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 444: ap_expense_report_headers RH

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

Line 501: FROM ap_expense_report_headers erh,

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

Line 551: FROM ap_expense_report_headers

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

Line 582: INSERT INTO AP_EXPENSE_REPORT_HEADERS

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

Line 660: INSERT INTO ap_expense_report_headers

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

Line 850: FROM ap_expense_report_headers erh

846: receipts_received_date, -- jrautiai 3008468
847: last_audited_by, -- jrautiai 2987037
848: audit_code, -- jrautiai 3255738
849: report_filing_number
850: FROM ap_expense_report_headers erh
851: WHERE report_header_id = p_orig_report_header_id;
852:
853: return TRUE;
854: EXCEPTION

Line 867: UPDATE ap_expense_report_headers

863: FUNCTION SetDefaultExchRateType(p_report_header_id IN expHdr_headerID,
864: p_xrate_type IN expHdr_defaultXchRateType)
865: RETURN BOOLEAN IS
866: BEGIN
867: UPDATE ap_expense_report_headers
868: SET default_exchange_rate_type = p_xrate_type
869: WHERE report_header_id = p_report_header_id;
870:
871: return TRUE;

Line 899: UPDATE ap_expense_report_headers RH

895: p_employee_ccid IN expHdr_employeeCCID
896: ) RETURN BOOLEAN IS
897: -------------------------------------------------------------------
898: BEGIN
899: UPDATE ap_expense_report_headers RH
900: SET expense_check_address_flag = p_exp_check_address_flag,
901: source = p_source,
902: workflow_approved_flag = p_workflow_approve_flag,
903: apply_advances_default = decode(apply_advances_default,'Y','Y',decode(p_sys_apply_advances_default, 'Y',

Line 942: from ap_expense_report_headers

938: l_amt_due_employee := p_amt_due_employee;
939:
940: SELECT decode (maximum_amount_to_apply, NULL, NULL,least( p_total, maximum_amount_to_apply))-- Bug 3654956
941: INTO l_max_amt_to_apply
942: from ap_expense_report_headers
943: where report_header_id = p_report_header_id;
944:
945: --Bug#6400678 : Calculate amount due to employee taking advance applied into consideration
946:

Line 951: UPDATE ap_expense_report_headers

947: IF(l_max_amt_to_apply IS NOT NULL AND l_max_amt_to_apply <> 0) THEN
948: l_amt_due_employee := l_amt_due_employee - l_max_amt_to_apply;
949: END IF;
950:
951: UPDATE ap_expense_report_headers
952: SET amt_due_ccard_company = p_amt_due_ccard_company,
953: amt_due_employee = l_amt_due_employee,
954: total = p_total,
955: maximum_amount_to_apply = l_max_amt_to_apply

Line 988: UPDATE ap_expense_report_headers

984: ) RETURN BOOLEAN IS
985: -------------------------------------------------------------------
986: BEGIN
987: /* Bug 3654956 : Seeting the value of maximum_amount_to_apply*/
988: UPDATE ap_expense_report_headers
989: SET total = decode(p_total, NULL, total, total - p_sub_total),
990: vendor_id = p_vendor_id,
991: vendor_site_id = p_vendor_site_id,
992: amt_due_ccard_company = NVL(p_amt_due_ccard_company, amt_due_ccard_company),

Line 1024: UPDATE ap_expense_report_headers erh

1020: ) RETURN BOOLEAN IS
1021: -------------------------------------------------------------------
1022: BEGIN
1023:
1024: UPDATE ap_expense_report_headers erh
1025: SET workflow_approved_flag = NVL(p_flag, decode(erh.workflow_approved_flag, 'M', 'A', erh.workflow_approved_flag)),
1026: source = NVL(p_source, erh.source)
1027: WHERE report_header_id = p_report_header_id;
1028:

Line 1049: UPDATE ap_expense_report_headers

