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

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

246: , p_sys_reference4
247: , p_sys_reference5
248: , l_si_assets_addition_flag
249: FROM
250: -- pa_cost_distribution_lines cdl -- 12i MOAC changes
251: pa_cost_distribution_lines_All cdl
252: WHERE cdl.expenditure_item_id = X_expenditure_item_id
253: AND DECODE(p_mode,'INTERFACE',NULL,cdl.line_num_reversed) IS NULL -- Bug 4374769
254: AND DECODE(p_mode,'INTERFACE',NULL,cdl.reversed_flag) IS NULL -- Bug 4374769

Line 251: pa_cost_distribution_lines_All cdl

247: , p_sys_reference5
248: , l_si_assets_addition_flag
249: FROM
250: -- pa_cost_distribution_lines cdl -- 12i MOAC changes
251: pa_cost_distribution_lines_All cdl
252: WHERE cdl.expenditure_item_id = X_expenditure_item_id
253: AND DECODE(p_mode,'INTERFACE',NULL,cdl.line_num_reversed) IS NULL -- Bug 4374769
254: AND DECODE(p_mode,'INTERFACE',NULL,cdl.reversed_flag) IS NULL -- Bug 4374769
255: AND cdl.line_type = X_line_type

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

254: AND DECODE(p_mode,'INTERFACE',NULL,cdl.reversed_flag) IS NULL -- Bug 4374769
255: AND cdl.line_type = X_line_type
256: AND cdl.line_num = DECODE ( p_mode, 'INTERFACE', X_line_num, cdl.line_num) -- Bug 4374769
257: /* Added this Not exists Clause for the bug 5509019 */
258: AND NOT EXISTS (select 1 from pa_cost_distribution_lines_all cdl1
259: where cdl1.expenditure_item_id = cdl.expenditure_item_id
260: and cdl1.line_num_reversed = cdl.line_num
261: and cdl1.transfer_status_code = 'G'
262: and cdl1.line_type = 'I'

Line 328: UPDATE pa_cost_distribution_lines_all

324: /* 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
325: kept as NULL on the original cdl. */
326:
327: If p_mode <> 'INTERFACE' Then
328: UPDATE pa_cost_distribution_lines_all
329: SET reversed_flag = 'Y'
330: WHERE expenditure_item_id = X_expenditure_item_id
331: AND line_num = max_cdl_line_num ;
332: end if;

Line 774: FROM pa_cost_distribution_lines cdl

770: X_err_stage := '-> Get new CDL line num';
771:
772: SELECT max(cdl.line_num)
773: INTO new_cdl_line_num
774: FROM pa_cost_distribution_lines cdl
775: WHERE cdl.expenditure_item_id = X_expenditure_item_id ;
776:
777: /* Create the new reversing CDL */
778:

Line 784: -- Insert into pa_cost_distribution_lines

780: X_err_stage := '-> Insert row in CDL table';
781: pa_cc_utils.log_message('Gl Accounted Flag['||PA_TRANSACTIONS.GL_ACCOUNTED_FLAG||
782: ']l_gl_date['||l_gl_date||']x_gl_date['||x_gl_date||']');
783:
784: -- Insert into pa_cost_distribution_lines
785: Insert into pa_cost_distribution_lines_All
786: ( line_num
787: , parent_line_num
788: , expenditure_item_id

Line 785: Insert into pa_cost_distribution_lines_All

781: pa_cc_utils.log_message('Gl Accounted Flag['||PA_TRANSACTIONS.GL_ACCOUNTED_FLAG||
782: ']l_gl_date['||l_gl_date||']x_gl_date['||x_gl_date||']');
783:
784: -- Insert into pa_cost_distribution_lines
785: Insert into pa_cost_distribution_lines_All
786: ( line_num
787: , parent_line_num
788: , expenditure_item_id
789: , amount

Line 1006: -- Insert into PA_Cost_Distribution_lines

1002: if (x_recvr_pa_date IS NULL) then
1003: x_err_code := -20010 ;
1004: raise_application_error( -20010, 'INVALID_RECVR_PA_DATE') ;
1005: end if;
1006: -- Insert into PA_Cost_Distribution_lines
1007:
1008: x_err_stage := 'Insert into PA_Cost_Disctribution_Lines';
1009: Pa_Costing.CreateNewCdl (
1010: X_expenditure_item_id => x_expenditure_item_id

Line 1107: p_amount pa_cost_distribution_lines.amount%TYPE;

1103: X_backout_id IN NUMBER,
1104: X_user IN NUMBER,
1105: X_status OUT NOCOPY NUMBER)
1106: IS
1107: p_amount pa_cost_distribution_lines.amount%TYPE;
1108: p_dr_ccid pa_cost_distribution_lines.dr_code_combination_id%TYPE;
1109: p_cr_ccid pa_cost_distribution_lines.cr_code_combination_id%TYPE;
1110: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;
1111: p_quantity pa_cost_distribution_lines.quantity%TYPE;

Line 1108: p_dr_ccid pa_cost_distribution_lines.dr_code_combination_id%TYPE;

1104: X_user IN NUMBER,
1105: X_status OUT NOCOPY NUMBER)
1106: IS
1107: p_amount pa_cost_distribution_lines.amount%TYPE;
1108: p_dr_ccid pa_cost_distribution_lines.dr_code_combination_id%TYPE;
1109: p_cr_ccid pa_cost_distribution_lines.cr_code_combination_id%TYPE;
1110: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;
1111: p_quantity pa_cost_distribution_lines.quantity%TYPE;
1112: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;

Line 1109: p_cr_ccid pa_cost_distribution_lines.cr_code_combination_id%TYPE;

1105: X_status OUT NOCOPY NUMBER)
1106: IS
1107: p_amount pa_cost_distribution_lines.amount%TYPE;
1108: p_dr_ccid pa_cost_distribution_lines.dr_code_combination_id%TYPE;
1109: p_cr_ccid pa_cost_distribution_lines.cr_code_combination_id%TYPE;
1110: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;
1111: p_quantity pa_cost_distribution_lines.quantity%TYPE;
1112: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;
1113: p_request_id pa_cost_distribution_lines.request_id%TYPE;

Line 1110: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;

1106: IS
1107: p_amount pa_cost_distribution_lines.amount%TYPE;
1108: p_dr_ccid pa_cost_distribution_lines.dr_code_combination_id%TYPE;
1109: p_cr_ccid pa_cost_distribution_lines.cr_code_combination_id%TYPE;
1110: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;
1111: p_quantity pa_cost_distribution_lines.quantity%TYPE;
1112: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;
1113: p_request_id pa_cost_distribution_lines.request_id%TYPE;
1114: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;

Line 1111: p_quantity pa_cost_distribution_lines.quantity%TYPE;

1107: p_amount pa_cost_distribution_lines.amount%TYPE;
1108: p_dr_ccid pa_cost_distribution_lines.dr_code_combination_id%TYPE;
1109: p_cr_ccid pa_cost_distribution_lines.cr_code_combination_id%TYPE;
1110: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;
1111: p_quantity pa_cost_distribution_lines.quantity%TYPE;
1112: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;
1113: p_request_id pa_cost_distribution_lines.request_id%TYPE;
1114: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;
1115: p_program_id pa_cost_distribution_lines.program_id%TYPE;

Line 1112: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;

1108: p_dr_ccid pa_cost_distribution_lines.dr_code_combination_id%TYPE;
1109: p_cr_ccid pa_cost_distribution_lines.cr_code_combination_id%TYPE;
1110: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;
1111: p_quantity pa_cost_distribution_lines.quantity%TYPE;
1112: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;
1113: p_request_id pa_cost_distribution_lines.request_id%TYPE;
1114: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;
1115: p_program_id pa_cost_distribution_lines.program_id%TYPE;
1116: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;

Line 1113: p_request_id pa_cost_distribution_lines.request_id%TYPE;

1109: p_cr_ccid pa_cost_distribution_lines.cr_code_combination_id%TYPE;
1110: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;
1111: p_quantity pa_cost_distribution_lines.quantity%TYPE;
1112: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;
1113: p_request_id pa_cost_distribution_lines.request_id%TYPE;
1114: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;
1115: p_program_id pa_cost_distribution_lines.program_id%TYPE;
1116: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;
1117: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;

Line 1114: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;

1110: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;
1111: p_quantity pa_cost_distribution_lines.quantity%TYPE;
1112: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;
1113: p_request_id pa_cost_distribution_lines.request_id%TYPE;
1114: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;
1115: p_program_id pa_cost_distribution_lines.program_id%TYPE;
1116: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;
1117: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;
1118: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/

Line 1115: p_program_id pa_cost_distribution_lines.program_id%TYPE;

1111: p_quantity pa_cost_distribution_lines.quantity%TYPE;
1112: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;
1113: p_request_id pa_cost_distribution_lines.request_id%TYPE;
1114: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;
1115: p_program_id pa_cost_distribution_lines.program_id%TYPE;
1116: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;
1117: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;
1118: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/
1119: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;

Line 1116: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;

1112: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;
1113: p_request_id pa_cost_distribution_lines.request_id%TYPE;
1114: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;
1115: p_program_id pa_cost_distribution_lines.program_id%TYPE;
1116: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;
1117: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;
1118: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/
1119: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;
1120: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;

Line 1117: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;

1113: p_request_id pa_cost_distribution_lines.request_id%TYPE;
1114: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;
1115: p_program_id pa_cost_distribution_lines.program_id%TYPE;
1116: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;
1117: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;
1118: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/
1119: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;
1120: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;
1121: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;

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

1114: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;
1115: p_program_id pa_cost_distribution_lines.program_id%TYPE;
1116: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;
1117: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;
1118: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/
1119: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;
1120: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;
1121: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;
1122: p_line_type pa_cost_distribution_lines.line_type%TYPE;

Line 1119: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;

1115: p_program_id pa_cost_distribution_lines.program_id%TYPE;
1116: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;
1117: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;
1118: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/
1119: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;
1120: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;
1121: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;
1122: p_line_type pa_cost_distribution_lines.line_type%TYPE;
1123: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;

Line 1120: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;

1116: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;
1117: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;
1118: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/
1119: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;
1120: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;
1121: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;
1122: p_line_type pa_cost_distribution_lines.line_type%TYPE;
1123: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;
1124: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;

Line 1121: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;

1117: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;
1118: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/
1119: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;
1120: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;
1121: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;
1122: p_line_type pa_cost_distribution_lines.line_type%TYPE;
1123: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;
1124: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;
1125: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;

Line 1122: p_line_type pa_cost_distribution_lines.line_type%TYPE;

1118: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/
1119: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;
1120: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;
1121: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;
1122: p_line_type pa_cost_distribution_lines.line_type%TYPE;
1123: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;
1124: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;
1125: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;
1126: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;

Line 1123: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;

1119: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;
1120: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;
1121: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;
1122: p_line_type pa_cost_distribution_lines.line_type%TYPE;
1123: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;
1124: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;
1125: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;
1126: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;
1127: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;

Line 1124: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;

1120: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;
1121: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;
1122: p_line_type pa_cost_distribution_lines.line_type%TYPE;
1123: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;
1124: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;
1125: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;
1126: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;
1127: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;
1128: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;

Line 1125: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;

1121: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;
1122: p_line_type pa_cost_distribution_lines.line_type%TYPE;
1123: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;
1124: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;
1125: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;
1126: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;
1127: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;
1128: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;
1129: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;

Line 1126: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;

1122: p_line_type pa_cost_distribution_lines.line_type%TYPE;
1123: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;
1124: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;
1125: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;
1126: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;
1127: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;
1128: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;
1129: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;
1130: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;

Line 1127: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;

1123: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;
1124: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;
1125: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;
1126: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;
1127: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;
1128: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;
1129: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;
1130: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;
1131: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;

Line 1128: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;

1124: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;
1125: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;
1126: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;
1127: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;
1128: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;
1129: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;
1130: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;
1131: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;
1132: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;

Line 1129: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;

1125: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;
1126: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;
1127: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;
1128: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;
1129: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;
1130: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;
1131: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;
1132: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;
1133: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;

Line 1130: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;

1126: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;
1127: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;
1128: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;
1129: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;
1130: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;
1131: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;
1132: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;
1133: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;
1134: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;

Line 1131: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;

1127: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;
1128: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;
1129: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;
1130: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;
1131: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;
1132: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;
1133: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;
1134: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;
1135: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;

Line 1132: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;

1128: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;
1129: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;
1130: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;
1131: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;
1132: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;
1133: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;
1134: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;
1135: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;
1136: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;

Line 1133: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;

1129: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;
1130: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;
1131: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;
1132: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;
1133: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;
1134: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;
1135: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;
1136: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;
1137: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;

Line 1134: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;

1130: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;
1131: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;
1132: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;
1133: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;
1134: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;
1135: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;
1136: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;
1137: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;
1138: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;

Line 1135: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;

1131: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;
1132: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;
1133: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;
1134: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;
1135: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;
1136: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;
1137: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;
1138: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;
1139: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;

Line 1136: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;

1132: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;
1133: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;
1134: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;
1135: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;
1136: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;
1137: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;
1138: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;
1139: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;
1140: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;

Line 1137: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;

1133: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;
1134: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;
1135: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;
1136: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;
1137: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;
1138: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;
1139: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;
1140: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;
1141: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;

Line 1138: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;

1134: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;
1135: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;
1136: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;
1137: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;
1138: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;
1139: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;
1140: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;
1141: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;
1142: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;

Line 1139: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;

1135: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;
1136: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;
1137: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;
1138: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;
1139: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;
1140: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;
1141: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;
1142: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;
1143: p_project_id pa_cost_distribution_lines.project_id%TYPE;

Line 1140: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;

1136: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;
1137: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;
1138: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;
1139: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;
1140: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;
1141: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;
1142: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;
1143: p_project_id pa_cost_distribution_lines.project_id%TYPE;
1144: p_task_id pa_cost_distribution_lines.task_id%TYPE;

Line 1141: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;

1137: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;
1138: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;
1139: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;
1140: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;
1141: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;
1142: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;
1143: p_project_id pa_cost_distribution_lines.project_id%TYPE;
1144: p_task_id pa_cost_distribution_lines.task_id%TYPE;
1145: p_parent_adjusted_id pa_expenditure_items.adjusted_expenditure_item_id%TYPE;

Line 1142: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;

1138: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;
1139: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;
1140: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;
1141: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;
1142: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;
1143: p_project_id pa_cost_distribution_lines.project_id%TYPE;
1144: p_task_id pa_cost_distribution_lines.task_id%TYPE;
1145: p_parent_adjusted_id pa_expenditure_items.adjusted_expenditure_item_id%TYPE;
1146: p_parent_transferred_id pa_expenditure_items.transferred_from_exp_item_id%TYPE;

Line 1143: p_project_id pa_cost_distribution_lines.project_id%TYPE;

1139: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;
1140: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;
1141: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;
1142: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;
1143: p_project_id pa_cost_distribution_lines.project_id%TYPE;
1144: p_task_id pa_cost_distribution_lines.task_id%TYPE;
1145: p_parent_adjusted_id pa_expenditure_items.adjusted_expenditure_item_id%TYPE;
1146: p_parent_transferred_id pa_expenditure_items.transferred_from_exp_item_id%TYPE;
1147: p_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%TYPE;

Line 1144: p_task_id pa_cost_distribution_lines.task_id%TYPE;

1140: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;
1141: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;
1142: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;
1143: p_project_id pa_cost_distribution_lines.project_id%TYPE;
1144: p_task_id pa_cost_distribution_lines.task_id%TYPE;
1145: p_parent_adjusted_id pa_expenditure_items.adjusted_expenditure_item_id%TYPE;
1146: p_parent_transferred_id pa_expenditure_items.transferred_from_exp_item_id%TYPE;
1147: p_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%TYPE;
1148: p_transaction_source pa_transaction_sources.transaction_source%TYPE;

Line 1150: l_si_assets_addition_flag pa_cost_distribution_lines.si_assets_addition_flag%TYPE ;

1146: p_parent_transferred_id pa_expenditure_items.transferred_from_exp_item_id%TYPE;
1147: p_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%TYPE;
1148: p_transaction_source pa_transaction_sources.transaction_source%TYPE;
1149:
1150: l_si_assets_addition_flag pa_cost_distribution_lines.si_assets_addition_flag%TYPE ;
1151: p_err_code NUMBER;
1152: p_err_stage VARCHAR2(1000);
1153: p_err_stack VARCHAR2(1000);
1154: e_cdl_error EXCEPTION;

Line 1175: p_cdlsr4 pa_cost_distribution_lines.system_reference4%TYPE;

1171: p_project_burdened_cost NUMBER;
1172: -- End Project Currency/ EI Attribute Changes
1173:
1174: -- AP Discounts
1175: p_cdlsr4 pa_cost_distribution_lines.system_reference4%TYPE;
1176: p_cdlsr5 pa_cost_distribution_lines.system_reference5%TYPE;
1177: /* bug#2361495 */
1178: l_pa_date DATE ;
1179: l_recvr_pa_date DATE ;

Line 1176: p_cdlsr5 pa_cost_distribution_lines.system_reference5%TYPE;

1172: -- End Project Currency/ EI Attribute Changes
1173:
1174: -- AP Discounts
1175: p_cdlsr4 pa_cost_distribution_lines.system_reference4%TYPE;
1176: p_cdlsr5 pa_cost_distribution_lines.system_reference5%TYPE;
1177: /* bug#2361495 */
1178: l_pa_date DATE ;
1179: l_recvr_pa_date DATE ;
1180: l_ei_date DATE ;

Line 1184: actual_cdl_line_num pa_cost_distribution_lines.line_num%TYPE;

1180: l_ei_date DATE ;
1181: l_org_id pa_expenditure_items.org_id%type;
1182: /* bug#2361495 */
1183: /* bug2378505 */
1184: actual_cdl_line_num pa_cost_distribution_lines.line_num%TYPE;
1185: /* bug2378505 */
1186: /* bug 2661921*/
1187: l_recvr_org_id pa_expenditure_items.org_id%type;
1188: l_gl_date DATE;

Line 1264: FROM pa_cost_distribution_lines cdl

1260: this case is the billable_flag */
1261:
1262: SELECT max(cdl.line_num)
1263: INTO actual_cdl_line_num
1264: FROM pa_cost_distribution_lines cdl
1265: WHERE cdl.expenditure_item_id = X_exp_item_id and cdl.line_type = 'R';
1266:
1267: /* Addition for bug 2378505 ends */
1268:

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

1372: , p_Work_type_id
1373: , p_cdlsr4
1374: , p_cdlsr5
1375: , l_si_assets_addition_flag
1376: -- FROM pa_cost_distribution_lines -- 12i MOAC changes
1377: FROM pa_cost_distribution_lines_All -- 12i MOAC changes
1378: WHERE expenditure_item_id = X_exp_item_id
1379: -- AND line_num = 1; -- commented for bug2378505
1380: AND line_num = actual_cdl_line_num; -- bug2378505

Line 1377: FROM pa_cost_distribution_lines_All -- 12i MOAC changes

1373: , p_cdlsr4
1374: , p_cdlsr5
1375: , l_si_assets_addition_flag
1376: -- FROM pa_cost_distribution_lines -- 12i MOAC changes
1377: FROM pa_cost_distribution_lines_All -- 12i MOAC changes
1378: WHERE expenditure_item_id = X_exp_item_id
1379: -- AND line_num = 1; -- commented for bug2378505
1380: AND line_num = actual_cdl_line_num; -- bug2378505
1381: