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.

[Home] [Help]

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 315: from sys.duaL /* Exists clause added for bug#2591146 */

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

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

421: union
422: select x_new_exp_start_org_id
423: ,x_org_id
424: ,'EXPENDITURES'
425: from sys.duaL /* Exists clause added for bug#2591146 */
426: where EXISTS (select 'X'
427: from hr_organization_information info
428: where info.organization_id = x_new_exp_start_org_id
429: and info.org_information1 = 'PA_EXPENDITURE_ORG'

Line 595: FROM dual

591:
592: CURSOR c_get_new_org_sch(lp_org_version_id IN NUMBER,
593: lp_start_org_id IN NUMBER ) IS
594: SELECT l_dummy_level,lp_start_org_id
595: FROM dual
596: UNION ALL
597: SELECT level,organization_id_child
598: FROM per_org_structure_elements
599: WHERE org_structure_version_id = lp_org_version_id

Line 608: FROM dual

604:
605: CURSOR c_get_sub_orgs_sch (lp_org_version_id IN NUMBER,
606: lp_org_id IN NUMBER) IS
607: SELECT l_dummy_level,lp_org_id
608: FROM dual
609: UNION ALL
610: SELECT level,organization_id_child
611: FROM per_org_structure_elements
612: WHERE org_structure_version_id = lp_org_version_id

Line 622: FROM dual

618: /* Commented this cursor for bug#2723330 as this cursor is not used now
619:
620: CURSOR check_org_ver_not_exists ( lp_org_version_id IN NUMBER ) IS
621: SELECT 'x'
622: FROM dual
623: WHERE not exists
624: ( SELECT 'x' from pa_org_hierarchy_denorm
625: WHERE org_hierarchy_version_id = nvl(lp_org_version_id,org_hierarchy_version_id)
626: and pa_org_use_type = 'TP_SCHEDULE' );

Line 772: select x_organization_id_parent from sys.dual

768: start with se.organization_id_child =
769: x_organization_id_parent
770: and org_structure_version_id = x_org_version_id
771: union
772: select x_organization_id_parent from sys.dual
773: )
774: intersect
775: (
776: select v_start_org_id from sys.dual

Line 776: select v_start_org_id from sys.dual

772: select x_organization_id_parent from sys.dual
773: )
774: intersect
775: (
776: select v_start_org_id from sys.dual
777: );
778:
779: /* Commented for Bug#2620151 Added cursor above
780: cursor check_org_exists is

Line 793: from sys.dual)

789: v_start_org_id
790: and org_structure_version_id = x_org_version_id
791: union
792: select v_start_org_id
793: from sys.dual)
794: intersect
795: (select x_organization_id_parent
796: from sys.dual );
797: */

Line 796: from sys.dual );

792: select v_start_org_id
793: from sys.dual)
794: intersect
795: (select x_organization_id_parent
796: from sys.dual );
797: */
798:
799: --- To populate pa_org_hierarchy_denorm
800: cursor get_all_orgs is

Line 802: FROM dual

798:
799: --- To populate pa_org_hierarchy_denorm
800: cursor get_all_orgs is
801: (SELECT x_organization_id_parent
802: FROM dual
803: UNION
804: SELECT organization_id_parent
805: FROM per_org_structure_elements
806: WHERE org_structure_version_id = x_org_version_id

Line 812: (SELECT x_organization_id_child from dual);

808: AND org_structure_version_id = x_org_version_id
809: START WITH organization_id_child = x_organization_id_parent
810: 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 */
811: union ALL
812: (SELECT x_organization_id_child from dual);
813:
814: -- Start CC Change
815:
816: cursor get_all_orgs_sch(

Line 821: FROM dual

817: lp_organization_id_parent in number,
818: lp_organization_id_child in number,
819: lp_org_version_id in number ) is
820: (SELECT lp_organization_id_parent
821: FROM dual
822: UNION
823: SELECT organization_id_parent
824: FROM per_org_structure_elements
825: WHERE org_structure_version_id = lp_org_version_id

Line 831: (SELECT lp_organization_id_child from dual);

827: AND org_structure_version_id = lp_org_version_id
828: START WITH organization_id_child = lp_organization_id_parent
829: AND org_structure_version_id = lp_org_version_id)
830: union ALL
831: (SELECT lp_organization_id_child from dual);
832:
833: l_plevel number;
834: l_clevel number;
835: l_start_org_id number;

Line 891: from sys.dual

887: (select
888: x_organization_id_child,
889: imp_rec.org_id,
890: 'PROJECTS'
891: from sys.dual
892: where exists (select 'x'
893: from hr_organization_information info
894: where info.organization_id = x_organization_id_child
895: and info.org_information1 = 'PA_PROJECT_ORG'

Line 1003: from sys.dual

999: (select
1000: x_organization_id_child,
1001: imp_rec.org_id,
1002: 'EXPENDITURES'
1003: from sys.dual
1004: where exists (select 'x'
1005: from hr_organization_information info
1006: where info.organization_id = x_organization_id_child
1007: and info.org_information1 = 'PA_EXPENDITURE_ORG'

Line 1276: FROM dual

1272:
1273: --- To populate pa_org_hierarchy_denorm
1274: cursor get_all_orgs is
1275: (SELECT x_organization_id
1276: FROM dual
1277: UNION ALL
1278: SELECT organization_id_parent
1279: FROM per_org_structure_elements
1280: WHERE org_structure_version_id = v_org_structure_version_id

Line 1320: from sys.dual

1316: org_id,
1317: pa_org_use_type)
1318: (select x_organization_id,
1319: imp_rec.org_id, 'PROJECTS'
1320: from sys.dual
1321: where not exists ( select 'X'
1322: from pa_all_organizations
1323: where organization_id = x_organization_id
1324: and org_id = imp_rec.org_id --MOAC Changes: Bug 4363092: Removed nvl usage with org_id

Line 1362: from sys.dual

1358: org_id,
1359: pa_org_use_type)
1360: (select x_organization_id,
1361: imp_rec.org_id, 'PROJECTS'
1362: from sys.dual
1363: where not exists ( select 'X'
1364: from pa_all_organizations
1365: where organization_id = x_organization_id
1366: and org_id = imp_rec.org_id --MOAC Changes: Bug 4363092: Removed nvl usage with org_id

Line 1441: from sys.dual

1437: org_id,
1438: pa_org_use_type)
1439: (select x_organization_id,
1440: imp_rec.org_id, 'EXPENDITURES'
1441: from sys.dual
1442: where not exists ( select 'X'
1443: from pa_all_organizations
1444: where organization_id = x_organization_id
1445: and org_id = imp_rec.org_id --MOAC Changes: Bug 4363092: Removed nvl usage with org_id

Line 1482: from sys.dual

1478: org_id,
1479: pa_org_use_type)
1480: (select x_organization_id,
1481: imp_rec.org_id, 'EXPENDITURES'
1482: from sys.dual
1483: where not exists ( select 'X'
1484: from pa_all_organizations
1485: where organization_id = x_organization_id
1486: and org_id = imp_rec.org_id --MOAC Changes: Bug 4363092: Removed nvl usage with org_id

Line 1560: SELECT x_old_start_org_id FROM Sys.dual ;

1556: AND org_structure_version_id = x_old_org_version_id
1557: START WITH se.organization_id_parent = x_old_start_org_id
1558: AND org_structure_version_id = x_old_org_version_id
1559: UNION
1560: SELECT x_old_start_org_id FROM Sys.dual ;
1561:
1562: CURSOR cur_proj_new_org IS
1563: SELECT se.organization_id_child organization_id
1564: FROM per_org_structure_elements se

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

1574: AND org_structure_version_id = x_new_org_version_id
1575: START WITH se.organization_id_parent = x_new_start_org_id
1576: AND org_structure_version_id = x_new_org_version_id
1577: UNION
1578: SELECT x_new_start_org_id FROM Sys.dual -- Added exists clause for Bug# 1650520
1579: WHERE EXISTS (select 'X'
1580: from hr_organization_information info
1581: where info.org_information1 = 'PA_PROJECT_ORG'
1582: and info.org_information_context||'' = 'CLASS'

Line 1603: SELECT x_new_start_org_id FROM Sys.dual

1599: AND org_structure_version_id = x_new_org_version_id
1600: START WITH se.organization_id_parent = x_new_start_org_id
1601: AND org_structure_version_id = x_new_org_version_id
1602: UNION
1603: SELECT x_new_start_org_id FROM Sys.dual
1604: where EXISTS (select 'X' /* Made changes for BUG 1180635*/
1605: from hr_organization_information info
1606: where info.org_information1 = 'PA_EXPENDITURE_ORG'
1607: and info.org_information_context||'' = 'CLASS'

Line 1784: from dual

1780: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
1781: , sysdate
1782: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
1783: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
1784: from dual
1785: where not exists
1786: (select 'Y'
1787: from pa_org_hierarchy_denorm
1788: where pa_org_use_type = p_pa_org_use_type

Line 1888: from dual

1884: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
1885: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
1886: , p_parent_level
1887: , p_child_level
1888: from dual
1889: where not exists
1890: (select 'Y'
1891: from pa_org_hierarchy_denorm
1892: where pa_org_use_type = p_pa_org_use_type

Line 1962: from dual

1958: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
1959: , p_parent_org_level
1960: , p_child_org_level
1961: , p_org_id
1962: from dual
1963: where not exists
1964: (select 'Y'
1965: from pa_org_hierarchy_denorm
1966: where pa_org_use_type = p_pa_org_use_type

Line 2018: FROM dual

2014: -- example 200p - 205c,201p-205c,202p-205c,203p-205c,204p-205c,205p-205c
2015: -- where p is parent org and c is the child orgs
2016: cursor get_all_orgs is
2017: SELECT P_organization_id_parent
2018: FROM dual
2019: UNION
2020: (SELECT distinct organization_id_parent
2021: FROM per_org_structure_elements
2022: WHERE org_structure_version_id = P_org_version_id

Line 2041: (SELECT P_organization_id_child from dual);

2037: AND org_structure_version_id = P_org_version_id
2038: START WITH organization_id_child = P_start_org_id
2039: AND org_structure_version_id = P_org_version_id)
2040: UNION
2041: (SELECT P_organization_id_child from dual);
2042:
2043: BEGIN
2044:
2045: x_err_code := 0;

Line 2205: FROM dual

2201: cursor get_all_orgs(version_id NUMBER,start_org_id NUMBER) is
2202: SELECT dummy_level plevel --- This query is added to fix bug : 1619922
2203: ,start_org_id organization_id_parent
2204: ,start_org_id organization_id_child
2205: FROM dual
2206: UNION
2207: SELECT distinct
2208: level plevel
2209: ,organization_id_parent

Line 2231: FROM sys.dual)

2227: START WITH organization_id_parent = start_org_id
2228: and org_structure_version_id = version_id
2229: UNION
2230: SELECT v_start_org_id
2231: FROM sys.dual)
2232: INTERSECT
2233: (SELECT p_organization_id_parent
2234: FROM sys.dual );
2235:

Line 2234: FROM sys.dual );

2230: SELECT v_start_org_id
2231: FROM sys.dual)
2232: INTERSECT
2233: (SELECT p_organization_id_parent
2234: FROM sys.dual );
2235:
2236:
2237: BEGIN
2238:

Line 2726: FROM dual

2722: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
2723: , v_max_level
2724: , v_max_level
2725: , p_org_id
2726: FROM dual
2727: );
2728:
2729: --mano_msg('inserted ' || sql%rowcount || ' rows');
2730:

Line 2926: from dual

2922: x_exists number;
2923:
2924: Cursor check_lower_org_exists(p_org_id number) IS
2925: Select 1
2926: from dual
2927: where exists
2928: (select 1 from pa_org_hierarchy_denorm
2929: where org_hierarchy_version_id = x_org_version_id and
2930: pa_org_use_type = 'REPORTING' and

Line 3398: FROM dual

3394: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3395: , v_max_level
3396: , v_max_level
3397: , imp_rec.org_id
3398: FROM dual
3399: ); */
3400:
3401: END LOOP;
3402:

Line 3431: SELECT c_start_org_id FROM dual

3427:
3428: CURSOR c_get_new_org ( c_org_struct_ver_id IN per_org_structure_elements.org_structure_version_id%TYPE,
3429: c_start_org_id IN per_org_structure_elements.organization_id_child%TYPE)
3430: IS
3431: SELECT c_start_org_id FROM dual
3432: UNION ALL
3433: SELECT organization_id_child
3434: FROM per_org_structure_elements
3435: WHERE org_structure_version_id = c_org_struct_ver_id

Line 3444: FROM dual

3440:
3441: CURSOR c_get_sub_orgs (c_org_struct_ver_id IN per_org_structure_elements.org_structure_version_id%TYPE,
3442: c_org_id IN per_org_structure_elements.organization_id_child%TYPE) IS
3443: SELECT c_org_id
3444: FROM dual
3445: UNION ALL
3446: SELECT organization_id_child
3447: FROM per_org_structure_elements
3448: WHERE org_structure_version_id = c_org_struct_ver_id

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

3550: AND org_structure_version_id = x_org_version_id
3551: START WITH se.organization_id_parent = v_start_org_id
3552: AND org_structure_version_id = x_org_version_id
3553: UNION
3554: SELECT v_start_org_id FROM Sys.dual -- Added exists clause for Bug# 1650520
3555: WHERE EXISTS (select 'X'
3556: from hr_organization_information info
3557: where info.org_information1 = 'PA_PROJECT_ORG'
3558: and info.org_information_context||'' = 'CLASS'

Line 3578: SELECT v_start_org_id FROM Sys.dual

3574: AND org_structure_version_id = x_org_version_id
3575: START WITH se.organization_id_parent = v_start_org_id
3576: AND org_structure_version_id = x_org_version_id
3577: UNION
3578: SELECT v_start_org_id FROM Sys.dual
3579: where EXISTS (select 'X' /* Made changes for BUG 1180635*/
3580: from hr_organization_information info
3581: where info.org_information1 = 'PA_EXPENDITURE_ORG'
3582: and info.org_information_context||'' = 'CLASS'