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

Line 210: FROM dual

206:
207: /* Bug 3795903 - Added parameters to the cursor c_get_new_org */
208: CURSOR c_get_new_org (l_new_org_version_id IN NUMBER, l_new_start_org_id IN NUMBER) IS
209: SELECT l_new_start_org_id
210: FROM dual
211: UNION ALL
212: SELECT organization_id_child
213: FROM per_org_structure_elements
214: WHERE org_structure_version_id = l_new_org_version_id

Line 224: FROM dual

220: /* Bug 3795903 - Added parameters to the cursor c_get_sub_orgs */
221:
222: CURSOR c_get_sub_orgs (l_org_id IN NUMBER , l_new_org_version_id IN NUMBER) IS
223: SELECT l_org_id
224: FROM dual
225: UNION ALL
226: SELECT organization_id_child
227: FROM per_org_structure_elements
228: WHERE org_structure_version_id = l_new_org_version_id

Line 245: select l_old_org_start_id from sys.dual)

241: and org_structure_version_id = l_old_org_version_id
242: start with se.organization_id_parent = l_old_org_start_id
243: and org_structure_version_id = l_old_org_version_id
244: union
245: select l_old_org_start_id from sys.dual)
246: intersect
247: (select l_new_start_org_id from sys.dual );
248:
249: /* Added the cursor for bug 4232613 */

Line 247: (select l_new_start_org_id from sys.dual );

