DBA Data[Home] [Help]

APPS.AP_WEB_DB_EXPDIST_PKG dependencies on AP_EXPENSE_REPORT_LINES

Line 745: p_report_line_id IN AP_EXPENSE_REPORT_LINES.REPORT_LINE_ID%TYPE)

741: END updateDistAcctValuesForForms;
742:
743: --------------------------------------------------------------------------------
744: PROCEDURE AddDistributionLine(
745: p_report_line_id IN AP_EXPENSE_REPORT_LINES.REPORT_LINE_ID%TYPE)
746: IS
747: --------------------------------------------------------------------------------
748: l_debug_info varchar2(1000);
749: l_sequence_num NUMBER;

Line 856: FROM AP_EXPENSE_REPORT_LINES XL,

852: XL.award_id,
853: XL.expenditure_organization_id,
854: XH.flex_concatenated, -- Bug: 6735020, flex_concatenated should be fetched from headers
855: XL.web_parameter_id
856: FROM AP_EXPENSE_REPORT_LINES XL,
857: AP_EXPENSE_REPORT_HEADERS XH,
858: GL_CODE_COMBINATIONS GL
859: WHERE XL.report_line_id = p_report_line_id
860: AND XL.report_header_id = XH.report_header_id

Line 879: p_report_line_id IN AP_EXPENSE_REPORT_LINES.REPORT_LINE_ID%TYPE,

875:
876: --------------------------------------------------------------------------------
877: PROCEDURE AddDistributionLine(
878: p_segments IN AP_OIE_KFF_SEGMENTS_T,
879: p_report_line_id IN AP_EXPENSE_REPORT_LINES.REPORT_LINE_ID%TYPE,
880: p_chart_of_accounts_id IN NUMBER)
881: IS
882: --------------------------------------------------------------------------------
883: l_debug_info varchar2(1000);

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

965: -- Bug 7395568, get the cost center
966: l_cost_center := p_segments(l_cost_center_seg_num);
967:
968: -----------------------------------------------------
969: l_debug_info := 'select from ap_expense_report_lines';
970: -----------------------------------------------------
971: l_sequence_num := 0;
972: SELECT XL.report_header_id,
973: XL.code_combination_id,

Line 994: FROM ap_expense_report_lines XL,

990: l_task_id,
991: l_award_id,
992: l_expenditure_organization_id,
993: l_cost_center
994: FROM ap_expense_report_lines XL,
995: ap_expense_report_headers XH
996: WHERE XL.report_line_id = p_report_line_id
997: AND XL.report_header_id = XH.report_header_id;
998: