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.

[Home] [Help]

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.15.12010000.2 2008/08/22 16:16:51 mumohan 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 1148: l_billable_flag pa_cost_distribution_lines_all.billable_flag%type;

1144: l_exp_item_id pa_expenditure_items_all.expenditure_item_id%type;
1145: l_gl_date DATE;
1146: l_pji_summarized_flag VARCHAR2(1);
1147: l_prvdr_accr_date DATE;
1148: l_billable_flag pa_cost_distribution_lines_all.billable_flag%type;
1149: l_line_type VARCHAR2(1);
1150: l_line_num NUMBER ;
1151: l_denom_currency_code pa_expenditure_items_all.denom_currency_code%type;
1152: l_acct_currency_code pa_expenditure_items_all.acct_currency_code%type;

Line 1199: pa_cost_distribution_lines cdl,

1195: ei.projfunc_cost_rate_type,
1196: ei.projfunc_cost_exchange_rate,
1197: ei.work_type_id
1198: FROM pa_expenditure_items_all ei,
1199: pa_cost_distribution_lines cdl,
1200: pa_transaction_sources tr
1201: WHERE tr.transaction_source(+) = ei.transaction_source
1202: AND ei.expenditure_item_id = cdl.expenditure_item_id
1203: AND CDL.Transfer_Status_Code = 'Y';

Line 1264: FROM PA_COST_DISTRIBUTION_LINES_ALL CDL,

1260: l_projfunc_cost_rate_date,
1261: l_projfunc_cost_rate_type,
1262: l_projfunc_cost_exchange_rate,
1263: l_work_type_id
1264: FROM PA_COST_DISTRIBUTION_LINES_ALL CDL,
1265: PA_EXPENDITURE_ITEMS_ALL EI
1266: WHERE CDL.EXPENDITURE_ITEM_ID = EI.EXPENDITURE_ITEM_ID
1267: AND CDL.ROWID = chartorowid( p_cdl_rowid(1));
1268:

Line 1276: FROM pa_cost_distribution_lines CDL,

1272: /* Bug 4374769 : The following query selects the end_date of the GL period stamped on the 'R' line of the original expenditure item. */
1273:
1274: SELECT GPS.end_date
1275: INTO v_gl_per_end_dt
1276: FROM pa_cost_distribution_lines CDL,
1277: gl_period_statuses GPS
1278: WHERE GPS.application_id = 101
1279: AND GPS.set_of_books_id = l_sob_id
1280: AND GPS.adjustment_period_flag = 'N'

Line 1310: UPDATE PA_Cost_Distribution_lines CDL

1306:
1307:
1308: IF (l_pji_summarized_flag = 'N') THEN
1309:
1310: UPDATE PA_Cost_Distribution_lines CDL
1311: SET CDL.gl_date = l_prvdr_accr_date
1312: WHERE CDL.ROWID = chartorowid( p_cdl_rowid(1))
1313: AND CDL.TRANSFER_STATUS_CODE in ('P','R');
1314:

Line 1355: UPDATE PA_Cost_Distribution_lines CDL

1351: , P_mode => 'INTERFACE'
1352: , X_line_num => l_line_num
1353: );
1354:
1355: UPDATE PA_Cost_Distribution_lines CDL
1356: SET CDL.GL_DATE = l_prvdr_accr_date,
1357: CDL.GL_PERIOD_NAME = pa_utils2.get_gl_period_name (l_prvdr_accr_date,CDL.org_id)
1358: WHERE CDL.EXPENDITURE_ITEM_ID = l_exp_item_id
1359: AND CDL.LINE_NUM_REVERSED IS NULL

Line 1395: UPDATE PA_Cost_Distribution_lines CDL

