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

Line 523: FROM pa_cost_distribution_lines cdl

519: ,cdl.denom_raw_cost
520: ,cdl.denom_burdened_cost
521: ,cdl.project_raw_cost
522: ,cdl.project_burdened_cost
523: FROM pa_cost_distribution_lines cdl
524: WHERE cdl.expenditure_item_id=ei.expenditure_item_id
525: AND cdl.line_type='R'
526: AND NVL(cdl.reversed_flag,'N')='N'
527: AND cdl.line_num_reversed IS NULL)

Line 534: FROM pa_cost_distribution_lines cdl2

530: AND ei.adjustment_type is not null
531: AND ei.costing_method is not null
532: AND EXISTS (
533: SELECT 1
534: FROM pa_cost_distribution_lines cdl2
535: WHERE cdl2.expenditure_item_id =ei.expenditure_item_id
536: );
537:
538: END IF ;

Line 933: p_amount pa_cost_distribution_lines.amount%TYPE;

929: X_backout_id IN NUMBER,
930: X_user IN NUMBER,
931: X_status OUT NOCOPY NUMBER)
932: IS
933: p_amount pa_cost_distribution_lines.amount%TYPE;
934: p_dr_ccid pa_cost_distribution_lines.dr_code_combination_id%TYPE;
935: p_cr_ccid pa_cost_distribution_lines.cr_code_combination_id%TYPE;
936: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;
937: p_quantity pa_cost_distribution_lines.quantity%TYPE;

Line 934: p_dr_ccid pa_cost_distribution_lines.dr_code_combination_id%TYPE;

930: X_user IN NUMBER,
931: X_status OUT NOCOPY NUMBER)
932: IS
933: p_amount pa_cost_distribution_lines.amount%TYPE;
934: p_dr_ccid pa_cost_distribution_lines.dr_code_combination_id%TYPE;
935: p_cr_ccid pa_cost_distribution_lines.cr_code_combination_id%TYPE;
936: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;
937: p_quantity pa_cost_distribution_lines.quantity%TYPE;
938: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;

Line 935: p_cr_ccid pa_cost_distribution_lines.cr_code_combination_id%TYPE;

931: X_status OUT NOCOPY NUMBER)
932: IS
933: p_amount pa_cost_distribution_lines.amount%TYPE;
934: p_dr_ccid pa_cost_distribution_lines.dr_code_combination_id%TYPE;
935: p_cr_ccid pa_cost_distribution_lines.cr_code_combination_id%TYPE;
936: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;
937: p_quantity pa_cost_distribution_lines.quantity%TYPE;
938: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;
939: p_request_id pa_cost_distribution_lines.request_id%TYPE;

Line 936: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;

932: IS
933: p_amount pa_cost_distribution_lines.amount%TYPE;
934: p_dr_ccid pa_cost_distribution_lines.dr_code_combination_id%TYPE;
935: p_cr_ccid pa_cost_distribution_lines.cr_code_combination_id%TYPE;
936: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;
937: p_quantity pa_cost_distribution_lines.quantity%TYPE;
938: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;
939: p_request_id pa_cost_distribution_lines.request_id%TYPE;
940: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;

Line 937: p_quantity pa_cost_distribution_lines.quantity%TYPE;

933: p_amount pa_cost_distribution_lines.amount%TYPE;
934: p_dr_ccid pa_cost_distribution_lines.dr_code_combination_id%TYPE;
935: p_cr_ccid pa_cost_distribution_lines.cr_code_combination_id%TYPE;
936: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;
937: p_quantity pa_cost_distribution_lines.quantity%TYPE;
938: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;
939: p_request_id pa_cost_distribution_lines.request_id%TYPE;
940: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;
941: p_program_id pa_cost_distribution_lines.program_id%TYPE;

Line 938: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;

934: p_dr_ccid pa_cost_distribution_lines.dr_code_combination_id%TYPE;
935: p_cr_ccid pa_cost_distribution_lines.cr_code_combination_id%TYPE;
936: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;
937: p_quantity pa_cost_distribution_lines.quantity%TYPE;
938: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;
939: p_request_id pa_cost_distribution_lines.request_id%TYPE;
940: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;
941: p_program_id pa_cost_distribution_lines.program_id%TYPE;
942: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;

Line 939: p_request_id pa_cost_distribution_lines.request_id%TYPE;

