APPS.PA_ORG_UTILS dependencies on FND_PROFILE

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

405: , l_child_org_id_var(i)
406: , x_new_proj_org_version_id
407: , 'PROJECTS'
408: , sysdate
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

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

407: , 'PROJECTS'
408: , sysdate
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'

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

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

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

552: , l_child_org_id_var(i)
553: , x_new_exp_org_version_id
554: , 'EXPENDITURES'
555: , sysdate
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

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

554: , 'EXPENDITURES'
555: , sysdate
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'

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

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

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

810: , l_tmp_child_org_id_var(i)
811: , p_org_version_id
812: , 'TP_SCHEDULE'
813: , sysdate
814: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
815: , sysdate
816: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
817: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
818: , l_plevel

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

812: , 'TP_SCHEDULE'
813: , sysdate
814: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
815: , sysdate
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

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

813: , sysdate
814: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
815: , sysdate
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

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

1094: , x_organization_id_child
1095: , x_org_version_id
1096: , 'PROJECTS'
1097: , sysdate
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

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

1096: , 'PROJECTS'
1097: , sysdate
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'

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

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

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

1238: , x_organization_id_child
1239: , x_org_version_id
1240: , 'EXPENDITURES'
1241: , sysdate
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

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

1240: , 'EXPENDITURES'
1241: , sysdate
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'

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

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

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

1983: , p_child_organization_id
1984: , p_org_hierarchy_version_id
1985: , p_pa_org_use_type
1986: , sysdate
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

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

1985: , p_pa_org_use_type
1986: , sysdate
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'

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

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

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

2085: , p_child_organization_id
2086: , p_org_hierarchy_version_id
2087: , p_pa_org_use_type
2088: , sysdate
2089: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
2090: , sysdate
2091: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
2092: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
2093: , p_parent_level

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

2087: , p_pa_org_use_type
2088: , sysdate
2089: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
2090: , sysdate
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

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

2088: , sysdate
2089: ,1-- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
2090: , sysdate
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

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

2158: , p_child_organization_id
2159: , p_org_hierarchy_version_id
2160: , p_pa_org_use_type
2161: , sysdate
2162: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2163: , sysdate
2164: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2165: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
2166: , p_parent_org_level

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

2160: , p_pa_org_use_type
2161: , sysdate
2162: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2163: , sysdate
2164: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2165: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
2166: , p_parent_org_level
2167: , p_child_org_level
2168: , p_org_id

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

2161: , sysdate
2162: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2163: , sysdate
2164: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
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

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

2858: , organization_id_child
2859: , org_structure_version_id
2860: , 'REPORTING'
2861: , sysdate
2862: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2863: , sysdate
2864: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2865: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
2866: , c1rec.rev_level

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

2860: , 'REPORTING'
2861: , sysdate
2862: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2863: , sysdate
2864: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2865: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
2866: , c1rec.rev_level
2867: , c1rec.rev_level - level
2868: , p_org_id

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

2861: , sysdate
2862: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2863: , sysdate
2864: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2865: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
2866: , c1rec.rev_level
2867: , c1rec.rev_level - level
2868: , p_org_id
2869: FROM per_org_structure_elements a

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

2904: , child_organization_id
2905: , org_hierarchy_version_id
2906: , 'REPORTING'
2907: , sysdate
2908: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2909: , sysdate
2910: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2911: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
2912: , child_level

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

2906: , 'REPORTING'
2907: , sysdate
2908: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2909: , sysdate
2910: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2911: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
2912: , child_level
2913: , child_level
2914: , p_org_id

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

2907: , sysdate
2908: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2909: , sysdate
2910: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2911: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
2912: , child_level
2913: , child_level
2914: , p_org_id
2915: FROM pa_org_hierarchy_denorm

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

2922: , p_organization_id_parent
2923: , p_org_version_id
2924: , 'REPORTING'
2925: , sysdate
2926: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2927: , sysdate
2928: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2929: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
2930: , v_max_level

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

2924: , 'REPORTING'
2925: , sysdate
2926: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2927: , sysdate
2928: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2929: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
2930: , v_max_level
2931: , v_max_level
2932: , p_org_id

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

2925: , sysdate
2926: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
2927: , sysdate
2928: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
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

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

3420: ,l_child_organization_id_tbl(i)
3421: ,l_version_id
3422: ,'REPORTING'
3423: ,sysdate
3424: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3425: ,sysdate
3426: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3427: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3428: ,c1rec.rev_level

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

3422: ,'REPORTING'
3423: ,sysdate
3424: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3425: ,sysdate
3426: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3427: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3428: ,c1rec.rev_level
3429: ,l_child_level_tbl(i)
3430: ,imp1_rec.org_id

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

3423: ,sysdate
3424: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3425: ,sysdate
3426: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3427: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3428: ,c1rec.rev_level
3429: ,l_child_level_tbl(i)
3430: ,imp1_rec.org_id
3431: );

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

3472: ,l_child_organization_id_tbl(i)
3473: ,l_version_id
3474: ,'REPORTING'
3475: ,sysdate
3476: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3477: ,sysdate
3478: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3479: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3480: ,l_child_level_tbl(i)

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

3474: ,'REPORTING'
3475: ,sysdate
3476: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3477: ,sysdate
3478: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3479: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3480: ,l_child_level_tbl(i)
3481: ,l_child_level_tbl(i)
3482: ,imp1_rec.org_id

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

3475: ,sysdate
3476: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3477: ,sysdate
3478: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3479: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3480: ,l_child_level_tbl(i)
3481: ,l_child_level_tbl(i)
3482: ,imp1_rec.org_id
3483: );

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

3509: ,imp_rec.start_organization_id
3510: ,l_version_id
3511: ,'REPORTING'
3512: ,sysdate
3513: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3514: ,sysdate
3515: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3516: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3517: ,v_max_level

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

3511: ,'REPORTING'
3512: ,sysdate
3513: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3514: ,sysdate
3515: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3516: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3517: ,v_max_level
3518: ,v_max_level
3519: ,imp1_rec.org_id

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

3512: ,sysdate
3513: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3514: ,sysdate
3515: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3516: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3517: ,v_max_level
3518: ,v_max_level
3519: ,imp1_rec.org_id
3520: );

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

3540: , organization_id_child
3541: , l_version_id
3542: , 'REPORTING'
3543: , sysdate
3544: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3545: , sysdate
3546: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3547: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3548: , c1rec.rev_level

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

3542: , 'REPORTING'
3543: , sysdate
3544: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3545: , sysdate
3546: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3547: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3548: , c1rec.rev_level
3549: , c1rec.rev_level - level
3550: , imp_rec.org_id

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

3543: , sysdate
3544: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3545: , sysdate
3546: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3547: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3548: , c1rec.rev_level
3549: , c1rec.rev_level - level
3550: , imp_rec.org_id
3551: FROM per_org_structure_elements a

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

3576: , child_organization_id
3577: , org_hierarchy_version_id
3578: , 'REPORTING'
3579: , sysdate
3580: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3581: , sysdate
3582: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3583: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3584: , child_level

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

3578: , 'REPORTING'
3579: , sysdate
3580: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3581: , sysdate
3582: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3583: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3584: , child_level
3585: , child_level
3586: , imp_rec.org_id

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

3579: , sysdate
3580: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3581: , sysdate
3582: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3583: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3584: , child_level
3585: , child_level
3586: , imp_rec.org_id
3587: FROM pa_org_hierarchy_denorm

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

3594: , imp_rec.start_organization_id
3595: , l_version_id
3596: , 'REPORTING'
3597: , sysdate
3598: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3599: , sysdate
3600: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3601: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3602: , v_max_level

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

3596: , 'REPORTING'
3597: , sysdate
3598: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3599: , sysdate
3600: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3601: , nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),1)
3602: , v_max_level
3603: , v_max_level
3604: , imp_rec.org_id

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

3597: , sysdate
3598: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
3599: , sysdate
3600: , nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),1)
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

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

3743: , l_child_org_id2_var(i)
3744: , p_version_id
3745: , p_org_use_type
3746: , sysdate
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

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

3745: , p_org_use_type
3746: , sysdate
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'

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

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

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

3783: , per_org.child
3784: , p_version_id
3785: , p_org_use_type
3786: , sysdate
3787: , 1 -- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
3788: , sysdate
3789: , 1 -- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
3790: , 1 -- , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
3791: from (

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

3785: , p_org_use_type
3786: , sysdate
3787: , 1 -- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
3788: , sysdate
3789: , 1 -- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
3790: , 1 -- , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
3791: from (
3792: SELECT
3793: to_number(substrb(sys_connect_by_path(child_outer, '.'),

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

3786: , sysdate
3787: , 1 -- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
3788: , sysdate
3789: , 1 -- , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
3790: , 1 -- , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
3791: from (
3792: SELECT
3793: to_number(substrb(sys_connect_by_path(child_outer, '.'),
3794: instr(sys_connect_by_path(child_outer, '.'), '.',1,1)+1,