APPS.GCS_TRANS_RE_DYNAMIC_PKG dependencies on GCS_TRANSLATION_GT

Line 386: 'INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(translate_rule_code, account_type_code, ' ||

382: END IF;
383:
384: IF p_group_by_flag = 'Y' THEN
385: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
386: 'INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(translate_rule_code, account_type_code, ' ||
387: 'line_item_id, company_cost_center_org_id, intercompany_id, financial_elem_id, ' ||
388: 'product_id, natural_account_id, channel_id, ' ||
389: 'project_id, customer_id, task_id, user_dim1_id, user_dim2_id, user_dim3_id, ' ||
390: 'user_dim4_id, user_dim5_id, user_dim6_id, user_dim7_id, user_dim8_id, ' ||

Line 470: INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(

466: 'AND ghr.update_flag = ''N'' ' || g_nl ||
467: 'AND ghr.standard_re_rate_flag = ''Y'' ' || g_nl ||
468: 'AND fb.line_item_id = p_hier_li_id ' || g_nl ||'');
469:
470: INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(
471: translate_rule_code, account_type_code, line_item_id,
472: company_cost_center_org_id, intercompany_id, financial_elem_id,
473: product_id, natural_account_id, channel_id, project_id,
474: customer_id, task_id, user_dim1_id, user_dim2_id, user_dim3_id,

Line 557: 'INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(translate_rule_code, account_type_code, ' ||

553: AND ghr.standard_re_rate_flag = 'Y' ;
554:
555: ELSE
556: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
557: 'INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(translate_rule_code, account_type_code, ' ||
558: 'line_item_id, company_cost_center_org_id, intercompany_id, financial_elem_id, ' ||
559: 'product_id, natural_account_id, channel_id, ' ||
560: 'project_id, customer_id, task_id, user_dim1_id, user_dim2_id, user_dim3_id, ' ||
561: 'user_dim4_id, user_dim5_id, user_dim6_id, user_dim7_id, user_dim8_id, ' ||

Line 640: INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(

636: 'AND ghr.update_flag = ''N'' ' || g_nl ||
637: 'AND ghr.standard_re_rate_flag = ''Y'' ' || g_nl ||
638: 'AND fb.line_item_id = p_hier_li_id ' || g_nl ||'');
639:
640: INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(
641: translate_rule_code, account_type_code, line_item_id,
642: company_cost_center_org_id, intercompany_id, financial_elem_id,
643: product_id, natural_account_id, channel_id, project_id,
644: customer_id, task_id, user_dim1_id, user_dim2_id, user_dim3_id,

Line 802: 'INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(translate_rule_code, account_type_code, ' ||

798: CLOSE get_object_id;
799:
800: IF p_group_by_flag = 'Y' THEN
801: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
802: 'INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(translate_rule_code, account_type_code, ' ||
803: 'line_item_id, company_cost_center_org_id, ' ||
804: 'intercompany_id, financial_elem_id, product_id, ' ||
805: 'natural_account_id, channel_id, project_id, customer_id, task_id, ' ||
806: 'user_dim1_id, user_dim2_id, user_dim3_id, user_dim4_id, user_dim5_id, ' ||

Line 901: INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(

897: 'AND ghr.line_item_id = fb.line_item_id' || g_nl ||
898: 'AND ghr.standard_re_rate_flag = ''Y'' ' || g_nl ||
899: 'AND ghr.update_flag = ''N''' || g_nl ||'');
900:
901: INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(
902: translate_rule_code, account_type_code, line_item_id,
903: company_cost_center_org_id, intercompany_id, financial_elem_id,
904: product_id, natural_account_id, channel_id, project_id,
905: customer_id, task_id, user_dim1_id, user_dim2_id, user_dim3_id,

Line 1001: 'INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(translate_rule_code, account_type_code, ' ||

997: AND ghr.update_flag = 'N' ;
998:
999: ELSE
1000: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
1001: 'INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(translate_rule_code, account_type_code, ' ||
1002: 'line_item_id, company_cost_center_org_id, ' ||
1003: 'intercompany_id, financial_elem_id, product_id, ' ||
1004: 'natural_account_id, channel_id, project_id, customer_id, task_id, ' ||
1005: 'user_dim1_id, user_dim2_id, user_dim3_id, user_dim4_id, user_dim5_id, ' ||

Line 1099: INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(

1095: 'AND ghr.line_item_id = fb.line_item_id' || g_nl ||
1096: 'AND ghr.standard_re_rate_flag = ''Y'' ' || g_nl ||
1097: 'AND ghr.update_flag = ''N''' || g_nl ||'');
1098:
1099: INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(
1100: translate_rule_code, account_type_code, line_item_id,
1101: company_cost_center_org_id, intercompany_id, financial_elem_id,
1102: product_id, natural_account_id, channel_id, project_id,
1103: customer_id, task_id, user_dim1_id, user_dim2_id, user_dim3_id,