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: G_Application_Id NUMBER; /*Added for bug 7638790 */

Line 57: g_p_earliest_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;

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;

Line 58: g_p_earliest_gl_end_date pa_cost_distribution_lines_all.gl_date%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;

Line 59: g_p_earliest_gl_period_name pa_cost_distribution_lines_all.gl_period_name%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;

Line 62: g_prvdr_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;
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:

Line 63: g_prvdr_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:
67: /*

Line 64: g_prvdr_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: /*
68: * Receiver.

Line 65: g_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;

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: */

Line 70: g_r_earliest_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;

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;

Line 71: g_r_earliest_gl_end_date pa_cost_distribution_lines_all.gl_date%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;

Line 72: g_r_earliest_gl_period_name pa_cost_distribution_lines_all.gl_period_name%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;

Line 75: g_recvr_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;
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:

Line 76: g_recvr_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:
80: /*

Line 77: g_recvr_gl_period_name pa_cost_distribution_lines_all.recvr_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: /*
81: * EPP.

Line 78: g_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;

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: */

Line 84: g_prev_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;

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:

Line 85: g_prev_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;

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: /*

Line 86: g_prev_recvr_gl_period_name pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;

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.

Line 87: g_prev_recvr_gl_date pa_cost_distribution_lines_all.recvr_gl_date%TYPE;

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: */

Line 92: g_org_id pa_cost_distribution_lines_all.org_id%TYPE ;

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:

Line 93: g_gl_period_start_date pa_cost_distribution_lines_all.gl_date%TYPE ;

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 */

Line 94: g_gl_period_end_date pa_cost_distribution_lines_all.gl_date%TYPE ;

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;

Line 95: g_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;

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;

Line 102: g_p_rev_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;

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;

Line 108: g_r_rev_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;

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;

Line 110: g_p_accr_gl_per_st_dt pa_cost_distribution_lines_all.gl_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;
113:
114: g_r_accr_gl_per_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

Line 111: g_p_accr_gl_per_end_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;

Line 112: g_p_accr_gl_per_name pa_cost_distribution_lines_all.pa_period_name%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;

Line 114: g_r_accr_gl_per_st_dt pa_cost_distribution_lines_all.gl_date%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;

Line 115: g_r_accr_gl_per_end_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;
119: g_prv_accr_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

Line 116: g_r_accr_gl_per_name pa_cost_distribution_lines_all.pa_period_name%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;

Line 118: g_prv_accr_prvdr_pa_start_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;

Line 119: g_prv_accr_prvdr_pa_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;

Line 120: g_prv_accr_prvdr_pa_end_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;

Line 121: g_prv_accr_recvr_pa_start_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;

Line 122: g_prv_accr_recvr_pa_end_date pa_cost_distribution_lines_all.pa_date%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;

Line 123: g_p_accr_rev_pa_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;
127: g_prv_accr_prvdr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;

Line 124: g_r_accr_rev_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;
128: g_prv_accr_recvr_gl_period pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;

Line 125: g_prv_accr_prvdr_pa_period pa_cost_distribution_lines_all.pa_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:

Line 126: g_prv_accr_recvr_pa_period pa_cost_distribution_lines_all.pa_period_name%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:
130: g_p_accr_rev_pa_period pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

Line 127: g_prv_accr_prvdr_gl_period pa_cost_distribution_lines_all.gl_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;

Line 128: g_prv_accr_recvr_gl_period pa_cost_distribution_lines_all.gl_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;

Line 130: g_p_accr_rev_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;
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

Line 131: g_r_accr_rev_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
135:

Line 132: g_p_gl_period pa_cost_distribution_lines_all.pa_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:
136:

Line 133: g_r_gl_period pa_cost_distribution_lines_all.pa_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:
137: /* added the following two global variables for BUG# 3384892 */

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

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)

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

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

Line 363: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_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

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

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

Line 365: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%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

Line 366: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%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
370: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE := NULL

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

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

Line 374: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%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

Line 375: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%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

Line 376: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%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

Line 377: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%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

Line 378: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%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
382: ,x_error_code OUT NOCOPY VARCHAR2

Line 379: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%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
383: ,x_error_stage OUT NOCOPY NUMBER

Line 380: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%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
384: );

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

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

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

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

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

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

Line 391: ,x_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%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
395: );

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

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: ---------------------------------------------------------------

Line 399: ,p_org_id IN pa_cost_distribution_lines_all.org_id%TYPE

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;

Line 401: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE;

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: /*

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

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

Line 429: ,x_recvr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%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

Line 435: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%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

Line 436: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%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

Line 437: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%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

Line 438: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%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

Line 439: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%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

Line 440: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%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

Line 441: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%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
445: ,x_return_status OUT NOCOPY VARCHAR2

Line 442: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%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
446: ,x_error_code OUT NOCOPY VARCHAR2