DBA Data[Home] [Help]

APPS.AP_WEB_OA_MAINFLOW_PKG dependencies on AP_WEB_DB_EXPLINE_PKG

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

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

Line 1568: l_ReportLines AP_WEB_DB_EXPLINE_PKG.CCTrxnCursor;

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

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

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

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

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