DBA Data[Home] [Help]

APPS.FUN_WEBADI_PKG dependencies on FND_ID_FLEX_STRUCTURES

Line 725: Cursor C_Flex_Info(cp_chart_of_accounts_id In Fnd_Id_Flex_Structures.id_flex_num%type) Is

721: And fun_tca_pkg.get_le_id(hzp.party_id) = xfi.party_id
722: And xfi.legal_entity_id = led.legal_entity_id
723: And led.ledger_category_code = 'PRIMARY';
724:
725: Cursor C_Flex_Info(cp_chart_of_accounts_id In Fnd_Id_Flex_Structures.id_flex_num%type) Is
726: Select fa.application_short_name appl_short_name
727: From Fnd_Id_Flex_Structures fs, Fnd_Application fa
728: Where fs.application_id = fa.application_id
729: And id_flex_num = cp_chart_of_accounts_id

Line 727: From Fnd_Id_Flex_Structures fs, Fnd_Application fa

723: And led.ledger_category_code = 'PRIMARY';
724:
725: Cursor C_Flex_Info(cp_chart_of_accounts_id In Fnd_Id_Flex_Structures.id_flex_num%type) Is
726: Select fa.application_short_name appl_short_name
727: From Fnd_Id_Flex_Structures fs, Fnd_Application fa
728: Where fs.application_id = fa.application_id
729: And id_flex_num = cp_chart_of_accounts_id
730: And id_flex_code = 'GL#';
731:

Line 752: l_init_chart_of_accounts Fnd_Id_Flex_Structures.id_flex_num%type;

748: l_trx_insert Varchar2(1);
749: l_dup_reci_count Number;
750: l_to_le_name Fun_Interface_Headers.to_le_name%type;
751: l_init_dist_line_insert Varchar2(1);
752: l_init_chart_of_accounts Fnd_Id_Flex_Structures.id_flex_num%type;
753: l_reci_chart_of_accounts Fnd_Id_Flex_Structures.id_flex_num%type;
754: l_appl_short_name Fnd_Application.application_short_name%type;
755: l_reci_dist_line_insert Varchar2(1);
756: l_data varchar2(2000);

Line 753: l_reci_chart_of_accounts Fnd_Id_Flex_Structures.id_flex_num%type;

749: l_dup_reci_count Number;
750: l_to_le_name Fun_Interface_Headers.to_le_name%type;
751: l_init_dist_line_insert Varchar2(1);
752: l_init_chart_of_accounts Fnd_Id_Flex_Structures.id_flex_num%type;
753: l_reci_chart_of_accounts Fnd_Id_Flex_Structures.id_flex_num%type;
754: l_appl_short_name Fnd_Application.application_short_name%type;
755: l_reci_dist_line_insert Varchar2(1);
756: l_data varchar2(2000);
757: l_dr_sum Fun_Interface_Dist_Lines.amount_dr%type;