APPS.AP_WEB_OA_MAINFLOW_PKG dependencies on AP_WEB_DB_EXPLINE_PKG

Line 1188: AP_WEB_DB_EXPLINE_PKG.DuplicateLines(p_user_id, p_source_report_header_id, p_target_report_header_id);

1184: into p_target_report_header_id
1185: from sys.dual;
1186:
1187: AP_WEB_DB_EXPRPT_PKG.DuplicateHeader(p_user_id, p_source_report_header_id, p_target_report_header_id);
1188: AP_WEB_DB_EXPLINE_PKG.DuplicateLines(p_user_id, p_source_report_header_id, p_target_report_header_id);
1189:
1190: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',
1191: 'end DuplicateExpenseReport');
1192:

Line 1570: l_ReportLines AP_WEB_DB_EXPLINE_PKG.CCTrxnCursor;

1566: l_DebugInfo VARCHAR2(200);
1567: l_count NUMBER;
1568: l_idArray AP_WEB_PARENT_PKG.number_Array;
1569: l_amtArray AP_WEB_PARENT_PKG.number_Array;
1570: l_ReportLines AP_WEB_DB_EXPLINE_PKG.CCTrxnCursor;
1571: l_WkflRec AP_WEB_DB_EXPRPT_PKG.ExpWorkflowRec;
1572: BEGIN
1573: l_DebugInfo := 'Get all the ids and amounts of credit card receipts';
1574:

Line 1575: IF (AP_WEB_DB_EXPLINE_PKG.GetTrxIdsAndAmtsCursor(ReportID, l_ReportLines)) THEN

1571: l_WkflRec AP_WEB_DB_EXPRPT_PKG.ExpWorkflowRec;
1572: BEGIN
1573: l_DebugInfo := 'Get all the ids and amounts of credit card receipts';
1574:
1575: IF (AP_WEB_DB_EXPLINE_PKG.GetTrxIdsAndAmtsCursor(ReportID, l_ReportLines)) THEN
1576: l_count := 1;
1577: LOOP
1578: FETCH l_ReportLines INTO l_idArray(l_count), l_amtArray(l_count);
1579: EXIT WHEN l_ReportLines%NOTFOUND;

Line 1605: IF (NOT AP_WEB_DB_EXPLINE_PKG.DeleteReportLines(ReportID))THEN

1601: raise NO_DATA_FOUND;
1602: END IF;
1603:
1604: l_DebugInfo := 'Delete report lines';
1605: IF (NOT AP_WEB_DB_EXPLINE_PKG.DeleteReportLines(ReportID))THEN
1606: raise NO_DATA_FOUND;
1607: END IF;
1608:
1609: l_DebugInfo := 'update credit card charges';