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

Line 5: FUNCTION get_period_name RETURN pa_cost_distribution_lines_all.pa_period_name%TYPE is

1: PACKAGE BODY PA_UTILS2 AS
2: /* $Header: PAXGUT2B.pls 120.26.12020000.4 2013/03/06 09:49:17 admarath ship $ */
3:
4: -- FUNCTION get_period_name /*2835063*/
5: FUNCTION get_period_name RETURN pa_cost_distribution_lines_all.pa_period_name%TYPE is
6: BEGIN
7: /* Please note that this function should be used only after ensuring that
8: get_pa_date() is called for the returned variable's value to be set to
9: a non-NULL value */

Line 1164: l_billable_flag pa_cost_distribution_lines_all.billable_flag%type;

1160: l_exp_item_id pa_expenditure_items_all.expenditure_item_id%type;
1161: l_gl_date DATE;
1162: l_pji_summarized_flag VARCHAR2(1);
1163: l_prvdr_accr_date DATE;
1164: l_billable_flag pa_cost_distribution_lines_all.billable_flag%type;
1165: l_line_type VARCHAR2(1);
1166: l_line_num NUMBER ;
1167: l_denom_currency_code pa_expenditure_items_all.denom_currency_code%type;
1168: l_acct_currency_code pa_expenditure_items_all.acct_currency_code%type;

Line 1215: pa_cost_distribution_lines cdl,

1211: ei.projfunc_cost_rate_type,
1212: ei.projfunc_cost_exchange_rate,
1213: ei.work_type_id
1214: FROM pa_expenditure_items_all ei,
1215: pa_cost_distribution_lines cdl,
1216: pa_transaction_sources tr
1217: WHERE tr.transaction_source(+) = ei.transaction_source
1218: AND ei.expenditure_item_id = cdl.expenditure_item_id
1219: AND CDL.Transfer_Status_Code = 'Y';

Line 1280: FROM PA_COST_DISTRIBUTION_LINES_ALL CDL,

1276: l_projfunc_cost_rate_date,
1277: l_projfunc_cost_rate_type,
1278: l_projfunc_cost_exchange_rate,
1279: l_work_type_id
1280: FROM PA_COST_DISTRIBUTION_LINES_ALL CDL,
1281: PA_EXPENDITURE_ITEMS_ALL EI
1282: WHERE CDL.EXPENDITURE_ITEM_ID = EI.EXPENDITURE_ITEM_ID
1283: AND CDL.ROWID = chartorowid( p_cdl_rowid(1));
1284:

Line 1292: FROM pa_cost_distribution_lines CDL,

1288: /* Bug 4374769 : The following query selects the end_date of the GL period stamped on the 'R' line of the original expenditure item. */
1289:
1290: SELECT GPS.end_date
1291: INTO v_gl_per_end_dt
1292: FROM pa_cost_distribution_lines CDL,
1293: gl_period_statuses GPS
1294: WHERE GPS.application_id = 101
1295: AND GPS.set_of_books_id = l_sob_id
1296: AND GPS.adjustment_period_flag = 'N'

Line 1326: UPDATE PA_Cost_Distribution_lines CDL

1322:
1323:
1324: IF (l_pji_summarized_flag = 'N') THEN
1325:
1326: UPDATE PA_Cost_Distribution_lines CDL
1327: SET CDL.gl_date = l_prvdr_accr_date
1328: WHERE CDL.ROWID = chartorowid( p_cdl_rowid(1))
1329: AND CDL.TRANSFER_STATUS_CODE in ('P','R');
1330:

Line 1371: UPDATE PA_Cost_Distribution_lines CDL

1367: , P_mode => 'INTERFACE'
1368: , X_line_num => l_line_num
1369: );
1370:
1371: UPDATE PA_Cost_Distribution_lines CDL
1372: SET CDL.GL_DATE = l_prvdr_accr_date,
1373: CDL.GL_PERIOD_NAME = pa_utils2.get_gl_period_name (l_prvdr_accr_date,CDL.org_id)
1374: WHERE CDL.EXPENDITURE_ITEM_ID = l_exp_item_id
1375: AND CDL.LINE_NUM_REVERSED IS NULL

Line 1411: UPDATE PA_Cost_Distribution_lines CDL

1407: WHERE LOOK.Lookup_Type = 'TRANSFER REJECTION CODE'
1408: AND LOOK.Lookup_Code = 'TRANS_INV_DATA';
1409:
1410: FORALL i IN 1..p_local_set_size
1411: UPDATE PA_Cost_Distribution_lines CDL
1412: SET CDL.request_id = p_request_id(i)
1413: ,CDL.transfer_rejection_reason = l_reject_meaning
1414: ,CDL.transfer_status_code = 'X'
1415: ,CDL.Transferred_Date = SYSDATE

Line 1430: * FROM pa_cost_distribution_lines CDL,

1426: * ,CDL.GL_Date = ( SELECT pa_utils2.get_prvdr_gl_date(
1427: * MAX(CDL.pa_date)
1428: * ,p_application_id(i)
1429: * ,p_prvdr_sob_id(i))
1430: * FROM pa_cost_distribution_lines CDL,
1431: * pa_expenditure_items ITEM
1432: * WHERE ITEM.expenditure_item_id = CDL.expenditure_item_id
1433: * AND CDL.line_type = 'R'
1434: * AND ITEM.expenditure_id = p_expnd_id(i)

Line 1440: * FROM pa_cost_distribution_lines CDL,

1436: * ,CDL.Recvr_Gl_Date = ( SELECT pa_utils2.get_recvr_gl_date(
1437: * MAX(CDL.recvr_pa_date)
1438: * ,p_application_id(i)
1439: * ,p_recvr_sob_id(i))
1440: * FROM pa_cost_distribution_lines CDL,
1441: * pa_expenditure_items ITEM
1442: * WHERE ITEM.expenditure_item_id = CDL.expenditure_item_id
1443: * AND CDL.line_type = 'R'
1444: * AND ITEM.expenditure_id = p_expnd_id(i)

Line 1511: From PA_Cost_Distribution_lines CDL,PA_Expenditure_items_all EI,PA_Expenditures EXP

1507: ,p_recvr_sob_id(i))
1508: ,nvl(EI.recvr_org_id,CDL.org_id)) recvr_gl_period_name,
1509: 'Y' -- Interface to GL
1510: Into l_gl_date_new(i) , l_gl_period_new(i) , l_recvr_gl_date_new(i) , l_recvr_gl_period_new(i) , l_interface_to_gl(i)
1511: From PA_Cost_Distribution_lines CDL,PA_Expenditure_items_all EI,PA_Expenditures EXP
1512: Where CDL.Rowid = chartorowid( p_cdl_rowid(i) )
1513: AND CDL.Transfer_Status_Code in ('P','R')
1514: AND CDL.expenditure_item_id = EI.expenditure_item_id
1515: AND EXP.expenditure_id = EI.Expenditure_Id

Line 1559: UPDATE PA_Cost_Distribution_lines CDL

1555: GL Period. The reversed_flag will be NULL for the original 'R' cdl. */
1556:
1557:
1558: FORALL i IN 1..p_local_set_size
1559: UPDATE PA_Cost_Distribution_lines CDL
1560: SET CDL.request_id = p_request_id(i)
1561: ,CDL.transfer_status_code = Decode(l_interface_to_gl(i),
1562: 'Y', DECODE(l_gl_date_new(i),
1563: NULL,'R',

Line 1636: UPDATE PA_Cost_Distribution_lines CDL

1632: --(3)The new CDL would have the proper GL info with stutus 'X' for further processing.
1633:
1634: -- The following code is commented for Bug 4374769
1635: /* FORALL i IN 1..p_local_set_size
1636: UPDATE PA_Cost_Distribution_lines CDL
1637: SET CDL.request_id = p_request_id(i)
1638: ,CDL.transfer_status_code = DECODE(l_gl_date_new(i) -- Bug 3669746
1639: , NULL ,'R'
1640: ,DECODE(l_recvr_gl_date_new(i)

Line 1713: UPDATE PA_Cost_Distribution_lines CDL

1709: --Marking the ORIGINAL and REVERSING CDLs with transfer_status_code 'G'.
1710:
1711: -- Commented for Bug 4374769
1712: /* FORALL i IN 1..p_local_set_size
1713: UPDATE PA_Cost_Distribution_lines CDL
1714: SET CDL.request_id = p_request_id(i)
1715: ,CDL.transfer_status_code = 'G'
1716: ,CDL.Transferred_Date = SYSDATE
1717: WHERE CDL.Transfer_Status_Code in ('Y')

Line 1726: UPDATE PA_Cost_Distribution_lines CDL

1722: /* Bug 4374769 : The following code is modified to set the TRANSFER_STATUS_CODE to 'X' and rederive the GL_DATE, GL_PERIOD_NAME, RECVR_GL_DATE and
1723: RECVR_GL_PERIOD_NAME for the reversing and new cdls of line_type 'R' to further process and transfer them to GL. */
1724:
1725: FORALL i IN 1..p_local_set_size
1726: UPDATE PA_Cost_Distribution_lines CDL
1727: SET CDL.request_id = p_request_id(i)
1728: ,CDL.transfer_status_code = 'X'
1729: ,CDL.Transferred_Date = SYSDATE
1730: ,CDL.gl_date = Decode(l_interface_to_gl(i),'N',CDL.gl_date,nvl(l_gl_date_new(i),CDL.gl_date))

Line 1745: UPDATE PA_Cost_Distribution_lines CDL

1741: /*************************** Bug 3668005 Ends ****************************/
1742:
1743: ELSE
1744: FORALL i IN 1..p_local_set_size
1745: UPDATE PA_Cost_Distribution_lines CDL
1746: SET CDL.request_id = p_request_id(i)
1747: ,CDL.transfer_status_code = 'X'
1748: ,CDL.Transferred_Date = SYSDATE
1749: WHERE CDL.Rowid = chartorowid( p_cdl_rowid(i) )

Line 2452: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE

2448:
2449: PROCEDURE get_period_information ( p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
2450: ,p_expenditure_id IN pa_expenditure_items_all.expenditure_id%TYPE
2451: ,p_system_linkage_function IN pa_expenditure_items_all.system_linkage_function%TYPE
2452: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE
2453: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE
2454: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE
2455: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2456: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE

Line 2453: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE

2449: PROCEDURE get_period_information ( p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
2450: ,p_expenditure_id IN pa_expenditure_items_all.expenditure_id%TYPE
2451: ,p_system_linkage_function IN pa_expenditure_items_all.system_linkage_function%TYPE
2452: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE
2453: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE
2454: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE
2455: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2456: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2457: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE

Line 2454: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE

2450: ,p_expenditure_id IN pa_expenditure_items_all.expenditure_id%TYPE
2451: ,p_system_linkage_function IN pa_expenditure_items_all.system_linkage_function%TYPE
2452: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE
2453: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE
2454: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE
2455: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2456: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2457: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
2458: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE

Line 2455: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE

2451: ,p_system_linkage_function IN pa_expenditure_items_all.system_linkage_function%TYPE
2452: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE
2453: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE
2454: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE
2455: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2456: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2457: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
2458: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
2459: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE

Line 2456: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE

2452: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE
2453: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE
2454: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE
2455: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2456: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2457: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
2458: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
2459: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
2460: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE

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

2459: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
2460: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
2461: ,p_calling_module IN VARCHAR2
2462: ,p_ou_context IN VARCHAR2
2463: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
2464: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
2465: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
2466: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
2467: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE

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

2460: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
2461: ,p_calling_module IN VARCHAR2
2462: ,p_ou_context IN VARCHAR2
2463: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
2464: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
2465: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
2466: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
2467: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
2468: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE

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

2461: ,p_calling_module IN VARCHAR2
2462: ,p_ou_context IN VARCHAR2
2463: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
2464: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
2465: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
2466: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
2467: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
2468: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
2469: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE

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

2462: ,p_ou_context IN VARCHAR2
2463: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
2464: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
2465: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
2466: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
2467: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
2468: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
2469: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
2470: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE

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

2463: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
2464: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
2465: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
2466: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
2467: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
2468: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
2469: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
2470: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
2471: ,x_return_status OUT NOCOPY NUMBER

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

2464: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
2465: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
2466: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
2467: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
2468: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
2469: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
2470: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
2471: ,x_return_status OUT NOCOPY NUMBER
2472: ,x_error_code OUT NOCOPY VARCHAR2

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

2465: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
2466: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
2467: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
2468: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
2469: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
2470: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
2471: ,x_return_status OUT NOCOPY NUMBER
2472: ,x_error_code OUT NOCOPY VARCHAR2
2473: ,x_error_stage OUT NOCOPY NUMBER

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

2466: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
2467: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
2468: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
2469: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
2470: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
2471: ,x_return_status OUT NOCOPY NUMBER
2472: ,x_error_code OUT NOCOPY VARCHAR2
2473: ,x_error_stage OUT NOCOPY NUMBER
2474: )

Line 2476: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

2472: ,x_error_code OUT NOCOPY VARCHAR2
2473: ,x_error_stage OUT NOCOPY NUMBER
2474: )
2475: IS
2476: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2477: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
2478: l_prvdr_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2479: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2480:

Line 2477: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

2473: ,x_error_stage OUT NOCOPY NUMBER
2474: )
2475: IS
2476: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2477: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
2478: l_prvdr_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2479: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2480:
2481: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

Line 2478: l_prvdr_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

2474: )
2475: IS
2476: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2477: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
2478: l_prvdr_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2479: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2480:
2481: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2482: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

