eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_EXPENSE_WF dependencies on AP_EXPENSE_REPORT_HEADERS

Line 292: from ap_expense_report_headers_all

288:
289: -- Fix 2178792 : Added the below select
290: select nvl(AMT_DUE_CCARD_COMPANY,0)+nvl(AMT_DUE_EMPLOYEE,0)+nvl(MAXIMUM_AMOUNT_TO_APPLY,0)
291: into l_total
292: from ap_expense_report_headers_all
293: where report_header_id = p_report_header_id;
294:
295: l_total_dsp := to_char(l_total,
296: FND_CURRENCY.Get_Format_Mask(p_reimb_curr,22));

Line 369: FROM ap_expense_report_headers_all

365: -- FND_PROFILE.GET('ORG_ID' , l_n_org_id );
366:
367: SELECT org_id
368: INTO l_n_org_id
369: FROM ap_expense_report_headers_all
370: WHERE report_header_id = l_item_key;
371:
372:
373: -- ORG_ID was added later; therefore, it needs to be tested for upgrade purpose, and

Line 898: UPDATE ap_expense_report_headers erh

894:
895: -- Bug 3248874 : Also set expense_status_code as NULL.
896: -- Source as NonValidateWebExpense.
897:
898: UPDATE ap_expense_report_headers erh
899: SET workflow_approved_flag = 'S',
900: expense_status_code = null,
901: source = 'NonValidatedWebExpense'
902: WHERE report_header_id = p_report_header_id;

Line 1798: PROCEDURE HandleInvalidDistCCID(p_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,

1794: END AddToHeaderErrors;
1795:
1796:
1797: ----------------------------------------------------------------------
1798: PROCEDURE HandleInvalidDistCCID(p_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
1799: p_report_distribution_id IN AP_WEB_DB_EXPDIST_PKG.expDist_REPORT_DISTRIBUTION_ID,
1800: p_payment_due IN VARCHAR2,
1801: p_exp_type_parameter_id IN AP_WEB_DB_EXPLINE_PKG.expLines_webParamID,
1802: p_personalParameterId IN AP_WEB_DB_EXPLINE_PKG.expLines_webParamID,

Line 1868: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE) IS

1864:
1865: ----------------------------------------------------------------------
1866: PROCEDURE DoAPValidation(p_item_type IN VARCHAR2,
1867: p_item_key IN VARCHAR2,
1868: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE) IS
1869: ----------------------------------------------------------------------
1870: l_sys_apply_advances_default AP_WEB_DB_AP_INT_PKG.apSetUp_applyAdvDefault;
1871: l_sys_allow_awt_flag AP_WEB_DB_AP_INT_PKG.apSetUp_allowAwtFlag;
1872: l_sys_default_xrate_type AP_WEB_DB_AP_INT_PKG.apSetUp_defaultExchRateType;

Line 2017: UPDATE ap_expense_report_headers erh

2013:
2014: ---------------------------------------------------
2015: l_debug_info := 'Clear out potentially rejected/returned status';
2016: ---------------------------------------------------
2017: UPDATE ap_expense_report_headers erh
2018: SET workflow_approved_flag = '',
2019: source = 'NonValidatedWebExpense'
2020: WHERE report_header_id = p_report_header_id;
2021:

Line 2619: l_debug_info := 'Update ap_expense_report_headers';

2615:
2616: END IF; /* GetVendorAWTSetupForExpRpt */
2617:
2618: ---------------------------------------------------
2619: l_debug_info := 'Update ap_expense_report_headers';
2620: ---------------------------------------------------
2621: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetExpenseHeaderInfo(p_report_header_id,
2622: l_exp_check_address_flag,
2623: 'WebExpense',

Line 2868: update ap_expense_report_headers

2864:
2865: ----------------------------------------------------------
2866: l_debug_info := 'Update Receipts Status to Missing if Pending Resolution';
2867: ----------------------------------------------------------
2868: update ap_expense_report_headers
2869: set receipts_status = 'MISSING'
2870: where report_header_id = l_report_header_id
2871: and receipts_status = 'RESOLUTN';
2872:

Line 3287: FROM ap_expense_report_headers

3283: l_debug_info := 'Retrieve The AP Reviewed Flag';
3284: -------------------------------------------------
3285: SELECT nvl(workflow_approved_flag, 'N')
3286: INTO l_ap_review_status
3287: FROM ap_expense_report_headers
3288: WHERE report_header_id = l_report_header_id;
3289:
3290: ------------------------------------------------------------------
3291: l_debug_info := 'Check flag to determine if AP Review Complete and

Line 3410: UPDATE ap_expense_report_headers_all

3406: IF (C_WF_Version < AP_WEB_EXPENSE_WF.C_OIEH_Version) THEN
3407: -------------------------------------------------------------------
3408: l_debug_info := 'Set Expense Status Code';
3409: -------------------------------------------------------------------
3410: UPDATE ap_expense_report_headers_all
3411: SET expense_status_code = 'MGRAPPR'
3412: WHERE report_header_id = l_report_header_id;
3413: END IF;
3414:

Line 3497: l_reimb_currency ap_expense_report_headers_all.payment_currency_code%type;

3493: l_policy_shortpay_total NUMBER := 0;
3494: /* jrautiai ADJ Fix End */
3495:
3496: l_ExpRec AP_WEB_DB_EXPRPT_PKG.ExpInfoRec;
3497: l_reimb_currency ap_expense_report_headers_all.payment_currency_code%type;
3498: BEGIN
3499:
3500: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start AnyAPAdjustments');
3501:

Line 3962: UPDATE ap_expense_report_headers_all

3958: IF (C_WF_Version < AP_WEB_EXPENSE_WF.C_OIEH_Version) THEN
3959: -------------------------------------------------------------------
3960: l_debug_info := 'Set Expense Status Code';
3961: -------------------------------------------------------------------
3962: UPDATE ap_expense_report_headers_all
3963: SET expense_status_code = 'INVOICED',
3964: last_update_date = SYSDATE
3965: --last_updated_by = Decode(Nvl(fnd_global.user_id,-1),-1,last_updated_by,fnd_global.user_id)
3966: WHERE report_header_id = l_report_header_id;

Line 4341: l_receipts_status AP_EXPENSE_REPORT_HEADERS.receipts_status%TYPE;

4337: ------------------------------------------------------------------------------
4338: IS
4339: l_debug_info VARCHAR2(2000);
4340: l_ExpenseRec AP_WEB_DB_EXPRPT_PKG.XpenseInfoRec;
4341: l_receipts_status AP_EXPENSE_REPORT_HEADERS.receipts_status%TYPE;
4342: l_received_date AP_EXPENSE_REPORT_HEADERS.receipts_received_date%TYPE;
4343: l_img_receipts_status AP_EXPENSE_REPORT_HEADERS.image_receipts_status%TYPE;
4344: l_img_received_date AP_EXPENSE_REPORT_HEADERS.image_receipts_received_date%TYPE;
4345:

Line 4342: l_received_date AP_EXPENSE_REPORT_HEADERS.receipts_received_date%TYPE;

4338: IS
4339: l_debug_info VARCHAR2(2000);
4340: l_ExpenseRec AP_WEB_DB_EXPRPT_PKG.XpenseInfoRec;
4341: l_receipts_status AP_EXPENSE_REPORT_HEADERS.receipts_status%TYPE;
4342: l_received_date AP_EXPENSE_REPORT_HEADERS.receipts_received_date%TYPE;
4343: l_img_receipts_status AP_EXPENSE_REPORT_HEADERS.image_receipts_status%TYPE;
4344: l_img_received_date AP_EXPENSE_REPORT_HEADERS.image_receipts_received_date%TYPE;
4345:
4346: BEGIN

Line 4343: l_img_receipts_status AP_EXPENSE_REPORT_HEADERS.image_receipts_status%TYPE;

4339: l_debug_info VARCHAR2(2000);
4340: l_ExpenseRec AP_WEB_DB_EXPRPT_PKG.XpenseInfoRec;
4341: l_receipts_status AP_EXPENSE_REPORT_HEADERS.receipts_status%TYPE;
4342: l_received_date AP_EXPENSE_REPORT_HEADERS.receipts_received_date%TYPE;
4343: l_img_receipts_status AP_EXPENSE_REPORT_HEADERS.image_receipts_status%TYPE;
4344: l_img_received_date AP_EXPENSE_REPORT_HEADERS.image_receipts_received_date%TYPE;
4345:
4346: BEGIN
4347:

Line 4344: l_img_received_date AP_EXPENSE_REPORT_HEADERS.image_receipts_received_date%TYPE;

4340: l_ExpenseRec AP_WEB_DB_EXPRPT_PKG.XpenseInfoRec;
4341: l_receipts_status AP_EXPENSE_REPORT_HEADERS.receipts_status%TYPE;
4342: l_received_date AP_EXPENSE_REPORT_HEADERS.receipts_received_date%TYPE;
4343: l_img_receipts_status AP_EXPENSE_REPORT_HEADERS.image_receipts_status%TYPE;
4344: l_img_received_date AP_EXPENSE_REPORT_HEADERS.image_receipts_received_date%TYPE;
4345:
4346: BEGIN
4347:
4348: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start CreateShortPayExpReport');

Line 4352: ap_expense_report_headers, with same info as old

4348: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start CreateShortPayExpReport');
4349:
4350: -------------------------------------------------------------------
4351: l_debug_info := 'Create new expense report by creating new record in
4352: ap_expense_report_headers, with same info as old
4353: expense report except new id, number and total';
4354: --------------------------------------------------------------------
4355: l_ExpenseRec.report_header_id := p_new_expense_report_id;
4356: l_ExpenseRec.employee_id := NULL;

Line 4387: FROM ap_expense_report_headers WHERE report_header_id = p_orig_expense_report_id;

4383: l_ExpenseRec.image_receipts_received_date := NULL;
4384:
4385: SELECT receipts_status, receipts_received_date, image_receipts_status, image_receipts_received_date
4386: INTO l_receipts_status, l_received_date, l_img_receipts_status, l_img_received_date
4387: FROM ap_expense_report_headers WHERE report_header_id = p_orig_expense_report_id;
4388:
4389: IF (p_shortpay_type = 'NO_RECEIPTS') THEN
4390: l_ExpenseRec.receipts_status := NULL;
4391: l_ExpenseRec.receipts_received_date := NULL;

Line 5978: update ap_expense_report_headers

5974:
5975: ----------------------------------------------------------
5976: l_debug_info := 'Update Receipts Status to Required if Pending Resolution';
5977: ----------------------------------------------------------
5978: update ap_expense_report_headers
5979: set receipts_status = 'IN_TRANSIT'
5980: where report_header_id = l_report_header_id
5981: and receipts_status = 'RESOLUTN';
5982:

Line 5983: update ap_expense_report_headers

5979: set receipts_status = 'IN_TRANSIT'
5980: where report_header_id = l_report_header_id
5981: and receipts_status = 'RESOLUTN';
5982:
5983: update ap_expense_report_headers
5984: set image_receipts_status = 'IN_TRANSIT'
5985: where report_header_id = l_report_header_id
5986: and image_receipts_status = 'RESOLUTN';
5987:

Line 6225: ap_expense_report_headers, with same info as old

6221: IF (l_total - l_ccard_amt <> 0) THEN
6222: */
6223: -------------------------------------------------------------------
6224: l_debug_info := 'Create new expense report by creating new record in
6225: ap_expense_report_headers, with same info as old
6226: expense report except new id, doc number, total,
6227: bothpay parent id, paid on behalf employee id, description,
6228: and amt due ccard company';
6229: --------------------------------------------------------------------

Line 6260: from ap_expense_report_headers

6256: l_debug_info := 'Get Expense Report date';
6257: ----------------------------------------------------------
6258: select report_submitted_date
6259: into l_report_submitted_date
6260: from ap_expense_report_headers
6261: where report_header_id = l_report_header_id;
6262:
6263: ------------------------------------------------------------
6264: l_debug_info := 'Retrieve ORG_ID Item Attribute';

Line 8150: UPDATE ap_expense_report_headers_all

8146: /* Bug 3566496: Need to update expense_current_approver_id since that
8147: * is used to display the approver in the Track expenses page.
8148: */
8149:
8150: UPDATE ap_expense_report_headers_all
8151: SET expense_current_approver_id = p_manager_id,
8152: approval_type = 'PER'
8153: WHERE report_header_id = l_report_header_id;
8154:

Line 10976: UPDATE ap_expense_report_headers

10972: -----------------------------------------------------
10973: l_debug_info := 'Update Headers table with Person Id';
10974: -----------------------------------------------------
10975:
10976: UPDATE ap_expense_report_headers
10977: SET expense_current_approver_id = l_approver_person_id
10978: WHERE report_header_id = p_item_key;
10979:
10980: END IF;

Line 11514: from ap_expense_report_headers

11510: l_debug_info := 'Get Expense Report data';
11511: ----------------------------------------------------------
11512: select report_submitted_date
11513: into l_report_submitted_date
11514: from ap_expense_report_headers
11515: where report_header_id = l_report_header_id;
11516:
11517: SELECT employee_id
11518: INTO l_employee_id

Line 11519: FROM ap_expense_report_headers_all

11515: where report_header_id = l_report_header_id;
11516:
11517: SELECT employee_id
11518: INTO l_employee_id
11519: FROM ap_expense_report_headers_all
11520: WHERE report_header_id = l_report_header_id;
11521:
11522: IF (l_expense_status_code = 'INVOICED') THEN
11523:

Line 11544: UPDATE ap_expense_report_headers_all

11540: -- replaced p_item_key with the l_report_header_id
11541: -------------------------------------------------------------------
11542: l_debug_info := 'Set Expense Status Code and Current Approver ID';
11543: -------------------------------------------------------------------
11544: UPDATE ap_expense_report_headers_all
11545: SET expense_status_code = l_expense_status_code,
11546: expense_current_approver_id = l_current_approver_id,
11547: expense_last_status_date=sysdate,
11548: source = nvl(l_source, source),

Line 11808: update ap_expense_report_headers

11804: l_debug_info := 'Reset Report Submitted Date to null And Expense Status Code to WITHDRAWN';
11805: ----------------------------------------------------------
11806: -- Bug 4070441
11807: begin
11808: update ap_expense_report_headers
11809: set report_submitted_date = null,
11810: last_update_date = sysdate, -- Bug 8411814 (sodash) added to update the who columns when a report is withdrawn
11811: expense_last_status_date = sysdate,
11812: expense_status_code = AP_WEB_OA_ACTIVE_PKG.C_WITHDRAWN

Line 13114: AP_EXPENSE_REPORT_HEADERS XH,

13110: l_web_parameter_id,
13111: l_policy_id,
13112: l_currency_preference
13113: FROM ap_expense_report_lines XL,
13114: AP_EXPENSE_REPORT_HEADERS XH,
13115: AP_EXPENSE_REPORT_PARAMS XP,
13116: AP_POL_HEADERS SH
13117: WHERE XH.report_header_id = p_report_header_id
13118: AND XH.report_header_id = XL.report_header_id

Line 14180: l_debug_info := 'update display_total item attribute if ap_expense_report_headers has been updated';

14176:
14177: AP_WEB_DB_EXPLINE_PKG.updateExpenseMileageLines(l_mileage_line_array, l_bHeaderUpdated);
14178:
14179: -----------------------------------------------------------------------
14180: l_debug_info := 'update display_total item attribute if ap_expense_report_headers has been updated';
14181: -----------------------------------------------------------------------
14182: IF (l_bHeaderUpdated = TRUE) THEN
14183: IF (NOT AP_WEB_DB_EXPRPT_PKG.UpdateHeaderTotal(l_report_header_id)) THEN
14184: NULL;

Line 14391: from ap_expense_report_headers

14387: -------------------------------------------------------------------------------
14388:
14389: CURSOR audit_cur(p_report_header_id IN NUMBER) IS
14390: select audit_code
14391: from ap_expense_report_headers
14392: where report_header_id = p_report_header_id;
14393:
14394: CURSOR rule_cur(p_report_header_id IN NUMBER) IS
14395: select rs.assign_auditor_stage_code, rs.audit_all,

Line 14400: from ap_expense_report_headers aerh,

14396: rs.paperless_audit_cc_only_flag,
14397: rs.paperless_audit_violation_flag,
14398: rs.paperless_audit_pdm_only_flag,
14399: aerh.workflow_approved_flag
14400: from ap_expense_report_headers aerh,
14401: ap_aud_rule_sets rs,
14402: ap_aud_rule_assignments_all rsa
14403: where aerh.report_header_id = p_report_header_id
14404: and aerh.org_id = rsa.org_id

Line 14415: from ap_expense_report_headers aerh,

14411: CURSOR recpt_cur(p_report_header_id IN NUMBER) IS
14412: select rs.recpt_assign_stage_code,
14413: rs.AUD_IMG_RECEIPT_REQUIRED,
14414: rs.AUD_PAPER_RECEIPT_REQUIRED
14415: from ap_expense_report_headers aerh,
14416: ap_aud_rule_sets rs,
14417: ap_aud_rule_assignments_all rsa
14418: where aerh.report_header_id = p_report_header_id
14419: and aerh.org_id = rsa.org_id

Line 14501: ap_expense_report_headers_all where report_header_id = l_report_header_id;

14497:
14498:
14499: select nvl(image_receipts_status,'NOT_REQUIRED') ,
14500: nvl(receipts_status, 'NOT_REQUIRED') into l_image_receipts_status, l_receipts_status from
14501: ap_expense_report_headers_all where report_header_id = l_report_header_id;
14502:
14503: IF ((NVL(recpt_rec.AUD_IMG_RECEIPT_REQUIRED, 'N') = 'Y' AND l_image_receipts_status = 'RECEIVED')
14504: OR (NVL(recpt_rec.AUD_PAPER_RECEIPT_REQUIRED, 'N') = 'Y' AND l_receipts_status = 'RECEIVED')) THEN
14505: IF (l_auditor_id IS NULL) THEN

Line 14526: ap_expense_report_headers_all where report_header_id = l_report_header_id;

14522: IF recpt_rec.recpt_assign_stage_code = 'MGR_APPR_IMG' THEN
14523:
14524: select nvl(image_receipts_status,'NOT_REQUIRED') ,
14525: nvl(receipts_status, 'NOT_REQUIRED') into l_image_receipts_status, l_receipts_status from
14526: ap_expense_report_headers_all where report_header_id = l_report_header_id;
14527:
14528: IF ((NVL(recpt_rec.AUD_IMG_RECEIPT_REQUIRED, 'N') = 'Y' AND l_image_receipts_status = 'RECEIVED')
14529: OR (NVL(recpt_rec.AUD_PAPER_RECEIPT_REQUIRED, 'N') = 'Y' AND l_receipts_status = 'RECEIVED')) THEN
14530: IF (l_auditor_id IS NULL) THEN

Line 14548: ap_expense_report_headers_all where report_header_id = l_report_header_id;

14544: IF recpt_rec.recpt_assign_stage_code = 'MGR_APPR_IMG' THEN
14545:
14546: select nvl(image_receipts_status,'NOT_REQUIRED') ,
14547: nvl(receipts_status, 'NOT_REQUIRED') into l_image_receipts_status, l_receipts_status from
14548: ap_expense_report_headers_all where report_header_id = l_report_header_id;
14549:
14550: IF ((NVL(recpt_rec.AUD_IMG_RECEIPT_REQUIRED, 'N') = 'Y' AND l_image_receipts_status = 'RECEIVED')
14551: OR (NVL(recpt_rec.AUD_PAPER_RECEIPT_REQUIRED, 'N') = 'Y' AND l_receipts_status = 'RECEIVED')) THEN
14552: IF (l_auditor_id IS NULL) THEN

Line 14745: FROM ap_expense_report_headers_all

14741: begin
14742: SELECT user_name INTO l_auditor_name
14743: FROM fnd_user
14744: WHERE user_id=(SELECT last_audited_by
14745: FROM ap_expense_report_headers_all
14746: WHERE report_header_id=p_item_key);
14747: exception
14748: when no_data_found then
14749: l_auditor_name := WF_ENGINE.GetItemAttrText(p_item_type,

Line 15003: FROM AP_EXPENSE_REPORT_HEADERS

14999: l_debug_info := 'Retrieve Workflow_Approved_Flag';
15000: ------------------------------------------------------------
15001: SELECT WORKFLOW_APPROVED_FLAG
15002: INTO l_workflow_approved_flag
15003: FROM AP_EXPENSE_REPORT_HEADERS
15004: WHERE REPORT_HEADER_ID = l_report_header_id;
15005:
15006: IF (l_workflow_approved_flag = AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_REJECTED) THEN
15007: p_result := 'COMPLETE:REJECTED';

Line 15050: from ap_expense_report_headers

15046: l_workflow_flag VARCHAR2(5);
15047:
15048: CURSOR audit_cur(p_report_header_id IN NUMBER) IS
15049: select audit_code, workflow_approved_flag
15050: from ap_expense_report_headers
15051: where report_header_id = p_report_header_id;
15052:
15053: audit_rec audit_cur%ROWTYPE;
15054:

Line 15235: l_approval_type AP_EXPENSE_REPORT_HEADERS_ALL.APPROVAL_TYPE%TYPE;

15231: l_entered_by NUMBER := fnd_global.user_id;
15232: l_user_name fnd_user.user_name%TYPE := null;
15233: l_ame_enabled varchar2(1) := 'N';
15234:
15235: l_approval_type AP_EXPENSE_REPORT_HEADERS_ALL.APPROVAL_TYPE%TYPE;
15236: l_workflow_flag AP_EXPENSE_REPORT_HEADERS_ALL.WORKFLOW_APPROVED_FLAG%TYPE;
15237:
15238: BEGIN
15239:

Line 15236: l_workflow_flag AP_EXPENSE_REPORT_HEADERS_ALL.WORKFLOW_APPROVED_FLAG%TYPE;

15232: l_user_name fnd_user.user_name%TYPE := null;
15233: l_ame_enabled varchar2(1) := 'N';
15234:
15235: l_approval_type AP_EXPENSE_REPORT_HEADERS_ALL.APPROVAL_TYPE%TYPE;
15236: l_workflow_flag AP_EXPENSE_REPORT_HEADERS_ALL.WORKFLOW_APPROVED_FLAG%TYPE;
15237:
15238: BEGIN
15239:
15240: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start StoreNote');

Line 15305: FROM AP_EXPENSE_REPORT_HEADERS_ALL

15301: p_item_key,
15302: 'EXPENSE_REPORT_ID');
15303:
15304: SELECT approval_type, workflow_approved_flag INTO l_approval_type, l_workflow_flag
15305: FROM AP_EXPENSE_REPORT_HEADERS_ALL
15306: WHERE report_header_id = l_report_header_id;
15307: EXCEPTION
15308: WHEN OTHERS THEN
15309: l_approval_type := null;

Line 15785: UPDATE AP_EXPENSE_REPORT_HEADERS

15781: END IF;
15782:
15783: IF l_num_both_personal_lines > 0 THEN
15784:
15785: UPDATE AP_EXPENSE_REPORT_HEADERS
15786: SET EXPENSE_STATUS_CODE = 'PAID'
15787: WHERE REPORT_HEADER_ID = p_report_header_id;
15788:
15789: END IF;

Line 15812: UPDATE AP_EXPENSE_REPORT_HEADERS

15808: ----------------------------------------------------------------------------
15809:
15810: BEGIN
15811:
15812: UPDATE AP_EXPENSE_REPORT_HEADERS
15813: SET DESCRIPTION= AP_WEB_UTILITIES_PKG.RtrimMultiByteSpaces(description)
15814: WHERE REPORT_HEADER_ID = p_report_header_id;
15815:
15816: UPDATE AP_EXPENSE_REPORT_LINES

Line 15907: UPDATE ap_expense_report_headers erh

15903:
15904: -- Bug 3248874 : Also set expense_status_code as NULL.
15905: -- Source as NonValidateWebExpense.
15906:
15907: UPDATE ap_expense_report_headers erh
15908: SET workflow_approved_flag = 'S',
15909: expense_status_code = null,
15910: source = 'NonValidatedWebExpense'
15911: WHERE report_header_id = p_report_header_id;

Line 15940: l_report_header_id ap_expense_report_headers.report_header_id%type;

15936: ----------------------------------------------------------------------
15937:
15938: l_debug_info VARCHAR2(200);
15939:
15940: l_report_header_id ap_expense_report_headers.report_header_id%type;
15941: l_preparer_id ap_expense_report_headers.employee_id%type;
15942: l_employee_id ap_expense_report_headers.employee_id%type;
15943: l_document_number ap_expense_report_headers.invoice_num%type;
15944: l_total ap_expense_report_lines.amount%type;

Line 15941: l_preparer_id ap_expense_report_headers.employee_id%type;

15937:
15938: l_debug_info VARCHAR2(200);
15939:
15940: l_report_header_id ap_expense_report_headers.report_header_id%type;
15941: l_preparer_id ap_expense_report_headers.employee_id%type;
15942: l_employee_id ap_expense_report_headers.employee_id%type;
15943: l_document_number ap_expense_report_headers.invoice_num%type;
15944: l_total ap_expense_report_lines.amount%type;
15945: l_new_total ap_expense_report_lines.amount%type;

Line 15942: l_employee_id ap_expense_report_headers.employee_id%type;

15938: l_debug_info VARCHAR2(200);
15939:
15940: l_report_header_id ap_expense_report_headers.report_header_id%type;
15941: l_preparer_id ap_expense_report_headers.employee_id%type;
15942: l_employee_id ap_expense_report_headers.employee_id%type;
15943: l_document_number ap_expense_report_headers.invoice_num%type;
15944: l_total ap_expense_report_lines.amount%type;
15945: l_new_total ap_expense_report_lines.amount%type;
15946: l_reimb_curr ap_expense_report_headers.default_currency_code%type;

Line 15943: l_document_number ap_expense_report_headers.invoice_num%type;

15939:
15940: l_report_header_id ap_expense_report_headers.report_header_id%type;
15941: l_preparer_id ap_expense_report_headers.employee_id%type;
15942: l_employee_id ap_expense_report_headers.employee_id%type;
15943: l_document_number ap_expense_report_headers.invoice_num%type;
15944: l_total ap_expense_report_lines.amount%type;
15945: l_new_total ap_expense_report_lines.amount%type;
15946: l_reimb_curr ap_expense_report_headers.default_currency_code%type;
15947: l_cost_center ap_expense_report_headers.flex_concatenated%type;

Line 15946: l_reimb_curr ap_expense_report_headers.default_currency_code%type;

15942: l_employee_id ap_expense_report_headers.employee_id%type;
15943: l_document_number ap_expense_report_headers.invoice_num%type;
15944: l_total ap_expense_report_lines.amount%type;
15945: l_new_total ap_expense_report_lines.amount%type;
15946: l_reimb_curr ap_expense_report_headers.default_currency_code%type;
15947: l_cost_center ap_expense_report_headers.flex_concatenated%type;
15948: l_purpose ap_expense_report_headers.description%type;
15949: l_approver_id ap_expense_report_headers.override_approver_id%type;
15950: l_week_end_date ap_expense_report_headers.week_end_date%type;

Line 15947: l_cost_center ap_expense_report_headers.flex_concatenated%type;

15943: l_document_number ap_expense_report_headers.invoice_num%type;
15944: l_total ap_expense_report_lines.amount%type;
15945: l_new_total ap_expense_report_lines.amount%type;
15946: l_reimb_curr ap_expense_report_headers.default_currency_code%type;
15947: l_cost_center ap_expense_report_headers.flex_concatenated%type;
15948: l_purpose ap_expense_report_headers.description%type;
15949: l_approver_id ap_expense_report_headers.override_approver_id%type;
15950: l_week_end_date ap_expense_report_headers.week_end_date%type;
15951: l_workflow_flag ap_expense_report_headers.workflow_approved_flag%type;

Line 15948: l_purpose ap_expense_report_headers.description%type;

15944: l_total ap_expense_report_lines.amount%type;
15945: l_new_total ap_expense_report_lines.amount%type;
15946: l_reimb_curr ap_expense_report_headers.default_currency_code%type;
15947: l_cost_center ap_expense_report_headers.flex_concatenated%type;
15948: l_purpose ap_expense_report_headers.description%type;
15949: l_approver_id ap_expense_report_headers.override_approver_id%type;
15950: l_week_end_date ap_expense_report_headers.week_end_date%type;
15951: l_workflow_flag ap_expense_report_headers.workflow_approved_flag%type;
15952: l_submit_from_oie varchar2(1);

Line 15949: l_approver_id ap_expense_report_headers.override_approver_id%type;

15945: l_new_total ap_expense_report_lines.amount%type;
15946: l_reimb_curr ap_expense_report_headers.default_currency_code%type;
15947: l_cost_center ap_expense_report_headers.flex_concatenated%type;
15948: l_purpose ap_expense_report_headers.description%type;
15949: l_approver_id ap_expense_report_headers.override_approver_id%type;
15950: l_week_end_date ap_expense_report_headers.week_end_date%type;
15951: l_workflow_flag ap_expense_report_headers.workflow_approved_flag%type;
15952: l_submit_from_oie varchar2(1);
15953:

Line 15950: l_week_end_date ap_expense_report_headers.week_end_date%type;

15946: l_reimb_curr ap_expense_report_headers.default_currency_code%type;
15947: l_cost_center ap_expense_report_headers.flex_concatenated%type;
15948: l_purpose ap_expense_report_headers.description%type;
15949: l_approver_id ap_expense_report_headers.override_approver_id%type;
15950: l_week_end_date ap_expense_report_headers.week_end_date%type;
15951: l_workflow_flag ap_expense_report_headers.workflow_approved_flag%type;
15952: l_submit_from_oie varchar2(1);
15953:
15954: BEGIN

Line 15951: l_workflow_flag ap_expense_report_headers.workflow_approved_flag%type;

15947: l_cost_center ap_expense_report_headers.flex_concatenated%type;
15948: l_purpose ap_expense_report_headers.description%type;
15949: l_approver_id ap_expense_report_headers.override_approver_id%type;
15950: l_week_end_date ap_expense_report_headers.week_end_date%type;
15951: l_workflow_flag ap_expense_report_headers.workflow_approved_flag%type;
15952: l_submit_from_oie varchar2(1);
15953:
15954: BEGIN
15955:

Line 15980: from ap_expense_report_headers aerh,

15976: l_purpose,
15977: l_approver_id,
15978: l_week_end_date,
15979: l_workflow_flag
15980: from ap_expense_report_headers aerh,
15981: fnd_user fnd
15982: where aerh.report_header_id = l_report_header_id
15983: and fnd.user_id = aerh.created_by;
15984:

Line 17191: UPDATE ap_expense_report_headers_all

17187: approvalprocesscompleteynout => l_approvalProcessCompleteYNOut,
17188: approversout => l_approversOut);
17189:
17190: if (l_approversOut.count > 1) then
17191: UPDATE ap_expense_report_headers_all
17192: SET expense_current_approver_id = C_AME_MULTIPLE_CURR_APPROVER
17193: WHERE report_header_id = l_report_header_id;
17194: elsif (l_approversOut.count = 1) then
17195: UPDATE ap_expense_report_headers_all

Line 17195: UPDATE ap_expense_report_headers_all

17191: UPDATE ap_expense_report_headers_all
17192: SET expense_current_approver_id = C_AME_MULTIPLE_CURR_APPROVER
17193: WHERE report_header_id = l_report_header_id;
17194: elsif (l_approversOut.count = 1) then
17195: UPDATE ap_expense_report_headers_all
17196: SET expense_current_approver_id = l_approversOut(1).orig_system_id,
17197: approval_type = l_approversOut(1).orig_system
17198: WHERE report_header_id = l_report_header_id;
17199: end if;

Line 17328: from ap_expense_report_headers aerh,

17324: p_result := 'COMPLETE:N';
17325: ELSE
17326: select nvl(rs.image_req_appr_flag,'X'),
17327: nvl(aerh.image_receipts_status, 'NOT_REQUIRED') into l_req_mgr_appr,l_img_recpt_status
17328: from ap_expense_report_headers aerh,
17329: ap_aud_rule_sets rs,
17330: ap_aud_rule_assignments_all rsa
17331: where aerh.report_header_id = l_report_header_id
17332: and aerh.org_id = rsa.org_id

Line 17341: update ap_expense_report_headers_all

17337: AND TRUNC(NVL(rsa.END_DATE,SYSDATE));
17338:
17339: IF (l_req_mgr_appr = 'Y' AND l_img_recpt_status NOT IN ('RECEIVED','NOT_REQUIRED')) THEN
17340:
17341: update ap_expense_report_headers_all
17342: set expense_status_code = 'PENDING_IMAGE_SUBMISSION'
17343: where report_header_id = l_report_header_id;
17344:
17345: p_result := 'COMPLETE:Y';

Line 17389: from ap_expense_report_headers aerh,

17385: p_result := 'COMPLETE:N';
17386: ELSE
17387: select nvl(rs.req_reappr_flag,'X')
17388: into l_re_appr_flag
17389: from ap_expense_report_headers aerh,
17390: ap_aud_rule_sets rs,
17391: ap_aud_rule_assignments_all rsa
17392: where aerh.report_header_id = l_report_header_id
17393: and aerh.org_id = rsa.org_id

Line 17437: UPDATE ap_expense_report_headers

17433: p_item_key,
17434: p_actid,
17435: 'IMAGE_RECEIPTS_STATUS');
17436:
17437: UPDATE ap_expense_report_headers
17438: SET image_receipts_status = l_image_receipts_status,
17439: last_update_date = sysdate,
17440: last_updated_by = Decode(Nvl(fnd_global.user_id,-1),-1,last_updated_by,fnd_global.user_id)
17441: WHERE report_header_id = l_report_header_id;

Line 17473: UPDATE ap_expense_report_headers

17469: p_actid,
17470: 'ORIGINAL_RECEIPTS_STATUS');
17471:
17472:
17473: UPDATE ap_expense_report_headers
17474: SET receipts_status = l_orig_receipts_status,
17475: last_update_date = sysdate,
17476: last_updated_by = Decode(Nvl(fnd_global.user_id,-1),-1,last_updated_by,fnd_global.user_id)
17477: WHERE report_header_id = l_report_header_id;

Line 17509: UPDATE ap_expense_report_headers

17505: p_actid,
17506: 'EXPENSE_STATUS_CODE');
17507:
17508:
17509: UPDATE ap_expense_report_headers
17510: SET expense_status_code = l_expense_status_code,
17511: last_update_date = sysdate,
17512: last_updated_by = Decode(Nvl(fnd_global.user_id,-1),-1,last_updated_by,fnd_global.user_id)
17513: WHERE report_header_id = l_report_header_id;

Line 17585: l_missing_image_just AP_EXPENSE_REPORT_HEADERS.MISSING_IMG_JUST%TYPE;

17581:
17582: -------------------------------------------------------------------------------------
17583: FUNCTION GetImageMissingJustification(p_report_header_id IN NUMBER) RETURN VARCHAR2 IS
17584: --------------------------------------------------------------------------------------
17585: l_missing_image_just AP_EXPENSE_REPORT_HEADERS.MISSING_IMG_JUST%TYPE;
17586: BEGIN
17587:
17588: SELECT missing_img_just
17589: INTO l_missing_image_just

Line 17590: FROM ap_expense_report_headers

17586: BEGIN
17587:
17588: SELECT missing_img_just
17589: INTO l_missing_image_just
17590: FROM ap_expense_report_headers
17591: WHERE report_header_id = p_report_header_id;
17592:
17593: RETURN l_missing_image_just;
17594: EXCEPTION

Line 17603: l_report_header_id AP_EXPENSE_REPORT_HEADERS.REPORT_HEADER_ID%TYPE;

17599:
17600: -------------------------------------------------------------------------------------
17601: FUNCTION IsBothPayReportExists(p_report_header_id IN NUMBER) RETURN BOOLEAN IS
17602: -------------------------------------------------------------------------------------
17603: l_report_header_id AP_EXPENSE_REPORT_HEADERS.REPORT_HEADER_ID%TYPE;
17604: BEGIN
17605:
17606: SELECT report_header_id INTO l_report_header_id
17607: FROM ap_expense_report_headers where bothpay_parent_id = p_report_header_id;

Line 17607: FROM ap_expense_report_headers where bothpay_parent_id = p_report_header_id;

17603: l_report_header_id AP_EXPENSE_REPORT_HEADERS.REPORT_HEADER_ID%TYPE;
17604: BEGIN
17605:
17606: SELECT report_header_id INTO l_report_header_id
17607: FROM ap_expense_report_headers where bothpay_parent_id = p_report_header_id;
17608:
17609: RETURN TRUE;
17610:
17611: EXCEPTION