DBA Data[Home] [Help]

APPS.PA_ONLINE_COPY_EXP dependencies on PA_UTILS

Line 32: org_id := pa_utils.GetEmpOrgId ( G_inc_by_person_id, X_ei_date );

28: X_status := NULL;
29: org_id := NULL;
30: dummy := NULL;
31:
32: org_id := pa_utils.GetEmpOrgId ( G_inc_by_person_id, X_ei_date );
33:
34: IF ( org_id IS NULL ) THEN
35: X_status := 'PA_EX_NO_ORG_ASSGN';
36: RETURN;

Line 45: dummy := pa_utils.GetEmpJobId ( G_inc_by_person_id, X_ei_date );

41: END IF;
42: END IF;
43:
44: dummy := NULL;
45: dummy := pa_utils.GetEmpJobId ( G_inc_by_person_id, X_ei_date );
46:
47: x_job_id := dummy;
48:
49: IF ( dummy IS NULL ) THEN

Line 749: ei_denorm.raw_cost_rate_1 := pa_utils.GetExpTypeCostRate( ei_denorm.expenditure_type

745: ei_denorm.expenditure_comment_1 := NULL;
746: ei_denorm.job_id_1 := NULL;
747: ELSE
748: IF ( G_exp_class_code = 'OE' ) THEN
749: ei_denorm.raw_cost_rate_1 := pa_utils.GetExpTypeCostRate( ei_denorm.expenditure_type
750: , ei_denorm.expenditure_item_date_1 );
751: ei_denorm.raw_cost_1 := PA_CURRENCY.ROUND_CURRENCY_AMT(
752: ( ei_denorm.quantity_1 * ei_denorm.raw_cost_rate_1 ) );
753: ELSE

Line 820: ei_denorm.raw_cost_rate_2 := pa_utils.GetExpTypeCostRate( ei_denorm.expenditure_type

816: ei_denorm.expenditure_comment_2 := NULL;
817: ei_denorm.job_id_2 := NULL;
818: ELSE
819: IF ( G_exp_class_code = 'OE' ) THEN
820: ei_denorm.raw_cost_rate_2 := pa_utils.GetExpTypeCostRate( ei_denorm.expenditure_type
821: , ei_denorm.expenditure_item_date_2 );
822: ei_denorm.raw_cost_2 := PA_CURRENCY.ROUND_CURRENCY_AMT(
823: ( ei_denorm.quantity_2 * ei_denorm.raw_cost_rate_2 ) );
824: ELSE

Line 889: ei_denorm.raw_cost_rate_3 := pa_utils.GetExpTypeCostRate( ei_denorm.expenditure_type

885: ei_denorm.expenditure_comment_3 := NULL;
886: ei_denorm.job_id_3 := NULL;
887: ELSE
888: IF ( G_exp_class_code = 'OE' ) THEN
889: ei_denorm.raw_cost_rate_3 := pa_utils.GetExpTypeCostRate( ei_denorm.expenditure_type
890: , ei_denorm.expenditure_item_date_3 );
891: ei_denorm.raw_cost_3 := PA_CURRENCY.ROUND_CURRENCY_AMT(
892: ( ei_denorm.quantity_3 * ei_denorm.raw_cost_rate_3 ) );
893: ELSE

Line 959: ei_denorm.raw_cost_rate_4 := pa_utils.GetExpTypeCostRate( ei_denorm.expenditure_type

955: ei_denorm.expenditure_comment_4 := NULL;
956: ei_denorm.job_id_4 := NULL;
957: ELSE
958: IF ( G_exp_class_code = 'OE' ) THEN
959: ei_denorm.raw_cost_rate_4 := pa_utils.GetExpTypeCostRate( ei_denorm.expenditure_type
960: , ei_denorm.expenditure_item_date_4 );
961: ei_denorm.raw_cost_4 := PA_CURRENCY.ROUND_CURRENCY_AMT(
962: ( ei_denorm.quantity_4 * ei_denorm.raw_cost_rate_4 ) );
963: ELSE

Line 1029: ei_denorm.raw_cost_rate_5 := pa_utils.GetExpTypeCostRate( ei_denorm.expenditure_type

1025: ei_denorm.expenditure_comment_5 := NULL;
1026: ei_denorm.job_id_5 := NULL;
1027: ELSE
1028: IF ( G_exp_class_code = 'OE' ) THEN
1029: ei_denorm.raw_cost_rate_5 := pa_utils.GetExpTypeCostRate( ei_denorm.expenditure_type
1030: , ei_denorm.expenditure_item_date_5 );
1031: ei_denorm.raw_cost_5 := PA_CURRENCY.ROUND_CURRENCY_AMT(
1032: ( ei_denorm.quantity_5 * ei_denorm.raw_cost_rate_5 ) );
1033: ELSE

Line 1099: ei_denorm.raw_cost_rate_6 := pa_utils.GetExpTypeCostRate( ei_denorm.expenditure_type

1095: ei_denorm.expenditure_comment_6 := NULL;
1096: ei_denorm.job_id_6 := NULL;
1097: ELSE
1098: IF ( G_exp_class_code = 'OE' ) THEN
1099: ei_denorm.raw_cost_rate_6 := pa_utils.GetExpTypeCostRate( ei_denorm.expenditure_type
1100: , ei_denorm.expenditure_item_date_6 );
1101: ei_denorm.raw_cost_6 := PA_CURRENCY.ROUND_CURRENCY_AMT(
1102: ( ei_denorm.quantity_6 * ei_denorm.raw_cost_rate_6 ) );
1103: ELSE

Line 1169: ei_denorm.raw_cost_rate_7 := pa_utils.GetExpTypeCostRate( ei_denorm.expenditure_type

1165: ei_denorm.expenditure_comment_7 := NULL;
1166: ei_denorm.job_id_7 := NULL;
1167: ELSE
1168: IF ( G_exp_class_code = 'OE' ) THEN
1169: ei_denorm.raw_cost_rate_7 := pa_utils.GetExpTypeCostRate( ei_denorm.expenditure_type
1170: , ei_denorm.expenditure_item_date_7 );
1171: ei_denorm.raw_cost_7 := PA_CURRENCY.ROUND_CURRENCY_AMT(
1172: ( ei_denorm.quantity_7 * ei_denorm.raw_cost_rate_7 ) );
1173: ELSE

Line 1469: IF pa_utils.CheckExpTypeActive(x_expenditure_type,x_expenditure_item_date) = FALSE THEN

1465: l_temp_outcome := temp_outcome;
1466:
1467: temp_outcome := NULL;
1468:
1469: IF pa_utils.CheckExpTypeActive(x_expenditure_type,x_expenditure_item_date) = FALSE THEN
1470: temp_outcome := 'NOT ACTIVE EXP TYPE';
1471: RETURN;
1472: END IF;
1473:

Line 1474: IF pa_utils2.CheckSysLinkFuncActive(x_expenditure_type, x_expenditure_item_date, x_sys_link_func) = FALSE THEN

1470: temp_outcome := 'NOT ACTIVE EXP TYPE';
1471: RETURN;
1472: END IF;
1473:
1474: IF pa_utils2.CheckSysLinkFuncActive(x_expenditure_type, x_expenditure_item_date, x_sys_link_func) = FALSE THEN
1475: temp_outcome := 'NOT ACTIVE SYS LINK FUNC';
1476: RETURN;
1477: END IF;
1478: