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_UTILS2 dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 27: g_prvdr_org_id pa_cost_distribution_lines_all.org_id%TYPE;

23: */
24: /*
25: * Provider.
26: */
27: g_prvdr_org_id pa_cost_distribution_lines_all.org_id%TYPE;
28: g_p_earliest_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
29: g_p_earliest_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
30: g_p_earliest_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
31:

Line 28: g_p_earliest_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;

24: /*
25: * Provider.
26: */
27: g_prvdr_org_id pa_cost_distribution_lines_all.org_id%TYPE;
28: g_p_earliest_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
29: g_p_earliest_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
30: g_p_earliest_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
31:
32: g_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;

Line 29: g_p_earliest_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;

25: * Provider.
26: */
27: g_prvdr_org_id pa_cost_distribution_lines_all.org_id%TYPE;
28: g_p_earliest_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
29: g_p_earliest_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
30: g_p_earliest_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
31:
32: g_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
33: g_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;

Line 30: g_p_earliest_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;

26: */
27: g_prvdr_org_id pa_cost_distribution_lines_all.org_id%TYPE;
28: g_p_earliest_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
29: g_p_earliest_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
30: g_p_earliest_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
31:
32: g_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
33: g_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
34: g_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE;

Line 32: g_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;

28: g_p_earliest_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
29: g_p_earliest_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
30: g_p_earliest_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
31:
32: g_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
33: g_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
34: g_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE;
35: g_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
36:

Line 33: g_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;

29: g_p_earliest_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
30: g_p_earliest_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
31:
32: g_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
33: g_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
34: g_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE;
35: g_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
36:
37: /*

Line 34: g_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE;

30: g_p_earliest_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
31:
32: g_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
33: g_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
34: g_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE;
35: g_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
36:
37: /*
38: * Receiver.

Line 35: g_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;

31:
32: g_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
33: g_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
34: g_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE;
35: g_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
36:
37: /*
38: * Receiver.
39: */

Line 40: g_recvr_org_id pa_cost_distribution_lines_all.org_id%TYPE;

36:
37: /*
38: * Receiver.
39: */
40: g_recvr_org_id pa_cost_distribution_lines_all.org_id%TYPE;
41: g_r_earliest_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
42: g_r_earliest_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
43: g_r_earliest_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
44:

Line 41: g_r_earliest_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;

37: /*
38: * Receiver.
39: */
40: g_recvr_org_id pa_cost_distribution_lines_all.org_id%TYPE;
41: g_r_earliest_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
42: g_r_earliest_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
43: g_r_earliest_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
44:
45: g_recvr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;

Line 42: g_r_earliest_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;

38: * Receiver.
39: */
40: g_recvr_org_id pa_cost_distribution_lines_all.org_id%TYPE;
41: g_r_earliest_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
42: g_r_earliest_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
43: g_r_earliest_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
44:
45: g_recvr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
46: g_recvr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;

Line 43: g_r_earliest_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;

39: */
40: g_recvr_org_id pa_cost_distribution_lines_all.org_id%TYPE;
41: g_r_earliest_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
42: g_r_earliest_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
43: g_r_earliest_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
44:
45: g_recvr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
46: g_recvr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
47: g_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE;

Line 45: g_recvr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;

41: g_r_earliest_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
42: g_r_earliest_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
43: g_r_earliest_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
44:
45: g_recvr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
46: g_recvr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
47: g_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE;
48: g_recvr_pa_period_name pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
49:

Line 46: g_recvr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;

42: g_r_earliest_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
43: g_r_earliest_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
44:
45: g_recvr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
46: g_recvr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
47: g_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE;
48: g_recvr_pa_period_name pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
49:
50: G_Business_Group_Id NUMBER;

Line 47: g_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE;

43: g_r_earliest_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
44:
45: g_recvr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
46: g_recvr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
47: g_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE;
48: g_recvr_pa_period_name pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
49:
50: G_Business_Group_Id NUMBER;
51: G_Return_Status VARCHAR2(30);

Line 48: g_recvr_pa_period_name pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;

44:
45: g_recvr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
46: g_recvr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
47: g_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE;
48: g_recvr_pa_period_name pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
49:
50: G_Business_Group_Id NUMBER;
51: G_Return_Status VARCHAR2(30);
52:

Line 56: g_p_earliest_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;

52:
53: /*
54: * Provider.
55: */
56: g_p_earliest_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
57: g_p_earliest_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
58: g_p_earliest_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
59:
60: g_prvdr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;

Line 57: g_p_earliest_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;

53: /*
54: * Provider.
55: */
56: g_p_earliest_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
57: g_p_earliest_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
58: g_p_earliest_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
59:
60: g_prvdr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
61: g_prvdr_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;

Line 58: g_p_earliest_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;

54: * Provider.
55: */
56: g_p_earliest_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
57: g_p_earliest_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
58: g_p_earliest_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
59:
60: g_prvdr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
61: g_prvdr_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
62: g_prvdr_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;

Line 61: g_prvdr_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;

57: g_p_earliest_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
58: g_p_earliest_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
59:
60: g_prvdr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
61: g_prvdr_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
62: g_prvdr_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
63: g_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;
64: g_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;
65:

Line 62: g_prvdr_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;

58: g_p_earliest_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
59:
60: g_prvdr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
61: g_prvdr_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
62: g_prvdr_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
63: g_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;
64: g_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;
65:
66: /*

Line 63: g_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;

59:
60: g_prvdr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
61: g_prvdr_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
62: g_prvdr_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
63: g_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;
64: g_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;
65:
66: /*
67: * Receiver.

Line 64: g_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;

60: g_prvdr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
61: g_prvdr_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
62: g_prvdr_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
63: g_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;
64: g_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;
65:
66: /*
67: * Receiver.
68: */

Line 69: g_r_earliest_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;

65:
66: /*
67: * Receiver.
68: */
69: g_r_earliest_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
70: g_r_earliest_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
71: g_r_earliest_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
72:
73: g_recvr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;

Line 70: g_r_earliest_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;

66: /*
67: * Receiver.
68: */
69: g_r_earliest_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
70: g_r_earliest_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
71: g_r_earliest_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
72:
73: g_recvr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
74: g_recvr_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;

Line 71: g_r_earliest_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;

67: * Receiver.
68: */
69: g_r_earliest_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
70: g_r_earliest_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
71: g_r_earliest_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
72:
73: g_recvr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
74: g_recvr_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
75: g_recvr_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;

Line 74: g_recvr_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;

70: g_r_earliest_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
71: g_r_earliest_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
72:
73: g_recvr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
74: g_recvr_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
75: g_recvr_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
76: g_recvr_gl_period_name pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE ;
77: g_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;
78:

Line 75: g_recvr_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;

71: g_r_earliest_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
72:
73: g_recvr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
74: g_recvr_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
75: g_recvr_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
76: g_recvr_gl_period_name pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE ;
77: g_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;
78:
79: /*

Line 76: g_recvr_gl_period_name pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE ;

72:
73: g_recvr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
74: g_recvr_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
75: g_recvr_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
76: g_recvr_gl_period_name pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE ;
77: g_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;
78:
79: /*
80: * EPP.

Line 77: g_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;

73: g_recvr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
74: g_recvr_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
75: g_recvr_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
76: g_recvr_gl_period_name pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE ;
77: g_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;
78:
79: /*
80: * EPP.
81: */

Line 83: g_prev_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;

79: /*
80: * EPP.
81: */
82: g_prev_expenditure_id pa_expenditure_items_all.expenditure_id%TYPE;
83: g_prev_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;
84: g_prev_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
85: g_prev_recvr_gl_period_name pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;
86: g_prev_recvr_gl_date pa_cost_distribution_lines_all.recvr_gl_date%TYPE;
87:

Line 84: g_prev_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;

80: * EPP.
81: */
82: g_prev_expenditure_id pa_expenditure_items_all.expenditure_id%TYPE;
83: g_prev_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;
84: g_prev_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
85: g_prev_recvr_gl_period_name pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;
86: g_prev_recvr_gl_date pa_cost_distribution_lines_all.recvr_gl_date%TYPE;
87:
88: /*

Line 85: g_prev_recvr_gl_period_name pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;

81: */
82: g_prev_expenditure_id pa_expenditure_items_all.expenditure_id%TYPE;
83: g_prev_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;
84: g_prev_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
85: g_prev_recvr_gl_period_name pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;
86: g_prev_recvr_gl_date pa_cost_distribution_lines_all.recvr_gl_date%TYPE;
87:
88: /*
89: * These global variables are used by function get_gl_period_name.

Line 86: g_prev_recvr_gl_date pa_cost_distribution_lines_all.recvr_gl_date%TYPE;

82: g_prev_expenditure_id pa_expenditure_items_all.expenditure_id%TYPE;
83: g_prev_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;
84: g_prev_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
85: g_prev_recvr_gl_period_name pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;
86: g_prev_recvr_gl_date pa_cost_distribution_lines_all.recvr_gl_date%TYPE;
87:
88: /*
89: * These global variables are used by function get_gl_period_name.
90: */

Line 91: g_org_id pa_cost_distribution_lines_all.org_id%TYPE ;

87:
88: /*
89: * These global variables are used by function get_gl_period_name.
90: */
91: g_org_id pa_cost_distribution_lines_all.org_id%TYPE ;
92: g_gl_period_start_date pa_cost_distribution_lines_all.gl_date%TYPE ;
93: g_gl_period_end_date pa_cost_distribution_lines_all.gl_date%TYPE ;
94: g_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;
95:

Line 92: g_gl_period_start_date pa_cost_distribution_lines_all.gl_date%TYPE ;

88: /*
89: * These global variables are used by function get_gl_period_name.
90: */
91: g_org_id pa_cost_distribution_lines_all.org_id%TYPE ;
92: g_gl_period_start_date pa_cost_distribution_lines_all.gl_date%TYPE ;
93: g_gl_period_end_date pa_cost_distribution_lines_all.gl_date%TYPE ;
94: g_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;
95:
96: /* Period End Accruals */

Line 93: g_gl_period_end_date pa_cost_distribution_lines_all.gl_date%TYPE ;

89: * These global variables are used by function get_gl_period_name.
90: */
91: g_org_id pa_cost_distribution_lines_all.org_id%TYPE ;
92: g_gl_period_start_date pa_cost_distribution_lines_all.gl_date%TYPE ;
93: g_gl_period_end_date pa_cost_distribution_lines_all.gl_date%TYPE ;
94: g_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;
95:
96: /* Period End Accruals */
97: g_p_org_accr_start_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;

Line 94: g_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;

90: */
91: g_org_id pa_cost_distribution_lines_all.org_id%TYPE ;
92: g_gl_period_start_date pa_cost_distribution_lines_all.gl_date%TYPE ;
93: g_gl_period_end_date pa_cost_distribution_lines_all.gl_date%TYPE ;
94: g_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;
95:
96: /* Period End Accruals */
97: g_p_org_accr_start_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
98: g_p_org_accr_end_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;

Line 101: g_p_rev_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;

97: g_p_org_accr_start_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
98: g_p_org_accr_end_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
99: g_p_rev_accr_nxt_st_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
100: g_p_rev_accr_nxt_end_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
101: g_p_rev_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
102:
103: g_r_org_accr_start_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
104: g_r_org_accr_end_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
105: g_r_rev_accr_nxt_st_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;

Line 107: g_r_rev_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;

103: g_r_org_accr_start_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
104: g_r_org_accr_end_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
105: g_r_rev_accr_nxt_st_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
106: g_r_rev_accr_nxt_end_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
107: g_r_rev_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
108:
109: g_p_accr_gl_per_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
110: g_p_accr_gl_per_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
111: g_p_accr_gl_per_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

Line 109: g_p_accr_gl_per_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

105: g_r_rev_accr_nxt_st_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
106: g_r_rev_accr_nxt_end_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
107: g_r_rev_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
108:
109: g_p_accr_gl_per_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
110: g_p_accr_gl_per_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
111: g_p_accr_gl_per_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
112:
113: g_r_accr_gl_per_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