1391: WHERE LOOK.Lookup_Type = 'TRANSFER REJECTION CODE'
1392: AND LOOK.Lookup_Code = 'TRANS_INV_DATA';
1393:
1394: FORALL i IN 1..p_local_set_size
1395: UPDATE PA_Cost_Distribution_lines CDL
1396: SET CDL.request_id = p_request_id(i)
1397: ,CDL.transfer_rejection_reason = l_reject_meaning
1398: ,CDL.transfer_status_code = 'X'
1399: ,CDL.Transferred_Date = SYSDATE

Line 1414: * FROM pa_cost_distribution_lines CDL,

1410: * ,CDL.GL_Date = ( SELECT pa_utils2.get_prvdr_gl_date(
1411: * MAX(CDL.pa_date)
1412: * ,p_application_id(i)
1413: * ,p_prvdr_sob_id(i))
1414: * FROM pa_cost_distribution_lines CDL,
1415: * pa_expenditure_items ITEM
1416: * WHERE ITEM.expenditure_item_id = CDL.expenditure_item_id
1417: * AND CDL.line_type = 'R'
1418: * AND ITEM.expenditure_id = p_expnd_id(i)

Line 1424: * FROM pa_cost_distribution_lines CDL,

1420: * ,CDL.Recvr_Gl_Date = ( SELECT pa_utils2.get_recvr_gl_date(
1421: * MAX(CDL.recvr_pa_date)
1422: * ,p_application_id(i)
1423: * ,p_recvr_sob_id(i))
1424: * FROM pa_cost_distribution_lines CDL,
1425: * pa_expenditure_items ITEM
1426: * WHERE ITEM.expenditure_item_id = CDL.expenditure_item_id
1427: * AND CDL.line_type = 'R'
1428: * AND ITEM.expenditure_id = p_expnd_id(i)

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

1491: ,p_recvr_sob_id(i))
1492: ,nvl(EI.recvr_org_id,CDL.org_id)) recvr_gl_period_name,
1493: 'Y' -- Interface to GL
1494: 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)
1495: From PA_Cost_Distribution_lines CDL,PA_Expenditure_items_all EI,PA_Expenditures EXP
1496: Where CDL.Rowid = chartorowid( p_cdl_rowid(i) )
1497: AND CDL.Transfer_Status_Code in ('P','R')
1498: AND CDL.expenditure_item_id = EI.expenditure_item_id
1499: AND EXP.expenditure_id = EI.Expenditure_Id

Line 1543: UPDATE PA_Cost_Distribution_lines CDL

1539: GL Period. The reversed_flag will be NULL for the original 'R' cdl. */
1540:
1541:
1542: FORALL i IN 1..p_local_set_size
1543: UPDATE PA_Cost_Distribution_lines CDL
1544: SET CDL.request_id = p_request_id(i)
1545: ,CDL.transfer_status_code = Decode(l_interface_to_gl(i),
1546: 'Y', DECODE(l_gl_date_new(i),
1547: NULL,'R',

Line 1620: UPDATE PA_Cost_Distribution_lines CDL

1616: --(3)The new CDL would have the proper GL info with stutus 'X' for further processing.
1617:
1618: -- The following code is commented for Bug 4374769
1619: /* FORALL i IN 1..p_local_set_size
1620: UPDATE PA_Cost_Distribution_lines CDL
1621: SET CDL.request_id = p_request_id(i)
1622: ,CDL.transfer_status_code = DECODE(l_gl_date_new(i) -- Bug 3669746
1623: , NULL ,'R'
1624: ,DECODE(l_recvr_gl_date_new(i)

Line 1697: UPDATE PA_Cost_Distribution_lines CDL

1693: --Marking the ORIGINAL and REVERSING CDLs with transfer_status_code 'G'.
1694:
1695: -- Commented for Bug 4374769
1696: /* FORALL i IN 1..p_local_set_size
1697: UPDATE PA_Cost_Distribution_lines CDL
1698: SET CDL.request_id = p_request_id(i)
1699: ,CDL.transfer_status_code = 'G'
1700: ,CDL.Transferred_Date = SYSDATE
1701: WHERE CDL.Transfer_Status_Code in ('Y')

Line 1710: UPDATE PA_Cost_Distribution_lines CDL

1706: /* 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
1707: RECVR_GL_PERIOD_NAME for the reversing and new cdls of line_type 'R' to further process and transfer them to GL. */
1708:
1709: FORALL i IN 1..p_local_set_size
1710: UPDATE PA_Cost_Distribution_lines CDL
1711: SET CDL.request_id = p_request_id(i)
1712: ,CDL.transfer_status_code = 'X'
1713: ,CDL.Transferred_Date = SYSDATE
1714: ,CDL.gl_date = Decode(l_interface_to_gl(i),'N',CDL.gl_date,nvl(l_gl_date_new(i),CDL.gl_date))

Line 1729: UPDATE PA_Cost_Distribution_lines CDL

1725: /*************************** Bug 3668005 Ends ****************************/
1726:
1727: ELSE
1728: FORALL i IN 1..p_local_set_size
1729: UPDATE PA_Cost_Distribution_lines CDL
1730: SET CDL.request_id = p_request_id(i)
1731: ,CDL.transfer_status_code = 'X'
1732: ,CDL.Transferred_Date = SYSDATE
1733: WHERE CDL.Rowid = chartorowid( p_cdl_rowid(i) )

Line 2435: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE

2431:
2432: PROCEDURE get_period_information ( p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
2433: ,p_expenditure_id IN pa_expenditure_items_all.expenditure_id%TYPE
2434: ,p_system_linkage_function IN pa_expenditure_items_all.system_linkage_function%TYPE
2435: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE
2436: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE
2437: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE
2438: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2439: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE

Line 2436: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE

2432: PROCEDURE get_period_information ( p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
2433: ,p_expenditure_id IN pa_expenditure_items_all.expenditure_id%TYPE
2434: ,p_system_linkage_function IN pa_expenditure_items_all.system_linkage_function%TYPE
2435: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE
2436: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE
2437: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE
2438: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2439: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2440: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE

Line 2437: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE

2433: ,p_expenditure_id IN pa_expenditure_items_all.expenditure_id%TYPE
2434: ,p_system_linkage_function IN pa_expenditure_items_all.system_linkage_function%TYPE
2435: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE
2436: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE
2437: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE
2438: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2439: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2440: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
2441: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE

Line 2438: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE

2434: ,p_system_linkage_function IN pa_expenditure_items_all.system_linkage_function%TYPE
2435: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE
2436: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE
2437: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE
2438: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2439: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2440: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
2441: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
2442: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE

Line 2439: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE

2435: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE
2436: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE
2437: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE
2438: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2439: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2440: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
2441: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
2442: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
2443: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE

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

2442: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
2443: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
2444: ,p_calling_module IN VARCHAR2
2445: ,p_ou_context IN VARCHAR2
2446: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
2447: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
2448: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
2449: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
2450: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE

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

2443: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
2444: ,p_calling_module IN VARCHAR2
2445: ,p_ou_context IN VARCHAR2
2446: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
2447: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
2448: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
2449: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
2450: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
2451: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE

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

2444: ,p_calling_module IN VARCHAR2
2445: ,p_ou_context IN VARCHAR2
2446: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
2447: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
2448: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
2449: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
2450: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
2451: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
2452: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE

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

2445: ,p_ou_context IN VARCHAR2
2446: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
2447: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
2448: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
2449: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
2450: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
2451: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
2452: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
2453: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE

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

2446: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
2447: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
2448: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
2449: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
2450: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
2451: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
2452: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
2453: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
2454: ,x_return_status OUT NOCOPY NUMBER

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

2447: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
2448: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
2449: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
2450: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
2451: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
2452: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
2453: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
2454: ,x_return_status OUT NOCOPY NUMBER
2455: ,x_error_code OUT NOCOPY VARCHAR2

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

2448: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
2449: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
2450: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
2451: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
2452: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
2453: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
2454: ,x_return_status OUT NOCOPY NUMBER
2455: ,x_error_code OUT NOCOPY VARCHAR2
2456: ,x_error_stage OUT NOCOPY NUMBER

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

2449: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
2450: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
2451: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
2452: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
2453: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
2454: ,x_return_status OUT NOCOPY NUMBER
2455: ,x_error_code OUT NOCOPY VARCHAR2
2456: ,x_error_stage OUT NOCOPY NUMBER
2457: )

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

2455: ,x_error_code OUT NOCOPY VARCHAR2
2456: ,x_error_stage OUT NOCOPY NUMBER
2457: )
2458: IS
2459: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2460: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
2461: l_prvdr_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2462: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2463:

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

2456: ,x_error_stage OUT NOCOPY NUMBER
2457: )
2458: IS
2459: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2460: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
2461: l_prvdr_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2462: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2463:
2464: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

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

2457: )
2458: IS
2459: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2460: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
2461: l_prvdr_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2462: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2463:
2464: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2465: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

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

2458: IS
2459: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2460: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
2461: l_prvdr_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2462: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2463:
2464: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2465: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
2466: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

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

2460: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
2461: l_prvdr_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2462: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2463:
2464: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2465: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
2466: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
2467: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2468:

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

2461: l_prvdr_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2462: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2463:
2464: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2465: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
2466: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
2467: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2468:
2469: l_pa_gl_app_id NUMBER := 8721 ;

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

2462: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2463:
2464: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2465: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
2466: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
2467: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2468:
2469: l_pa_gl_app_id NUMBER := 8721 ;
2470: l_gl_app_id NUMBER := 101;

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

2463:
2464: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2465: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
2466: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
2467: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2468:
2469: l_pa_gl_app_id NUMBER := 8721 ;
2470: l_gl_app_id NUMBER := 101;
2471: l_ar_app_id NUMBER := 222;

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

2984: END get_period_information ;
2985: -----------------------------------------------------------------------
2986: PROCEDURE get_OU_period_information ( p_reference_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
2987: ,p_calling_module IN VARCHAR2
2988: ,x_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
2989: ,x_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
2990: ,x_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
2991: ,x_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
2992: ,x_return_status OUT NOCOPY NUMBER

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

2985: -----------------------------------------------------------------------
2986: PROCEDURE get_OU_period_information ( p_reference_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
2987: ,p_calling_module IN VARCHAR2
2988: ,x_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
2989: ,x_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
2990: ,x_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
2991: ,x_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
2992: ,x_return_status OUT NOCOPY NUMBER
2993: ,x_error_code OUT NOCOPY VARCHAR2

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

2986: PROCEDURE get_OU_period_information ( p_reference_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
2987: ,p_calling_module IN VARCHAR2
2988: ,x_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
2989: ,x_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
2990: ,x_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
2991: ,x_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
2992: ,x_return_status OUT NOCOPY NUMBER
2993: ,x_error_code OUT NOCOPY VARCHAR2
2994: ,x_error_stage OUT NOCOPY NUMBER

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

2987: ,p_calling_module IN VARCHAR2
2988: ,x_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
2989: ,x_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
2990: ,x_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
2991: ,x_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
2992: ,x_return_status OUT NOCOPY NUMBER
2993: ,x_error_code OUT NOCOPY VARCHAR2
2994: ,x_error_stage OUT NOCOPY NUMBER
2995: )

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

2996: IS
2997: l_org_id pa_implementations_all.org_id%TYPE;
2998: l_sob_id pa_implementations_all.set_of_books_id%TYPE;
2999:
3000: l_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3001: l_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
3002: l_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3003: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
3004:

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

2997: l_org_id pa_implementations_all.org_id%TYPE;
2998: l_sob_id pa_implementations_all.set_of_books_id%TYPE;
2999:
3000: l_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3001: l_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
3002: l_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3003: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
3004:
3005: l_return_status NUMBER ;

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

2998: l_sob_id pa_implementations_all.set_of_books_id%TYPE;
2999:
3000: l_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3001: l_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
3002: l_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3003: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
3004:
3005: l_return_status NUMBER ;
3006: l_stage NUMBER ;

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

2999:
3000: l_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3001: l_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
3002: l_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3003: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
3004:
3005: l_return_status NUMBER ;
3006: l_stage NUMBER ;
3007: l_error_code VARCHAR2(30);

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

3091: RAISE;
3092: END get_OU_period_information;
3093:
3094: -----------------------------------------------------------------------
3095: FUNCTION get_gl_period_name ( p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
3096: ,p_org_id IN pa_cost_distribution_lines_all.org_id%TYPE
3097: )
3098: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE
3099: IS

Line 3096: ,p_org_id IN pa_cost_distribution_lines_all.org_id%TYPE

3092: END get_OU_period_information;
3093:
3094: -----------------------------------------------------------------------
3095: FUNCTION get_gl_period_name ( p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
3096: ,p_org_id IN pa_cost_distribution_lines_all.org_id%TYPE
3097: )
3098: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE
3099: IS
3100: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;

Line 3098: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE

3094: -----------------------------------------------------------------------
3095: FUNCTION get_gl_period_name ( p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
3096: ,p_org_id IN pa_cost_distribution_lines_all.org_id%TYPE
3097: )
3098: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE
3099: IS
3100: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;
3101: l_gl_period_start_date pa_cost_distribution_lines_all.gl_date%TYPE ;
3102: l_gl_period_end_date pa_cost_distribution_lines_all.gl_date%TYPE ;

Line 3100: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;

3096: ,p_org_id IN pa_cost_distribution_lines_all.org_id%TYPE
3097: )
3098: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE
3099: IS
3100: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;
3101: l_gl_period_start_date pa_cost_distribution_lines_all.gl_date%TYPE ;
3102: l_gl_period_end_date pa_cost_distribution_lines_all.gl_date%TYPE ;
3103:
3104: BEGIN

Line 3101: l_gl_period_start_date pa_cost_distribution_lines_all.gl_date%TYPE ;

3097: )
3098: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE
3099: IS
3100: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;
3101: l_gl_period_start_date pa_cost_distribution_lines_all.gl_date%TYPE ;
3102: l_gl_period_end_date pa_cost_distribution_lines_all.gl_date%TYPE ;
3103:
3104: BEGIN
3105: /*

Line 3102: l_gl_period_end_date pa_cost_distribution_lines_all.gl_date%TYPE ;

3098: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE
3099: IS
3100: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;
3101: l_gl_period_start_date pa_cost_distribution_lines_all.gl_date%TYPE ;
3102: l_gl_period_end_date pa_cost_distribution_lines_all.gl_date%TYPE ;
3103:
3104: BEGIN
3105: /*
3106: * Try to reuse the global cache.

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

3209: ,x_return_status OUT NOCOPY VARCHAR2
3210: ,x_error_code OUT NOCOPY VARCHAR2
3211: )
3212: IS
3213: l_org_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3214: l_org_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3215: l_org_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3216: l_org_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3217: l_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

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

3210: ,x_error_code OUT NOCOPY VARCHAR2
3211: )
3212: IS
3213: l_org_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3214: l_org_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3215: l_org_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3216: l_org_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3217: l_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3218: l_rev_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;

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

3211: )
3212: IS
3213: l_org_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3214: l_org_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3215: l_org_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3216: l_org_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3217: l_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3218: l_rev_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3219: l_org_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;

Line 3216: l_org_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;

3212: IS
3213: l_org_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3214: l_org_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3215: l_org_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3216: l_org_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3217: l_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3218: l_rev_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3219: l_org_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
3220: l_pa_overlaps_gl VARCHAR2(1) := 'N';

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

3213: l_org_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3214: l_org_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3215: l_org_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3216: l_org_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3217: l_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3218: l_rev_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3219: l_org_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
3220: l_pa_overlaps_gl VARCHAR2(1) := 'N';
3221: l_debug_mode VARCHAR2(1);

Line 3218: l_rev_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;

3214: l_org_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3215: l_org_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3216: l_org_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3217: l_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3218: l_rev_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3219: l_org_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
3220: l_pa_overlaps_gl VARCHAR2(1) := 'N';
3221: l_debug_mode VARCHAR2(1);
3222: BEGIN

Line 3219: l_org_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;

3215: l_org_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3216: l_org_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3217: l_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3218: l_rev_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3219: l_org_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
3220: l_pa_overlaps_gl VARCHAR2(1) := 'N';
3221: l_debug_mode VARCHAR2(1);
3222: BEGIN
3223:

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

3532: x_error_stage OUT NOCOPY VARCHAR2
3533: )
3534: return date
3535: IS
3536: l_org_accr_start_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3537: l_org_accr_end_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3538: l_rev_accr_nxt_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3539: l_rev_accr_nxt_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3540:

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

3533: )
3534: return date
3535: IS
3536: l_org_accr_start_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3537: l_org_accr_end_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3538: l_rev_accr_nxt_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3539: l_rev_accr_nxt_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3540:
3541: l_rev_accr_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

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

3534: return date
3535: IS
3536: l_org_accr_start_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3537: l_org_accr_end_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3538: l_rev_accr_nxt_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3539: l_rev_accr_nxt_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3540:
3541: l_rev_accr_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3542: l_period_status gl_period_statuses.closing_status%TYPE := NULL;

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

3535: IS
3536: l_org_accr_start_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3537: l_org_accr_end_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3538: l_rev_accr_nxt_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3539: l_rev_accr_nxt_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3540:
3541: l_rev_accr_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3542: l_period_status gl_period_statuses.closing_status%TYPE := NULL;
3543: l_period_name gl_period_statuses.period_name%TYPE := NULL;

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

3537: l_org_accr_end_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3538: l_rev_accr_nxt_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3539: l_rev_accr_nxt_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3540:
3541: l_rev_accr_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3542: l_period_status gl_period_statuses.closing_status%TYPE := NULL;
3543: l_period_name gl_period_statuses.period_name%TYPE := NULL;
3544: l_debug_mode VARCHAR2(1);
3545:

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

3731: x_error_code OUT NOCOPY VARCHAR2,
3732: x_error_stage OUT NOCOPY VARCHAR2
3733: )
3734: IS
3735: l_accr_gl_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
3736: l_accr_gl_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3737: l_accr_gl_period_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3738: l_accr_gl_period_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3739: l_period_status gl_period_statuses.closing_status%TYPE :=NULL;

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

3732: x_error_stage OUT NOCOPY VARCHAR2
3733: )
3734: IS
3735: l_accr_gl_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
3736: l_accr_gl_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3737: l_accr_gl_period_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3738: l_accr_gl_period_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3739: l_period_status gl_period_statuses.closing_status%TYPE :=NULL;
3740: l_debug_mode VARCHAR2(1);

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

3733: )
3734: IS
3735: l_accr_gl_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
3736: l_accr_gl_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3737: l_accr_gl_period_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3738: l_accr_gl_period_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3739: l_period_status gl_period_statuses.closing_status%TYPE :=NULL;
3740: l_debug_mode VARCHAR2(1);
3741: BEGIN

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

3734: IS
3735: l_accr_gl_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
3736: l_accr_gl_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3737: l_accr_gl_period_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3738: l_accr_gl_period_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3739: l_period_status gl_period_statuses.closing_status%TYPE :=NULL;
3740: l_debug_mode VARCHAR2(1);
3741: BEGIN
3742:

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

4008: ------------------------------------------------------------------------------------------------------
4009: *======================================================================================================*/
4010: ----------------------------------------------------------------------------------------------------------------
4011: PROCEDURE get_accrual_period_information(p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
4012: ,x_prvdr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4013: ,x_recvr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4014: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
4015: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
4016: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE

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

4009: *======================================================================================================*/
4010: ----------------------------------------------------------------------------------------------------------------
4011: PROCEDURE get_accrual_period_information(p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
4012: ,x_prvdr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4013: ,x_recvr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4014: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
4015: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
4016: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
4017: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE

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

4015: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
4016: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
4017: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
4018: ,p_calling_module IN VARCHAR2
4019: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
4020: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
4021: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4022: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
4023: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE

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

4016: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
4017: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
4018: ,p_calling_module IN VARCHAR2
4019: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
4020: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
4021: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4022: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
4023: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
4024: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE

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

4017: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
4018: ,p_calling_module IN VARCHAR2
4019: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
4020: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
4021: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4022: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
4023: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
4024: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
4025: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE

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

4018: ,p_calling_module IN VARCHAR2
4019: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
4020: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
4021: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4022: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
4023: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
4024: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
4025: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
4026: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE

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

4019: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
4020: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
4021: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4022: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
4023: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
4024: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
4025: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
4026: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
4027: ,p_adj_ei_id IN pa_expenditure_items_all.expenditure_item_id%type

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

4020: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
4021: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4022: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
4023: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
4024: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
4025: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
4026: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
4027: ,p_adj_ei_id IN pa_expenditure_items_all.expenditure_item_id%type
4028: ,p_acct_flag IN VARCHAR2

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

4021: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4022: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
4023: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
4024: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
4025: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
4026: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
4027: ,p_adj_ei_id IN pa_expenditure_items_all.expenditure_item_id%type
4028: ,p_acct_flag IN VARCHAR2
4029: ,x_return_status OUT NOCOPY VARCHAR2

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

4022: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
4023: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
4024: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
4025: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
4026: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
4027: ,p_adj_ei_id IN pa_expenditure_items_all.expenditure_item_id%type
4028: ,p_acct_flag IN VARCHAR2
4029: ,x_return_status OUT NOCOPY VARCHAR2
4030: ,x_error_code OUT NOCOPY VARCHAR2

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

4030: ,x_error_code OUT NOCOPY VARCHAR2
4031: ,x_error_stage OUT NOCOPY VARCHAR2
4032: )
4033: IS
4034: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4035: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4036: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4037: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4038: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

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

4031: ,x_error_stage OUT NOCOPY VARCHAR2
4032: )
4033: IS
4034: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4035: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4036: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4037: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4038: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4039: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;

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

