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_RECEIPTS_WF dependencies on AP_EXPENSE_REPORT_HEADERS

Line 114: l_report_submitted_date AP_EXPENSE_REPORT_HEADERS.report_submitted_date%type;

110: l_debug_info VARCHAR2(200);
111:
112: l_org_id number;
113: l_expense_report_id number;
114: l_report_submitted_date AP_EXPENSE_REPORT_HEADERS.report_submitted_date%type;
115:
116: l_is_notif_rule_setup VARCHAR2(1);
117:
118: BEGIN

Line 145: from ap_expense_report_headers_all

141: l_debug_info := 'Get Expense Report data';
142: ----------------------------------------------------------
143: select report_submitted_date
144: into l_report_submitted_date
145: from ap_expense_report_headers_all
146: where report_header_id = l_expense_report_id;
147:
148: ------------------------------------------------------------
149: l_debug_info := 'Check if Notif Rules Setup';

Line 364: update ap_expense_report_headers_all

360: ----------------------------------------------------------
361: l_debug_info := 'Update Receipts Status if not Received or Waived';
362: ----------------------------------------------------------
363: begin
364: update ap_expense_report_headers_all
365: set receipts_status = ''
366: where report_header_id = p_expense_report_id
367: and nvl(receipts_status, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED) not in (AP_WEB_RECEIPTS_WF.C_RECEIVED, AP_WEB_RECEIPTS_WF.C_RECEIVED_RESUBMITTED, AP_WEB_RECEIPTS_WF.C_WAIVED, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED)
368: and receipts_received_date is null;

Line 370: update ap_expense_report_headers_all

366: where report_header_id = p_expense_report_id
367: and nvl(receipts_status, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED) not in (AP_WEB_RECEIPTS_WF.C_RECEIVED, AP_WEB_RECEIPTS_WF.C_RECEIVED_RESUBMITTED, AP_WEB_RECEIPTS_WF.C_WAIVED, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED)
368: and receipts_received_date is null;
369:
370: update ap_expense_report_headers_all
371: set image_receipts_status = ''
372: where report_header_id = p_expense_report_id
373: and nvl(image_receipts_status, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED) not in (AP_WEB_RECEIPTS_WF.C_RECEIVED, AP_WEB_RECEIPTS_WF.C_RECEIVED_RESUBMITTED, AP_WEB_RECEIPTS_WF.C_WAIVED, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED)
374: and image_receipts_received_date is null;

Line 384: update ap_expense_report_headers_all

380: l_debug_info := 'Reset Held Reports';
381: ----------------------------------------------------------
382: -- Bug 4075804
383: begin
384: update ap_expense_report_headers_all
385: set expense_status_code = C_PENDING_HOLDS,
386: holding_report_header_id = null,
387: expense_last_status_date = sysdate
388: where holding_report_header_id = p_expense_report_id

Line 450: update ap_expense_report_headers_all

446: p_actid,
447: 'ABORT_RECEIPT_TYPE');
448: IF (NOT EventKeyExists(l_event_key)) THEN
449: IF (l_receipt_type = 'ORIGINAL') THEN
450: update ap_expense_report_headers_all
451: set receipts_status = ''
452: where report_header_id = l_report_header_id
453: and nvl(receipts_status, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED) not in (AP_WEB_RECEIPTS_WF.C_RECEIVED, AP_WEB_RECEIPTS_WF.C_RECEIVED_RESUBMITTED, AP_WEB_RECEIPTS_WF.C_WAIVED)
454: and receipts_received_date is null;

Line 456: update ap_expense_report_headers_all

452: where report_header_id = l_report_header_id
453: and nvl(receipts_status, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED) not in (AP_WEB_RECEIPTS_WF.C_RECEIVED, AP_WEB_RECEIPTS_WF.C_RECEIVED_RESUBMITTED, AP_WEB_RECEIPTS_WF.C_WAIVED)
454: and receipts_received_date is null;
455: ELSE
456: update ap_expense_report_headers_all
457: set image_receipts_status = ''
458: where report_header_id = l_report_header_id
459: and nvl(image_receipts_status, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED) not in (AP_WEB_RECEIPTS_WF.C_RECEIVED, AP_WEB_RECEIPTS_WF.C_RECEIVED_RESUBMITTED, AP_WEB_RECEIPTS_WF.C_WAIVED)
460: and image_receipts_received_date is null;

Line 464: update ap_expense_report_headers_all

