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.LNS_OCM_ADP_PUB dependencies on OCM_ADD_DATA_POINTS

Line 33: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;

29:
30: FUNCTION loan_request_amount(x_resultout OUT NOCOPY VARCHAR2,
31: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
32:
33: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
34: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
35:
36: l_loan_req_amt lns_loan_headers_all.requested_amount%TYPE ;
37: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;

Line 34: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;

30: FUNCTION loan_request_amount(x_resultout OUT NOCOPY VARCHAR2,
31: x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
32:
33: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
34: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
35:
36: l_loan_req_amt lns_loan_headers_all.requested_amount%TYPE ;
37: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;
38:

Line 62: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

58: x_errormsg := sqlerrm;
59: END;
60:
61:
62: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=
63: to_char(l_loan_req_amt) ;
64:
65: RETURN to_char( NVL(l_loan_req_amt,0) );
66:

Line 103: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;

99:
100: FUNCTION is_secured_loan (x_resultout OUT NOCOPY VARCHAR2,
101: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
102:
103: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
104:
105: l_loan_subtype lns_loan_headers_all.loan_subtype%TYPE ;
106: l_loan_secured VARCHAR2(1) ;
107:

Line 134: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

130: x_errormsg := sqlerrm;
131: END;
132:
133:
134: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=
135: NVL(l_loan_secured,'N') ;
136:
137: RETURN NVL(l_loan_secured,'N');
138:

Line 171: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;

167:
168: FUNCTION loan_collateral_percentage (x_resultout OUT NOCOPY VARCHAR2,
169: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
170:
171: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
172:
173: l_loan_collateral_perecent lns_loan_headers_all.collateral_percent%TYPE ;
174:
175:

Line 196: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

192: x_errormsg := sqlerrm;
193: END;
194:
195:
196: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=
197: to_char(l_loan_collateral_perecent) ;
198:
199: RETURN to_char( NVL(l_loan_collateral_perecent,0) );
200:

Line 234: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;

230: +===========================================================================*/
231:
232: FUNCTION initial_intrest_rate (x_resultout OUT NOCOPY VARCHAR2,
233: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
234: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
235:
236: l_initial_interest_rate lns_rate_schedules.current_interest_rate%TYPE ;
237:
238:

Line 265: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

261: x_errormsg := sqlerrm;
262: END;
263:
264:
265: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=
266: to_char(l_initial_interest_rate) ;
267:
268: RETURN to_char( NVL(l_initial_interest_rate,0) );
269:

Line 304: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;

300:
301: FUNCTION number_of_coborrowers (x_resultout OUT NOCOPY VARCHAR2,
302: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
303:
304: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
305:
306: l_number_of_coborrowers NUMBER ;
307:
308:

Line 329: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

325: x_errormsg := sqlerrm;
326: END;
327:
328:
329: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=
330: to_char(l_number_of_coborrowers) ;
331:
332: RETURN to_char( NVL(l_number_of_coborrowers,0) );
333:

Line 370: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;

366:
367: FUNCTION is_having_coborrowers (x_resultout OUT NOCOPY VARCHAR2,
368: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
369:
370: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
371:
372: l_is_having_coborrowers VARCHAR2(1) ;
373:
374:

Line 398: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

394: x_errormsg := sqlerrm;
395: END;
396:
397:
398: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=
399: l_is_having_coborrowers ;
400:
401: RETURN l_is_having_coborrowers ;
402:

Line 438: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;

434:
435: FUNCTION number_of_guarantors (x_resultout OUT NOCOPY VARCHAR2,
436: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
437:
438: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
439:
440: l_number_of_guarantors NUMBER ;
441:
442:

Line 463: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

459: x_errormsg := sqlerrm;
460: END;
461:
462:
463: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=
464: to_char(l_number_of_guarantors) ;
465:
466: RETURN to_char( NVL(l_number_of_guarantors,0) );
467:

Line 503: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;

499:
500: FUNCTION is_having_guarantors (x_resultout OUT NOCOPY VARCHAR2,
501: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
502:
503: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
504:
505: l_is_having_guarantors VARCHAR2(1) ;
506:
507:

Line 531: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

527: x_errormsg := sqlerrm;
528: END;
529:
530:
531: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=
532: l_is_having_guarantors ;
533:
534: RETURN l_is_having_guarantors ;
535:

Line 570: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;

566:
567: FUNCTION required_collateral_amount (x_resultout OUT NOCOPY VARCHAR2,
568: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
569:
570: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
571: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
572:
573: l_req_coll_amount NUMBER ;
574: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;

Line 571: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;

567: FUNCTION required_collateral_amount (x_resultout OUT NOCOPY VARCHAR2,
568: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
569:
570: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
571: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
572:
573: l_req_coll_amount NUMBER ;
574: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;
575:

Line 602: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

598: x_errormsg := sqlerrm;
599: END;
600:
601:
602: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=
603: to_char(nvl(l_req_coll_amount,0)) ;
604:
605: RETURN to_char( NVL(l_req_coll_amount,0) ) ;
606:

Line 639: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;

635:
636: FUNCTION total_collateral_amount (x_resultout OUT NOCOPY VARCHAR2,
637: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
638:
639: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
640: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
641:
642: l_total_coll_amount NUMBER ;
643: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;

Line 640: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;

636: FUNCTION total_collateral_amount (x_resultout OUT NOCOPY VARCHAR2,
637: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
638:
639: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
640: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
641:
642: l_total_coll_amount NUMBER ;
643: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;
644:

Line 673: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

669: x_errormsg := sqlerrm;
670: END;
671:
672:
673: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=
674: to_char(nvl(l_total_coll_amount,0) ) ;
675:
676: RETURN to_char( NVL(l_total_coll_amount,0) ) ;
677:

Line 711: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;

707:
708: FUNCTION deliquency_cond_amount (x_resultout OUT NOCOPY VARCHAR2,
709: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
710:
711: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
712: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
713:
714:
715: l_deliquency_amount NUMBER ;

Line 712: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;

708: FUNCTION deliquency_cond_amount (x_resultout OUT NOCOPY VARCHAR2,
709: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
710:
711: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
712: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
713:
714:
715: l_deliquency_amount NUMBER ;
716: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;

Line 743: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

739: x_errormsg := sqlerrm;
740: END;
741:
742:
743: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=
744: to_char( nvl(l_deliquency_amount,0) ) ;
745:
746: RETURN to_char( NVL(l_deliquency_amount,0) ) ;
747:

Line 809: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;

805: or trunc(end_date_active) > trunc(sysdate))
806: group by CURRENCY_CODE ;
807:
808:
809: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
810: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
811: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
812:
813: l_asset_amount NUMBER ;

Line 810: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;

806: group by CURRENCY_CODE ;
807:
808:
809: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
810: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
811: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
812:
813: l_asset_amount NUMBER ;
814: l_asset_currency lns_assets.currency_code%TYPE ;

Line 811: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;

807:
808:
809: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
810: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
811: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
812:
813: l_asset_amount NUMBER ;
814: l_asset_currency lns_assets.currency_code%TYPE ;
815: l_total_assets_amount NUMBER ;

Line 852: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

848: x_errormsg := sqlerrm;
849: END;
850:
851:
852: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=
853: to_char( NVL(l_total_assets_amount,0) ) ;
854:
855: RETURN to_char( NVL(l_total_assets_amount,0) ) ;
856:

Line 917: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;

913: or trunc(end_date_active) > trunc(sysdate))
914: group by CURRENCY_CODE ;
915:
916:
917: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
918: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
919: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
920:
921: l_asset_pledged_amt NUMBER ;

Line 918: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;

914: group by CURRENCY_CODE ;
915:
916:
917: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
918: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
919: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
920:
921: l_asset_pledged_amt NUMBER ;
922: l_asset_currency lns_assets.currency_code%TYPE ;

Line 919: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;

915:
916:
917: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
918: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
919: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
920:
921: l_asset_pledged_amt NUMBER ;
922: l_asset_currency lns_assets.currency_code%TYPE ;
923: l_total_assets_pledged_amt NUMBER ;

Line 960: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

956: x_errormsg := sqlerrm;
957: END;
958:
959:
960: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=
961: to_char( NVL(l_total_assets_pledged_amt,0) ) ;
962:
963: RETURN to_char( NVL(l_total_assets_pledged_amt,0) ) ;
964:

Line 1024: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;

1020: group by CURRENCY_CODE ;
1021:
1022:
1023:
1024: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
1025: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
1026: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
1027:
1028: l_asset_available_amt NUMBER ;

Line 1025: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;

1021:
1022:
1023:
1024: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
1025: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
1026: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
1027:
1028: l_asset_available_amt NUMBER ;
1029: l_asset_currency lns_assets.currency_code%TYPE ;

Line 1026: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;

1022:
1023:
1024: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
1025: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
1026: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
1027:
1028: l_asset_available_amt NUMBER ;
1029: l_asset_currency lns_assets.currency_code%TYPE ;
1030: l_total_assets_available_amt NUMBER ;

Line 1067: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

1063: x_errormsg := sqlerrm;
1064: END;
1065:
1066:
1067: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=
1068: to_char( NVL(l_total_assets_available_amt,0) ) ;
1069:
1070: RETURN to_char( NVL(l_total_assets_available_amt,0) ) ;
1071:

Line 1107: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;

1103: FUNCTION number_active_loans ( x_resultout OUT NOCOPY VARCHAR2,
1104: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
1105:
1106:
1107: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
1108:
1109: l_count_active_loans NUMBER ;
1110:
1111:

Line 1138: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

1134: x_errormsg := sqlerrm;
1135: END;
1136:
1137:
1138: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=
1139: to_char( NVL(l_count_active_loans,0) ) ;
1140:
1141: RETURN to_char( NVL(l_count_active_loans,0) ) ;
1142:

Line 1192: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;

1188: AND llh.loan_status = 'ACTIVE'
1189: GROUP BY loan_currency ;
1190:
1191:
1192: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
1193: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
1194:
1195: l_loan_balance_amt NUMBER ;
1196: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;

Line 1193: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;

1189: GROUP BY loan_currency ;
1190:
1191:
1192: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
1193: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
1194:
1195: l_loan_balance_amt NUMBER ;
1196: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;
1197: l_total_balance_amt NUMBER ;

Line 1232: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

1228: x_errormsg := sqlerrm;
1229: END;
1230:
1231:
1232: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=
1233: to_char( NVL(l_total_balance_amt,0) ) ;
1234:
1235: RETURN to_char( NVL(l_total_balance_amt,0) ) ;
1236:

Line 1272: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;

1268: FUNCTION number_pending_loans ( x_resultout OUT NOCOPY VARCHAR2,
1269: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
1270:
1271:
1272: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
1273:
1274: l_count_pending_loans NUMBER ;
1275:
1276:

Line 1303: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

1299: x_errormsg := sqlerrm;
1300: END;
1301:
1302:
1303: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=
1304: to_char( NVL(l_count_pending_loans,0) ) ;
1305:
1306: RETURN to_char( NVL(l_count_pending_loans,0) ) ;
1307:

Line 1357: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;

1353: AND llh.loan_status = 'PENDING'
1354: GROUP BY loan_currency ;
1355:
1356:
1357: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
1358: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
1359:
1360: l_loan_balance_amt NUMBER ;
1361: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;

Line 1358: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;

1354: GROUP BY loan_currency ;
1355:
1356:
1357: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
1358: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
1359:
1360: l_loan_balance_amt NUMBER ;
1361: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;
1362: l_total_balance_amt NUMBER ;

Line 1397: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

1393: x_errormsg := sqlerrm;
1394: END;
1395:
1396:
1397: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=
1398: to_char( NVL(l_total_balance_amt,0) ) ;
1399:
1400: RETURN to_char( NVL(l_total_balance_amt,0) ) ;
1401:

Line 1436: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;

1432: FUNCTION number_delinquent_loans ( x_resultout OUT NOCOPY VARCHAR2,
1433: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
1434:
1435:
1436: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
1437:
1438: l_count_delinquent_loans NUMBER ;
1439:
1440:

Line 1467: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

1463: x_errormsg := sqlerrm;
1464: END;
1465:
1466:
1467: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=
1468: to_char( NVL(l_count_delinquent_loans,0) ) ;
1469:
1470: RETURN to_char( NVL(l_count_delinquent_loans,0) ) ;
1471:

Line 1521: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;

1517: AND llh.loan_status = 'DELINQUENT'
1518: GROUP BY loan_currency ;
1519:
1520:
1521: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
1522: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
1523:
1524: l_loan_balance_amt NUMBER ;
1525: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;

Line 1522: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;

1518: GROUP BY loan_currency ;
1519:
1520:
1521: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
1522: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
1523:
1524: l_loan_balance_amt NUMBER ;
1525: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;
1526: l_total_balance_amt NUMBER ;

Line 1561: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

1557: x_errormsg := sqlerrm;
1558: END;
1559:
1560:
1561: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=
1562: to_char( NVL(l_total_balance_amt,0) ) ;
1563:
1564: RETURN to_char( NVL(l_total_balance_amt,0) ) ;
1565:

Line 1601: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;

1597: FUNCTION number_default_loans ( x_resultout OUT NOCOPY VARCHAR2,
1598: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
1599:
1600:
1601: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
1602:
1603: l_count_default_loans NUMBER ;
1604:
1605:

Line 1632: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

1628: x_errormsg := sqlerrm;
1629: END;
1630:
1631:
1632: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=
1633: to_char( NVL(l_count_default_loans,0) ) ;
1634:
1635: RETURN to_char( NVL(l_count_default_loans,0) ) ;
1636:

Line 1685: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;

1681: AND llh.loan_status = 'DEFAULT'
1682: GROUP BY loan_currency ;
1683:
1684:
1685: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
1686: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
1687:
1688: l_loan_balance_amt NUMBER ;
1689: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;

Line 1686: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;

1682: GROUP BY loan_currency ;
1683:
1684:
1685: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
1686: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
1687:
1688: l_loan_balance_amt NUMBER ;
1689: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;
1690: l_total_balance_amt NUMBER ;

Line 1725: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

1721: x_errormsg := sqlerrm;
1722: END;
1723:
1724:
1725: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=
1726: to_char( NVL(l_total_balance_amt,0) ) ;
1727:
1728: RETURN to_char( NVL(l_total_balance_amt,0) ) ;
1729:

Line 1764: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;

1760: FUNCTION number_paidoff_loans ( x_resultout OUT NOCOPY VARCHAR2,
1761: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
1762:
1763:
1764: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
1765:
1766: l_count_paidoff_loans NUMBER ;
1767:
1768:

Line 1795: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

1791: x_errormsg := sqlerrm;
1792: END;
1793:
1794:
1795: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=
1796: to_char( NVL(l_count_paidoff_loans,0) ) ;
1797:
1798: RETURN to_char( NVL(l_count_paidoff_loans,0) ) ;
1799:

Line 1848: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;

1844: AND llh.loan_status = 'PAIDOFF'
1845: GROUP BY loan_currency ;
1846:
1847:
1848: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
1849: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
1850:
1851: l_loan_balance_amt NUMBER ;
1852: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;

Line 1849: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;

1845: GROUP BY loan_currency ;
1846:
1847:
1848: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
1849: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
1850:
1851: l_loan_balance_amt NUMBER ;
1852: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;
1853: l_total_balance_amt NUMBER ;

Line 1888: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

1884: x_errormsg := sqlerrm;
1885: END;
1886:
1887:
1888: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=
1889: to_char( NVL(l_total_balance_amt,0) ) ;
1890:
1891: RETURN to_char( NVL(l_total_balance_amt,0) ) ;
1892:

Line 1932: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;

1928:
1929: FUNCTION total_active_loans ( x_resultout OUT NOCOPY VARCHAR2,
1930: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
1931:
1932: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
1933: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
1934:
1935: l_total_active_loans NUMBER ;
1936:

Line 1933: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;

1929: FUNCTION total_active_loans ( x_resultout OUT NOCOPY VARCHAR2,
1930: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
1931:
1932: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
1933: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
1934:
1935: l_total_active_loans NUMBER ;
1936:
1937:

Line 1979: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

1975: x_errormsg := sqlerrm;
1976: END;
1977:
1978:
1979: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=
1980: to_char( NVL(l_total_active_loans,0) ) ;
1981:
1982: RETURN to_char( NVL(l_total_active_loans,0) ) ;
1983:

Line 2052: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;

2048: AND llh.loan_status = 'ACTIVE'
2049: GROUP BY loan_currency ;
2050:
2051:
2052: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
2053: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
2054: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
2055:
2056: l_loan_balance_amt NUMBER ;

Line 2053: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;

2049: GROUP BY loan_currency ;
2050:
2051:
2052: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
2053: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
2054: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
2055:
2056: l_loan_balance_amt NUMBER ;
2057: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;

Line 2054: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;

2050:
2051:
2052: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
2053: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
2054: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
2055:
2056: l_loan_balance_amt NUMBER ;
2057: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;
2058: l_total_balance_amt NUMBER ;

Line 2092: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

2088: x_errormsg := sqlerrm;
2089: END;
2090:
2091:
2092: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=
2093: to_char( NVL(l_total_balance_amt,0) ) ;
2094:
2095: RETURN to_char( NVL(l_total_balance_amt,0) ) ;
2096:

Line 2135: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;

2131:
2132: FUNCTION total_deliquent_loans ( x_resultout OUT NOCOPY VARCHAR2,
2133: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
2134:
2135: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
2136: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
2137:
2138: l_total_deliquent_loans NUMBER ;
2139:

Line 2136: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;

2132: FUNCTION total_deliquent_loans ( x_resultout OUT NOCOPY VARCHAR2,
2133: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
2134:
2135: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
2136: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
2137:
2138: l_total_deliquent_loans NUMBER ;
2139:
2140:

Line 2182: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

2178: x_errormsg := sqlerrm;
2179: END;
2180:
2181:
2182: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=
2183: to_char( NVL(l_total_deliquent_loans,0) ) ;
2184:
2185: RETURN to_char( NVL(l_total_deliquent_loans,0) ) ;
2186:

Line 2253: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;

2249: AND llh.loan_status = 'ACTIVE'
2250: GROUP BY loan_currency ;
2251:
2252:
2253: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
2254: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
2255: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
2256:
2257: l_loan_overdue_amt NUMBER ;

Line 2254: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;

2250: GROUP BY loan_currency ;
2251:
2252:
2253: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
2254: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
2255: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
2256:
2257: l_loan_overdue_amt NUMBER ;
2258: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;

Line 2255: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;

2251:
2252:
2253: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
2254: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
2255: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
2256:
2257: l_loan_overdue_amt NUMBER ;
2258: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;
2259: l_total_overdue_amt NUMBER ;

Line 2293: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

2289: x_errormsg := sqlerrm;
2290: END;
2291:
2292:
2293: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=
2294: to_char( NVL(l_total_overdue_amt,0) ) ;
2295:
2296: RETURN to_char( NVL(l_total_overdue_amt,0) ) ;
2297:

Line 2337: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;

2333:
2334: FUNCTION total_defaulted_loans ( x_resultout OUT NOCOPY VARCHAR2,
2335: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
2336:
2337: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
2338: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
2339:
2340: l_total_default_loans NUMBER ;
2341:

Line 2338: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;

2334: FUNCTION total_defaulted_loans ( x_resultout OUT NOCOPY VARCHAR2,
2335: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
2336:
2337: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
2338: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
2339:
2340: l_total_default_loans NUMBER ;
2341:
2342:

Line 2384: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

2380: x_errormsg := sqlerrm;
2381: END;
2382:
2383:
2384: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=
2385: to_char( NVL(l_total_default_loans,0) ) ;
2386:
2387: RETURN to_char( NVL(l_total_default_loans,0) ) ;
2388: