APPS.AP_WEB_OA_MAINFLOW_PKG dependencies on AP_WEB_DB_EXPRPT_PKG

Line 36: AP_WEB_DB_EXPRPT_PKG.GetEmployeeIdFromBothPayParent(p_bothpay_parent_id,

32: BEGIN
33: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',
34: 'start GetEmployeeIdFromBothPayParent');
35:
36: AP_WEB_DB_EXPRPT_PKG.GetEmployeeIdFromBothPayParent(p_bothpay_parent_id,
37: p_employee_id);
38:
39: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',
40: 'end GetEmployeeIdFromBothPayParent');

Line 804: l_ResubmitReport := AP_WEB_DB_EXPRPT_PKG.ResubmitExpenseReport(

800: -------------------------------------------------------------------
801: -- Check to see if this is resubmitting a rejected/returned report
802: -- If so then restart existing WF else raise a Submit event
803: -------------------------------------------------------------------
804: l_ResubmitReport := AP_WEB_DB_EXPRPT_PKG.ResubmitExpenseReport(
805: p_workflow_appr_flag);
806:
807: IF (TRUE) THEN
808:

Line 1185: AP_WEB_DB_EXPRPT_PKG.DuplicateHeader(p_user_id, p_source_report_header_id, p_target_report_header_id);

1181: select AP_EXPENSE_REPORT_HEADERS_S.NEXTVAL
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');

Line 1569: l_WkflRec AP_WEB_DB_EXPRPT_PKG.ExpWorkflowRec;

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:
1573: IF (AP_WEB_DB_EXPLINE_PKG.GetTrxIdsAndAmtsCursor(ReportID, l_ReportLines)) THEN

Line 1584: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetExpWorkflowInfo(ReportID,l_WkflRec)) THEN

1580: END IF;
1581: CLOSE l_ReportLines;
1582:
1583: -- Abort workflow process if report has been previously rejected
1584: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetExpWorkflowInfo(ReportID,l_WkflRec)) THEN
1585: l_WkflRec.workflow_flag := NULL;
1586: END IF;
1587:
1588: IF AP_WEB_DB_EXPRPT_PKG.ResubmitExpenseReport(l_WkflRec.workflow_flag) THEN

Line 1588: IF AP_WEB_DB_EXPRPT_PKG.ResubmitExpenseReport(l_WkflRec.workflow_flag) THEN

1584: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetExpWorkflowInfo(ReportID,l_WkflRec)) THEN
1585: l_WkflRec.workflow_flag := NULL;
1586: END IF;
1587:
1588: IF AP_WEB_DB_EXPRPT_PKG.ResubmitExpenseReport(l_WkflRec.workflow_flag) THEN
1589: begin
1590: WF_ENGINE.AbortProcess('APEXP', ReportID);
1591: exception
1592: when others then null;

Line 1598: IF (NOT AP_WEB_DB_EXPRPT_PKG.DeleteReportHeaderAtDate(ReportID)) THEN

1594: END IF;
1595:
1596:
1597: l_DebugInfo := 'Delete report header';
1598: IF (NOT AP_WEB_DB_EXPRPT_PKG.DeleteReportHeaderAtDate(ReportID)) THEN
1599: raise NO_DATA_FOUND;
1600: END IF;
1601:
1602: l_DebugInfo := 'Delete report lines';