[Home] [Help]
2167: /*******************************************/
2168: /** Added by krsankar for AAD Perf Issue **/
2169: /*******************************************/
2170:
2171: INSERT INTO xla_aads_gt
2172: ( product_rule_code,
2173: event_class_code,
2174: event_type_code,
2175: line_definition_code,
2226: p_log_type_code => 'MERGE',
2227: p_encoded_message =>'Number of Rows inserted into aads_gt from xla_aad_line_defn_assgns is :'||l_num_rows,
2228: p_component_code => 'merge_aads');
2229:
2230: INSERT INTO xla_aads_gt
2231: ( product_rule_code,
2232: event_class_code,
2233: accounting_attribute_code,
2234: source_code,
2286: p_log_type_code => 'MERGE',
2287: p_encoded_message =>'Number of Rows inserted into aads_gt from xla_aad_hdr_acct_attrs is :'||l_num_rows,
2288: p_component_code => 'merge_aads');
2289:
2290: INSERT INTO xla_aads_gt
2291: ( product_rule_code,
2292: event_class_code,
2293: event_type_code,
2294: analytical_criterion_code,
2725: /*************************************************/
2726: /**** Added by krsankar for Performance changes **/
2727: /*************************************************/
2728:
2729: INSERT INTO xla_aads_gt
2730: ( event_class_code,
2731: event_type_code,
2732: line_definition_code,
2733: table_name
2780: p_log_type_code => 'MERGE',
2781: p_encoded_message =>'Number of Rows inserted into aads_gt from xla_line_definitions_b is :'||l_num_rows,
2782: p_component_code => 'merge_journal_line_defns');
2783:
2784: INSERT INTO xla_aads_gt
2785: ( event_class_code,
2786: event_type_code,
2787: line_definition_code,
2788: accounting_line_code,
2841: p_log_type_code => 'MERGE',
2842: p_encoded_message =>'Number of Rows inserted into aads_gt from xla_line_defn_jlt_assgns is :'||l_num_rows,
2843: p_component_code => 'merge_journal_line_defns');
2844:
2845: INSERT INTO xla_aads_gt
2846: ( event_class_code,
2847: event_type_code,
2848: line_definition_code,
2849: accounting_line_code,
2907: p_log_type_code => 'MERGE',
2908: p_encoded_message =>'Number of Rows inserted into aads_gt from xla_line_defn_adr_assgns is :'||l_num_rows,
2909: p_component_code => 'merge_journal_line_defns');
2910:
2911: INSERT INTO xla_aads_gt
2912: ( event_class_code,
2913: event_type_code,
2914: line_definition_code,
2915: accounting_line_code,
2974: p_log_type_code => 'MERGE',
2975: p_encoded_message =>'Number of Rows inserted into aads_gt from xla_line_defn_ac_assgns is :'||l_num_rows,
2976: p_component_code => 'merge_journal_line_defns');
2977:
2978: INSERT INTO xla_aads_gt
2979: ( event_class_code
2980: ,event_type_code
2981: ,line_definition_code
2982: ,accounting_line_code
3045: p_log_type_code => 'MERGE',
3046: p_encoded_message =>'Number of Rows inserted into aads_gt from xla_mpa_jlt_assgns is :'||l_num_rows,
3047: p_component_code => 'merge_journal_line_defns');
3048:
3049: INSERT INTO xla_aads_gt
3050: ( event_class_code
3051: ,event_type_code
3052: ,line_definition_code
3053: ,accounting_line_code
3125: p_log_type_code => 'MERGE',
3126: p_encoded_message =>'Number of Rows inserted into aads_gt from xla_mpa_header_ac_assgns is :'||l_num_rows,
3127: p_component_code => 'merge_journal_line_defns');
3128:
3129: INSERT INTO xla_aads_gt
3130: (
3131: event_class_code
3132: ,event_type_code
3133: ,line_definition_code
3215: p_log_type_code => 'MERGE',
3216: p_encoded_message =>'Number of Rows inserted into aads_gt from xla_mpa_jlt_adr_assgns is :'||l_num_rows,
3217: p_component_code => 'merge_journal_line_defns');
3218:
3219: INSERT INTO xla_aads_gt
3220: ( event_class_code
3221: ,event_type_code
3222: ,line_definition_code
3223: ,accounting_line_code
3888: /*************************************************/
3889: /**** Added by krsankar for Performance changes **/
3890: /*************************************************/
3891:
3892: INSERT INTO xla_aads_gt
3893: ( entity_code,
3894: event_class_code,
3895: accounting_line_code,
3896: accounting_class_code,
3947: p_log_type_code => 'MERGE',
3948: p_encoded_message => 'Number of Rows inserted into aads_gt from xla_acct_line_types_b is :'||l_num_rows,
3949: p_component_code => 'merge_journal_line_types');
3950:
3951: INSERT INTO xla_aads_gt
3952: ( event_class_code
3953: ,accounting_line_code
3954: ,accounting_attribute_code
3955: ,source_code
4001: p_log_type_code => 'MERGE',
4002: p_encoded_message => 'Number of Rows inserted into aads_gt from xla_jlt_acct_attrs is :'||l_num_rows,
4003: p_component_code => 'merge_journal_line_types');
4004:
4005: INSERT INTO xla_aads_gt
4006: ( entity_code
4007: ,event_class_code
4008: ,accounting_line_code
4009: ,source_code
4344: /*************************************************/
4345: /**** Added by krsankar for Performance changes **/
4346: /*************************************************/
4347:
4348: INSERT INTO xla_aads_gt
4349: (description_code,
4350: table_name
4351: )
4352: select description_code,
4389: p_log_type_code => 'MERGE',
4390: p_encoded_message => 'Number of Rows inserted into aads_gt from xla_descriptions_b is :'||l_num_rows,
4391: p_component_code => 'merge_descriptions');
4392:
4393: INSERT INTO xla_aads_gt
4394: ( description_code,
4395: table_name
4396: )
4397: select description_code,
4433: p_log_type_code => 'MERGE',
4434: p_encoded_message => 'Number of Rows inserted into aads_gt from xla_desc_priorities is :'||l_num_rows,
4435: p_component_code => 'merge_descriptions');
4436:
4437: INSERT INTO xla_aads_gt
4438: ( source_code,
4439: table_name
4440: )
4441: SELECT desc_details.source_code,
4906: /*************************************************/
4907: /**** Added by krsankar for Performance changes **/
4908: /*************************************************/
4909:
4910: INSERT INTO xla_aads_gt
4911: ( analytical_criterion_code,
4912: table_name
4913: )
4914: select analytical_criterion_code,
4952: p_log_type_code => 'MERGE',
4953: p_encoded_message => 'Number of Rows inserted into aads_gt from xla_analytical_hdrs_b is :'||l_num_rows,
4954: p_component_code => 'merge_analytical_criteria');
4955:
4956: INSERT INTO xla_aads_gt
4957: ( analytical_criterion_code,
4958: analytical_detail_code,
4959: table_name
4960: )
5001: p_log_type_code => 'MERGE',
5002: p_encoded_message => 'Number of Rows inserted into aads_gt from xla_analytical_dtls_b is :'||l_num_rows,
5003: p_component_code => 'merge_analytical_criteria');
5004:
5005: INSERT INTO xla_aads_gt
5006: ( analytical_criterion_code,
5007: analytical_detail_code,
5008: entity_code,
5009: event_class_code,
5522: /*************************************************/
5523: /**** Added by krsankar for Performance changes **/
5524: /*************************************************/
5525:
5526: INSERT INTO xla_aads_gt
5527: ( segment_rule_code,
5528: table_name
5529: )
5530: select segment_rule_code,
5570: p_log_type_code => 'MERGE',
5571: p_encoded_message => 'Number of Rows inserted into aads_gt from xla_seg_rule_details is :'||l_num_rows,
5572: p_component_code => 'merge_adrs');
5573:
5574: INSERT INTO xla_aads_gt
5575: ( segment_rule_code,
5576: table_name
5577: )
5578: select segment_rule_code,