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

Line 7: g_p_earliest_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;

3:
4:
5: /**global variables related to get_raw_cdl_pa_date() and get_raw_cdl_recvr_pa_date() caching **/
6: g_prvdr_org_id pa_expenditure_items_all.org_id%TYPE;
7: g_p_earliest_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
8: g_p_earliest_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
9: g_p_earliest_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
10: g_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
11: g_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;

Line 8: g_p_earliest_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;

4:
5: /**global variables related to get_raw_cdl_pa_date() and get_raw_cdl_recvr_pa_date() caching **/
6: g_prvdr_org_id pa_expenditure_items_all.org_id%TYPE;
7: g_p_earliest_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
8: g_p_earliest_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
9: g_p_earliest_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
10: g_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
11: g_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
12: g_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;

Line 9: g_p_earliest_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;

5: /**global variables related to get_raw_cdl_pa_date() and get_raw_cdl_recvr_pa_date() caching **/
6: g_prvdr_org_id pa_expenditure_items_all.org_id%TYPE;
7: g_p_earliest_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
8: g_p_earliest_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
9: g_p_earliest_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
10: g_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
11: g_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
12: g_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
13: g_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE;

Line 10: g_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;

6: g_prvdr_org_id pa_expenditure_items_all.org_id%TYPE;
7: g_p_earliest_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
8: g_p_earliest_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
9: g_p_earliest_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
10: g_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
11: g_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
12: g_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
13: g_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE;
14:

Line 11: g_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;

7: g_p_earliest_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
8: g_p_earliest_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
9: g_p_earliest_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
10: g_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
11: g_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
12: g_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
13: g_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE;
14:
15: g_recvr_org_id pa_expenditure_items_all.recvr_org_id%TYPE;

Line 12: g_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;

8: g_p_earliest_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
9: g_p_earliest_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
10: g_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
11: g_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
12: g_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
13: g_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE;
14:
15: g_recvr_org_id pa_expenditure_items_all.recvr_org_id%TYPE;
16: g_r_earliest_pa_start_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;

Line 13: g_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE;

9: g_p_earliest_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
10: g_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
11: g_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
12: g_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
13: g_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE;
14:
15: g_recvr_org_id pa_expenditure_items_all.recvr_org_id%TYPE;
16: g_r_earliest_pa_start_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
17: g_r_earliest_pa_end_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;

Line 16: g_r_earliest_pa_start_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;

12: g_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
13: g_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE;
14:
15: g_recvr_org_id pa_expenditure_items_all.recvr_org_id%TYPE;
16: g_r_earliest_pa_start_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
17: g_r_earliest_pa_end_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
18: g_r_earliest_pa_period_name pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
19: g_recvr_pa_start_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
20: g_recvr_pa_end_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;

Line 17: g_r_earliest_pa_end_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;

13: g_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE;
14:
15: g_recvr_org_id pa_expenditure_items_all.recvr_org_id%TYPE;
16: g_r_earliest_pa_start_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
17: g_r_earliest_pa_end_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
18: g_r_earliest_pa_period_name pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
19: g_recvr_pa_start_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
20: g_recvr_pa_end_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
21: g_recvr_pa_period_name pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;

Line 18: g_r_earliest_pa_period_name pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;

14:
15: g_recvr_org_id pa_expenditure_items_all.recvr_org_id%TYPE;
16: g_r_earliest_pa_start_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
17: g_r_earliest_pa_end_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
18: g_r_earliest_pa_period_name pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
19: g_recvr_pa_start_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
20: g_recvr_pa_end_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
21: g_recvr_pa_period_name pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
22: g_recvr_pa_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;

Line 19: g_recvr_pa_start_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;

15: g_recvr_org_id pa_expenditure_items_all.recvr_org_id%TYPE;
16: g_r_earliest_pa_start_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
17: g_r_earliest_pa_end_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
18: g_r_earliest_pa_period_name pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
19: g_recvr_pa_start_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
20: g_recvr_pa_end_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
21: g_recvr_pa_period_name pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
22: g_recvr_pa_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
23:

Line 20: g_recvr_pa_end_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;

16: g_r_earliest_pa_start_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
17: g_r_earliest_pa_end_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
18: g_r_earliest_pa_period_name pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
19: g_recvr_pa_start_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
20: g_recvr_pa_end_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
21: g_recvr_pa_period_name pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
22: g_recvr_pa_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
23:
24: /**global variables related to pa_date caching **/

Line 21: g_recvr_pa_period_name pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;

17: g_r_earliest_pa_end_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
18: g_r_earliest_pa_period_name pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
19: g_recvr_pa_start_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
20: g_recvr_pa_end_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
21: g_recvr_pa_period_name pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
22: g_recvr_pa_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
23:
24: /**global variables related to pa_date caching **/
25:

Line 22: g_recvr_pa_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;

18: g_r_earliest_pa_period_name pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
19: g_recvr_pa_start_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
20: g_recvr_pa_end_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
21: g_recvr_pa_period_name pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
22: g_recvr_pa_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
23:
24: /**global variables related to pa_date caching **/
25:
26: FUNCTION get_period_name return pa_cost_distribution_lines_all.pa_period_name%TYPE;/*2835063*/

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

22: g_recvr_pa_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
23:
24: /**global variables related to pa_date caching **/
25:
26: FUNCTION get_period_name return pa_cost_distribution_lines_all.pa_period_name%TYPE;/*2835063*/
27:
28:
29: /*----------------------------------------------------------------------------*/
30: -- Start of Comments

Line 200: ,p_prvdr_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE

196: RETURN DATE;
197: pragma RESTRICT_REFERENCES(get_burden_cdl_pa_date,WNDS,WNPS);
198: /*----------------------------------------------------------------------------*/
199: PROCEDURE get_period_information ( p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
200: ,p_prvdr_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
201: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE
202: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
203: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
204: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE

Line 201: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE

197: pragma RESTRICT_REFERENCES(get_burden_cdl_pa_date,WNDS,WNPS);
198: /*----------------------------------------------------------------------------*/
199: PROCEDURE get_period_information ( p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
200: ,p_prvdr_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
201: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE
202: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
203: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
204: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
205: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE

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

202: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
203: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
204: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
205: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
206: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
207: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
208: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
209: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
210: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE

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

203: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
204: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
205: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
206: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
207: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
208: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
209: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
210: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
211: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE

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

204: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
205: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
206: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
207: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
208: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
209: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
210: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
211: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
212: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE

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

205: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
206: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
207: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
208: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
209: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
210: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
211: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
212: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
213: ,x_return_status OUT NOCOPY NUMBER

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

206: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
207: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
208: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
209: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
210: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
211: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
212: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
213: ,x_return_status OUT NOCOPY NUMBER
214: ,x_error_code OUT NOCOPY VARCHAR2

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

207: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
208: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
209: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
210: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
211: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
212: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
213: ,x_return_status OUT NOCOPY NUMBER
214: ,x_error_code OUT NOCOPY VARCHAR2
215: ,x_error_stage OUT NOCOPY NUMBER

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

208: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
209: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
210: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
211: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
212: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
213: ,x_return_status OUT NOCOPY NUMBER
214: ,x_error_code OUT NOCOPY VARCHAR2
215: ,x_error_stage OUT NOCOPY NUMBER
216: );

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

214: ,x_error_code OUT NOCOPY VARCHAR2
215: ,x_error_stage OUT NOCOPY NUMBER
216: );
217: /*----------------------------------------------------------------------------*/
218: FUNCTION get_gl_period_name ( p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
219: ,p_set_of_books_id IN pa_implementations_all.set_of_books_id%TYPE
220: ) RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE;
221: /*----------------------------------------------------------------------------*/
222: END pa_integration;

Line 220: ) RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE;

216: );
217: /*----------------------------------------------------------------------------*/
218: FUNCTION get_gl_period_name ( p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
219: ,p_set_of_books_id IN pa_implementations_all.set_of_books_id%TYPE
220: ) RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE;
221: /*----------------------------------------------------------------------------*/
222: END pa_integration;