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 OCM_ADD_DATA_POINTS

Line 10: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

6: ---------------------------------------------
7: FUNCTION credit_line_number(x_resultout OUT NOCOPY VARCHAR2,
8: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
9:
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

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 32: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

28: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
29: x_errormsg := sqlerrm;
30: END;
31:
32: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=
33: to_char(l_credit_line_number) ;
34:
35: RETURN to_char(l_credit_line_number );
36: END credit_line_number ;

Line 44: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

40: ---------------------------------------------
41: FUNCTION credit_line_expiration_date(x_resultout OUT NOCOPY VARCHAR2,
42: x_errormsg OUT NOCOPY VARCHAR2) RETURN DATE IS
43:
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

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 69: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

65: END;
66:
67: l_credit_line_expiration_date := to_date(l_credit_line_expiration_date, 'DD-MM-RRRR');
68:
69: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=
70: l_credit_line_expiration_date;
71:
72: RETURN l_credit_line_expiration_date;
73: END credit_line_expiration_date ;

Line 81: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

77: ---------------------------------------------
78: FUNCTION currency(x_resultout OUT NOCOPY VARCHAR2,
79: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
80:
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

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 101: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

97: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
98: x_errormsg := sqlerrm;
99: END;
100:
101: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=
102: to_char(l_currency) ;
103:
104: RETURN to_char(l_currency);
105: END currency ;

Line 113: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

109: ---------------------------------------------
110: FUNCTION sales_rep(x_resultout OUT NOCOPY VARCHAR2,
111: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
112:
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

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 136: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

132: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
133: x_errormsg := sqlerrm;
134: END;
135:
136: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=
137: to_char(l_sales_rep) ;
138:
139: RETURN to_char(l_sales_rep);
140: END sales_rep ;

Line 148: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

144: ---------------------------------------------
145: FUNCTION program_vendor(x_resultout OUT NOCOPY VARCHAR2,
146: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
147:
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

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 173: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

169: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
170: x_errormsg := sqlerrm;
171: END;
172:
173: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=
174: to_char(l_program_vendor) ;
175:
176: RETURN to_char(l_program_vendor );
177: END program_vendor ;

Line 185: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

181: ---------------------------------------------
182: FUNCTION program_agreement_number(x_resultout OUT NOCOPY VARCHAR2,
183: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
184:
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

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 207: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

203: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
204: x_errormsg := sqlerrm;
205: END;
206:
207: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=
208: to_char(l_program_agreement_number) ;
209:
210: RETURN to_char(l_program_agreement_number );
211: END program_agreement_number ;

Line 219: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

215: ---------------------------------------------
216: FUNCTION expected_start_date(x_resultout OUT NOCOPY VARCHAR2,
217: x_errormsg OUT NOCOPY VARCHAR2) RETURN DATE IS
218:
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

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 245: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

241: END;
242:
243: l_expected_start_date := to_date(l_expected_start_date, 'DD-MM-RRRR');
244:
245: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=
246: l_expected_start_date;
247:
248: RETURN l_expected_start_date;
249: END expected_start_date ;

Line 257: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

253: ---------------------------------------------
254: FUNCTION expected_delivery_date(x_resultout OUT NOCOPY VARCHAR2,
255: x_errormsg OUT NOCOPY VARCHAR2) RETURN DATE IS
256:
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

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 282: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

278: END;
279:
280: l_expected_delivery_date := to_date(l_expected_delivery_date, 'DD-MM-RRRR');
281:
282: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=
283: l_expected_delivery_date;
284:
285: RETURN l_expected_delivery_date;
286: END expected_delivery_date ;

Line 294: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

290: ---------------------------------------------
291: FUNCTION expected_funding_date(x_resultout OUT NOCOPY VARCHAR2,
292: x_errormsg OUT NOCOPY VARCHAR2) RETURN DATE IS
293:
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

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 319: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

315: END;
316:
317: l_expected_funding_date := to_date(l_expected_funding_date, 'DD-MM-RRRR');
318:
319: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=
320: l_expected_funding_date;
321:
322: RETURN l_expected_funding_date;
323: END expected_funding_date ;

Line 331: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

327: ---------------------------------------------
328: FUNCTION lease_application_template(x_resultout OUT NOCOPY VARCHAR2,
329: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
330:
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

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 352: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

348: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
349: x_errormsg := sqlerrm;
350: END;
351:
352: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=
353: to_char(l_lease_application_template) ;
354:
355: RETURN to_char(l_lease_application_template );
356: END lease_application_template ;

Line 364: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

360: ---------------------------------------------
361: FUNCTION org_unit(x_resultout OUT NOCOPY VARCHAR2,
362: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
363:
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

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 385: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

381: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
382: x_errormsg := sqlerrm;
383: END;
384:
385: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=
386: to_char(l_org_unit) ;
387:
388: RETURN to_char(l_org_unit );
389: END org_unit ;

Line 397: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

393: ---------------------------------------------
394: FUNCTION prospect_address(x_resultout OUT NOCOPY VARCHAR2,
395: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
396:
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

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 418: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

414: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
415: x_errormsg := sqlerrm;
416: END;
417:
418: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=
419: to_char(l_prospect_address) ;
420:
421: RETURN to_char(l_prospect_address );
422: END prospect_address ;

Line 430: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

426: ---------------------------------------------
427: FUNCTION term_of_deal(x_resultout OUT NOCOPY VARCHAR2,
428: x_errormsg OUT NOCOPY VARCHAR2) RETURN NUMBER IS
429:
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

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 453: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

449: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
450: x_errormsg := sqlerrm;
451: END;
452:
453: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=
454: l_term_of_deal ;
455:
456: RETURN l_term_of_deal;
457: END term_of_deal ;

Line 465: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

461: ---------------------------------------------
462: FUNCTION financial_product(x_resultout OUT NOCOPY VARCHAR2,
463: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
464:
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

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 490: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

486: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
487: x_errormsg := sqlerrm;
488: END;
489:
490: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=
491: to_char(l_financial_product) ;
492:
493: RETURN to_char(l_financial_product);
494: END financial_product ;

Line 502: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

498: ---------------------------------------------
499: FUNCTION item(x_resultout OUT NOCOPY VARCHAR2,
500: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
501:
502: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
503: l_item VARCHAR2(40);
504:
505: CURSOR citem IS
506: SELECT ITEM.CONCATENATED_SEGMENTS CONCATENATED_SEGMENTS, ASSET.ID

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 533: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

529:
530: x_resultout := FND_API.G_RET_STS_SUCCESS;
531:
532: FOR cItemRec IN cItem LOOP
533: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
534: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
535: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
536: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
537: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

Line 534: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

530: x_resultout := FND_API.G_RET_STS_SUCCESS;
531:
532: FOR cItemRec IN cItem LOOP
533: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
534: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
535: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
536: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
537: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
538: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

Line 535: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=

531:
532: FOR cItemRec IN cItem LOOP
533: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
534: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
535: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
536: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
537: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
538: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
539: cItemRec.CONCATENATED_SEGMENTS;

Line 536: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;

532: FOR cItemRec IN cItem LOOP
533: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
534: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
535: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
536: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
537: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
538: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
539: cItemRec.CONCATENATED_SEGMENTS;
540: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value_id :=

Line 537: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

533: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
534: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
535: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
536: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
537: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
538: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
539: cItemRec.CONCATENATED_SEGMENTS;
540: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value_id :=
541: cItemRec.ID;

Line 538: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

534: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
535: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
536: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
537: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
538: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
539: cItemRec.CONCATENATED_SEGMENTS;
540: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value_id :=
541: cItemRec.ID;
542:

Line 540: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value_id :=

536: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
537: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
538: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
539: cItemRec.CONCATENATED_SEGMENTS;
540: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value_id :=
541: cItemRec.ID;
542:
543: ln_seq_number := ln_seq_number + 1;
544: END LOOP;

Line 562: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

558: ---------------------------------------------
559: FUNCTION item_description(x_resultout OUT NOCOPY VARCHAR2,
560: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
561:
562: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
563: l_item_description VARCHAR2(1995);
564:
565: CURSOR citemdesc IS
566: -- ssdeshpa Bug#6689249 start

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 590: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

586:
587: x_resultout := FND_API.G_RET_STS_SUCCESS;
588:
589: FOR cItemDescRec IN cItemDesc LOOP
590: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
591: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
592: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
593: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
594: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

Line 591: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

587: x_resultout := FND_API.G_RET_STS_SUCCESS;
588:
589: FOR cItemDescRec IN cItemDesc LOOP
590: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
591: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
592: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
593: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
594: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
595: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

Line 592: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=

588:
589: FOR cItemDescRec IN cItemDesc LOOP
590: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
591: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
592: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
593: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
594: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
595: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
596: cItemDescRec.description;

Line 593: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;

589: FOR cItemDescRec IN cItemDesc LOOP
590: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
591: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
592: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
593: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
594: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
595: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
596: cItemDescRec.description;
597:

Line 594: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

590: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
591: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
592: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
593: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
594: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
595: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
596: cItemDescRec.description;
597:
598: ln_seq_number := ln_seq_number + 1;

Line 595: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

591: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
592: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
593: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
594: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
595: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
596: cItemDescRec.description;
597:
598: ln_seq_number := ln_seq_number + 1;
599:

Line 618: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

614: ---------------------------------------------
615: FUNCTION item_supplier(x_resultout OUT NOCOPY VARCHAR2,
616: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
617:
618: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
619: l_item_supplier VARCHAR2(120);
620:
621: CURSOR cItemSupp IS
622: -- ssdeshpa Bug# 6689249 start

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 647: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

643:
644: x_resultout := FND_API.G_RET_STS_SUCCESS;
645:
646: FOR cItemSuppRec IN cItemSupp LOOP
647: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
648: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
649: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
650: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
651: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

Line 648: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

644: x_resultout := FND_API.G_RET_STS_SUCCESS;
645:
646: FOR cItemSuppRec IN cItemSupp LOOP
647: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
648: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
649: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
650: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
651: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
652: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

Line 649: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=

645:
646: FOR cItemSuppRec IN cItemSupp LOOP
647: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
648: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
649: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
650: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
651: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
652: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
653: cItemSuppRec.supplier;

Line 650: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;

646: FOR cItemSuppRec IN cItemSupp LOOP
647: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
648: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
649: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
650: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
651: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
652: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
653: cItemSuppRec.supplier;
654:

Line 651: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

647: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
648: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
649: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
650: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
651: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
652: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
653: cItemSuppRec.supplier;
654:
655: ln_seq_number := ln_seq_number + 1;

Line 652: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

648: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
649: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
650: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
651: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
652: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
653: cItemSuppRec.supplier;
654:
655: ln_seq_number := ln_seq_number + 1;
656:

Line 675: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

671: ---------------------------------------------
672: FUNCTION model(x_resultout OUT NOCOPY VARCHAR2,
673: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
674:
675: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
676: l_model VARCHAR2(40);
677:
678: CURSOR cModelNum IS
679: SELECT ASSET_COMP.MODEL_NUMBER MODEL_NUMBER

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 701: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

697:
698: x_resultout := FND_API.G_RET_STS_SUCCESS;
699:
700: FOR cModelNumRec IN cModelNum LOOP
701: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
702: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
703: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
704: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
705: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

Line 702: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

698: x_resultout := FND_API.G_RET_STS_SUCCESS;
699:
700: FOR cModelNumRec IN cModelNum LOOP
701: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
702: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
703: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
704: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
705: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
706: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

Line 703: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=

699:
700: FOR cModelNumRec IN cModelNum LOOP
701: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
702: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
703: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
704: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
705: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
706: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
707: cModelNumRec.model_number;

Line 704: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;

700: FOR cModelNumRec IN cModelNum LOOP
701: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
702: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
703: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
704: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
705: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
706: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
707: cModelNumRec.model_number;
708:

Line 705: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

701: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
702: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
703: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
704: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
705: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
706: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
707: cModelNumRec.model_number;
708:
709: ln_seq_number := ln_seq_number + 1;

Line 706: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

702: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
703: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
704: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
705: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
706: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
707: cModelNumRec.model_number;
708:
709: ln_seq_number := ln_seq_number + 1;
710:

Line 729: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

725: ---------------------------------------------
726: FUNCTION manufacturer(x_resultout OUT NOCOPY VARCHAR2,
727: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
728:
729: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
730: --Bug# 9590286
731: l_manufacturer VARCHAR2(360);
732:
733: CURSOR cMfgName is

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 756: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

752:
753: x_resultout := FND_API.G_RET_STS_SUCCESS;
754:
755: FOR cMfgNameRec IN cMfgName LOOP
756: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
757: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
758: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
759: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
760: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

Line 757: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

753: x_resultout := FND_API.G_RET_STS_SUCCESS;
754:
755: FOR cMfgNameRec IN cMfgName LOOP
756: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
757: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
758: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
759: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
760: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
761: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

Line 758: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=

754:
755: FOR cMfgNameRec IN cMfgName LOOP
756: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
757: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
758: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
759: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
760: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
761: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
762: cMfgNameRec.manufacturer_name;

Line 759: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;

755: FOR cMfgNameRec IN cMfgName LOOP
756: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
757: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
758: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
759: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
760: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
761: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
762: cMfgNameRec.manufacturer_name;
763:

Line 760: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

756: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
757: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
758: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
759: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
760: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
761: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
762: cMfgNameRec.manufacturer_name;
763:
764: ln_seq_number := ln_seq_number + 1;

Line 761: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

757: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
758: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
759: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
760: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
761: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
762: cMfgNameRec.manufacturer_name;
763:
764: ln_seq_number := ln_seq_number + 1;
765:

Line 784: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

780: ---------------------------------------------
781: FUNCTION year_of_manufacture(x_resultout OUT NOCOPY VARCHAR2,
782: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
783:
784: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
785: l_year_of_manufacture NUMBER;
786:
787: CURSOR cYearMfg IS
788: SELECT ASSET_COMP.YEAR_MANUFACTURED YEAR_MANUFACTURED

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 809: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

805: BEGIN
806: x_resultout := FND_API.G_RET_STS_SUCCESS;
807:
808: FOR cYearMfgRec IN cYearMfg LOOP
809: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
810: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
811: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
812: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
813: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

Line 810: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

806: x_resultout := FND_API.G_RET_STS_SUCCESS;
807:
808: FOR cYearMfgRec IN cYearMfg LOOP
809: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
810: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
811: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
812: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
813: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
814: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

Line 811: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=

807:
808: FOR cYearMfgRec IN cYearMfg LOOP
809: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
810: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
811: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
812: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
813: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
814: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
815: cYearMfgRec.year_manufactured;

Line 812: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;

808: FOR cYearMfgRec IN cYearMfg LOOP
809: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
810: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
811: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
812: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
813: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
814: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
815: cYearMfgRec.year_manufactured;
816:

Line 813: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

809: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
810: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
811: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
812: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
813: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
814: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
815: cYearMfgRec.year_manufactured;
816:
817: ln_seq_number := ln_seq_number + 1;

Line 814: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

810: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
811: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
812: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
813: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
814: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
815: cYearMfgRec.year_manufactured;
816:
817: ln_seq_number := ln_seq_number + 1;
818:

Line 837: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

833: ---------------------------------------------
834: FUNCTION no_of_units(x_resultout OUT NOCOPY VARCHAR2,
835: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
836:
837: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
838: l_no_of_units NUMBER;
839:
840: CURSOR cNoOfUnits IS
841: SELECT ASSET_COMP.NUMBER_OF_UNITS NUMBER_OF_UNITS

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 861: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

857: BEGIN
858: x_resultout := FND_API.G_RET_STS_SUCCESS;
859:
860: FOR cNoOfUnitsRec IN cNoOfUnits LOOP
861: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
862: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
863: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
864: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
865: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

Line 862: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

858: x_resultout := FND_API.G_RET_STS_SUCCESS;
859:
860: FOR cNoOfUnitsRec IN cNoOfUnits LOOP
861: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
862: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
863: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
864: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
865: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
866: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

Line 863: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=

859:
860: FOR cNoOfUnitsRec IN cNoOfUnits LOOP
861: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
862: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
863: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
864: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
865: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
866: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
867: cNoOfUnitsRec.number_of_units;

Line 864: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;

860: FOR cNoOfUnitsRec IN cNoOfUnits LOOP
861: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
862: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
863: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
864: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
865: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
866: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
867: cNoOfUnitsRec.number_of_units;
868:

Line 865: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

861: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
862: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
863: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
864: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
865: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
866: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
867: cNoOfUnitsRec.number_of_units;
868:
869: ln_seq_number := ln_seq_number + 1;

Line 866: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

862: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
863: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
864: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
865: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
866: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
867: cNoOfUnitsRec.number_of_units;
868:
869: ln_seq_number := ln_seq_number + 1;
870:

Line 889: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

885: ---------------------------------------------
886: FUNCTION unit_cost(x_resultout OUT NOCOPY VARCHAR2,
887: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
888:
889: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
890: l_unit_cost NUMBER;
891:
892: CURSOR cUnitCost IS
893: SELECT ASSET_COMP.UNIT_COST UNIT_COST

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 915: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

911: BEGIN
912: x_resultout := FND_API.G_RET_STS_SUCCESS;
913:
914: FOR cUnitCostRec IN cUnitCost LOOP
915: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
916: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
917: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
918: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
919: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

Line 916: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

912: x_resultout := FND_API.G_RET_STS_SUCCESS;
913:
914: FOR cUnitCostRec IN cUnitCost LOOP
915: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
916: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
917: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
918: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
919: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
920: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

Line 917: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=

913:
914: FOR cUnitCostRec IN cUnitCost LOOP
915: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
916: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
917: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
918: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
919: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
920: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
921: cUnitCostRec.unit_cost;

Line 918: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;

914: FOR cUnitCostRec IN cUnitCost LOOP
915: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
916: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
917: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
918: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
919: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
920: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
921: cUnitCostRec.unit_cost;
922:

Line 919: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

915: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
916: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
917: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
918: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
919: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
920: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
921: cUnitCostRec.unit_cost;
922:
923: ln_seq_number := ln_seq_number + 1;

Line 920: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

916: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
917: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
918: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
919: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
920: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
921: cUnitCostRec.unit_cost;
922:
923: ln_seq_number := ln_seq_number + 1;
924:

Line 943: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

939: ---------------------------------------------
940: FUNCTION install_site(x_resultout OUT NOCOPY VARCHAR2,
941: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
942:
943: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
944: l_install_site VARCHAR2(30);
945:
946: CURSOR cInstallSite IS
947: SELECT PARTY_SITE.PARTY_SITE_NUMBER PARTY_SITE_NUMBER

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 967: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

963: BEGIN
964: x_resultout := FND_API.G_RET_STS_SUCCESS;
965:
966: FOR cInstallSiteRec IN cInstallSite LOOP
967: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
968: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
969: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
970: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
971: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

Line 968: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

964: x_resultout := FND_API.G_RET_STS_SUCCESS;
965:
966: FOR cInstallSiteRec IN cInstallSite LOOP
967: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
968: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
969: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
970: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
971: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
972: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

Line 969: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=

965:
966: FOR cInstallSiteRec IN cInstallSite LOOP
967: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
968: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
969: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
970: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
971: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
972: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
973: cInstallSiteRec.party_site_number;

Line 970: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;

966: FOR cInstallSiteRec IN cInstallSite LOOP
967: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
968: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
969: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
970: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
971: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
972: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
973: cInstallSiteRec.party_site_number;
974:

Line 971: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

967: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
968: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
969: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
970: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
971: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
972: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
973: cInstallSiteRec.party_site_number;
974:
975: ln_seq_number := ln_seq_number + 1;

Line 972: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

968: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
969: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
970: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
971: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
972: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
973: cInstallSiteRec.party_site_number;
974:
975: ln_seq_number := ln_seq_number + 1;
976:

Line 995: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

991: ---------------------------------------------
992: FUNCTION usage_of_equipment(x_resultout OUT NOCOPY VARCHAR2,
993: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
994:
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

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 1021: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

1017: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1018: x_errormsg := sqlerrm;
1019: END;
1020:
1021: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=
1022: to_char(l_usage_of_equipment) ;
1023:
1024: RETURN to_char(l_usage_of_equipment );
1025: END usage_of_equipment ;

Line 1033: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

1029: ---------------------------------------------
1030: FUNCTION usage_industry(x_resultout OUT NOCOPY VARCHAR2,
1031: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
1032:
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

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 1070: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

1066: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1067: x_errormsg := sqlerrm;
1068: END;
1069:
1070: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=
1071: to_char(l_usage_industry) ;
1072:
1073: RETURN to_char(l_usage_industry);
1074: END usage_industry ;

Line 1082: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

1078: ---------------------------------------------
1079: FUNCTION usage_category(x_resultout OUT NOCOPY VARCHAR2,
1080: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
1081:
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

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 1106: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

1102: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1103: x_errormsg := sqlerrm;
1104: END;
1105:
1106: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=
1107: to_char(l_usage_category) ;
1108:
1109: RETURN to_char(l_usage_category);
1110: END usage_category ;

Line 1118: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

1114: ---------------------------------------------
1115: FUNCTION usage_amount(x_resultout OUT NOCOPY VARCHAR2,
1116: x_errormsg OUT NOCOPY VARCHAR2) RETURN NUMBER IS
1117:
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

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 1151: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

1147: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1148: x_errormsg := sqlerrm;
1149: END;
1150:
1151: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=
1152: l_usage_amount;
1153:
1154: RETURN l_usage_amount;
1155: END usage_amount ;

Line 1163: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

1159: ---------------------------------------------
1160: FUNCTION add_on_item(x_resultout OUT NOCOPY VARCHAR2,
1161: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
1162:
1163: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1164: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
1165:
1166: l_add_on_item VARCHAR2(40);
1167:

Line 1164: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);

1160: FUNCTION add_on_item(x_resultout OUT NOCOPY VARCHAR2,
1161: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
1162:
1163: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1164: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
1165:
1166: l_add_on_item VARCHAR2(40);
1167:
1168: CURSOR cAddOnItem IS

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 1184: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

1180: BEGIN
1181: x_resultout := FND_API.G_RET_STS_SUCCESS;
1182:
1183: FOR cAddOnItemRec IN cAddOnItem LOOP
1184: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1185: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1186: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
1187: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1188: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

Line 1185: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

1181: x_resultout := FND_API.G_RET_STS_SUCCESS;
1182:
1183: FOR cAddOnItemRec IN cAddOnItem LOOP
1184: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1185: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1186: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
1187: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1188: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1189: cAddOnItemRec.add_on_item;

Line 1186: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;

1182:
1183: FOR cAddOnItemRec IN cAddOnItem LOOP
1184: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1185: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1186: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
1187: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1188: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1189: cAddOnItemRec.add_on_item;
1190:

Line 1187: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

1183: FOR cAddOnItemRec IN cAddOnItem LOOP
1184: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1185: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1186: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
1187: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1188: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1189: cAddOnItemRec.add_on_item;
1190:
1191: ln_seq_number := ln_seq_number + 1;

Line 1188: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

1184: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1185: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1186: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
1187: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1188: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1189: cAddOnItemRec.add_on_item;
1190:
1191: ln_seq_number := ln_seq_number + 1;
1192: END LOOP;

Line 1211: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

1207: ---------------------------------------------
1208: FUNCTION add_on_item_description(x_resultout OUT NOCOPY VARCHAR2,
1209: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
1210:
1211: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1212: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
1213:
1214: l_add_on_item_description VARCHAR2(1995);
1215:

Line 1212: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);

1208: FUNCTION add_on_item_description(x_resultout OUT NOCOPY VARCHAR2,
1209: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
1210:
1211: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1212: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
1213:
1214: l_add_on_item_description VARCHAR2(1995);
1215:
1216: CURSOR cItemDescription IS

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 1233: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

1229:
1230: x_resultout := FND_API.G_RET_STS_SUCCESS;
1231:
1232: FOR cItemDescriptionRec IN cItemDescription LOOP
1233: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1234: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1235: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
1236: l_asset_id;
1237: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

Line 1234: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

1230: x_resultout := FND_API.G_RET_STS_SUCCESS;
1231:
1232: FOR cItemDescriptionRec IN cItemDescription LOOP
1233: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1234: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1235: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
1236: l_asset_id;
1237: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1238: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

Line 1235: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=

1231:
1232: FOR cItemDescriptionRec IN cItemDescription LOOP
1233: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1234: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1235: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
1236: l_asset_id;
1237: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1238: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1239: cItemDescriptionRec.add_on_item;

Line 1237: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

1233: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1234: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1235: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
1236: l_asset_id;
1237: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1238: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1239: cItemDescriptionRec.add_on_item;
1240:
1241: ln_seq_number := ln_seq_number + 1;

Line 1238: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

1234: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1235: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
1236: l_asset_id;
1237: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1238: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1239: cItemDescriptionRec.add_on_item;
1240:
1241: ln_seq_number := ln_seq_number + 1;
1242:

Line 1261: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

1257: ---------------------------------------------
1258: FUNCTION add_on_item_supplier(x_resultout OUT NOCOPY VARCHAR2,
1259: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
1260:
1261: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1262: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
1263:
1264: l_add_on_item_supplier VARCHAR2(30);
1265:

Line 1262: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);

1258: FUNCTION add_on_item_supplier(x_resultout OUT NOCOPY VARCHAR2,
1259: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
1260:
1261: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1262: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
1263:
1264: l_add_on_item_supplier VARCHAR2(30);
1265:
1266: CURSOR cItemSupplier IS

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 1281: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

1277: BEGIN
1278: x_resultout := FND_API.G_RET_STS_SUCCESS;
1279:
1280: FOR cItemSupplierRec IN cItemSupplier LOOP
1281: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1282: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1283: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
1284: l_asset_id;
1285: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

Line 1282: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

1278: x_resultout := FND_API.G_RET_STS_SUCCESS;
1279:
1280: FOR cItemSupplierRec IN cItemSupplier LOOP
1281: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1282: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1283: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
1284: l_asset_id;
1285: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1286: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

Line 1283: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=

1279:
1280: FOR cItemSupplierRec IN cItemSupplier LOOP
1281: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1282: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1283: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
1284: l_asset_id;
1285: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1286: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1287: cItemSupplierRec.item_supplier;

Line 1285: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

1281: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1282: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1283: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
1284: l_asset_id;
1285: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1286: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1287: cItemSupplierRec.item_supplier;
1288:
1289: ln_seq_number := ln_seq_number + 1;

Line 1286: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

1282: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1283: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
1284: l_asset_id;
1285: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1286: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1287: cItemSupplierRec.item_supplier;
1288:
1289: ln_seq_number := ln_seq_number + 1;
1290:

Line 1309: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

1305: ---------------------------------------------
1306: FUNCTION add_on_item_model(x_resultout OUT NOCOPY VARCHAR2,
1307: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
1308:
1309: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1310: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
1311:
1312: l_add_on_item_model VARCHAR2(40);
1313:

Line 1310: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);

1306: FUNCTION add_on_item_model(x_resultout OUT NOCOPY VARCHAR2,
1307: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
1308:
1309: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1310: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
1311:
1312: l_add_on_item_model VARCHAR2(40);
1313:
1314: CURSOR cItemModel IS

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 1330: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

1326:
1327: x_resultout := FND_API.G_RET_STS_SUCCESS;
1328:
1329: FOR cItemModelRec IN cItemModel LOOP
1330: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1331: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1332: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
1333: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1334: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

Line 1331: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

1327: x_resultout := FND_API.G_RET_STS_SUCCESS;
1328:
1329: FOR cItemModelRec IN cItemModel LOOP
1330: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1331: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1332: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
1333: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1334: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1335: cItemModelRec.model_number;

Line 1332: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;

1328:
1329: FOR cItemModelRec IN cItemModel LOOP
1330: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1331: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1332: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
1333: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1334: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1335: cItemModelRec.model_number;
1336:

Line 1333: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

1329: FOR cItemModelRec IN cItemModel LOOP
1330: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1331: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1332: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
1333: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1334: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1335: cItemModelRec.model_number;
1336:
1337: ln_seq_number := ln_seq_number + 1;

Line 1334: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

1330: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1331: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1332: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
1333: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1334: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1335: cItemModelRec.model_number;
1336:
1337: ln_seq_number := ln_seq_number + 1;
1338:

Line 1357: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

1353: ---------------------------------------------
1354: FUNCTION add_on_item_manufacturer(x_resultout OUT NOCOPY VARCHAR2,
1355: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
1356:
1357: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1358: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
1359:
1360: --Bug# 9590286
1361: l_add_on_item_manufacturer VARCHAR2(360);

Line 1358: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);

1354: FUNCTION add_on_item_manufacturer(x_resultout OUT NOCOPY VARCHAR2,
1355: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
1356:
1357: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1358: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
1359:
1360: --Bug# 9590286
1361: l_add_on_item_manufacturer VARCHAR2(360);
1362:

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 1378: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

1374:
1375: x_resultout := FND_API.G_RET_STS_SUCCESS;
1376:
1377: FOR cItemMfgRec IN cItemMfg LOOP
1378: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1379: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1380: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
1381: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
1382: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

Line 1379: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

1375: x_resultout := FND_API.G_RET_STS_SUCCESS;
1376:
1377: FOR cItemMfgRec IN cItemMfg LOOP
1378: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1379: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1380: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
1381: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
1382: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1383: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

Line 1380: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=

1376:
1377: FOR cItemMfgRec IN cItemMfg LOOP
1378: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1379: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1380: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
1381: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
1382: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1383: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1384: cItemMfgRec.manufacturer_name;

Line 1381: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;

1377: FOR cItemMfgRec IN cItemMfg LOOP
1378: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1379: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1380: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
1381: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
1382: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1383: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1384: cItemMfgRec.manufacturer_name;
1385:

Line 1382: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

1378: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1379: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1380: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
1381: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
1382: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1383: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1384: cItemMfgRec.manufacturer_name;
1385:
1386: ln_seq_number := ln_seq_number + 1;

Line 1383: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

1379: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1380: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
1381: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
1382: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1383: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1384: cItemMfgRec.manufacturer_name;
1385:
1386: ln_seq_number := ln_seq_number + 1;
1387:

Line 1406: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

1402: ---------------------------------------------
1403: FUNCTION add_on_item_amount(x_resultout OUT NOCOPY VARCHAR2,
1404: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
1405:
1406: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1407: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
1408:
1409: l_add_on_item_amount NUMBER;
1410:

Line 1407: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);

1403: FUNCTION add_on_item_amount(x_resultout OUT NOCOPY VARCHAR2,
1404: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
1405:
1406: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1407: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
1408:
1409: l_add_on_item_amount NUMBER;
1410:
1411: CURSOR cAddOnItemAmount IS

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 1426: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

1422:
1423: x_resultout := FND_API.G_RET_STS_SUCCESS;
1424:
1425: FOR cAddOnItemAmountRec IN cAddOnItemAmount LOOP
1426: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1427: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1428: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
1429: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1430: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

Line 1427: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

1423: x_resultout := FND_API.G_RET_STS_SUCCESS;
1424:
1425: FOR cAddOnItemAmountRec IN cAddOnItemAmount LOOP
1426: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1427: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1428: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
1429: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1430: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1431: cAddOnItemAmountRec.unit_cost;

Line 1428: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;

1424:
1425: FOR cAddOnItemAmountRec IN cAddOnItemAmount LOOP
1426: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1427: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1428: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
1429: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1430: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1431: cAddOnItemAmountRec.unit_cost;
1432:

Line 1429: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

1425: FOR cAddOnItemAmountRec IN cAddOnItemAmount LOOP
1426: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1427: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1428: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
1429: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1430: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1431: cAddOnItemAmountRec.unit_cost;
1432:
1433: ln_seq_number := ln_seq_number + 1;

Line 1430: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

1426: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1427: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1428: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
1429: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1430: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1431: cAddOnItemAmountRec.unit_cost;
1432:
1433: ln_seq_number := ln_seq_number + 1;
1434:

Line 1453: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

1449: ---------------------------------------------
1450: FUNCTION asset_residual_value(x_resultout OUT NOCOPY VARCHAR2,
1451: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
1452:
1453: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1454: l_add_on_item_residual_values NUMBER;
1455:
1456: CURSOR cItemResVal IS
1457: SELECT NVL(ASSET.END_OF_TERM_VALUE,ASSET.END_OF_TERM_VALUE_DEFAULT) END_OF_TERM_VALUE

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 1475: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

1471:
1472: x_resultout := FND_API.G_RET_STS_SUCCESS;
1473:
1474: FOR cItemResValRec IN cItemResVal LOOP
1475: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1476: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1477: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
1478: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
1479: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

Line 1476: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

1472: x_resultout := FND_API.G_RET_STS_SUCCESS;
1473:
1474: FOR cItemResValRec IN cItemResVal LOOP
1475: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1476: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1477: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
1478: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
1479: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1480: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

Line 1477: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=

1473:
1474: FOR cItemResValRec IN cItemResVal LOOP
1475: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1476: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1477: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
1478: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
1479: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1480: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1481: cItemResValRec.END_OF_TERM_VALUE;

Line 1478: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;

1474: FOR cItemResValRec IN cItemResVal LOOP
1475: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1476: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1477: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
1478: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
1479: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1480: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1481: cItemResValRec.END_OF_TERM_VALUE;
1482:

Line 1479: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

1475: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1476: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1477: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
1478: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
1479: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1480: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1481: cItemResValRec.END_OF_TERM_VALUE;
1482:
1483: ln_seq_number := ln_seq_number + 1;

Line 1480: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

1476: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1477: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
1478: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
1479: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1480: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1481: cItemResValRec.END_OF_TERM_VALUE;
1482:
1483: ln_seq_number := ln_seq_number + 1;
1484:

Line 1503: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

1499: ---------------------------------------------
1500: FUNCTION down_payment_amount(x_resultout OUT NOCOPY VARCHAR2,
1501: x_errormsg OUT NOCOPY VARCHAR2) RETURN NUMBER IS
1502:
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

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 1532: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

1528: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1529: x_errormsg := sqlerrm;
1530: END;
1531:
1532: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=
1533: l_down_payment_amount;
1534: RETURN l_down_payment_amount;
1535: END down_payment_amount ;
1536:

Line 1543: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

1539: ---------------------------------------------
1540: FUNCTION subsidy_amount(x_resultout OUT NOCOPY VARCHAR2,
1541: x_errormsg OUT NOCOPY VARCHAR2) RETURN NUMBER IS
1542:
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

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 1572: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

1568: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1569: x_errormsg := sqlerrm;
1570: END;
1571:
1572: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=
1573: l_subsidy_amount ;
1574:
1575: RETURN l_subsidy_amount;
1576: END subsidy_amount ;

Line 1584: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

1580: ---------------------------------------------
1581: FUNCTION trade_in_amount(x_resultout OUT NOCOPY VARCHAR2,
1582: x_errormsg OUT NOCOPY VARCHAR2) RETURN NUMBER IS
1583:
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

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 1613: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

1609: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1610: x_errormsg := sqlerrm;
1611: END;
1612:
1613: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=
1614: l_trade_in_amount;
1615:
1616: RETURN l_trade_in_amount;
1617: END trade_in_amount ;

Line 1625: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

1621: ---------------------------------------------
1622: FUNCTION trade_in_asset_number(x_resultout OUT NOCOPY VARCHAR2,
1623: x_errormsg OUT NOCOPY VARCHAR2) RETURN NUMBER IS
1624:
1625: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1626: l_trade_in_asset_number VARCHAR2(15);
1627:
1628: CURSOR cAssetNumber IS
1629: SELECT ASSET.ASSET_NUMBER

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 1651: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

1647: x_resultout := FND_API.G_RET_STS_SUCCESS;
1648:
1649: FOR cAssetNumberRec IN cAssetNumber
1650: LOOP
1651: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1652: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1653: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
1654: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
1655: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

Line 1652: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

1648:
1649: FOR cAssetNumberRec IN cAssetNumber
1650: LOOP
1651: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1652: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1653: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
1654: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
1655: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1656: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

Line 1653: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=

1649: FOR cAssetNumberRec IN cAssetNumber
1650: LOOP
1651: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1652: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1653: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
1654: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
1655: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1656: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1657: cAssetNumberRec.ASSET_NUMBER;

Line 1654: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;

1650: LOOP
1651: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1652: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1653: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
1654: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
1655: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1656: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1657: cAssetNumberRec.ASSET_NUMBER;
1658:

Line 1655: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

1651: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1652: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1653: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
1654: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
1655: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1656: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1657: cAssetNumberRec.ASSET_NUMBER;
1658:
1659: ln_seq_number := ln_seq_number + 1;

Line 1656: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

1652: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1653: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
1654: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
1655: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1656: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1657: cAssetNumberRec.ASSET_NUMBER;
1658:
1659: ln_seq_number := ln_seq_number + 1;
1660:

Line 1680: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

1676: ---------------------------------------------
1677: FUNCTION pmnt_frequency(x_resultout OUT NOCOPY VARCHAR2,
1678: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
1679:
1680: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1681: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
1682:
1683: l_pmnt_frequency VARCHAR2(30);
1684:

Line 1681: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);

1677: FUNCTION pmnt_frequency(x_resultout OUT NOCOPY VARCHAR2,
1678: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
1679:
1680: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1681: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
1682:
1683: l_pmnt_frequency VARCHAR2(30);
1684:
1685: cursor cPmntFreq is

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 1752: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

1748: x_resultout := FND_API.G_RET_STS_SUCCESS;
1749:
1750: FOR cPmntFreqRec IN cPmntFreq
1751: LOOP
1752: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1753: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1754: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
1755: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1756: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

Line 1753: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

1749:
1750: FOR cPmntFreqRec IN cPmntFreq
1751: LOOP
1752: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1753: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1754: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
1755: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1756: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1757: cPmntFreqRec.frequency;

Line 1754: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;

1750: FOR cPmntFreqRec IN cPmntFreq
1751: LOOP
1752: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1753: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1754: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
1755: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1756: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1757: cPmntFreqRec.frequency;
1758:

Line 1755: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

1751: LOOP
1752: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1753: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1754: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
1755: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1756: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1757: cPmntFreqRec.frequency;
1758:
1759: ln_seq_number := ln_seq_number + 1;

Line 1756: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

1752: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1753: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1754: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
1755: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1756: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1757: cPmntFreqRec.frequency;
1758:
1759: ln_seq_number := ln_seq_number + 1;
1760:

Line 1779: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

1775: ---------------------------------------------
1776: FUNCTION pmnt_arrears_yn(x_resultout OUT NOCOPY VARCHAR2,
1777: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
1778:
1779: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1780: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
1781:
1782: l_pmnt_arrears_yn VARCHAR2(3);
1783:

Line 1780: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);

1776: FUNCTION pmnt_arrears_yn(x_resultout OUT NOCOPY VARCHAR2,
1777: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
1778:
1779: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1780: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
1781:
1782: l_pmnt_arrears_yn VARCHAR2(3);
1783:
1784: cursor cPmntArrYN is

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 1849: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

1845: x_resultout := FND_API.G_RET_STS_SUCCESS;
1846:
1847: FOR cPmntArrYNRec IN cPmntArrYN
1848: LOOP
1849: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1850: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1851: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
1852: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1853: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

Line 1850: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

1846:
1847: FOR cPmntArrYNRec IN cPmntArrYN
1848: LOOP
1849: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1850: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1851: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
1852: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1853: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1854: cPmntArrYNRec.Arrears;

Line 1851: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;

1847: FOR cPmntArrYNRec IN cPmntArrYN
1848: LOOP
1849: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1850: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1851: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
1852: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1853: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1854: cPmntArrYNRec.Arrears;
1855:

Line 1852: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

1848: LOOP
1849: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1850: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1851: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
1852: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1853: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1854: cPmntArrYNRec.Arrears;
1855:
1856: ln_seq_number := ln_seq_number + 1;

Line 1853: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

1849: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1850: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1851: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
1852: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1853: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1854: cPmntArrYNRec.Arrears;
1855:
1856: ln_seq_number := ln_seq_number + 1;
1857:

Line 1877: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

1873: ---------------------------------------------
1874: FUNCTION pmnt_periods(x_resultout OUT NOCOPY VARCHAR2,
1875: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
1876:
1877: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1878: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
1879:
1880: l_pmnt_periods NUMBER;
1881:

Line 1878: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);

1874: FUNCTION pmnt_periods(x_resultout OUT NOCOPY VARCHAR2,
1875: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
1876:
1877: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1878: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
1879:
1880: l_pmnt_periods NUMBER;
1881:
1882: cursor cPmntPeriods is

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 1945: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

1941: x_resultout := FND_API.G_RET_STS_SUCCESS;
1942:
1943: FOR cPmntPeriodsRec IN cPmntPeriods
1944: LOOP
1945: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1946: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1947: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
1948: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1949: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

Line 1946: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

1942:
1943: FOR cPmntPeriodsRec IN cPmntPeriods
1944: LOOP
1945: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1946: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1947: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
1948: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1949: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1950: cPmntPeriodsRec.number_of_periods;

Line 1947: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;

1943: FOR cPmntPeriodsRec IN cPmntPeriods
1944: LOOP
1945: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1946: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1947: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
1948: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1949: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1950: cPmntPeriodsRec.number_of_periods;
1951:

Line 1948: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

1944: LOOP
1945: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1946: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1947: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
1948: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1949: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1950: cPmntPeriodsRec.number_of_periods;
1951:
1952: ln_seq_number := ln_seq_number + 1;

Line 1949: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

1945: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1946: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
1947: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
1948: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
1949: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
1950: cPmntPeriodsRec.number_of_periods;
1951:
1952: ln_seq_number := ln_seq_number + 1;
1953:

Line 1973: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

1969: ---------------------------------------------
1970: FUNCTION pmnt_amounts(x_resultout OUT NOCOPY VARCHAR2,
1971: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
1972:
1973: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1974: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
1975:
1976: l_pmnt_amounts NUMBER;
1977:

Line 1974: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);

1970: FUNCTION pmnt_amounts(x_resultout OUT NOCOPY VARCHAR2,
1971: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
1972:
1973: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1974: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
1975:
1976: l_pmnt_amounts NUMBER;
1977:
1978: cursor cPmntAmount is

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 2041: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

2037: x_resultout := FND_API.G_RET_STS_SUCCESS;
2038:
2039: FOR cPmntAmountRec IN cPmntAmount
2040: LOOP
2041: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2042: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2043: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
2044: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2045: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

Line 2042: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

2038:
2039: FOR cPmntAmountRec IN cPmntAmount
2040: LOOP
2041: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2042: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2043: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
2044: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2045: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
2046: cPmntAmountRec.amount;

Line 2043: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;

2039: FOR cPmntAmountRec IN cPmntAmount
2040: LOOP
2041: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2042: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2043: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
2044: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2045: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
2046: cPmntAmountRec.amount;
2047:

Line 2044: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

2040: LOOP
2041: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2042: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2043: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
2044: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2045: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
2046: cPmntAmountRec.amount;
2047:
2048: ln_seq_number := ln_seq_number + 1;

Line 2045: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

2041: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2042: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2043: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
2044: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2045: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
2046: cPmntAmountRec.amount;
2047:
2048: ln_seq_number := ln_seq_number + 1;
2049:

Line 2069: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

2065: ---------------------------------------------
2066: FUNCTION pmnt_start_date(x_resultout OUT NOCOPY VARCHAR2,
2067: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
2068:
2069: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
2070: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
2071:
2072: l_pmnt_start_date DATE;
2073:

Line 2070: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);

2066: FUNCTION pmnt_start_date(x_resultout OUT NOCOPY VARCHAR2,
2067: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
2068:
2069: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
2070: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
2071:
2072: l_pmnt_start_date DATE;
2073:
2074: cursor cPmntStartDate is

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 2138: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

2134: x_resultout := FND_API.G_RET_STS_SUCCESS;
2135:
2136: FOR cPmntStartDateRec IN cPmntStartDate
2137: LOOP
2138: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2139: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2140: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
2141: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2142: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

Line 2139: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

2135:
2136: FOR cPmntStartDateRec IN cPmntStartDate
2137: LOOP
2138: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2139: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2140: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
2141: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2142: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
2143: cPmntStartDateRec.start_date;

Line 2140: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;

2136: FOR cPmntStartDateRec IN cPmntStartDate
2137: LOOP
2138: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2139: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2140: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
2141: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2142: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
2143: cPmntStartDateRec.start_date;
2144:

Line 2141: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

2137: LOOP
2138: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2139: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2140: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
2141: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2142: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
2143: cPmntStartDateRec.start_date;
2144:
2145: ln_seq_number := ln_seq_number + 1;

Line 2142: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

2138: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2139: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2140: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
2141: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2142: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
2143: cPmntStartDateRec.start_date;
2144:
2145: ln_seq_number := ln_seq_number + 1;
2146:

Line 2165: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

2161: ---------------------------------------------
2162: FUNCTION payment_structure(x_resultout OUT NOCOPY VARCHAR2,
2163: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
2164:
2165: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
2166: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
2167:
2168: l_payment_structure VARCHAR2(5) := 'LEVEL';
2169:

Line 2166: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);

2162: FUNCTION payment_structure(x_resultout OUT NOCOPY VARCHAR2,
2163: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
2164:
2165: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
2166: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
2167:
2168: l_payment_structure VARCHAR2(5) := 'LEVEL';
2169:
2170: ln_seq_number NUMBER :=1;

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 2178: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

2174: BEGIN
2175:
2176: x_resultout := FND_API.G_RET_STS_SUCCESS;
2177:
2178: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2179: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2180: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
2181: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2182: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

Line 2179: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

2175:
2176: x_resultout := FND_API.G_RET_STS_SUCCESS;
2177:
2178: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2179: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2180: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
2181: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2182: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
2183: l_payment_structure;

Line 2180: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;

2176: x_resultout := FND_API.G_RET_STS_SUCCESS;
2177:
2178: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2179: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2180: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
2181: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2182: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
2183: l_payment_structure;
2184:

Line 2181: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

2177:
2178: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2179: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2180: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
2181: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2182: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
2183: l_payment_structure;
2184:
2185:

Line 2182: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

2178: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2179: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2180: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
2181: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2182: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
2183: l_payment_structure;
2184:
2185:
2186: RETURN NULL;

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 2282: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

2278: ---------------------------------------------
2279: FUNCTION pmnt_end_date(x_resultout OUT NOCOPY VARCHAR2,
2280: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
2281:
2282: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
2283: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
2284:
2285: l_pmnt_end_date DATE;
2286:

Line 2283: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);

2279: FUNCTION pmnt_end_date(x_resultout OUT NOCOPY VARCHAR2,
2280: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
2281:
2282: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
2283: l_asset_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value_id);
2284:
2285: l_pmnt_end_date DATE;
2286:
2287: cursor c_level_data is

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 2403: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

2399: END IF;
2400:
2401: FOR j IN cf_level_tbl.FIRST .. cf_level_tbl.LAST LOOP
2402: IF cf_level_tbl.EXISTS(j) THEN
2403: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2404: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2405: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
2406: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2407: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value := cf_level_tbl(j).start_date;

Line 2404: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

2400:
2401: FOR j IN cf_level_tbl.FIRST .. cf_level_tbl.LAST LOOP
2402: IF cf_level_tbl.EXISTS(j) THEN
2403: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2404: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2405: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
2406: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2407: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value := cf_level_tbl(j).start_date;
2408:

Line 2405: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;

2401: FOR j IN cf_level_tbl.FIRST .. cf_level_tbl.LAST LOOP
2402: IF cf_level_tbl.EXISTS(j) THEN
2403: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2404: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2405: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
2406: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2407: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value := cf_level_tbl(j).start_date;
2408:
2409: ln_seq_number := ln_seq_number + 1;

Line 2406: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

2402: IF cf_level_tbl.EXISTS(j) THEN
2403: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2404: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2405: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
2406: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2407: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value := cf_level_tbl(j).start_date;
2408:
2409: ln_seq_number := ln_seq_number + 1;
2410: END IF;

Line 2407: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value := cf_level_tbl(j).start_date;

2403: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2404: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2405: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;
2406: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2407: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value := cf_level_tbl(j).start_date;
2408:
2409: ln_seq_number := ln_seq_number + 1;
2410: END IF;
2411: END LOOP;

Line 2438: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

2434: ---------------------------------------------
2435: FUNCTION fee_name (x_resultout OUT NOCOPY VARCHAR2,
2436: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
2437:
2438: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
2439: l_fee_name VARCHAR2(30);
2440: -- gboomina:Bug 7110500 :Modified cursor to use correct view
2441: CURSOR cFeeName IS
2442: /*

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 2476: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

2472: BEGIN
2473: x_resultout := FND_API.G_RET_STS_SUCCESS;
2474:
2475: FOR cFeeNameRec IN cFeeName LOOP
2476: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2477: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2478: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
2479: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
2480: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

Line 2477: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

2473: x_resultout := FND_API.G_RET_STS_SUCCESS;
2474:
2475: FOR cFeeNameRec IN cFeeName LOOP
2476: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2477: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2478: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
2479: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
2480: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2481: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

Line 2478: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=

2474:
2475: FOR cFeeNameRec IN cFeeName LOOP
2476: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2477: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2478: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
2479: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
2480: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2481: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
2482: cFeeNameRec.fee_name;

Line 2479: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;

2475: FOR cFeeNameRec IN cFeeName LOOP
2476: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2477: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2478: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
2479: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
2480: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2481: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
2482: cFeeNameRec.fee_name;
2483:

Line 2480: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

2476: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2477: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2478: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
2479: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
2480: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2481: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
2482: cFeeNameRec.fee_name;
2483:
2484: ln_seq_number := ln_seq_number + 1;

Line 2481: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

2477: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2478: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
2479: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
2480: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2481: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
2482: cFeeNameRec.fee_name;
2483:
2484: ln_seq_number := ln_seq_number + 1;
2485:

Line 2505: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

2501: ---------------------------------------------
2502: FUNCTION fee_type(x_resultout OUT NOCOPY VARCHAR2,
2503: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
2504:
2505: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
2506: l_fee_type VARCHAR2(30);
2507:
2508: CURSOR cFeeType IS
2509: SELECT FEES.FEE_TYPE FEE_TYPE

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 2528: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

2524: BEGIN
2525: x_resultout := FND_API.G_RET_STS_SUCCESS;
2526:
2527: FOR cFeeTypeRec IN cFeeType LOOP
2528: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2529: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2530: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
2531: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
2532: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

Line 2529: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

2525: x_resultout := FND_API.G_RET_STS_SUCCESS;
2526:
2527: FOR cFeeTypeRec IN cFeeType LOOP
2528: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2529: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2530: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
2531: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
2532: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2533: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

Line 2530: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=

2526:
2527: FOR cFeeTypeRec IN cFeeType LOOP
2528: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2529: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2530: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
2531: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
2532: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2533: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
2534: cFeeTypeRec.fee_type;

Line 2531: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;

2527: FOR cFeeTypeRec IN cFeeType LOOP
2528: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2529: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2530: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
2531: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
2532: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2533: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
2534: cFeeTypeRec.fee_type;
2535:

Line 2532: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

2528: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2529: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2530: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
2531: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
2532: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2533: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
2534: cFeeTypeRec.fee_type;
2535:
2536: ln_seq_number := ln_seq_number + 1;

Line 2533: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

2529: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2530: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
2531: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
2532: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2533: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
2534: cFeeTypeRec.fee_type;
2535:
2536: ln_seq_number := ln_seq_number + 1;
2537:

Line 2556: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

2552: ---------------------------------------------
2553: FUNCTION fee_amount(x_resultout OUT NOCOPY VARCHAR2,
2554: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
2555:
2556: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
2557: l_fee_amount NUMBER;
2558:
2559: CURSOR cFeeAmount IS
2560: SELECT FEES.FEE_AMOUNT FEE_AMOUNT

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 2578: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

2574: BEGIN
2575: x_resultout := FND_API.G_RET_STS_SUCCESS;
2576:
2577: FOR cFeeAmountRec IN cFeeAmount LOOP
2578: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2579: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2580: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
2581: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
2582: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

Line 2579: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

2575: x_resultout := FND_API.G_RET_STS_SUCCESS;
2576:
2577: FOR cFeeAmountRec IN cFeeAmount LOOP
2578: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2579: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2580: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
2581: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
2582: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2583: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

Line 2580: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=

2576:
2577: FOR cFeeAmountRec IN cFeeAmount LOOP
2578: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2579: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2580: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
2581: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
2582: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2583: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
2584: cFeeAmountRec.fee_amount;

Line 2581: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;

2577: FOR cFeeAmountRec IN cFeeAmount LOOP
2578: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2579: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2580: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
2581: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
2582: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2583: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
2584: cFeeAmountRec.fee_amount;
2585:

Line 2582: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

2578: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2579: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2580: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
2581: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
2582: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2583: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
2584: cFeeAmountRec.fee_amount;
2585:
2586: ln_seq_number := ln_seq_number + 1;

Line 2583: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

2579: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2580: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
2581: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
2582: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2583: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
2584: cFeeAmountRec.fee_amount;
2585:
2586: ln_seq_number := ln_seq_number + 1;
2587:

Line 2606: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

2602: ---------------------------------------------
2603: FUNCTION fee_date(x_resultout OUT NOCOPY VARCHAR2,
2604: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
2605:
2606: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
2607: l_fee_date DATE;
2608:
2609: CURSOR cFeeEffFrom IS
2610: SELECT FEES.EFFECTIVE_FROM EFFECTIVE_FROM

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 2628: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

2624: BEGIN
2625: x_resultout := FND_API.G_RET_STS_SUCCESS;
2626:
2627: FOR cFeeEffFromRec IN cFeeEffFrom LOOP
2628: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2629: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2630: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
2631: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
2632: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

Line 2629: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

2625: x_resultout := FND_API.G_RET_STS_SUCCESS;
2626:
2627: FOR cFeeEffFromRec IN cFeeEffFrom LOOP
2628: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2629: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2630: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
2631: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
2632: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2633: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

Line 2630: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=

2626:
2627: FOR cFeeEffFromRec IN cFeeEffFrom LOOP
2628: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2629: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2630: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
2631: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
2632: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2633: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
2634: cFeeEffFromRec.effective_from;

Line 2631: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;

2627: FOR cFeeEffFromRec IN cFeeEffFrom LOOP
2628: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2629: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2630: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
2631: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
2632: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2633: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
2634: cFeeEffFromRec.effective_from;
2635:

Line 2632: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

2628: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2629: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2630: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
2631: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
2632: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2633: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
2634: cFeeEffFromRec.effective_from;
2635:
2636: ln_seq_number := ln_seq_number + 1;

Line 2633: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

2629: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2630: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
2631: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
2632: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2633: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
2634: cFeeEffFromRec.effective_from;
2635:
2636: ln_seq_number := ln_seq_number + 1;
2637:

Line 2649: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

2645: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
2646: x_errormsg := sqlerrm;
2647: END;
2648:
2649: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=
2650: to_char(l_fee_date) ;
2651:
2652: RETURN to_char(l_fee_date);
2653: END fee_date ;

Line 2661: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

2657: ---------------------------------------------
2658: FUNCTION amount_requested(x_resultout OUT NOCOPY VARCHAR2,
2659: x_errormsg OUT NOCOPY VARCHAR2) RETURN NUMBER IS
2660:
2661: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
2662:
2663: ln_amount_requested NUMBER;
2664: ln_asset_cost NUMBER;
2665: ln_addon_cost NUMBER;

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 2731: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

2727: CLOSE l_adj_sum_csr;
2728:
2729: ln_amount_requested := ln_asset_cost + ln_fee_cost - l_adj_amount ; -- added for bug 6596860 --removded addon and added adj_amount
2730:
2731: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=
2732: ln_amount_requested;
2733:
2734: RETURN ln_amount_requested;
2735: END amount_requested ;

Line 2743: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

2739: ---------------------------------------------
2740: FUNCTION total_financed_amount(x_resultout OUT NOCOPY VARCHAR2,
2741: x_errormsg OUT NOCOPY VARCHAR2) RETURN NUMBER IS
2742:
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

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 2753: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

2749:
2750: ln_financed_amount := amount_requested(x_resultout => x_resultout,
2751: x_errormsg => x_errormsg);
2752:
2753: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=
2754: ln_financed_amount ;
2755:
2756: RETURN ln_financed_amount;
2757: END total_financed_amount ;

Line 2765: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

2761: ---------------------------------------------
2762: FUNCTION total_subsidized_cost(x_resultout OUT NOCOPY VARCHAR2,
2763: x_errormsg OUT NOCOPY VARCHAR2) RETURN NUMBER IS
2764:
2765: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
2766:
2767: ln_subs_cost NUMBER;
2768: ln_down_payment_amount NUMBER;
2769: ln_financed_amount NUMBER;

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 2798: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value := ln_subs_cost;

2794: x_errormsg => x_errormsg);
2795:
2796: ln_subs_cost := ln_financed_amount - ln_down_payment_amount - ln_subsidy_amount;
2797:
2798: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value := ln_subs_cost;
2799:
2800: RETURN ln_subs_cost;
2801: END total_subsidized_cost ;
2802:

Line 2809: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

2805: ---------------------------------------------
2806: FUNCTION security_deposit(x_resultout OUT NOCOPY VARCHAR2,
2807: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
2808:
2809: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
2810: l_security_deposit VARCHAR2(120);
2811:
2812: CURSOR cSecDeposit IS
2813: SELECT FEES.FEE_AMOUNT FEE_AMOUNT

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 2834: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

2830: x_resultout := FND_API.G_RET_STS_SUCCESS;
2831:
2832: FOR cSecDepositRec IN cSecDeposit
2833: LOOP
2834: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2835: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2836: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
2837: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
2838: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

Line 2835: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

2831:
2832: FOR cSecDepositRec IN cSecDeposit
2833: LOOP
2834: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2835: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2836: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
2837: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
2838: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2839: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

Line 2836: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=

2832: FOR cSecDepositRec IN cSecDeposit
2833: LOOP
2834: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2835: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2836: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
2837: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
2838: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2839: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
2840: cSecDepositRec.fee_amount;

Line 2837: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;

2833: LOOP
2834: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2835: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2836: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
2837: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
2838: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2839: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
2840: cSecDepositRec.fee_amount;
2841:

Line 2838: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;

2834: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2835: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2836: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
2837: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
2838: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2839: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
2840: cSecDepositRec.fee_amount;
2841:
2842: ln_seq_number := ln_seq_number + 1;

Line 2839: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=

2835: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2836: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id :=
2837: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;
2838: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_sequence_number := ln_seq_number;
2839: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_value :=
2840: cSecDepositRec.fee_amount;
2841:
2842: ln_seq_number := ln_seq_number + 1;
2843:

Line 2864: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

2860: ---------------------------------------------
2861: FUNCTION billed_tax(x_resultout OUT NOCOPY VARCHAR2,
2862: x_errormsg OUT NOCOPY VARCHAR2) RETURN NUMBER IS
2863:
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

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 2896: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

2892: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
2893: x_errormsg := sqlerrm;
2894: END;
2895:
2896: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=
2897: l_billed_tax;
2898:
2899: RETURN l_billed_tax;
2900: END 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 3175: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);

3171:
3172: FUNCTION fetch_data_point_value(x_resultout OUT NOCOPY VARCHAR2,
3173: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
3174:
3175: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
3176: l_data_point_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id);
3177:
3178: lv_data_point_value okl_leaseapp_datapoints.data_point_value%TYPE;
3179:

Line 3176: l_data_point_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id);

3172: FUNCTION fetch_data_point_value(x_resultout OUT NOCOPY VARCHAR2,
3173: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
3174:
3175: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
3176: l_data_point_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id);
3177:
3178: lv_data_point_value okl_leaseapp_datapoints.data_point_value%TYPE;
3179:
3180: BEGIN

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

Line 3198: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value := lv_data_point_value;

3194: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
3195: x_errormsg := sqlerrm;
3196: END;
3197:
3198: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value := lv_data_point_value;
3199:
3200: RETURN lv_data_point_value;
3201:
3202: END fetch_data_point_value ;