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_EXPENDITURE_ITEMS_ALL

Line 1143: l_adj_exp_item_id pa_expenditure_items_all.adjusted_expenditure_item_id%type;

1139: l_interface_to_gl PA_PLSQL_DATATYPES.Char1TabTyp;
1140:
1141: -- Bug 4374769 : The following variables are introduced as part of this bug.
1142: v_gl_per_end_dt DATE;
1143: l_adj_exp_item_id pa_expenditure_items_all.adjusted_expenditure_item_id%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;

Line 1144: l_exp_item_id pa_expenditure_items_all.expenditure_item_id%type;

1140:
1141: -- Bug 4374769 : The following variables are introduced as part of this bug.
1142: v_gl_per_end_dt DATE;
1143: l_adj_exp_item_id pa_expenditure_items_all.adjusted_expenditure_item_id%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;

Line 1151: l_denom_currency_code pa_expenditure_items_all.denom_currency_code%type;

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;
1153: l_acct_rate_date pa_expenditure_items_all.acct_rate_date%type;
1154: l_acct_rate_type pa_expenditure_items_all.acct_rate_type%type;
1155: l_acct_exchange_rate pa_expenditure_items_all.acct_exchange_rate%type;

Line 1152: l_acct_currency_code pa_expenditure_items_all.acct_currency_code%type;

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;
1153: l_acct_rate_date pa_expenditure_items_all.acct_rate_date%type;
1154: l_acct_rate_type pa_expenditure_items_all.acct_rate_type%type;
1155: l_acct_exchange_rate pa_expenditure_items_all.acct_exchange_rate%type;
1156: l_project_currency_code pa_expenditure_items_all.project_currency_code%type;

Line 1153: l_acct_rate_date pa_expenditure_items_all.acct_rate_date%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;
1153: l_acct_rate_date pa_expenditure_items_all.acct_rate_date%type;
1154: l_acct_rate_type pa_expenditure_items_all.acct_rate_type%type;
1155: l_acct_exchange_rate pa_expenditure_items_all.acct_exchange_rate%type;
1156: l_project_currency_code pa_expenditure_items_all.project_currency_code%type;
1157: l_project_rate_date pa_expenditure_items_all.project_rate_date%type;

Line 1154: l_acct_rate_type pa_expenditure_items_all.acct_rate_type%type;

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;
1153: l_acct_rate_date pa_expenditure_items_all.acct_rate_date%type;
1154: l_acct_rate_type pa_expenditure_items_all.acct_rate_type%type;
1155: l_acct_exchange_rate pa_expenditure_items_all.acct_exchange_rate%type;
1156: l_project_currency_code pa_expenditure_items_all.project_currency_code%type;
1157: l_project_rate_date pa_expenditure_items_all.project_rate_date%type;
1158: l_project_rate_type pa_expenditure_items_all.project_rate_type%type;

Line 1155: l_acct_exchange_rate pa_expenditure_items_all.acct_exchange_rate%type;

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;
1153: l_acct_rate_date pa_expenditure_items_all.acct_rate_date%type;
1154: l_acct_rate_type pa_expenditure_items_all.acct_rate_type%type;
1155: l_acct_exchange_rate pa_expenditure_items_all.acct_exchange_rate%type;
1156: l_project_currency_code pa_expenditure_items_all.project_currency_code%type;
1157: l_project_rate_date pa_expenditure_items_all.project_rate_date%type;
1158: l_project_rate_type pa_expenditure_items_all.project_rate_type%type;
1159: l_project_exchange_rate pa_expenditure_items_all.project_exchange_rate%type;

Line 1156: l_project_currency_code pa_expenditure_items_all.project_currency_code%type;

1152: l_acct_currency_code pa_expenditure_items_all.acct_currency_code%type;
1153: l_acct_rate_date pa_expenditure_items_all.acct_rate_date%type;
1154: l_acct_rate_type pa_expenditure_items_all.acct_rate_type%type;
1155: l_acct_exchange_rate pa_expenditure_items_all.acct_exchange_rate%type;
1156: l_project_currency_code pa_expenditure_items_all.project_currency_code%type;
1157: l_project_rate_date pa_expenditure_items_all.project_rate_date%type;
1158: l_project_rate_type pa_expenditure_items_all.project_rate_type%type;
1159: l_project_exchange_rate pa_expenditure_items_all.project_exchange_rate%type;
1160: l_projfunc_currency_code pa_expenditure_items_all.projfunc_currency_code%type;

Line 1157: l_project_rate_date pa_expenditure_items_all.project_rate_date%type;

1153: l_acct_rate_date pa_expenditure_items_all.acct_rate_date%type;
1154: l_acct_rate_type pa_expenditure_items_all.acct_rate_type%type;
1155: l_acct_exchange_rate pa_expenditure_items_all.acct_exchange_rate%type;
1156: l_project_currency_code pa_expenditure_items_all.project_currency_code%type;
1157: l_project_rate_date pa_expenditure_items_all.project_rate_date%type;
1158: l_project_rate_type pa_expenditure_items_all.project_rate_type%type;
1159: l_project_exchange_rate pa_expenditure_items_all.project_exchange_rate%type;
1160: l_projfunc_currency_code pa_expenditure_items_all.projfunc_currency_code%type;
1161: l_projfunc_cost_rate_date pa_expenditure_items_all.projfunc_cost_rate_date%type;

