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.PJI_AUDIT_RPT dependencies on DUAL

Line 42: FROM dual;

38: BEGIN
39:
40: SELECT BIS_COMMON_PARAMETERS.GET_PERIOD_SET_NAME
41: INTO l_period_set_name
42: FROM dual;
43:
44: SELECT PJI_UTILS.GET_EXTRACTION_START_DATE
45: INTO l_global_st_date
46: FROM dual;

Line 46: FROM dual;

42: FROM dual;
43:
44: SELECT PJI_UTILS.GET_EXTRACTION_START_DATE
45: INTO l_global_st_date
46: FROM dual;
47:
48: SELECT BIS_COMMON_PARAMETERS.GET_PERIOD_TYPE
49: INTO l_period_type
50: FROM dual;

Line 50: FROM dual;

46: FROM dual;
47:
48: SELECT BIS_COMMON_PARAMETERS.GET_PERIOD_TYPE
49: INTO l_period_type
50: FROM dual;
51:
52: SELECT BIS_COMMON_PARAMETERS.GET_CURRENCY_CODE
53: INTO l_currency_code
54: FROM dual;

Line 54: FROM dual;

50: FROM dual;
51:
52: SELECT BIS_COMMON_PARAMETERS.GET_CURRENCY_CODE
53: INTO l_currency_code
54: FROM dual;
55:
56: SELECT BIS_COMMON_PARAMETERS.GET_RATE_TYPE
57: INTO l_rate_type
58: FROM dual;

Line 58: FROM dual;

54: FROM dual;
55:
56: SELECT BIS_COMMON_PARAMETERS.GET_RATE_TYPE
57: INTO l_rate_type
58: FROM dual;
59:
60: SELECT BIS_COMMON_PARAMETERS.GET_START_DAY_OF_WEEK_ID
61: INTO l_start_dt_of_week
62: FROM dual;

Line 62: FROM dual;

58: FROM dual;
59:
60: SELECT BIS_COMMON_PARAMETERS.GET_START_DAY_OF_WEEK_ID
61: INTO l_start_dt_of_week
62: FROM dual;
63:
64: l_bis_param_name_tbl := V_TYPE_TAB();
65: l_bis_param_name_tbl.DELETE;
66:

Line 148: FROM dual;

144:
145: IF (l_cnt_set_up_err > 0) THEN
146: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_ALL_PARAM_TEXT')
147: INTO l_all_msg_text
148: FROM dual;
149:
150: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PARAM_NAME')
151: INTO l_param_msg
152: FROM dual;

Line 152: FROM dual;

148: FROM dual;
149:
150: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PARAM_NAME')
151: INTO l_param_msg
152: FROM dual;
153:
154: FOR i in l_bis_param_name_tbl.FIRST.. l_bis_param_name_tbl.LAST
155: LOOP
156: l_param_msg_text := l_param_msg_text || l_param_msg || ' ' || l_bis_param_name_tbl(i) || l_newline;

Line 161: FROM dual;

157: END LOOP;
158:
159: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_BIS_PARAM_TEXT')
160: INTO l_bis_msg_text
161: FROM dual;
162:
163: pji_utils.write2out(l_all_msg_text || l_newline || l_param_msg_text || l_bis_msg_text || l_newline);
164:
165: END IF;

Line 234: FROM dual;

230:
231: IF (l_cnt_set_up_err > 0) THEN
232: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_ALL_PARAM_TEXT')
233: INTO l_all_msg_text
234: FROM dual;
235:
236: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PARAM_NAME')
237: INTO l_param_msg
238: FROM dual;

Line 238: FROM dual;

234: FROM dual;
235:
236: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PARAM_NAME')
237: INTO l_param_msg
238: FROM dual;
239:
240: FOR i in l_pji_param_name_tbl.FIRST.. l_pji_param_name_tbl.LAST
241: LOOP
242: l_param_msg_text := l_param_msg_text || l_param_msg || ' ' || l_pji_param_name_tbl(i) || l_newline;

Line 247: FROM dual;

243: END LOOP;
244:
245: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJI_PARAM_TEXT')
246: INTO l_pji_msg_text
247: FROM dual;
248:
249: pji_utils.write2out(l_newline || l_all_msg_text || l_newline || l_param_msg_text || l_pji_msg_text || l_newline);
250:
251: END IF;

Line 279: FROM dual

275:
276: BEGIN
277: SELECT 1
278: INTO l_time_cal_dim
279: FROM dual
280: WHERE EXISTS (
281: SELECT 1
282: FROM fii_time_day
283: );

Line 293: FROM dual

289:
290: BEGIN
291: SELECT 1
292: INTO l_org_dim
293: FROM dual
294: WHERE EXISTS (
295: SELECT 1
296: FROM hri_org_hrchy_summary
297: );

Line 307: FROM dual;

303:
304: IF l_time_cal_dim IS NULL THEN
305: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_TIME_CAL_DIMENSION')
306: INTO l_time_cal_msg_text
307: FROM dual;
308:
309: l_dim_msg_text := l_dim_msg_text|| l_time_cal_msg_text || l_newline;
310: END IF;
311:

Line 315: FROM dual;

311:
312: IF l_org_dim IS NULL THEN
313: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_ORG_DIMENSION')
314: INTO l_org_msg_text
315: FROM dual;
316:
317: l_dim_msg_text := l_dim_msg_text|| l_newline || l_org_msg_text || l_newline;
318: END IF;
319:

Line 658: FROM dual;

654: BEGIN
655:
656: SELECT fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL')
657: INTO l_pji_security_prof
658: FROM dual;
659:
660: SELECT fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL')
661: INTO l_mo_security_prof
662: FROM dual;

Line 662: FROM dual;

658: FROM dual;
659:
660: SELECT fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL')
661: INTO l_mo_security_prof
662: FROM dual;
663:
664: l_sec_prof_param_name_tbl := V_TYPE_TAB();
665: l_sec_prof_param_name_tbl.DELETE;
666:

Line 696: FROM dual;

692:
693: IF (l_cnt_set_up_err > 0) THEN
694: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_SEC_PROF_NOT_SET')
695: INTO l_prof_not_set_msg_text
696: FROM dual;
697:
698: FOR i in l_sec_prof_param_name_tbl.FIRST.. l_sec_prof_param_name_tbl.LAST
699: LOOP
700: l_param_msg := l_param_msg || l_sec_prof_param_name_tbl(i) || l_newline;

Line 705: FROM dual;

701: END LOOP;
702:
703: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_SEC_PROF_NO_ACCESS')
704: INTO l_no_access_msg_text
705: FROM dual;
706:
707: pji_utils.write2out(l_newline || l_prof_not_set_msg_text || l_newline || l_param_msg || l_no_access_msg_text || l_newline);
708:
709: RETURN;

Line 731: FROM dual;

727:
728: IF (NVL(l_org_view_all_flag,'N') = 'Y' OR NVL(l_org_view_all_org_flag,'N') = 'Y') THEN
729: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_SEC_PROF_ALL_ACCESS')
730: INTO l_org_all_access_msg_text
731: FROM dual;
732:
733: pji_utils.write2out(l_newline || l_org_all_access_msg_text || l_newline);
734: ELSE
735: l_org_name_tbl := V_TYPE_TAB();

Line 749: FROM dual;

745: AND sec.security_profile_id = l_pji_security_prof;
746:
747: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_SEC_PROF_PAR_ORG_ACCS')
748: INTO l_org_par_access_msg_text
749: FROM dual;
750:
751: pji_utils.write2out(l_newline || l_org_par_access_msg_text || l_newline || l_newline);
752:
753: FOR i in l_org_name_tbl.FIRST.. l_org_name_tbl.LAST

Line 774: FROM dual;

770:
771: IF (NVL(l_ou_view_all_flag,'N') = 'Y' OR NVL(l_ou_view_all_org_flag,'N') = 'Y') THEN
772: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_SEC_PROF_ALL_MO_ACCESS')
773: INTO l_ou_all_access_msg_text
774: FROM dual;
775:
776: pji_utils.write2out(l_newline || l_ou_all_access_msg_text || l_newline);
777: ELSE
778: l_ou_name_tbl := V_TYPE_TAB();

Line 799: FROM dual;

795: );
796:
797: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_SEC_PROF_PAR_MO_ACCS')
798: INTO l_ou_par_access_msg_text
799: FROM dual;
800:
801: pji_utils.write2out(l_newline || l_ou_par_access_msg_text || l_newline || l_newline);
802:
803: FOR i in l_ou_name_tbl.FIRST.. l_ou_name_tbl.LAST

Line 834: FROM dual;

830: BEGIN
831:
832: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJI_BIS_REPORT_TEXT')
833: INTO l_pji_report_msg
834: FROM dual;
835:
836: l_separator := '---------------------------------------';
837:
838: pji_utils.write2out(l_newline || l_pji_report_msg || l_newline || l_separator || l_newline);

Line 852: FROM dual;

848: IF (g_cnt_set_up_err = 0) THEN
849:
850: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_SETUP_NOERR_TEXT')
851: INTO l_pji_no_err_msg
852: FROM dual;
853:
854: pji_utils.write2out(l_pji_no_err_msg || l_newline);
855: END IF;
856:

Line 883: FROM dual;

879: BEGIN
880:
881: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_SECURITY_REPORT_TEXT')
882: INTO l_security_report_msg
883: FROM dual;
884:
885: l_separator := '------------------------------------------';
886:
887: pji_utils.write2out(l_newline || l_security_report_msg || l_newline || l_separator || l_newline);

Line 900: FROM dual;

896: END IF;
897:
898: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_USER_NAME')
899: INTO l_user_name_msg
900: FROM dual;
901:
902: pji_utils.write2out(l_newline || l_user_name_msg || ' ' || l_username || l_newline );
903:
904: CHK_SECURITY_SET_UP