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 64: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

60:
61:
62:
63:
64: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=
65: to_char(l_loan_req_amt) ;
66:
67: RETURN to_char( NVL(l_loan_req_amt,0) );
68:

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

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

Line 136: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

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

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

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

Line 198: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

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

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

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

Line 267: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

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

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

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

Line 331: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

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

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

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

Line 400: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

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

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

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

Line 465: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

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

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

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

Line 533: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

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

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

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

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

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

Line 604: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

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

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

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

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

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

Line 675: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

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

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

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

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

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

Line 745: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

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

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

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

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

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

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

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

Line 854: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

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

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

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

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

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

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

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

Line 962: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

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

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

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

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

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

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

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

Line 1069: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

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

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

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

Line 1140: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

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

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

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

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

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

Line 1234: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

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

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

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

Line 1305: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

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

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

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

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

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

Line 1399: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

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

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

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

Line 1469: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

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

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

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

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

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

Line 1563: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

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

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

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

Line 1634: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

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

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

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

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

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

Line 1727: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

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

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

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

Line 1797: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

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

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

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

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

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

Line 1890: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

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

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

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

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

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

Line 1981: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

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

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

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

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

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

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

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

Line 2094: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

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

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

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

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

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

Line 2184: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

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

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

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

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

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

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

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

Line 2295: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

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

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

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

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

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

Line 2386: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_data_point_value :=

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