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_EXPLINE_PKG dependencies on AP_WEB_DB_EXPTEMPLATE_PKG

Line 270: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;

266: p_is_cc_lines IN BOOLEAN,
267: p_xpense_lines_cursor OUT NOCOPY DisplayXpenseLinesCursor)
268: RETURN BOOLEAN IS
269: --------------------------------------------------------------------------------
270: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
271: BEGIN
272: if p_is_cc_lines then
273: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN
274: return FALSE;

Line 273: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN

269: --------------------------------------------------------------------------------
270: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
271: BEGIN
272: if p_is_cc_lines then
273: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN
274: return FALSE;
275: END IF; /* GetPersonalParamID */
276:
277: -- get credit card lines only

Line 473: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;

469: p_report_header_id IN expLines_headerID,
470: p_personal_lines_cursor OUT NOCOPY DisplayXpenseLinesCursor)
471: RETURN BOOLEAN IS
472: --------------------------------------------------------------------------------
473: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
474: BEGIN
475: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN
476: return FALSE;
477: END IF; /* GetPersonalParamID */

Line 475: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN

471: RETURN BOOLEAN IS
472: --------------------------------------------------------------------------------
473: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
474: BEGIN
475: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN
476: return FALSE;
477: END IF; /* GetPersonalParamID */
478:
479: OPEN p_personal_lines_cursor FOR

Line 600: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;

596: p_adjustment_type IN VARCHAR2,
597: p_cursor OUT NOCOPY AdjustmentCursorType)
598: RETURN BOOLEAN IS
599: --------------------------------------------------------------------------------
600: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
601: l_roundingParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
602: BEGIN
603: /**
604: * Note the select statement needs to have the same number and type of columns in order for the reference cursor

Line 601: l_roundingParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;

597: p_cursor OUT NOCOPY AdjustmentCursorType)
598: RETURN BOOLEAN IS
599: --------------------------------------------------------------------------------
600: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
601: l_roundingParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
602: BEGIN
603: /**
604: * Note the select statement needs to have the same number and type of columns in order for the reference cursor
605: * to work. Currently the queries match except for where statement. Not using dynamic SQL here because there are

Line 611: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN

607: * future.
608: */
609:
610: /* jrautiai ADJ Fix Start */
611: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN
612: l_personalParameterId := fnd_api.G_MISS_NUM;
613: END IF;
614:
615: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetRoundingParamID(l_roundingParameterId)) THEN

Line 615: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetRoundingParamID(l_roundingParameterId)) THEN

611: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN
612: l_personalParameterId := fnd_api.G_MISS_NUM;
613: END IF;
614:
615: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetRoundingParamID(l_roundingParameterId)) THEN
616: l_roundingParameterId := fnd_api.G_MISS_NUM;
617: END IF;
618: /* jrautiai ADJ Fix End */
619:

Line 943: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;

939: FUNCTION GetPersonalTotalOfExpRpt(p_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
940: p_personal_total OUT NOCOPY NUMBER)
941: RETURN BOOLEAN IS
942: -------------------------------------------------------------------
943: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
944: BEGIN
945:
946: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN
947: return FALSE;

Line 946: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN

942: -------------------------------------------------------------------
943: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
944: BEGIN
945:
946: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN
947: return FALSE;
948: END IF; /* GetPersonalParamID */
949:
950: -- used (itemization_parent_id is null OR itemization_parent_id <> -1)

Line 1157: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;

1153: FUNCTION GetNumberOfPersonalLines(p_report_header_id IN expLines_headerID,
1154: p_personal_count OUT NOCOPY NUMBER)
1155: RETURN BOOLEAN IS
1156: -------------------------------------------------------------------
1157: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
1158: BEGIN
1159: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN
1160: return FALSE;
1161: END IF; /* GetPersonalParamID */

Line 1159: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN

1155: RETURN BOOLEAN IS
1156: -------------------------------------------------------------------
1157: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
1158: BEGIN
1159: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN
1160: return FALSE;
1161: END IF; /* GetPersonalParamID */
1162:
1163: SELECT count(*)

Line 2618: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;

2614: --------------------------------------------------------------------------------
2615: FUNCTION DeletePersonalLines(p_report_header_id IN expLines_headerID
2616: ) RETURN BOOLEAN IS
2617: --------------------------------------------------------------------------------
2618: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
2619:
2620: BEGIN
2621:
2622: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN

Line 2622: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN

2618: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
2619:
2620: BEGIN
2621:
2622: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN
2623: return FALSE;
2624: END IF; /* GetPersonalParamID */
2625:
2626: -- Bug: 8588537 remove distributions on the personal lines

Line 2745: if (AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_parameterId) <> TRUE) then

2741: RETURN BOOLEAN IS
2742: --------------------------------------------------------------------------------
2743: l_parameterId number;
2744: BEGIN
2745: if (AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_parameterId) <> TRUE) then
2746: APP_EXCEPTION.RAISE_EXCEPTION;
2747: end if;
2748:
2749: -- Bug 3253775: Included personal credit card transactions in the cursor and

Line 2805: if (AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_parameterId) <> TRUE) then

2801: /* Bug 3649748 : Calling GetCCardLineCursor to get the COMPANY Pay
2802: * lines
2803: */
2804: /*
2805: if (AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_parameterId) <> TRUE) then
2806: APP_EXCEPTION.RAISE_EXCEPTION;
2807: end if;
2808:
2809: SELECT sum(erl.amount)

Line 4921: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;

4917: l_cash_amt NUMBER := 0;
4918: l_ccard_amt NUMBER := 0;
4919: l_total_amt NUMBER := 0;
4920: l_company_pay VARCHAR2(100) := AP_WEB_EXPENSE_WF.C_CompanyPay;
4921: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
4922: BEGIN
4923:
4924: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN
4925: l_personalParameterId := fnd_api.G_MISS_NUM;

Line 4924: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN

4920: l_company_pay VARCHAR2(100) := AP_WEB_EXPENSE_WF.C_CompanyPay;
4921: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
4922: BEGIN
4923:
4924: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN
4925: l_personalParameterId := fnd_api.G_MISS_NUM;
4926: END IF;
4927:
4928: /**