935: p_cr_ccid pa_cost_distribution_lines.cr_code_combination_id%TYPE;
936: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;
937: p_quantity pa_cost_distribution_lines.quantity%TYPE;
938: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;
939: p_request_id pa_cost_distribution_lines.request_id%TYPE;
940: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;
941: p_program_id pa_cost_distribution_lines.program_id%TYPE;
942: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;
943: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;

Line 940: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;

936: p_transfer_status_code pa_cost_distribution_lines.transfer_status_code%TYPE;
937: p_quantity pa_cost_distribution_lines.quantity%TYPE;
938: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;
939: p_request_id pa_cost_distribution_lines.request_id%TYPE;
940: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;
941: p_program_id pa_cost_distribution_lines.program_id%TYPE;
942: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;
943: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;
944: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/

Line 941: p_program_id pa_cost_distribution_lines.program_id%TYPE;

937: p_quantity pa_cost_distribution_lines.quantity%TYPE;
938: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;
939: p_request_id pa_cost_distribution_lines.request_id%TYPE;
940: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;
941: p_program_id pa_cost_distribution_lines.program_id%TYPE;
942: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;
943: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;
944: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/
945: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;

Line 942: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;

938: p_billable_flag pa_cost_distribution_lines.billable_flag%TYPE;
939: p_request_id pa_cost_distribution_lines.request_id%TYPE;
940: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;
941: p_program_id pa_cost_distribution_lines.program_id%TYPE;
942: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;
943: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;
944: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/
945: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;
946: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;

Line 943: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;

939: p_request_id pa_cost_distribution_lines.request_id%TYPE;
940: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;
941: p_program_id pa_cost_distribution_lines.program_id%TYPE;
942: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;
943: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;
944: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/
945: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;
946: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;
947: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;

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

940: p_program_application_id pa_cost_distribution_lines.program_application_id%TYPE;
941: p_program_id pa_cost_distribution_lines.program_id%TYPE;
942: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;
943: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;
944: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/
945: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;
946: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;
947: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;
948: p_line_type pa_cost_distribution_lines.line_type%TYPE;

Line 945: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;

941: p_program_id pa_cost_distribution_lines.program_id%TYPE;
942: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;
943: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;
944: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/
945: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;
946: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;
947: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;
948: p_line_type pa_cost_distribution_lines.line_type%TYPE;
949: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;

Line 946: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;

942: p_program_update_date pa_cost_distribution_lines.program_update_date%TYPE;
943: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;
944: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/
945: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;
946: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;
947: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;
948: p_line_type pa_cost_distribution_lines.line_type%TYPE;
949: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;
950: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;

Line 947: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;

943: p_pa_date pa_cost_distribution_lines.pa_date%TYPE;
944: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/
945: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;
946: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;
947: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;
948: p_line_type pa_cost_distribution_lines.line_type%TYPE;
949: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;
950: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;
951: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;

Line 948: p_line_type pa_cost_distribution_lines.line_type%TYPE;

944: p_recvr_pa_date pa_cost_distribution_lines.pa_date%TYPE; /**CBGA**/
945: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;
946: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;
947: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;
948: p_line_type pa_cost_distribution_lines.line_type%TYPE;
949: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;
950: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;
951: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;
952: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;

Line 949: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;

945: p_gl_date pa_cost_distribution_lines.gl_date%TYPE;
946: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;
947: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;
948: p_line_type pa_cost_distribution_lines.line_type%TYPE;
949: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;
950: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;
951: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;
952: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;
953: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;

Line 950: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;

946: p_transferred_date pa_cost_distribution_lines.transferred_date%TYPE;
947: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;
948: p_line_type pa_cost_distribution_lines.line_type%TYPE;
949: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;
950: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;
951: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;
952: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;
953: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;
954: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;

Line 951: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;

947: p_transfer_rejection_reason pa_cost_distribution_lines.transfer_rejection_reason%TYPE;
948: p_line_type pa_cost_distribution_lines.line_type%TYPE;
949: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;
950: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;
951: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;
952: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;
953: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;
954: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;
955: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;

Line 952: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;

948: p_line_type pa_cost_distribution_lines.line_type%TYPE;
949: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;
950: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;
951: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;
952: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;
953: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;
954: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;
955: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;
956: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;

Line 953: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;

949: p_ind_complied_set_id pa_cost_distribution_lines.ind_compiled_set_id%TYPE;
950: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;
951: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;
952: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;
953: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;
954: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;
955: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;
956: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;
957: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;