460: and image_receipts_received_date is null;
461: END IF;
462:
463: begin
464: update ap_expense_report_headers_all
465: set expense_status_code = C_PENDING_HOLDS,
466: holding_report_header_id = null,
467: expense_last_status_date = sysdate
468: where holding_report_header_id = l_report_header_id

Line 517: l_invoice_num AP_EXPENSE_REPORT_HEADERS.invoice_num%type;

513: l_preparer_display_name wf_users.display_name%type;
514: l_employee_id number;
515: l_employee_name wf_users.name%type;
516: l_employee_display_name wf_users.display_name%type;
517: l_invoice_num AP_EXPENSE_REPORT_HEADERS.invoice_num%type;
518: l_cost_center AP_EXPENSE_REPORT_HEADERS.flex_concatenated%type;
519: l_total varchar2(80);
520: l_purpose AP_EXPENSE_REPORT_HEADERS.description%type;
521: l_report_submitted_date AP_EXPENSE_REPORT_HEADERS.report_submitted_date%type;

Line 518: l_cost_center AP_EXPENSE_REPORT_HEADERS.flex_concatenated%type;

514: l_employee_id number;
515: l_employee_name wf_users.name%type;
516: l_employee_display_name wf_users.display_name%type;
517: l_invoice_num AP_EXPENSE_REPORT_HEADERS.invoice_num%type;
518: l_cost_center AP_EXPENSE_REPORT_HEADERS.flex_concatenated%type;
519: l_total varchar2(80);
520: l_purpose AP_EXPENSE_REPORT_HEADERS.description%type;
521: l_report_submitted_date AP_EXPENSE_REPORT_HEADERS.report_submitted_date%type;
522: l_missing_img_just AP_EXPENSE_REPORT_HEADERS.missing_img_just%type;

Line 520: l_purpose AP_EXPENSE_REPORT_HEADERS.description%type;

516: l_employee_display_name wf_users.display_name%type;
517: l_invoice_num AP_EXPENSE_REPORT_HEADERS.invoice_num%type;
518: l_cost_center AP_EXPENSE_REPORT_HEADERS.flex_concatenated%type;
519: l_total varchar2(80);
520: l_purpose AP_EXPENSE_REPORT_HEADERS.description%type;
521: l_report_submitted_date AP_EXPENSE_REPORT_HEADERS.report_submitted_date%type;
522: l_missing_img_just AP_EXPENSE_REPORT_HEADERS.missing_img_just%type;
523:
524: l_notif_rule AP_AUD_RULE_SETS%ROWTYPE;

Line 521: l_report_submitted_date AP_EXPENSE_REPORT_HEADERS.report_submitted_date%type;

517: l_invoice_num AP_EXPENSE_REPORT_HEADERS.invoice_num%type;
518: l_cost_center AP_EXPENSE_REPORT_HEADERS.flex_concatenated%type;
519: l_total varchar2(80);
520: l_purpose AP_EXPENSE_REPORT_HEADERS.description%type;
521: l_report_submitted_date AP_EXPENSE_REPORT_HEADERS.report_submitted_date%type;
522: l_missing_img_just AP_EXPENSE_REPORT_HEADERS.missing_img_just%type;
523:
524: l_notif_rule AP_AUD_RULE_SETS%ROWTYPE;
525: l_is_notif_rule_setup varchar2(1) := 'N';

Line 522: l_missing_img_just AP_EXPENSE_REPORT_HEADERS.missing_img_just%type;

518: l_cost_center AP_EXPENSE_REPORT_HEADERS.flex_concatenated%type;
519: l_total varchar2(80);
520: l_purpose AP_EXPENSE_REPORT_HEADERS.description%type;
521: l_report_submitted_date AP_EXPENSE_REPORT_HEADERS.report_submitted_date%type;
522: l_missing_img_just AP_EXPENSE_REPORT_HEADERS.missing_img_just%type;
523:
524: l_notif_rule AP_AUD_RULE_SETS%ROWTYPE;
525: l_is_notif_rule_setup varchar2(1) := 'N';
526:

Line 570: from ap_expense_report_headers_all

566: l_total,
567: l_purpose,
568: l_report_submitted_date,
569: l_missing_img_just
570: from ap_expense_report_headers_all
571: where report_header_id = l_expense_report_id;
572:
573: ----------------------------------------------------------
574: l_debug_info := 'Get Preparer Id using Created By';

Line 1087: FROM ap_expense_report_headers_all WHERE report_header_id = l_expense_report_id;

1083: l_expense_report_id := ParseItemKey(p_item_type, p_item_key);
1084:
1085: SELECT receipts_status, image_receipts_status, expense_status_code, workflow_approved_flag
1086: INTO l_receipts_status, l_image_receipts_status, l_expense_status_code, l_workflow_flag
1087: FROM ap_expense_report_headers_all WHERE report_header_id = l_expense_report_id;
1088:
1089: IF (l_receipts_status = AP_WEB_RECEIPTS_WF.C_RECEIVED OR l_receipts_status = AP_WEB_RECEIPTS_WF.C_WAIVED OR
1090: l_receipts_status = AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED OR l_expense_status_code = 'REJECTED' OR l_expense_status_code = 'RETURNED' OR
1091: l_expense_status_code = 'WITHDRAWN') THEN

Line 1325: from ap_expense_report_headers_all

1321: l_debug_info := 'Retrieve current Receipt Status';
1322: ------------------------------------------------------------
1323: select receipts_status
1324: into l_receipts_status
1325: from ap_expense_report_headers_all
1326: where report_header_id = p_report_header_id;
1327:
1328: return l_receipts_status;
1329:

Line 1403: from ap_expense_report_headers_all

1399: l_debug_info := 'Lock current Receipt Status';
1400: ------------------------------------------------------------
1401: select receipts_status
1402: into l_orig_receipts_status
1403: from ap_expense_report_headers_all
1404: where report_header_id = p_report_header_id
1405: for update of receipts_status nowait;
1406:
1407: ------------------------------------------------------------

Line 1410: update ap_expense_report_headers_all

1406:
1407: ------------------------------------------------------------
1408: l_debug_info := 'Update current Receipt Status';
1409: ------------------------------------------------------------
1410: update ap_expense_report_headers_all
1411: set receipts_status = p_receipts_status
1412: where report_header_id = p_report_header_id;
1413:
1414: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetReceiptsStatus');

Line 1768: from ap_expense_report_headers_all aerh,

1764: l_debug_info := 'Check if Missing or Policy Shortpay';
1765: ------------------------------------------------------------
1766: select 'Y'
1767: into l_is_shortpay
1768: from ap_expense_report_headers_all aerh,
1769: wf_items wf
1770: where aerh.report_header_id = l_report_header_id
1771: and aerh.shortpay_parent_id is not null
1772: and wf.item_type = C_APEXP

Line 2059: l_received_date ap_expense_report_headers_all.receipts_received_date%type;

2055: l_created_by number;
2056: --l_preparer_id number;
2057:
2058: l_org_id ap_expense_params_all.org_id%type;
2059: l_received_date ap_expense_report_headers_all.receipts_received_date%type;
2060: BEGIN
2061:
2062: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start StoreNote');
2063:

Line 2134: from ap_expense_report_headers_all

2130: -- bug 6361555
2131: begin
2132: select created_by
2133: into l_created_by
2134: from ap_expense_report_headers_all
2135: where report_header_id = l_report_header_id;
2136: exception
2137: when others then
2138: null;

Line 2276: FROM ap_expense_report_headers_all WHERE report_header_id = l_report_header_id;

2272: elsif (l_fnd_message = 'APWRECPT_RECEIVED_SENT') THEN
2273: BEGIN
2274: FND_MESSAGE.SET_NAME('SQLAP', l_fnd_message);
2275: SELECT trunc(receipts_received_date) INTO l_received_date
2276: FROM ap_expense_report_headers_all WHERE report_header_id = l_report_header_id;
2277: FND_MESSAGE.SET_TOKEN('RECEIVED_DATE', to_char(l_received_date));
2278: EXCEPTION
2279: WHEN OTHERS THEN
2280: NULL;

Line 2286: FROM ap_expense_report_headers_all WHERE report_header_id = l_report_header_id;

2282: elsif (l_fnd_message = 'APWRECPT_IMG_RECEIVED_SENT') THEN
2283: BEGIN
2284: FND_MESSAGE.SET_NAME('SQLAP', l_fnd_message);
2285: SELECT trunc(image_receipts_received_date) INTO l_received_date
2286: FROM ap_expense_report_headers_all WHERE report_header_id = l_report_header_id;
2287: FND_MESSAGE.SET_TOKEN('RECEIVED_DATE', to_char(l_received_date));
2288: EXCEPTION
2289: WHEN OTHERS THEN
2290: NULL;

