APPS.GCS_TRANS_HRATES_DYNAMIC_PKG dependencies on GCS_TRANSLATION_GT

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

374: END IF;
375:
376: IF p_group_by_flag = 'Y' THEN
377: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
378: 'INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(translate_rule_code, account_type_code, ' ||
379: 'line_item_id, company_cost_center_org_id, intercompany_id, financial_elem_id, ' ||
380: 'product_id, natural_account_id, channel_id, ' ||
381: 'project_id, customer_id, task_id, user_dim1_id, user_dim2_id, user_dim3_id, ' ||
382: 'user_dim4_id, user_dim5_id, user_dim6_id, user_dim7_id, user_dim8_id, ' ||

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

456: 'AND ghr.cal_period_id (+) = ' || p_cal_period_id || g_nl ||
457: 'AND ghr.line_item_id (+) = fb.line_item_id' || g_nl ||
458: 'AND ghr.update_flag (+) = ''N'' ' || g_nl ||'');
459:
460: INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(
461: translate_rule_code, account_type_code, line_item_id,
462: company_cost_center_org_id, intercompany_id, financial_elem_id,
463: product_id, natural_account_id, channel_id, project_id,
464: customer_id, task_id, user_dim1_id, user_dim2_id, user_dim3_id,

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

548: AND ghr_retained.line_item_id = fb.line_item_id );
549:
550: ELSE
551: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
552: 'INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(translate_rule_code, account_type_code, ' ||
553: 'line_item_id, company_cost_center_org_id, intercompany_id, financial_elem_id, ' ||
554: 'product_id, natural_account_id, channel_id, ' ||
555: 'project_id, customer_id, task_id, user_dim1_id, user_dim2_id, user_dim3_id, ' ||
556: 'user_dim4_id, user_dim5_id, user_dim6_id, user_dim7_id, user_dim8_id, ' ||

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

629: 'AND ghr.cal_period_id (+) = ' || p_cal_period_id || g_nl ||
630: 'AND ghr.line_item_id (+) = fb.line_item_id' || g_nl ||
631: 'AND ghr.update_flag (+) = ''N'' ' || g_nl ||'');
632:
633: INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(
634: translate_rule_code, account_type_code, line_item_id,
635: company_cost_center_org_id, intercompany_id, financial_elem_id,
636: product_id, natural_account_id, channel_id, project_id,
637: customer_id, task_id, user_dim1_id, user_dim2_id, user_dim3_id,

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

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

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

892: 'AND ghr.cal_period_id (+)= ' || p_cal_period_id || g_nl ||
893: 'AND ghr.line_item_id (+)= fb.line_item_id' || g_nl ||
894: 'AND ghr.update_flag (+)= ''N''' || g_nl ||'');
895:
896: INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(
897: translate_rule_code, account_type_code, line_item_id,
898: company_cost_center_org_id, intercompany_id, financial_elem_id,
899: product_id, natural_account_id, channel_id, project_id,
900: 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_retained.line_item_id = fb.line_item_id );
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 1097: INSERT /*+ parallel (GCS_TRANSLATION_GT) */ INTO GCS_TRANSLATION_GT(

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