eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FORECAST_HDR_PKG dependencies on PA_PLSQL_DATATYPES

Line 17: l_forecast_item_id PA_PLSQL_DATATYPES.IdTabTyp;

13: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
14: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
15: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
16: IS
17: l_forecast_item_id PA_PLSQL_DATATYPES.IdTabTyp;
18: l_forecast_item_type PA_PLSQL_DATATYPES.Char30TabTyp;
19: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;
20: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
21: l_expenditure_organization_id PA_PLSQL_DATATYPES.IdTabTyp;

Line 18: l_forecast_item_type PA_PLSQL_DATATYPES.Char30TabTyp;

14: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
15: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
16: IS
17: l_forecast_item_id PA_PLSQL_DATATYPES.IdTabTyp;
18: l_forecast_item_type PA_PLSQL_DATATYPES.Char30TabTyp;
19: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;
20: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
21: l_expenditure_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
22: l_project_organization_id PA_PLSQL_DATATYPES.IdTabTyp;

Line 19: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;

15: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
16: IS
17: l_forecast_item_id PA_PLSQL_DATATYPES.IdTabTyp;
18: l_forecast_item_type PA_PLSQL_DATATYPES.Char30TabTyp;
19: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;
20: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
21: l_expenditure_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
22: l_project_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
23: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;

Line 20: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;

16: IS
17: l_forecast_item_id PA_PLSQL_DATATYPES.IdTabTyp;
18: l_forecast_item_type PA_PLSQL_DATATYPES.Char30TabTyp;
19: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;
20: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
21: l_expenditure_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
22: l_project_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
23: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
24: l_project_type_class PA_PLSQL_DATATYPES.Char30TabTyp;

Line 21: l_expenditure_organization_id PA_PLSQL_DATATYPES.IdTabTyp;

17: l_forecast_item_id PA_PLSQL_DATATYPES.IdTabTyp;
18: l_forecast_item_type PA_PLSQL_DATATYPES.Char30TabTyp;
19: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;
20: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
21: l_expenditure_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
22: l_project_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
23: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
24: l_project_type_class PA_PLSQL_DATATYPES.Char30TabTyp;
25: l_person_id PA_PLSQL_DATATYPES.IdTabTyp;

Line 22: l_project_organization_id PA_PLSQL_DATATYPES.IdTabTyp;

18: l_forecast_item_type PA_PLSQL_DATATYPES.Char30TabTyp;
19: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;
20: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
21: l_expenditure_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
22: l_project_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
23: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
24: l_project_type_class PA_PLSQL_DATATYPES.Char30TabTyp;
25: l_person_id PA_PLSQL_DATATYPES.IdTabTyp;
26: l_resource_id PA_PLSQL_DATATYPES.IdTabTyp;

Line 23: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;

19: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;
20: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
21: l_expenditure_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
22: l_project_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
23: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
24: l_project_type_class PA_PLSQL_DATATYPES.Char30TabTyp;
25: l_person_id PA_PLSQL_DATATYPES.IdTabTyp;
26: l_resource_id PA_PLSQL_DATATYPES.IdTabTyp;
27: l_borrowed_flag PA_PLSQL_DATATYPES.Char1TabTyp;

Line 24: l_project_type_class PA_PLSQL_DATATYPES.Char30TabTyp;

20: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
21: l_expenditure_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
22: l_project_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
23: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
24: l_project_type_class PA_PLSQL_DATATYPES.Char30TabTyp;
25: l_person_id PA_PLSQL_DATATYPES.IdTabTyp;
26: l_resource_id PA_PLSQL_DATATYPES.IdTabTyp;
27: l_borrowed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
28: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;

Line 25: l_person_id PA_PLSQL_DATATYPES.IdTabTyp;

21: l_expenditure_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
22: l_project_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
23: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
24: l_project_type_class PA_PLSQL_DATATYPES.Char30TabTyp;
25: l_person_id PA_PLSQL_DATATYPES.IdTabTyp;
26: l_resource_id PA_PLSQL_DATATYPES.IdTabTyp;
27: l_borrowed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
28: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
29: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;

Line 26: l_resource_id PA_PLSQL_DATATYPES.IdTabTyp;

22: l_project_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
23: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
24: l_project_type_class PA_PLSQL_DATATYPES.Char30TabTyp;
25: l_person_id PA_PLSQL_DATATYPES.IdTabTyp;
26: l_resource_id PA_PLSQL_DATATYPES.IdTabTyp;
27: l_borrowed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
28: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
29: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;
30: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;

Line 27: l_borrowed_flag PA_PLSQL_DATATYPES.Char1TabTyp;

23: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
24: l_project_type_class PA_PLSQL_DATATYPES.Char30TabTyp;
25: l_person_id PA_PLSQL_DATATYPES.IdTabTyp;
26: l_resource_id PA_PLSQL_DATATYPES.IdTabTyp;
27: l_borrowed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
28: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
29: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;
30: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;
31: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;

Line 28: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;

24: l_project_type_class PA_PLSQL_DATATYPES.Char30TabTyp;
25: l_person_id PA_PLSQL_DATATYPES.IdTabTyp;
26: l_resource_id PA_PLSQL_DATATYPES.IdTabTyp;
27: l_borrowed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
28: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
29: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;
30: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;
31: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;
32: l_pvdr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;

Line 29: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;

25: l_person_id PA_PLSQL_DATATYPES.IdTabTyp;
26: l_resource_id PA_PLSQL_DATATYPES.IdTabTyp;
27: l_borrowed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
28: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
29: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;
30: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;
31: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;
32: l_pvdr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;
33: l_pvdr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;

Line 30: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;

26: l_resource_id PA_PLSQL_DATATYPES.IdTabTyp;
27: l_borrowed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
28: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
29: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;
30: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;
31: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;
32: l_pvdr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;
33: l_pvdr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
34: l_pvdr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;

Line 31: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;

27: l_borrowed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
28: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
29: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;
30: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;
31: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;
32: l_pvdr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;
33: l_pvdr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
34: l_pvdr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
35: l_rcvr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;

Line 32: l_pvdr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;

28: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
29: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;
30: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;
31: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;
32: l_pvdr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;
33: l_pvdr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
34: l_pvdr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
35: l_rcvr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;
36: l_rcvr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;

Line 33: l_pvdr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;

29: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;
30: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;
31: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;
32: l_pvdr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;
33: l_pvdr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
34: l_pvdr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
35: l_rcvr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;
36: l_rcvr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
37: l_rcvr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;

Line 34: l_pvdr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;

30: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;
31: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;
32: l_pvdr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;
33: l_pvdr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
34: l_pvdr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
35: l_rcvr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;
36: l_rcvr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
37: l_rcvr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
38: l_global_exp_period_end_date PA_PLSQL_DATATYPES.DateTabTyp;

Line 35: l_rcvr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;

31: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;
32: l_pvdr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;
33: l_pvdr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
34: l_pvdr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
35: l_rcvr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;
36: l_rcvr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
37: l_rcvr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
38: l_global_exp_period_end_date PA_PLSQL_DATATYPES.DateTabTyp;
39: l_expenditure_type PA_PLSQL_DATATYPES.Char30TabTyp;

Line 36: l_rcvr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;

32: l_pvdr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;
33: l_pvdr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
34: l_pvdr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
35: l_rcvr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;
36: l_rcvr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
37: l_rcvr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
38: l_global_exp_period_end_date PA_PLSQL_DATATYPES.DateTabTyp;
39: l_expenditure_type PA_PLSQL_DATATYPES.Char30TabTyp;
40: l_expenditure_type_class PA_PLSQL_DATATYPES.Char30TabTyp;

Line 37: l_rcvr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;

33: l_pvdr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
34: l_pvdr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
35: l_rcvr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;
36: l_rcvr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
37: l_rcvr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
38: l_global_exp_period_end_date PA_PLSQL_DATATYPES.DateTabTyp;
39: l_expenditure_type PA_PLSQL_DATATYPES.Char30TabTyp;
40: l_expenditure_type_class PA_PLSQL_DATATYPES.Char30TabTyp;
41: l_cost_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 38: l_global_exp_period_end_date PA_PLSQL_DATATYPES.DateTabTyp;

34: l_pvdr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
35: l_rcvr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;
36: l_rcvr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
37: l_rcvr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
38: l_global_exp_period_end_date PA_PLSQL_DATATYPES.DateTabTyp;
39: l_expenditure_type PA_PLSQL_DATATYPES.Char30TabTyp;
40: l_expenditure_type_class PA_PLSQL_DATATYPES.Char30TabTyp;
41: l_cost_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
42: l_rev_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 39: l_expenditure_type PA_PLSQL_DATATYPES.Char30TabTyp;

35: l_rcvr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;
36: l_rcvr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
37: l_rcvr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
38: l_global_exp_period_end_date PA_PLSQL_DATATYPES.DateTabTyp;
39: l_expenditure_type PA_PLSQL_DATATYPES.Char30TabTyp;
40: l_expenditure_type_class PA_PLSQL_DATATYPES.Char30TabTyp;
41: l_cost_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
42: l_rev_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
43: l_tp_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 40: l_expenditure_type_class PA_PLSQL_DATATYPES.Char30TabTyp;

36: l_rcvr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
37: l_rcvr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
38: l_global_exp_period_end_date PA_PLSQL_DATATYPES.DateTabTyp;
39: l_expenditure_type PA_PLSQL_DATATYPES.Char30TabTyp;
40: l_expenditure_type_class PA_PLSQL_DATATYPES.Char30TabTyp;
41: l_cost_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
42: l_rev_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
43: l_tp_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
44: l_burden_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 41: l_cost_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;

37: l_rcvr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
38: l_global_exp_period_end_date PA_PLSQL_DATATYPES.DateTabTyp;
39: l_expenditure_type PA_PLSQL_DATATYPES.Char30TabTyp;
40: l_expenditure_type_class PA_PLSQL_DATATYPES.Char30TabTyp;
41: l_cost_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
42: l_rev_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
43: l_tp_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
44: l_burden_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
45: l_other_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 42: l_rev_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;

38: l_global_exp_period_end_date PA_PLSQL_DATATYPES.DateTabTyp;
39: l_expenditure_type PA_PLSQL_DATATYPES.Char30TabTyp;
40: l_expenditure_type_class PA_PLSQL_DATATYPES.Char30TabTyp;
41: l_cost_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
42: l_rev_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
43: l_tp_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
44: l_burden_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
45: l_other_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
46: l_delete_flag PA_PLSQL_DATATYPES.Char1TabTyp;

Line 43: l_tp_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;

39: l_expenditure_type PA_PLSQL_DATATYPES.Char30TabTyp;
40: l_expenditure_type_class PA_PLSQL_DATATYPES.Char30TabTyp;
41: l_cost_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
42: l_rev_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
43: l_tp_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
44: l_burden_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
45: l_other_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
46: l_delete_flag PA_PLSQL_DATATYPES.Char1TabTyp;
47: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;

Line 44: l_burden_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;

40: l_expenditure_type_class PA_PLSQL_DATATYPES.Char30TabTyp;
41: l_cost_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
42: l_rev_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
43: l_tp_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
44: l_burden_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
45: l_other_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
46: l_delete_flag PA_PLSQL_DATATYPES.Char1TabTyp;
47: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;
48: l_error_flag PA_PLSQL_DATATYPES.Char1TabTyp;

Line 45: l_other_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;

41: l_cost_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
42: l_rev_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
43: l_tp_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
44: l_burden_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
45: l_other_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
46: l_delete_flag PA_PLSQL_DATATYPES.Char1TabTyp;
47: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;
48: l_error_flag PA_PLSQL_DATATYPES.Char1TabTyp;
49: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;

Line 46: l_delete_flag PA_PLSQL_DATATYPES.Char1TabTyp;

42: l_rev_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
43: l_tp_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
44: l_burden_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
45: l_other_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
46: l_delete_flag PA_PLSQL_DATATYPES.Char1TabTyp;
47: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;
48: l_error_flag PA_PLSQL_DATATYPES.Char1TabTyp;
49: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;
50: l_TP_AMOUNT_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;

Line 47: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;

43: l_tp_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
44: l_burden_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
45: l_other_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
46: l_delete_flag PA_PLSQL_DATATYPES.Char1TabTyp;
47: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;
48: l_error_flag PA_PLSQL_DATATYPES.Char1TabTyp;
49: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;
50: l_TP_AMOUNT_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
51: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;

Line 48: l_error_flag PA_PLSQL_DATATYPES.Char1TabTyp;

44: l_burden_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
45: l_other_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
46: l_delete_flag PA_PLSQL_DATATYPES.Char1TabTyp;
47: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;
48: l_error_flag PA_PLSQL_DATATYPES.Char1TabTyp;
49: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;
50: l_TP_AMOUNT_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
51: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
52: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;

Line 49: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;

45: l_other_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
46: l_delete_flag PA_PLSQL_DATATYPES.Char1TabTyp;
47: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;
48: l_error_flag PA_PLSQL_DATATYPES.Char1TabTyp;
49: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;
50: l_TP_AMOUNT_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
51: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
52: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;
53: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;

Line 50: l_TP_AMOUNT_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;

46: l_delete_flag PA_PLSQL_DATATYPES.Char1TabTyp;
47: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;
48: l_error_flag PA_PLSQL_DATATYPES.Char1TabTyp;
49: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;
50: l_TP_AMOUNT_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
51: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
52: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;
53: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;
54: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;

Line 51: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;

47: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;
48: l_error_flag PA_PLSQL_DATATYPES.Char1TabTyp;
49: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;
50: l_TP_AMOUNT_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
51: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
52: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;
53: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;
54: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
55: l_asgmt_sys_status_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 52: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;

48: l_error_flag PA_PLSQL_DATATYPES.Char1TabTyp;
49: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;
50: l_TP_AMOUNT_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
51: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
52: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;
53: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;
54: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
55: l_asgmt_sys_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
56: l_capacity_quantity PA_PLSQL_DATATYPES.NumTabTyp;

Line 53: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;

49: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;
50: l_TP_AMOUNT_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
51: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
52: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;
53: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;
54: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
55: l_asgmt_sys_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
56: l_capacity_quantity PA_PLSQL_DATATYPES.NumTabTyp;
57: l_overcommitment_quantity PA_PLSQL_DATATYPES.NumTabTyp;

Line 54: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;

50: l_TP_AMOUNT_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
51: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
52: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;
53: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;
54: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
55: l_asgmt_sys_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
56: l_capacity_quantity PA_PLSQL_DATATYPES.NumTabTyp;
57: l_overcommitment_quantity PA_PLSQL_DATATYPES.NumTabTyp;
58: l_availability_quantity PA_PLSQL_DATATYPES.NumTabTyp;

Line 55: l_asgmt_sys_status_code PA_PLSQL_DATATYPES.Char30TabTyp;

51: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
52: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;
53: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;
54: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
55: l_asgmt_sys_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
56: l_capacity_quantity PA_PLSQL_DATATYPES.NumTabTyp;
57: l_overcommitment_quantity PA_PLSQL_DATATYPES.NumTabTyp;
58: l_availability_quantity PA_PLSQL_DATATYPES.NumTabTyp;
59: l_overcommitment_flag PA_PLSQL_DATATYPES.Char1TabTyp;

Line 56: l_capacity_quantity PA_PLSQL_DATATYPES.NumTabTyp;

52: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;
53: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;
54: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
55: l_asgmt_sys_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
56: l_capacity_quantity PA_PLSQL_DATATYPES.NumTabTyp;
57: l_overcommitment_quantity PA_PLSQL_DATATYPES.NumTabTyp;
58: l_availability_quantity PA_PLSQL_DATATYPES.NumTabTyp;
59: l_overcommitment_flag PA_PLSQL_DATATYPES.Char1TabTyp;
60: l_availability_flag PA_PLSQL_DATATYPES.Char1TabTyp;

Line 57: l_overcommitment_quantity PA_PLSQL_DATATYPES.NumTabTyp;

53: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;
54: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
55: l_asgmt_sys_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
56: l_capacity_quantity PA_PLSQL_DATATYPES.NumTabTyp;
57: l_overcommitment_quantity PA_PLSQL_DATATYPES.NumTabTyp;
58: l_availability_quantity PA_PLSQL_DATATYPES.NumTabTyp;
59: l_overcommitment_flag PA_PLSQL_DATATYPES.Char1TabTyp;
60: l_availability_flag PA_PLSQL_DATATYPES.Char1TabTyp;
61:

Line 58: l_availability_quantity PA_PLSQL_DATATYPES.NumTabTyp;

54: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
55: l_asgmt_sys_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
56: l_capacity_quantity PA_PLSQL_DATATYPES.NumTabTyp;
57: l_overcommitment_quantity PA_PLSQL_DATATYPES.NumTabTyp;
58: l_availability_quantity PA_PLSQL_DATATYPES.NumTabTyp;
59: l_overcommitment_flag PA_PLSQL_DATATYPES.Char1TabTyp;
60: l_availability_flag PA_PLSQL_DATATYPES.Char1TabTyp;
61:
62: l_fi_rejected EXCEPTION;

Line 59: l_overcommitment_flag PA_PLSQL_DATATYPES.Char1TabTyp;

55: l_asgmt_sys_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
56: l_capacity_quantity PA_PLSQL_DATATYPES.NumTabTyp;
57: l_overcommitment_quantity PA_PLSQL_DATATYPES.NumTabTyp;
58: l_availability_quantity PA_PLSQL_DATATYPES.NumTabTyp;
59: l_overcommitment_flag PA_PLSQL_DATATYPES.Char1TabTyp;
60: l_availability_flag PA_PLSQL_DATATYPES.Char1TabTyp;
61:
62: l_fi_rejected EXCEPTION;
63: lv_rejection_code VARCHAR2(30);

Line 60: l_availability_flag PA_PLSQL_DATATYPES.Char1TabTyp;

56: l_capacity_quantity PA_PLSQL_DATATYPES.NumTabTyp;
57: l_overcommitment_quantity PA_PLSQL_DATATYPES.NumTabTyp;
58: l_availability_quantity PA_PLSQL_DATATYPES.NumTabTyp;
59: l_overcommitment_flag PA_PLSQL_DATATYPES.Char1TabTyp;
60: l_availability_flag PA_PLSQL_DATATYPES.Char1TabTyp;
61:
62: l_fi_rejected EXCEPTION;
63: lv_rejection_code VARCHAR2(30);
64: l_msg_index_out NUMBER;

Line 438: l_forecast_item_id PA_PLSQL_DATATYPES.IdTabTyp;

434: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
435: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
436:
437: IS
438: l_forecast_item_id PA_PLSQL_DATATYPES.IdTabTyp;
439: l_forecast_item_type PA_PLSQL_DATATYPES.Char30TabTyp;
440: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;
441: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
442: l_expenditure_organization_id PA_PLSQL_DATATYPES.IdTabTyp;