Line 2451: UPDATE AP_EXPENSE_REPORT_HEADERS_ALL

2447:
2448: end if;
2449:
2450: -- Supervisor Notifications
2451: UPDATE AP_EXPENSE_REPORT_HEADERS_ALL
2452: SET OVERDUE_REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID
2453: WHERE REPORT_HEADER_ID = p_expense_report_id;
2454:
2455: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseOverdueEvent');

Line 2551: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;

2547: ----------------------------------------------------------------------
2548:
2549: l_debug_info VARCHAR2(200);
2550:
2551: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
2552: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
2553: l_orig_receipts_status ap_expense_report_headers.receipts_status%TYPE;
2554: l_report_submit_date ap_expense_report_headers.report_submitted_date%TYPE;
2555: l_rule_overdue_days AP_AUD_RULE_SETS.NOTIFY_RCT_OVERDUE_DAYS%TYPE;

Line 2552: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;

2548:
2549: l_debug_info VARCHAR2(200);
2550:
2551: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
2552: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
2553: l_orig_receipts_status ap_expense_report_headers.receipts_status%TYPE;
2554: l_report_submit_date ap_expense_report_headers.report_submitted_date%TYPE;
2555: l_rule_overdue_days AP_AUD_RULE_SETS.NOTIFY_RCT_OVERDUE_DAYS%TYPE;
2556: l_image_rule_overdue_days AP_AUD_RULE_SETS.NOTIFY_IMG_RCT_OVERDUE_DAYS%TYPE;

Line 2553: l_orig_receipts_status ap_expense_report_headers.receipts_status%TYPE;

2549: l_debug_info VARCHAR2(200);
2550:
2551: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
2552: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
2553: l_orig_receipts_status ap_expense_report_headers.receipts_status%TYPE;
2554: l_report_submit_date ap_expense_report_headers.report_submitted_date%TYPE;
2555: l_rule_overdue_days AP_AUD_RULE_SETS.NOTIFY_RCT_OVERDUE_DAYS%TYPE;
2556: l_image_rule_overdue_days AP_AUD_RULE_SETS.NOTIFY_IMG_RCT_OVERDUE_DAYS%TYPE;
2557:

Line 2554: l_report_submit_date ap_expense_report_headers.report_submitted_date%TYPE;

2550:
2551: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
2552: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
2553: l_orig_receipts_status ap_expense_report_headers.receipts_status%TYPE;
2554: l_report_submit_date ap_expense_report_headers.report_submitted_date%TYPE;
2555: l_rule_overdue_days AP_AUD_RULE_SETS.NOTIFY_RCT_OVERDUE_DAYS%TYPE;
2556: l_image_rule_overdue_days AP_AUD_RULE_SETS.NOTIFY_IMG_RCT_OVERDUE_DAYS%TYPE;
2557:
2558: l_employee_id ap_expense_report_headers.employee_id%TYPE;

Line 2558: l_employee_id ap_expense_report_headers.employee_id%TYPE;

2554: l_report_submit_date ap_expense_report_headers.report_submitted_date%TYPE;
2555: l_rule_overdue_days AP_AUD_RULE_SETS.NOTIFY_RCT_OVERDUE_DAYS%TYPE;
2556: l_image_rule_overdue_days AP_AUD_RULE_SETS.NOTIFY_IMG_RCT_OVERDUE_DAYS%TYPE;
2557:
2558: l_employee_id ap_expense_report_headers.employee_id%TYPE;
2559: l_business_group_id hr_organization_units.business_group_id%TYPE;
2560: l_duration AP_AUD_RULE_SETS.audit_term_duration_days%TYPE;
2561: l_emp_rec AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type;
2562: l_audit_rec AP_WEB_AUDIT_LIST_PUB.Audit_Rec_Type;

Line 2569: l_image_receipt_status ap_expense_report_headers.receipts_status%TYPE;

2565: l_x_msg_count NUMBER;
2566: l_x_msg_data VARCHAR2(2000);
2567: l_event_raised VARCHAR2(1) := 'N';
2568: l_receipt_type VARCHAR2(10);
2569: l_image_receipt_status ap_expense_report_headers.receipts_status%TYPE;
2570: l_original_overdue BOOLEAN := FALSE;
2571: l_image_overdue BOOLEAN := FALSE;
2572: l_original_missing BOOLEAN := FALSE;
2573: l_image_missing BOOLEAN := FALSE;