Line 1158: l_project_rate_type pa_expenditure_items_all.project_rate_type%type;

1154: l_acct_rate_type pa_expenditure_items_all.acct_rate_type%type;
1155: l_acct_exchange_rate pa_expenditure_items_all.acct_exchange_rate%type;
1156: l_project_currency_code pa_expenditure_items_all.project_currency_code%type;
1157: l_project_rate_date pa_expenditure_items_all.project_rate_date%type;
1158: l_project_rate_type pa_expenditure_items_all.project_rate_type%type;
1159: l_project_exchange_rate pa_expenditure_items_all.project_exchange_rate%type;
1160: l_projfunc_currency_code pa_expenditure_items_all.projfunc_currency_code%type;
1161: l_projfunc_cost_rate_date pa_expenditure_items_all.projfunc_cost_rate_date%type;
1162: l_projfunc_cost_rate_type pa_expenditure_items_all.projfunc_cost_rate_type%type;

Line 1159: l_project_exchange_rate pa_expenditure_items_all.project_exchange_rate%type;

1155: l_acct_exchange_rate pa_expenditure_items_all.acct_exchange_rate%type;
1156: l_project_currency_code pa_expenditure_items_all.project_currency_code%type;
1157: l_project_rate_date pa_expenditure_items_all.project_rate_date%type;
1158: l_project_rate_type pa_expenditure_items_all.project_rate_type%type;
1159: l_project_exchange_rate pa_expenditure_items_all.project_exchange_rate%type;
1160: l_projfunc_currency_code pa_expenditure_items_all.projfunc_currency_code%type;
1161: l_projfunc_cost_rate_date pa_expenditure_items_all.projfunc_cost_rate_date%type;
1162: l_projfunc_cost_rate_type pa_expenditure_items_all.projfunc_cost_rate_type%type;
1163: l_projfunc_cost_exchange_rate pa_expenditure_items_all.projfunc_cost_exchange_rate%type;

Line 1160: l_projfunc_currency_code pa_expenditure_items_all.projfunc_currency_code%type;

1156: l_project_currency_code pa_expenditure_items_all.project_currency_code%type;
1157: l_project_rate_date pa_expenditure_items_all.project_rate_date%type;
1158: l_project_rate_type pa_expenditure_items_all.project_rate_type%type;
1159: l_project_exchange_rate pa_expenditure_items_all.project_exchange_rate%type;
1160: l_projfunc_currency_code pa_expenditure_items_all.projfunc_currency_code%type;
1161: l_projfunc_cost_rate_date pa_expenditure_items_all.projfunc_cost_rate_date%type;
1162: l_projfunc_cost_rate_type pa_expenditure_items_all.projfunc_cost_rate_type%type;
1163: l_projfunc_cost_exchange_rate pa_expenditure_items_all.projfunc_cost_exchange_rate%type;
1164: l_work_type_id pa_expenditure_items_all.work_type_id%type;

Line 1161: l_projfunc_cost_rate_date pa_expenditure_items_all.projfunc_cost_rate_date%type;

1157: l_project_rate_date pa_expenditure_items_all.project_rate_date%type;
1158: l_project_rate_type pa_expenditure_items_all.project_rate_type%type;
1159: l_project_exchange_rate pa_expenditure_items_all.project_exchange_rate%type;
1160: l_projfunc_currency_code pa_expenditure_items_all.projfunc_currency_code%type;
1161: l_projfunc_cost_rate_date pa_expenditure_items_all.projfunc_cost_rate_date%type;
1162: l_projfunc_cost_rate_type pa_expenditure_items_all.projfunc_cost_rate_type%type;
1163: l_projfunc_cost_exchange_rate pa_expenditure_items_all.projfunc_cost_exchange_rate%type;
1164: l_work_type_id pa_expenditure_items_all.work_type_id%type;
1165: l_sob_id pa_implementations.set_of_books_id%type;

Line 1162: l_projfunc_cost_rate_type pa_expenditure_items_all.projfunc_cost_rate_type%type;

1158: l_project_rate_type pa_expenditure_items_all.project_rate_type%type;
1159: l_project_exchange_rate pa_expenditure_items_all.project_exchange_rate%type;
1160: l_projfunc_currency_code pa_expenditure_items_all.projfunc_currency_code%type;
1161: l_projfunc_cost_rate_date pa_expenditure_items_all.projfunc_cost_rate_date%type;
1162: l_projfunc_cost_rate_type pa_expenditure_items_all.projfunc_cost_rate_type%type;
1163: l_projfunc_cost_exchange_rate pa_expenditure_items_all.projfunc_cost_exchange_rate%type;
1164: l_work_type_id pa_expenditure_items_all.work_type_id%type;
1165: l_sob_id pa_implementations.set_of_books_id%type;
1166:

Line 1163: l_projfunc_cost_exchange_rate pa_expenditure_items_all.projfunc_cost_exchange_rate%type;

1159: l_project_exchange_rate pa_expenditure_items_all.project_exchange_rate%type;
1160: l_projfunc_currency_code pa_expenditure_items_all.projfunc_currency_code%type;
1161: l_projfunc_cost_rate_date pa_expenditure_items_all.projfunc_cost_rate_date%type;
1162: l_projfunc_cost_rate_type pa_expenditure_items_all.projfunc_cost_rate_type%type;
1163: l_projfunc_cost_exchange_rate pa_expenditure_items_all.projfunc_cost_exchange_rate%type;
1164: l_work_type_id pa_expenditure_items_all.work_type_id%type;
1165: l_sob_id pa_implementations.set_of_books_id%type;
1166:
1167:

Line 1164: l_work_type_id pa_expenditure_items_all.work_type_id%type;

1160: l_projfunc_currency_code pa_expenditure_items_all.projfunc_currency_code%type;
1161: l_projfunc_cost_rate_date pa_expenditure_items_all.projfunc_cost_rate_date%type;
1162: l_projfunc_cost_rate_type pa_expenditure_items_all.projfunc_cost_rate_type%type;
1163: l_projfunc_cost_exchange_rate pa_expenditure_items_all.projfunc_cost_exchange_rate%type;
1164: l_work_type_id pa_expenditure_items_all.work_type_id%type;
1165: l_sob_id pa_implementations.set_of_books_id%type;
1166:
1167:
1168: -- Cursor to pick up all CDLs with intermediate status 'Y' for creation of

Line 1198: FROM pa_expenditure_items_all ei,

1194: ei.projfunc_cost_rate_date,
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

Line 1265: PA_EXPENDITURE_ITEMS_ALL EI

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:
1269: /* Bug 4374769 : The code in the "PRC: Interface and Usage Transactions to General Ledger" process that updated the CDLs of reversing EI with

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 2432: PROCEDURE get_period_information ( p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE

2428: * o For transactions with transaction source 'Capitalized Interest', GL period is always *
2429: * derived based on application id 101 irrespective of the EPP profile option. *
2430: *==============================================================================================*/
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

Line 2433: ,p_expenditure_id IN pa_expenditure_items_all.expenditure_id%TYPE

2429: * derived based on application id 101 irrespective of the EPP profile option. *
2430: *==============================================================================================*/
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

Line 2434: ,p_system_linkage_function IN pa_expenditure_items_all.system_linkage_function%TYPE

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

Line 2440: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%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
2444: ,p_calling_module IN VARCHAR2

Line 2441: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%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
2444: ,p_calling_module IN VARCHAR2
2445: ,p_ou_context IN VARCHAR2

Line 2986: PROCEDURE get_OU_period_information ( p_reference_date IN pa_expenditure_items_all.expenditure_item_date%TYPE

2982: RAISE ;
2983:
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

Line 3203: ,p_org_id IN pa_expenditure_items_all.org_id%TYPE

3199: -- x_error_code - Return Error Code.
3200: ----------------------------------------------------------------------------------------------------------------
3201: PROCEDURE get_accrual_pa_dt_period( p_gl_period IN VARCHAR2
3202: ,p_ei_date IN DATE
3203: ,p_org_id IN pa_expenditure_items_all.org_id%TYPE
3204: ,p_prvdr_recvr_flg IN VARCHAR2
3205: ,p_epp_flag IN VARCHAR2
3206: ,p_org_rev_flg IN VARCHAR2
3207: ,x_pa_date OUT NOCOPY DATE

Line 4011: PROCEDURE get_accrual_period_information(p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE

4007: | | | | | | | Its the min(end_date). |
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

Line 4014: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE

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
4018: ,p_calling_module IN VARCHAR2

Line 4015: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE

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
4018: ,p_calling_module IN VARCHAR2
4019: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE

Line 4027: ,p_adj_ei_id IN pa_expenditure_items_all.expenditure_item_id%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
4031: ,x_error_stage OUT NOCOPY VARCHAR2

Line 4735: FUNCTION get_pa_period_name( p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE

4731: WHEN OTHERS THEN
4732: RAISE ;
4733: END get_accrual_period_information ;
4734: -----------------------------------------------------------------------
4735: FUNCTION get_pa_period_name( p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
4736: ,p_org_id IN pa_implementations_all.org_id%TYPE
4737: )
4738: RETURN pa_periods.period_name%TYPE
4739: IS

Line 4761: FUNCTION get_ts_allow_burden_flag( p_transaction_source IN pa_expenditure_items_all.transaction_source%TYPE)

4757: END get_pa_period_name ;
4758:
4759: -----------------------------------------------------------------------
4760: --Start Bug 3069632
4761: FUNCTION get_ts_allow_burden_flag( p_transaction_source IN pa_expenditure_items_all.transaction_source%TYPE)
4762: RETURN pa_transaction_sources.allow_burden_flag%TYPE
4763: IS
4764: l_allow_burden_flag pa_transaction_sources.allow_burden_flag%TYPE := 'N';
4765: BEGIN