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

Line 17: FROM AP_EXPENSE_REPORT_HEADERS

13: IS
14: BEGIN
15: SELECT employee_id
16: INTO p_employee_id
17: FROM AP_EXPENSE_REPORT_HEADERS
18: WHERE report_header_id = p_bothpay_parent_id;
19:
20: EXCEPTION
21: WHEN OTHERS THEN

Line 38: -- o Query is driven off AP_EXPENSE_REPORT_HEADERS

34: -- Returns reports which can be modified by the web user
35: -- 3176205: hr_empcur includes all workers.
36: -- Note: Instead of PER_WORKFORCE_X, PER_PEOPLE_X is used for the
37: -- following reasons:
38: -- o Query is driven off AP_EXPENSE_REPORT_HEADERS
39: -- o Better performance using PER_PEOPLE_X
40: -- o PER_WORKFORCE_X can return more than one row for a person
41: -- o The only column selected from PER_PEOPLE_X is full_name
42: OPEN p_cursor FOR

Line 51: FROM AP_EXPENSE_REPORT_HEADERS ap_erh,

47: ap_erh.DEFAULT_CURRENCY_CODE,
48: ap_erh.DESCRIPTION,
49: ap_erh.TOTAL,
50: fndl.MEANING
51: FROM AP_EXPENSE_REPORT_HEADERS ap_erh,
52: PER_PEOPLE_X hr_empcur,
53: FND_LOOKUPS fndl
54: WHERE (ap_erh.EMPLOYEE_ID IN
55: (SELECT NUMBER_VALUE

Line 94: FROM AP_EXPENSE_REPORT_HEADERS

90: SELECT INVOICE_NUM,
91: WORKFLOW_APPROVED_FLAG
92: INTO P_WorkflowRec.doc_num,
93: P_WorkflowRec.workflow_flag
94: FROM AP_EXPENSE_REPORT_HEADERS
95: WHERE REPORT_HEADER_ID = P_ReportID;
96:
97: return TRUE;
98: EXCEPTION

Line 128: FROM ap_expense_report_headers

124: p_exp_info_rec.doc_num,
125: p_exp_info_rec.total,
126: p_exp_info_rec.payment_curr_code,
127: p_exp_info_rec.week_end_date
128: FROM ap_expense_report_headers
129: WHERE report_header_id = p_expenseReportId;
130:
131: return TRUE;
132: EXCEPTION

Line 150: FROM ap_expense_report_headers

146: -------------------------------------------------------------------
147: BEGIN
148: SELECT override_approver_id
149: INTO p_id
150: FROM ap_expense_report_headers
151: WHERE report_header_id = p_report_header_id;
152:
153: return TRUE;
154:

Line 174: FROM ap_expense_report_headers_all

170: --------------------------------------------------------------------------------
171: BEGIN
172: SELECT org_id
173: INTO p_org_id
174: FROM ap_expense_report_headers_all
175: WHERE report_header_id = p_header_id;
176:
177: return TRUE;
178: EXCEPTION

Line 256: FROM ap_expense_report_headers exp

252: p_attr12,
253: p_attr13,
254: p_attr14,
255: p_attr15
256: FROM ap_expense_report_headers exp
257: WHERE exp.report_header_id = p_report_header_id;
258:
259: IF GetDefaultEmpCCID(p_emp_id, l_default_emp_ccid) THEN
260: p_default_comb_id := l_default_emp_ccid;

Line 308: FROM AP_EXPENSE_REPORT_HEADERS

304: P_ExpHdrRec.override_appr_id,
305: P_ExpHdrRec.override_appr_name,
306: P_ExpHdrRec.emp_id,
307: P_ExpHdrRec.last_update_date
308: FROM AP_EXPENSE_REPORT_HEADERS
309: WHERE REPORT_HEADER_ID = P_ReportID
310: AND SOURCE = C_RestorableReportSource;
311:
312: return TRUE;

Line 336: ap_expense_report_headers

332: nvl(precision,0)
333: INTO p_exch_rate,
334: p_reimb_precision
335: FROM fnd_currencies_vl,
336: ap_expense_report_headers
337: WHERE report_header_id = p_report_id
338: AND currency_code = default_currency_code;
339:
340: return TRUE;

Line 358: SELECT ap_expense_report_headers_s.nextval

354: l_debug_info VARCHAR2(1000);
355: BEGIN
356: l_debug_info := 'Getting the next report header id';
357:
358: SELECT ap_expense_report_headers_s.nextval
359: INTO p_new_report_id
360: FROM sys.dual;
361:
362: return TRUE;

Line 380: SELECT ap_expense_report_headers_s.nextval

376: l_debug_info VARCHAR2(1000);
377: BEGIN
378: l_debug_info := 'Getting the next report header id';
379:
380: SELECT ap_expense_report_headers_s.nextval
381: INTO p_new_report_id
382: FROM dual;
383:
384: return TRUE;

Line 446: ap_expense_report_headers RH

442: p_week_end_date,
443: p_flex_concatenated,
444: p_employee_id
445: FROM ap_system_parameters S,
446: ap_expense_report_headers RH
447: WHERE RH.report_header_id = p_report_header_id;
448:
449: SELECT expense_check_address_flag
450: INTO l_exp_check_address_flag

Line 503: FROM ap_expense_report_headers erh,

499: l_exp_rpt_purpose,
500: l_emp_full_name,
501: p_ccard_amt,
502: p_total
503: FROM ap_expense_report_headers erh,
504: ap_credit_card_trxns cc,
505: /* hr_employees emp Bug 3006221 */
506: per_people_f emp,
507: ap_cards aca,

Line 553: FROM ap_expense_report_headers

549: l_shortpay_id expHdr_shortpayParentID := NULL;
550: BEGIN
551: SELECT shortpay_parent_id
552: INTO l_shortpay_id
553: FROM ap_expense_report_headers
554: WHERE report_header_id = P_ReportID;
555:
556: IF (l_shortpay_id IS NULL) THEN
557: P_Shortpaid := FALSE;

Line 584: INSERT INTO AP_EXPENSE_REPORT_HEADERS

580: BEGIN
581:
582: l_debug_info := 'Add Report Header';
583:
584: INSERT INTO AP_EXPENSE_REPORT_HEADERS
585: (report_header_id,
586: employee_id,
587: override_approver_id,
588: override_approver_name,

Line 662: INSERT INTO ap_expense_report_headers

658: p_xpense_rec IN XpenseInfoRec
659: ) RETURN BOOLEAN IS
660: -------------------------------------------------------------------
661: BEGIN
662: INSERT INTO ap_expense_report_headers
663: (report_header_id,
664: employee_id,
665: week_end_date,
666: creation_date,

Line 860: FROM ap_expense_report_headers erh

856: p_xpense_rec.receipts_status,
857: p_xpense_rec.image_receipts_status,
858: p_xpense_rec.image_receipts_received_date,
859: approval_type -- Bug 13696856
860: FROM ap_expense_report_headers erh
861: WHERE report_header_id = p_orig_report_header_id;
862:
863: return TRUE;
864: EXCEPTION

Line 877: UPDATE ap_expense_report_headers

873: FUNCTION SetDefaultExchRateType(p_report_header_id IN expHdr_headerID,
874: p_xrate_type IN expHdr_defaultXchRateType)
875: RETURN BOOLEAN IS
876: BEGIN
877: UPDATE ap_expense_report_headers
878: SET default_exchange_rate_type = p_xrate_type
879: WHERE report_header_id = p_report_header_id;
880:
881: return TRUE;

Line 909: UPDATE ap_expense_report_headers RH

905: p_employee_ccid IN expHdr_employeeCCID
906: ) RETURN BOOLEAN IS
907: -------------------------------------------------------------------
908: BEGIN
909: UPDATE ap_expense_report_headers RH
910: SET expense_check_address_flag = p_exp_check_address_flag,
911: source = p_source,
912: workflow_approved_flag = p_workflow_approve_flag,
913: apply_advances_default = decode(apply_advances_default,'Y','Y',decode(p_sys_apply_advances_default, 'Y',

Line 952: from ap_expense_report_headers

948: l_amt_due_employee := p_amt_due_employee;
949:
950: SELECT decode (maximum_amount_to_apply, NULL, NULL,least( p_total, maximum_amount_to_apply))-- Bug 3654956
951: INTO l_max_amt_to_apply
952: from ap_expense_report_headers
953: where report_header_id = p_report_header_id;
954:
955: --Bug#6400678 : Calculate amount due to employee taking advance applied into consideration
956:

Line 961: UPDATE ap_expense_report_headers

957: IF(l_max_amt_to_apply IS NOT NULL AND l_max_amt_to_apply <> 0) THEN
958: l_amt_due_employee := l_amt_due_employee - l_max_amt_to_apply;
959: END IF;
960:
961: UPDATE ap_expense_report_headers
962: SET amt_due_ccard_company = p_amt_due_ccard_company,
963: amt_due_employee = l_amt_due_employee,
964: total = p_total,
965: maximum_amount_to_apply = l_max_amt_to_apply

Line 998: UPDATE ap_expense_report_headers

994: ) RETURN BOOLEAN IS
995: -------------------------------------------------------------------
996: BEGIN
997: /* Bug 3654956 : Seeting the value of maximum_amount_to_apply*/
998: UPDATE ap_expense_report_headers
999: SET total = decode(p_total, NULL, total, total - p_sub_total),
1000: vendor_id = p_vendor_id,
1001: vendor_site_id = p_vendor_site_id,
1002: amt_due_ccard_company = NVL(p_amt_due_ccard_company, amt_due_ccard_company),

Line 1034: UPDATE ap_expense_report_headers erh

1030: ) RETURN BOOLEAN IS
1031: -------------------------------------------------------------------
1032: BEGIN
1033:
1034: UPDATE ap_expense_report_headers erh
1035: SET workflow_approved_flag = NVL(p_flag, decode(erh.workflow_approved_flag, 'M', 'A', erh.workflow_approved_flag)),
1036: source = NVL(p_source, erh.source),
1037: last_update_date = SYSDATE
1038: --last_updated_by = Decode(Nvl(fnd_global.user_id,-1),-1,last_updated_by,fnd_global.user_id)

Line 1061: UPDATE ap_expense_report_headers

1057: RETURN BOOLEAN IS
1058: -------------------------------------------------------------------
1059: BEGIN
1060:
1061: UPDATE ap_expense_report_headers
1062: SET workflow_approved_flag = decode(workflow_approved_flag,
1063: 'P','Y',
1064: C_WORKFLOW_APPROVED_REQUEST, C_WORKFLOW_APPROVED_REQUEST, -- AP already rejected
1065: C_WORKFLOW_APPROVED_REJECTED, C_WORKFLOW_APPROVED_REJECTED, -- AP already requests more info

Line 1086: UPDATE ap_expense_report_headers

1082: RETURN BOOLEAN IS
1083: -------------------------------------------------------------------
1084: BEGIN
1085:
1086: UPDATE ap_expense_report_headers
1087: SET workflow_approved_flag = decode(workflow_approved_flag,
1088: 'P', 'Y',
1089: 'Y', 'Y',
1090: 'M')

Line 1120: FROM AP_EXPENSE_REPORT_HEADERS

1116: -- column-name in the FOR UPDATE is missing and NOWAIT is used, so the OF
1117: -- REPORT_HEADER_ID is used as a place holder.
1118: SELECT REPORT_HEADER_ID
1119: INTO l_TempReportHeaderID
1120: FROM AP_EXPENSE_REPORT_HEADERS
1121: WHERE REPORT_HEADER_ID = P_ReportID
1122: AND SOURCE = C_RestorableReportSource
1123: AND LAST_UPDATE_DATE = NVL(P_LastUpdateDate, LAST_UPDATE_DATE)
1124: FOR UPDATE OF REPORT_HEADER_ID NOWAIT;

Line 1148: DELETE FROM ap_expense_report_headers

1144: -------------------------------------------------------------------
1145: l_curr_calling_sequence VARCHAR2(100) := 'DeleteExpenseReport';
1146:
1147: BEGIN
1148: DELETE FROM ap_expense_report_headers
1149: WHERE report_header_id = p_report_header_id;
1150:
1151: /* Delete All Notes associated with Expense Report */
1152: AP_WEB_NOTES_PKG.DeleteERNotes (

Line 1221: from AP_EXPENSE_REPORT_HEADERS

1217: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPRPT_PKG',
1218: 'start DuplicateHeader');
1219:
1220: select EMPLOYEE_ID into l_employee_id
1221: from AP_EXPENSE_REPORT_HEADERS
1222: where REPORT_HEADER_ID = p_source_report_header_id;
1223: l_invoice_num := AP_WEB_OA_CUSTOM_PKG.GetNewExpenseReportInvoice(l_employee_id, p_user_id, p_target_report_header_id);
1224:
1225: insert into AP_EXPENSE_REPORT_HEADERS

Line 1225: insert into AP_EXPENSE_REPORT_HEADERS

1221: from AP_EXPENSE_REPORT_HEADERS
1222: where REPORT_HEADER_ID = p_source_report_header_id;
1223: l_invoice_num := AP_WEB_OA_CUSTOM_PKG.GetNewExpenseReportInvoice(l_employee_id, p_user_id, p_target_report_header_id);
1224:
1225: insert into AP_EXPENSE_REPORT_HEADERS
1226: (
1227: REPORT_HEADER_ID,
1228: WEEK_END_DATE,
1229: EMPLOYEE_ID,

Line 1353: from AP_EXPENSE_REPORT_HEADERS

1349: p_user_id AS CREATED_BY,
1350: sysdate AS LAST_UPDATE_DATE,
1351: p_user_id AS LAST_UPDATED_BY,
1352: l_invoice_num as INVOICE_NUM
1353: from AP_EXPENSE_REPORT_HEADERS
1354: where REPORT_HEADER_ID = p_source_report_header_id;
1355:
1356: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPRPT_PKG',
1357: 'end DuplicateHeader');

Line 1379: from ap_expense_report_headers

1375: and Nvl(itemization_parent_id,-200) <> -1;
1376:
1377: select(l_total - total)
1378: into l_diff
1379: from ap_expense_report_headers
1380: where report_header_id = p_report_header_id;
1381:
1382: update ap_expense_report_headers
1383: set total = l_total,

Line 1382: update ap_expense_report_headers

1378: into l_diff
1379: from ap_expense_report_headers
1380: where report_header_id = p_report_header_id;
1381:
1382: update ap_expense_report_headers
1383: set total = l_total,
1384: amt_due_employee = amt_due_employee + l_diff
1385: where report_header_id = p_report_header_id;
1386:

Line 1409: FROM ap_expense_report_headers

1405: -------------------------------------------------------------------
1406: BEGIN
1407: SELECT payment_currency_code
1408: INTO p_payment_curr_code
1409: FROM ap_expense_report_headers
1410: WHERE report_header_id = p_expenseReportId;
1411:
1412: return TRUE;
1413: EXCEPTION

Line 1430: FROM ap_expense_report_headers

1426: -------------------------------------------------------------------
1427: BEGIN
1428: SELECT total
1429: INTO p_total
1430: FROM ap_expense_report_headers
1431: WHERE report_header_id = p_report_header_id;
1432:
1433: RETURN true;
1434: EXCEPTION

Line 1498: FROM ap_expense_report_headers aerh

1494: SELECT AP_WEB_POLICY_UTILS.get_lookup_meaning('OIE_AUD_RETURN_REASONS',aerh.return_reason_code),
1495: AP_WEB_POLICY_UTILS.get_lookup_description('OIE_AUD_RETURN_REASONS',aerh.return_reason_code)||' '||aerh.return_instruction
1496: INTO p_return_reason,
1497: p_return_instruction
1498: FROM ap_expense_report_headers aerh
1499: WHERE aerh.report_header_id = p_report_header_id;
1500:
1501: return true;
1502:

Line 1524: UPDATE ap_expense_report_headers aerh

1520:
1521: BEGIN
1522: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_DB_EXPRPT_PKG', 'start clearAuditReturnReasonInstr');
1523:
1524: UPDATE ap_expense_report_headers aerh
1525: SET aerh.return_reason_code = '',
1526: aerh.return_instruction = ''
1527: WHERE aerh.report_header_id = p_report_header_id;
1528:

Line 1677: l_invoice_num AP_EXPENSE_REPORT_HEADERS_ALL.INVOICE_NUM%TYPE;

1673: ------------------------------------------------------------------------
1674: FUNCTION GetERInvoiceNumber(p_report_header_id IN NUMBER)
1675: RETURN VARCHAR2 IS
1676:
1677: l_invoice_num AP_EXPENSE_REPORT_HEADERS_ALL.INVOICE_NUM%TYPE;
1678:
1679: BEGIN
1680: SELECT invoice_num
1681: INTO l_invoice_num

Line 1682: FROM ap_expense_report_headers_all

1678:
1679: BEGIN
1680: SELECT invoice_num
1681: INTO l_invoice_num
1682: FROM ap_expense_report_headers_all
1683: WHERE report_header_id = p_report_header_id;
1684:
1685: return l_invoice_num;
1686: EXCEPTION

Line 1699: l_workflow_approved_flag AP_EXPENSE_REPORT_HEADERS_ALL.WORKFLOW_APPROVED_FLAG%TYPE;

1695: -- 03/22/2005 - Kristian Widjaja
1696: ------------------------------------------------------------------------
1697: FUNCTION GetERWorkflowApprovedFlag(p_report_header_id IN NUMBER)
1698: RETURN VARCHAR2 IS
1699: l_workflow_approved_flag AP_EXPENSE_REPORT_HEADERS_ALL.WORKFLOW_APPROVED_FLAG%TYPE;
1700:
1701: BEGIN
1702: SELECT workflow_approved_flag
1703: INTO l_workflow_approved_flag

Line 1704: FROM ap_expense_report_headers_all

1700:
1701: BEGIN
1702: SELECT workflow_approved_flag
1703: INTO l_workflow_approved_flag
1704: FROM ap_expense_report_headers_all
1705: WHERE report_header_id = p_report_header_id;
1706:
1707: return l_workflow_approved_flag;
1708: EXCEPTION

Line 1721: FROM ap_expense_report_headers_all

1717:
1718: BEGIN
1719: SELECT to_char(last_update_date, 'DD-MON-RRRR HH:MI:SS', 'NLS_DATE_LANGUAGE = ENGLISH')
1720: INTO l_last_update_date
1721: FROM ap_expense_report_headers_all
1722: WHERE report_header_id = p_report_header_id;
1723:
1724: return l_last_update_date;
1725: EXCEPTION