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 748: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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