Tuesday, 14 October 2014

Custom Table Process

DECLARE

 P_ID1   number;
 P_ID2   number;
--l_flex_value_id      number ;
v_enabled_flag       varchar2(1);
BEGIN

 P_ID1    := #DISPOSITION_ID1#;
 P_ID2    := #DISPOSITION_ID2#;

insert into apps.(Custom_Table) select * from (Base_Tabe) where flex_value_id=P_ID1;

begin
   begin
     select enabled_flag
       into v_enabled_flag
       from fnd_flex_values
      where flex_value_id =P_ID1;
      Exception
        when no_data_found then
             v_enabled_flag := 'Y';
        when others then
              v_enabled_flag := 'Y';            
     end;
     if v_enabled_flag = 'N' then            
        fnd_flex_values_pkg.delete_row( X_FLEX_VALUE_ID                => P_ID1);
     end if;
end;

END;

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, BI Publisher, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete