APPS.AP_WEB_DB_EXPDIST_PKG dependencies on AP_EXPENSE_REPORT_LINES

Line 738: p_report_line_id IN AP_EXPENSE_REPORT_LINES.REPORT_LINE_ID%TYPE)

734: END updateDistAcctValuesForForms;
735:
736: --------------------------------------------------------------------------------
737: PROCEDURE AddDistributionLine(
738: p_report_line_id IN AP_EXPENSE_REPORT_LINES.REPORT_LINE_ID%TYPE)
739: IS
740: --------------------------------------------------------------------------------
741: l_debug_info varchar2(1000);
742: l_sequence_num NUMBER;

Line 847: FROM AP_EXPENSE_REPORT_LINES XL,

843: XL.task_id,
844: XL.award_id,
845: XL.expenditure_organization_id,
846: XH.flex_concatenated -- Bug: 6735020, flex_concatenated should be fetched from headers
847: FROM AP_EXPENSE_REPORT_LINES XL,
848: AP_EXPENSE_REPORT_HEADERS XH,
849: GL_CODE_COMBINATIONS GL
850: WHERE XL.report_line_id = p_report_line_id
851: AND XL.report_header_id = XH.report_header_id

Line 870: p_report_line_id IN AP_EXPENSE_REPORT_LINES.REPORT_LINE_ID%TYPE,

866:
867: --------------------------------------------------------------------------------
868: PROCEDURE AddDistributionLine(
869: p_segments IN AP_OIE_KFF_SEGMENTS_T,
870: p_report_line_id IN AP_EXPENSE_REPORT_LINES.REPORT_LINE_ID%TYPE,
871: p_chart_of_accounts_id IN NUMBER)
872: IS
873: --------------------------------------------------------------------------------
874: l_debug_info varchar2(1000);

Line 937: l_debug_info := 'select from ap_expense_report_lines';

933: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',
934: 'start AddDistributionLine');
935:
936: -----------------------------------------------------
937: l_debug_info := 'select from ap_expense_report_lines';
938: -----------------------------------------------------
939: l_sequence_num := 0;
940: SELECT XL.report_header_id,
941: XL.code_combination_id,

Line 962: FROM ap_expense_report_lines XL,

958: l_task_id,
959: l_award_id,
960: l_expenditure_organization_id,
961: l_cost_center
962: FROM ap_expense_report_lines XL,
963: ap_expense_report_headers XH
964: WHERE XL.report_line_id = p_report_line_id
965: AND XL.report_header_id = XH.report_header_id;
966: