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

Line 4989: PA_COST_DISTRIBUTION_LINES CDL

4985: CDL.DENOM_BURDENED_COST ,
4986: CDL.PROJECT_RAW_COST ,
4987: CDL.PROJECT_BURDENED_COST
4988: FROM
4989: PA_COST_DISTRIBUTION_LINES CDL
4990: WHERE
4991: CDL.EXPENDITURE_ITEM_ID =EI.EXPENDITURE_ITEM_ID AND
4992: CDL.LINE_TYPE ='R' AND
4993: NVL(CDL.REVERSED_FLAG,'N')='N' AND

Line 5006: PA_COST_DISTRIBUTION_LINES CDL2

5002: (
5003: SELECT
5004: 1
5005: FROM
5006: PA_COST_DISTRIBUTION_LINES CDL2
5007: WHERE
5008: CDL2.EXPENDITURE_ITEM_ID =EI.EXPENDITURE_ITEM_ID
5009: ) ;
5010:

Line 6042: p_amount pa_cost_distribution_lines.amount%TYPE;

6038: X_backout_id IN NUMBER,
6039: X_user IN NUMBER,
6040: X_status OUT NOCOPY NUMBER)
6041: IS
6042: p_amount pa_cost_distribution_lines.amount%TYPE;
6043: p_dr_ccid pa_cost_distribution_lines.dr_code_combination_id%TYPE;
6044: p_cr_ccid pa_cost_distribution_lines.cr_code_combination_id%TYPE;
6045: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;
6046: p_quantity pa_cost_distribution_lines.quantity%TYPE;

Line 6043: p_dr_ccid pa_cost_distribution_lines.dr_code_combination_id%TYPE;

6039: X_user IN NUMBER,
6040: X_status OUT NOCOPY NUMBER)
6041: IS
6042: p_amount pa_cost_distribution_lines.amount%TYPE;
6043: p_dr_ccid pa_cost_distribution_lines.dr_code_combination_id%TYPE;
6044: p_cr_ccid pa_cost_distribution_lines.cr_code_combination_id%TYPE;
6045: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;
6046: p_quantity pa_cost_distribution_lines.quantity%TYPE;
6047: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;

Line 6044: p_cr_ccid pa_cost_distribution_lines.cr_code_combination_id%TYPE;

6040: X_status OUT NOCOPY NUMBER)
6041: IS
6042: p_amount pa_cost_distribution_lines.amount%TYPE;
6043: p_dr_ccid pa_cost_distribution_lines.dr_code_combination_id%TYPE;
6044: p_cr_ccid pa_cost_distribution_lines.cr_code_combination_id%TYPE;
6045: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;
6046: p_quantity pa_cost_distribution_lines.quantity%TYPE;
6047: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;
6048: p_request_id pa_cost_distribution_lines.request_id%TYPE;

Line 6045: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;

6041: IS
6042: p_amount pa_cost_distribution_lines.amount%TYPE;
6043: p_dr_ccid pa_cost_distribution_lines.dr_code_combination_id%TYPE;
6044: p_cr_ccid pa_cost_distribution_lines.cr_code_combination_id%TYPE;
6045: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;
6046: p_quantity pa_cost_distribution_lines.quantity%TYPE;
6047: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;
6048: p_request_id pa_cost_distribution_lines.request_id%TYPE;
6049: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;

Line 6046: p_quantity pa_cost_distribution_lines.quantity%TYPE;

6042: p_amount pa_cost_distribution_lines.amount%TYPE;
6043: p_dr_ccid pa_cost_distribution_lines.dr_code_combination_id%TYPE;
6044: p_cr_ccid pa_cost_distribution_lines.cr_code_combination_id%TYPE;
6045: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;
6046: p_quantity pa_cost_distribution_lines.quantity%TYPE;
6047: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;
6048: p_request_id pa_cost_distribution_lines.request_id%TYPE;
6049: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;
6050: p_program_id pa_cost_distribution_lines.program_id%TYPE;

Line 6047: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;

6043: p_dr_ccid pa_cost_distribution_lines.dr_code_combination_id%TYPE;
6044: p_cr_ccid pa_cost_distribution_lines.cr_code_combination_id%TYPE;
6045: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;
6046: p_quantity pa_cost_distribution_lines.quantity%TYPE;
6047: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;
6048: p_request_id pa_cost_distribution_lines.request_id%TYPE;
6049: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;
6050: p_program_id pa_cost_distribution_lines.program_id%TYPE;
6051: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;

Line 6048: p_request_id pa_cost_distribution_lines.request_id%TYPE;

6044: p_cr_ccid pa_cost_distribution_lines.cr_code_combination_id%TYPE;
6045: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;
6046: p_quantity pa_cost_distribution_lines.quantity%TYPE;
6047: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;
6048: p_request_id pa_cost_distribution_lines.request_id%TYPE;
6049: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;
6050: p_program_id pa_cost_distribution_lines.program_id%TYPE;
6051: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;
6052: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;

Line 6049: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;

6045: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;
6046: p_quantity pa_cost_distribution_lines.quantity%TYPE;
6047: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;
6048: p_request_id pa_cost_distribution_lines.request_id%TYPE;
6049: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;
6050: p_program_id pa_cost_distribution_lines.program_id%TYPE;
6051: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;
6052: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;
6053: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/

Line 6050: p_program_id pa_cost_distribution_lines.program_id%TYPE;

6046: p_quantity pa_cost_distribution_lines.quantity%TYPE;
6047: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;
6048: p_request_id pa_cost_distribution_lines.request_id%TYPE;
6049: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;
6050: p_program_id pa_cost_distribution_lines.program_id%TYPE;
6051: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;
6052: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;
6053: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/
6054: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;

Line 6051: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;

6047: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;
6048: p_request_id pa_cost_distribution_lines.request_id%TYPE;
6049: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;
6050: p_program_id pa_cost_distribution_lines.program_id%TYPE;
6051: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;
6052: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;
6053: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/
6054: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;
6055: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;

Line 6052: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;

6048: p_request_id pa_cost_distribution_lines.request_id%TYPE;
6049: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;
6050: p_program_id pa_cost_distribution_lines.program_id%TYPE;
6051: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;
6052: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;
6053: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/
6054: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;
6055: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;
6056: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;

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

6049: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;
6050: p_program_id pa_cost_distribution_lines.program_id%TYPE;
6051: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;
6052: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;
6053: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/
6054: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;
6055: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;
6056: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;
6057: p_line_type pa_cost_distribution_lines.line_type%TYPE;

Line 6054: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;

6050: p_program_id pa_cost_distribution_lines.program_id%TYPE;
6051: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;
6052: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;
6053: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/
6054: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;
6055: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;
6056: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;
6057: p_line_type pa_cost_distribution_lines.line_type%TYPE;
6058: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;

Line 6055: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;

6051: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;
6052: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;
6053: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/
6054: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;
6055: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;
6056: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;
6057: p_line_type pa_cost_distribution_lines.line_type%TYPE;
6058: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;
6059: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;

Line 6056: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;

6052: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;
6053: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/
6054: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;
6055: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;
6056: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;
6057: p_line_type pa_cost_distribution_lines.line_type%TYPE;
6058: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;
6059: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;
6060: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;

Line 6057: p_line_type pa_cost_distribution_lines.line_type%TYPE;

6053: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/
6054: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;
6055: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;
6056: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;
6057: p_line_type pa_cost_distribution_lines.line_type%TYPE;
6058: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;
6059: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;
6060: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;
6061: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;

Line 6058: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;

6054: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;
6055: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;
6056: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;
6057: p_line_type pa_cost_distribution_lines.line_type%TYPE;
6058: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;
6059: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;
6060: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;
6061: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;
6062: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;

Line 6059: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;

6055: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;
6056: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;
6057: p_line_type pa_cost_distribution_lines.line_type%TYPE;
6058: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;
6059: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;
6060: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;
6061: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;
6062: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;
6063: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;

Line 6060: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;

6056: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;
6057: p_line_type pa_cost_distribution_lines.line_type%TYPE;
6058: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;
6059: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;
6060: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;
6061: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;
6062: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;
6063: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;
6064: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;

Line 6061: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;

6057: p_line_type pa_cost_distribution_lines.line_type%TYPE;
6058: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;
6059: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;
6060: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;
6061: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;
6062: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;
6063: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;
6064: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;
6065: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;

Line 6062: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;

6058: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;
6059: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;
6060: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;
6061: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;
6062: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;
6063: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;
6064: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;
6065: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;
6066: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;

Line 6063: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;

6059: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;
6060: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;
6061: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;
6062: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;
6063: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;
6064: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;
6065: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;
6066: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;
6067: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;

Line 6064: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;

6060: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;
6061: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;
6062: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;
6063: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;
6064: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;
6065: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;
6066: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;
6067: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;
6068: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;

Line 6065: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;

6061: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;
6062: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;
6063: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;
6064: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;
6065: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;
6066: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;
6067: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;
6068: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;
6069: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;

Line 6066: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;

6062: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;
6063: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;
6064: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;
6065: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;
6066: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;
6067: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;
6068: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;
6069: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;
6070: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;

Line 6067: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;

6063: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;
6064: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;
6065: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;
6066: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;
6067: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;
6068: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;
6069: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;
6070: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;
6071: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;

Line 6068: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;

6064: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;
6065: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;
6066: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;
6067: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;
6068: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;
6069: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;
6070: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;
6071: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;
6072: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;

Line 6069: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;

6065: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;
6066: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;
6067: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;
6068: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;
6069: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;
6070: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;
6071: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;
6072: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;
6073: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;

Line 6070: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;

6066: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;
6067: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;
6068: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;
6069: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;
6070: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;
6071: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;
6072: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;
6073: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;
6074: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;

Line 6071: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;

6067: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;
6068: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;
6069: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;
6070: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;
6071: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;
6072: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;
6073: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;
6074: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;
6075: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;

Line 6072: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;

6068: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;
6069: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;
6070: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;
6071: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;
6072: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;
6073: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;
6074: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;
6075: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;
6076: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;

Line 6073: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;

6069: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;
6070: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;
6071: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;
6072: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;
6073: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;
6074: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;
6075: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;
6076: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;
6077: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;

Line 6074: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;

6070: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;
6071: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;
6072: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;
6073: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;
6074: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;
6075: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;
6076: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;
6077: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;
6078: p_project_id pa_cost_distribution_lines.project_id%TYPE;

Line 6075: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;

6071: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;
6072: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;
6073: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;
6074: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;
6075: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;
6076: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;
6077: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;
6078: p_project_id pa_cost_distribution_lines.project_id%TYPE;
6079: p_task_id pa_cost_distribution_lines.task_id%TYPE;

Line 6076: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;

6072: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;
6073: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;
6074: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;
6075: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;
6076: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;
6077: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;
6078: p_project_id pa_cost_distribution_lines.project_id%TYPE;
6079: p_task_id pa_cost_distribution_lines.task_id%TYPE;
6080: p_parent_adjusted_id pa_expenditure_items.adjusted_expenditure_item_id%TYPE;

Line 6077: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;

6073: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;
6074: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;
6075: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;
6076: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;
6077: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;
6078: p_project_id pa_cost_distribution_lines.project_id%TYPE;
6079: p_task_id pa_cost_distribution_lines.task_id%TYPE;
6080: p_parent_adjusted_id pa_expenditure_items.adjusted_expenditure_item_id%TYPE;
6081: p_parent_transferred_id pa_expenditure_items.transferred_from_exp_item_id%TYPE;

Line 6078: p_project_id pa_cost_distribution_lines.project_id%TYPE;

6074: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;
6075: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;
6076: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;
6077: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;
6078: p_project_id pa_cost_distribution_lines.project_id%TYPE;
6079: p_task_id pa_cost_distribution_lines.task_id%TYPE;
6080: p_parent_adjusted_id pa_expenditure_items.adjusted_expenditure_item_id%TYPE;
6081: p_parent_transferred_id pa_expenditure_items.transferred_from_exp_item_id%TYPE;
6082: p_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%TYPE;

Line 6079: p_task_id pa_cost_distribution_lines.task_id%TYPE;

6075: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;
6076: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;
6077: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;
6078: p_project_id pa_cost_distribution_lines.project_id%TYPE;
6079: p_task_id pa_cost_distribution_lines.task_id%TYPE;
6080: p_parent_adjusted_id pa_expenditure_items.adjusted_expenditure_item_id%TYPE;
6081: p_parent_transferred_id pa_expenditure_items.transferred_from_exp_item_id%TYPE;
6082: p_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%TYPE;
6083: p_transaction_source pa_transaction_sources.transaction_source%TYPE;

Line 6084: l_si_assets_addition_flag pa_cost_distribution_lines.si_assets_addition_flag%TYPE ;

6080: p_parent_adjusted_id pa_expenditure_items.adjusted_expenditure_item_id%TYPE;
6081: p_parent_transferred_id pa_expenditure_items.transferred_from_exp_item_id%TYPE;
6082: p_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%TYPE;
6083: p_transaction_source pa_transaction_sources.transaction_source%TYPE;
6084: l_si_assets_addition_flag pa_cost_distribution_lines.si_assets_addition_flag%TYPE ;
6085: p_err_code NUMBER;
6086: p_err_stage VARCHAR2(1000);
6087: p_err_stack VARCHAR2(1000);
6088: e_cdl_error EXCEPTION;

Line 6106: p_cdlsr4 pa_cost_distribution_lines.system_reference4%TYPE;

6102: p_project_raw_cost NUMBER;
6103: p_project_burdened_cost NUMBER;
6104: -- End Project Currency/ EI Attribute Changes
6105: -- AP Discounts
6106: p_cdlsr4 pa_cost_distribution_lines.system_reference4%TYPE;
6107: p_cdlsr5 pa_cost_distribution_lines.system_reference5%TYPE;
6108:
6109: l_pa_date DATE ;
6110: l_recvr_pa_date DATE ;

Line 6107: p_cdlsr5 pa_cost_distribution_lines.system_reference5%TYPE;

6103: p_project_burdened_cost NUMBER;
6104: -- End Project Currency/ EI Attribute Changes
6105: -- AP Discounts
6106: p_cdlsr4 pa_cost_distribution_lines.system_reference4%TYPE;
6107: p_cdlsr5 pa_cost_distribution_lines.system_reference5%TYPE;
6108:
6109: l_pa_date DATE ;
6110: l_recvr_pa_date DATE ;
6111: l_ei_date DATE ;

Line 6114: actual_cdl_line_num pa_cost_distribution_lines.line_num%TYPE;

6110: l_recvr_pa_date DATE ;
6111: l_ei_date DATE ;
6112: l_org_id pa_expenditure_items.org_id%type;
6113:
6114: actual_cdl_line_num pa_cost_distribution_lines.line_num%TYPE;
6115:
6116:
6117: l_recvr_org_id pa_expenditure_items.org_id%type;
6118: l_gl_date DATE;

Line 6170: FROM pa_cost_distribution_lines cdl

6166: this case is the billable_flag */
6167:
6168: SELECT max(cdl.line_num)
6169: INTO actual_cdl_line_num
6170: FROM pa_cost_distribution_lines cdl
6171: WHERE cdl.expenditure_item_id = X_exp_item_id and cdl.line_type = 'R';
6172: /* Addition for bug 2378505 ends */
6173:
6174: SELECT amount

Line 6274: FROM pa_cost_distribution_lines_All -- 12i MOAC changes

6270: , p_cdlsr5
6271: , l_si_assets_addition_flag
6272: , l_rate_source_code
6273: , l_costing_method
6274: FROM pa_cost_distribution_lines_All -- 12i MOAC changes
6275: WHERE expenditure_item_id = X_exp_item_id
6276: AND line_num = actual_cdl_line_num; -- bug2378505
6277: /* Getting pa and gl period information for 2661921 */
6278: PA_UTILS2.get_period_information(