APPS.AP_WEB_EXPENSE_CUST_WF dependencies on AP_WEB_DB_EXPRPT_PKG

Line 333: IF (NOT (AP_WEB_DB_EXPRPT_PKG.GetOverrideApproverID(to_number(p_item_key), l_curr_approver_id))) THEN

329: /* removed IF (l_AMEEnabled = 'N') to avoid error AP_WEB_EXP_COST_CTR_DIFF
330: when cost center is changed and override approver is entered
331: */
332: IF (l_find_approver_count = 0) THEN
333: IF (NOT (AP_WEB_DB_EXPRPT_PKG.GetOverrideApproverID(to_number(p_item_key), l_curr_approver_id))) THEN
334: l_curr_approver_id := NULL;
335: END IF;
336: END IF;
337:

Line 603: l_report_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;

599: p_item_key IN VARCHAR2,
600: p_item_type IN VARCHAR2) RETURN BOOLEAN IS
601: ---------------------------------------------------------------------
602: l_has_authority BOOLEAN;
603: l_report_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
604: l_exch_rate AP_WEB_DB_EXPRPT_PKG.expHdr_defaultExchRate;
605: l_reimb_precision AP_WEB_DB_COUNTRY_PKG.curr_precision;
606: l_debug_info VARCHAR2(240);
607: l_exp_info_rec AP_WEB_DB_EXPRPT_PKG.ExpInfoRec;

Line 604: l_exch_rate AP_WEB_DB_EXPRPT_PKG.expHdr_defaultExchRate;

600: p_item_type IN VARCHAR2) RETURN BOOLEAN IS
601: ---------------------------------------------------------------------
602: l_has_authority BOOLEAN;
603: l_report_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
604: l_exch_rate AP_WEB_DB_EXPRPT_PKG.expHdr_defaultExchRate;
605: l_reimb_precision AP_WEB_DB_COUNTRY_PKG.curr_precision;
606: l_debug_info VARCHAR2(240);
607: l_exp_info_rec AP_WEB_DB_EXPRPT_PKG.ExpInfoRec;
608:

Line 607: l_exp_info_rec AP_WEB_DB_EXPRPT_PKG.ExpInfoRec;

603: l_report_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
604: l_exch_rate AP_WEB_DB_EXPRPT_PKG.expHdr_defaultExchRate;
605: l_reimb_precision AP_WEB_DB_COUNTRY_PKG.curr_precision;
606: l_debug_info VARCHAR2(240);
607: l_exp_info_rec AP_WEB_DB_EXPRPT_PKG.ExpInfoRec;
608:
609:
610: BEGIN
611:

Line 624: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetReportInfo(l_report_id,l_exp_info_rec)) THEN

620:
621: -----------------------------------------------------
622: l_debug_info := 'Get Expense Report Currency Info';
623: -----------------------------------------------------
624: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetReportInfo(l_report_id,l_exp_info_rec)) THEN
625: return false;
626: END IF;
627:
628: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetExpReportExchCurrInfo(l_report_id, l_exch_rate, l_reimb_precision)) THEN

Line 628: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetExpReportExchCurrInfo(l_report_id, l_exch_rate, l_reimb_precision)) THEN

624: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetReportInfo(l_report_id,l_exp_info_rec)) THEN
625: return false;
626: END IF;
627:
628: IF (NOT AP_WEB_DB_EXPRPT_PKG.GetExpReportExchCurrInfo(l_report_id, l_exch_rate, l_reimb_precision)) THEN
629: return false;
630: END IF;
631:
632: -----------------------------------------------------

Line 1026: IF (NOT AP_WEB_DB_EXPRPT_PKG.getPaymentDueFromReport(l_report_header_id,l_payment)) THEN

1022: if (AP_WEB_DB_EXPLINE_PKG.GetNoOfBothPayPersonalLines(l_report_header_id,l_num_personal_lines)) then null; end if;
1023: ----------------------------------------------------------------
1024: l_debug_info := 'Retrieve Profile Option Payment Due From';
1025: ----------------------------------------------------------------
1026: IF (NOT AP_WEB_DB_EXPRPT_PKG.getPaymentDueFromReport(l_report_header_id,l_payment)) THEN
1027: l_debug_info := 'Could not set workflow attribute Payment_Due_From';
1028: END IF;
1029:
1030: IF (l_payment = 'BOTH' and l_num_personal_lines > 0 ) THEN