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:
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;
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;
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;
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:
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: /*
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.
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: */
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:
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;
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;
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;
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:
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;
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);
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: G_Application_Id NUMBER; /*Added for bug 7638790 */
53:
54: /*
55: * Provider.
56: */
57: g_p_earliest_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
58: g_p_earliest_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
59: g_p_earliest_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
60:
61: g_prvdr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
54: /*
55: * Provider.
56: */
57: g_p_earliest_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
58: g_p_earliest_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
59: g_p_earliest_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
60:
61: g_prvdr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
62: g_prvdr_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
55: * Provider.
56: */
57: g_p_earliest_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
58: g_p_earliest_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
59: g_p_earliest_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
60:
61: g_prvdr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
62: g_prvdr_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
63: g_prvdr_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
58: g_p_earliest_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
59: g_p_earliest_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
60:
61: g_prvdr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
62: g_prvdr_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
63: g_prvdr_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
64: g_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;
65: g_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;
66:
59: g_p_earliest_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
60:
61: g_prvdr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
62: g_prvdr_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
63: g_prvdr_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
64: g_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;
65: g_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;
66:
67: /*
60:
61: g_prvdr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
62: g_prvdr_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
63: g_prvdr_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
64: g_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;
65: g_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;
66:
67: /*
68: * Receiver.
61: g_prvdr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
62: g_prvdr_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
63: g_prvdr_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
64: g_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;
65: g_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;
66:
67: /*
68: * Receiver.
69: */
66:
67: /*
68: * Receiver.
69: */
70: g_r_earliest_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
71: g_r_earliest_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
72: g_r_earliest_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
73:
74: g_recvr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
67: /*
68: * Receiver.
69: */
70: g_r_earliest_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
71: g_r_earliest_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
72: g_r_earliest_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
73:
74: g_recvr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
75: g_recvr_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
68: * Receiver.
69: */
70: g_r_earliest_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
71: g_r_earliest_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
72: g_r_earliest_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
73:
74: g_recvr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
75: g_recvr_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
76: g_recvr_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
71: g_r_earliest_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
72: g_r_earliest_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
73:
74: g_recvr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
75: g_recvr_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
76: g_recvr_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
77: g_recvr_gl_period_name pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE ;
78: g_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;
79:
72: g_r_earliest_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
73:
74: g_recvr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
75: g_recvr_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
76: g_recvr_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
77: g_recvr_gl_period_name pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE ;
78: g_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;
79:
80: /*
73:
74: g_recvr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
75: g_recvr_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
76: g_recvr_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
77: g_recvr_gl_period_name pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE ;
78: g_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;
79:
80: /*
81: * EPP.
74: g_recvr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
75: g_recvr_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
76: g_recvr_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
77: g_recvr_gl_period_name pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE ;
78: g_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;
79:
80: /*
81: * EPP.
82: */
80: /*
81: * EPP.
82: */
83: g_prev_expenditure_id pa_expenditure_items_all.expenditure_id%TYPE;
84: g_prev_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;
85: g_prev_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
86: g_prev_recvr_gl_period_name pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;
87: g_prev_recvr_gl_date pa_cost_distribution_lines_all.recvr_gl_date%TYPE;
88:
81: * EPP.
82: */
83: g_prev_expenditure_id pa_expenditure_items_all.expenditure_id%TYPE;
84: g_prev_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;
85: g_prev_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
86: g_prev_recvr_gl_period_name pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;
87: g_prev_recvr_gl_date pa_cost_distribution_lines_all.recvr_gl_date%TYPE;
88:
89: /*
82: */
83: g_prev_expenditure_id pa_expenditure_items_all.expenditure_id%TYPE;
84: g_prev_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;
85: g_prev_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
86: g_prev_recvr_gl_period_name pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;
87: g_prev_recvr_gl_date pa_cost_distribution_lines_all.recvr_gl_date%TYPE;
88:
89: /*
90: * These global variables are used by function get_gl_period_name.
83: g_prev_expenditure_id pa_expenditure_items_all.expenditure_id%TYPE;
84: g_prev_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;
85: g_prev_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
86: g_prev_recvr_gl_period_name pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;
87: g_prev_recvr_gl_date pa_cost_distribution_lines_all.recvr_gl_date%TYPE;
88:
89: /*
90: * These global variables are used by function get_gl_period_name.
91: */
88:
89: /*
90: * These global variables are used by function get_gl_period_name.
91: */
92: g_org_id pa_cost_distribution_lines_all.org_id%TYPE ;
93: g_gl_period_start_date pa_cost_distribution_lines_all.gl_date%TYPE ;
94: g_gl_period_end_date pa_cost_distribution_lines_all.gl_date%TYPE ;
95: g_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;
96:
89: /*
90: * These global variables are used by function get_gl_period_name.
91: */
92: g_org_id pa_cost_distribution_lines_all.org_id%TYPE ;
93: g_gl_period_start_date pa_cost_distribution_lines_all.gl_date%TYPE ;
94: g_gl_period_end_date pa_cost_distribution_lines_all.gl_date%TYPE ;
95: g_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;
96:
97: /* Period End Accruals */
90: * These global variables are used by function get_gl_period_name.
91: */
92: g_org_id pa_cost_distribution_lines_all.org_id%TYPE ;
93: g_gl_period_start_date pa_cost_distribution_lines_all.gl_date%TYPE ;
94: g_gl_period_end_date pa_cost_distribution_lines_all.gl_date%TYPE ;
95: g_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;
96:
97: /* Period End Accruals */
98: g_p_org_accr_start_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
91: */
92: g_org_id pa_cost_distribution_lines_all.org_id%TYPE ;
93: g_gl_period_start_date pa_cost_distribution_lines_all.gl_date%TYPE ;
94: g_gl_period_end_date pa_cost_distribution_lines_all.gl_date%TYPE ;
95: g_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;
96:
97: /* Period End Accruals */
98: g_p_org_accr_start_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
99: g_p_org_accr_end_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
98: g_p_org_accr_start_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
99: g_p_org_accr_end_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
100: g_p_rev_accr_nxt_st_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
101: g_p_rev_accr_nxt_end_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
102: g_p_rev_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
103:
104: g_r_org_accr_start_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
105: g_r_org_accr_end_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
106: g_r_rev_accr_nxt_st_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
104: g_r_org_accr_start_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
105: g_r_org_accr_end_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
106: g_r_rev_accr_nxt_st_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
107: g_r_rev_accr_nxt_end_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
108: g_r_rev_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
109:
110: g_p_accr_gl_per_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
111: g_p_accr_gl_per_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
112: g_p_accr_gl_per_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
106: g_r_rev_accr_nxt_st_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
107: g_r_rev_accr_nxt_end_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
108: g_r_rev_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
109:
110: g_p_accr_gl_per_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
111: g_p_accr_gl_per_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
112: g_p_accr_gl_per_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
113:
114: g_r_accr_gl_per_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
107: g_r_rev_accr_nxt_end_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
108: g_r_rev_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
109:
110: g_p_accr_gl_per_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
111: g_p_accr_gl_per_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
112: g_p_accr_gl_per_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
113:
114: g_r_accr_gl_per_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
115: g_r_accr_gl_per_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
108: g_r_rev_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
109:
110: g_p_accr_gl_per_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
111: g_p_accr_gl_per_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
112: g_p_accr_gl_per_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
113:
114: g_r_accr_gl_per_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
115: g_r_accr_gl_per_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
116: g_r_accr_gl_per_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
110: g_p_accr_gl_per_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
111: g_p_accr_gl_per_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
112: g_p_accr_gl_per_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
113:
114: g_r_accr_gl_per_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
115: g_r_accr_gl_per_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
116: g_r_accr_gl_per_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
117:
118: g_prv_accr_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
111: g_p_accr_gl_per_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
112: g_p_accr_gl_per_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
113:
114: g_r_accr_gl_per_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
115: g_r_accr_gl_per_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
116: g_r_accr_gl_per_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
117:
118: g_prv_accr_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
119: g_prv_accr_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
112: g_p_accr_gl_per_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
113:
114: g_r_accr_gl_per_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
115: g_r_accr_gl_per_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
116: g_r_accr_gl_per_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
117:
118: g_prv_accr_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
119: g_prv_accr_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
120: g_prv_accr_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
114: g_r_accr_gl_per_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
115: g_r_accr_gl_per_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
116: g_r_accr_gl_per_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
117:
118: g_prv_accr_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
119: g_prv_accr_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
120: g_prv_accr_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
121: g_prv_accr_recvr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
122: g_prv_accr_recvr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
115: g_r_accr_gl_per_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
116: g_r_accr_gl_per_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
117:
118: g_prv_accr_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
119: g_prv_accr_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
120: g_prv_accr_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
121: g_prv_accr_recvr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
122: g_prv_accr_recvr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
123: g_p_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
116: g_r_accr_gl_per_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
117:
118: g_prv_accr_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
119: g_prv_accr_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
120: g_prv_accr_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
121: g_prv_accr_recvr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
122: g_prv_accr_recvr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
123: g_p_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
124: g_r_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
117:
118: g_prv_accr_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
119: g_prv_accr_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
120: g_prv_accr_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
121: g_prv_accr_recvr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
122: g_prv_accr_recvr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
123: g_p_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
124: g_r_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
125: g_prv_accr_prvdr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
118: g_prv_accr_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
119: g_prv_accr_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
120: g_prv_accr_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
121: g_prv_accr_recvr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
122: g_prv_accr_recvr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
123: g_p_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
124: g_r_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
125: g_prv_accr_prvdr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
126: g_prv_accr_recvr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
119: g_prv_accr_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
120: g_prv_accr_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
121: g_prv_accr_recvr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
122: g_prv_accr_recvr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
123: g_p_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
124: g_r_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
125: g_prv_accr_prvdr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
126: g_prv_accr_recvr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
127: g_prv_accr_prvdr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
120: g_prv_accr_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
121: g_prv_accr_recvr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
122: g_prv_accr_recvr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
123: g_p_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
124: g_r_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
125: g_prv_accr_prvdr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
126: g_prv_accr_recvr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
127: g_prv_accr_prvdr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
128: g_prv_accr_recvr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
121: g_prv_accr_recvr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
122: g_prv_accr_recvr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
123: g_p_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
124: g_r_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
125: g_prv_accr_prvdr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
126: g_prv_accr_recvr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
127: g_prv_accr_prvdr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
128: g_prv_accr_recvr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
129:
122: g_prv_accr_recvr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
123: g_p_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
124: g_r_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
125: g_prv_accr_prvdr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
126: g_prv_accr_recvr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
127: g_prv_accr_prvdr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
128: g_prv_accr_recvr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
129:
130: g_p_accr_rev_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
123: g_p_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
124: g_r_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
125: g_prv_accr_prvdr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
126: g_prv_accr_recvr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
127: g_prv_accr_prvdr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
128: g_prv_accr_recvr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
129:
130: g_p_accr_rev_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
131: g_r_accr_rev_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
124: g_r_accr_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
125: g_prv_accr_prvdr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
126: g_prv_accr_recvr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
127: g_prv_accr_prvdr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
128: g_prv_accr_recvr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
129:
130: g_p_accr_rev_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
131: g_r_accr_rev_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
132: g_p_gl_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
126: g_prv_accr_recvr_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
127: g_prv_accr_prvdr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
128: g_prv_accr_recvr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
129:
130: g_p_accr_rev_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
131: g_r_accr_rev_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
132: g_p_gl_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
133: g_r_gl_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
134: g_prof_new_gldate_derivation VARCHAR2(1) := NULL; --EPP global variable
127: g_prv_accr_prvdr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
128: g_prv_accr_recvr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
129:
130: g_p_accr_rev_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
131: g_r_accr_rev_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
132: g_p_gl_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
133: g_r_gl_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
134: g_prof_new_gldate_derivation VARCHAR2(1) := NULL; --EPP global variable
135:
128: g_prv_accr_recvr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
129:
130: g_p_accr_rev_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
131: g_r_accr_rev_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
132: g_p_gl_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
133: g_r_gl_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
134: g_prof_new_gldate_derivation VARCHAR2(1) := NULL; --EPP global variable
135:
136:
129:
130: g_p_accr_rev_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
131: g_r_accr_rev_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
132: g_p_gl_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
133: g_r_gl_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
134: g_prof_new_gldate_derivation VARCHAR2(1) := NULL; --EPP global variable
135:
136:
137: /* added the following two global variables for BUG# 3384892 */
158: ---------------------------------------------------------------
159: -- This function returns 'Y' if a given org is a Exp organization ,
160: -- otherwise , it returns 'N'
161: ---------------------------------------------------------------
162: FUNCTION get_period_name return pa_cost_distribution_lines_all.pa_period_name%TYPE;/*2835063*/
163:
164: /* added the following two functions for bug 3384892 for caching a the profile value.*/
165:
166: FUNCTION pa_date_profile(exp_item_date IN DATE, accounting_date IN DATE, org_id IN NUMBER)
358: ---------------------------------------------------------------
359: PROCEDURE get_period_information ( p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
360: ,p_expenditure_id IN pa_expenditure_items_all.expenditure_id%TYPE := NULL
361: ,p_system_linkage_function IN pa_expenditure_items_all.system_linkage_function%TYPE := NULL
362: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE := NULL
363: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE := NULL
364: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE := NULL
365: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE := NULL
366: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE := NULL
359: PROCEDURE get_period_information ( p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
360: ,p_expenditure_id IN pa_expenditure_items_all.expenditure_id%TYPE := NULL
361: ,p_system_linkage_function IN pa_expenditure_items_all.system_linkage_function%TYPE := NULL
362: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE := NULL
363: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE := NULL
364: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE := NULL
365: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE := NULL
366: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE := NULL
367: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
360: ,p_expenditure_id IN pa_expenditure_items_all.expenditure_id%TYPE := NULL
361: ,p_system_linkage_function IN pa_expenditure_items_all.system_linkage_function%TYPE := NULL
362: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE := NULL
363: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE := NULL
364: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE := NULL
365: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE := NULL
366: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE := NULL
367: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
368: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE := NULL
361: ,p_system_linkage_function IN pa_expenditure_items_all.system_linkage_function%TYPE := NULL
362: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE := NULL
363: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE := NULL
364: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE := NULL
365: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE := NULL
366: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE := NULL
367: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
368: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE := NULL
369: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
362: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE := NULL
363: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE := NULL
364: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE := NULL
365: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE := NULL
366: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE := NULL
367: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
368: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE := NULL
369: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
370: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE := NULL
369: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
370: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE := NULL
371: ,p_calling_module IN VARCHAR2 := NULL
372: ,p_ou_context IN VARCHAR2 DEFAULT 'N'
373: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
374: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
375: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
376: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
377: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
370: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE := NULL
371: ,p_calling_module IN VARCHAR2 := NULL
372: ,p_ou_context IN VARCHAR2 DEFAULT 'N'
373: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
374: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
375: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
376: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
377: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
378: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
371: ,p_calling_module IN VARCHAR2 := NULL
372: ,p_ou_context IN VARCHAR2 DEFAULT 'N'
373: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
374: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
375: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
376: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
377: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
378: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
379: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
372: ,p_ou_context IN VARCHAR2 DEFAULT 'N'
373: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
374: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
375: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
376: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
377: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
378: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
379: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
380: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
373: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
374: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
375: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
376: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
377: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
378: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
379: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
380: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
381: ,x_return_status OUT NOCOPY NUMBER
374: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
375: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
376: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
377: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
378: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
379: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
380: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
381: ,x_return_status OUT NOCOPY NUMBER
382: ,x_error_code OUT NOCOPY VARCHAR2
375: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
376: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
377: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
378: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
379: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
380: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
381: ,x_return_status OUT NOCOPY NUMBER
382: ,x_error_code OUT NOCOPY VARCHAR2
383: ,x_error_stage OUT NOCOPY NUMBER
376: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
377: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
378: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
379: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
380: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
381: ,x_return_status OUT NOCOPY NUMBER
382: ,x_error_code OUT NOCOPY VARCHAR2
383: ,x_error_stage OUT NOCOPY NUMBER
384: );
384: );
385: ---------------------------------------------------------------
386: PROCEDURE get_OU_period_information ( p_reference_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
387: ,p_calling_module IN VARCHAR2 := NULL
388: ,x_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
389: ,x_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
390: ,x_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
391: ,x_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
392: ,x_return_status OUT NOCOPY NUMBER
385: ---------------------------------------------------------------
386: PROCEDURE get_OU_period_information ( p_reference_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
387: ,p_calling_module IN VARCHAR2 := NULL
388: ,x_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
389: ,x_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
390: ,x_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
391: ,x_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
392: ,x_return_status OUT NOCOPY NUMBER
393: ,x_error_code OUT NOCOPY VARCHAR2
386: PROCEDURE get_OU_period_information ( p_reference_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
387: ,p_calling_module IN VARCHAR2 := NULL
388: ,x_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
389: ,x_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
390: ,x_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
391: ,x_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
392: ,x_return_status OUT NOCOPY NUMBER
393: ,x_error_code OUT NOCOPY VARCHAR2
394: ,x_error_stage OUT NOCOPY NUMBER
387: ,p_calling_module IN VARCHAR2 := NULL
388: ,x_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
389: ,x_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
390: ,x_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
391: ,x_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
392: ,x_return_status OUT NOCOPY NUMBER
393: ,x_error_code OUT NOCOPY VARCHAR2
394: ,x_error_stage OUT NOCOPY NUMBER
395: );
394: ,x_error_stage OUT NOCOPY NUMBER
395: );
396:
397: ---------------------------------------------------------------
398: FUNCTION get_gl_period_name ( p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
399: ,p_org_id IN pa_cost_distribution_lines_all.org_id%TYPE
400: )
401: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE;
402: ---------------------------------------------------------------
395: );
396:
397: ---------------------------------------------------------------
398: FUNCTION get_gl_period_name ( p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
399: ,p_org_id IN pa_cost_distribution_lines_all.org_id%TYPE
400: )
401: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE;
402: ---------------------------------------------------------------
403: FUNCTION get_set_of_books_id (p_org_id IN pa_implementations_all.org_id%TYPE) RETURN NUMBER;
397: ---------------------------------------------------------------
398: FUNCTION get_gl_period_name ( p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
399: ,p_org_id IN pa_cost_distribution_lines_all.org_id%TYPE
400: )
401: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE;
402: ---------------------------------------------------------------
403: FUNCTION get_set_of_books_id (p_org_id IN pa_implementations_all.org_id%TYPE) RETURN NUMBER;
404: ---------------------------------------------------------------
405: /*
424: ------------------------------------------------------------------------------------------------------------------
425: -- Procedure : get_accrual_period_information
426: ------------------------------------------------------------------------------------------------------------------
427: PROCEDURE get_accrual_period_information(p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
428: ,x_prvdr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
429: ,x_recvr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
430: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
431: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
432: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
425: -- Procedure : get_accrual_period_information
426: ------------------------------------------------------------------------------------------------------------------
427: PROCEDURE get_accrual_period_information(p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
428: ,x_prvdr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
429: ,x_recvr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
430: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
431: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
432: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
433: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
431: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
432: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
433: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
434: ,p_calling_module IN VARCHAR2
435: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
436: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
437: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
438: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
439: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
432: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
433: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
434: ,p_calling_module IN VARCHAR2
435: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
436: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
437: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
438: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
439: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
440: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
433: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
434: ,p_calling_module IN VARCHAR2
435: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
436: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
437: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
438: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
439: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
440: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
441: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
434: ,p_calling_module IN VARCHAR2
435: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
436: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
437: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
438: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
439: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
440: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
441: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
442: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
435: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
436: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
437: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
438: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
439: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
440: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
441: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
442: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
443: ,p_adj_ei_id IN pa_expenditure_items_all.expenditure_item_id%type
436: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
437: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
438: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
439: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
440: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
441: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
442: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
443: ,p_adj_ei_id IN pa_expenditure_items_all.expenditure_item_id%type
444: ,p_acct_flag IN VARCHAR2
437: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
438: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
439: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
440: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
441: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
442: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
443: ,p_adj_ei_id IN pa_expenditure_items_all.expenditure_item_id%type
444: ,p_acct_flag IN VARCHAR2
445: ,x_return_status OUT NOCOPY VARCHAR2
438: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
439: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
440: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
441: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
442: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
443: ,p_adj_ei_id IN pa_expenditure_items_all.expenditure_item_id%type
444: ,p_acct_flag IN VARCHAR2
445: ,x_return_status OUT NOCOPY VARCHAR2
446: ,x_error_code OUT NOCOPY VARCHAR2