Line 2479: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;

2475: IS
2476: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2477: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
2478: l_prvdr_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2479: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2480:
2481: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2482: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
2483: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

Line 2481: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

2477: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
2478: l_prvdr_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2479: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2480:
2481: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2482: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
2483: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
2484: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2485:

Line 2482: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

2478: l_prvdr_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2479: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2480:
2481: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2482: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
2483: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
2484: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2485:
2486: /*Starts-Changes for 7535550 */

Line 2483: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

2479: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2480:
2481: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2482: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
2483: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
2484: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2485:
2486: /*Starts-Changes for 7535550 */
2487: p_prvdr_raw_pa_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

Line 2484: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;

2480:
2481: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2482: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
2483: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
2484: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2485:
2486: /*Starts-Changes for 7535550 */
2487: p_prvdr_raw_pa_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2488: p_recvr_raw_pa_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

Line 2487: p_prvdr_raw_pa_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

2483: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
2484: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2485:
2486: /*Starts-Changes for 7535550 */
2487: p_prvdr_raw_pa_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2488: p_recvr_raw_pa_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2489: p_prvdr_raw_gl_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2490: p_recvr_raw_gl_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2491:

Line 2488: p_recvr_raw_pa_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

2484: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2485:
2486: /*Starts-Changes for 7535550 */
2487: p_prvdr_raw_pa_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2488: p_recvr_raw_pa_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2489: p_prvdr_raw_gl_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2490: p_recvr_raw_gl_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2491:
2492: /*End-Changes for 7535550 */

Line 2489: p_prvdr_raw_gl_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

2485:
2486: /*Starts-Changes for 7535550 */
2487: p_prvdr_raw_pa_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2488: p_recvr_raw_pa_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2489: p_prvdr_raw_gl_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2490: p_recvr_raw_gl_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2491:
2492: /*End-Changes for 7535550 */
2493: l_pa_gl_app_id NUMBER := 8721 ;

Line 2490: p_recvr_raw_gl_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

2486: /*Starts-Changes for 7535550 */
2487: p_prvdr_raw_pa_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2488: p_recvr_raw_pa_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2489: p_prvdr_raw_gl_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2490: p_recvr_raw_gl_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2491:
2492: /*End-Changes for 7535550 */
2493: l_pa_gl_app_id NUMBER := 8721 ;
2494: l_gl_app_id NUMBER := 101;

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

3022: END get_period_information ;
3023: -----------------------------------------------------------------------
3024: PROCEDURE get_OU_period_information ( p_reference_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
3025: ,p_calling_module IN VARCHAR2
3026: ,x_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
3027: ,x_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
3028: ,x_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
3029: ,x_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
3030: ,x_return_status OUT NOCOPY NUMBER

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

3023: -----------------------------------------------------------------------
3024: PROCEDURE get_OU_period_information ( p_reference_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
3025: ,p_calling_module IN VARCHAR2
3026: ,x_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
3027: ,x_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
3028: ,x_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
3029: ,x_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
3030: ,x_return_status OUT NOCOPY NUMBER
3031: ,x_error_code OUT NOCOPY VARCHAR2

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

3024: PROCEDURE get_OU_period_information ( p_reference_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
3025: ,p_calling_module IN VARCHAR2
3026: ,x_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
3027: ,x_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
3028: ,x_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
3029: ,x_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
3030: ,x_return_status OUT NOCOPY NUMBER
3031: ,x_error_code OUT NOCOPY VARCHAR2
3032: ,x_error_stage OUT NOCOPY NUMBER

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

3025: ,p_calling_module IN VARCHAR2
3026: ,x_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
3027: ,x_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
3028: ,x_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
3029: ,x_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
3030: ,x_return_status OUT NOCOPY NUMBER
3031: ,x_error_code OUT NOCOPY VARCHAR2
3032: ,x_error_stage OUT NOCOPY NUMBER
3033: )

Line 3038: l_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

3034: IS
3035: l_org_id pa_implementations_all.org_id%TYPE;
3036: l_sob_id pa_implementations_all.set_of_books_id%TYPE;
3037:
3038: l_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3039: l_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
3040: l_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3041: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
3042:

Line 3039: l_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

3035: l_org_id pa_implementations_all.org_id%TYPE;
3036: l_sob_id pa_implementations_all.set_of_books_id%TYPE;
3037:
3038: l_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3039: l_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
3040: l_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3041: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
3042:
3043: l_return_status NUMBER ;

Line 3040: l_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

3036: l_sob_id pa_implementations_all.set_of_books_id%TYPE;
3037:
3038: l_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3039: l_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
3040: l_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3041: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
3042:
3043: l_return_status NUMBER ;
3044: l_stage NUMBER ;

Line 3041: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;

3037:
3038: l_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3039: l_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
3040: l_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3041: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
3042:
3043: l_return_status NUMBER ;
3044: l_stage NUMBER ;
3045: l_error_code VARCHAR2(30);

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

3129: RAISE;
3130: END get_OU_period_information;
3131:
3132: -----------------------------------------------------------------------
3133: FUNCTION get_gl_period_name ( p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
3134: ,p_org_id IN pa_cost_distribution_lines_all.org_id%TYPE
3135: )
3136: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE
3137: IS

Line 3134: ,p_org_id IN pa_cost_distribution_lines_all.org_id%TYPE

3130: END get_OU_period_information;
3131:
3132: -----------------------------------------------------------------------
3133: FUNCTION get_gl_period_name ( p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
3134: ,p_org_id IN pa_cost_distribution_lines_all.org_id%TYPE
3135: )
3136: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE
3137: IS
3138: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;

Line 3136: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE

3132: -----------------------------------------------------------------------
3133: FUNCTION get_gl_period_name ( p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
3134: ,p_org_id IN pa_cost_distribution_lines_all.org_id%TYPE
3135: )
3136: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE
3137: IS
3138: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;
3139: l_gl_period_start_date pa_cost_distribution_lines_all.gl_date%TYPE ;
3140: l_gl_period_end_date pa_cost_distribution_lines_all.gl_date%TYPE ;

Line 3138: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;

3134: ,p_org_id IN pa_cost_distribution_lines_all.org_id%TYPE
3135: )
3136: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE
3137: IS
3138: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;
3139: l_gl_period_start_date pa_cost_distribution_lines_all.gl_date%TYPE ;
3140: l_gl_period_end_date pa_cost_distribution_lines_all.gl_date%TYPE ;
3141:
3142: BEGIN

Line 3139: l_gl_period_start_date pa_cost_distribution_lines_all.gl_date%TYPE ;

3135: )
3136: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE
3137: IS
3138: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;
3139: l_gl_period_start_date pa_cost_distribution_lines_all.gl_date%TYPE ;
3140: l_gl_period_end_date pa_cost_distribution_lines_all.gl_date%TYPE ;
3141:
3142: BEGIN
3143: /*

Line 3140: l_gl_period_end_date pa_cost_distribution_lines_all.gl_date%TYPE ;

3136: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE
3137: IS
3138: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;
3139: l_gl_period_start_date pa_cost_distribution_lines_all.gl_date%TYPE ;
3140: l_gl_period_end_date pa_cost_distribution_lines_all.gl_date%TYPE ;
3141:
3142: BEGIN
3143: /*
3144: * Try to reuse the global cache.

Line 3251: l_org_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

3247: ,x_return_status OUT NOCOPY VARCHAR2
3248: ,x_error_code OUT NOCOPY VARCHAR2
3249: )
3250: IS
3251: l_org_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3252: l_org_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3253: l_org_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3254: l_org_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3255: l_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

Line 3252: l_org_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

3248: ,x_error_code OUT NOCOPY VARCHAR2
3249: )
3250: IS
3251: l_org_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3252: l_org_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3253: l_org_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3254: l_org_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3255: l_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3256: l_rev_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;

Line 3253: l_org_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

3249: )
3250: IS
3251: l_org_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3252: l_org_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3253: l_org_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3254: l_org_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3255: l_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3256: l_rev_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3257: l_org_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;

Line 3254: l_org_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;

3250: IS
3251: l_org_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3252: l_org_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3253: l_org_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3254: l_org_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3255: l_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3256: l_rev_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3257: l_org_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
3258: l_pa_overlaps_gl VARCHAR2(1) := 'N';

Line 3255: l_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

3251: l_org_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3252: l_org_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3253: l_org_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3254: l_org_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3255: l_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3256: l_rev_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3257: l_org_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
3258: l_pa_overlaps_gl VARCHAR2(1) := 'N';
3259: l_debug_mode VARCHAR2(1);

Line 3256: l_rev_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;

3252: l_org_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3253: l_org_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3254: l_org_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3255: l_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3256: l_rev_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3257: l_org_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
3258: l_pa_overlaps_gl VARCHAR2(1) := 'N';
3259: l_debug_mode VARCHAR2(1);
3260: BEGIN

Line 3257: l_org_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;

3253: l_org_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3254: l_org_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3255: l_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3256: l_rev_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3257: l_org_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
3258: l_pa_overlaps_gl VARCHAR2(1) := 'N';
3259: l_debug_mode VARCHAR2(1);
3260: BEGIN
3261:

Line 3574: l_org_accr_start_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

3570: x_error_stage OUT NOCOPY VARCHAR2
3571: )
3572: return date
3573: IS
3574: l_org_accr_start_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3575: l_org_accr_end_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3576: l_rev_accr_nxt_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3577: l_rev_accr_nxt_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3578:

Line 3575: l_org_accr_end_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

3571: )
3572: return date
3573: IS
3574: l_org_accr_start_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3575: l_org_accr_end_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3576: l_rev_accr_nxt_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3577: l_rev_accr_nxt_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3578:
3579: l_rev_accr_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

Line 3576: l_rev_accr_nxt_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

3572: return date
3573: IS
3574: l_org_accr_start_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3575: l_org_accr_end_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3576: l_rev_accr_nxt_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3577: l_rev_accr_nxt_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3578:
3579: l_rev_accr_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3580: l_period_status gl_period_statuses.closing_status%TYPE := NULL;

Line 3577: l_rev_accr_nxt_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

3573: IS
3574: l_org_accr_start_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3575: l_org_accr_end_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3576: l_rev_accr_nxt_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3577: l_rev_accr_nxt_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3578:
3579: l_rev_accr_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3580: l_period_status gl_period_statuses.closing_status%TYPE := NULL;
3581: l_period_name gl_period_statuses.period_name%TYPE := NULL;

Line 3579: l_rev_accr_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

3575: l_org_accr_end_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3576: l_rev_accr_nxt_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3577: l_rev_accr_nxt_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3578:
3579: l_rev_accr_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3580: l_period_status gl_period_statuses.closing_status%TYPE := NULL;
3581: l_period_name gl_period_statuses.period_name%TYPE := NULL;
3582: l_debug_mode VARCHAR2(1);
3583:

Line 3773: l_accr_gl_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

3769: x_error_code OUT NOCOPY VARCHAR2,
3770: x_error_stage OUT NOCOPY VARCHAR2
3771: )
3772: IS
3773: l_accr_gl_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
3774: l_accr_gl_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3775: l_accr_gl_period_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3776: l_accr_gl_period_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3777: l_period_status gl_period_statuses.closing_status%TYPE :=NULL;

Line 3774: l_accr_gl_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

3770: x_error_stage OUT NOCOPY VARCHAR2
3771: )
3772: IS
3773: l_accr_gl_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
3774: l_accr_gl_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3775: l_accr_gl_period_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3776: l_accr_gl_period_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3777: l_period_status gl_period_statuses.closing_status%TYPE :=NULL;
3778: l_debug_mode VARCHAR2(1);

Line 3775: l_accr_gl_period_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

3771: )
3772: IS
3773: l_accr_gl_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
3774: l_accr_gl_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3775: l_accr_gl_period_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3776: l_accr_gl_period_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3777: l_period_status gl_period_statuses.closing_status%TYPE :=NULL;
3778: l_debug_mode VARCHAR2(1);
3779: BEGIN

Line 3776: l_accr_gl_period_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

3772: IS
3773: l_accr_gl_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
3774: l_accr_gl_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3775: l_accr_gl_period_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3776: l_accr_gl_period_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3777: l_period_status gl_period_statuses.closing_status%TYPE :=NULL;
3778: l_debug_mode VARCHAR2(1);
3779: BEGIN
3780:

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

4046: ------------------------------------------------------------------------------------------------------
4047: *======================================================================================================*/
4048: ----------------------------------------------------------------------------------------------------------------
4049: PROCEDURE get_accrual_period_information(p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
4050: ,x_prvdr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4051: ,x_recvr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4052: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
4053: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
4054: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE

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

4047: *======================================================================================================*/
4048: ----------------------------------------------------------------------------------------------------------------
4049: PROCEDURE get_accrual_period_information(p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
4050: ,x_prvdr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4051: ,x_recvr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4052: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
4053: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
4054: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
4055: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE

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

4053: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
4054: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
4055: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
4056: ,p_calling_module IN VARCHAR2
4057: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
4058: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
4059: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4060: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
4061: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE

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

4054: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
4055: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
4056: ,p_calling_module IN VARCHAR2
4057: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
4058: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
4059: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4060: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
4061: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
4062: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE

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

4055: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
4056: ,p_calling_module IN VARCHAR2
4057: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
4058: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
4059: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4060: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
4061: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
4062: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
4063: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE

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

4056: ,p_calling_module IN VARCHAR2
4057: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
4058: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
4059: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4060: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
4061: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
4062: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
4063: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
4064: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE

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

4057: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
4058: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
4059: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4060: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
4061: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
4062: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
4063: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
4064: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
4065: ,p_adj_ei_id IN pa_expenditure_items_all.expenditure_item_id%type

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

4058: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
4059: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4060: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
4061: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
4062: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
4063: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
4064: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
4065: ,p_adj_ei_id IN pa_expenditure_items_all.expenditure_item_id%type
4066: ,p_acct_flag IN VARCHAR2

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

4059: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4060: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
4061: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
4062: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
4063: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
4064: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
4065: ,p_adj_ei_id IN pa_expenditure_items_all.expenditure_item_id%type
4066: ,p_acct_flag IN VARCHAR2
4067: ,x_return_status OUT NOCOPY VARCHAR2

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

4060: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
4061: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
4062: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
4063: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
4064: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
4065: ,p_adj_ei_id IN pa_expenditure_items_all.expenditure_item_id%type
4066: ,p_acct_flag IN VARCHAR2
4067: ,x_return_status OUT NOCOPY VARCHAR2
4068: ,x_error_code OUT NOCOPY VARCHAR2

Line 4072: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

4068: ,x_error_code OUT NOCOPY VARCHAR2
4069: ,x_error_stage OUT NOCOPY VARCHAR2
4070: )
4071: IS
4072: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4073: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4074: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4075: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4076: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

Line 4073: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

4069: ,x_error_stage OUT NOCOPY VARCHAR2
4070: )
4071: IS
4072: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4073: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4074: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4075: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4076: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4077: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;

Line 4074: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;

4070: )
4071: IS
4072: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4073: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4074: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4075: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4076: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4077: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4078: l_prvdr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

Line 4075: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

4071: IS
4072: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4073: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4074: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4075: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4076: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4077: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4078: l_prvdr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4079: l_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

Line 4076: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

4072: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4073: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4074: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4075: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4076: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4077: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4078: l_prvdr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4079: l_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4080: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

Line 4077: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;

4073: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4074: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4075: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4076: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4077: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4078: l_prvdr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4079: l_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4080: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4081: l_recvr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

Line 4078: l_prvdr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

4074: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4075: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4076: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4077: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4078: l_prvdr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4079: l_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4080: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4081: l_recvr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4082:

Line 4079: l_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

4075: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4076: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4077: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4078: l_prvdr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4079: l_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4080: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4081: l_recvr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4082:
4083: l_pa_gl_app_id NUMBER := 101; -- We always go against the GL Period.

Line 4080: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

4076: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4077: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4078: l_prvdr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4079: l_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4080: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4081: l_recvr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4082:
4083: l_pa_gl_app_id NUMBER := 101; -- We always go against the GL Period.
4084: l_gl_app_id NUMBER := 101;

Line 4081: l_recvr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

4077: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4078: l_prvdr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4079: l_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4080: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4081: l_recvr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4082:
4083: l_pa_gl_app_id NUMBER := 101; -- We always go against the GL Period.
4084: l_gl_app_id NUMBER := 101;
4085: l_app_id NUMBER := NULL ;

Line 5294: FROM pa_cost_distribution_lines cdl, pa_expenditures e,

5290: SELECT DISTINCT
5291: e.expenditure_id,
5292: e.incurred_by_person_id,
5293: e.expenditure_ending_date
5294: FROM pa_cost_distribution_lines cdl, pa_expenditures e,
5295: pa_expenditure_items ei
5296: WHERE TRUNC(CDL.GL_DATE) <= NVL(gl_date,TRUNC(CDL.GL_DATE))
5297: AND cdl.expenditure_item_id = ei.expenditure_item_id
5298: AND cdl.Transfer_Status_Code IN ('P', 'R', 'X')

Line 5310: FROM pa_cost_distribution_lines cdl, pa_expenditures e,

5306: SELECT DISTINCT
5307: e.expenditure_id,
5308: e.incurred_by_person_id,
5309: e.expenditure_ending_date
5310: FROM pa_cost_distribution_lines cdl, pa_expenditures e,
5311: pa_expenditure_items ei
5312: WHERE cdl.expenditure_item_id = ei.expenditure_item_id
5313: AND cdl.Transfer_Status_Code = 'X'
5314: AND cdl.Line_Type = 'R'