APPS.AP_WEB_RECEIPTS_WF dependencies on AP_WEB_DB_EXPRPT_PKG

Line 136: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(l_expense_report_id, l_org_id) <> TRUE) THEN

132:
133: ----------------------------------------------------------
134: l_debug_info := 'Get the Expense Report Org Id';
135: ----------------------------------------------------------
136: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(l_expense_report_id, l_org_id) <> TRUE) THEN
137: l_org_id := NULL;
138: END IF;
139:
140: ----------------------------------------------------------

Line 543: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(l_expense_report_id, l_org_id) <> TRUE) THEN

539:
540: ----------------------------------------------------------
541: l_debug_info := 'Get the Expense Report Org Id';
542: ----------------------------------------------------------
543: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(l_expense_report_id, l_org_id) <> TRUE) THEN
544: l_org_id := NULL;
545: END IF;
546:
547:

Line 2354: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(l_expense_report_id, l_org_id) <> TRUE) THEN

2350: l_expense_report_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
2351: p_item_key,
2352: 'EXPENSE_REPORT_ID');
2353:
2354: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(l_expense_report_id, l_org_id) <> TRUE) THEN
2355: l_org_id := NULL;
2356: END IF;
2357:
2358: WF_ENGINE.SetItemAttrNumber(p_item_type,

Line 3047: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(l_expense_report_id, l_org_id) <> TRUE) THEN

3043: l_image_receipts_status := 'N';
3044: END IF;
3045:
3046:
3047: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(l_expense_report_id, l_org_id) <> TRUE) THEN
3048: l_org_id := NULL;
3049: END IF;
3050:
3051: l_report_submitted_date := WF_ENGINE.GetItemAttrDate(p_item_type,

Line 3504: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(l_expense_report_id, l_org_id) <> TRUE) THEN

3500: Wf_Core.Raise('InvalidExpenseReportId');
3501: end if;
3502: l_item_key := to_char(l_expense_report_id);
3503:
3504: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(l_expense_report_id, l_org_id) <> TRUE) THEN
3505: l_org_id := NULL;
3506: END IF;
3507:
3508: l_report_submitted_date := WF_ENGINE.GetItemAttrDate(p_item_type,

Line 3530: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetWkflApprvdFlagAndSource(l_expense_report_id,

3526: report_submitted_date = null,last_update_date = sysdate
3527: where report_header_id = l_expense_report_id;
3528:
3529:
3530: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetWkflApprvdFlagAndSource(l_expense_report_id,
3531: AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_RETURNED,
3532: 'NonValidatedWebExpense')) THEN
3533: NULL;
3534: END IF;

Line 3531: AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_RETURNED,

3527: where report_header_id = l_expense_report_id;
3528:
3529:
3530: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetWkflApprvdFlagAndSource(l_expense_report_id,
3531: AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_RETURNED,
3532: 'NonValidatedWebExpense')) THEN
3533: NULL;
3534: END IF;
3535: BEGIN

Line 3620: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(l_expense_report_id, l_org_id) <> TRUE) THEN

3616: SetReceiptsStatus(l_expense_report_id, 'REQUIRED');
3617: END IF;
3618:
3619: /*
3620: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(l_expense_report_id, l_org_id) <> TRUE) THEN
3621: l_org_id := NULL;
3622: END IF;
3623:
3624: l_report_submitted_date := WF_ENGINE.GetItemAttrDate(p_item_type,

Line 3835: IF (l_wf_status_code = AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_RETURNED) THEN

3831: SELECT nvl(workflow_approved_flag, 1) INTO l_wf_status_code
3832: FROM ap_expense_report_headers_all
3833: WHERE report_header_id = l_report_header_id;
3834:
3835: IF (l_wf_status_code = AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_RETURNED) THEN
3836: p_result := 'COMPLETE:Y';
3837: ELSE
3838: p_result := 'COMPLETE:N';
3839: END IF;