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_CC_BL_PROCESS dependencies on PA_CC_DIST_LINES_ALL

Line 5: -- Type of information retrieved from pa_cc_dist_lines_all or

1: PACKAGE PA_CC_BL_PROCESS AUTHID CURRENT_USER AS
2: /* $Header: PAXBLPRS.pls 120.1.12010000.3 2008/10/17 05:17:36 abjacob ship $ */
3:
4:
5: -- Type of information retrieved from pa_cc_dist_lines_all or
6: -- expenditure item. A record of this type is defined as opposed to
7: -- defining a %ROWTYPE to take advantage of getting the rowid and
8: -- other attributes that do not belong to the pa_cc_dist_lines_all
9: -- table but to the expenditure item table eliminating the need to

Line 8: -- other attributes that do not belong to the pa_cc_dist_lines_all

4:
5: -- Type of information retrieved from pa_cc_dist_lines_all or
6: -- expenditure item. A record of this type is defined as opposed to
7: -- defining a %ROWTYPE to take advantage of getting the rowid and
8: -- other attributes that do not belong to the pa_cc_dist_lines_all
9: -- table but to the expenditure item table eliminating the need to
10: -- have them re-read the table. The rowid is stored for better
11: -- performance and to avoid hitting the index of an already retrieved
12: -- record (for updates and deletes)

Line 17: expenditure_item_id pa_cc_dist_lines_all.expenditure_item_id%TYPE,

13:
14: TYPE CcdRecType is RECORD (
15: EIRowId rowid,
16: CcdRowId rowid,
17: expenditure_item_id pa_cc_dist_lines_all.expenditure_item_id%TYPE,
18: cc_dist_line_id pa_cc_dist_lines_all.cc_dist_line_id%TYPE,
19: adjusted_exp_item_id pa_expenditure_items_all.adjusted_expenditure_item_id%TYPE,
20: acct_currency_code pa_cc_dist_lines_all.acct_currency_code%TYPE,
21: acct_tp_exchange_rate pa_cc_dist_lines_all.acct_tp_exchange_rate%TYPE,

Line 18: cc_dist_line_id pa_cc_dist_lines_all.cc_dist_line_id%TYPE,

14: TYPE CcdRecType is RECORD (
15: EIRowId rowid,
16: CcdRowId rowid,
17: expenditure_item_id pa_cc_dist_lines_all.expenditure_item_id%TYPE,
18: cc_dist_line_id pa_cc_dist_lines_all.cc_dist_line_id%TYPE,
19: adjusted_exp_item_id pa_expenditure_items_all.adjusted_expenditure_item_id%TYPE,
20: acct_currency_code pa_cc_dist_lines_all.acct_currency_code%TYPE,
21: acct_tp_exchange_rate pa_cc_dist_lines_all.acct_tp_exchange_rate%TYPE,
22: acct_tp_rate_date pa_cc_dist_lines_all.acct_tp_rate_date%TYPE,

Line 20: acct_currency_code pa_cc_dist_lines_all.acct_currency_code%TYPE,

16: CcdRowId rowid,
17: expenditure_item_id pa_cc_dist_lines_all.expenditure_item_id%TYPE,
18: cc_dist_line_id pa_cc_dist_lines_all.cc_dist_line_id%TYPE,
19: adjusted_exp_item_id pa_expenditure_items_all.adjusted_expenditure_item_id%TYPE,
20: acct_currency_code pa_cc_dist_lines_all.acct_currency_code%TYPE,
21: acct_tp_exchange_rate pa_cc_dist_lines_all.acct_tp_exchange_rate%TYPE,
22: acct_tp_rate_date pa_cc_dist_lines_all.acct_tp_rate_date%TYPE,
23: acct_tp_rate_type pa_cc_dist_lines_all.acct_tp_rate_type%TYPE,
24: amount pa_cc_dist_lines_all.amount%TYPE,

Line 21: acct_tp_exchange_rate pa_cc_dist_lines_all.acct_tp_exchange_rate%TYPE,

17: expenditure_item_id pa_cc_dist_lines_all.expenditure_item_id%TYPE,
18: cc_dist_line_id pa_cc_dist_lines_all.cc_dist_line_id%TYPE,
19: adjusted_exp_item_id pa_expenditure_items_all.adjusted_expenditure_item_id%TYPE,
20: acct_currency_code pa_cc_dist_lines_all.acct_currency_code%TYPE,
21: acct_tp_exchange_rate pa_cc_dist_lines_all.acct_tp_exchange_rate%TYPE,
22: acct_tp_rate_date pa_cc_dist_lines_all.acct_tp_rate_date%TYPE,
23: acct_tp_rate_type pa_cc_dist_lines_all.acct_tp_rate_type%TYPE,
24: amount pa_cc_dist_lines_all.amount%TYPE,
25: bill_markup_percentage pa_cc_dist_lines_all.bill_markup_percentage%TYPE,

Line 22: acct_tp_rate_date pa_cc_dist_lines_all.acct_tp_rate_date%TYPE,

18: cc_dist_line_id pa_cc_dist_lines_all.cc_dist_line_id%TYPE,
19: adjusted_exp_item_id pa_expenditure_items_all.adjusted_expenditure_item_id%TYPE,
20: acct_currency_code pa_cc_dist_lines_all.acct_currency_code%TYPE,
21: acct_tp_exchange_rate pa_cc_dist_lines_all.acct_tp_exchange_rate%TYPE,
22: acct_tp_rate_date pa_cc_dist_lines_all.acct_tp_rate_date%TYPE,
23: acct_tp_rate_type pa_cc_dist_lines_all.acct_tp_rate_type%TYPE,
24: amount pa_cc_dist_lines_all.amount%TYPE,
25: bill_markup_percentage pa_cc_dist_lines_all.bill_markup_percentage%TYPE,
26: bill_rate pa_cc_dist_lines_all.bill_rate%TYPE,

Line 23: acct_tp_rate_type pa_cc_dist_lines_all.acct_tp_rate_type%TYPE,

19: adjusted_exp_item_id pa_expenditure_items_all.adjusted_expenditure_item_id%TYPE,
20: acct_currency_code pa_cc_dist_lines_all.acct_currency_code%TYPE,
21: acct_tp_exchange_rate pa_cc_dist_lines_all.acct_tp_exchange_rate%TYPE,
22: acct_tp_rate_date pa_cc_dist_lines_all.acct_tp_rate_date%TYPE,
23: acct_tp_rate_type pa_cc_dist_lines_all.acct_tp_rate_type%TYPE,
24: amount pa_cc_dist_lines_all.amount%TYPE,
25: bill_markup_percentage pa_cc_dist_lines_all.bill_markup_percentage%TYPE,
26: bill_rate pa_cc_dist_lines_all.bill_rate%TYPE,
27: cc_rejection_code pa_expenditure_items_all.cc_rejection_code%TYPE,

Line 24: amount pa_cc_dist_lines_all.amount%TYPE,

20: acct_currency_code pa_cc_dist_lines_all.acct_currency_code%TYPE,
21: acct_tp_exchange_rate pa_cc_dist_lines_all.acct_tp_exchange_rate%TYPE,
22: acct_tp_rate_date pa_cc_dist_lines_all.acct_tp_rate_date%TYPE,
23: acct_tp_rate_type pa_cc_dist_lines_all.acct_tp_rate_type%TYPE,
24: amount pa_cc_dist_lines_all.amount%TYPE,
25: bill_markup_percentage pa_cc_dist_lines_all.bill_markup_percentage%TYPE,
26: bill_rate pa_cc_dist_lines_all.bill_rate%TYPE,
27: cc_rejection_code pa_expenditure_items_all.cc_rejection_code%TYPE,
28: cr_code_combination_id pa_cc_dist_lines_all.cr_code_combination_id%TYPE,

Line 25: bill_markup_percentage pa_cc_dist_lines_all.bill_markup_percentage%TYPE,

21: acct_tp_exchange_rate pa_cc_dist_lines_all.acct_tp_exchange_rate%TYPE,
22: acct_tp_rate_date pa_cc_dist_lines_all.acct_tp_rate_date%TYPE,
23: acct_tp_rate_type pa_cc_dist_lines_all.acct_tp_rate_type%TYPE,
24: amount pa_cc_dist_lines_all.amount%TYPE,
25: bill_markup_percentage pa_cc_dist_lines_all.bill_markup_percentage%TYPE,
26: bill_rate pa_cc_dist_lines_all.bill_rate%TYPE,
27: cc_rejection_code pa_expenditure_items_all.cc_rejection_code%TYPE,
28: cr_code_combination_id pa_cc_dist_lines_all.cr_code_combination_id%TYPE,
29: cross_charge_code pa_cc_dist_lines_all.cross_charge_code%TYPE,

Line 26: bill_rate pa_cc_dist_lines_all.bill_rate%TYPE,

22: acct_tp_rate_date pa_cc_dist_lines_all.acct_tp_rate_date%TYPE,
23: acct_tp_rate_type pa_cc_dist_lines_all.acct_tp_rate_type%TYPE,
24: amount pa_cc_dist_lines_all.amount%TYPE,
25: bill_markup_percentage pa_cc_dist_lines_all.bill_markup_percentage%TYPE,
26: bill_rate pa_cc_dist_lines_all.bill_rate%TYPE,
27: cc_rejection_code pa_expenditure_items_all.cc_rejection_code%TYPE,
28: cr_code_combination_id pa_cc_dist_lines_all.cr_code_combination_id%TYPE,
29: cross_charge_code pa_cc_dist_lines_all.cross_charge_code%TYPE,
30: denom_tp_currency_code pa_cc_dist_lines_all.denom_tp_currency_code%TYPE,

Line 28: cr_code_combination_id pa_cc_dist_lines_all.cr_code_combination_id%TYPE,

24: amount pa_cc_dist_lines_all.amount%TYPE,
25: bill_markup_percentage pa_cc_dist_lines_all.bill_markup_percentage%TYPE,
26: bill_rate pa_cc_dist_lines_all.bill_rate%TYPE,
27: cc_rejection_code pa_expenditure_items_all.cc_rejection_code%TYPE,
28: cr_code_combination_id pa_cc_dist_lines_all.cr_code_combination_id%TYPE,
29: cross_charge_code pa_cc_dist_lines_all.cross_charge_code%TYPE,
30: denom_tp_currency_code pa_cc_dist_lines_all.denom_tp_currency_code%TYPE,
31: denom_transfer_price pa_cc_dist_lines_all.denom_transfer_price%TYPE,
32: dist_line_id_reversed pa_cc_dist_lines_all.dist_line_id_reversed%TYPE,

Line 29: cross_charge_code pa_cc_dist_lines_all.cross_charge_code%TYPE,

25: bill_markup_percentage pa_cc_dist_lines_all.bill_markup_percentage%TYPE,
26: bill_rate pa_cc_dist_lines_all.bill_rate%TYPE,
27: cc_rejection_code pa_expenditure_items_all.cc_rejection_code%TYPE,
28: cr_code_combination_id pa_cc_dist_lines_all.cr_code_combination_id%TYPE,
29: cross_charge_code pa_cc_dist_lines_all.cross_charge_code%TYPE,
30: denom_tp_currency_code pa_cc_dist_lines_all.denom_tp_currency_code%TYPE,
31: denom_transfer_price pa_cc_dist_lines_all.denom_transfer_price%TYPE,
32: dist_line_id_reversed pa_cc_dist_lines_all.dist_line_id_reversed%TYPE,
33: dr_code_combination_id pa_cc_dist_lines_all.dr_code_combination_id%TYPE,

Line 30: denom_tp_currency_code pa_cc_dist_lines_all.denom_tp_currency_code%TYPE,

26: bill_rate pa_cc_dist_lines_all.bill_rate%TYPE,
27: cc_rejection_code pa_expenditure_items_all.cc_rejection_code%TYPE,
28: cr_code_combination_id pa_cc_dist_lines_all.cr_code_combination_id%TYPE,
29: cross_charge_code pa_cc_dist_lines_all.cross_charge_code%TYPE,
30: denom_tp_currency_code pa_cc_dist_lines_all.denom_tp_currency_code%TYPE,
31: denom_transfer_price pa_cc_dist_lines_all.denom_transfer_price%TYPE,
32: dist_line_id_reversed pa_cc_dist_lines_all.dist_line_id_reversed%TYPE,
33: dr_code_combination_id pa_cc_dist_lines_all.dr_code_combination_id%TYPE,
34: expenditure_item_date date,

Line 31: denom_transfer_price pa_cc_dist_lines_all.denom_transfer_price%TYPE,

27: cc_rejection_code pa_expenditure_items_all.cc_rejection_code%TYPE,
28: cr_code_combination_id pa_cc_dist_lines_all.cr_code_combination_id%TYPE,
29: cross_charge_code pa_cc_dist_lines_all.cross_charge_code%TYPE,
30: denom_tp_currency_code pa_cc_dist_lines_all.denom_tp_currency_code%TYPE,
31: denom_transfer_price pa_cc_dist_lines_all.denom_transfer_price%TYPE,
32: dist_line_id_reversed pa_cc_dist_lines_all.dist_line_id_reversed%TYPE,
33: dr_code_combination_id pa_cc_dist_lines_all.dr_code_combination_id%TYPE,
34: expenditure_item_date date,
35: ind_compiled_set_id pa_cc_dist_lines_all.ind_compiled_set_id%TYPE,

Line 32: dist_line_id_reversed pa_cc_dist_lines_all.dist_line_id_reversed%TYPE,

28: cr_code_combination_id pa_cc_dist_lines_all.cr_code_combination_id%TYPE,
29: cross_charge_code pa_cc_dist_lines_all.cross_charge_code%TYPE,
30: denom_tp_currency_code pa_cc_dist_lines_all.denom_tp_currency_code%TYPE,
31: denom_transfer_price pa_cc_dist_lines_all.denom_transfer_price%TYPE,
32: dist_line_id_reversed pa_cc_dist_lines_all.dist_line_id_reversed%TYPE,
33: dr_code_combination_id pa_cc_dist_lines_all.dr_code_combination_id%TYPE,
34: expenditure_item_date date,
35: ind_compiled_set_id pa_cc_dist_lines_all.ind_compiled_set_id%TYPE,
36: line_num pa_cc_dist_lines_all.line_num%TYPE,

Line 33: dr_code_combination_id pa_cc_dist_lines_all.dr_code_combination_id%TYPE,

29: cross_charge_code pa_cc_dist_lines_all.cross_charge_code%TYPE,
30: denom_tp_currency_code pa_cc_dist_lines_all.denom_tp_currency_code%TYPE,
31: denom_transfer_price pa_cc_dist_lines_all.denom_transfer_price%TYPE,
32: dist_line_id_reversed pa_cc_dist_lines_all.dist_line_id_reversed%TYPE,
33: dr_code_combination_id pa_cc_dist_lines_all.dr_code_combination_id%TYPE,
34: expenditure_item_date date,
35: ind_compiled_set_id pa_cc_dist_lines_all.ind_compiled_set_id%TYPE,
36: line_num pa_cc_dist_lines_all.line_num%TYPE,
37: line_num_reversed pa_cc_dist_lines_all.line_num_reversed%TYPE,

Line 35: ind_compiled_set_id pa_cc_dist_lines_all.ind_compiled_set_id%TYPE,

31: denom_transfer_price pa_cc_dist_lines_all.denom_transfer_price%TYPE,
32: dist_line_id_reversed pa_cc_dist_lines_all.dist_line_id_reversed%TYPE,
33: dr_code_combination_id pa_cc_dist_lines_all.dr_code_combination_id%TYPE,
34: expenditure_item_date date,
35: ind_compiled_set_id pa_cc_dist_lines_all.ind_compiled_set_id%TYPE,
36: line_num pa_cc_dist_lines_all.line_num%TYPE,
37: line_num_reversed pa_cc_dist_lines_all.line_num_reversed%TYPE,
38: line_type pa_cc_dist_lines_all.line_type%TYPE,
39: markup_calc_base_code pa_cc_dist_lines_all.markup_calc_base_code%TYPE,

Line 36: line_num pa_cc_dist_lines_all.line_num%TYPE,

32: dist_line_id_reversed pa_cc_dist_lines_all.dist_line_id_reversed%TYPE,
33: dr_code_combination_id pa_cc_dist_lines_all.dr_code_combination_id%TYPE,
34: expenditure_item_date date,
35: ind_compiled_set_id pa_cc_dist_lines_all.ind_compiled_set_id%TYPE,
36: line_num pa_cc_dist_lines_all.line_num%TYPE,
37: line_num_reversed pa_cc_dist_lines_all.line_num_reversed%TYPE,
38: line_type pa_cc_dist_lines_all.line_type%TYPE,
39: markup_calc_base_code pa_cc_dist_lines_all.markup_calc_base_code%TYPE,
40: pa_date pa_cc_dist_lines_all.pa_date%TYPE,

Line 37: line_num_reversed pa_cc_dist_lines_all.line_num_reversed%TYPE,

33: dr_code_combination_id pa_cc_dist_lines_all.dr_code_combination_id%TYPE,
34: expenditure_item_date date,
35: ind_compiled_set_id pa_cc_dist_lines_all.ind_compiled_set_id%TYPE,
36: line_num pa_cc_dist_lines_all.line_num%TYPE,
37: line_num_reversed pa_cc_dist_lines_all.line_num_reversed%TYPE,
38: line_type pa_cc_dist_lines_all.line_type%TYPE,
39: markup_calc_base_code pa_cc_dist_lines_all.markup_calc_base_code%TYPE,
40: pa_date pa_cc_dist_lines_all.pa_date%TYPE,
41: gl_date pa_cc_dist_lines_all.gl_date%TYPE, /* EPP */

Line 38: line_type pa_cc_dist_lines_all.line_type%TYPE,

34: expenditure_item_date date,
35: ind_compiled_set_id pa_cc_dist_lines_all.ind_compiled_set_id%TYPE,
36: line_num pa_cc_dist_lines_all.line_num%TYPE,
37: line_num_reversed pa_cc_dist_lines_all.line_num_reversed%TYPE,
38: line_type pa_cc_dist_lines_all.line_type%TYPE,
39: markup_calc_base_code pa_cc_dist_lines_all.markup_calc_base_code%TYPE,
40: pa_date pa_cc_dist_lines_all.pa_date%TYPE,
41: gl_date pa_cc_dist_lines_all.gl_date%TYPE, /* EPP */
42: pa_period_name pa_cc_dist_lines_all.pa_period_name%TYPE, /* EPP */

Line 39: markup_calc_base_code pa_cc_dist_lines_all.markup_calc_base_code%TYPE,

35: ind_compiled_set_id pa_cc_dist_lines_all.ind_compiled_set_id%TYPE,
36: line_num pa_cc_dist_lines_all.line_num%TYPE,
37: line_num_reversed pa_cc_dist_lines_all.line_num_reversed%TYPE,
38: line_type pa_cc_dist_lines_all.line_type%TYPE,
39: markup_calc_base_code pa_cc_dist_lines_all.markup_calc_base_code%TYPE,
40: pa_date pa_cc_dist_lines_all.pa_date%TYPE,
41: gl_date pa_cc_dist_lines_all.gl_date%TYPE, /* EPP */
42: pa_period_name pa_cc_dist_lines_all.pa_period_name%TYPE, /* EPP */
43: gl_period_name pa_cc_dist_lines_all.gl_period_name%TYPE, /* EPP */

Line 40: pa_date pa_cc_dist_lines_all.pa_date%TYPE,

36: line_num pa_cc_dist_lines_all.line_num%TYPE,
37: line_num_reversed pa_cc_dist_lines_all.line_num_reversed%TYPE,
38: line_type pa_cc_dist_lines_all.line_type%TYPE,
39: markup_calc_base_code pa_cc_dist_lines_all.markup_calc_base_code%TYPE,
40: pa_date pa_cc_dist_lines_all.pa_date%TYPE,
41: gl_date pa_cc_dist_lines_all.gl_date%TYPE, /* EPP */
42: pa_period_name pa_cc_dist_lines_all.pa_period_name%TYPE, /* EPP */
43: gl_period_name pa_cc_dist_lines_all.gl_period_name%TYPE, /* EPP */
44: project_id pa_cc_dist_lines_all.project_id%TYPE,

Line 41: gl_date pa_cc_dist_lines_all.gl_date%TYPE, /* EPP */

37: line_num_reversed pa_cc_dist_lines_all.line_num_reversed%TYPE,
38: line_type pa_cc_dist_lines_all.line_type%TYPE,
39: markup_calc_base_code pa_cc_dist_lines_all.markup_calc_base_code%TYPE,
40: pa_date pa_cc_dist_lines_all.pa_date%TYPE,
41: gl_date pa_cc_dist_lines_all.gl_date%TYPE, /* EPP */
42: pa_period_name pa_cc_dist_lines_all.pa_period_name%TYPE, /* EPP */
43: gl_period_name pa_cc_dist_lines_all.gl_period_name%TYPE, /* EPP */
44: project_id pa_cc_dist_lines_all.project_id%TYPE,
45: reversed_flag pa_cc_dist_lines_all.reversed_flag%TYPE,

Line 42: pa_period_name pa_cc_dist_lines_all.pa_period_name%TYPE, /* EPP */

38: line_type pa_cc_dist_lines_all.line_type%TYPE,
39: markup_calc_base_code pa_cc_dist_lines_all.markup_calc_base_code%TYPE,
40: pa_date pa_cc_dist_lines_all.pa_date%TYPE,
41: gl_date pa_cc_dist_lines_all.gl_date%TYPE, /* EPP */
42: pa_period_name pa_cc_dist_lines_all.pa_period_name%TYPE, /* EPP */
43: gl_period_name pa_cc_dist_lines_all.gl_period_name%TYPE, /* EPP */
44: project_id pa_cc_dist_lines_all.project_id%TYPE,
45: reversed_flag pa_cc_dist_lines_all.reversed_flag%TYPE,
46: rule_percentage pa_cc_dist_lines_all.rule_percentage%TYPE,

Line 43: gl_period_name pa_cc_dist_lines_all.gl_period_name%TYPE, /* EPP */

39: markup_calc_base_code pa_cc_dist_lines_all.markup_calc_base_code%TYPE,
40: pa_date pa_cc_dist_lines_all.pa_date%TYPE,
41: gl_date pa_cc_dist_lines_all.gl_date%TYPE, /* EPP */
42: pa_period_name pa_cc_dist_lines_all.pa_period_name%TYPE, /* EPP */
43: gl_period_name pa_cc_dist_lines_all.gl_period_name%TYPE, /* EPP */
44: project_id pa_cc_dist_lines_all.project_id%TYPE,
45: reversed_flag pa_cc_dist_lines_all.reversed_flag%TYPE,
46: rule_percentage pa_cc_dist_lines_all.rule_percentage%TYPE,
47: schedule_line_percentage pa_cc_dist_lines_all.schedule_line_percentage%TYPE,

Line 44: project_id pa_cc_dist_lines_all.project_id%TYPE,

40: pa_date pa_cc_dist_lines_all.pa_date%TYPE,
41: gl_date pa_cc_dist_lines_all.gl_date%TYPE, /* EPP */
42: pa_period_name pa_cc_dist_lines_all.pa_period_name%TYPE, /* EPP */
43: gl_period_name pa_cc_dist_lines_all.gl_period_name%TYPE, /* EPP */
44: project_id pa_cc_dist_lines_all.project_id%TYPE,
45: reversed_flag pa_cc_dist_lines_all.reversed_flag%TYPE,
46: rule_percentage pa_cc_dist_lines_all.rule_percentage%TYPE,
47: schedule_line_percentage pa_cc_dist_lines_all.schedule_line_percentage%TYPE,
48: task_id pa_cc_dist_lines_all.task_id%TYPE,

Line 45: reversed_flag pa_cc_dist_lines_all.reversed_flag%TYPE,

41: gl_date pa_cc_dist_lines_all.gl_date%TYPE, /* EPP */
42: pa_period_name pa_cc_dist_lines_all.pa_period_name%TYPE, /* EPP */
43: gl_period_name pa_cc_dist_lines_all.gl_period_name%TYPE, /* EPP */
44: project_id pa_cc_dist_lines_all.project_id%TYPE,
45: reversed_flag pa_cc_dist_lines_all.reversed_flag%TYPE,
46: rule_percentage pa_cc_dist_lines_all.rule_percentage%TYPE,
47: schedule_line_percentage pa_cc_dist_lines_all.schedule_line_percentage%TYPE,
48: task_id pa_cc_dist_lines_all.task_id%TYPE,
49: tp_base_amount pa_cc_dist_lines_all.tp_base_amount%TYPE,

Line 46: rule_percentage pa_cc_dist_lines_all.rule_percentage%TYPE,

42: pa_period_name pa_cc_dist_lines_all.pa_period_name%TYPE, /* EPP */
43: gl_period_name pa_cc_dist_lines_all.gl_period_name%TYPE, /* EPP */
44: project_id pa_cc_dist_lines_all.project_id%TYPE,
45: reversed_flag pa_cc_dist_lines_all.reversed_flag%TYPE,
46: rule_percentage pa_cc_dist_lines_all.rule_percentage%TYPE,
47: schedule_line_percentage pa_cc_dist_lines_all.schedule_line_percentage%TYPE,
48: task_id pa_cc_dist_lines_all.task_id%TYPE,
49: tp_base_amount pa_cc_dist_lines_all.tp_base_amount%TYPE,
50: tp_job_id pa_cc_dist_lines_all.tp_job_id%TYPE,

Line 47: schedule_line_percentage pa_cc_dist_lines_all.schedule_line_percentage%TYPE,

43: gl_period_name pa_cc_dist_lines_all.gl_period_name%TYPE, /* EPP */
44: project_id pa_cc_dist_lines_all.project_id%TYPE,
45: reversed_flag pa_cc_dist_lines_all.reversed_flag%TYPE,
46: rule_percentage pa_cc_dist_lines_all.rule_percentage%TYPE,
47: schedule_line_percentage pa_cc_dist_lines_all.schedule_line_percentage%TYPE,
48: task_id pa_cc_dist_lines_all.task_id%TYPE,
49: tp_base_amount pa_cc_dist_lines_all.tp_base_amount%TYPE,
50: tp_job_id pa_cc_dist_lines_all.tp_job_id%TYPE,
51: upd_type VARCHAR2(1),

Line 48: task_id pa_cc_dist_lines_all.task_id%TYPE,

44: project_id pa_cc_dist_lines_all.project_id%TYPE,
45: reversed_flag pa_cc_dist_lines_all.reversed_flag%TYPE,
46: rule_percentage pa_cc_dist_lines_all.rule_percentage%TYPE,
47: schedule_line_percentage pa_cc_dist_lines_all.schedule_line_percentage%TYPE,
48: task_id pa_cc_dist_lines_all.task_id%TYPE,
49: tp_base_amount pa_cc_dist_lines_all.tp_base_amount%TYPE,
50: tp_job_id pa_cc_dist_lines_all.tp_job_id%TYPE,
51: upd_type VARCHAR2(1),
52: reference_1 pa_cc_dist_lines_all.reference_1%TYPE,

Line 49: tp_base_amount pa_cc_dist_lines_all.tp_base_amount%TYPE,

45: reversed_flag pa_cc_dist_lines_all.reversed_flag%TYPE,
46: rule_percentage pa_cc_dist_lines_all.rule_percentage%TYPE,
47: schedule_line_percentage pa_cc_dist_lines_all.schedule_line_percentage%TYPE,
48: task_id pa_cc_dist_lines_all.task_id%TYPE,
49: tp_base_amount pa_cc_dist_lines_all.tp_base_amount%TYPE,
50: tp_job_id pa_cc_dist_lines_all.tp_job_id%TYPE,
51: upd_type VARCHAR2(1),
52: reference_1 pa_cc_dist_lines_all.reference_1%TYPE,
53: reference_2 pa_cc_dist_lines_all.reference_2%TYPE,

Line 50: tp_job_id pa_cc_dist_lines_all.tp_job_id%TYPE,

46: rule_percentage pa_cc_dist_lines_all.rule_percentage%TYPE,
47: schedule_line_percentage pa_cc_dist_lines_all.schedule_line_percentage%TYPE,
48: task_id pa_cc_dist_lines_all.task_id%TYPE,
49: tp_base_amount pa_cc_dist_lines_all.tp_base_amount%TYPE,
50: tp_job_id pa_cc_dist_lines_all.tp_job_id%TYPE,
51: upd_type VARCHAR2(1),
52: reference_1 pa_cc_dist_lines_all.reference_1%TYPE,
53: reference_2 pa_cc_dist_lines_all.reference_2%TYPE,
54: reference_3 pa_cc_dist_lines_all.reference_3%TYPE,

Line 52: reference_1 pa_cc_dist_lines_all.reference_1%TYPE,

48: task_id pa_cc_dist_lines_all.task_id%TYPE,
49: tp_base_amount pa_cc_dist_lines_all.tp_base_amount%TYPE,
50: tp_job_id pa_cc_dist_lines_all.tp_job_id%TYPE,
51: upd_type VARCHAR2(1),
52: reference_1 pa_cc_dist_lines_all.reference_1%TYPE,
53: reference_2 pa_cc_dist_lines_all.reference_2%TYPE,
54: reference_3 pa_cc_dist_lines_all.reference_3%TYPE,
55:
56: /* Added for cross proj*/

Line 53: reference_2 pa_cc_dist_lines_all.reference_2%TYPE,

49: tp_base_amount pa_cc_dist_lines_all.tp_base_amount%TYPE,
50: tp_job_id pa_cc_dist_lines_all.tp_job_id%TYPE,
51: upd_type VARCHAR2(1),
52: reference_1 pa_cc_dist_lines_all.reference_1%TYPE,
53: reference_2 pa_cc_dist_lines_all.reference_2%TYPE,
54: reference_3 pa_cc_dist_lines_all.reference_3%TYPE,
55:
56: /* Added for cross proj*/
57: tp_amt_type_code pa_cc_dist_lines_all.tp_amt_type_code%TYPE ,

Line 54: reference_3 pa_cc_dist_lines_all.reference_3%TYPE,

50: tp_job_id pa_cc_dist_lines_all.tp_job_id%TYPE,
51: upd_type VARCHAR2(1),
52: reference_1 pa_cc_dist_lines_all.reference_1%TYPE,
53: reference_2 pa_cc_dist_lines_all.reference_2%TYPE,
54: reference_3 pa_cc_dist_lines_all.reference_3%TYPE,
55:
56: /* Added for cross proj*/
57: tp_amt_type_code pa_cc_dist_lines_all.tp_amt_type_code%TYPE ,
58: project_tp_rate_type pa_cc_dist_lines_all.project_tp_rate_type%TYPE,

Line 57: tp_amt_type_code pa_cc_dist_lines_all.tp_amt_type_code%TYPE ,

53: reference_2 pa_cc_dist_lines_all.reference_2%TYPE,
54: reference_3 pa_cc_dist_lines_all.reference_3%TYPE,
55:
56: /* Added for cross proj*/
57: tp_amt_type_code pa_cc_dist_lines_all.tp_amt_type_code%TYPE ,
58: project_tp_rate_type pa_cc_dist_lines_all.project_tp_rate_type%TYPE,
59: project_tp_rate_date pa_cc_dist_lines_all.project_tp_rate_date%TYPE,
60: project_tp_exchange_rate pa_cc_dist_lines_all.project_tp_exchange_rate%TYPE,
61: project_transfer_price pa_cc_dist_lines_all.project_transfer_price%TYPE,

Line 58: project_tp_rate_type pa_cc_dist_lines_all.project_tp_rate_type%TYPE,

54: reference_3 pa_cc_dist_lines_all.reference_3%TYPE,
55:
56: /* Added for cross proj*/
57: tp_amt_type_code pa_cc_dist_lines_all.tp_amt_type_code%TYPE ,
58: project_tp_rate_type pa_cc_dist_lines_all.project_tp_rate_type%TYPE,
59: project_tp_rate_date pa_cc_dist_lines_all.project_tp_rate_date%TYPE,
60: project_tp_exchange_rate pa_cc_dist_lines_all.project_tp_exchange_rate%TYPE,
61: project_transfer_price pa_cc_dist_lines_all.project_transfer_price%TYPE,
62: projfunc_tp_rate_type pa_cc_dist_lines_all.projfunc_tp_rate_type%TYPE,

Line 59: project_tp_rate_date pa_cc_dist_lines_all.project_tp_rate_date%TYPE,

55:
56: /* Added for cross proj*/
57: tp_amt_type_code pa_cc_dist_lines_all.tp_amt_type_code%TYPE ,
58: project_tp_rate_type pa_cc_dist_lines_all.project_tp_rate_type%TYPE,
59: project_tp_rate_date pa_cc_dist_lines_all.project_tp_rate_date%TYPE,
60: project_tp_exchange_rate pa_cc_dist_lines_all.project_tp_exchange_rate%TYPE,
61: project_transfer_price pa_cc_dist_lines_all.project_transfer_price%TYPE,
62: projfunc_tp_rate_type pa_cc_dist_lines_all.projfunc_tp_rate_type%TYPE,
63: projfunc_tp_rate_date pa_cc_dist_lines_all.projfunc_tp_rate_date%TYPE,

Line 60: project_tp_exchange_rate pa_cc_dist_lines_all.project_tp_exchange_rate%TYPE,

56: /* Added for cross proj*/
57: tp_amt_type_code pa_cc_dist_lines_all.tp_amt_type_code%TYPE ,
58: project_tp_rate_type pa_cc_dist_lines_all.project_tp_rate_type%TYPE,
59: project_tp_rate_date pa_cc_dist_lines_all.project_tp_rate_date%TYPE,
60: project_tp_exchange_rate pa_cc_dist_lines_all.project_tp_exchange_rate%TYPE,
61: project_transfer_price pa_cc_dist_lines_all.project_transfer_price%TYPE,
62: projfunc_tp_rate_type pa_cc_dist_lines_all.projfunc_tp_rate_type%TYPE,
63: projfunc_tp_rate_date pa_cc_dist_lines_all.projfunc_tp_rate_date%TYPE,
64: projfunc_tp_exchange_rate pa_cc_dist_lines_all.projfunc_tp_exchange_rate%TYPE,

Line 61: project_transfer_price pa_cc_dist_lines_all.project_transfer_price%TYPE,

57: tp_amt_type_code pa_cc_dist_lines_all.tp_amt_type_code%TYPE ,
58: project_tp_rate_type pa_cc_dist_lines_all.project_tp_rate_type%TYPE,
59: project_tp_rate_date pa_cc_dist_lines_all.project_tp_rate_date%TYPE,
60: project_tp_exchange_rate pa_cc_dist_lines_all.project_tp_exchange_rate%TYPE,
61: project_transfer_price pa_cc_dist_lines_all.project_transfer_price%TYPE,
62: projfunc_tp_rate_type pa_cc_dist_lines_all.projfunc_tp_rate_type%TYPE,
63: projfunc_tp_rate_date pa_cc_dist_lines_all.projfunc_tp_rate_date%TYPE,
64: projfunc_tp_exchange_rate pa_cc_dist_lines_all.projfunc_tp_exchange_rate%TYPE,
65: projfunc_transfer_price pa_cc_dist_lines_all.projfunc_transfer_price%TYPE,

Line 62: projfunc_tp_rate_type pa_cc_dist_lines_all.projfunc_tp_rate_type%TYPE,

58: project_tp_rate_type pa_cc_dist_lines_all.project_tp_rate_type%TYPE,
59: project_tp_rate_date pa_cc_dist_lines_all.project_tp_rate_date%TYPE,
60: project_tp_exchange_rate pa_cc_dist_lines_all.project_tp_exchange_rate%TYPE,
61: project_transfer_price pa_cc_dist_lines_all.project_transfer_price%TYPE,
62: projfunc_tp_rate_type pa_cc_dist_lines_all.projfunc_tp_rate_type%TYPE,
63: projfunc_tp_rate_date pa_cc_dist_lines_all.projfunc_tp_rate_date%TYPE,
64: projfunc_tp_exchange_rate pa_cc_dist_lines_all.projfunc_tp_exchange_rate%TYPE,
65: projfunc_transfer_price pa_cc_dist_lines_all.projfunc_transfer_price%TYPE,
66:

Line 63: projfunc_tp_rate_date pa_cc_dist_lines_all.projfunc_tp_rate_date%TYPE,

59: project_tp_rate_date pa_cc_dist_lines_all.project_tp_rate_date%TYPE,
60: project_tp_exchange_rate pa_cc_dist_lines_all.project_tp_exchange_rate%TYPE,
61: project_transfer_price pa_cc_dist_lines_all.project_transfer_price%TYPE,
62: projfunc_tp_rate_type pa_cc_dist_lines_all.projfunc_tp_rate_type%TYPE,
63: projfunc_tp_rate_date pa_cc_dist_lines_all.projfunc_tp_rate_date%TYPE,
64: projfunc_tp_exchange_rate pa_cc_dist_lines_all.projfunc_tp_exchange_rate%TYPE,
65: projfunc_transfer_price pa_cc_dist_lines_all.projfunc_transfer_price%TYPE,
66:
67: project_tp_currency_code pa_cc_dist_lines_all.project_tp_currency_code%TYPE,

Line 64: projfunc_tp_exchange_rate pa_cc_dist_lines_all.projfunc_tp_exchange_rate%TYPE,

60: project_tp_exchange_rate pa_cc_dist_lines_all.project_tp_exchange_rate%TYPE,
61: project_transfer_price pa_cc_dist_lines_all.project_transfer_price%TYPE,
62: projfunc_tp_rate_type pa_cc_dist_lines_all.projfunc_tp_rate_type%TYPE,
63: projfunc_tp_rate_date pa_cc_dist_lines_all.projfunc_tp_rate_date%TYPE,
64: projfunc_tp_exchange_rate pa_cc_dist_lines_all.projfunc_tp_exchange_rate%TYPE,
65: projfunc_transfer_price pa_cc_dist_lines_all.projfunc_transfer_price%TYPE,
66:
67: project_tp_currency_code pa_cc_dist_lines_all.project_tp_currency_code%TYPE,
68: projfunc_tp_currency_code pa_cc_dist_lines_all.projfunc_tp_currency_code%TYPE

Line 65: projfunc_transfer_price pa_cc_dist_lines_all.projfunc_transfer_price%TYPE,

61: project_transfer_price pa_cc_dist_lines_all.project_transfer_price%TYPE,
62: projfunc_tp_rate_type pa_cc_dist_lines_all.projfunc_tp_rate_type%TYPE,
63: projfunc_tp_rate_date pa_cc_dist_lines_all.projfunc_tp_rate_date%TYPE,
64: projfunc_tp_exchange_rate pa_cc_dist_lines_all.projfunc_tp_exchange_rate%TYPE,
65: projfunc_transfer_price pa_cc_dist_lines_all.projfunc_transfer_price%TYPE,
66:
67: project_tp_currency_code pa_cc_dist_lines_all.project_tp_currency_code%TYPE,
68: projfunc_tp_currency_code pa_cc_dist_lines_all.projfunc_tp_currency_code%TYPE
69: /* End for cross proj*/

Line 67: project_tp_currency_code pa_cc_dist_lines_all.project_tp_currency_code%TYPE,

63: projfunc_tp_rate_date pa_cc_dist_lines_all.projfunc_tp_rate_date%TYPE,
64: projfunc_tp_exchange_rate pa_cc_dist_lines_all.projfunc_tp_exchange_rate%TYPE,
65: projfunc_transfer_price pa_cc_dist_lines_all.projfunc_transfer_price%TYPE,
66:
67: project_tp_currency_code pa_cc_dist_lines_all.project_tp_currency_code%TYPE,
68: projfunc_tp_currency_code pa_cc_dist_lines_all.projfunc_tp_currency_code%TYPE
69: /* End for cross proj*/
70:
71: );

Line 68: projfunc_tp_currency_code pa_cc_dist_lines_all.projfunc_tp_currency_code%TYPE

64: projfunc_tp_exchange_rate pa_cc_dist_lines_all.projfunc_tp_exchange_rate%TYPE,
65: projfunc_transfer_price pa_cc_dist_lines_all.projfunc_transfer_price%TYPE,
66:
67: project_tp_currency_code pa_cc_dist_lines_all.project_tp_currency_code%TYPE,
68: projfunc_tp_currency_code pa_cc_dist_lines_all.projfunc_tp_currency_code%TYPE
69: /* End for cross proj*/
70:
71: );
72:

Line 85: cc_dist_line_id pa_cc_dist_lines_all.cc_dist_line_id%TYPE

81:
82: TYPE DelRecType IS RECORD
83: (
84: CcdRowId rowid,
85: cc_dist_line_id pa_cc_dist_lines_all.cc_dist_line_id%TYPE
86: );
87:
88: -- Declare a type for the table of delete record type
89: TYPE DelTabType IS TABLE OF DelRecType