Line 110: g_p_accr_gl_per_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

106: g_r_rev_accr_nxt_end_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
107: g_r_rev_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
108:
109: g_p_accr_gl_per_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
110: g_p_accr_gl_per_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
111: g_p_accr_gl_per_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
112:
113: g_r_accr_gl_per_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
114: g_r_accr_gl_per_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

Line 111: g_p_accr_gl_per_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

107: g_r_rev_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
108:
109: g_p_accr_gl_per_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
110: g_p_accr_gl_per_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
111: g_p_accr_gl_per_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
112:
113: g_r_accr_gl_per_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
114: g_r_accr_gl_per_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
115: g_r_accr_gl_per_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

Line 113: g_r_accr_gl_per_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

109: g_p_accr_gl_per_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
110: g_p_accr_gl_per_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
111: g_p_accr_gl_per_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
112:
113: g_r_accr_gl_per_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
114: g_r_accr_gl_per_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
115: g_r_accr_gl_per_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
116:
117: g_prv_accr_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

Line 114: g_r_accr_gl_per_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

110: g_p_accr_gl_per_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
111: g_p_accr_gl_per_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
112:
113: g_r_accr_gl_per_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
114: g_r_accr_gl_per_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
115: g_r_accr_gl_per_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
116:
117: g_prv_accr_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
118: g_prv_accr_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

Line 115: g_r_accr_gl_per_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

111: g_p_accr_gl_per_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
112:
113: g_r_accr_gl_per_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
114: g_r_accr_gl_per_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
115: g_r_accr_gl_per_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
116:
117: g_prv_accr_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
118: g_prv_accr_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
119: g_prv_accr_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

Line 117: g_prv_accr_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

113: g_r_accr_gl_per_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
114: g_r_accr_gl_per_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
115: g_r_accr_gl_per_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
116:
117: g_prv_accr_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
118: g_prv_accr_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
119: g_prv_accr_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
120: g_prv_accr_recvr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
121: g_prv_accr_recvr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

Line 118: g_prv_accr_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

114: g_r_accr_gl_per_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
115: g_r_accr_gl_per_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
116:
117: g_prv_accr_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
118: g_prv_accr_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
119: g_prv_accr_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
120: g_prv_accr_recvr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
121: g_prv_accr_recvr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
122: g_p_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

Line 119: g_prv_accr_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

115: g_r_accr_gl_per_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
116:
117: g_prv_accr_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
118: g_prv_accr_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
119: g_prv_accr_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
120: g_prv_accr_recvr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
121: g_prv_accr_recvr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
122: g_p_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
123: g_r_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

Line 120: g_prv_accr_recvr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

116:
117: g_prv_accr_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
118: g_prv_accr_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
119: g_prv_accr_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
120: g_prv_accr_recvr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
121: g_prv_accr_recvr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
122: g_p_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
123: g_r_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
124: g_prv_accr_prvdr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

Line 121: g_prv_accr_recvr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

117: g_prv_accr_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
118: g_prv_accr_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
119: g_prv_accr_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
120: g_prv_accr_recvr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
121: g_prv_accr_recvr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
122: g_p_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
123: g_r_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
124: g_prv_accr_prvdr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
125: g_prv_accr_recvr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

Line 122: g_p_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

118: g_prv_accr_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
119: g_prv_accr_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
120: g_prv_accr_recvr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
121: g_prv_accr_recvr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
122: g_p_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
123: g_r_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
124: g_prv_accr_prvdr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
125: g_prv_accr_recvr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
126: g_prv_accr_prvdr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;

Line 123: g_r_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

119: g_prv_accr_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
120: g_prv_accr_recvr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
121: g_prv_accr_recvr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
122: g_p_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
123: g_r_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
124: g_prv_accr_prvdr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
125: g_prv_accr_recvr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
126: g_prv_accr_prvdr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
127: g_prv_accr_recvr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;

Line 124: g_prv_accr_prvdr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

