DBA Data[Home] [Help]

APPS.FUN_WEBADI_PKG dependencies on FND_ID_FLEX_STRUCTURES

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

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

Line 728: From Fnd_Id_Flex_Structures fs, Fnd_Application fa

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

Line 753: l_init_chart_of_accounts Fnd_Id_Flex_Structures.id_flex_num%type;

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

Line 754: l_reci_chart_of_accounts Fnd_Id_Flex_Structures.id_flex_num%type;

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