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_COSTING dependencies on PA_COST_DISTRIBUTION_LINES

Line 257: -- pa_cost_distribution_lines cdl -- 12i MOAC changes

253: , l_si_assets_addition_flag
254: --, l_agreement_id --FSIO Changes
255: , l_cbs_element_id -- Added for CBS Enhancement Bug 16220146
256: FROM
257: -- pa_cost_distribution_lines cdl -- 12i MOAC changes
258: pa_cost_distribution_lines_All cdl
259: WHERE cdl.expenditure_item_id = X_expenditure_item_id
260: AND DECODE(p_mode,'INTERFACE',NULL,cdl.line_num_reversed) IS NULL -- Bug 4374769
261: AND DECODE(p_mode,'INTERFACE',NULL,cdl.reversed_flag) IS NULL -- Bug 4374769

Line 258: pa_cost_distribution_lines_All cdl

254: --, l_agreement_id --FSIO Changes
255: , l_cbs_element_id -- Added for CBS Enhancement Bug 16220146
256: FROM
257: -- pa_cost_distribution_lines cdl -- 12i MOAC changes
258: pa_cost_distribution_lines_All cdl
259: WHERE cdl.expenditure_item_id = X_expenditure_item_id
260: AND DECODE(p_mode,'INTERFACE',NULL,cdl.line_num_reversed) IS NULL -- Bug 4374769
261: AND DECODE(p_mode,'INTERFACE',NULL,cdl.reversed_flag) IS NULL -- Bug 4374769
262: AND cdl.line_type = X_line_type