Line 2576: l_supervisor_id ap_expense_report_headers.employee_id%TYPE;

2572: l_original_missing BOOLEAN := FALSE;
2573: l_image_missing BOOLEAN := FALSE;
2574: l_item_key VARCHAR2(100) := to_char(FND_GLOBAL.CONC_REQUEST_ID);
2575: l_item_type VARCHAR2(10) := C_APWRECPT;
2576: l_supervisor_id ap_expense_report_headers.employee_id%TYPE;
2577: l_temp_emp_id ap_expense_report_headers.employee_id%TYPE;
2578: l_supName wf_users.name%type;
2579: l_supDisplayName wf_users.display_name%type;
2580:

Line 2577: l_temp_emp_id ap_expense_report_headers.employee_id%TYPE;

2573: l_image_missing BOOLEAN := FALSE;
2574: l_item_key VARCHAR2(100) := to_char(FND_GLOBAL.CONC_REQUEST_ID);
2575: l_item_type VARCHAR2(10) := C_APWRECPT;
2576: l_supervisor_id ap_expense_report_headers.employee_id%TYPE;
2577: l_temp_emp_id ap_expense_report_headers.employee_id%TYPE;
2578: l_supName wf_users.name%type;
2579: l_supDisplayName wf_users.display_name%type;
2580:
2581:

Line 2600: from AP_EXPENSE_REPORT_HEADERS aerh,

2596: aerh.image_receipts_status,
2597: aerh.report_submitted_date,
2598: rs.NOTIFY_RCT_OVERDUE_DAYS,
2599: rs.NOTIFY_IMG_RCT_OVERDUE_DAYS
2600: from AP_EXPENSE_REPORT_HEADERS aerh,
2601: AP_AUD_RULE_SETS rs,
2602: AP_AUD_RULE_ASSIGNMENTS rsa
2603: where (aerh.receipts_status in (C_REQUIRED, C_MISSING)
2604: OR decode(aerh.image_receipts_status, 'PENDING_IMAGE_SUBMISSION', C_REQUIRED, aerh.image_receipts_status) in (C_REQUIRED, C_MISSING))

Line 2664: from AP_EXPENSE_REPORT_HEADERS aerh,

