DBA Data[Home] [Help]

APPS.AR_CMGT_DATA_POINTS_PKG dependencies on AR_CMGT_DATA_POINTS_PKG

Line 1: Package BODY AR_CMGT_DATA_POINTS_PKG AS

1: Package BODY AR_CMGT_DATA_POINTS_PKG AS
2: /* $Header: ARCMGDPB.pls 120.31.12010000.2 2008/09/24 15:08:43 mraymond ship $ */
3:
4: pg_wf_debug VARCHAR2(1) := ar_cmgt_util.get_wf_debug_flag;
5:

Line 22: -- 'ar_cmgt_data_points_pkg.build_case_folder_details()+');

18: BEGIN
19: IF pg_wf_debug = 'Y'
20: THEN
21: -- ar_cmgt_util.wf_debug(p_case_folder_id,
22: -- 'ar_cmgt_data_points_pkg.build_case_folder_details()+');
23: ar_cmgt_util.wf_debug(p_case_folder_id,
24: 'DP:' || p_data_point_id || ' = ' || p_data_point_value);
25: END IF;
26:

Line 74: -- 'ar_cmgt_data_points_pkg.build_case_folder_details()-');

70:
71: -- IF pg_wf_debug = 'Y'
72: -- THEN
73: -- ar_cmgt_util.wf_debug(p_case_folder_id,
74: -- 'ar_cmgt_data_points_pkg.build_case_folder_details()-');
75: -- END IF;
76:
77: EXCEPTION
78: WHEN OTHERS THEN

Line 104: 'ar_cmgt_data_points_pkg.build_case_folder_adp_details()+');

100: BEGIN
101: IF pg_wf_debug = 'Y'
102: THEN
103: ar_cmgt_util.wf_debug(p_case_folder_id,
104: 'ar_cmgt_data_points_pkg.build_case_folder_adp_details()+');
105: -- ar_cmgt_util.wf_debug(p_case_folder_id,
106: -- p_data_point_id || '=' || p_data_point_value);
107: END IF;
108:

Line 156: 'ar_cmgt_data_points_pkg.build_case_folder_adp_details()-');

152:
153: IF pg_wf_debug = 'Y'
154: THEN
155: ar_cmgt_util.wf_debug(p_case_folder_id,
156: 'ar_cmgt_data_points_pkg.build_case_folder_adp_details()-');
157: -- ar_cmgt_util.wf_debug(p_case_folder_id,
158: -- p_data_point_id || '=' || p_data_point_value);
159: END IF;
160: EXCEPTION

Line 189: 'ar_cmgt_data_points_pkg.get_deduction_data_points()+');

185: BEGIN
186: IF pg_wf_debug = 'Y'
187: THEN
188: ar_cmgt_util.wf_debug(p_case_folder_id,
189: 'ar_cmgt_data_points_pkg.get_deduction_data_points()+');
190: END IF;
191: -- first get the deduction amount
192: p_resultout := 0;
193: IF p_analysis_level = 'P'

Line 346: 'ar_cmgt_data_points_pkg.get_deduction_data_points()-');

342: END IF;
343: IF pg_wf_debug = 'Y'
344: THEN
345: ar_cmgt_util.wf_debug(p_case_folder_id,
346: 'ar_cmgt_data_points_pkg.get_deduction_data_points()-');
347: END IF;
348:
349: END;
350:

Line 365: 'ar_cmgt_data_points_pkg.getmanualdatapoints()+');

361: BEGIN
362: IF pg_wf_debug = 'Y'
363: THEN
364: ar_cmgt_util.wf_debug(p_case_folder_id,
365: 'ar_cmgt_data_points_pkg.getmanualdatapoints()+');
366: END IF;
367:
368: x_resultout := 0;
369: ocm_add_data_points.getadditionalDataPoints (

Line 379: 'ar_cmgt_data_points_pkg.getmanualdatapoints()-');

375:
376: IF pg_wf_debug = 'Y'
377: THEN
378: ar_cmgt_util.wf_debug(p_case_folder_id,
379: 'ar_cmgt_data_points_pkg.getmanualdatapoints()-');
380: END IF;
381: END GetManualDataPoints;
382:
383:

Line 577: 'ar_cmgt_data_points_pkg.getanalyticaldata()+');

573: BEGIN
574: IF pg_wf_debug = 'Y'
575: THEN
576: ar_cmgt_util.wf_debug(p_case_folder_id,
577: 'ar_cmgt_data_points_pkg.getanalyticaldata()+');
578: END IF;
579:
580: p_resultout := 0;
581: -- get largest in amount

Line 1010: 'ar_cmgt_data_points_pkg.getanalyticaldata()-');

1006:
1007: IF pg_wf_debug = 'Y'
1008: THEN
1009: ar_cmgt_util.wf_debug(p_case_folder_id,
1010: 'ar_cmgt_data_points_pkg.getanalyticaldata()-');
1011: END IF;
1012:
1013: EXCEPTION
1014: WHEN OTHERS THEN

Line 1041: 'ar_cmgt_data_points_pkg.getdunning()+');

1037: BEGIN
1038: IF pg_wf_debug = 'Y'
1039: THEN
1040: ar_cmgt_util.wf_debug(p_case_folder_id,
1041: 'ar_cmgt_data_points_pkg.getdunning()+');
1042: END IF;
1043:
1044: p_resultout := 0;
1045: IF p_analysis_level = 'A'

Line 1131: 'ar_cmgt_data_points_pkg.getdunning()-');

1127:
1128: IF pg_wf_debug = 'Y'
1129: THEN
1130: ar_cmgt_util.wf_debug(p_case_folder_id,
1131: 'ar_cmgt_data_points_pkg.getdunning()-');
1132: END IF;
1133:
1134: EXCEPTION
1135: WHEN OTHERS THEN

Line 1181: 'ar_cmgt_data_points_pkg.getomdatapoints()+');

1177: BEGIN
1178: IF pg_wf_debug = 'Y'
1179: THEN
1180: ar_cmgt_util.wf_debug(p_case_folder_id,
1181: 'ar_cmgt_data_points_pkg.getomdatapoints()+');
1182: END IF;
1183:
1184: -- first check if OM is installed, if OM is installed then get oM data points
1185: p_resultout := 0;

Line 1343: 'ar_cmgt_data_points_pkg.getomdatapoints()-');

1339:
1340: IF pg_wf_debug = 'Y'
1341: THEN
1342: ar_cmgt_util.wf_debug(p_case_folder_id,
1343: 'ar_cmgt_data_points_pkg.getomdatapoints()-');
1344: END IF;
1345:
1346: END;
1347:

Line 1425: 'ar_cmgt_data_points_pkg.getfinancialdata()+');

1421: BEGIN
1422: IF pg_wf_debug = 'Y'
1423: THEN
1424: ar_cmgt_util.wf_debug(p_case_folder_id,
1425: 'ar_cmgt_data_points_pkg.getfinancialdata()+');
1426: END IF;
1427:
1428: p_resultout := 0;
1429: BEGIN

Line 1798: 'ar_cmgt_data_points_pkg.getfinancialdata()-');

1794: p_resultout => p_resultout);
1795: IF pg_wf_debug = 'Y'
1796: THEN
1797: ar_cmgt_util.wf_debug(p_case_folder_id,
1798: 'ar_cmgt_data_points_pkg.getfinancialdata()-');
1799: END IF;
1800:
1801: END;
1802:

Line 1872: 'ar_cmgt_data_points_pkg.getotherdatapoints()+');

1868: BEGIN
1869: IF pg_wf_debug = 'Y'
1870: THEN
1871: ar_cmgt_util.wf_debug(p_case_folder_id,
1872: 'ar_cmgt_data_points_pkg.getotherdatapoints()+');
1873: END IF;
1874:
1875: FOR c_hz_cust_prof_amts_rec IN c_hz_cust_prof_amts
1876: LOOP

Line 2045: 'ar_cmgt_data_points_pkg.getotherdatapoints()-');

2041: END LOOP;
2042: IF pg_wf_debug = 'Y'
2043: THEN
2044: ar_cmgt_util.wf_debug(p_case_folder_id,
2045: 'ar_cmgt_data_points_pkg.getotherdatapoints()-');
2046: END IF;
2047: END;
2048:
2049:

Line 2108: 'ar_cmgt_data_points_pkg.populate_aging_data()+');

2104: BEGIN
2105: IF pg_wf_debug = 'Y'
2106: THEN
2107: ar_cmgt_util.wf_debug(p_case_folder_id,
2108: 'ar_cmgt_data_points_pkg.populate_aging_data()+');
2109: END IF;
2110:
2111: l_check_flag := 'Y';
2112:

Line 2566: 'ar_cmgt_data_points_pkg.populate_aging_data()-');

2562:
2563: IF pg_wf_debug = 'Y'
2564: THEN
2565: ar_cmgt_util.wf_debug(p_case_folder_id,
2566: 'ar_cmgt_data_points_pkg.populate_aging_data()-');
2567: END IF;
2568: end populate_aging_data;
2569:
2570:

Line 2587: 'ar_cmgt_data_points_pkg.populate_dnb_data()+');

2583: BEGIN
2584: IF pg_wf_debug = 'Y'
2585: THEN
2586: ar_cmgt_util.wf_debug(p_case_folder_id,
2587: 'ar_cmgt_data_points_pkg.populate_dnb_data()+');
2588: END IF;
2589:
2590: -- call table handler to insert into ar_cmgt_cf_dnb_dtls.
2591: IF p_mode = 'CREATE'

Line 2638: 'ar_cmgt_data_points_pkg.populate_dnb_data()-');

2634: END IF;
2635: IF pg_wf_debug = 'Y'
2636: THEN
2637: ar_cmgt_util.wf_debug(p_case_folder_id,
2638: 'ar_cmgt_data_points_pkg.populate_dnb_data()-');
2639: END IF;
2640: END;
2641:
2642:

Line 2672: 'ar_cmgt_data_points_pkg.build_case_folder()+');

2668:
2669: IF pg_wf_debug = 'Y'
2670: THEN
2671: ar_cmgt_util.wf_debug(p_case_folder_id,
2672: 'ar_cmgt_data_points_pkg.build_case_folder()+');
2673: END IF;
2674:
2675: -- check if case folder number is passed by calling program
2676: IF p_case_folder_number IS NULL

Line 2784: 'ar_cmgt_data_points_pkg.build_case_folder()-');

2780: ar_cmgt_util.wf_debug(p_case_folder_id,
2781: 'CR:' || p_credit_request_id || ' => CF:' ||
2782: p_case_folder_id);
2783: ar_cmgt_util.wf_debug(p_case_folder_id,
2784: 'ar_cmgt_data_points_pkg.build_case_folder()-');
2785: END IF;
2786:
2787: END build_case_folder;
2788:

Line 2838: 'ar_cmgt_data_points_pkg.build_dnb_scorable_fin_data()+');

2834: BEGIN
2835: IF pg_wf_debug = 'Y'
2836: THEN
2837: ar_cmgt_util.wf_debug(p_case_folder_id,
2838: 'ar_cmgt_data_points_pkg.build_dnb_scorable_fin_data()+');
2839: END IF;
2840:
2841: FOR cFinancialReportsRec IN cFinancialReports
2842: LOOP

Line 3015: 'ar_cmgt_data_points_pkg.build_dnb_scorable_fin_data()-');

3011: END IF;
3012: IF pg_wf_debug = 'Y'
3013: THEN
3014: ar_cmgt_util.wf_debug(p_case_folder_id,
3015: 'ar_cmgt_data_points_pkg.build_dnb_scorable_fin_data()-');
3016: END IF;
3017: END;
3018:
3019: PROCEDURE BUILD_DNB_SCOREABLE_DATA (

Line 3246: 'ar_cmgt_data_points_pkg.build_dnb_scorable_data()+');

3242: BEGIN
3243: IF pg_wf_debug = 'Y'
3244: THEN
3245: ar_cmgt_util.wf_debug(p_case_folder_id,
3246: 'ar_cmgt_data_points_pkg.build_dnb_scorable_data()+');
3247: END IF;
3248:
3249: FOR cOrgProfRec IN cOrgProf
3250: LOOP

Line 4246: 'ar_cmgt_data_points_pkg.build_dnb_scorable_data()-');

4242:
4243: IF pg_wf_debug = 'Y'
4244: THEN
4245: ar_cmgt_util.wf_debug(p_case_folder_id,
4246: 'ar_cmgt_data_points_pkg.build_dnb_scorable_data()-');
4247: END IF;
4248: END BUILD_DNB_SCOREABLE_DATA;
4249:
4250:

Line 4305: 'ar_cmgt_data_points_pkg.build_dnb_case_folder()+');

4301: BEGIN
4302: IF pg_wf_debug = 'Y'
4303: THEN
4304: ar_cmgt_util.wf_debug(p_case_folder_id,
4305: 'ar_cmgt_data_points_pkg.build_dnb_case_folder()+');
4306: END IF;
4307: p_resultout := 0;
4308: -- build the case folder details table for DNB data. In case of
4309: -- dnb data datpoint value will be null.

Line 4526: 'ar_cmgt_data_points_pkg.build_dnb_case_folder()-');

4522: hz_common_pub.enable_cont_source_security;
4523: IF pg_wf_debug = 'Y'
4524: THEN
4525: ar_cmgt_util.wf_debug(p_case_folder_id,
4526: 'ar_cmgt_data_points_pkg.build_dnb_case_folder()-');
4527: END IF;
4528:
4529: EXCEPTION
4530: WHEN OTHERS THEN

Line 5651: 'ar_cmgt_data_points_pkg.gather_data_points()+');

5647: ELSE
5648: l_tag := 'CF:' || p_case_folder_id;
5649: END IF;
5650: ar_cmgt_util.wf_debug(l_tag,
5651: 'ar_cmgt_data_points_pkg.gather_data_points()+');
5652: ar_cmgt_util.wf_debug(l_tag,
5653: ' p_mode = ' || p_mode);
5654: ar_cmgt_util.wf_debug(l_tag,
5655: ' p_party_id = ' || p_party_id);

Line 6419: 'ar_cmgt_data_points_pkg.gather_data_points()-');

6415: END IF;
6416: IF pg_wf_debug = 'Y'
6417: THEN
6418: ar_cmgt_util.wf_debug(l_tag,
6419: 'ar_cmgt_data_points_pkg.gather_data_points()-');
6420: END IF;
6421: END GATHER_DATA_POINTS;
6422:
6423:

Line 6424: END AR_CMGT_DATA_POINTS_PKG;

6420: END IF;
6421: END GATHER_DATA_POINTS;
6422:
6423:
6424: END AR_CMGT_DATA_POINTS_PKG;