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 268: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;

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

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

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

Line 471: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;

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

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

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

Line 598: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;

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

Line 599: l_roundingParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;

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

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

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

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

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

Line 941: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;

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

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

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

Line 1152: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;

1148: FUNCTION GetNumberOfPersonalLines(p_report_header_id IN expLines_headerID,
1149: p_personal_count OUT NOCOPY NUMBER)
1150: RETURN BOOLEAN IS
1151: -------------------------------------------------------------------
1152: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
1153: BEGIN
1154: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN
1155: return FALSE;
1156: END IF; /* GetPersonalParamID */

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

1150: RETURN BOOLEAN IS
1151: -------------------------------------------------------------------
1152: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
1153: BEGIN
1154: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN
1155: return FALSE;
1156: END IF; /* GetPersonalParamID */
1157:
1158: SELECT count(*)

Line 2369: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;

2365: --------------------------------------------------------------------------------
2366: FUNCTION DeletePersonalLines(p_report_header_id IN expLines_headerID
2367: ) RETURN BOOLEAN IS
2368: --------------------------------------------------------------------------------
2369: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
2370:
2371: BEGIN
2372:
2373: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN

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

2369: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
2370:
2371: BEGIN
2372:
2373: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN
2374: return FALSE;
2375: END IF; /* GetPersonalParamID */
2376:
2377:

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

2484: RETURN BOOLEAN IS
2485: --------------------------------------------------------------------------------
2486: l_parameterId number;
2487: BEGIN
2488: if (AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_parameterId) <> TRUE) then
2489: APP_EXCEPTION.RAISE_EXCEPTION;
2490: end if;
2491:
2492: -- Bug 3253775: Included personal credit card transactions in the cursor and

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

2544: /* Bug 3649748 : Calling GetCCardLineCursor to get the COMPANY Pay
2545: * lines
2546: */
2547: /*
2548: if (AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_parameterId) <> TRUE) then
2549: APP_EXCEPTION.RAISE_EXCEPTION;
2550: end if;
2551:
2552: SELECT sum(erl.amount)

Line 4607: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;

4603: l_cash_amt NUMBER := 0;
4604: l_ccard_amt NUMBER := 0;
4605: l_total_amt NUMBER := 0;
4606: l_company_pay VARCHAR2(100) := AP_WEB_EXPENSE_WF.C_CompanyPay;
4607: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
4608: BEGIN
4609:
4610: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN
4611: l_personalParameterId := fnd_api.G_MISS_NUM;

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

4606: l_company_pay VARCHAR2(100) := AP_WEB_EXPENSE_WF.C_CompanyPay;
4607: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
4608: BEGIN
4609:
4610: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN
4611: l_personalParameterId := fnd_api.G_MISS_NUM;
4612: END IF;
4613:
4614: /**