Line 439: l_forecast_item_type PA_PLSQL_DATATYPES.Char30TabTyp;

435: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
436:
437: IS
438: l_forecast_item_id PA_PLSQL_DATATYPES.IdTabTyp;
439: l_forecast_item_type PA_PLSQL_DATATYPES.Char30TabTyp;
440: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;
441: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
442: l_expenditure_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
443: l_project_organization_id PA_PLSQL_DATATYPES.IdTabTyp;

Line 440: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;

436:
437: IS
438: l_forecast_item_id PA_PLSQL_DATATYPES.IdTabTyp;
439: l_forecast_item_type PA_PLSQL_DATATYPES.Char30TabTyp;
440: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;
441: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
442: l_expenditure_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
443: l_project_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
444: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;

Line 441: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;

437: IS
438: l_forecast_item_id PA_PLSQL_DATATYPES.IdTabTyp;
439: l_forecast_item_type PA_PLSQL_DATATYPES.Char30TabTyp;
440: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;
441: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
442: l_expenditure_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
443: l_project_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
444: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
445: l_project_type_class PA_PLSQL_DATATYPES.Char30TabTyp;

Line 442: l_expenditure_organization_id PA_PLSQL_DATATYPES.IdTabTyp;

438: l_forecast_item_id PA_PLSQL_DATATYPES.IdTabTyp;
439: l_forecast_item_type PA_PLSQL_DATATYPES.Char30TabTyp;
440: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;
441: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
442: l_expenditure_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
443: l_project_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
444: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
445: l_project_type_class PA_PLSQL_DATATYPES.Char30TabTyp;
446: l_person_id PA_PLSQL_DATATYPES.IdTabTyp;

Line 443: l_project_organization_id PA_PLSQL_DATATYPES.IdTabTyp;

439: l_forecast_item_type PA_PLSQL_DATATYPES.Char30TabTyp;
440: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;
441: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
442: l_expenditure_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
443: l_project_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
444: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
445: l_project_type_class PA_PLSQL_DATATYPES.Char30TabTyp;
446: l_person_id PA_PLSQL_DATATYPES.IdTabTyp;
447: l_resource_id PA_PLSQL_DATATYPES.IdTabTyp;

Line 444: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;

440: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;
441: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
442: l_expenditure_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
443: l_project_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
444: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
445: l_project_type_class PA_PLSQL_DATATYPES.Char30TabTyp;
446: l_person_id PA_PLSQL_DATATYPES.IdTabTyp;
447: l_resource_id PA_PLSQL_DATATYPES.IdTabTyp;
448: l_borrowed_flag PA_PLSQL_DATATYPES.Char1TabTyp;

Line 445: l_project_type_class PA_PLSQL_DATATYPES.Char30TabTyp;

441: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
442: l_expenditure_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
443: l_project_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
444: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
445: l_project_type_class PA_PLSQL_DATATYPES.Char30TabTyp;
446: l_person_id PA_PLSQL_DATATYPES.IdTabTyp;
447: l_resource_id PA_PLSQL_DATATYPES.IdTabTyp;
448: l_borrowed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
449: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;

Line 446: l_person_id PA_PLSQL_DATATYPES.IdTabTyp;

442: l_expenditure_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
443: l_project_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
444: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
445: l_project_type_class PA_PLSQL_DATATYPES.Char30TabTyp;
446: l_person_id PA_PLSQL_DATATYPES.IdTabTyp;
447: l_resource_id PA_PLSQL_DATATYPES.IdTabTyp;
448: l_borrowed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
449: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
450: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;

Line 447: l_resource_id PA_PLSQL_DATATYPES.IdTabTyp;

443: l_project_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
444: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
445: l_project_type_class PA_PLSQL_DATATYPES.Char30TabTyp;
446: l_person_id PA_PLSQL_DATATYPES.IdTabTyp;
447: l_resource_id PA_PLSQL_DATATYPES.IdTabTyp;
448: l_borrowed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
449: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
450: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;
451: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;

Line 448: l_borrowed_flag PA_PLSQL_DATATYPES.Char1TabTyp;

444: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
445: l_project_type_class PA_PLSQL_DATATYPES.Char30TabTyp;
446: l_person_id PA_PLSQL_DATATYPES.IdTabTyp;
447: l_resource_id PA_PLSQL_DATATYPES.IdTabTyp;
448: l_borrowed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
449: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
450: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;
451: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;
452: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;

Line 449: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;

445: l_project_type_class PA_PLSQL_DATATYPES.Char30TabTyp;
446: l_person_id PA_PLSQL_DATATYPES.IdTabTyp;
447: l_resource_id PA_PLSQL_DATATYPES.IdTabTyp;
448: l_borrowed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
449: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
450: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;
451: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;
452: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;
453: l_pvdr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;

Line 450: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;

446: l_person_id PA_PLSQL_DATATYPES.IdTabTyp;
447: l_resource_id PA_PLSQL_DATATYPES.IdTabTyp;
448: l_borrowed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
449: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
450: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;
451: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;
452: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;
453: l_pvdr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;
454: l_pvdr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;

Line 451: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;

447: l_resource_id PA_PLSQL_DATATYPES.IdTabTyp;
448: l_borrowed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
449: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
450: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;
451: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;
452: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;
453: l_pvdr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;
454: l_pvdr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
455: l_pvdr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;

Line 452: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;

448: l_borrowed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
449: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
450: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;
451: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;
452: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;
453: l_pvdr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;
454: l_pvdr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
455: l_pvdr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
456: l_rcvr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;

Line 453: l_pvdr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;

449: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
450: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;
451: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;
452: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;
453: l_pvdr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;
454: l_pvdr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
455: l_pvdr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
456: l_rcvr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;
457: l_rcvr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;

Line 454: l_pvdr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;

450: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;
451: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;
452: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;
453: l_pvdr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;
454: l_pvdr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
455: l_pvdr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
456: l_rcvr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;
457: l_rcvr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
458: l_rcvr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;

Line 455: l_pvdr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;

451: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;
452: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;
453: l_pvdr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;
454: l_pvdr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
455: l_pvdr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
456: l_rcvr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;
457: l_rcvr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
458: l_rcvr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
459: l_global_exp_period_end_date PA_PLSQL_DATATYPES.DateTabTyp;

Line 456: l_rcvr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;

452: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;
453: l_pvdr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;
454: l_pvdr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
455: l_pvdr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
456: l_rcvr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;
457: l_rcvr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
458: l_rcvr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
459: l_global_exp_period_end_date PA_PLSQL_DATATYPES.DateTabTyp;
460: l_expenditure_type PA_PLSQL_DATATYPES.Char30TabTyp;

Line 457: l_rcvr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;

453: l_pvdr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;
454: l_pvdr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
455: l_pvdr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
456: l_rcvr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;
457: l_rcvr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
458: l_rcvr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
459: l_global_exp_period_end_date PA_PLSQL_DATATYPES.DateTabTyp;
460: l_expenditure_type PA_PLSQL_DATATYPES.Char30TabTyp;
461: l_expenditure_type_class PA_PLSQL_DATATYPES.Char30TabTyp;

Line 458: l_rcvr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;

454: l_pvdr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
455: l_pvdr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
456: l_rcvr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;
457: l_rcvr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
458: l_rcvr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
459: l_global_exp_period_end_date PA_PLSQL_DATATYPES.DateTabTyp;
460: l_expenditure_type PA_PLSQL_DATATYPES.Char30TabTyp;
461: l_expenditure_type_class PA_PLSQL_DATATYPES.Char30TabTyp;
462: l_cost_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 459: l_global_exp_period_end_date PA_PLSQL_DATATYPES.DateTabTyp;

455: l_pvdr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
456: l_rcvr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;
457: l_rcvr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
458: l_rcvr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
459: l_global_exp_period_end_date PA_PLSQL_DATATYPES.DateTabTyp;
460: l_expenditure_type PA_PLSQL_DATATYPES.Char30TabTyp;
461: l_expenditure_type_class PA_PLSQL_DATATYPES.Char30TabTyp;
462: l_cost_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
463: l_rev_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 460: l_expenditure_type PA_PLSQL_DATATYPES.Char30TabTyp;

456: l_rcvr_period_set_name PA_PLSQL_DATATYPES.Char30TabTyp;
457: l_rcvr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
458: l_rcvr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
459: l_global_exp_period_end_date PA_PLSQL_DATATYPES.DateTabTyp;
460: l_expenditure_type PA_PLSQL_DATATYPES.Char30TabTyp;
461: l_expenditure_type_class PA_PLSQL_DATATYPES.Char30TabTyp;
462: l_cost_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
463: l_rev_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
464: l_tp_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 461: l_expenditure_type_class PA_PLSQL_DATATYPES.Char30TabTyp;

457: l_rcvr_pa_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
458: l_rcvr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
459: l_global_exp_period_end_date PA_PLSQL_DATATYPES.DateTabTyp;
460: l_expenditure_type PA_PLSQL_DATATYPES.Char30TabTyp;
461: l_expenditure_type_class PA_PLSQL_DATATYPES.Char30TabTyp;
462: l_cost_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
463: l_rev_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
464: l_tp_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
465: l_burden_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 462: l_cost_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;

458: l_rcvr_gl_period_name PA_PLSQL_DATATYPES.Char30TabTyp;
459: l_global_exp_period_end_date PA_PLSQL_DATATYPES.DateTabTyp;
460: l_expenditure_type PA_PLSQL_DATATYPES.Char30TabTyp;
461: l_expenditure_type_class PA_PLSQL_DATATYPES.Char30TabTyp;
462: l_cost_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
463: l_rev_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
464: l_tp_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
465: l_burden_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
466: l_other_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 463: l_rev_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;

