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.BEN_CWB_CD_SUMMARY_PKG dependencies on BEN_CWB_COMP_DETAILS

Line 10: FROM BEN_CWB_COMP_DETAILS

6: l_check NUMBER;
7: BEGIN
8: SELECT 1
9: INTO l_check
10: FROM BEN_CWB_COMP_DETAILS
11: WHERE Nvl(bg_id, -1) = -2
12: AND Nvl(org_id, -1) = -2;
13:
14: RETURN l_check;

Line 25: INSERT INTO BEN_CWB_COMP_DETAILS

21: PROCEDURE Insert_refresh_jobs
22: IS
23: PRAGMA autonomous_transaction;
24: BEGIN
25: INSERT INTO BEN_CWB_COMP_DETAILS
26: (GROUP_PER_IN_LER_ID,
27: PERSON_ID,
28: GROUP_PL_ID,
29: LF_EVT_OCRD_DT,

Line 41: ben_cwb_cd_summary_pkg.Message_log_proc('Inserted Pilot row in BEN_CWB_COMP_DETAILS', 5);

37: -2,
38: -2,
39: Conc_Prog_Id);
40:
41: ben_cwb_cd_summary_pkg.Message_log_proc('Inserted Pilot row in BEN_CWB_COMP_DETAILS', 5);
42:
43: COMMIT;
44: END insert_refresh_jobs;
45:

Line 50: ben_cwb_cd_summary_pkg.Message_log_proc('Deleting Pilot row in BEN_CWB_COMP_DETAILS', 99);

46: PROCEDURE Delete_refresh_jobs
47: IS
48: PRAGMA autonomous_transaction;
49: BEGIN
50: ben_cwb_cd_summary_pkg.Message_log_proc('Deleting Pilot row in BEN_CWB_COMP_DETAILS', 99);
51:
52: DELETE FROM BEN_CWB_COMP_DETAILS
53: WHERE Nvl(bg_id, -1) = -2
54: AND Nvl(org_id, -1) = -2

Line 52: DELETE FROM BEN_CWB_COMP_DETAILS

48: PRAGMA autonomous_transaction;
49: BEGIN
50: ben_cwb_cd_summary_pkg.Message_log_proc('Deleting Pilot row in BEN_CWB_COMP_DETAILS', 99);
51:
52: DELETE FROM BEN_CWB_COMP_DETAILS
53: WHERE Nvl(bg_id, -1) = -2
54: AND Nvl(org_id, -1) = -2
55: AND Nvl(GROUP_PER_IN_LER_ID, -1) = -2
56: AND Nvl(PERSON_ID, -1) = -2;

Line 66: IS TABLE OF ben_cwb_comp_details%ROWTYPE;

62: p_lf_evt_ocrd_dt DATE)
63: IS
64: PRAGMA autonomous_transaction;
65: TYPE comp_analytics_bulk_collect
66: IS TABLE OF ben_cwb_comp_details%ROWTYPE;
67: psa COMP_ANALYTICS_BULK_COLLECT;
68: l_Start_Date Date;
69: CURSOR COMPANALYTICS IS SELECT per.group_per_in_ler_id
70: , per.group_pl_id

Line 1070: INSERT INTO BEN_CWB_COMP_DETAILS

1066: LOOP
1067: FETCH companalytics bulk collect INTO PSA limit 2000;
1068:
1069: forall i IN 1..PSA.COUNT
1070: INSERT INTO BEN_CWB_COMP_DETAILS
1071: VALUES Psa(i);
1072:
1073: ben_cwb_cd_summary_pkg.Message_log_proc('INSERTED '||SQL%ROWCOUNT || ' Rows in to BEN_CWB_COMP_DETAILS TABLE', 50);
1074:

Line 1073: ben_cwb_cd_summary_pkg.Message_log_proc('INSERTED '||SQL%ROWCOUNT || ' Rows in to BEN_CWB_COMP_DETAILS TABLE', 50);

1069: forall i IN 1..PSA.COUNT
1070: INSERT INTO BEN_CWB_COMP_DETAILS
1071: VALUES Psa(i);
1072:
1073: ben_cwb_cd_summary_pkg.Message_log_proc('INSERTED '||SQL%ROWCOUNT || ' Rows in to BEN_CWB_COMP_DETAILS TABLE', 50);
1074:
1075: EXIT WHEN companalytics%NOTFOUND;
1076:
1077: COMMIT;

Line 1080: INSERT INTO BEN_CWB_COMP_DETAILS

1076:
1077: COMMIT;
1078: END LOOP;
1079:
1080: INSERT INTO BEN_CWB_COMP_DETAILS
1081: (GROUP_PER_IN_LER_ID,
1082: PERSON_ID,
1083: GROUP_PL_ID,
1084: LF_EVT_OCRD_DT,

Line 1145: WHERE synonym_name = 'BEN_CWB_COMP_DETAILS'

1141: ||Nvl(ev.table_name, s.table_name) table_name
1142: INTO table_name_var
1143: FROM user_synonyms s,
1144: dba_editioning_views ev
1145: WHERE synonym_name = 'BEN_CWB_COMP_DETAILS'
1146: AND ev.owner(+) = s.table_owner
1147: AND ev.view_name(+) = s.table_name;
1148:
1149: ben_cwb_cd_summary_pkg.Message_log_proc('-----Concurrent Program Compensation Detail Report Summary Refresh Started-------',10);

Line 1174: ben_cwb_cd_summary_pkg.Message_log_proc('Purged Table BEN_CWB_COMP_DETAILS', 40);

1170: ben_cwb_cd_summary_pkg.Message_log_proc('Plan Security is disabled', 30);
1171:
1172: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||table_name_var;
1173:
1174: ben_cwb_cd_summary_pkg.Message_log_proc('Purged Table BEN_CWB_COMP_DETAILS', 40);
1175:
1176: IF Nvl(Lower(Trim(P_PURGE)), 'n') <> 'y' THEN
1177: BEN_CWB_CD_SUMMARY_PKG.insert_refresh_jobs;
1178:

Line 1207: DELETE FROM BEN_CWB_COMP_DETAILS

1203: FETCH c_group_plan_list INTO L_PARAM_GROUP_PL_ID, L_PARAM_PL_NAME, L_PARAM_EVT_OCRD_DT;
1204:
1205: EXIT WHEN c_group_plan_list%NOTFOUND;
1206:
1207: DELETE FROM BEN_CWB_COMP_DETAILS
1208: WHERE group_pl_id = L_PARAM_GROUP_PL_ID
1209: AND LF_EVT_OCRD_DT = L_PARAM_EVT_OCRD_DT;
1210:
1211: ben_cwb_cd_summary_pkg.Message_log_proc('Deleted '||SQL%ROWCOUNT ||' Rows for ' ||L_PARAM_PL_NAME||'-'||L_PARAM_EVT_OCRD_DT||' from BEN_CWB_COMP_DETAILS', 40);

Line 1211: ben_cwb_cd_summary_pkg.Message_log_proc('Deleted '||SQL%ROWCOUNT ||' Rows for ' ||L_PARAM_PL_NAME||'-'||L_PARAM_EVT_OCRD_DT||' from BEN_CWB_COMP_DETAILS', 40);

1207: DELETE FROM BEN_CWB_COMP_DETAILS
1208: WHERE group_pl_id = L_PARAM_GROUP_PL_ID
1209: AND LF_EVT_OCRD_DT = L_PARAM_EVT_OCRD_DT;
1210:
1211: ben_cwb_cd_summary_pkg.Message_log_proc('Deleted '||SQL%ROWCOUNT ||' Rows for ' ||L_PARAM_PL_NAME||'-'||L_PARAM_EVT_OCRD_DT||' from BEN_CWB_COMP_DETAILS', 40);
1212:
1213: COMMIT;
1214: END LOOP;
1215:

Line 1243: ben_cwb_cd_summary_pkg.Message_log_proc('Gathering in Statistics BEN_CWB_COMP_DETAILS', 80);

1239: END IF;
1240:
1241: BEN_CWB_CD_SUMMARY_PKG.delete_refresh_jobs;
1242:
1243: ben_cwb_cd_summary_pkg.Message_log_proc('Gathering in Statistics BEN_CWB_COMP_DETAILS', 80);
1244: fnd_stats.Gather_table_stats('BEN', 'BEN_CWB_COMP_DETAILS');
1245: ben_cwb_cd_summary_pkg.Message_log_proc('Leaving BEN_CWB_COMP_DETAILS_PROC', 95);
1246: ben_cwb_cd_summary_pkg.Message_log_proc('-----Concurrent Program Compensation Detail Report Summary Refresh Finished Successfully-------', 100);
1247:

Line 1244: fnd_stats.Gather_table_stats('BEN', 'BEN_CWB_COMP_DETAILS');

1240:
1241: BEN_CWB_CD_SUMMARY_PKG.delete_refresh_jobs;
1242:
1243: ben_cwb_cd_summary_pkg.Message_log_proc('Gathering in Statistics BEN_CWB_COMP_DETAILS', 80);
1244: fnd_stats.Gather_table_stats('BEN', 'BEN_CWB_COMP_DETAILS');
1245: ben_cwb_cd_summary_pkg.Message_log_proc('Leaving BEN_CWB_COMP_DETAILS_PROC', 95);
1246: ben_cwb_cd_summary_pkg.Message_log_proc('-----Concurrent Program Compensation Detail Report Summary Refresh Finished Successfully-------', 100);
1247:
1248: EXCEPTION

Line 1245: ben_cwb_cd_summary_pkg.Message_log_proc('Leaving BEN_CWB_COMP_DETAILS_PROC', 95);

1241: BEN_CWB_CD_SUMMARY_PKG.delete_refresh_jobs;
1242:
1243: ben_cwb_cd_summary_pkg.Message_log_proc('Gathering in Statistics BEN_CWB_COMP_DETAILS', 80);
1244: fnd_stats.Gather_table_stats('BEN', 'BEN_CWB_COMP_DETAILS');
1245: ben_cwb_cd_summary_pkg.Message_log_proc('Leaving BEN_CWB_COMP_DETAILS_PROC', 95);
1246: ben_cwb_cd_summary_pkg.Message_log_proc('-----Concurrent Program Compensation Detail Report Summary Refresh Finished Successfully-------', 100);
1247:
1248: EXCEPTION
1249: WHEN OTHERS THEN

Line 1255: DELETE FROM BEN_CWB_COMP_DETAILS

1251: ||SQLERRM;
1252:
1253: retcode := '1';
1254:
1255: DELETE FROM BEN_CWB_COMP_DETAILS
1256: WHERE CONC_REQUEST_ID = Conc_Prog_Id;
1257:
1258: ben_cwb_cd_summary_pkg.Message_log_proc('Deleted '||SQL%ROWCOUNT ||' from summary Table', 90);
1259:

Line 1263: ben_cwb_cd_summary_pkg.Message_log_proc('Error in BEN_CWB_COMP_DETAILS_PROC: '||SQLCODE, 100);

1259:
1260: COMMIT;
1261:
1262: ben_cwb_cd_summary_pkg.Message_log_proc('-----Concurrent Program Compensation Detail Report Summary Refresh Throwed an Exception-------', 100);
1263: ben_cwb_cd_summary_pkg.Message_log_proc('Error in BEN_CWB_COMP_DETAILS_PROC: '||SQLCODE, 100);
1264: ben_cwb_cd_summary_pkg.Message_log_proc(1, 100);
1265: ben_cwb_cd_summary_pkg.Message_log_proc('Error Msg: '||Substr(SQLERRM, 1, 700), 100);
1266:
1267: END ben_cwb_cd_summary_proc;