4032: )
4033: IS
4034: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4035: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4036: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4037: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4038: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4039: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4040: l_prvdr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

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

4033: IS
4034: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4035: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4036: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4037: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4038: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4039: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4040: l_prvdr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4041: l_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

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

4034: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4035: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4036: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4037: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4038: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4039: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4040: l_prvdr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4041: l_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4042: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

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

4035: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4036: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4037: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4038: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4039: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4040: l_prvdr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4041: l_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4042: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4043: l_recvr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

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

4036: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4037: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4038: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4039: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4040: l_prvdr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4041: l_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4042: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4043: l_recvr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4044:

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

4037: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4038: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4039: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4040: l_prvdr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4041: l_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4042: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4043: l_recvr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4044:
4045: l_pa_gl_app_id NUMBER := 101; -- We always go against the GL Period.

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

4038: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4039: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4040: l_prvdr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4041: l_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4042: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4043: l_recvr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4044:
4045: l_pa_gl_app_id NUMBER := 101; -- We always go against the GL Period.
4046: l_gl_app_id NUMBER := 101;

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

4039: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4040: l_prvdr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4041: l_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4042: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4043: l_recvr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4044:
4045: l_pa_gl_app_id NUMBER := 101; -- We always go against the GL Period.
4046: l_gl_app_id NUMBER := 101;
4047: l_app_id NUMBER := NULL ;