2660: /*
2661: select aerh.report_header_id,
2662: aerh.receipts_status,
2663: 'ORIGINAL'
2664: from AP_EXPENSE_REPORT_HEADERS aerh,
2665: AP_AUD_RULE_SETS rs,
2666: AP_AUD_RULE_ASSIGNMENTS rsa
2667: where aerh.receipts_status in (C_REQUIRED, C_MISSING)
2668: and aerh.bothpay_parent_id is null

Line 2692: from AP_EXPENSE_REPORT_HEADERS aerh,

2688:
2689: select aerh.report_header_id,
2690: aerh.image_receipts_status,
2691: 'IMAGE'
2692: from AP_EXPENSE_REPORT_HEADERS aerh,
2693: AP_AUD_RULE_SETS rs,
2694: AP_AUD_RULE_ASSIGNMENTS rsa
2695: where aerh.image_receipts_status in (C_REQUIRED, C_MISSING)
2696: and aerh.bothpay_parent_id is null

Line 2726: from AP_EXPENSE_REPORT_HEADERS aerh,

2722: CURSOR c_audit_list_receipts IS
2723: select aerh.employee_id,
2724: hr.business_group_id,
2725: max(rs.audit_term_duration_days)
2726: from AP_EXPENSE_REPORT_HEADERS aerh,
2727: hr_organization_units hr,
2728: AP_AUD_RULE_SETS rs,
2729: AP_AUD_RULE_ASSIGNMENTS rsa
2730: where aerh.org_id = nvl(p_org_id, aerh.org_id)

Line 2752: from ap_expense_report_headers_all

2748: SELECT DISTINCT supervisor_id FROM
2749: (SELECT emp.supervisor_id
2750: FROM per_employees_x emp
2751: WHERE emp.employee_id in (select distinct employee_id
2752: from ap_expense_report_headers_all
2753: where overdue_request_id = FND_GLOBAL.CONC_REQUEST_ID)
2754: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'
2755: UNION ALL
2756: SELECT emp.supervisor_id

Line 2759: from ap_expense_report_headers_all

2755: UNION ALL
2756: SELECT emp.supervisor_id
2757: FROM per_cont_workers_current_x emp
2758: WHERE emp.person_id in (select distinct employee_id
2759: from ap_expense_report_headers_all
2760: where overdue_request_id = FND_GLOBAL.CONC_REQUEST_ID)
2761: );
2762:
2763:

Line 3030: from ap_expense_report_headers_all where report_header_id = l_expense_report_id;

3026: Wf_Core.Raise('InvalidExpenseReportId');
3027: end if;
3028:
3029: select nvl(receipts_status,'N'), nvl(image_receipts_status,'N') into l_receipts_status, l_image_receipts_status
3030: from ap_expense_report_headers_all where report_header_id = l_expense_report_id;
3031:
3032: IF (l_receipts_status = 'RECEIVED') THEN
3033: l_receipts_status := 'Y';
3034: ELSE

Line 3106: from ap_expense_report_headers_all

3102: l_debug_info := 'Retrieve current Receipt Status';
3103: ------------------------------------------------------------
3104: select image_receipts_status
3105: into l_receipts_status
3106: from ap_expense_report_headers_all
3107: where report_header_id = p_report_header_id;
3108:
3109: return l_receipts_status;
3110:

Line 3139: from ap_expense_report_headers_all

3135: l_debug_info := 'Lock current Receipt Status';
3136: ------------------------------------------------------------
3137: select image_receipts_status
3138: into l_image_receipts_status
3139: from ap_expense_report_headers_all
3140: where report_header_id = p_report_header_id
3141: for update of receipts_status nowait;
3142:
3143: ------------------------------------------------------------

Line 3146: update ap_expense_report_headers_all

3142:
3143: ------------------------------------------------------------
3144: l_debug_info := 'Update current Receipt Status';
3145: ------------------------------------------------------------
3146: update ap_expense_report_headers_all
3147: set image_receipts_status = p_receipts_status
3148: where report_header_id = p_report_header_id;
3149:
3150: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetImageReceiptsStatus');

Line 3518: from ap_expense_report_headers_all

3514: IF (l_receipt_rule.rule_set_id is null OR nvl(l_receipt_rule.allow_recpt_decl,'N') = 'N') THEN
3515: p_result := 'COMPLETE:Y';
3516: ELSE
3517: select nvl(workflow_approved_flag, 1) into l_wf_appr_flag
3518: from ap_expense_report_headers_all
3519: where report_header_id = l_expense_report_id;
3520:
3521: IF (l_wf_appr_flag IN ('A','P','Y')) THEN
3522: p_result := 'COMPLETE:Y';

Line 3524: update ap_expense_report_headers_all set

3520:
3521: IF (l_wf_appr_flag IN ('A','P','Y')) THEN
3522: p_result := 'COMPLETE:Y';
3523: ELSE
3524: update ap_expense_report_headers_all set
3525: expense_status_code = 'RETURNED',
3526: report_submitted_date = null,last_update_date = sysdate
3527: where report_header_id = l_expense_report_id;
3528:

Line 3612: FROM ap_expense_report_headers_all

3608: end if;
3609:
3610: SELECT nvl(receipts_status, 'NOT_REQUIRED'), nvl(image_receipts_status, 'NOT_REQUIRED')
3611: INTO l_receipts_status, l_image_receipts_status
3612: FROM ap_expense_report_headers_all
3613: WHERE report_header_id = l_expense_report_id;
3614:
3615: IF (l_image_receipts_status <> 'NOT_REQUIRED' AND l_receipts_status = 'NOT_REQUIRED') THEN
3616: SetReceiptsStatus(l_expense_report_id, 'REQUIRED');

Line 3669: FROM ap_expense_report_headers_all WHERE report_header_id = l_expense_report_id;

3665: p_result := 'COMPLETE:'||l_result;
3666:
3667: /*l_expense_report_id := ParseItemKey(p_item_type, p_item_key);
3668: SELECT receipts_status, image_receipts_status INTO l_receipts_status, l_image_receipts_status
3669: FROM ap_expense_report_headers_all WHERE report_header_id = l_expense_report_id;
3670:
3671: IF (l_receipts_status = 'RECEIVED' AND l_image_receipts_status = 'RECEIVED') THEN
3672: p_result := 'COMPLETE:BOTH';
3673: ELSIF(l_receipts_status = 'RECEIVED') THEN

Line 3832: FROM ap_expense_report_headers_all

3828: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
3829: p_item_key,
3830: 'EXPENSE_REPORT_ID');
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';