APPS.PA_ORG_UTILS dependencies on FND_PROFILE

Line 1780: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))

1776: , p_child_organization_id
1777: , p_org_hierarchy_version_id
1778: , p_pa_org_use_type
1779: , sysdate
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

Line 1782: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))

1778: , p_pa_org_use_type
1779: , sysdate
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'

Line 1783: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))

1779: , sysdate
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

Line 1882: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))

1878: , p_child_organization_id
1879: , p_org_hierarchy_version_id
1880: , p_pa_org_use_type
1881: , sysdate
1882: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
1883: , sysdate
1884: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
1885: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
1886: , p_parent_level

Line 1884: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))

1880: , p_pa_org_use_type
1881: , sysdate
1882: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
1883: , sysdate
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

Line 1885: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))

1881: , sysdate
1882: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
1883: , sysdate
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

Line 1955: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)

1951: , p_child_organization_id
1952: , p_org_hierarchy_version_id
1953: , p_pa_org_use_type
1954: , sysdate
1955: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
1956: , sysdate
1957: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
1958: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
1959: , p_parent_org_level

Line 1957: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)

1953: , p_pa_org_use_type
1954: , sysdate
1955: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
1956: , sysdate
1957: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
1958: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
1959: , p_parent_org_level
1960: , p_child_org_level
1961: , p_org_id

Line 1958: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)

1954: , sysdate
1955: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
1956: , sysdate
1957: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
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

Line 2655: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)

2651: , organization_id_child
2652: , org_structure_version_id
2653: , 'REPORTING'
2654: , sysdate
2655: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2656: , sysdate
2657: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2658: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
2659: , c1rec.rev_level

Line 2657: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)

2653: , 'REPORTING'
2654: , sysdate
2655: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2656: , sysdate
2657: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2658: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
2659: , c1rec.rev_level
2660: , c1rec.rev_level - level
2661: , p_org_id

Line 2658: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)

2654: , sysdate
2655: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2656: , sysdate
2657: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2658: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
2659: , c1rec.rev_level
2660: , c1rec.rev_level - level
2661: , p_org_id
2662: FROM per_org_structure_elements a

Line 2701: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)

2697: , child_organization_id
2698: , org_hierarchy_version_id
2699: , 'REPORTING'
2700: , sysdate
2701: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2702: , sysdate
2703: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2704: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
2705: , child_level

Line 2703: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)

2699: , 'REPORTING'
2700: , sysdate
2701: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2702: , sysdate
2703: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2704: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
2705: , child_level
2706: , child_level
2707: , p_org_id

Line 2704: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)

2700: , sysdate
2701: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2702: , sysdate
2703: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2704: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
2705: , child_level
2706: , child_level
2707: , p_org_id
2708: FROM pa_org_hierarchy_denorm

Line 2719: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)

2715: , p_organization_id_parent
2716: , p_org_version_id
2717: , 'REPORTING'
2718: , sysdate
2719: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2720: , sysdate
2721: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2722: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
2723: , v_max_level

Line 2721: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)

2717: , 'REPORTING'
2718: , sysdate
2719: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2720: , sysdate
2721: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2722: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
2723: , v_max_level
2724: , v_max_level
2725: , p_org_id

Line 2722: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)

2718: , sysdate
2719: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2720: , sysdate
2721: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
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

Line 3217: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)

3213: ,l_child_organization_id_tbl(i)
3214: ,l_version_id
3215: ,'REPORTING'
3216: ,sysdate
3217: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3218: ,sysdate
3219: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3220: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3221: ,c1rec.rev_level

Line 3219: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)

3215: ,'REPORTING'
3216: ,sysdate
3217: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3218: ,sysdate
3219: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3220: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3221: ,c1rec.rev_level
3222: ,l_child_level_tbl(i)
3223: ,imp1_rec.org_id

Line 3220: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)

3216: ,sysdate
3217: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3218: ,sysdate
3219: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3220: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3221: ,c1rec.rev_level
3222: ,l_child_level_tbl(i)
3223: ,imp1_rec.org_id
3224: );

Line 3269: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)

3265: ,l_child_organization_id_tbl(i)
3266: ,l_version_id
3267: ,'REPORTING'
3268: ,sysdate
3269: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3270: ,sysdate
3271: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3272: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3273: ,l_child_level_tbl(i)

Line 3271: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)

3267: ,'REPORTING'
3268: ,sysdate
3269: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3270: ,sysdate
3271: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3272: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3273: ,l_child_level_tbl(i)
3274: ,l_child_level_tbl(i)
3275: ,imp1_rec.org_id

Line 3272: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)

3268: ,sysdate
3269: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3270: ,sysdate
3271: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3272: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3273: ,l_child_level_tbl(i)
3274: ,l_child_level_tbl(i)
3275: ,imp1_rec.org_id
3276: );

Line 3306: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)

3302: ,imp_rec.start_organization_id
3303: ,l_version_id
3304: ,'REPORTING'
3305: ,sysdate
3306: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3307: ,sysdate
3308: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3309: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3310: ,v_max_level

Line 3308: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)

3304: ,'REPORTING'
3305: ,sysdate
3306: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3307: ,sysdate
3308: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3309: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3310: ,v_max_level
3311: ,v_max_level
3312: ,imp1_rec.org_id

Line 3309: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)

3305: ,sysdate
3306: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3307: ,sysdate
3308: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3309: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3310: ,v_max_level
3311: ,v_max_level
3312: ,imp1_rec.org_id
3313: );

Line 3337: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)

3333: , organization_id_child
3334: , l_version_id
3335: , 'REPORTING'
3336: , sysdate
3337: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3338: , sysdate
3339: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3340: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3341: , c1rec.rev_level

Line 3339: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)

3335: , 'REPORTING'
3336: , sysdate
3337: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3338: , sysdate
3339: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3340: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3341: , c1rec.rev_level
3342: , c1rec.rev_level - level
3343: , imp_rec.org_id

Line 3340: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)

3336: , sysdate
3337: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3338: , sysdate
3339: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3340: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3341: , c1rec.rev_level
3342: , c1rec.rev_level - level
3343: , imp_rec.org_id
3344: FROM per_org_structure_elements a

Line 3373: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)

3369: , child_organization_id
3370: , org_hierarchy_version_id
3371: , 'REPORTING'
3372: , sysdate
3373: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3374: , sysdate
3375: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3376: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3377: , child_level

Line 3375: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)

3371: , 'REPORTING'
3372: , sysdate
3373: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3374: , sysdate
3375: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3376: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3377: , child_level
3378: , child_level
3379: , imp_rec.org_id

Line 3376: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)

3372: , sysdate
3373: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3374: , sysdate
3375: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3376: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3377: , child_level
3378: , child_level
3379: , imp_rec.org_id
3380: FROM pa_org_hierarchy_denorm

Line 3391: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)

3387: , imp_rec.start_organization_id
3388: , l_version_id
3389: , 'REPORTING'
3390: , sysdate
3391: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3392: , sysdate
3393: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3394: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3395: , v_max_level

Line 3393: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)

3389: , 'REPORTING'
3390: , sysdate
3391: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3392: , sysdate
3393: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3394: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3395: , v_max_level
3396: , v_max_level
3397: , imp_rec.org_id

Line 3394: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)

3390: , sysdate
3391: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3392: , sysdate
3393: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
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