459: l_global_exp_period_end_date PA_PLSQL_DATATYPES.DateTabTyp;
460: l_expenditure_type PA_PLSQL_DATATYPES.Char30TabTyp;
461: l_expenditure_type_class PA_PLSQL_DATATYPES.Char30TabTyp;
462: l_cost_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
463: l_rev_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
464: l_tp_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
465: l_burden_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
466: l_other_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
467: l_delete_flag PA_PLSQL_DATATYPES.Char1TabTyp;

Line 464: l_tp_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;

460: l_expenditure_type PA_PLSQL_DATATYPES.Char30TabTyp;
461: l_expenditure_type_class PA_PLSQL_DATATYPES.Char30TabTyp;
462: l_cost_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
463: l_rev_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
464: l_tp_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
465: l_burden_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
466: l_other_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
467: l_delete_flag PA_PLSQL_DATATYPES.Char1TabTyp;
468: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;

Line 465: l_burden_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;

461: l_expenditure_type_class PA_PLSQL_DATATYPES.Char30TabTyp;
462: l_cost_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
463: l_rev_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
464: l_tp_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
465: l_burden_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
466: l_other_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
467: l_delete_flag PA_PLSQL_DATATYPES.Char1TabTyp;
468: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;
469: l_error_flag PA_PLSQL_DATATYPES.Char1TabTyp;

Line 466: l_other_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;

462: l_cost_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
463: l_rev_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
464: l_tp_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
465: l_burden_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
466: l_other_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
467: l_delete_flag PA_PLSQL_DATATYPES.Char1TabTyp;
468: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;
469: l_error_flag PA_PLSQL_DATATYPES.Char1TabTyp;
470: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;

Line 467: l_delete_flag PA_PLSQL_DATATYPES.Char1TabTyp;

463: l_rev_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
464: l_tp_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
465: l_burden_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
466: l_other_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
467: l_delete_flag PA_PLSQL_DATATYPES.Char1TabTyp;
468: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;
469: l_error_flag PA_PLSQL_DATATYPES.Char1TabTyp;
470: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;
471: l_TP_AMOUNT_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;

Line 468: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;

464: l_tp_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
465: l_burden_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
466: l_other_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
467: l_delete_flag PA_PLSQL_DATATYPES.Char1TabTyp;
468: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;
469: l_error_flag PA_PLSQL_DATATYPES.Char1TabTyp;
470: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;
471: l_TP_AMOUNT_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
472: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;

Line 469: l_error_flag PA_PLSQL_DATATYPES.Char1TabTyp;

465: l_burden_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
466: l_other_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
467: l_delete_flag PA_PLSQL_DATATYPES.Char1TabTyp;
468: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;
469: l_error_flag PA_PLSQL_DATATYPES.Char1TabTyp;
470: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;
471: l_TP_AMOUNT_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
472: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
473: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;

Line 470: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;

466: l_other_rejection_code PA_PLSQL_DATATYPES.Char30TabTyp;
467: l_delete_flag PA_PLSQL_DATATYPES.Char1TabTyp;
468: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;
469: l_error_flag PA_PLSQL_DATATYPES.Char1TabTyp;
470: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;
471: l_TP_AMOUNT_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
472: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
473: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;
474: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;

Line 471: l_TP_AMOUNT_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;

467: l_delete_flag PA_PLSQL_DATATYPES.Char1TabTyp;
468: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;
469: l_error_flag PA_PLSQL_DATATYPES.Char1TabTyp;
470: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;
471: l_TP_AMOUNT_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
472: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
473: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;
474: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;
475: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;

Line 472: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;

468: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;
469: l_error_flag PA_PLSQL_DATATYPES.Char1TabTyp;
470: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;
471: l_TP_AMOUNT_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
472: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
473: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;
474: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;
475: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
476: l_asgmt_sys_status_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 473: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;

469: l_error_flag PA_PLSQL_DATATYPES.Char1TabTyp;
470: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;
471: l_TP_AMOUNT_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
472: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
473: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;
474: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;
475: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
476: l_asgmt_sys_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
477: l_capacity_quantity PA_PLSQL_DATATYPES.NumTabTyp;

Line 474: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;

470: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;
471: l_TP_AMOUNT_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
472: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
473: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;
474: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;
475: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
476: l_asgmt_sys_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
477: l_capacity_quantity PA_PLSQL_DATATYPES.NumTabTyp;
478: l_overcommitment_quantity PA_PLSQL_DATATYPES.NumTabTyp;

Line 475: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;

471: l_TP_AMOUNT_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
472: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
473: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;
474: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;
475: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
476: l_asgmt_sys_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
477: l_capacity_quantity PA_PLSQL_DATATYPES.NumTabTyp;
478: l_overcommitment_quantity PA_PLSQL_DATATYPES.NumTabTyp;
479: l_availability_quantity PA_PLSQL_DATATYPES.NumTabTyp;

Line 476: l_asgmt_sys_status_code PA_PLSQL_DATATYPES.Char30TabTyp;

472: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
473: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;
474: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;
475: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
476: l_asgmt_sys_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
477: l_capacity_quantity PA_PLSQL_DATATYPES.NumTabTyp;
478: l_overcommitment_quantity PA_PLSQL_DATATYPES.NumTabTyp;
479: l_availability_quantity PA_PLSQL_DATATYPES.NumTabTyp;
480: l_overcommitment_flag PA_PLSQL_DATATYPES.Char1TabTyp;

Line 477: l_capacity_quantity PA_PLSQL_DATATYPES.NumTabTyp;

473: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;
474: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;
475: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
476: l_asgmt_sys_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
477: l_capacity_quantity PA_PLSQL_DATATYPES.NumTabTyp;
478: l_overcommitment_quantity PA_PLSQL_DATATYPES.NumTabTyp;
479: l_availability_quantity PA_PLSQL_DATATYPES.NumTabTyp;
480: l_overcommitment_flag PA_PLSQL_DATATYPES.Char1TabTyp;
481: l_availability_flag PA_PLSQL_DATATYPES.Char1TabTyp;

Line 478: l_overcommitment_quantity PA_PLSQL_DATATYPES.NumTabTyp;

474: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;
475: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
476: l_asgmt_sys_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
477: l_capacity_quantity PA_PLSQL_DATATYPES.NumTabTyp;
478: l_overcommitment_quantity PA_PLSQL_DATATYPES.NumTabTyp;
479: l_availability_quantity PA_PLSQL_DATATYPES.NumTabTyp;
480: l_overcommitment_flag PA_PLSQL_DATATYPES.Char1TabTyp;
481: l_availability_flag PA_PLSQL_DATATYPES.Char1TabTyp;
482:

Line 479: l_availability_quantity PA_PLSQL_DATATYPES.NumTabTyp;

475: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
476: l_asgmt_sys_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
477: l_capacity_quantity PA_PLSQL_DATATYPES.NumTabTyp;
478: l_overcommitment_quantity PA_PLSQL_DATATYPES.NumTabTyp;
479: l_availability_quantity PA_PLSQL_DATATYPES.NumTabTyp;
480: l_overcommitment_flag PA_PLSQL_DATATYPES.Char1TabTyp;
481: l_availability_flag PA_PLSQL_DATATYPES.Char1TabTyp;
482:
483: l_fi_rejected EXCEPTION;

Line 480: l_overcommitment_flag PA_PLSQL_DATATYPES.Char1TabTyp;

476: l_asgmt_sys_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
477: l_capacity_quantity PA_PLSQL_DATATYPES.NumTabTyp;
478: l_overcommitment_quantity PA_PLSQL_DATATYPES.NumTabTyp;
479: l_availability_quantity PA_PLSQL_DATATYPES.NumTabTyp;
480: l_overcommitment_flag PA_PLSQL_DATATYPES.Char1TabTyp;
481: l_availability_flag PA_PLSQL_DATATYPES.Char1TabTyp;
482:
483: l_fi_rejected EXCEPTION;
484: lv_rejection_code VARCHAR2(30);

Line 481: l_availability_flag PA_PLSQL_DATATYPES.Char1TabTyp;

477: l_capacity_quantity PA_PLSQL_DATATYPES.NumTabTyp;
478: l_overcommitment_quantity PA_PLSQL_DATATYPES.NumTabTyp;
479: l_availability_quantity PA_PLSQL_DATATYPES.NumTabTyp;
480: l_overcommitment_flag PA_PLSQL_DATATYPES.Char1TabTyp;
481: l_availability_flag PA_PLSQL_DATATYPES.Char1TabTyp;
482:
483: l_fi_rejected EXCEPTION;
484: lv_rejection_code VARCHAR2(30);
485: l_msg_index_out NUMBER;

Line 818: l_schedule_id PA_PLSQL_DATATYPES.IdTabTyp;

814: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
815: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
816:
817: IS
818: l_schedule_id PA_PLSQL_DATATYPES.IdTabTyp;
819: l_forecast_txn_version_number PA_PLSQL_DATATYPES.NumTabTyp;
820:
821:
822: BEGIN

Line 819: l_forecast_txn_version_number PA_PLSQL_DATATYPES.NumTabTyp;

815: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
816:
817: IS
818: l_schedule_id PA_PLSQL_DATATYPES.IdTabTyp;
819: l_forecast_txn_version_number PA_PLSQL_DATATYPES.NumTabTyp;
820:
821:
822: BEGIN
823: PA_DEBUG.Init_err_stack( 'PA_FORECAST_HDR_PKG.Update_Schedule_Rows');