120: g_prv_accr_recvr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
121: g_prv_accr_recvr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
122: g_p_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
123: g_r_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
124: g_prv_accr_prvdr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
125: g_prv_accr_recvr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
126: g_prv_accr_prvdr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
127: g_prv_accr_recvr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
128:

Line 125: g_prv_accr_recvr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

121: g_prv_accr_recvr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
122: g_p_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
123: g_r_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
124: g_prv_accr_prvdr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
125: g_prv_accr_recvr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
126: g_prv_accr_prvdr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
127: g_prv_accr_recvr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
128:
129: g_p_accr_rev_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

Line 126: g_prv_accr_prvdr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;

122: g_p_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
123: g_r_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
124: g_prv_accr_prvdr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
125: g_prv_accr_recvr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
126: g_prv_accr_prvdr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
127: g_prv_accr_recvr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
128:
129: g_p_accr_rev_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
130: g_r_accr_rev_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

Line 127: g_prv_accr_recvr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;

123: g_r_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
124: g_prv_accr_prvdr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
125: g_prv_accr_recvr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
126: g_prv_accr_prvdr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
127: g_prv_accr_recvr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
128:
129: g_p_accr_rev_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
130: g_r_accr_rev_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
131: g_p_gl_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

Line 129: g_p_accr_rev_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

125: g_prv_accr_recvr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
126: g_prv_accr_prvdr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
127: g_prv_accr_recvr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
128:
129: g_p_accr_rev_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
130: g_r_accr_rev_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
131: g_p_gl_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
132: g_r_gl_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
133: g_prof_new_gldate_derivation VARCHAR2(1) := NULL; --EPP global variable

Line 130: g_r_accr_rev_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

126: g_prv_accr_prvdr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
127: g_prv_accr_recvr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
128:
129: g_p_accr_rev_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
130: g_r_accr_rev_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
131: g_p_gl_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
132: g_r_gl_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
133: g_prof_new_gldate_derivation VARCHAR2(1) := NULL; --EPP global variable
134:

Line 131: g_p_gl_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

127: g_prv_accr_recvr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
128:
129: g_p_accr_rev_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
130: g_r_accr_rev_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
131: g_p_gl_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
132: g_r_gl_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
133: g_prof_new_gldate_derivation VARCHAR2(1) := NULL; --EPP global variable
134:
135:

Line 132: g_r_gl_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

128:
129: g_p_accr_rev_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
130: g_r_accr_rev_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
131: g_p_gl_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
132: g_r_gl_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
133: g_prof_new_gldate_derivation VARCHAR2(1) := NULL; --EPP global variable
134:
135:
136: /* added the following two global variables for BUG# 3384892 */

Line 161: FUNCTION get_period_name return pa_cost_distribution_lines_all.pa_period_name%TYPE;/2835063/

157: ---------------------------------------------------------------
158: -- This function returns 'Y' if a given org is a Exp organization ,
159: -- otherwise , it returns 'N'
160: ---------------------------------------------------------------
161: FUNCTION get_period_name return pa_cost_distribution_lines_all.pa_period_name%TYPE;/*2835063*/
162:
163: /* added the following two functions for bug 3384892 for caching a the profile value.*/
164:
165: FUNCTION pa_date_profile(exp_item_date IN DATE, accounting_date IN DATE, org_id IN NUMBER)

Line 361: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE := NULL

357: ---------------------------------------------------------------
358: PROCEDURE get_period_information ( p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
359: ,p_expenditure_id IN pa_expenditure_items_all.expenditure_id%TYPE := NULL
360: ,p_system_linkage_function IN pa_expenditure_items_all.system_linkage_function%TYPE := NULL
361: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE := NULL
362: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE := NULL
363: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE := NULL
364: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE := NULL
365: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE := NULL

Line 362: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE := NULL

358: PROCEDURE get_period_information ( p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
359: ,p_expenditure_id IN pa_expenditure_items_all.expenditure_id%TYPE := NULL
360: ,p_system_linkage_function IN pa_expenditure_items_all.system_linkage_function%TYPE := NULL
361: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE := NULL
362: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE := NULL
363: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE := NULL
364: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE := NULL
365: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE := NULL
366: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE

Line 363: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE := NULL

359: ,p_expenditure_id IN pa_expenditure_items_all.expenditure_id%TYPE := NULL
360: ,p_system_linkage_function IN pa_expenditure_items_all.system_linkage_function%TYPE := NULL
361: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE := NULL
362: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE := NULL
363: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE := NULL
364: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE := NULL
365: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE := NULL
366: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
367: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE := NULL

Line 364: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE := NULL

360: ,p_system_linkage_function IN pa_expenditure_items_all.system_linkage_function%TYPE := NULL
361: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE := NULL
362: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE := NULL
363: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE := NULL
364: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE := NULL
365: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE := NULL
366: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
367: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE := NULL
368: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE

Line 365: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE := NULL

361: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE := NULL
362: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE := NULL
363: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE := NULL
364: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE := NULL
365: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE := NULL
366: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
367: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE := NULL
368: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
369: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE := NULL

Line 372: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE

368: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
369: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE := NULL
370: ,p_calling_module IN VARCHAR2 := NULL
371: ,p_ou_context IN VARCHAR2 DEFAULT 'N'
372: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
373: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
374: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
375: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
376: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE

Line 373: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE

369: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE := NULL
370: ,p_calling_module IN VARCHAR2 := NULL
371: ,p_ou_context IN VARCHAR2 DEFAULT 'N'
372: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
373: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
374: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
375: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
376: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
377: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE

Line 374: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE

370: ,p_calling_module IN VARCHAR2 := NULL
371: ,p_ou_context IN VARCHAR2 DEFAULT 'N'
372: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
373: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
374: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
375: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
376: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
377: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
378: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE

Line 375: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE

371: ,p_ou_context IN VARCHAR2 DEFAULT 'N'
372: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
373: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
374: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
375: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
376: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
377: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
378: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
379: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE

Line 376: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE

372: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
373: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
374: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
375: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
376: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
377: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
378: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
379: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
380: ,x_return_status OUT NOCOPY NUMBER

Line 377: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE

373: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
374: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
375: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
376: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
377: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
378: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
379: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
380: ,x_return_status OUT NOCOPY NUMBER
381: ,x_error_code OUT NOCOPY VARCHAR2

Line 378: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE

374: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
375: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
376: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
377: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
378: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
379: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
380: ,x_return_status OUT NOCOPY NUMBER
381: ,x_error_code OUT NOCOPY VARCHAR2
382: ,x_error_stage OUT NOCOPY NUMBER

Line 379: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE

375: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
376: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
377: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
378: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
379: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
380: ,x_return_status OUT NOCOPY NUMBER
381: ,x_error_code OUT NOCOPY VARCHAR2
382: ,x_error_stage OUT NOCOPY NUMBER
383: );

Line 387: ,x_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE

383: );
384: ---------------------------------------------------------------
385: PROCEDURE get_OU_period_information ( p_reference_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
386: ,p_calling_module IN VARCHAR2 := NULL
387: ,x_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
388: ,x_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
389: ,x_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
390: ,x_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
391: ,x_return_status OUT NOCOPY NUMBER

Line 388: ,x_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE

384: ---------------------------------------------------------------
385: PROCEDURE get_OU_period_information ( p_reference_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
386: ,p_calling_module IN VARCHAR2 := NULL
387: ,x_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
388: ,x_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
389: ,x_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
390: ,x_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
391: ,x_return_status OUT NOCOPY NUMBER
392: ,x_error_code OUT NOCOPY VARCHAR2

Line 389: ,x_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE

385: PROCEDURE get_OU_period_information ( p_reference_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
386: ,p_calling_module IN VARCHAR2 := NULL
387: ,x_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
388: ,x_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
389: ,x_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
390: ,x_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
391: ,x_return_status OUT NOCOPY NUMBER
392: ,x_error_code OUT NOCOPY VARCHAR2
393: ,x_error_stage OUT NOCOPY NUMBER

Line 390: ,x_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE

386: ,p_calling_module IN VARCHAR2 := NULL
387: ,x_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
388: ,x_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
389: ,x_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
390: ,x_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
391: ,x_return_status OUT NOCOPY NUMBER
392: ,x_error_code OUT NOCOPY VARCHAR2
393: ,x_error_stage OUT NOCOPY NUMBER
394: );

Line 397: FUNCTION get_gl_period_name ( p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE

393: ,x_error_stage OUT NOCOPY NUMBER
394: );
395:
396: ---------------------------------------------------------------
397: FUNCTION get_gl_period_name ( p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
398: ,p_org_id IN pa_cost_distribution_lines_all.org_id%TYPE
399: )
400: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE;
401: ---------------------------------------------------------------

Line 398: ,p_org_id IN pa_cost_distribution_lines_all.org_id%TYPE

394: );
395:
396: ---------------------------------------------------------------
397: FUNCTION get_gl_period_name ( p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
398: ,p_org_id IN pa_cost_distribution_lines_all.org_id%TYPE
399: )
400: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE;
401: ---------------------------------------------------------------
402: FUNCTION get_set_of_books_id (p_org_id IN pa_implementations_all.org_id%TYPE) RETURN NUMBER;

Line 400: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE;

396: ---------------------------------------------------------------
397: FUNCTION get_gl_period_name ( p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
398: ,p_org_id IN pa_cost_distribution_lines_all.org_id%TYPE
399: )
400: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE;
401: ---------------------------------------------------------------
402: FUNCTION get_set_of_books_id (p_org_id IN pa_implementations_all.org_id%TYPE) RETURN NUMBER;
403: ---------------------------------------------------------------
404: /*

Line 427: ,x_prvdr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE

423: ------------------------------------------------------------------------------------------------------------------
424: -- Procedure : get_accrual_period_information
425: ------------------------------------------------------------------------------------------------------------------
426: PROCEDURE get_accrual_period_information(p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
427: ,x_prvdr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
428: ,x_recvr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
429: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
430: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
431: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE

Line 428: ,x_recvr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE

424: -- Procedure : get_accrual_period_information
425: ------------------------------------------------------------------------------------------------------------------
426: PROCEDURE get_accrual_period_information(p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
427: ,x_prvdr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
428: ,x_recvr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
429: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
430: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
431: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
432: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE

Line 434: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE

430: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
431: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
432: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
433: ,p_calling_module IN VARCHAR2
434: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
435: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
436: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
437: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
438: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE

Line 435: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE

431: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
432: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
433: ,p_calling_module IN VARCHAR2
434: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
435: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
436: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
437: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
438: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
439: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE

Line 436: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE

432: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
433: ,p_calling_module IN VARCHAR2
434: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
435: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
436: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
437: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
438: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
439: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
440: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE

Line 437: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE

433: ,p_calling_module IN VARCHAR2
434: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
435: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
436: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
437: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
438: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
439: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
440: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
441: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE

Line 438: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE

434: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
435: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
436: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
437: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
438: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
439: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
440: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
441: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
442: ,p_adj_ei_id IN pa_expenditure_items_all.expenditure_item_id%type

Line 439: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE

435: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
436: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
437: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
438: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
439: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
440: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
441: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
442: ,p_adj_ei_id IN pa_expenditure_items_all.expenditure_item_id%type
443: ,p_acct_flag IN VARCHAR2

Line 440: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE

436: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
437: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
438: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
439: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
440: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
441: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
442: ,p_adj_ei_id IN pa_expenditure_items_all.expenditure_item_id%type
443: ,p_acct_flag IN VARCHAR2
444: ,x_return_status OUT NOCOPY VARCHAR2

Line 441: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE

437: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
438: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
439: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
440: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
441: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
442: ,p_adj_ei_id IN pa_expenditure_items_all.expenditure_item_id%type
443: ,p_acct_flag IN VARCHAR2
444: ,x_return_status OUT NOCOPY VARCHAR2
445: ,x_error_code OUT NOCOPY VARCHAR2