Line 954: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;

950: p_burdened_cost pa_cost_distribution_lines.burdened_cost%TYPE;
951: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;
952: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;
953: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;
954: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;
955: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;
956: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;
957: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;
958: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;

Line 955: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;

951: p_line_num_reversed pa_cost_distribution_lines.line_num_reversed%TYPE;
952: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;
953: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;
954: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;
955: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;
956: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;
957: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;
958: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;
959: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;

Line 956: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;

952: p_reversed_flag pa_cost_distribution_lines.reversed_flag%TYPE;
953: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;
954: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;
955: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;
956: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;
957: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;
958: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;
959: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;
960: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;

Line 957: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;

953: p_cdlsr1 pa_cost_distribution_lines.system_reference1%TYPE;
954: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;
955: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;
956: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;
957: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;
958: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;
959: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;
960: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;
961: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;

Line 958: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;

954: p_cdlsr2 pa_cost_distribution_lines.system_reference2%TYPE;
955: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;
956: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;
957: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;
958: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;
959: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;
960: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;
961: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;
962: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;

Line 959: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;

955: p_cdlsr3 pa_cost_distribution_lines.system_reference3%TYPE;
956: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;
957: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;
958: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;
959: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;
960: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;
961: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;
962: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;
963: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;

Line 960: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;

956: p_denom_currency_code pa_cost_distribution_lines.denom_currency_code%TYPE;
957: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;
958: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;
959: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;
960: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;
961: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;
962: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;
963: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;
964: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;

Line 961: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;

957: p_denom_raw_cost pa_cost_distribution_lines.denom_raw_cost%TYPE;
958: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;
959: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;
960: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;
961: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;
962: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;
963: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;
964: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;
965: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;

Line 962: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;

958: p_denom_burdened_cost pa_cost_distribution_lines.denom_burdened_cost%TYPE;
959: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;
960: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;
961: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;
962: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;
963: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;
964: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;
965: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;
966: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;

Line 963: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;

959: p_acct_currency_code pa_cost_distribution_lines.acct_currency_code%TYPE;
960: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;
961: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;
962: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;
963: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;
964: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;
965: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;
966: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;
967: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;

Line 964: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;

960: p_acct_rate_date pa_cost_distribution_lines.acct_rate_date%TYPE;
961: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;
962: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;
963: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;
964: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;
965: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;
966: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;
967: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;
968: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;

Line 965: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;

961: p_acct_rate_type pa_cost_distribution_lines.acct_rate_type%TYPE;
962: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;
963: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;
964: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;
965: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;
966: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;
967: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;
968: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;
969: p_project_id pa_cost_distribution_lines.project_id%TYPE;

Line 966: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;

962: p_acct_exchange_rate pa_cost_distribution_lines.acct_exchange_rate%TYPE;
963: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;
964: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;
965: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;
966: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;
967: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;
968: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;
969: p_project_id pa_cost_distribution_lines.project_id%TYPE;
970: p_task_id pa_cost_distribution_lines.task_id%TYPE;

Line 967: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;

963: p_acct_raw_cost pa_cost_distribution_lines.acct_raw_cost%TYPE;
964: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;
965: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;
966: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;
967: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;
968: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;
969: p_project_id pa_cost_distribution_lines.project_id%TYPE;
970: p_task_id pa_cost_distribution_lines.task_id%TYPE;
971: p_parent_adjusted_id pa_expenditure_items.adjusted_expenditure_item_id%TYPE;

Line 968: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;

964: p_acct_burdened_cost pa_cost_distribution_lines.acct_burdened_cost%TYPE;
965: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;
966: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;
967: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;
968: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;
969: p_project_id pa_cost_distribution_lines.project_id%TYPE;
970: p_task_id pa_cost_distribution_lines.task_id%TYPE;
971: p_parent_adjusted_id pa_expenditure_items.adjusted_expenditure_item_id%TYPE;
972: p_parent_transferred_id pa_expenditure_items.transferred_from_exp_item_id%TYPE;

Line 969: p_project_id pa_cost_distribution_lines.project_id%TYPE;

965: p_project_currency_code pa_cost_distribution_lines.project_currency_code%TYPE;
966: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;
967: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;
968: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;
969: p_project_id pa_cost_distribution_lines.project_id%TYPE;
970: p_task_id pa_cost_distribution_lines.task_id%TYPE;
971: p_parent_adjusted_id pa_expenditure_items.adjusted_expenditure_item_id%TYPE;
972: p_parent_transferred_id pa_expenditure_items.transferred_from_exp_item_id%TYPE;
973: p_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%TYPE;

Line 970: p_task_id pa_cost_distribution_lines.task_id%TYPE;

966: p_project_rate_date pa_cost_distribution_lines.project_rate_date%TYPE;
967: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;
968: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;
969: p_project_id pa_cost_distribution_lines.project_id%TYPE;
970: p_task_id pa_cost_distribution_lines.task_id%TYPE;
971: p_parent_adjusted_id pa_expenditure_items.adjusted_expenditure_item_id%TYPE;
972: p_parent_transferred_id pa_expenditure_items.transferred_from_exp_item_id%TYPE;
973: p_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%TYPE;
974: p_transaction_source pa_transaction_sources.transaction_source%TYPE;

Line 975: l_si_assets_addition_flag pa_cost_distribution_lines.si_assets_addition_flag%TYPE ;

971: p_parent_adjusted_id pa_expenditure_items.adjusted_expenditure_item_id%TYPE;
972: p_parent_transferred_id pa_expenditure_items.transferred_from_exp_item_id%TYPE;
973: p_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%TYPE;
974: p_transaction_source pa_transaction_sources.transaction_source%TYPE;
975: l_si_assets_addition_flag pa_cost_distribution_lines.si_assets_addition_flag%TYPE ;
976: p_err_code NUMBER;
977: p_err_stage VARCHAR2(1000);
978: p_err_stack VARCHAR2(1000);
979: e_cdl_error EXCEPTION;

Line 997: p_cdlsr4 pa_cost_distribution_lines.system_reference4%TYPE;

993: p_project_raw_cost NUMBER;
994: p_project_burdened_cost NUMBER;
995: -- End Project Currency/ EI Attribute Changes
996: -- AP Discounts
997: p_cdlsr4 pa_cost_distribution_lines.system_reference4%TYPE;
998: p_cdlsr5 pa_cost_distribution_lines.system_reference5%TYPE;
999: l_pa_date DATE ;
1000: l_recvr_pa_date DATE ;
1001: l_ei_date DATE ;

Line 998: p_cdlsr5 pa_cost_distribution_lines.system_reference5%TYPE;

994: p_project_burdened_cost NUMBER;
995: -- End Project Currency/ EI Attribute Changes
996: -- AP Discounts
997: p_cdlsr4 pa_cost_distribution_lines.system_reference4%TYPE;
998: p_cdlsr5 pa_cost_distribution_lines.system_reference5%TYPE;
999: l_pa_date DATE ;
1000: l_recvr_pa_date DATE ;
1001: l_ei_date DATE ;
1002: l_org_id pa_expenditure_items.org_id%type;

Line 1003: actual_cdl_line_num pa_cost_distribution_lines.line_num%TYPE;

999: l_pa_date DATE ;
1000: l_recvr_pa_date DATE ;
1001: l_ei_date DATE ;
1002: l_org_id pa_expenditure_items.org_id%type;
1003: actual_cdl_line_num pa_cost_distribution_lines.line_num%TYPE;
1004: l_recvr_org_id pa_expenditure_items.org_id%type;
1005: l_gl_date DATE;
1006: l_recvr_gl_date DATE;
1007: l_exp_id NUMBER;

Line 1047: FROM pa_cost_distribution_lines cdl

1043: AND imp2.org_id = l_recvr_org_id;
1044:
1045: SELECT max(cdl.line_num)
1046: INTO actual_cdl_line_num
1047: FROM pa_cost_distribution_lines cdl
1048: WHERE cdl.expenditure_item_id = X_exp_item_id and cdl.line_type = 'R';
1049: SELECT amount
1050: , dr_code_combination_id
1051: , cr_code_combination_id

Line 1149: FROM pa_cost_distribution_lines_All

1145: , p_cdlsr5
1146: , l_si_assets_addition_flag
1147: , l_rate_source_code
1148: , l_costing_method
1149: FROM pa_cost_distribution_lines_All
1150: WHERE expenditure_item_id = X_exp_item_id
1151: AND line_num = actual_cdl_line_num;
1152: PA_UTILS2.get_period_information(
1153: p_expenditure_item_date => l_ei_date