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_DTLS_PKG dependencies on PA_PLSQL_DATATYPES

Line 18: l_forecast_item_id PA_PLSQL_DATATYPES.IdTabTyp;

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:
18: l_forecast_item_id PA_PLSQL_DATATYPES.IdTabTyp;
19: l_amount_type_id PA_PLSQL_DATATYPES.IdTabTyp;
20: l_line_num PA_PLSQL_DATATYPES.NumTabTyp;
21: l_resource_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
22: l_person_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;

Line 19: l_amount_type_id PA_PLSQL_DATATYPES.IdTabTyp;

15: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
16: IS
17:
18: l_forecast_item_id PA_PLSQL_DATATYPES.IdTabTyp;
19: l_amount_type_id PA_PLSQL_DATATYPES.IdTabTyp;
20: l_line_num PA_PLSQL_DATATYPES.NumTabTyp;
21: l_resource_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
22: l_person_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;
23: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;

Line 20: l_line_num PA_PLSQL_DATATYPES.NumTabTyp;

16: IS
17:
18: l_forecast_item_id PA_PLSQL_DATATYPES.IdTabTyp;
19: l_amount_type_id PA_PLSQL_DATATYPES.IdTabTyp;
20: l_line_num PA_PLSQL_DATATYPES.NumTabTyp;
21: l_resource_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
22: l_person_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;
23: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;
24: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;

Line 21: l_resource_type_code PA_PLSQL_DATATYPES.Char30TabTyp;

17:
18: l_forecast_item_id PA_PLSQL_DATATYPES.IdTabTyp;
19: l_amount_type_id PA_PLSQL_DATATYPES.IdTabTyp;
20: l_line_num PA_PLSQL_DATATYPES.NumTabTyp;
21: l_resource_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
22: l_person_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;
23: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;
24: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;
25: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;

Line 22: l_person_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;

18: l_forecast_item_id PA_PLSQL_DATATYPES.IdTabTyp;
19: l_amount_type_id PA_PLSQL_DATATYPES.IdTabTyp;
20: l_line_num PA_PLSQL_DATATYPES.NumTabTyp;
21: l_resource_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
22: l_person_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;
23: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;
24: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;
25: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;
26: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;

Line 23: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;

19: l_amount_type_id PA_PLSQL_DATATYPES.IdTabTyp;
20: l_line_num PA_PLSQL_DATATYPES.NumTabTyp;
21: l_resource_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
22: l_person_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;
23: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;
24: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;
25: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;
26: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
27: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;

Line 24: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;

20: l_line_num PA_PLSQL_DATATYPES.NumTabTyp;
21: l_resource_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
22: l_person_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;
23: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;
24: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;
25: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;
26: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
27: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;
28: l_PJI_SUMMARIZED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;

Line 25: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;

21: l_resource_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
22: l_person_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;
23: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;
24: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;
25: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;
26: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
27: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;
28: l_PJI_SUMMARIZED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
29: l_CAPACITY_QUANTITY PA_PLSQL_DATATYPES.NumTabTyp;

Line 26: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;

22: l_person_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;
23: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;
24: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;
25: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;
26: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
27: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;
28: l_PJI_SUMMARIZED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
29: l_CAPACITY_QUANTITY PA_PLSQL_DATATYPES.NumTabTyp;
30: l_OVERCOMMITMENT_QTY PA_PLSQL_DATATYPES.NumTabTyp;

Line 27: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;

23: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;
24: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;
25: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;
26: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
27: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;
28: l_PJI_SUMMARIZED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
29: l_CAPACITY_QUANTITY PA_PLSQL_DATATYPES.NumTabTyp;
30: l_OVERCOMMITMENT_QTY PA_PLSQL_DATATYPES.NumTabTyp;
31: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;

Line 28: l_PJI_SUMMARIZED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;

24: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;
25: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;
26: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
27: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;
28: l_PJI_SUMMARIZED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
29: l_CAPACITY_QUANTITY PA_PLSQL_DATATYPES.NumTabTyp;
30: l_OVERCOMMITMENT_QTY PA_PLSQL_DATATYPES.NumTabTyp;
31: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
32: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;

Line 29: l_CAPACITY_QUANTITY PA_PLSQL_DATATYPES.NumTabTyp;

25: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;
26: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
27: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;
28: l_PJI_SUMMARIZED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
29: l_CAPACITY_QUANTITY PA_PLSQL_DATATYPES.NumTabTyp;
30: l_OVERCOMMITMENT_QTY PA_PLSQL_DATATYPES.NumTabTyp;
31: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
32: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;
33: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;

Line 30: l_OVERCOMMITMENT_QTY PA_PLSQL_DATATYPES.NumTabTyp;

26: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
27: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;
28: l_PJI_SUMMARIZED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
29: l_CAPACITY_QUANTITY PA_PLSQL_DATATYPES.NumTabTyp;
30: l_OVERCOMMITMENT_QTY PA_PLSQL_DATATYPES.NumTabTyp;
31: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
32: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;
33: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;
34: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;

Line 31: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;

27: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;
28: l_PJI_SUMMARIZED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
29: l_CAPACITY_QUANTITY PA_PLSQL_DATATYPES.NumTabTyp;
30: l_OVERCOMMITMENT_QTY PA_PLSQL_DATATYPES.NumTabTyp;
31: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
32: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;
33: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;
34: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
35: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;

Line 32: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;

28: l_PJI_SUMMARIZED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
29: l_CAPACITY_QUANTITY PA_PLSQL_DATATYPES.NumTabTyp;
30: l_OVERCOMMITMENT_QTY PA_PLSQL_DATATYPES.NumTabTyp;
31: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
32: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;
33: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;
34: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
35: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;
36: l_PROJECT_ID PA_PLSQL_DATATYPES.NumTabTyp;

Line 33: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;

29: l_CAPACITY_QUANTITY PA_PLSQL_DATATYPES.NumTabTyp;
30: l_OVERCOMMITMENT_QTY PA_PLSQL_DATATYPES.NumTabTyp;
31: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
32: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;
33: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;
34: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
35: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;
36: l_PROJECT_ID PA_PLSQL_DATATYPES.NumTabTyp;
37: l_RESOURCE_ID PA_PLSQL_DATATYPES.NumTabTyp;

Line 34: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;

30: l_OVERCOMMITMENT_QTY PA_PLSQL_DATATYPES.NumTabTyp;
31: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
32: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;
33: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;
34: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
35: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;
36: l_PROJECT_ID PA_PLSQL_DATATYPES.NumTabTyp;
37: l_RESOURCE_ID PA_PLSQL_DATATYPES.NumTabTyp;
38: l_EXPENDITURE_ORGANIZATION_ID PA_PLSQL_DATATYPES.NumTabTyp;

Line 35: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;

31: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
32: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;
33: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;
34: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
35: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;
36: l_PROJECT_ID PA_PLSQL_DATATYPES.NumTabTyp;
37: l_RESOURCE_ID PA_PLSQL_DATATYPES.NumTabTyp;
38: l_EXPENDITURE_ORGANIZATION_ID PA_PLSQL_DATATYPES.NumTabTyp;
39: l_pvdr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 36: l_PROJECT_ID PA_PLSQL_DATATYPES.NumTabTyp;

32: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;
33: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;
34: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
35: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;
36: l_PROJECT_ID PA_PLSQL_DATATYPES.NumTabTyp;
37: l_RESOURCE_ID PA_PLSQL_DATATYPES.NumTabTyp;
38: l_EXPENDITURE_ORGANIZATION_ID PA_PLSQL_DATATYPES.NumTabTyp;
39: l_pvdr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;
40: l_pvdr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;

Line 37: l_RESOURCE_ID PA_PLSQL_DATATYPES.NumTabTyp;

33: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;
34: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
35: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;
36: l_PROJECT_ID PA_PLSQL_DATATYPES.NumTabTyp;
37: l_RESOURCE_ID PA_PLSQL_DATATYPES.NumTabTyp;
38: l_EXPENDITURE_ORGANIZATION_ID PA_PLSQL_DATATYPES.NumTabTyp;
39: l_pvdr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;
40: l_pvdr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;
41: l_rcvr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 38: l_EXPENDITURE_ORGANIZATION_ID PA_PLSQL_DATATYPES.NumTabTyp;

34: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
35: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;
36: l_PROJECT_ID PA_PLSQL_DATATYPES.NumTabTyp;
37: l_RESOURCE_ID PA_PLSQL_DATATYPES.NumTabTyp;
38: l_EXPENDITURE_ORGANIZATION_ID PA_PLSQL_DATATYPES.NumTabTyp;
39: l_pvdr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;
40: l_pvdr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;
41: l_rcvr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;
42: l_rcvr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;

Line 39: l_pvdr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;

35: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;
36: l_PROJECT_ID PA_PLSQL_DATATYPES.NumTabTyp;
37: l_RESOURCE_ID PA_PLSQL_DATATYPES.NumTabTyp;
38: l_EXPENDITURE_ORGANIZATION_ID PA_PLSQL_DATATYPES.NumTabTyp;
39: l_pvdr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;
40: l_pvdr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;
41: l_rcvr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;
42: l_rcvr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;
43: l_proj_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 40: l_pvdr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;

36: l_PROJECT_ID PA_PLSQL_DATATYPES.NumTabTyp;
37: l_RESOURCE_ID PA_PLSQL_DATATYPES.NumTabTyp;
38: l_EXPENDITURE_ORGANIZATION_ID PA_PLSQL_DATATYPES.NumTabTyp;
39: l_pvdr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;
40: l_pvdr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;
41: l_rcvr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;
42: l_rcvr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;
43: l_proj_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
44: l_proj_amount PA_PLSQL_DATATYPES.NumTabTyp;

Line 41: l_rcvr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;

37: l_RESOURCE_ID PA_PLSQL_DATATYPES.NumTabTyp;
38: l_EXPENDITURE_ORGANIZATION_ID PA_PLSQL_DATATYPES.NumTabTyp;
39: l_pvdr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;
40: l_pvdr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;
41: l_rcvr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;
42: l_rcvr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;
43: l_proj_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
44: l_proj_amount PA_PLSQL_DATATYPES.NumTabTyp;
45: l_denom_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 42: l_rcvr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;

38: l_EXPENDITURE_ORGANIZATION_ID PA_PLSQL_DATATYPES.NumTabTyp;
39: l_pvdr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;
40: l_pvdr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;
41: l_rcvr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;
42: l_rcvr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;
43: l_proj_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
44: l_proj_amount PA_PLSQL_DATATYPES.NumTabTyp;
45: l_denom_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
46: l_denom_amount PA_PLSQL_DATATYPES.NumTabTyp;

Line 43: l_proj_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;

39: l_pvdr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;
40: l_pvdr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;
41: l_rcvr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;
42: l_rcvr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;
43: l_proj_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
44: l_proj_amount PA_PLSQL_DATATYPES.NumTabTyp;
45: l_denom_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
46: l_denom_amount PA_PLSQL_DATATYPES.NumTabTyp;
47: l_tp_amount_type PA_PLSQL_DATATYPES.Char30TabTyp;

Line 44: l_proj_amount PA_PLSQL_DATATYPES.NumTabTyp;

40: l_pvdr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;
41: l_rcvr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;
42: l_rcvr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;
43: l_proj_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
44: l_proj_amount PA_PLSQL_DATATYPES.NumTabTyp;
45: l_denom_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
46: l_denom_amount PA_PLSQL_DATATYPES.NumTabTyp;
47: l_tp_amount_type PA_PLSQL_DATATYPES.Char30TabTyp;
48: l_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;

Line 45: l_denom_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;

41: l_rcvr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;
42: l_rcvr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;
43: l_proj_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
44: l_proj_amount PA_PLSQL_DATATYPES.NumTabTyp;
45: l_denom_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
46: l_denom_amount PA_PLSQL_DATATYPES.NumTabTyp;
47: l_tp_amount_type PA_PLSQL_DATATYPES.Char30TabTyp;
48: l_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;
49: l_forecast_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 46: l_denom_amount PA_PLSQL_DATATYPES.NumTabTyp;

42: l_rcvr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;
43: l_proj_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
44: l_proj_amount PA_PLSQL_DATATYPES.NumTabTyp;
45: l_denom_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
46: l_denom_amount PA_PLSQL_DATATYPES.NumTabTyp;
47: l_tp_amount_type PA_PLSQL_DATATYPES.Char30TabTyp;
48: l_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;
49: l_forecast_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;
50: l_util_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 47: l_tp_amount_type PA_PLSQL_DATATYPES.Char30TabTyp;

43: l_proj_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
44: l_proj_amount PA_PLSQL_DATATYPES.NumTabTyp;
45: l_denom_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
46: l_denom_amount PA_PLSQL_DATATYPES.NumTabTyp;
47: l_tp_amount_type PA_PLSQL_DATATYPES.Char30TabTyp;
48: l_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;
49: l_forecast_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;
50: l_util_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;
51: l_work_type_id PA_PLSQL_DATATYPES.IdTabTyp;

Line 48: l_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;

44: l_proj_amount PA_PLSQL_DATATYPES.NumTabTyp;
45: l_denom_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
46: l_denom_amount PA_PLSQL_DATATYPES.NumTabTyp;
47: l_tp_amount_type PA_PLSQL_DATATYPES.Char30TabTyp;
48: l_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;
49: l_forecast_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;
50: l_util_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;
51: l_work_type_id PA_PLSQL_DATATYPES.IdTabTyp;
52: l_resource_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;

Line 49: l_forecast_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;

45: l_denom_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
46: l_denom_amount PA_PLSQL_DATATYPES.NumTabTyp;
47: l_tp_amount_type PA_PLSQL_DATATYPES.Char30TabTyp;
48: l_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;
49: l_forecast_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;
50: l_util_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;
51: l_work_type_id PA_PLSQL_DATATYPES.IdTabTyp;
52: l_resource_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;
53: l_org_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;

Line 50: l_util_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;

46: l_denom_amount PA_PLSQL_DATATYPES.NumTabTyp;
47: l_tp_amount_type PA_PLSQL_DATATYPES.Char30TabTyp;
48: l_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;
49: l_forecast_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;
50: l_util_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;
51: l_work_type_id PA_PLSQL_DATATYPES.IdTabTyp;
52: l_resource_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;
53: l_org_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;
54: l_resource_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;

Line 51: l_work_type_id PA_PLSQL_DATATYPES.IdTabTyp;

47: l_tp_amount_type PA_PLSQL_DATATYPES.Char30TabTyp;
48: l_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;
49: l_forecast_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;
50: l_util_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;
51: l_work_type_id PA_PLSQL_DATATYPES.IdTabTyp;
52: l_resource_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;
53: l_org_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;
54: l_resource_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;
55: l_org_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;

Line 52: l_resource_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;

48: l_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;
49: l_forecast_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;
50: l_util_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;
51: l_work_type_id PA_PLSQL_DATATYPES.IdTabTyp;
52: l_resource_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;
53: l_org_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;
54: l_resource_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;
55: l_org_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;
56: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;

Line 53: l_org_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;

49: l_forecast_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;
50: l_util_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;
51: l_work_type_id PA_PLSQL_DATATYPES.IdTabTyp;
52: l_resource_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;
53: l_org_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;
54: l_resource_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;
55: l_org_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;
56: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;
57: l_reversed_flag PA_PLSQL_DATATYPES.Char1TabTyp;

Line 54: l_resource_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;

50: l_util_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;
51: l_work_type_id PA_PLSQL_DATATYPES.IdTabTyp;
52: l_resource_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;
53: l_org_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;
54: l_resource_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;
55: l_org_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;
56: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;
57: l_reversed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
58: l_net_zero_flag PA_PLSQL_DATATYPES.Char1TabTyp;

Line 55: l_org_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;

51: l_work_type_id PA_PLSQL_DATATYPES.IdTabTyp;
52: l_resource_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;
53: l_org_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;
54: l_resource_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;
55: l_org_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;
56: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;
57: l_reversed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
58: l_net_zero_flag PA_PLSQL_DATATYPES.Char1TabTyp;
59: l_reduce_capacity_flag PA_PLSQL_DATATYPES.Char1TabTyp;

Line 56: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;

52: l_resource_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;
53: l_org_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;
54: l_resource_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;
55: l_org_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;
56: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;
57: l_reversed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
58: l_net_zero_flag PA_PLSQL_DATATYPES.Char1TabTyp;
59: l_reduce_capacity_flag PA_PLSQL_DATATYPES.Char1TabTyp;
60: l_line_num_reversed PA_PLSQL_DATATYPES.NumTabTyp;

Line 57: l_reversed_flag PA_PLSQL_DATATYPES.Char1TabTyp;

53: l_org_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;
54: l_resource_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;
55: l_org_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;
56: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;
57: l_reversed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
58: l_net_zero_flag PA_PLSQL_DATATYPES.Char1TabTyp;
59: l_reduce_capacity_flag PA_PLSQL_DATATYPES.Char1TabTyp;
60: l_line_num_reversed PA_PLSQL_DATATYPES.NumTabTyp;
61:

Line 58: l_net_zero_flag PA_PLSQL_DATATYPES.Char1TabTyp;

54: l_resource_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;
55: l_org_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;
56: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;
57: l_reversed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
58: l_net_zero_flag PA_PLSQL_DATATYPES.Char1TabTyp;
59: l_reduce_capacity_flag PA_PLSQL_DATATYPES.Char1TabTyp;
60: l_line_num_reversed PA_PLSQL_DATATYPES.NumTabTyp;
61:
62:

Line 59: l_reduce_capacity_flag PA_PLSQL_DATATYPES.Char1TabTyp;

55: l_org_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;
56: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;
57: l_reversed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
58: l_net_zero_flag PA_PLSQL_DATATYPES.Char1TabTyp;
59: l_reduce_capacity_flag PA_PLSQL_DATATYPES.Char1TabTyp;
60: l_line_num_reversed PA_PLSQL_DATATYPES.NumTabTyp;
61:
62:
63: BEGIN

Line 60: l_line_num_reversed PA_PLSQL_DATATYPES.NumTabTyp;

56: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;
57: l_reversed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
58: l_net_zero_flag PA_PLSQL_DATATYPES.Char1TabTyp;
59: l_reduce_capacity_flag PA_PLSQL_DATATYPES.Char1TabTyp;
60: l_line_num_reversed PA_PLSQL_DATATYPES.NumTabTyp;
61:
62:
63: BEGIN
64: PA_DEBUG.Init_err_stack( 'PA_FORECAST_DTLS_PKG.Insert_Rows');

Line 269: l_forecast_item_id PA_PLSQL_DATATYPES.IdTabTyp;

265: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
266: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
267:
268: IS
269: l_forecast_item_id PA_PLSQL_DATATYPES.IdTabTyp;
270: l_amount_type_id PA_PLSQL_DATATYPES.IdTabTyp;
271: l_line_num PA_PLSQL_DATATYPES.NumTabTyp;
272: l_resource_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
273: l_person_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;

Line 270: l_amount_type_id PA_PLSQL_DATATYPES.IdTabTyp;

266: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
267:
268: IS
269: l_forecast_item_id PA_PLSQL_DATATYPES.IdTabTyp;
270: l_amount_type_id PA_PLSQL_DATATYPES.IdTabTyp;
271: l_line_num PA_PLSQL_DATATYPES.NumTabTyp;
272: l_resource_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
273: l_person_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;
274: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;

Line 271: l_line_num PA_PLSQL_DATATYPES.NumTabTyp;

267:
268: IS
269: l_forecast_item_id PA_PLSQL_DATATYPES.IdTabTyp;
270: l_amount_type_id PA_PLSQL_DATATYPES.IdTabTyp;
271: l_line_num PA_PLSQL_DATATYPES.NumTabTyp;
272: l_resource_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
273: l_person_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;
274: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;
275: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;

Line 272: l_resource_type_code PA_PLSQL_DATATYPES.Char30TabTyp;

268: IS
269: l_forecast_item_id PA_PLSQL_DATATYPES.IdTabTyp;
270: l_amount_type_id PA_PLSQL_DATATYPES.IdTabTyp;
271: l_line_num PA_PLSQL_DATATYPES.NumTabTyp;
272: l_resource_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
273: l_person_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;
274: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;
275: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;
276: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;

Line 273: l_person_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;

269: l_forecast_item_id PA_PLSQL_DATATYPES.IdTabTyp;
270: l_amount_type_id PA_PLSQL_DATATYPES.IdTabTyp;
271: l_line_num PA_PLSQL_DATATYPES.NumTabTyp;
272: l_resource_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
273: l_person_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;
274: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;
275: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;
276: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;
277: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;

Line 274: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;

270: l_amount_type_id PA_PLSQL_DATATYPES.IdTabTyp;
271: l_line_num PA_PLSQL_DATATYPES.NumTabTyp;
272: l_resource_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
273: l_person_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;
274: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;
275: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;
276: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;
277: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
278: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;

Line 275: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;

271: l_line_num PA_PLSQL_DATATYPES.NumTabTyp;
272: l_resource_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
273: l_person_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;
274: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;
275: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;
276: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;
277: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
278: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;
279: l_PJI_SUMMARIZED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;

Line 276: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;

272: l_resource_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
273: l_person_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;
274: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;
275: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;
276: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;
277: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
278: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;
279: l_PJI_SUMMARIZED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
280: l_CAPACITY_QUANTITY PA_PLSQL_DATATYPES.NumTabTyp;

Line 277: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;

273: l_person_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;
274: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;
275: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;
276: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;
277: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
278: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;
279: l_PJI_SUMMARIZED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
280: l_CAPACITY_QUANTITY PA_PLSQL_DATATYPES.NumTabTyp;
281: l_OVERCOMMITMENT_QTY PA_PLSQL_DATATYPES.NumTabTyp;

Line 278: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;

274: l_item_uom PA_PLSQL_DATATYPES.Char30TabTyp;
275: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;
276: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;
277: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
278: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;
279: l_PJI_SUMMARIZED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
280: l_CAPACITY_QUANTITY PA_PLSQL_DATATYPES.NumTabTyp;
281: l_OVERCOMMITMENT_QTY PA_PLSQL_DATATYPES.NumTabTyp;
282: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;

Line 279: l_PJI_SUMMARIZED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;

275: l_item_date PA_PLSQL_DATATYPES.DateTabTyp;
276: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;
277: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
278: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;
279: l_PJI_SUMMARIZED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
280: l_CAPACITY_QUANTITY PA_PLSQL_DATATYPES.NumTabTyp;
281: l_OVERCOMMITMENT_QTY PA_PLSQL_DATATYPES.NumTabTyp;
282: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
283: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;

Line 280: l_CAPACITY_QUANTITY PA_PLSQL_DATATYPES.NumTabTyp;

276: l_item_quantity PA_PLSQL_DATATYPES.NumTabTyp;
277: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
278: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;
279: l_PJI_SUMMARIZED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
280: l_CAPACITY_QUANTITY PA_PLSQL_DATATYPES.NumTabTyp;
281: l_OVERCOMMITMENT_QTY PA_PLSQL_DATATYPES.NumTabTyp;
282: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
283: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;
284: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;

Line 281: l_OVERCOMMITMENT_QTY PA_PLSQL_DATATYPES.NumTabTyp;

277: l_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
278: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;
279: l_PJI_SUMMARIZED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
280: l_CAPACITY_QUANTITY PA_PLSQL_DATATYPES.NumTabTyp;
281: l_OVERCOMMITMENT_QTY PA_PLSQL_DATATYPES.NumTabTyp;
282: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
283: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;
284: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;
285: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;

Line 282: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;

278: l_project_org_id PA_PLSQL_DATATYPES.IdTabTyp;
279: l_PJI_SUMMARIZED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
280: l_CAPACITY_QUANTITY PA_PLSQL_DATATYPES.NumTabTyp;
281: l_OVERCOMMITMENT_QTY PA_PLSQL_DATATYPES.NumTabTyp;
282: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
283: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;
284: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;
285: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
286: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;

Line 283: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;

279: l_PJI_SUMMARIZED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
280: l_CAPACITY_QUANTITY PA_PLSQL_DATATYPES.NumTabTyp;
281: l_OVERCOMMITMENT_QTY PA_PLSQL_DATATYPES.NumTabTyp;
282: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
283: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;
284: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;
285: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
286: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;
287: l_PROJECT_ID PA_PLSQL_DATATYPES.NumTabTyp;

Line 284: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;

280: l_CAPACITY_QUANTITY PA_PLSQL_DATATYPES.NumTabTyp;
281: l_OVERCOMMITMENT_QTY PA_PLSQL_DATATYPES.NumTabTyp;
282: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
283: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;
284: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;
285: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
286: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;
287: l_PROJECT_ID PA_PLSQL_DATATYPES.NumTabTyp;
288: l_RESOURCE_ID PA_PLSQL_DATATYPES.NumTabTyp;

Line 285: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;

281: l_OVERCOMMITMENT_QTY PA_PLSQL_DATATYPES.NumTabTyp;
282: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
283: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;
284: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;
285: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
286: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;
287: l_PROJECT_ID PA_PLSQL_DATATYPES.NumTabTyp;
288: l_RESOURCE_ID PA_PLSQL_DATATYPES.NumTabTyp;
289: l_EXPENDITURE_ORGANIZATION_ID PA_PLSQL_DATATYPES.NumTabTyp;

Line 286: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;

282: l_OVERPROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
283: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;
284: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;
285: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
286: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;
287: l_PROJECT_ID PA_PLSQL_DATATYPES.NumTabTyp;
288: l_RESOURCE_ID PA_PLSQL_DATATYPES.NumTabTyp;
289: l_EXPENDITURE_ORGANIZATION_ID PA_PLSQL_DATATYPES.NumTabTyp;
290: l_pvdr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 287: l_PROJECT_ID PA_PLSQL_DATATYPES.NumTabTyp;

283: l_OVER_PROV_CONF_QTY PA_PLSQL_DATATYPES.NumTabTyp;
284: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;
285: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
286: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;
287: l_PROJECT_ID PA_PLSQL_DATATYPES.NumTabTyp;
288: l_RESOURCE_ID PA_PLSQL_DATATYPES.NumTabTyp;
289: l_EXPENDITURE_ORGANIZATION_ID PA_PLSQL_DATATYPES.NumTabTyp;
290: l_pvdr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;
291: l_pvdr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;

Line 288: l_RESOURCE_ID PA_PLSQL_DATATYPES.NumTabTyp;

284: l_CONFIRMED_QTY PA_PLSQL_DATATYPES.NumTabTyp;
285: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
286: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;
287: l_PROJECT_ID PA_PLSQL_DATATYPES.NumTabTyp;
288: l_RESOURCE_ID PA_PLSQL_DATATYPES.NumTabTyp;
289: l_EXPENDITURE_ORGANIZATION_ID PA_PLSQL_DATATYPES.NumTabTyp;
290: l_pvdr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;
291: l_pvdr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;
292: l_rcvr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 289: l_EXPENDITURE_ORGANIZATION_ID PA_PLSQL_DATATYPES.NumTabTyp;

285: l_PROVISIONAL_QTY PA_PLSQL_DATATYPES.NumTabTyp;
286: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;
287: l_PROJECT_ID PA_PLSQL_DATATYPES.NumTabTyp;
288: l_RESOURCE_ID PA_PLSQL_DATATYPES.NumTabTyp;
289: l_EXPENDITURE_ORGANIZATION_ID PA_PLSQL_DATATYPES.NumTabTyp;
290: l_pvdr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;
291: l_pvdr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;
292: l_rcvr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;
293: l_rcvr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;

Line 290: l_pvdr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;

286: l_JOB_ID PA_PLSQL_DATATYPES.NumTabTyp;
287: l_PROJECT_ID PA_PLSQL_DATATYPES.NumTabTyp;
288: l_RESOURCE_ID PA_PLSQL_DATATYPES.NumTabTyp;
289: l_EXPENDITURE_ORGANIZATION_ID PA_PLSQL_DATATYPES.NumTabTyp;
290: l_pvdr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;
291: l_pvdr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;
292: l_rcvr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;
293: l_rcvr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;
294: l_proj_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 291: l_pvdr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;

287: l_PROJECT_ID PA_PLSQL_DATATYPES.NumTabTyp;
288: l_RESOURCE_ID PA_PLSQL_DATATYPES.NumTabTyp;
289: l_EXPENDITURE_ORGANIZATION_ID PA_PLSQL_DATATYPES.NumTabTyp;
290: l_pvdr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;
291: l_pvdr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;
292: l_rcvr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;
293: l_rcvr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;
294: l_proj_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
295: l_proj_amount PA_PLSQL_DATATYPES.NumTabTyp;

Line 292: l_rcvr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;

288: l_RESOURCE_ID PA_PLSQL_DATATYPES.NumTabTyp;
289: l_EXPENDITURE_ORGANIZATION_ID PA_PLSQL_DATATYPES.NumTabTyp;
290: l_pvdr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;
291: l_pvdr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;
292: l_rcvr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;
293: l_rcvr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;
294: l_proj_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
295: l_proj_amount PA_PLSQL_DATATYPES.NumTabTyp;
296: l_denom_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 293: l_rcvr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;

289: l_EXPENDITURE_ORGANIZATION_ID PA_PLSQL_DATATYPES.NumTabTyp;
290: l_pvdr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;
291: l_pvdr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;
292: l_rcvr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;
293: l_rcvr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;
294: l_proj_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
295: l_proj_amount PA_PLSQL_DATATYPES.NumTabTyp;
296: l_denom_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
297: l_denom_amount PA_PLSQL_DATATYPES.NumTabTyp;

Line 294: l_proj_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;

290: l_pvdr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;
291: l_pvdr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;
292: l_rcvr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;
293: l_rcvr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;
294: l_proj_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
295: l_proj_amount PA_PLSQL_DATATYPES.NumTabTyp;
296: l_denom_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
297: l_denom_amount PA_PLSQL_DATATYPES.NumTabTyp;
298: l_tp_amount_type PA_PLSQL_DATATYPES.Char30TabTyp;

Line 295: l_proj_amount PA_PLSQL_DATATYPES.NumTabTyp;

291: l_pvdr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;
292: l_rcvr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;
293: l_rcvr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;
294: l_proj_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
295: l_proj_amount PA_PLSQL_DATATYPES.NumTabTyp;
296: l_denom_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
297: l_denom_amount PA_PLSQL_DATATYPES.NumTabTyp;
298: l_tp_amount_type PA_PLSQL_DATATYPES.Char30TabTyp;
299: l_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;

Line 296: l_denom_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;

292: l_rcvr_acct_curr_code PA_PLSQL_DATATYPES.Char30TabTyp;
293: l_rcvr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;
294: l_proj_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
295: l_proj_amount PA_PLSQL_DATATYPES.NumTabTyp;
296: l_denom_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
297: l_denom_amount PA_PLSQL_DATATYPES.NumTabTyp;
298: l_tp_amount_type PA_PLSQL_DATATYPES.Char30TabTyp;
299: l_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;
300: l_forecast_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 297: l_denom_amount PA_PLSQL_DATATYPES.NumTabTyp;

293: l_rcvr_acct_amount PA_PLSQL_DATATYPES.NumTabTyp;
294: l_proj_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
295: l_proj_amount PA_PLSQL_DATATYPES.NumTabTyp;
296: l_denom_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
297: l_denom_amount PA_PLSQL_DATATYPES.NumTabTyp;
298: l_tp_amount_type PA_PLSQL_DATATYPES.Char30TabTyp;
299: l_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;
300: l_forecast_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;
301: l_util_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 298: l_tp_amount_type PA_PLSQL_DATATYPES.Char30TabTyp;

294: l_proj_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
295: l_proj_amount PA_PLSQL_DATATYPES.NumTabTyp;
296: l_denom_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
297: l_denom_amount PA_PLSQL_DATATYPES.NumTabTyp;
298: l_tp_amount_type PA_PLSQL_DATATYPES.Char30TabTyp;
299: l_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;
300: l_forecast_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;
301: l_util_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;
302: l_work_type_id PA_PLSQL_DATATYPES.IdTabTyp;

Line 299: l_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;

295: l_proj_amount PA_PLSQL_DATATYPES.NumTabTyp;
296: l_denom_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
297: l_denom_amount PA_PLSQL_DATATYPES.NumTabTyp;
298: l_tp_amount_type PA_PLSQL_DATATYPES.Char30TabTyp;
299: l_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;
300: l_forecast_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;
301: l_util_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;
302: l_work_type_id PA_PLSQL_DATATYPES.IdTabTyp;
303: l_resource_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;

Line 300: l_forecast_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;

296: l_denom_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
297: l_denom_amount PA_PLSQL_DATATYPES.NumTabTyp;
298: l_tp_amount_type PA_PLSQL_DATATYPES.Char30TabTyp;
299: l_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;
300: l_forecast_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;
301: l_util_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;
302: l_work_type_id PA_PLSQL_DATATYPES.IdTabTyp;
303: l_resource_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;
304: l_org_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;

Line 301: l_util_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;

297: l_denom_amount PA_PLSQL_DATATYPES.NumTabTyp;
298: l_tp_amount_type PA_PLSQL_DATATYPES.Char30TabTyp;
299: l_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;
300: l_forecast_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;
301: l_util_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;
302: l_work_type_id PA_PLSQL_DATATYPES.IdTabTyp;
303: l_resource_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;
304: l_org_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;
305: l_resource_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;

Line 302: l_work_type_id PA_PLSQL_DATATYPES.IdTabTyp;

298: l_tp_amount_type PA_PLSQL_DATATYPES.Char30TabTyp;
299: l_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;
300: l_forecast_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;
301: l_util_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;
302: l_work_type_id PA_PLSQL_DATATYPES.IdTabTyp;
303: l_resource_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;
304: l_org_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;
305: l_resource_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;
306: l_org_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;

Line 303: l_resource_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;

299: l_billable_flag PA_PLSQL_DATATYPES.Char1TabTyp;
300: l_forecast_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;
301: l_util_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;
302: l_work_type_id PA_PLSQL_DATATYPES.IdTabTyp;
303: l_resource_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;
304: l_org_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;
305: l_resource_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;
306: l_org_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;
307: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;

Line 304: l_org_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;

300: l_forecast_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;
301: l_util_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;
302: l_work_type_id PA_PLSQL_DATATYPES.IdTabTyp;
303: l_resource_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;
304: l_org_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;
305: l_resource_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;
306: l_org_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;
307: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;
308: l_reversed_flag PA_PLSQL_DATATYPES.Char1TabTyp;

Line 305: l_resource_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;

301: l_util_summarized_code PA_PLSQL_DATATYPES.Char30TabTyp;
302: l_work_type_id PA_PLSQL_DATATYPES.IdTabTyp;
303: l_resource_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;
304: l_org_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;
305: l_resource_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;
306: l_org_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;
307: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;
308: l_reversed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
309: l_net_zero_flag PA_PLSQL_DATATYPES.Char1TabTyp;

Line 306: l_org_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;

302: l_work_type_id PA_PLSQL_DATATYPES.IdTabTyp;
303: l_resource_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;
304: l_org_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;
305: l_resource_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;
306: l_org_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;
307: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;
308: l_reversed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
309: l_net_zero_flag PA_PLSQL_DATATYPES.Char1TabTyp;
310: l_reduce_capacity_flag PA_PLSQL_DATATYPES.Char1TabTyp;

Line 307: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;

303: l_resource_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;
304: l_org_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;
305: l_resource_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;
306: l_org_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;
307: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;
308: l_reversed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
309: l_net_zero_flag PA_PLSQL_DATATYPES.Char1TabTyp;
310: l_reduce_capacity_flag PA_PLSQL_DATATYPES.Char1TabTyp;
311: l_line_num_reversed PA_PLSQL_DATATYPES.NumTabTyp;

Line 308: l_reversed_flag PA_PLSQL_DATATYPES.Char1TabTyp;

304: l_org_util_category_id PA_PLSQL_DATATYPES.IdTabTyp;
305: l_resource_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;
306: l_org_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;
307: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;
308: l_reversed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
309: l_net_zero_flag PA_PLSQL_DATATYPES.Char1TabTyp;
310: l_reduce_capacity_flag PA_PLSQL_DATATYPES.Char1TabTyp;
311: l_line_num_reversed PA_PLSQL_DATATYPES.NumTabTyp;
312:

Line 309: l_net_zero_flag PA_PLSQL_DATATYPES.Char1TabTyp;

305: l_resource_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;
306: l_org_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;
307: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;
308: l_reversed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
309: l_net_zero_flag PA_PLSQL_DATATYPES.Char1TabTyp;
310: l_reduce_capacity_flag PA_PLSQL_DATATYPES.Char1TabTyp;
311: l_line_num_reversed PA_PLSQL_DATATYPES.NumTabTyp;
312:
313:

Line 310: l_reduce_capacity_flag PA_PLSQL_DATATYPES.Char1TabTyp;

306: l_org_util_weighted PA_PLSQL_DATATYPES.NumTabTyp;
307: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;
308: l_reversed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
309: l_net_zero_flag PA_PLSQL_DATATYPES.Char1TabTyp;
310: l_reduce_capacity_flag PA_PLSQL_DATATYPES.Char1TabTyp;
311: l_line_num_reversed PA_PLSQL_DATATYPES.NumTabTyp;
312:
313:
314: BEGIN

Line 311: l_line_num_reversed PA_PLSQL_DATATYPES.NumTabTyp;

307: l_provisional_flag PA_PLSQL_DATATYPES.Char1TabTyp;
308: l_reversed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
309: l_net_zero_flag PA_PLSQL_DATATYPES.Char1TabTyp;
310: l_reduce_capacity_flag PA_PLSQL_DATATYPES.Char1TabTyp;
311: l_line_num_reversed PA_PLSQL_DATATYPES.NumTabTyp;
312:
313:
314: BEGIN
315: