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.OKL_CREDIT_DATAPOINTS_PVT dependencies on MO_GLOBAL

Line 14: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

10: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
11: l_credit_line_number VARCHAR2(120);
12:
13: BEGIN
14: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
15: x_resultout := FND_API.G_RET_STS_SUCCESS;
16: BEGIN
17: SELECT KHR.CONTRACT_NUMBER
18: INTO l_credit_line_number

Line 48: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

44: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
45: l_credit_line_expiration_date DATE;
46:
47: BEGIN
48: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
49: x_resultout := FND_API.G_RET_STS_SUCCESS;
50: BEGIN
51: SELECT KHR.END_DATE
52: INTO l_credit_line_expiration_date

Line 85: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

81: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
82: l_currency VARCHAR2(15);
83:
84: BEGIN
85: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
86: x_resultout := FND_API.G_RET_STS_SUCCESS;
87: BEGIN
88: SELECT CURRENCY_CODE
89: INTO l_currency

Line 117: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

113: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
114: l_sales_rep VARCHAR2(30);
115:
116: BEGIN
117: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
118: x_resultout := FND_API.G_RET_STS_SUCCESS;
119: BEGIN
120: SELECT REP.SALESREP_NUMBER
121: INTO l_sales_rep

Line 152: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

148: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
149: l_program_vendor VARCHAR2(30);
150:
151: BEGIN
152: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
153: x_resultout := FND_API.G_RET_STS_SUCCESS;
154: BEGIN
155: SELECT PO.SEGMENT1
156: INTO l_program_vendor

Line 189: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

185: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
186: l_program_agreement_number VARCHAR2(120);
187:
188: BEGIN
189: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
190: x_resultout := FND_API.G_RET_STS_SUCCESS;
191: BEGIN
192: SELECT KHR.CONTRACT_NUMBER
193: INTO l_program_agreement_number

Line 223: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

219: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
220: l_expected_start_date DATE;
221:
222: BEGIN
223: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
224: x_resultout := FND_API.G_RET_STS_SUCCESS;
225: BEGIN
226: SELECT QUOTE.EXPECTED_START_DATE
227: INTO l_expected_start_date

Line 261: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

257: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
258: l_expected_delivery_date DATE;
259:
260: BEGIN
261: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
262: x_resultout := FND_API.G_RET_STS_SUCCESS;
263: BEGIN
264: SELECT QUOTE.EXPECTED_DELIVERY_DATE
265: INTO l_expected_delivery_date

Line 298: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

294: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
295: l_expected_funding_date DATE;
296:
297: BEGIN
298: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
299: x_resultout := FND_API.G_RET_STS_SUCCESS;
300: BEGIN
301: SELECT QUOTE.EXPECTED_FUNDING_DATE
302: INTO l_expected_funding_date

Line 335: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

331: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
332: l_lease_application_template VARCHAR2(150);
333:
334: BEGIN
335: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
336: x_resultout := FND_API.G_RET_STS_SUCCESS;
337: BEGIN
338: SELECT TEMPLATES.NAME
339: INTO l_lease_application_template

Line 368: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

364: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
365: l_org_unit VARCHAR2(240);
366:
367: BEGIN
368: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
369: x_resultout := FND_API.G_RET_STS_SUCCESS;
370: BEGIN
371: SELECT ORG.NAME
372: INTO l_org_unit

Line 401: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

397: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
398: l_prospect_address VARCHAR2(30);
399:
400: BEGIN
401: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
402: x_resultout := FND_API.G_RET_STS_SUCCESS;
403: BEGIN
404: SELECT PARTY_SITES.PARTY_SITE_NUMBER
405: INTO l_prospect_address

Line 434: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

430: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
431: l_term_of_deal NUMBER;
432:
433: BEGIN
434: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
435: x_resultout := FND_API.G_RET_STS_SUCCESS;
436: BEGIN
437: SELECT QUOTE.TERM
438: INTO l_term_of_deal

Line 469: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

465: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
466: l_financial_product VARCHAR2(150);
467:
468: BEGIN
469: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
470: x_resultout := FND_API.G_RET_STS_SUCCESS;
471: BEGIN
472: SELECT PRODUCT.NAME
473: INTO l_financial_product

Line 526: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

522: AND LAP.ID = l_lease_app_id;
523:
524: ln_seq_number NUMBER :=1;
525: BEGIN
526: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
527: x_resultout := FND_API.G_RET_STS_SUCCESS;
528: BEGIN
529:
530: x_resultout := FND_API.G_RET_STS_SUCCESS;

Line 583: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

579:
580: ln_seq_number NUMBER :=1;
581:
582: BEGIN
583: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
584: x_resultout := FND_API.G_RET_STS_SUCCESS;
585: BEGIN
586:
587: x_resultout := FND_API.G_RET_STS_SUCCESS;

Line 640: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

636: AND LAP.ID = l_lease_app_id;
637:
638: ln_seq_number NUMBER :=1;
639: BEGIN
640: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
641: x_resultout := FND_API.G_RET_STS_SUCCESS;
642: BEGIN
643:
644: x_resultout := FND_API.G_RET_STS_SUCCESS;

Line 694: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

690:
691: ln_seq_number NUMBER :=1;
692:
693: BEGIN
694: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
695: x_resultout := FND_API.G_RET_STS_SUCCESS;
696: BEGIN
697:
698: x_resultout := FND_API.G_RET_STS_SUCCESS;

Line 749: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

745:
746: ln_seq_number NUMBER :=1;
747:
748: BEGIN
749: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
750: x_resultout := FND_API.G_RET_STS_SUCCESS;
751: BEGIN
752:
753: x_resultout := FND_API.G_RET_STS_SUCCESS;

Line 803: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

799:
800: ln_seq_number NUMBER :=1;
801:
802: BEGIN
803: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
804: x_resultout := FND_API.G_RET_STS_SUCCESS;
805: BEGIN
806: x_resultout := FND_API.G_RET_STS_SUCCESS;
807:

Line 855: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

851: AND LAP.ID = l_lease_app_id;
852:
853: ln_seq_number NUMBER :=1;
854: BEGIN
855: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
856: x_resultout := FND_API.G_RET_STS_SUCCESS;
857: BEGIN
858: x_resultout := FND_API.G_RET_STS_SUCCESS;
859:

Line 909: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

905: ln_seq_number NUMBER :=1;
906:
907:
908: BEGIN
909: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
910: x_resultout := FND_API.G_RET_STS_SUCCESS;
911: BEGIN
912: x_resultout := FND_API.G_RET_STS_SUCCESS;
913:

Line 961: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

957:
958: ln_seq_number NUMBER :=1;
959:
960: BEGIN
961: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
962: x_resultout := FND_API.G_RET_STS_SUCCESS;
963: BEGIN
964: x_resultout := FND_API.G_RET_STS_SUCCESS;
965:

Line 999: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

995: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
996: l_usage_of_equipment VARCHAR2(30);
997:
998: BEGIN
999: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1000: x_resultout := FND_API.G_RET_STS_SUCCESS;
1001: BEGIN
1002: -- gboomina Bug 7110500 - Start
1003: SELECT QUOTE.USAGE_CATEGORY --QUOTE.USAGE_INDUSTRY_CLASS

Line 1037: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

1033: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1034: l_usage_industry VARCHAR2(1995);
1035:
1036: BEGIN
1037: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1038: x_resultout := FND_API.G_RET_STS_SUCCESS;
1039: BEGIN
1040: -- gboomina Bug 7110500 - Start
1041: /*

Line 1086: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

1082: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1083: l_usage_category VARCHAR2(30);
1084:
1085: BEGIN
1086: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1087: x_resultout := FND_API.G_RET_STS_SUCCESS;
1088: BEGIN
1089: SELECT QUOTE.USAGE_CATEGORY
1090: INTO l_usage_category

Line 1122: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

1118: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1119: l_usage_amount NUMBER;
1120:
1121: BEGIN
1122: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1123: x_resultout := FND_API.G_RET_STS_SUCCESS;
1124: BEGIN
1125: -- gboomina Bug 7110500 - Start
1126: /*

Line 1178: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

1174: AND ASSET_COMP.PRIMARY_COMPONENT = 'NO';
1175:
1176: ln_seq_number NUMBER :=1;
1177: BEGIN
1178: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1179: x_resultout := FND_API.G_RET_STS_SUCCESS;
1180: BEGIN
1181: x_resultout := FND_API.G_RET_STS_SUCCESS;
1182:

Line 1226: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

1222: AND ASSET_COMP.PRIMARY_COMPONENT = 'NO';
1223:
1224: ln_seq_number NUMBER :=1;
1225: BEGIN
1226: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1227: x_resultout := FND_API.G_RET_STS_SUCCESS;
1228: BEGIN
1229:
1230: x_resultout := FND_API.G_RET_STS_SUCCESS;

Line 1275: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

1271: AND ASSET_COMP.PRIMARY_COMPONENT = 'NO';
1272:
1273: ln_seq_number NUMBER :=1;
1274: BEGIN
1275: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1276: x_resultout := FND_API.G_RET_STS_SUCCESS;
1277: BEGIN
1278: x_resultout := FND_API.G_RET_STS_SUCCESS;
1279:

Line 1323: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

1319:
1320: ln_seq_number NUMBER :=1;
1321:
1322: BEGIN
1323: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1324: x_resultout := FND_API.G_RET_STS_SUCCESS;
1325: BEGIN
1326:
1327: x_resultout := FND_API.G_RET_STS_SUCCESS;

Line 1371: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

1367: AND ASSET_COMP.PRIMARY_COMPONENT = 'NO';
1368:
1369: ln_seq_number NUMBER :=1;
1370: BEGIN
1371: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1372: x_resultout := FND_API.G_RET_STS_SUCCESS;
1373: BEGIN
1374:
1375: x_resultout := FND_API.G_RET_STS_SUCCESS;

Line 1419: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

1415: AND ASSET_COMP.PRIMARY_COMPONENT = 'NO';
1416:
1417: ln_seq_number NUMBER :=1;
1418: BEGIN
1419: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1420: x_resultout := FND_API.G_RET_STS_SUCCESS;
1421: BEGIN
1422:
1423: x_resultout := FND_API.G_RET_STS_SUCCESS;

Line 1468: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

1464: AND LAP.ID = l_lease_app_id;
1465:
1466: ln_seq_number NUMBER :=1;
1467: BEGIN
1468: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1469: x_resultout := FND_API.G_RET_STS_SUCCESS;
1470: BEGIN
1471:
1472: x_resultout := FND_API.G_RET_STS_SUCCESS;

Line 1507: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

1503: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1504: l_down_payment_amount NUMBER;
1505:
1506: BEGIN
1507: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1508: x_resultout := FND_API.G_RET_STS_SUCCESS;
1509: BEGIN
1510: SELECT NVL(SUM(ADJ.VALUE), 0)
1511: INTO l_down_payment_amount

Line 1547: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

1543: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1544: l_subsidy_amount NUMBER;
1545:
1546: BEGIN
1547: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1548: x_resultout := FND_API.G_RET_STS_SUCCESS;
1549: BEGIN
1550: SELECT SUM(DECODE(ADJ.VALUE, NULL, ADJ.DEFAULT_SUBSIDY_AMOUNT, ADJ.VALUE)) SUBSIDY_AMOUNT
1551: INTO l_subsidy_amount

Line 1588: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

1584: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1585: l_trade_in_amount NUMBER;
1586:
1587: BEGIN
1588: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1589: x_resultout := FND_API.G_RET_STS_SUCCESS;
1590: BEGIN
1591: SELECT NVL(SUM(ADJ.VALUE), 0)
1592: INTO l_trade_in_amount

Line 1644: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

1640: AND LAP.ID = l_lease_app_id;
1641:
1642: ln_seq_number NUMBER :=1;
1643: BEGIN
1644: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1645: x_resultout := FND_API.G_RET_STS_SUCCESS;
1646: BEGIN
1647: x_resultout := FND_API.G_RET_STS_SUCCESS;
1648:

Line 1745: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

1741:
1742:
1743: ln_seq_number NUMBER :=1;
1744: BEGIN
1745: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1746: x_resultout := FND_API.G_RET_STS_SUCCESS;
1747: BEGIN
1748: x_resultout := FND_API.G_RET_STS_SUCCESS;
1749:

Line 1841: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

1837: and LAP.id = l_lease_app_id;*/
1838:
1839: ln_seq_number NUMBER :=1;
1840: BEGIN
1841: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1842: x_resultout := FND_API.G_RET_STS_SUCCESS;
1843: BEGIN
1844:
1845: x_resultout := FND_API.G_RET_STS_SUCCESS;

Line 1938: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

1934: and LAP.id = l_lease_app_id;*/
1935:
1936: ln_seq_number NUMBER :=1;
1937: BEGIN
1938: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1939: x_resultout := FND_API.G_RET_STS_SUCCESS;
1940: BEGIN
1941: x_resultout := FND_API.G_RET_STS_SUCCESS;
1942:

Line 2034: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

2030: and LAP.id = l_lease_app_id; */
2031:
2032: ln_seq_number NUMBER :=1;
2033: BEGIN
2034: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2035: x_resultout := FND_API.G_RET_STS_SUCCESS;
2036: BEGIN
2037: x_resultout := FND_API.G_RET_STS_SUCCESS;
2038:

Line 2130: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

2126: and LAP.id = l_lease_app_id;*/
2127:
2128: ln_seq_number NUMBER :=1;
2129: BEGIN
2130: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2131: x_resultout := FND_API.G_RET_STS_SUCCESS;
2132: BEGIN
2133:
2134: x_resultout := FND_API.G_RET_STS_SUCCESS;

Line 2172: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

2168: l_payment_structure VARCHAR2(5) := 'LEVEL';
2169:
2170: ln_seq_number NUMBER :=1;
2171: BEGIN
2172: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2173: x_resultout := FND_API.G_RET_STS_SUCCESS;
2174: BEGIN
2175:
2176: x_resultout := FND_API.G_RET_STS_SUCCESS;

Line 2217: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

2213: l_next_start_date DATE;
2214: l_end_date DATE;
2215:
2216: BEGIN
2217: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2218: IF p_frequency_code = 'A' THEN
2219: l_mpp := 12;
2220: ELSIF p_frequency_code = 'S' THEN
2221: l_mpp := 6;

Line 2369: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

2365: l_freq_code OKL_CASH_FLOW_LEVELS.FQY_CODE%TYPE;
2366: l_term NUMBER;
2367: l_return_status VARCHAR2(1);
2368: BEGIN
2369: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2370: x_resultout := FND_API.G_RET_STS_SUCCESS;
2371: BEGIN
2372: x_resultout := FND_API.G_RET_STS_SUCCESS;
2373:

Line 2470: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

2466:
2467: ln_seq_number NUMBER :=1;
2468:
2469: BEGIN
2470: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2471: x_resultout := FND_API.G_RET_STS_SUCCESS;
2472: BEGIN
2473: x_resultout := FND_API.G_RET_STS_SUCCESS;
2474:

Line 2522: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

2518:
2519: ln_seq_number NUMBER :=1;
2520:
2521: BEGIN
2522: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2523: x_resultout := FND_API.G_RET_STS_SUCCESS;
2524: BEGIN
2525: x_resultout := FND_API.G_RET_STS_SUCCESS;
2526:

Line 2572: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

2568:
2569:
2570: ln_seq_number NUMBER :=1;
2571: BEGIN
2572: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2573: x_resultout := FND_API.G_RET_STS_SUCCESS;
2574: BEGIN
2575: x_resultout := FND_API.G_RET_STS_SUCCESS;
2576:

Line 2622: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

2618:
2619:
2620: ln_seq_number NUMBER :=1;
2621: BEGIN
2622: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2623: x_resultout := FND_API.G_RET_STS_SUCCESS;
2624: BEGIN
2625: x_resultout := FND_API.G_RET_STS_SUCCESS;
2626:

Line 2686: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

2682:
2683: l_adj_amount NUMBER; -- added for bug 6596860 --
2684:
2685: BEGIN
2686: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2687: x_resultout := FND_API.G_RET_STS_SUCCESS;
2688:
2689: SELECT NVL(SUM(AST.OEC), 0)
2690: INTO ln_asset_cost

Line 2747: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

2743: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
2744: ln_financed_amount NUMBER;
2745:
2746: BEGIN
2747: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2748: x_resultout := FND_API.G_RET_STS_SUCCESS;
2749:
2750: ln_financed_amount := amount_requested(x_resultout => x_resultout,
2751: x_errormsg => x_errormsg);

Line 2773: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

2769: ln_financed_amount NUMBER;
2770: ln_subsidy_amount NUMBER;
2771:
2772: BEGIN
2773: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2774: SELECT NVL(SUM(ADJ.VALUE), 0)
2775: INTO ln_down_payment_amount
2776: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,
2777: OKL_COST_ADJUSTMENTS_B ADJ, OKL_LEASE_QUOTES_B QUOTE

Line 2827: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

2823:
2824: ln_seq_number NUMBER :=1;
2825:
2826: BEGIN
2827: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2828: x_resultout := FND_API.G_RET_STS_SUCCESS;
2829: BEGIN
2830: x_resultout := FND_API.G_RET_STS_SUCCESS;
2831:

Line 2868: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

2864: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
2865: l_billed_tax NUMBER;
2866:
2867: BEGIN
2868: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2869: x_resultout := FND_API.G_RET_STS_SUCCESS;
2870: BEGIN
2871: SELECT SUM(TRXD.TAX_AMT)
2872: INTO l_billed_tax

Line 2937: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

2933:
2934: x_data_points_tbl OCM_DATA_POINTS_PUB.data_points_tbl;
2935:
2936: BEGIN
2937: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2938: IF p_init_msg_list = G_TRUE THEN
2939: FND_MSG_PUB.initialize;
2940: END IF;
2941:

Line 3018: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

3014:
3015: ln_index NUMBER;
3016:
3017: BEGIN
3018: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
3019: IF p_init_msg_list = G_TRUE THEN
3020: FND_MSG_PUB.initialize;
3021: END IF;
3022:

Line 3106: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

3102: WHERE
3103: leaseapp_id = p_leaseapp_id;
3104:
3105: BEGIN
3106: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
3107: IF p_init_msg_list = G_TRUE THEN
3108: FND_MSG_PUB.initialize;
3109: END IF;
3110:

Line 3160: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

3156: WHERE
3157: leaseapp_id = p_leaseapp_id;
3158:
3159: BEGIN
3160: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
3161: OPEN c_get_leaseapp_datapoints;
3162: FETCH c_get_leaseapp_datapoints INTO ln_dp_count;
3163: CLOSE c_get_leaseapp_datapoints;
3164:

Line 3181: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

3177:
3178: lv_data_point_value okl_leaseapp_datapoints.data_point_value%TYPE;
3179:
3180: BEGIN
3181: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
3182: x_resultout := FND_API.G_RET_STS_SUCCESS;
3183: BEGIN
3184: SELECT DATA_POINT_VALUE
3185: INTO lv_data_point_value