Line 265: AND NOT EXISTS (select 1 from pa_cost_distribution_lines_all cdl1

261: AND DECODE(p_mode,'INTERFACE',NULL,cdl.reversed_flag) IS NULL -- Bug 4374769
262: AND cdl.line_type = X_line_type
263: AND cdl.line_num = DECODE ( p_mode, 'INTERFACE', X_line_num, cdl.line_num) -- Bug 4374769
264: /* Added this Not exists Clause for the bug 5509019 */
265: AND NOT EXISTS (select 1 from pa_cost_distribution_lines_all cdl1
266: where cdl1.expenditure_item_id = cdl.expenditure_item_id
267: and cdl1.line_num_reversed = cdl.line_num
268: and cdl1.transfer_status_code = 'G'
269: and cdl1.line_type = 'I'

Line 341: UPDATE pa_cost_distribution_lines_all

337: /* Bug 4374769 : If p_mode is 'INTERFACE' i.e if the reversing and new cdls are created because of PJI summarization then the reversed_flag is
338: kept as NULL on the original cdl. */
339:
340: If p_mode <> 'INTERFACE' Then
341: UPDATE pa_cost_distribution_lines_all
342: SET reversed_flag = 'Y'
343: WHERE expenditure_item_id = X_expenditure_item_id
344: AND line_num = max_cdl_line_num ;
345: end if;

Line 804: FROM pa_cost_distribution_lines cdl

800: X_err_stage := '-> Get new CDL line num';
801:
802: SELECT max(cdl.line_num)
803: INTO new_cdl_line_num
804: FROM pa_cost_distribution_lines cdl
805: WHERE cdl.expenditure_item_id = X_expenditure_item_id ;
806:
807: /* Create the new reversing CDL */
808:

Line 814: -- Insert into pa_cost_distribution_lines

810: X_err_stage := '-> Insert row in CDL table';
811: pa_cc_utils.log_message('Gl Accounted Flag['||PA_TRANSACTIONS.GL_ACCOUNTED_FLAG||
812: ']l_gl_date['||l_gl_date||']x_gl_date['||x_gl_date||']');
813:
814: -- Insert into pa_cost_distribution_lines
815: Insert into pa_cost_distribution_lines_All
816: ( line_num
817: , parent_line_num
818: , expenditure_item_id

Line 815: Insert into pa_cost_distribution_lines_All

811: pa_cc_utils.log_message('Gl Accounted Flag['||PA_TRANSACTIONS.GL_ACCOUNTED_FLAG||
812: ']l_gl_date['||l_gl_date||']x_gl_date['||x_gl_date||']');
813:
814: -- Insert into pa_cost_distribution_lines
815: Insert into pa_cost_distribution_lines_All
816: ( line_num
817: , parent_line_num
818: , expenditure_item_id
819: , amount

Line 1050: -- Insert into PA_Cost_Distribution_lines

1046: if (x_recvr_pa_date IS NULL) then
1047: x_err_code := -20010 ;
1048: raise_application_error( -20010, 'INVALID_RECVR_PA_DATE') ;
1049: end if;
1050: -- Insert into PA_Cost_Distribution_lines
1051:
1052: x_err_stage := 'Insert into PA_Cost_Disctribution_Lines';
1053: Pa_Costing.CreateNewCdl (
1054: X_expenditure_item_id => x_expenditure_item_id

Line 1154: p_amount pa_cost_distribution_lines.amount%TYPE;

1150: X_backout_id IN NUMBER,
1151: X_user IN NUMBER,
1152: X_status OUT NOCOPY NUMBER)
1153: IS
1154: p_amount pa_cost_distribution_lines.amount%TYPE;
1155: p_dr_ccid pa_cost_distribution_lines.dr_code_combination_id%TYPE;
1156: p_cr_ccid pa_cost_distribution_lines.cr_code_combination_id%TYPE;
1157: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;
1158: p_quantity pa_cost_distribution_lines.quantity%TYPE;

Line 1155: p_dr_ccid pa_cost_distribution_lines.dr_code_combination_id%TYPE;

1151: X_user IN NUMBER,
1152: X_status OUT NOCOPY NUMBER)
1153: IS
1154: p_amount pa_cost_distribution_lines.amount%TYPE;
1155: p_dr_ccid pa_cost_distribution_lines.dr_code_combination_id%TYPE;
1156: p_cr_ccid pa_cost_distribution_lines.cr_code_combination_id%TYPE;
1157: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;
1158: p_quantity pa_cost_distribution_lines.quantity%TYPE;
1159: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;

Line 1156: p_cr_ccid pa_cost_distribution_lines.cr_code_combination_id%TYPE;

1152: X_status OUT NOCOPY NUMBER)
1153: IS
1154: p_amount pa_cost_distribution_lines.amount%TYPE;
1155: p_dr_ccid pa_cost_distribution_lines.dr_code_combination_id%TYPE;
1156: p_cr_ccid pa_cost_distribution_lines.cr_code_combination_id%TYPE;
1157: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;
1158: p_quantity pa_cost_distribution_lines.quantity%TYPE;
1159: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;
1160: p_request_id pa_cost_distribution_lines.request_id%TYPE;

Line 1157: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;

1153: IS
1154: p_amount pa_cost_distribution_lines.amount%TYPE;
1155: p_dr_ccid pa_cost_distribution_lines.dr_code_combination_id%TYPE;
1156: p_cr_ccid pa_cost_distribution_lines.cr_code_combination_id%TYPE;
1157: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;
1158: p_quantity pa_cost_distribution_lines.quantity%TYPE;
1159: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;
1160: p_request_id pa_cost_distribution_lines.request_id%TYPE;
1161: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;

Line 1158: p_quantity pa_cost_distribution_lines.quantity%TYPE;

1154: p_amount pa_cost_distribution_lines.amount%TYPE;
1155: p_dr_ccid pa_cost_distribution_lines.dr_code_combination_id%TYPE;
1156: p_cr_ccid pa_cost_distribution_lines.cr_code_combination_id%TYPE;
1157: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;
1158: p_quantity pa_cost_distribution_lines.quantity%TYPE;
1159: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;
1160: p_request_id pa_cost_distribution_lines.request_id%TYPE;
1161: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;
1162: p_program_id pa_cost_distribution_lines.program_id%TYPE;

Line 1159: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;

1155: p_dr_ccid pa_cost_distribution_lines.dr_code_combination_id%TYPE;
1156: p_cr_ccid pa_cost_distribution_lines.cr_code_combination_id%TYPE;
1157: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;
1158: p_quantity pa_cost_distribution_lines.quantity%TYPE;
1159: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;
1160: p_request_id pa_cost_distribution_lines.request_id%TYPE;
1161: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;
1162: p_program_id pa_cost_distribution_lines.program_id%TYPE;
1163: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;

Line 1160: p_request_id pa_cost_distribution_lines.request_id%TYPE;

1156: p_cr_ccid pa_cost_distribution_lines.cr_code_combination_id%TYPE;
1157: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;
1158: p_quantity pa_cost_distribution_lines.quantity%TYPE;
1159: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;
1160: p_request_id pa_cost_distribution_lines.request_id%TYPE;
1161: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;
1162: p_program_id pa_cost_distribution_lines.program_id%TYPE;
1163: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;
1164: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;

Line 1161: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;

1157: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;
1158: p_quantity pa_cost_distribution_lines.quantity%TYPE;
1159: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;
1160: p_request_id pa_cost_distribution_lines.request_id%TYPE;
1161: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;
1162: p_program_id pa_cost_distribution_lines.program_id%TYPE;
1163: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;
1164: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;
1165: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/

Line 1162: p_program_id pa_cost_distribution_lines.program_id%TYPE;

1158: p_quantity pa_cost_distribution_lines.quantity%TYPE;
1159: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;
1160: p_request_id pa_cost_distribution_lines.request_id%TYPE;
1161: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;
1162: p_program_id pa_cost_distribution_lines.program_id%TYPE;
1163: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;
1164: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;
1165: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/
1166: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;

Line 1163: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;

1159: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;
1160: p_request_id pa_cost_distribution_lines.request_id%TYPE;
1161: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;
1162: p_program_id pa_cost_distribution_lines.program_id%TYPE;
1163: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;
1164: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;
1165: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/
1166: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;
1167: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;

Line 1164: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;

1160: p_request_id pa_cost_distribution_lines.request_id%TYPE;
1161: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;
1162: p_program_id pa_cost_distribution_lines.program_id%TYPE;
1163: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;
1164: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;
1165: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/
1166: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;
1167: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;
1168: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;

Line 1165: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /CBGA/

1161: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;
1162: p_program_id pa_cost_distribution_lines.program_id%TYPE;
1163: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;
1164: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;
1165: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/
1166: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;
1167: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;
1168: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;
1169: p_line_type pa_cost_distribution_lines.line_type%TYPE;

Line 1166: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;

1162: p_program_id pa_cost_distribution_lines.program_id%TYPE;
1163: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;
1164: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;
1165: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/
1166: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;
1167: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;
1168: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;
1169: p_line_type pa_cost_distribution_lines.line_type%TYPE;
1170: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;

Line 1167: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;

1163: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;
1164: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;
1165: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/
1166: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;
1167: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;
1168: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;
1169: p_line_type pa_cost_distribution_lines.line_type%TYPE;
1170: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;
1171: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;

Line 1168: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;

1164: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;
1165: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/
1166: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;
1167: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;
1168: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;
1169: p_line_type pa_cost_distribution_lines.line_type%TYPE;
1170: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;
1171: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;
1172: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;

Line 1169: p_line_type pa_cost_distribution_lines.line_type%TYPE;

1165: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/
1166: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;
1167: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;
1168: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;
1169: p_line_type pa_cost_distribution_lines.line_type%TYPE;
1170: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;
1171: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;
1172: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;
1173: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;

Line 1170: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;

1166: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;
1167: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;
1168: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;
1169: p_line_type pa_cost_distribution_lines.line_type%TYPE;
1170: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;
1171: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;
1172: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;
1173: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;
1174: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;

Line 1171: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;

1167: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;
1168: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;
1169: p_line_type pa_cost_distribution_lines.line_type%TYPE;
1170: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;
1171: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;
1172: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;
1173: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;
1174: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;
1175: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;

Line 1172: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;

1168: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;
1169: p_line_type pa_cost_distribution_lines.line_type%TYPE;
1170: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;
1171: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;
1172: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;
1173: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;
1174: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;
1175: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;
1176: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;

Line 1173: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;

1169: p_line_type pa_cost_distribution_lines.line_type%TYPE;
1170: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;
1171: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;
1172: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;
1173: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;
1174: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;
1175: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;
1176: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;
1177: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;

Line 1174: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;

1170: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;
1171: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;
1172: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;
1173: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;
1174: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;
1175: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;
1176: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;
1177: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;
1178: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;

Line 1175: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;

1171: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;
1172: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;
1173: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;
1174: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;
1175: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;
1176: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;
1177: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;
1178: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;
1179: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;

Line 1176: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;

1172: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;
1173: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;
1174: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;
1175: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;
1176: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;
1177: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;
1178: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;
1179: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;
1180: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;

Line 1177: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;

1173: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;
1174: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;
1175: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;
1176: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;
1177: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;
1178: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;
1179: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;
1180: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;
1181: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;

Line 1178: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;

1174: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;
1175: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;
1176: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;
1177: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;
1178: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;
1179: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;
1180: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;
1181: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;
1182: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;

Line 1179: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;

1175: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;
1176: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;
1177: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;
1178: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;
1179: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;
1180: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;
1181: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;
1182: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;
1183: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;

Line 1180: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;

1176: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;
1177: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;
1178: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;
1179: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;
1180: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;
1181: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;
1182: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;
1183: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;
1184: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;

Line 1181: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;

1177: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;
1178: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;
1179: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;
1180: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;
1181: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;
1182: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;
1183: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;
1184: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;
1185: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;

Line 1182: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;

1178: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;
1179: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;
1180: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;
1181: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;
1182: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;
1183: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;
1184: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;
1185: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;
1186: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;

Line 1183: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;

1179: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;
1180: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;
1181: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;
1182: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;
1183: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;
1184: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;
1185: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;
1186: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;
1187: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;

Line 1184: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;

1180: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;
1181: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;
1182: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;
1183: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;
1184: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;
1185: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;
1186: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;
1187: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;
1188: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;

Line 1185: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;

1181: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;
1182: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;
1183: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;
1184: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;
1185: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;
1186: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;
1187: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;
1188: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;
1189: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;

Line 1186: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;

1182: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;
1183: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;
1184: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;
1185: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;
1186: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;
1187: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;
1188: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;
1189: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;
1190: p_project_id pa_cost_distribution_lines.project_id%TYPE;

Line 1187: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;

1183: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;
1184: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;
1185: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;
1186: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;
1187: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;
1188: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;
1189: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;
1190: p_project_id pa_cost_distribution_lines.project_id%TYPE;
1191: p_task_id pa_cost_distribution_lines.task_id%TYPE;

Line 1188: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;

1184: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;
1185: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;
1186: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;
1187: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;
1188: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;
1189: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;
1190: p_project_id pa_cost_distribution_lines.project_id%TYPE;
1191: p_task_id pa_cost_distribution_lines.task_id%TYPE;
1192: p_parent_adjusted_id pa_expenditure_items.adjusted_expenditure_item_id%TYPE;

Line 1189: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;

1185: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;
1186: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;
1187: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;
1188: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;
1189: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;
1190: p_project_id pa_cost_distribution_lines.project_id%TYPE;
1191: p_task_id pa_cost_distribution_lines.task_id%TYPE;
1192: p_parent_adjusted_id pa_expenditure_items.adjusted_expenditure_item_id%TYPE;
1193: p_parent_transferred_id pa_expenditure_items.transferred_from_exp_item_id%TYPE;

Line 1190: p_project_id pa_cost_distribution_lines.project_id%TYPE;

1186: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;
1187: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;
1188: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;
1189: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;
1190: p_project_id pa_cost_distribution_lines.project_id%TYPE;
1191: p_task_id pa_cost_distribution_lines.task_id%TYPE;
1192: p_parent_adjusted_id pa_expenditure_items.adjusted_expenditure_item_id%TYPE;
1193: p_parent_transferred_id pa_expenditure_items.transferred_from_exp_item_id%TYPE;
1194: p_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%TYPE;

Line 1191: p_task_id pa_cost_distribution_lines.task_id%TYPE;

1187: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;
1188: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;
1189: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;
1190: p_project_id pa_cost_distribution_lines.project_id%TYPE;
1191: p_task_id pa_cost_distribution_lines.task_id%TYPE;
1192: p_parent_adjusted_id pa_expenditure_items.adjusted_expenditure_item_id%TYPE;
1193: p_parent_transferred_id pa_expenditure_items.transferred_from_exp_item_id%TYPE;
1194: p_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%TYPE;
1195: p_transaction_source pa_transaction_sources.transaction_source%TYPE;

Line 1197: l_si_assets_addition_flag pa_cost_distribution_lines.si_assets_addition_flag%TYPE ;

1193: p_parent_transferred_id pa_expenditure_items.transferred_from_exp_item_id%TYPE;
1194: p_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%TYPE;
1195: p_transaction_source pa_transaction_sources.transaction_source%TYPE;
1196:
1197: l_si_assets_addition_flag pa_cost_distribution_lines.si_assets_addition_flag%TYPE ;
1198: p_err_code NUMBER;
1199: p_err_stage VARCHAR2(1000);
1200: p_err_stack VARCHAR2(1000);
1201: e_cdl_error EXCEPTION;

Line 1222: p_cdlsr4 pa_cost_distribution_lines.system_reference4%TYPE;

1218: p_project_burdened_cost NUMBER;
1219: -- End Project Currency/ EI Attribute Changes
1220:
1221: -- AP Discounts
1222: p_cdlsr4 pa_cost_distribution_lines.system_reference4%TYPE;
1223: p_cdlsr5 pa_cost_distribution_lines.system_reference5%TYPE;
1224: /* bug#2361495 */
1225: l_pa_date DATE ;
1226: l_recvr_pa_date DATE ;

Line 1223: p_cdlsr5 pa_cost_distribution_lines.system_reference5%TYPE;

1219: -- End Project Currency/ EI Attribute Changes
1220:
1221: -- AP Discounts
1222: p_cdlsr4 pa_cost_distribution_lines.system_reference4%TYPE;
1223: p_cdlsr5 pa_cost_distribution_lines.system_reference5%TYPE;
1224: /* bug#2361495 */
1225: l_pa_date DATE ;
1226: l_recvr_pa_date DATE ;
1227: l_ei_date DATE ;

Line 1231: actual_cdl_line_num pa_cost_distribution_lines.line_num%TYPE;

1227: l_ei_date DATE ;
1228: l_org_id pa_expenditure_items.org_id%type;
1229: /* bug#2361495 */
1230: /* bug2378505 */
1231: actual_cdl_line_num pa_cost_distribution_lines.line_num%TYPE;
1232: /* bug2378505 */
1233: /* bug 2661921*/
1234: l_recvr_org_id pa_expenditure_items.org_id%type;
1235: l_gl_date DATE;

Line 1316: FROM pa_cost_distribution_lines cdl

1312: this case is the billable_flag */
1313:
1314: SELECT max(cdl.line_num)
1315: INTO actual_cdl_line_num
1316: FROM pa_cost_distribution_lines cdl
1317: WHERE cdl.expenditure_item_id = X_exp_item_id and cdl.line_type = 'R';
1318:
1319: /* Addition for bug 2378505 ends */
1320:

Line 1438: -- FROM pa_cost_distribution_lines -- 12i MOAC changes

1434: , l_rate_source_code
1435: , l_costing_method
1436: /* 12.2 payroll intg .. end */
1437: , l_cbs_element_id -- Added for CBS Enhancement Bug 16220146
1438: -- FROM pa_cost_distribution_lines -- 12i MOAC changes
1439: FROM pa_cost_distribution_lines_All -- 12i MOAC changes
1440: WHERE expenditure_item_id = X_exp_item_id
1441: -- AND line_num = 1; -- commented for bug2378505
1442: AND line_num = actual_cdl_line_num; -- bug2378505

Line 1439: FROM pa_cost_distribution_lines_All -- 12i MOAC changes

1435: , l_costing_method
1436: /* 12.2 payroll intg .. end */
1437: , l_cbs_element_id -- Added for CBS Enhancement Bug 16220146
1438: -- FROM pa_cost_distribution_lines -- 12i MOAC changes
1439: FROM pa_cost_distribution_lines_All -- 12i MOAC changes
1440: WHERE expenditure_item_id = X_exp_item_id
1441: -- AND line_num = 1; -- commented for bug2378505
1442: AND line_num = actual_cdl_line_num; -- bug2378505
1443: