DBA Data[Home] [Help]

APPS.XLA_TB_BALANCE_PKG dependencies on XLA_TB_DEFN_DETAILS

Line 1034: INSERT INTO xla_tb_defn_details

1030: --
1031: -- As record elements (e.g. p_balance_tbl(i).balance_date) is not allowed
1032: -- in forall statements, reassgin parameters to local variables
1033: --
1034: INSERT INTO xla_tb_defn_details
1035: (definition_detail_id
1036: ,object_version_number
1037: ,definition_code
1038: ,flexfield_segment_code

Line 1051: xla_tb_defn_details_s.NEXTVAL

1047: ,last_update_date
1048: ,last_updated_by
1049: ,last_update_login)
1050: SELECT
1051: xla_tb_defn_details_s.NEXTVAL
1052: ,C_OVN
1053: ,p_definition_code
1054: ,NULL -- flexfield segment code
1055: ,NULL -- segment value from

Line 1305: MERGE INTO xla_tb_defn_details dt

1301: l_last_update_date := sysdate;
1302: l_last_updated_by := xla_environment_pkg.g_usr_id;
1303: l_last_update_login := xla_environment_pkg.g_login_id;
1304:
1305: MERGE INTO xla_tb_defn_details dt
1306: USING (SELECT code_combination_id
1307: ,balance_date
1308: ,balance_amount
1309: FROM xla_tb_balances_gt

Line 1337: VALUES (xla_tb_defn_details_s.NEXTVAL

1333: ,created_by
1334: ,last_update_date
1335: ,last_updated_by
1336: ,last_update_login)
1337: VALUES (xla_tb_defn_details_s.NEXTVAL
1338: ,C_OVN
1339: ,p_definition_code
1340: ,NULL
1341: ,NULL

Line 2179: ,xla_tb_defn_details xdd

2175: FROM
2176: xla_ae_headers PARTITION (AP) xah
2177: ,ap_liability_balance alb
2178: ,xla_event_types_b xet
2179: ,xla_tb_defn_details xdd
2180: ,xla_tb_definitions_b xtd
2181: ,xla_tb_defn_je_sources xjs
2182: ,xla_subledgers xsu
2183: ,xla_transaction_entities_upg PARTITION (AP) xteu

Line 2524: -- Insert rows into xla_tb_defn_details

2520: ,p_module => l_log_module);
2521: END IF;
2522:
2523: --
2524: -- Insert rows into xla_tb_defn_details
2525: --
2526: -- Insert the Defn Details and Seg Ranges for those Definitions missing from TB Set Up Tables
2527: FORALL i IN l_array_defn_code.first .. l_array_defn_code.last
2528: INSERT ALL INTO xla_tb_defn_details

Line 2528: INSERT ALL INTO xla_tb_defn_details

2524: -- Insert rows into xla_tb_defn_details
2525: --
2526: -- Insert the Defn Details and Seg Ranges for those Definitions missing from TB Set Up Tables
2527: FORALL i IN l_array_defn_code.first .. l_array_defn_code.last
2528: INSERT ALL INTO xla_tb_defn_details
2529: (definition_detail_id
2530: ,object_version_number
2531: ,definition_code
2532: ,flexfield_segment_code

Line 2544: VALUES (xla_tb_defn_details_s.NEXTVAL

2540: ,created_by
2541: ,last_update_date
2542: ,last_updated_by
2543: ,last_update_login)
2544: VALUES (xla_tb_defn_details_s.NEXTVAL
2545: ,1
2546: ,definition_code
2547: ,NULL -- flexfield segment code
2548: ,NULL -- segment value from