1045: RETURN BOOLEAN IS
1046: -------------------------------------------------------------------
1047: BEGIN
1048:
1049: UPDATE ap_expense_report_headers
1050: SET workflow_approved_flag = decode(workflow_approved_flag,
1051: 'P','Y',
1052: C_WORKFLOW_APPROVED_REQUEST, C_WORKFLOW_APPROVED_REQUEST, -- AP already rejected
1053: C_WORKFLOW_APPROVED_REJECTED, C_WORKFLOW_APPROVED_REJECTED, -- AP already requests more info

Line 1074: UPDATE ap_expense_report_headers

1070: RETURN BOOLEAN IS
1071: -------------------------------------------------------------------
1072: BEGIN
1073:
1074: UPDATE ap_expense_report_headers
1075: SET workflow_approved_flag = decode(workflow_approved_flag,
1076: 'P', 'Y',
1077: 'Y', 'Y',
1078: 'M')

Line 1108: FROM AP_EXPENSE_REPORT_HEADERS

1104: -- column-name in the FOR UPDATE is missing and NOWAIT is used, so the OF
1105: -- REPORT_HEADER_ID is used as a place holder.
1106: SELECT REPORT_HEADER_ID
1107: INTO l_TempReportHeaderID
1108: FROM AP_EXPENSE_REPORT_HEADERS
1109: WHERE REPORT_HEADER_ID = P_ReportID
1110: AND SOURCE = C_RestorableReportSource
1111: AND LAST_UPDATE_DATE = NVL(P_LastUpdateDate, LAST_UPDATE_DATE)
1112: FOR UPDATE OF REPORT_HEADER_ID NOWAIT;

Line 1136: DELETE FROM ap_expense_report_headers

1132: -------------------------------------------------------------------
1133: l_curr_calling_sequence VARCHAR2(100) := 'DeleteExpenseReport';
1134:
1135: BEGIN
1136: DELETE FROM ap_expense_report_headers
1137: WHERE report_header_id = p_report_header_id;
1138:
1139: /* Delete All Notes associated with Expense Report */
1140: AP_WEB_NOTES_PKG.DeleteERNotes (

Line 1209: from AP_EXPENSE_REPORT_HEADERS

1205: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPRPT_PKG',
1206: 'start DuplicateHeader');
1207:
1208: select EMPLOYEE_ID into l_employee_id
1209: from AP_EXPENSE_REPORT_HEADERS
1210: where REPORT_HEADER_ID = p_source_report_header_id;
1211: l_invoice_num := AP_WEB_OA_CUSTOM_PKG.GetNewExpenseReportInvoice(l_employee_id, p_user_id, p_target_report_header_id);
1212:
1213: insert into AP_EXPENSE_REPORT_HEADERS

Line 1213: insert into AP_EXPENSE_REPORT_HEADERS

1209: from AP_EXPENSE_REPORT_HEADERS
1210: where REPORT_HEADER_ID = p_source_report_header_id;
1211: l_invoice_num := AP_WEB_OA_CUSTOM_PKG.GetNewExpenseReportInvoice(l_employee_id, p_user_id, p_target_report_header_id);
1212:
1213: insert into AP_EXPENSE_REPORT_HEADERS
1214: (
1215: REPORT_HEADER_ID,
1216: WEEK_END_DATE,
1217: EMPLOYEE_ID,

Line 1341: from AP_EXPENSE_REPORT_HEADERS

1337: p_user_id AS CREATED_BY,
1338: sysdate AS LAST_UPDATE_DATE,
1339: p_user_id AS LAST_UPDATED_BY,
1340: l_invoice_num as INVOICE_NUM
1341: from AP_EXPENSE_REPORT_HEADERS
1342: where REPORT_HEADER_ID = p_source_report_header_id;
1343:
1344: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPRPT_PKG',
1345: 'end DuplicateHeader');

Line 1365: from ap_expense_report_headers

1361: where report_header_id = p_report_header_id;
1362:
1363: select(l_total - total)
1364: into l_diff
1365: from ap_expense_report_headers
1366: where report_header_id = p_report_header_id;
1367:
1368: update ap_expense_report_headers
1369: set total = l_total,

Line 1368: update ap_expense_report_headers

1364: into l_diff
1365: from ap_expense_report_headers
1366: where report_header_id = p_report_header_id;
1367:
1368: update ap_expense_report_headers
1369: set total = l_total,
1370: amt_due_employee = amt_due_employee + l_diff
1371: where report_header_id = p_report_header_id;
1372:

Line 1395: FROM ap_expense_report_headers

1391: -------------------------------------------------------------------
1392: BEGIN
1393: SELECT payment_currency_code
1394: INTO p_payment_curr_code
1395: FROM ap_expense_report_headers
1396: WHERE report_header_id = p_expenseReportId;
1397:
1398: return TRUE;
1399: EXCEPTION

Line 1416: FROM ap_expense_report_headers

1412: -------------------------------------------------------------------
1413: BEGIN
1414: SELECT total
1415: INTO p_total
1416: FROM ap_expense_report_headers
1417: WHERE report_header_id = p_report_header_id;
1418:
1419: RETURN true;
1420: EXCEPTION

Line 1484: FROM ap_expense_report_headers aerh

1480: SELECT AP_WEB_POLICY_UTILS.get_lookup_meaning('OIE_AUD_RETURN_REASONS',aerh.return_reason_code),
1481: AP_WEB_POLICY_UTILS.get_lookup_description('OIE_AUD_RETURN_REASONS',aerh.return_reason_code)||' '||aerh.return_instruction
1482: INTO p_return_reason,
1483: p_return_instruction
1484: FROM ap_expense_report_headers aerh
1485: WHERE aerh.report_header_id = p_report_header_id;
1486:
1487: return true;
1488:

Line 1510: UPDATE ap_expense_report_headers aerh

1506:
1507: BEGIN
1508: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_DB_EXPRPT_PKG', 'start clearAuditReturnReasonInstr');
1509:
1510: UPDATE ap_expense_report_headers aerh
1511: SET aerh.return_reason_code = '',
1512: aerh.return_instruction = ''
1513: WHERE aerh.report_header_id = p_report_header_id;
1514:

Line 1663: l_invoice_num AP_EXPENSE_REPORT_HEADERS_ALL.INVOICE_NUM%TYPE;

1659: ------------------------------------------------------------------------
1660: FUNCTION GetERInvoiceNumber(p_report_header_id IN NUMBER)
1661: RETURN VARCHAR2 IS
1662:
1663: l_invoice_num AP_EXPENSE_REPORT_HEADERS_ALL.INVOICE_NUM%TYPE;
1664:
1665: BEGIN
1666: SELECT invoice_num
1667: INTO l_invoice_num

Line 1668: FROM ap_expense_report_headers_all

1664:
1665: BEGIN
1666: SELECT invoice_num
1667: INTO l_invoice_num
1668: FROM ap_expense_report_headers_all
1669: WHERE report_header_id = p_report_header_id;
1670:
1671: return l_invoice_num;
1672: EXCEPTION

Line 1685: l_workflow_approved_flag AP_EXPENSE_REPORT_HEADERS_ALL.WORKFLOW_APPROVED_FLAG%TYPE;

1681: -- 03/22/2005 - Kristian Widjaja
1682: ------------------------------------------------------------------------
1683: FUNCTION GetERWorkflowApprovedFlag(p_report_header_id IN NUMBER)
1684: RETURN VARCHAR2 IS
1685: l_workflow_approved_flag AP_EXPENSE_REPORT_HEADERS_ALL.WORKFLOW_APPROVED_FLAG%TYPE;
1686:
1687: BEGIN
1688: SELECT workflow_approved_flag
1689: INTO l_workflow_approved_flag

Line 1690: FROM ap_expense_report_headers_all

1686:
1687: BEGIN
1688: SELECT workflow_approved_flag
1689: INTO l_workflow_approved_flag
1690: FROM ap_expense_report_headers_all
1691: WHERE report_header_id = p_report_header_id;
1692:
1693: return l_workflow_approved_flag;
1694: EXCEPTION

Line 1707: FROM ap_expense_report_headers_all

1703:
1704: BEGIN
1705: SELECT to_char(last_update_date, 'DD-MON-RRRR HH:MI:SS', 'NLS_DATE_LANGUAGE = ENGLISH')
1706: INTO l_last_update_date
1707: FROM ap_expense_report_headers_all
1708: WHERE report_header_id = p_report_header_id;
1709:
1710: return l_last_update_date;
1711: EXCEPTION