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 32: AR_CMGT_CONTROLS.populate_case_folder_details(

28:
29: -- this will generate case folder details of type 'CASE'
30: IF p_mode = 'CREATE'
31: THEN
32: AR_CMGT_CONTROLS.populate_case_folder_details(
33: p_case_folder_id => p_case_folder_id,
34: p_data_point_id => p_data_point_id,
35: p_data_point_value => p_data_point_value,
36: p_included_in_check_list => l_included_in_check_list,

Line 43: AR_CMGT_CONTROLS.UPDATE_CASE_FOLDER_DETAILS (

39:
40: -- this will generate case folder details of type 'DATA'
41: IF g_data_case_folder_exists = 'Y'
42: THEN
43: AR_CMGT_CONTROLS.UPDATE_CASE_FOLDER_DETAILS (
44: p_case_folder_id => g_data_case_folder_id,
45: p_data_point_id => p_data_point_id,
46: p_data_point_value => p_data_point_value,
47: p_score => NULL,

Line 52: AR_CMGT_CONTROLS.populate_case_folder_details(

48: p_errmsg => l_errmsg,
49: p_resultout => l_resultout);
50: ELSIF g_data_case_folder_exists = 'N'
51: THEN
52: AR_CMGT_CONTROLS.populate_case_folder_details(
53: p_case_folder_id => g_data_case_folder_id,
54: p_data_point_id => p_data_point_id,
55: p_data_point_value => p_data_point_value,
56: p_included_in_check_list => l_included_in_check_list,

Line 62: AR_CMGT_CONTROLS.UPDATE_CASE_FOLDER_DETAILS (

58: p_resultout => l_resultout);
59: END IF;
60: ELSIF p_mode = 'REFRESH'
61: THEN
62: AR_CMGT_CONTROLS.UPDATE_CASE_FOLDER_DETAILS (
63: p_case_folder_id => p_case_folder_id,
64: p_data_point_id => p_data_point_id,
65: p_data_point_value => p_data_point_value,
66: p_score => NULL,

Line 114: AR_CMGT_CONTROLS.populate_case_folder_details(

110:
111: -- this will generate case folder details of type 'CASE'
112: IF p_mode = 'CREATE'
113: THEN
114: AR_CMGT_CONTROLS.populate_case_folder_details(
115: p_case_folder_id => p_case_folder_id,
116: p_data_point_id => p_data_point_id,
117: p_data_point_value => p_data_point_value,
118: p_included_in_check_list => l_included_in_check_list,

Line 125: AR_CMGT_CONTROLS.UPDATE_CASE_FOLDER_DETAILS (

121:
122: -- this will generate case folder details of type 'DATA'
123: IF g_data_case_folder_exists = 'Y'
124: THEN
125: AR_CMGT_CONTROLS.UPDATE_CASE_FOLDER_DETAILS (
126: p_case_folder_id => g_data_case_folder_id,
127: p_data_point_id => p_data_point_id,
128: p_data_point_value => p_data_point_value,
129: p_score => NULL,

Line 134: AR_CMGT_CONTROLS.populate_case_folder_details(

130: p_errmsg => x_error_msg,
131: p_resultout => x_resultout);
132: ELSIF g_data_case_folder_exists = 'N'
133: THEN
134: AR_CMGT_CONTROLS.populate_case_folder_details(
135: p_case_folder_id => g_data_case_folder_id,
136: p_data_point_id => p_data_point_id,
137: p_data_point_value => p_data_point_value,
138: p_included_in_check_list => l_included_in_check_list,

Line 144: AR_CMGT_CONTROLS.UPDATE_CASE_FOLDER_DETAILS (

140: p_resultout => x_resultout);
141: END IF;
142: ELSIF p_mode = 'REFRESH'
143: THEN
144: AR_CMGT_CONTROLS.UPDATE_CASE_FOLDER_DETAILS (
145: p_case_folder_id => p_case_folder_id,
146: p_data_point_id => p_data_point_id,
147: p_data_point_value => p_data_point_value,
148: p_score => NULL,

Line 2184: ar_cmgt_controls.populate_aging_dtls

2180:
2181: IF l_counter = 0 THEN
2182: IF p_mode = 'CREATE'
2183: THEN
2184: ar_cmgt_controls.populate_aging_dtls
2185: (p_case_folder_id => p_case_folder_id,
2186: p_aging_bucket_id => aging_rec.aging_bucket_id,
2187: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2188: p_amount => l_bucket_amount_0,

Line 2197: ar_cmgt_controls.update_aging_dtls

2193: return;
2194: END IF;
2195: IF g_data_case_folder_exists = 'Y' -- for data record
2196: THEN
2197: ar_cmgt_controls.update_aging_dtls
2198: (p_case_folder_id => g_data_case_folder_id,
2199: p_aging_bucket_id => aging_rec.aging_bucket_id,
2200: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2201: p_amount => l_bucket_amount_0,

Line 2206: ar_cmgt_controls.populate_aging_dtls

2202: p_error_msg => p_error_msg,
2203: p_resultout => p_resultout);
2204: ELSIF g_data_case_folder_exists = 'N'
2205: THEN
2206: ar_cmgt_controls.populate_aging_dtls
2207: (p_case_folder_id => g_data_case_folder_id,
2208: p_aging_bucket_id => aging_rec.aging_bucket_id,
2209: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2210: p_amount => l_bucket_amount_0,

Line 2220: ar_cmgt_controls.update_aging_dtls

2216: return;
2217: END IF;
2218: ELSIF p_mode = 'REFRESH'
2219: THEN
2220: ar_cmgt_controls.update_aging_dtls
2221: (p_case_folder_id => p_case_folder_id,
2222: p_aging_bucket_id => aging_rec.aging_bucket_id,
2223: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2224: p_amount => l_bucket_amount_0,

Line 2238: ar_cmgt_controls.populate_aging_dtls

2234: END IF;
2235: IF l_counter = 1 THEN
2236: IF p_mode = 'CREATE'
2237: THEN
2238: ar_cmgt_controls.populate_aging_dtls
2239: (p_case_folder_id => p_case_folder_id,
2240: p_aging_bucket_id => aging_rec.aging_bucket_id,
2241: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2242: p_amount => l_bucket_amount_1,

Line 2251: ar_cmgt_controls.update_aging_dtls

2247: return;
2248: END IF;
2249: IF g_data_case_folder_exists = 'Y' -- for data record
2250: THEN
2251: ar_cmgt_controls.update_aging_dtls
2252: (p_case_folder_id => g_data_case_folder_id,
2253: p_aging_bucket_id => aging_rec.aging_bucket_id,
2254: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2255: p_amount => l_bucket_amount_1,

Line 2260: ar_cmgt_controls.populate_aging_dtls

2256: p_error_msg => p_error_msg,
2257: p_resultout => p_resultout);
2258: ELSIF g_data_case_folder_exists = 'N'
2259: THEN
2260: ar_cmgt_controls.populate_aging_dtls
2261: (p_case_folder_id => g_data_case_folder_id,
2262: p_aging_bucket_id => aging_rec.aging_bucket_id,
2263: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2264: p_amount => l_bucket_amount_1,

Line 2274: ar_cmgt_controls.update_aging_dtls

2270: return;
2271: END IF;
2272: ELSIF p_mode = 'REFRESH'
2273: THEN
2274: ar_cmgt_controls.update_aging_dtls
2275: (p_case_folder_id => p_case_folder_id,
2276: p_aging_bucket_id => aging_rec.aging_bucket_id,
2277: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2278: p_amount => l_bucket_amount_1,

Line 2292: ar_cmgt_controls.populate_aging_dtls

2288: END IF;
2289: IF l_counter = 2 THEN
2290: IF p_mode = 'CREATE'
2291: THEN
2292: ar_cmgt_controls.populate_aging_dtls
2293: (p_case_folder_id => p_case_folder_id,
2294: p_aging_bucket_id => aging_rec.aging_bucket_id,
2295: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2296: p_amount => l_bucket_amount_2,

Line 2305: ar_cmgt_controls.update_aging_dtls

2301: return;
2302: END IF;
2303: IF g_data_case_folder_exists = 'Y' -- for data record
2304: THEN
2305: ar_cmgt_controls.update_aging_dtls
2306: (p_case_folder_id => g_data_case_folder_id,
2307: p_aging_bucket_id => aging_rec.aging_bucket_id,
2308: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2309: p_amount => l_bucket_amount_2,

Line 2314: ar_cmgt_controls.populate_aging_dtls

2310: p_error_msg => p_error_msg,
2311: p_resultout => p_resultout);
2312: ELSIF g_data_case_folder_exists = 'N'
2313: THEN
2314: ar_cmgt_controls.populate_aging_dtls
2315: (p_case_folder_id => g_data_case_folder_id,
2316: p_aging_bucket_id => aging_rec.aging_bucket_id,
2317: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2318: p_amount => l_bucket_amount_2,

Line 2328: ar_cmgt_controls.update_aging_dtls

2324: return;
2325: END IF;
2326: ELSIF p_mode = 'REFRESH'
2327: THEN
2328: ar_cmgt_controls.update_aging_dtls
2329: (p_case_folder_id => p_case_folder_id,
2330: p_aging_bucket_id => aging_rec.aging_bucket_id,
2331: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2332: p_amount => l_bucket_amount_2,

Line 2346: ar_cmgt_controls.populate_aging_dtls

2342: END IF;
2343: IF l_counter = 3 THEN
2344: IF p_mode = 'CREATE'
2345: THEN
2346: ar_cmgt_controls.populate_aging_dtls
2347: (p_case_folder_id => p_case_folder_id,
2348: p_aging_bucket_id => aging_rec.aging_bucket_id,
2349: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2350: p_amount => l_bucket_amount_3,

Line 2359: ar_cmgt_controls.update_aging_dtls

2355: return;
2356: END IF;
2357: IF g_data_case_folder_exists = 'Y' -- for data record
2358: THEN
2359: ar_cmgt_controls.update_aging_dtls
2360: (p_case_folder_id => g_data_case_folder_id,
2361: p_aging_bucket_id => aging_rec.aging_bucket_id,
2362: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2363: p_amount => l_bucket_amount_3,

Line 2368: ar_cmgt_controls.populate_aging_dtls

2364: p_error_msg => p_error_msg,
2365: p_resultout => p_resultout);
2366: ELSIF g_data_case_folder_exists = 'N'
2367: THEN
2368: ar_cmgt_controls.populate_aging_dtls
2369: (p_case_folder_id => g_data_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_3,

Line 2382: ar_cmgt_controls.update_aging_dtls

2378: return;
2379: END IF;
2380: ELSIF p_mode = 'REFRESH'
2381: THEN
2382: ar_cmgt_controls.update_aging_dtls
2383: (p_case_folder_id => p_case_folder_id,
2384: p_aging_bucket_id => aging_rec.aging_bucket_id,
2385: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2386: p_amount => l_bucket_amount_3,

Line 2400: ar_cmgt_controls.populate_aging_dtls

2396: END IF;
2397: IF l_counter = 4 THEN
2398: IF p_mode = 'CREATE'
2399: THEN
2400: ar_cmgt_controls.populate_aging_dtls
2401: (p_case_folder_id => p_case_folder_id,
2402: p_aging_bucket_id => aging_rec.aging_bucket_id,
2403: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2404: p_amount => l_bucket_amount_4,

Line 2413: ar_cmgt_controls.update_aging_dtls

2409: return;
2410: END IF;
2411: IF g_data_case_folder_exists = 'Y' -- for data record
2412: THEN
2413: ar_cmgt_controls.update_aging_dtls
2414: (p_case_folder_id => g_data_case_folder_id,
2415: p_aging_bucket_id => aging_rec.aging_bucket_id,
2416: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2417: p_amount => l_bucket_amount_4,

Line 2422: ar_cmgt_controls.populate_aging_dtls

2418: p_error_msg => p_error_msg,
2419: p_resultout => p_resultout);
2420: ELSIF g_data_case_folder_exists = 'N'
2421: THEN
2422: ar_cmgt_controls.populate_aging_dtls
2423: (p_case_folder_id => g_data_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_4,

Line 2436: ar_cmgt_controls.update_aging_dtls

2432: return;
2433: END IF;
2434: ELSIF p_mode = 'REFRESH'
2435: THEN
2436: ar_cmgt_controls.update_aging_dtls
2437: (p_case_folder_id => p_case_folder_id,
2438: p_aging_bucket_id => aging_rec.aging_bucket_id,
2439: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2440: p_amount => l_bucket_amount_4,

Line 2454: ar_cmgt_controls.populate_aging_dtls

2450: END IF;
2451: IF l_counter = 5 THEN
2452: IF p_mode = 'CREATE'
2453: THEN
2454: ar_cmgt_controls.populate_aging_dtls
2455: (p_case_folder_id => p_case_folder_id,
2456: p_aging_bucket_id => aging_rec.aging_bucket_id,
2457: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2458: p_amount => l_bucket_amount_5,

Line 2467: ar_cmgt_controls.update_aging_dtls

2463: return;
2464: END IF;
2465: IF g_data_case_folder_exists = 'Y' -- for data record
2466: THEN
2467: ar_cmgt_controls.update_aging_dtls
2468: (p_case_folder_id => g_data_case_folder_id,
2469: p_aging_bucket_id => aging_rec.aging_bucket_id,
2470: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2471: p_amount => l_bucket_amount_5,

Line 2476: ar_cmgt_controls.populate_aging_dtls

2472: p_error_msg => p_error_msg,
2473: p_resultout => p_resultout);
2474: ELSIF g_data_case_folder_exists = 'N'
2475: THEN
2476: ar_cmgt_controls.populate_aging_dtls
2477: (p_case_folder_id => g_data_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_5,

Line 2490: ar_cmgt_controls.update_aging_dtls

2486: return;
2487: END IF;
2488: ELSIF p_mode = 'REFRESH'
2489: THEN
2490: ar_cmgt_controls.update_aging_dtls
2491: (p_case_folder_id => p_case_folder_id,
2492: p_aging_bucket_id => aging_rec.aging_bucket_id,
2493: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2494: p_amount => l_bucket_amount_5,

Line 2508: ar_cmgt_controls.populate_aging_dtls

2504: END IF;
2505: IF l_counter = 6 THEN
2506: IF p_mode = 'CREATE'
2507: THEN
2508: ar_cmgt_controls.populate_aging_dtls
2509: (p_case_folder_id => p_case_folder_id,
2510: p_aging_bucket_id => aging_rec.aging_bucket_id,
2511: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2512: p_amount => l_bucket_amount_6,

Line 2521: ar_cmgt_controls.update_aging_dtls

2517: return;
2518: END IF;
2519: IF g_data_case_folder_exists = 'Y' -- for data record
2520: THEN
2521: ar_cmgt_controls.update_aging_dtls
2522: (p_case_folder_id => g_data_case_folder_id,
2523: p_aging_bucket_id => aging_rec.aging_bucket_id,
2524: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2525: p_amount => l_bucket_amount_6,

Line 2530: ar_cmgt_controls.populate_aging_dtls

2526: p_error_msg => p_error_msg,
2527: p_resultout => p_resultout);
2528: ELSIF g_data_case_folder_exists = 'N'
2529: THEN
2530: ar_cmgt_controls.populate_aging_dtls
2531: (p_case_folder_id => g_data_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_6,

Line 2544: ar_cmgt_controls.update_aging_dtls

2540: return;
2541: END IF;
2542: ELSIF p_mode = 'REFRESH'
2543: THEN
2544: ar_cmgt_controls.update_aging_dtls
2545: (p_case_folder_id => p_case_folder_id,
2546: p_aging_bucket_id => aging_rec.aging_bucket_id,
2547: p_aging_bucket_line_id => aging_rec.aging_bucket_line_id,
2548: p_amount => l_bucket_amount_6,

Line 2593: AR_CMGT_CONTROLS.populate_dnb_data(

2589:
2590: -- call table handler to insert into ar_cmgt_cf_dnb_dtls.
2591: IF p_mode = 'CREATE'
2592: THEN
2593: AR_CMGT_CONTROLS.populate_dnb_data(
2594: p_case_folder_id => p_case_folder_id,
2595: p_source_table_name => p_source_table_name,
2596: p_source_key => p_source_key,
2597: p_source_key_type => p_source_key_type,

Line 2622: AR_CMGT_CONTROLS.populate_dnb_data(

2618: -- as part of case folder generation. So if user
2619: -- purchased dnb data leter on then it will not be updated.
2620: IF ( SQL%NOTFOUND )
2621: THEN
2622: AR_CMGT_CONTROLS.populate_dnb_data(
2623: p_case_folder_id => p_case_folder_id,
2624: p_source_table_name => p_source_table_name,
2625: p_source_key => p_source_key,
2626: p_source_key_type => p_source_key_type,

Line 2685: AR_CMGT_CONTROLS.populate_case_folder (

2681: ELSE
2682: l_case_folder_number := p_case_folder_number;
2683: END IF;
2684: -- insert into case_folder table
2685: AR_CMGT_CONTROLS.populate_case_folder (
2686: p_case_folder_id => p_case_folder_id,
2687: p_case_folder_number => l_case_folder_number,
2688: p_credit_request_id => p_credit_request_id,
2689: p_check_list_id => p_check_list_id,

Line 2747: AR_CMGT_CONTROLS.populate_case_folder (

2743: SELECT ar_cmgt_case_folders_s.nextval
2744: INTO g_data_case_folder_id
2745: FROM dual;
2746: g_data_case_folder_exists := 'N';
2747: AR_CMGT_CONTROLS.populate_case_folder (
2748: p_case_folder_id => g_data_case_folder_id,
2749: p_case_folder_number => l_case_folder_number,
2750: p_credit_request_id => p_credit_request_id,
2751: p_check_list_id => p_check_list_id,