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: l_manufacturer VARCHAR2(30);
731:
732: CURSOR cMfgName is
733: SELECT ASSET_COMP.MANUFACTURER_NAME MANUFACTURER_NAME

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

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

Line 755: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

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

Line 756: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

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

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

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

Line 758: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;

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

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

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

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

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

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

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

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

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

Line 808: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

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

Line 809: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

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

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

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

Line 811: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;

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

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

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

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

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

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

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

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

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

Line 860: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

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

Line 861: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

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

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

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

Line 863: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;

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

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

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

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

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

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

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

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

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

Line 914: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

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

Line 915: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

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

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

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

Line 917: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;

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

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

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

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

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

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

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

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

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

Line 966: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

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

Line 967: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

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

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

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

Line 969: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;

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

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

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

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

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

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

990: ---------------------------------------------
991: FUNCTION usage_of_equipment(x_resultout OUT NOCOPY VARCHAR2,
992: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
993:
994: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
995: l_usage_of_equipment VARCHAR2(30);
996:
997: BEGIN
998: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

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

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

Line 1020: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

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

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

1028: ---------------------------------------------
1029: FUNCTION usage_industry(x_resultout OUT NOCOPY VARCHAR2,
1030: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
1031:
1032: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1033: l_usage_industry VARCHAR2(1995);
1034:
1035: BEGIN
1036: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

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

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

Line 1069: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

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

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

1077: ---------------------------------------------
1078: FUNCTION usage_category(x_resultout OUT NOCOPY VARCHAR2,
1079: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
1080:
1081: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1082: l_usage_category VARCHAR2(30);
1083:
1084: BEGIN
1085: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

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

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

Line 1105: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

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

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

1113: ---------------------------------------------
1114: FUNCTION usage_amount(x_resultout OUT NOCOPY VARCHAR2,
1115: x_errormsg OUT NOCOPY VARCHAR2) RETURN NUMBER IS
1116:
1117: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1118: l_usage_amount NUMBER;
1119:
1120: BEGIN
1121: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

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

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

Line 1150: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

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

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

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

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

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

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

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

Line 1183: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

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

Line 1184: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1232: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

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

Line 1233: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1280: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

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

Line 1281: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1329: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

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

Line 1330: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1376: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

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

Line 1377: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

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

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

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

Line 1379: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;

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

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

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

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

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

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

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

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

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

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

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

Line 1424: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

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

Line 1425: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

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

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

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

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

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

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

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

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

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

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

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

Line 1473: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

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

Line 1474: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

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

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

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

Line 1476: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;

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

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

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

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

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

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

1497: ---------------------------------------------
1498: FUNCTION down_payment_amount(x_resultout OUT NOCOPY VARCHAR2,
1499: x_errormsg OUT NOCOPY VARCHAR2) RETURN NUMBER IS
1500:
1501: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1502: l_down_payment_amount NUMBER;
1503:
1504: BEGIN
1505: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

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

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

Line 1530: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

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

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

1537: ---------------------------------------------
1538: FUNCTION subsidy_amount(x_resultout OUT NOCOPY VARCHAR2,
1539: x_errormsg OUT NOCOPY VARCHAR2) RETURN NUMBER IS
1540:
1541: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1542: l_subsidy_amount NUMBER;
1543:
1544: BEGIN
1545: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

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

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

Line 1570: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

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

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

1578: ---------------------------------------------
1579: FUNCTION trade_in_amount(x_resultout OUT NOCOPY VARCHAR2,
1580: x_errormsg OUT NOCOPY VARCHAR2) RETURN NUMBER IS
1581:
1582: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
1583: l_trade_in_amount NUMBER;
1584:
1585: BEGIN
1586: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

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

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

Line 1611: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

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

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

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

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

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

Line 1649: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

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

Line 1650: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

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

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

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

Line 1652: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;

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

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

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

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

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

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

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

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

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

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

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

Line 1750: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

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

Line 1751: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1847: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

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

Line 1848: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1943: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

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

Line 1944: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2039: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

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

Line 2040: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2136: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

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

Line 2137: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2176: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

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

Line 2177: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2400: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

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

Line 2401: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

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

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

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

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

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

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

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

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

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

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

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

Line 2473: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

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

Line 2474: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

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

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

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

Line 2476: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;

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

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

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

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

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

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

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

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

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

Line 2525: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

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

Line 2526: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

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

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

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

Line 2528: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;

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

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

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

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

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

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

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

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

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

Line 2575: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

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

Line 2576: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

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

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

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

Line 2578: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;

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

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

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

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

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

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

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

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

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

Line 2625: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

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

Line 2626: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

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

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

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

Line 2628: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;

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

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

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

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

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

Line 2646: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

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

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

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

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

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

Line 2728: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

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

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

2736: ---------------------------------------------
2737: FUNCTION total_financed_amount(x_resultout OUT NOCOPY VARCHAR2,
2738: x_errormsg OUT NOCOPY VARCHAR2) RETURN NUMBER IS
2739:
2740: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
2741: ln_financed_amount NUMBER;
2742:
2743: BEGIN
2744: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

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

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

Line 2750: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

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

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

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

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

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

Line 2795: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value := ln_subs_cost;

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

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

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

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

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

Line 2831: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

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

Line 2832: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

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

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

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

Line 2834: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_parent_data_point_id;

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

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

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

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

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

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

2857: ---------------------------------------------
2858: FUNCTION billed_tax(x_resultout OUT NOCOPY VARCHAR2,
2859: x_errormsg OUT NOCOPY VARCHAR2) RETURN NUMBER IS
2860:
2861: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
2862: l_billed_tax NUMBER;
2863:
2864: BEGIN
2865: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452

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

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

Line 2893: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

2889: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
2890: x_errormsg := sqlerrm;
2891: END;
2892:
2893: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=
2894: l_billed_tax;
2895:
2896: RETURN l_billed_tax;
2897: END billed_tax ;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3191: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
3192: x_errormsg := sqlerrm;
3193: END;
3194:
3195: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value := lv_data_point_value;
3196:
3197: RETURN lv_data_point_value;
3198:
3199: END fetch_data_point_value ;