243: and org_structure_version_id = l_old_org_version_id
244: union
245: select l_old_org_start_id from sys.dual)
246: intersect
247: (select l_new_start_org_id from sys.dual );
248:
249: /* Added the cursor for bug 4232613 */
250: CURSOR proj_exp_check(
251: c_org_struct_version_id IN per_org_structure_elements.org_structure_version_id%TYPE,

Line 318: from sys.duaL /* Exists clause added for bug#2591146 */

314: union
315: select x_new_proj_start_org_id
316: ,x_org_id
317: ,'PROJECTS'
318: from sys.duaL /* Exists clause added for bug#2591146 */
319: where EXISTS (select 'X'
320: from hr_organization_information info
321: where info.organization_id = x_new_proj_start_org_id
322: and info.org_information1 = 'PA_PROJECT_ORG'

Line 413: from dual

409: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
410: , sysdate
411: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
412: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
413: from dual
414: where not exists
415: (select 'Y'
416: from pa_org_hierarchy_denorm
417: where pa_org_use_type = 'PROJECTS'

Line 468: from sys.duaL /* Exists clause added for bug#2591146 */

464: union
465: select x_new_exp_start_org_id
466: ,x_org_id
467: ,'EXPENDITURES'
468: from sys.duaL /* Exists clause added for bug#2591146 */
469: where EXISTS (select 'X'
470: from hr_organization_information info
471: where info.organization_id = x_new_exp_start_org_id
472: and info.org_information1 = 'PA_EXPENDITURE_ORG'

Line 560: from dual

556: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
557: , sysdate
558: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
559: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
560: from dual
561: where not exists
562: (select 'Y'
563: from pa_org_hierarchy_denorm
564: where pa_org_use_type = 'EXPENDITURES'

Line 677: FROM dual

673:
674: CURSOR c_get_new_org_sch(lp_org_version_id IN NUMBER,
675: lp_start_org_id IN NUMBER ) IS
676: SELECT l_dummy_level,lp_start_org_id
677: FROM dual
678: UNION ALL
679: SELECT level,organization_id_child
680: FROM per_org_structure_elements
681: WHERE org_structure_version_id = lp_org_version_id

Line 690: FROM dual

686:
687: CURSOR c_get_sub_orgs_sch (lp_org_version_id IN NUMBER,
688: lp_org_id IN NUMBER) IS
689: SELECT l_dummy_level,lp_org_id
690: FROM dual
691: UNION ALL
692: SELECT level,organization_id_child
693: FROM per_org_structure_elements
694: WHERE org_structure_version_id = lp_org_version_id

Line 704: FROM dual

700: /* Commented this cursor for bug#2723330 as this cursor is not used now
701:
702: CURSOR check_org_ver_not_exists ( lp_org_version_id IN NUMBER ) IS
703: SELECT 'x'
704: FROM dual
705: WHERE not exists
706: ( SELECT 'x' from pa_org_hierarchy_denorm
707: WHERE org_hierarchy_version_id = nvl(lp_org_version_id,org_hierarchy_version_id)
708: and pa_org_use_type = 'TP_SCHEDULE' );

Line 820: from dual

816: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
817: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
818: , l_plevel
819: , (l_child_level_var(i) + l_parent_level +1)
820: from dual
821: where not exists
822: (select 'Y'
823: from pa_org_hierarchy_denorm
824: where pa_org_use_type = 'TP_SCHEDULE'

Line 897: select x_organization_id_parent from sys.dual

893: start with se.organization_id_child =
894: x_organization_id_parent
895: and org_structure_version_id = x_org_version_id
896: union
897: select x_organization_id_parent from sys.dual
898: )
899: intersect
900: (
901: select v_start_org_id from sys.dual

Line 901: select v_start_org_id from sys.dual

897: select x_organization_id_parent from sys.dual
898: )
899: intersect
900: (
901: select v_start_org_id from sys.dual
902: );
903:
904: /* Commented for Bug#2620151 Added cursor above
905: cursor check_org_exists is

Line 918: from sys.dual)

914: v_start_org_id
915: and org_structure_version_id = x_org_version_id
916: union
917: select v_start_org_id
918: from sys.dual)
919: intersect
920: (select x_organization_id_parent
921: from sys.dual );
922: */

Line 921: from sys.dual );

917: select v_start_org_id
918: from sys.dual)
919: intersect
920: (select x_organization_id_parent
921: from sys.dual );
922: */
923:
924: --- To populate pa_org_hierarchy_denorm
925: cursor get_all_orgs is

Line 927: FROM dual

923:
924: --- To populate pa_org_hierarchy_denorm
925: cursor get_all_orgs is
926: (SELECT x_organization_id_parent
927: FROM dual
928: UNION
929: SELECT organization_id_parent
930: FROM per_org_structure_elements
931: WHERE org_structure_version_id = x_org_version_id

Line 937: (SELECT x_organization_id_child from dual);

933: AND org_structure_version_id = x_org_version_id
934: START WITH organization_id_child = x_organization_id_parent
935: AND org_structure_version_id = x_org_version_id) /* Bug#2643047, Added this condition as we have to query only for this org_structure_version_id */
936: union ALL
937: (SELECT x_organization_id_child from dual);
938:
939: -- Start CC Change
940:
941: cursor get_all_orgs_sch(

Line 946: FROM dual

942: lp_organization_id_parent in number,
943: lp_organization_id_child in number,
944: lp_org_version_id in number ) is
945: (SELECT lp_organization_id_parent
946: FROM dual
947: UNION
948: SELECT organization_id_parent
949: FROM per_org_structure_elements
950: WHERE org_structure_version_id = lp_org_version_id

Line 956: (SELECT lp_organization_id_child from dual);

952: AND org_structure_version_id = lp_org_version_id
953: START WITH organization_id_child = lp_organization_id_parent
954: AND org_structure_version_id = lp_org_version_id)
955: union ALL
956: (SELECT lp_organization_id_child from dual);
957:
958: l_plevel number;
959: l_clevel number;
960: l_start_org_id number;

Line 1019: from sys.dual

1015: (select
1016: x_organization_id_child,
1017: imp_rec.org_id,
1018: 'PROJECTS'
1019: from sys.dual
1020: where exists (select 'x'
1021: from hr_organization_information info
1022: where info.organization_id = x_organization_id_child
1023: and info.org_information1 = 'PA_PROJECT_ORG'

Line 1102: from dual

1098: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
1099: , sysdate
1100: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
1101: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
1102: from dual
1103: where not exists
1104: (select 'Y'
1105: from pa_org_hierarchy_denorm
1106: where pa_org_use_type = 'PROJECTS'

Line 1165: from sys.dual

1161: (select
1162: x_organization_id_child,
1163: imp_rec.org_id,
1164: 'EXPENDITURES'
1165: from sys.dual
1166: where exists (select 'x'
1167: from hr_organization_information info
1168: where info.organization_id = x_organization_id_child
1169: and info.org_information1 = 'PA_EXPENDITURE_ORG'

Line 1246: from dual

1242: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
1243: , sysdate
1244: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
1245: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
1246: from dual
1247: where not exists
1248: (select 'Y'
1249: from pa_org_hierarchy_denorm
1250: where pa_org_use_type = 'EXPENDITURES'

Line 1482: FROM dual

1478:
1479: --- To populate pa_org_hierarchy_denorm
1480: cursor get_all_orgs is
1481: (SELECT x_organization_id
1482: FROM dual
1483: UNION ALL
1484: SELECT organization_id_parent
1485: FROM per_org_structure_elements
1486: WHERE org_structure_version_id = v_org_structure_version_id

Line 1526: from sys.dual

1522: org_id,
1523: pa_org_use_type)
1524: (select x_organization_id,
1525: imp_rec.org_id, 'PROJECTS'
1526: from sys.dual
1527: where not exists ( select 'X'
1528: from pa_all_organizations
1529: where organization_id = x_organization_id
1530: and org_id = imp_rec.org_id --MOAC Changes: Bug 4363092: Removed nvl usage with org_id

Line 1568: from sys.dual

1564: org_id,
1565: pa_org_use_type)
1566: (select x_organization_id,
1567: imp_rec.org_id, 'PROJECTS'
1568: from sys.dual
1569: where not exists ( select 'X'
1570: from pa_all_organizations
1571: where organization_id = x_organization_id
1572: and org_id = imp_rec.org_id --MOAC Changes: Bug 4363092: Removed nvl usage with org_id

Line 1647: from sys.dual

1643: org_id,
1644: pa_org_use_type)
1645: (select x_organization_id,
1646: imp_rec.org_id, 'EXPENDITURES'
1647: from sys.dual
1648: where not exists ( select 'X'
1649: from pa_all_organizations
1650: where organization_id = x_organization_id
1651: and org_id = imp_rec.org_id --MOAC Changes: Bug 4363092: Removed nvl usage with org_id

Line 1688: from sys.dual

1684: org_id,
1685: pa_org_use_type)
1686: (select x_organization_id,
1687: imp_rec.org_id, 'EXPENDITURES'
1688: from sys.dual
1689: where not exists ( select 'X'
1690: from pa_all_organizations
1691: where organization_id = x_organization_id
1692: and org_id = imp_rec.org_id --MOAC Changes: Bug 4363092: Removed nvl usage with org_id

Line 1766: SELECT x_old_start_org_id FROM Sys.dual ;

1762: AND org_structure_version_id = x_old_org_version_id
1763: START WITH se.organization_id_parent = x_old_start_org_id
1764: AND org_structure_version_id = x_old_org_version_id
1765: UNION
1766: SELECT x_old_start_org_id FROM Sys.dual ;
1767:
1768: CURSOR cur_proj_new_org IS
1769: SELECT se.organization_id_child organization_id
1770: FROM per_org_structure_elements se

Line 1784: SELECT x_new_start_org_id FROM Sys.dual -- Added exists clause for Bug# 1650520

1780: AND org_structure_version_id = x_new_org_version_id
1781: START WITH se.organization_id_parent = x_new_start_org_id
1782: AND org_structure_version_id = x_new_org_version_id
1783: UNION
1784: SELECT x_new_start_org_id FROM Sys.dual -- Added exists clause for Bug# 1650520
1785: WHERE EXISTS (select 'X'
1786: from hr_organization_information info
1787: where info.org_information1 = 'PA_PROJECT_ORG'
1788: and info.org_information_context||'' = 'CLASS'

Line 1809: SELECT x_new_start_org_id FROM Sys.dual

1805: AND org_structure_version_id = x_new_org_version_id
1806: START WITH se.organization_id_parent = x_new_start_org_id
1807: AND org_structure_version_id = x_new_org_version_id
1808: UNION
1809: SELECT x_new_start_org_id FROM Sys.dual
1810: where EXISTS (select 'X' /* Made changes for BUG 1180635*/
1811: from hr_organization_information info
1812: where info.org_information1 = 'PA_EXPENDITURE_ORG'
1813: and info.org_information_context||'' = 'CLASS'

Line 1991: from dual

1987: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
1988: , sysdate
1989: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
1990: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
1991: from dual
1992: where not exists
1993: (select 'Y'
1994: from pa_org_hierarchy_denorm
1995: where pa_org_use_type = p_pa_org_use_type

Line 2095: from dual

2091: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
2092: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
2093: , p_parent_level
2094: , p_child_level
2095: from dual
2096: where not exists
2097: (select 'Y'
2098: from pa_org_hierarchy_denorm
2099: where pa_org_use_type = p_pa_org_use_type

Line 2169: from dual

2165: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
2166: , p_parent_org_level
2167: , p_child_org_level
2168: , p_org_id
2169: from dual
2170: where not exists
2171: (select 'Y'
2172: from pa_org_hierarchy_denorm
2173: where pa_org_use_type = p_pa_org_use_type

Line 2225: FROM dual

2221: -- example 200p - 205c,201p-205c,202p-205c,203p-205c,204p-205c,205p-205c
2222: -- where p is parent org and c is the child orgs
2223: cursor get_all_orgs is
2224: SELECT P_organization_id_parent
2225: FROM dual
2226: UNION
2227: (SELECT distinct organization_id_parent
2228: FROM per_org_structure_elements
2229: WHERE org_structure_version_id = P_org_version_id

Line 2248: (SELECT P_organization_id_child from dual);

2244: AND org_structure_version_id = P_org_version_id
2245: START WITH organization_id_child = P_start_org_id
2246: AND org_structure_version_id = P_org_version_id)
2247: UNION
2248: (SELECT P_organization_id_child from dual);
2249:
2250: BEGIN
2251:
2252: x_err_code := 0;

Line 2412: FROM dual

2408: cursor get_all_orgs(version_id NUMBER,start_org_id NUMBER) is
2409: SELECT dummy_level plevel --- This query is added to fix bug : 1619922
2410: ,start_org_id organization_id_parent
2411: ,start_org_id organization_id_child
2412: FROM dual
2413: UNION
2414: SELECT distinct
2415: level plevel
2416: ,organization_id_parent

Line 2438: FROM sys.dual)

2434: START WITH organization_id_parent = start_org_id
2435: and org_structure_version_id = version_id
2436: UNION
2437: SELECT v_start_org_id
2438: FROM sys.dual)
2439: INTERSECT
2440: (SELECT p_organization_id_parent
2441: FROM sys.dual );
2442:

Line 2441: FROM sys.dual );

2437: SELECT v_start_org_id
2438: FROM sys.dual)
2439: INTERSECT
2440: (SELECT p_organization_id_parent
2441: FROM sys.dual );
2442:
2443:
2444: BEGIN
2445:

Line 2933: FROM dual

2929: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
2930: , v_max_level
2931: , v_max_level
2932: , p_org_id
2933: FROM dual
2934: );
2935:
2936: --mano_msg('inserted ' || sql%rowcount || ' rows');
2937:

Line 3133: from dual

3129: x_exists number;
3130:
3131: Cursor check_lower_org_exists(p_org_id number) IS
3132: Select 1
3133: from dual
3134: where exists
3135: (select 1 from pa_org_hierarchy_denorm
3136: where org_hierarchy_version_id = x_org_version_id and
3137: pa_org_use_type = 'REPORTING' and

Line 3605: FROM dual

3601: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3602: , v_max_level
3603: , v_max_level
3604: , imp_rec.org_id
3605: FROM dual
3606: ); */
3607:
3608: END LOOP;
3609:

Line 3641: SELECT c_start_org_id FROM dual

3637:
3638: CURSOR c_get_new_org ( c_org_struct_ver_id IN per_org_structure_elements.org_structure_version_id%TYPE,
3639: c_start_org_id IN per_org_structure_elements.organization_id_child%TYPE)
3640: IS
3641: SELECT c_start_org_id FROM dual
3642: UNION ALL
3643: SELECT organization_id_child
3644: FROM per_org_structure_elements
3645: WHERE org_structure_version_id = c_org_struct_ver_id

Line 3654: FROM dual

3650:
3651: CURSOR c_get_sub_orgs (c_org_struct_ver_id IN per_org_structure_elements.org_structure_version_id%TYPE,
3652: c_org_id IN per_org_structure_elements.organization_id_child%TYPE) IS
3653: SELECT c_org_id
3654: FROM dual
3655: UNION ALL
3656: SELECT organization_id_child
3657: FROM per_org_structure_elements
3658: WHERE org_structure_version_id = c_org_struct_ver_id

Line 3751: from dual

3747: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
3748: , sysdate
3749: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
3750: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
3751: from dual
3752: where not exists
3753: (select 'Y'
3754: from pa_org_hierarchy_denorm
3755: where pa_org_use_type = p_org_use_type

Line 3819: from dual)

3815: union
3816: select imp_rec.start_organization_id child_outer,
3817: null parent_outer,
3818: p_version_id org_structure_version_id
3819: from dual)
3820: where org_structure_version_id = p_version_id
3821: CONNECT BY PRIOR child_outer = parent_outer
3822: START WITH org_structure_version_id = p_version_id) per_org
3823: , HR_ORGANIZATION_INFORMATION

Line 3870: SELECT v_start_org_id FROM Sys.dual -- Added exists clause for Bug# 1650520

3866: AND org_structure_version_id = x_org_version_id
3867: START WITH se.organization_id_parent = v_start_org_id
3868: AND org_structure_version_id = x_org_version_id
3869: UNION
3870: SELECT v_start_org_id FROM Sys.dual -- Added exists clause for Bug# 1650520
3871: WHERE EXISTS (select 'X'
3872: from hr_organization_information info
3873: where info.org_information1 = 'PA_PROJECT_ORG'
3874: and info.org_information_context||'' = 'CLASS'

Line 3894: SELECT v_start_org_id FROM Sys.dual

3890: AND org_structure_version_id = x_org_version_id
3891: START WITH se.organization_id_parent = v_start_org_id
3892: AND org_structure_version_id = x_org_version_id
3893: UNION
3894: SELECT v_start_org_id FROM Sys.dual
3895: where EXISTS (select 'X' /* Made changes for BUG 1180635*/
3896: from hr_organization_information info
3897: where info.org_information1 = 'PA_EXPENDITURE_ORG'
3898: and info.org_information_context||'' = 'CLASS'