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.AR_CMGT_DATA_POINTS_PKG dependencies on AR_CMGT_CONTROLS

Line 91: AR_CMGT_CONTROLS.populate_case_folder_details(

87:
88: -- this will generate case folder details of type 'CASE'
89: IF p_mode = 'CREATE'
90: THEN
91: AR_CMGT_CONTROLS.populate_case_folder_details(
92: p_case_folder_id => p_case_folder_id,
93: p_data_point_id => p_data_point_id,
94: p_data_point_value => p_data_point_value,
95: p_included_in_check_list => l_included_in_check_list,

Line 102: AR_CMGT_CONTROLS.UPDATE_CASE_FOLDER_DETAILS (

98:
99: -- this will generate case folder details of type 'DATA'
100: IF g_data_case_folder_exists = 'Y'
101: THEN
102: AR_CMGT_CONTROLS.UPDATE_CASE_FOLDER_DETAILS (
103: p_case_folder_id => g_data_case_folder_id,
104: p_data_point_id => p_data_point_id,
105: p_data_point_value => p_data_point_value,
106: p_score => NULL,

Line 111: AR_CMGT_CONTROLS.populate_case_folder_details(

107: p_errmsg => l_errmsg,
108: p_resultout => l_resultout);
109: ELSIF g_data_case_folder_exists = 'N'
110: THEN
111: AR_CMGT_CONTROLS.populate_case_folder_details(
112: p_case_folder_id => g_data_case_folder_id,
113: p_data_point_id => p_data_point_id,
114: p_data_point_value => p_data_point_value,
115: p_included_in_check_list => l_included_in_check_list,

Line 121: AR_CMGT_CONTROLS.UPDATE_CASE_FOLDER_DETAILS (

117: p_resultout => l_resultout);
118: END IF;
119: ELSIF p_mode = 'REFRESH'
120: THEN
121: AR_CMGT_CONTROLS.UPDATE_CASE_FOLDER_DETAILS (
122: p_case_folder_id => p_case_folder_id,
123: p_data_point_id => p_data_point_id,
124: p_data_point_value => p_data_point_value,
125: p_score => NULL,

Line 173: AR_CMGT_CONTROLS.populate_case_folder_details(

169:
170: -- this will generate case folder details of type 'CASE'
171: IF p_mode = 'CREATE'
172: THEN
173: AR_CMGT_CONTROLS.populate_case_folder_details(
174: p_case_folder_id => p_case_folder_id,
175: p_data_point_id => p_data_point_id,
176: p_data_point_value => p_data_point_value,
177: p_included_in_check_list => l_included_in_check_list,

Line 184: AR_CMGT_CONTROLS.UPDATE_CASE_FOLDER_DETAILS (

180:
181: -- this will generate case folder details of type 'DATA'
182: IF g_data_case_folder_exists = 'Y'
183: THEN
184: AR_CMGT_CONTROLS.UPDATE_CASE_FOLDER_DETAILS (
185: p_case_folder_id => g_data_case_folder_id,
186: p_data_point_id => p_data_point_id,
187: p_data_point_value => p_data_point_value,
188: p_score => NULL,

Line 193: AR_CMGT_CONTROLS.populate_case_folder_details(

189: p_errmsg => x_error_msg,
190: p_resultout => x_resultout);
191: ELSIF g_data_case_folder_exists = 'N'
192: THEN
193: AR_CMGT_CONTROLS.populate_case_folder_details(
194: p_case_folder_id => g_data_case_folder_id,
195: p_data_point_id => p_data_point_id,
196: p_data_point_value => p_data_point_value,
197: p_included_in_check_list => l_included_in_check_list,

Line 203: AR_CMGT_CONTROLS.UPDATE_CASE_FOLDER_DETAILS (

199: p_resultout => x_resultout);
200: END IF;
201: ELSIF p_mode = 'REFRESH'
202: THEN
203: AR_CMGT_CONTROLS.UPDATE_CASE_FOLDER_DETAILS (
204: p_case_folder_id => p_case_folder_id,
205: p_data_point_id => p_data_point_id,
206: p_data_point_value => p_data_point_value,
207: p_score => NULL,

Line 2332: ar_cmgt_controls.populate_aging_dtls

2328:
2329: IF l_counter = 0 THEN
2330: IF p_mode = 'CREATE'
2331: THEN
2332: ar_cmgt_controls.populate_aging_dtls
2333: (p_case_folder_id => p_case_folder_id,
2334: p_aging_bucket_id => aging_rec.aging_bucket_id,
2335: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2336: p_amount => l_bucket_amount_0,

Line 2345: ar_cmgt_controls.update_aging_dtls

2341: return;
2342: END IF;
2343: IF g_data_case_folder_exists = 'Y' -- for data record
2344: THEN
2345: ar_cmgt_controls.update_aging_dtls
2346: (p_case_folder_id => g_data_case_folder_id,
2347: p_aging_bucket_id => aging_rec.aging_bucket_id,
2348: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2349: p_amount => l_bucket_amount_0,

Line 2354: ar_cmgt_controls.populate_aging_dtls

2350: p_error_msg => p_error_msg,
2351: p_resultout => p_resultout);
2352: ELSIF g_data_case_folder_exists = 'N'
2353: THEN
2354: ar_cmgt_controls.populate_aging_dtls
2355: (p_case_folder_id => g_data_case_folder_id,
2356: p_aging_bucket_id => aging_rec.aging_bucket_id,
2357: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2358: p_amount => l_bucket_amount_0,

Line 2368: ar_cmgt_controls.update_aging_dtls

2364: return;
2365: END IF;
2366: ELSIF p_mode = 'REFRESH'
2367: THEN
2368: ar_cmgt_controls.update_aging_dtls
2369: (p_case_folder_id => p_case_folder_id,
2370: p_aging_bucket_id => aging_rec.aging_bucket_id,
2371: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2372: p_amount => l_bucket_amount_0,

Line 2386: ar_cmgt_controls.populate_aging_dtls

2382: END IF;
2383: IF l_counter = 1 THEN
2384: IF p_mode = 'CREATE'
2385: THEN
2386: ar_cmgt_controls.populate_aging_dtls
2387: (p_case_folder_id => p_case_folder_id,
2388: p_aging_bucket_id => aging_rec.aging_bucket_id,
2389: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2390: p_amount => l_bucket_amount_1,

Line 2399: ar_cmgt_controls.update_aging_dtls

2395: return;
2396: END IF;
2397: IF g_data_case_folder_exists = 'Y' -- for data record
2398: THEN
2399: ar_cmgt_controls.update_aging_dtls
2400: (p_case_folder_id => g_data_case_folder_id,
2401: p_aging_bucket_id => aging_rec.aging_bucket_id,
2402: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2403: p_amount => l_bucket_amount_1,

Line 2408: ar_cmgt_controls.populate_aging_dtls

2404: p_error_msg => p_error_msg,
2405: p_resultout => p_resultout);
2406: ELSIF g_data_case_folder_exists = 'N'
2407: THEN
2408: ar_cmgt_controls.populate_aging_dtls
2409: (p_case_folder_id => g_data_case_folder_id,
2410: p_aging_bucket_id => aging_rec.aging_bucket_id,
2411: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2412: p_amount => l_bucket_amount_1,

Line 2422: ar_cmgt_controls.update_aging_dtls

2418: return;
2419: END IF;
2420: ELSIF p_mode = 'REFRESH'
2421: THEN
2422: ar_cmgt_controls.update_aging_dtls
2423: (p_case_folder_id => p_case_folder_id,
2424: p_aging_bucket_id => aging_rec.aging_bucket_id,
2425: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2426: p_amount => l_bucket_amount_1,

Line 2440: ar_cmgt_controls.populate_aging_dtls

2436: END IF;
2437: IF l_counter = 2 THEN
2438: IF p_mode = 'CREATE'
2439: THEN
2440: ar_cmgt_controls.populate_aging_dtls
2441: (p_case_folder_id => p_case_folder_id,
2442: p_aging_bucket_id => aging_rec.aging_bucket_id,
2443: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2444: p_amount => l_bucket_amount_2,

Line 2453: ar_cmgt_controls.update_aging_dtls

2449: return;
2450: END IF;
2451: IF g_data_case_folder_exists = 'Y' -- for data record
2452: THEN
2453: ar_cmgt_controls.update_aging_dtls
2454: (p_case_folder_id => g_data_case_folder_id,
2455: p_aging_bucket_id => aging_rec.aging_bucket_id,
2456: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2457: p_amount => l_bucket_amount_2,

Line 2462: ar_cmgt_controls.populate_aging_dtls

2458: p_error_msg => p_error_msg,
2459: p_resultout => p_resultout);
2460: ELSIF g_data_case_folder_exists = 'N'
2461: THEN
2462: ar_cmgt_controls.populate_aging_dtls
2463: (p_case_folder_id => g_data_case_folder_id,
2464: p_aging_bucket_id => aging_rec.aging_bucket_id,
2465: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2466: p_amount => l_bucket_amount_2,

Line 2476: ar_cmgt_controls.update_aging_dtls

2472: return;
2473: END IF;
2474: ELSIF p_mode = 'REFRESH'
2475: THEN
2476: ar_cmgt_controls.update_aging_dtls
2477: (p_case_folder_id => p_case_folder_id,
2478: p_aging_bucket_id => aging_rec.aging_bucket_id,
2479: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2480: p_amount => l_bucket_amount_2,

Line 2494: ar_cmgt_controls.populate_aging_dtls

2490: END IF;
2491: IF l_counter = 3 THEN
2492: IF p_mode = 'CREATE'
2493: THEN
2494: ar_cmgt_controls.populate_aging_dtls
2495: (p_case_folder_id => p_case_folder_id,
2496: p_aging_bucket_id => aging_rec.aging_bucket_id,
2497: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2498: p_amount => l_bucket_amount_3,

Line 2507: ar_cmgt_controls.update_aging_dtls

2503: return;
2504: END IF;
2505: IF g_data_case_folder_exists = 'Y' -- for data record
2506: THEN
2507: ar_cmgt_controls.update_aging_dtls
2508: (p_case_folder_id => g_data_case_folder_id,
2509: p_aging_bucket_id => aging_rec.aging_bucket_id,
2510: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2511: p_amount => l_bucket_amount_3,

Line 2516: ar_cmgt_controls.populate_aging_dtls

2512: p_error_msg => p_error_msg,
2513: p_resultout => p_resultout);
2514: ELSIF g_data_case_folder_exists = 'N'
2515: THEN
2516: ar_cmgt_controls.populate_aging_dtls
2517: (p_case_folder_id => g_data_case_folder_id,
2518: p_aging_bucket_id => aging_rec.aging_bucket_id,
2519: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2520: p_amount => l_bucket_amount_3,

Line 2530: ar_cmgt_controls.update_aging_dtls

2526: return;
2527: END IF;
2528: ELSIF p_mode = 'REFRESH'
2529: THEN
2530: ar_cmgt_controls.update_aging_dtls
2531: (p_case_folder_id => p_case_folder_id,
2532: p_aging_bucket_id => aging_rec.aging_bucket_id,
2533: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2534: p_amount => l_bucket_amount_3,

Line 2548: ar_cmgt_controls.populate_aging_dtls

2544: END IF;
2545: IF l_counter = 4 THEN
2546: IF p_mode = 'CREATE'
2547: THEN
2548: ar_cmgt_controls.populate_aging_dtls
2549: (p_case_folder_id => p_case_folder_id,
2550: p_aging_bucket_id => aging_rec.aging_bucket_id,
2551: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2552: p_amount => l_bucket_amount_4,

Line 2561: ar_cmgt_controls.update_aging_dtls

2557: return;
2558: END IF;
2559: IF g_data_case_folder_exists = 'Y' -- for data record
2560: THEN
2561: ar_cmgt_controls.update_aging_dtls
2562: (p_case_folder_id => g_data_case_folder_id,
2563: p_aging_bucket_id => aging_rec.aging_bucket_id,
2564: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2565: p_amount => l_bucket_amount_4,

Line 2570: ar_cmgt_controls.populate_aging_dtls

2566: p_error_msg => p_error_msg,
2567: p_resultout => p_resultout);
2568: ELSIF g_data_case_folder_exists = 'N'
2569: THEN
2570: ar_cmgt_controls.populate_aging_dtls
2571: (p_case_folder_id => g_data_case_folder_id,
2572: p_aging_bucket_id => aging_rec.aging_bucket_id,
2573: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2574: p_amount => l_bucket_amount_4,

Line 2584: ar_cmgt_controls.update_aging_dtls

2580: return;
2581: END IF;
2582: ELSIF p_mode = 'REFRESH'
2583: THEN
2584: ar_cmgt_controls.update_aging_dtls
2585: (p_case_folder_id => p_case_folder_id,
2586: p_aging_bucket_id => aging_rec.aging_bucket_id,
2587: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2588: p_amount => l_bucket_amount_4,

Line 2602: ar_cmgt_controls.populate_aging_dtls

2598: END IF;
2599: IF l_counter = 5 THEN
2600: IF p_mode = 'CREATE'
2601: THEN
2602: ar_cmgt_controls.populate_aging_dtls
2603: (p_case_folder_id => p_case_folder_id,
2604: p_aging_bucket_id => aging_rec.aging_bucket_id,
2605: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2606: p_amount => l_bucket_amount_5,

Line 2615: ar_cmgt_controls.update_aging_dtls

2611: return;
2612: END IF;
2613: IF g_data_case_folder_exists = 'Y' -- for data record
2614: THEN
2615: ar_cmgt_controls.update_aging_dtls
2616: (p_case_folder_id => g_data_case_folder_id,
2617: p_aging_bucket_id => aging_rec.aging_bucket_id,
2618: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2619: p_amount => l_bucket_amount_5,

Line 2624: ar_cmgt_controls.populate_aging_dtls

2620: p_error_msg => p_error_msg,
2621: p_resultout => p_resultout);
2622: ELSIF g_data_case_folder_exists = 'N'
2623: THEN
2624: ar_cmgt_controls.populate_aging_dtls
2625: (p_case_folder_id => g_data_case_folder_id,
2626: p_aging_bucket_id => aging_rec.aging_bucket_id,
2627: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2628: p_amount => l_bucket_amount_5,

Line 2638: ar_cmgt_controls.update_aging_dtls

2634: return;
2635: END IF;
2636: ELSIF p_mode = 'REFRESH'
2637: THEN
2638: ar_cmgt_controls.update_aging_dtls
2639: (p_case_folder_id => p_case_folder_id,
2640: p_aging_bucket_id => aging_rec.aging_bucket_id,
2641: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2642: p_amount => l_bucket_amount_5,

Line 2656: ar_cmgt_controls.populate_aging_dtls

2652: END IF;
2653: IF l_counter = 6 THEN
2654: IF p_mode = 'CREATE'
2655: THEN
2656: ar_cmgt_controls.populate_aging_dtls
2657: (p_case_folder_id => p_case_folder_id,
2658: p_aging_bucket_id => aging_rec.aging_bucket_id,
2659: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2660: p_amount => l_bucket_amount_6,

Line 2669: ar_cmgt_controls.update_aging_dtls

2665: return;
2666: END IF;
2667: IF g_data_case_folder_exists = 'Y' -- for data record
2668: THEN
2669: ar_cmgt_controls.update_aging_dtls
2670: (p_case_folder_id => g_data_case_folder_id,
2671: p_aging_bucket_id => aging_rec.aging_bucket_id,
2672: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2673: p_amount => l_bucket_amount_6,

Line 2678: ar_cmgt_controls.populate_aging_dtls

2674: p_error_msg => p_error_msg,
2675: p_resultout => p_resultout);
2676: ELSIF g_data_case_folder_exists = 'N'
2677: THEN
2678: ar_cmgt_controls.populate_aging_dtls
2679: (p_case_folder_id => g_data_case_folder_id,
2680: p_aging_bucket_id => aging_rec.aging_bucket_id,
2681: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2682: p_amount => l_bucket_amount_6,

Line 2692: ar_cmgt_controls.update_aging_dtls

2688: return;
2689: END IF;
2690: ELSIF p_mode = 'REFRESH'
2691: THEN
2692: ar_cmgt_controls.update_aging_dtls
2693: (p_case_folder_id => p_case_folder_id,
2694: p_aging_bucket_id => aging_rec.aging_bucket_id,
2695: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2696: p_amount => l_bucket_amount_6,

Line 2741: AR_CMGT_CONTROLS.populate_dnb_data(

2737:
2738: -- call table handler to insert into ar_cmgt_cf_dnb_dtls.
2739: IF p_mode = 'CREATE'
2740: THEN
2741: AR_CMGT_CONTROLS.populate_dnb_data(
2742: p_case_folder_id => p_case_folder_id,
2743: p_source_table_name => p_source_table_name,
2744: p_source_key => p_source_key,
2745: p_source_key_type => p_source_key_type,

Line 2770: AR_CMGT_CONTROLS.populate_dnb_data(

2766: -- as part of case folder generation. So if user
2767: -- purchased dnb data leter on then it will not be updated.
2768: IF ( SQL%NOTFOUND )
2769: THEN
2770: AR_CMGT_CONTROLS.populate_dnb_data(
2771: p_case_folder_id => p_case_folder_id,
2772: p_source_table_name => p_source_table_name,
2773: p_source_key => p_source_key,
2774: p_source_key_type => p_source_key_type,

Line 2833: AR_CMGT_CONTROLS.populate_case_folder (

2829: ELSE
2830: l_case_folder_number := p_case_folder_number;
2831: END IF;
2832: -- insert into case_folder table
2833: AR_CMGT_CONTROLS.populate_case_folder (
2834: p_case_folder_id => p_case_folder_id,
2835: p_case_folder_number => l_case_folder_number,
2836: p_credit_request_id => p_credit_request_id,
2837: p_check_list_id => p_check_list_id,

Line 2896: AR_CMGT_CONTROLS.populate_case_folder (

2892: SELECT ar_cmgt_case_folders_s.nextval
2893: INTO g_data_case_folder_id
2894: FROM dual;
2895: g_data_case_folder_exists := 'N';
2896: AR_CMGT_CONTROLS.populate_case_folder (
2897: p_case_folder_id => g_data_case_folder_id,
2898: p_case_folder_number => l_case_folder_number,
2899: p_credit_request_id => p_credit_request_id,
2900: p_check_list_id => p_check_list_id,