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_RBS_UTILS dependencies on FND_GLOBAL

Line 449: FND_GLOBAL.USER_ID,

445: PA_RBS_ELEMENT_NAMES_S.NEXTVAL,
446: a.resource_source_id,
447: a.resource_type_id,
448: sysdate,
449: FND_GLOBAL.USER_ID,
450: sysdate,
451: FND_GLOBAL.USER_ID,
452: FND_GLOBAL.LOGIN_ID
453: FROM pa_rbs_elem_in_temp a

Line 451: FND_GLOBAL.USER_ID,

447: a.resource_type_id,
448: sysdate,
449: FND_GLOBAL.USER_ID,
450: sysdate,
451: FND_GLOBAL.USER_ID,
452: FND_GLOBAL.LOGIN_ID
453: FROM pa_rbs_elem_in_temp a
454: WHERE a.resource_type_id = p_resource_type_id
455: AND NOT EXISTS (select 'Y'

Line 452: FND_GLOBAL.LOGIN_ID

448: sysdate,
449: FND_GLOBAL.USER_ID,
450: sysdate,
451: FND_GLOBAL.USER_ID,
452: FND_GLOBAL.LOGIN_ID
453: FROM pa_rbs_elem_in_temp a
454: WHERE a.resource_type_id = p_resource_type_id
455: AND NOT EXISTS (select 'Y'
456: FROM Pa_rbs_element_names_b b

Line 504: FND_GLOBAL.USER_ID,

500: c.name,
501: c.language,
502: c.source_lang,
503: sysdate,
504: FND_GLOBAL.USER_ID,
505: sysdate,
506: FND_GLOBAL.USER_ID,
507: FND_GLOBAL.LOGIN_ID
508: FROM

Line 506: FND_GLOBAL.USER_ID,

502: c.source_lang,
503: sysdate,
504: FND_GLOBAL.USER_ID,
505: sysdate,
506: FND_GLOBAL.USER_ID,
507: FND_GLOBAL.LOGIN_ID
508: FROM
509: pa_rbs_element_names_b a,
510: pa_rbs_elem_in_temp b,

Line 507: FND_GLOBAL.LOGIN_ID

503: sysdate,
504: FND_GLOBAL.USER_ID,
505: sysdate,
506: FND_GLOBAL.USER_ID,
507: FND_GLOBAL.LOGIN_ID
508: FROM
509: pa_rbs_element_names_b a,
510: pa_rbs_elem_in_temp b,
511: Pa_rbs_versions_tl c

Line 539: FND_GLOBAL.USER_ID,

535: c.meaning,
536: c.language,
537: c.source_lang,
538: sysdate,
539: FND_GLOBAL.USER_ID,
540: sysdate,
541: FND_GLOBAL.USER_ID,
542: FND_GLOBAL.LOGIN_ID
543: FROM

Line 541: FND_GLOBAL.USER_ID,

537: c.source_lang,
538: sysdate,
539: FND_GLOBAL.USER_ID,
540: sysdate,
541: FND_GLOBAL.USER_ID,
542: FND_GLOBAL.LOGIN_ID
543: FROM
544: pa_rbs_element_names_b a,
545: pa_rbs_elem_in_temp b,

Line 542: FND_GLOBAL.LOGIN_ID

538: sysdate,
539: FND_GLOBAL.USER_ID,
540: sysdate,
541: FND_GLOBAL.USER_ID,
542: FND_GLOBAL.LOGIN_ID
543: FROM
544: pa_rbs_element_names_b a,
545: pa_rbs_elem_in_temp b,
546: fnd_lookup_values c

Line 577: FND_GLOBAL.USER_ID,

573: c.full_name,
574: l.language_code,
575: USERENV('LANG'),
576: sysdate,
577: FND_GLOBAL.USER_ID,
578: sysdate,
579: FND_GLOBAL.USER_ID,
580: FND_GLOBAL.LOGIN_ID
581: FROM

Line 579: FND_GLOBAL.USER_ID,

575: USERENV('LANG'),
576: sysdate,
577: FND_GLOBAL.USER_ID,
578: sysdate,
579: FND_GLOBAL.USER_ID,
580: FND_GLOBAL.LOGIN_ID
581: FROM
582: pa_rbs_element_names_b a,
583: pa_rbs_elem_in_temp b,

Line 580: FND_GLOBAL.LOGIN_ID

576: sysdate,
577: FND_GLOBAL.USER_ID,
578: sysdate,
579: FND_GLOBAL.USER_ID,
580: FND_GLOBAL.LOGIN_ID
581: FROM
582: pa_rbs_element_names_b a,
583: pa_rbs_elem_in_temp b,
584: per_all_people_f c,

Line 617: FND_GLOBAL.USER_ID,

613: c.name,
614: l.language_code,
615: USERENV('LANG'),
616: sysdate,
617: FND_GLOBAL.USER_ID,
618: sysdate,
619: FND_GLOBAL.USER_ID,
620: FND_GLOBAL.LOGIN_ID
621: FROM

Line 619: FND_GLOBAL.USER_ID,

615: USERENV('LANG'),
616: sysdate,
617: FND_GLOBAL.USER_ID,
618: sysdate,
619: FND_GLOBAL.USER_ID,
620: FND_GLOBAL.LOGIN_ID
621: FROM
622: pa_rbs_element_names_b a,
623: pa_rbs_elem_in_temp b,

Line 620: FND_GLOBAL.LOGIN_ID

616: sysdate,
617: FND_GLOBAL.USER_ID,
618: sysdate,
619: FND_GLOBAL.USER_ID,
620: FND_GLOBAL.LOGIN_ID
621: FROM
622: pa_rbs_element_names_b a,
623: pa_rbs_elem_in_temp b,
624: Per_Jobs c,

Line 654: FND_GLOBAL.USER_ID,

650: lk.meaning,
651: lk.language,
652: lk.source_lang,
653: sysdate,
654: FND_GLOBAL.USER_ID,
655: sysdate,
656: FND_GLOBAL.USER_ID,
657: FND_GLOBAL.LOGIN_ID
658: FROM

Line 656: FND_GLOBAL.USER_ID,

652: lk.source_lang,
653: sysdate,
654: FND_GLOBAL.USER_ID,
655: sysdate,
656: FND_GLOBAL.USER_ID,
657: FND_GLOBAL.LOGIN_ID
658: FROM
659: pa_rbs_element_names_b a,
660: pa_rbs_elem_in_temp b,

Line 657: FND_GLOBAL.LOGIN_ID

653: sysdate,
654: FND_GLOBAL.USER_ID,
655: sysdate,
656: FND_GLOBAL.USER_ID,
657: FND_GLOBAL.LOGIN_ID
658: FROM
659: pa_rbs_element_names_b a,
660: pa_rbs_elem_in_temp b,
661: fnd_lookup_values lk,

Line 698: FND_GLOBAL.USER_ID,

694: c.resource_code, --End of bug 3602566.
695: l.language_code,
696: USERENV('LANG'),
697: sysdate,
698: FND_GLOBAL.USER_ID,
699: sysdate,
700: FND_GLOBAL.USER_ID,
701: FND_GLOBAL.LOGIN_ID
702: FROM

Line 700: FND_GLOBAL.USER_ID,

696: USERENV('LANG'),
697: sysdate,
698: FND_GLOBAL.USER_ID,
699: sysdate,
700: FND_GLOBAL.USER_ID,
701: FND_GLOBAL.LOGIN_ID
702: FROM
703: pa_rbs_element_names_b a,
704: pa_rbs_elem_in_temp b,

Line 701: FND_GLOBAL.LOGIN_ID

697: sysdate,
698: FND_GLOBAL.USER_ID,
699: sysdate,
700: FND_GLOBAL.USER_ID,
701: FND_GLOBAL.LOGIN_ID
702: FROM
703: pa_rbs_element_names_b a,
704: pa_rbs_elem_in_temp b,
705: Bom_Resources c,

Line 737: FND_GLOBAL.USER_ID,

733: c.non_labor_resource,
734: l.language_code,
735: USERENV('LANG'),
736: sysdate,
737: FND_GLOBAL.USER_ID,
738: sysdate,
739: FND_GLOBAL.USER_ID,
740: FND_GLOBAL.LOGIN_ID
741: FROM

Line 739: FND_GLOBAL.USER_ID,

735: USERENV('LANG'),
736: sysdate,
737: FND_GLOBAL.USER_ID,
738: sysdate,
739: FND_GLOBAL.USER_ID,
740: FND_GLOBAL.LOGIN_ID
741: FROM
742: pa_rbs_element_names_b a,
743: pa_rbs_elem_in_temp b,

Line 740: FND_GLOBAL.LOGIN_ID

736: sysdate,
737: FND_GLOBAL.USER_ID,
738: sysdate,
739: FND_GLOBAL.USER_ID,
740: FND_GLOBAL.LOGIN_ID
741: FROM
742: pa_rbs_element_names_b a,
743: pa_rbs_elem_in_temp b,
744: pa_non_labor_resources c,

Line 775: FND_GLOBAL.USER_ID,

771: c.name,
772: c.language,
773: c.source_lang, --USERENV('LANG'),
774: sysdate,
775: FND_GLOBAL.USER_ID,
776: sysdate,
777: FND_GLOBAL.USER_ID,
778: FND_GLOBAL.LOGIN_ID
779: FROM

Line 777: FND_GLOBAL.USER_ID,

773: c.source_lang, --USERENV('LANG'),
774: sysdate,
775: FND_GLOBAL.USER_ID,
776: sysdate,
777: FND_GLOBAL.USER_ID,
778: FND_GLOBAL.LOGIN_ID
779: FROM
780: pa_rbs_element_names_b a,
781: pa_rbs_elem_in_temp b,

Line 778: FND_GLOBAL.LOGIN_ID

774: sysdate,
775: FND_GLOBAL.USER_ID,
776: sysdate,
777: FND_GLOBAL.USER_ID,
778: FND_GLOBAL.LOGIN_ID
779: FROM
780: pa_rbs_element_names_b a,
781: pa_rbs_elem_in_temp b,
782: Pa_Resource_Classes_tl c

Line 813: FND_GLOBAL.USER_ID,

809: c.resource_name,
810: l.language_code,
811: USERENV('LANG'),
812: sysdate,
813: FND_GLOBAL.USER_ID,
814: sysdate,
815: FND_GLOBAL.USER_ID,
816: FND_GLOBAL.LOGIN_ID
817: FROM

Line 815: FND_GLOBAL.USER_ID,

811: USERENV('LANG'),
812: sysdate,
813: FND_GLOBAL.USER_ID,
814: sysdate,
815: FND_GLOBAL.USER_ID,
816: FND_GLOBAL.LOGIN_ID
817: FROM
818: pa_rbs_element_names_b a,
819: pa_rbs_elem_in_temp b,

Line 816: FND_GLOBAL.LOGIN_ID

812: sysdate,
813: FND_GLOBAL.USER_ID,
814: sysdate,
815: FND_GLOBAL.USER_ID,
816: FND_GLOBAL.LOGIN_ID
817: FROM
818: pa_rbs_element_names_b a,
819: pa_rbs_elem_in_temp b,
820: Pa_rbs_element_map c,

Line 853: FND_GLOBAL.USER_ID,

849: lk.meaning, --c.resource_name,
850: lk.language,
851: lk.source_lang,
852: sysdate,
853: FND_GLOBAL.USER_ID,
854: sysdate,
855: FND_GLOBAL.USER_ID,
856: FND_GLOBAL.LOGIN_ID
857: FROM

Line 855: FND_GLOBAL.USER_ID,

851: lk.source_lang,
852: sysdate,
853: FND_GLOBAL.USER_ID,
854: sysdate,
855: FND_GLOBAL.USER_ID,
856: FND_GLOBAL.LOGIN_ID
857: FROM
858: pa_rbs_element_names_b a,
859: pa_rbs_elem_in_temp b,

Line 856: FND_GLOBAL.LOGIN_ID

852: sysdate,
853: FND_GLOBAL.USER_ID,
854: sysdate,
855: FND_GLOBAL.USER_ID,
856: FND_GLOBAL.LOGIN_ID
857: FROM
858: pa_rbs_element_names_b a,
859: pa_rbs_elem_in_temp b,
860: Pa_rbs_element_map c,

Line 894: FND_GLOBAL.USER_ID,

890: c.event_type,
891: l.language_code,
892: USERENV('LANG'),
893: sysdate,
894: FND_GLOBAL.USER_ID,
895: sysdate,
896: FND_GLOBAL.USER_ID,
897: FND_GLOBAL.LOGIN_ID
898: FROM

Line 896: FND_GLOBAL.USER_ID,

892: USERENV('LANG'),
893: sysdate,
894: FND_GLOBAL.USER_ID,
895: sysdate,
896: FND_GLOBAL.USER_ID,
897: FND_GLOBAL.LOGIN_ID
898: FROM
899: pa_rbs_element_names_b a,
900: pa_rbs_elem_in_temp b,

Line 897: FND_GLOBAL.LOGIN_ID

893: sysdate,
894: FND_GLOBAL.USER_ID,
895: sysdate,
896: FND_GLOBAL.USER_ID,
897: FND_GLOBAL.LOGIN_ID
898: FROM
899: pa_rbs_element_names_b a,
900: pa_rbs_elem_in_temp b,
901: pa_event_types c,

Line 933: FND_GLOBAL.USER_ID,

929: c.expenditure_type,
930: l.language_code,
931: USERENV('LANG'),
932: sysdate,
933: FND_GLOBAL.USER_ID,
934: sysdate,
935: FND_GLOBAL.USER_ID,
936: FND_GLOBAL.LOGIN_ID
937: FROM

Line 935: FND_GLOBAL.USER_ID,

931: USERENV('LANG'),
932: sysdate,
933: FND_GLOBAL.USER_ID,
934: sysdate,
935: FND_GLOBAL.USER_ID,
936: FND_GLOBAL.LOGIN_ID
937: FROM
938: pa_rbs_element_names_b a,
939: pa_rbs_elem_in_temp b,

Line 936: FND_GLOBAL.LOGIN_ID

932: sysdate,
933: FND_GLOBAL.USER_ID,
934: sysdate,
935: FND_GLOBAL.USER_ID,
936: FND_GLOBAL.LOGIN_ID
937: FROM
938: pa_rbs_element_names_b a,
939: pa_rbs_elem_in_temp b,
940: pa_expenditure_types c,

Line 972: FND_GLOBAL.USER_ID,

968: c.expenditure_category,
969: l.language_code,
970: USERENV('LANG'),
971: sysdate,
972: FND_GLOBAL.USER_ID,
973: sysdate,
974: FND_GLOBAL.USER_ID,
975: FND_GLOBAL.LOGIN_ID
976: FROM

Line 974: FND_GLOBAL.USER_ID,

970: USERENV('LANG'),
971: sysdate,
972: FND_GLOBAL.USER_ID,
973: sysdate,
974: FND_GLOBAL.USER_ID,
975: FND_GLOBAL.LOGIN_ID
976: FROM
977: pa_rbs_element_names_b a,
978: pa_rbs_elem_in_temp b,

Line 975: FND_GLOBAL.LOGIN_ID

971: sysdate,
972: FND_GLOBAL.USER_ID,
973: sysdate,
974: FND_GLOBAL.USER_ID,
975: FND_GLOBAL.LOGIN_ID
976: FROM
977: pa_rbs_element_names_b a,
978: pa_rbs_elem_in_temp b,
979: pa_expenditure_categories c,

Line 1011: FND_GLOBAL.USER_ID,

1007: c.vendor_name,
1008: l.language_code,
1009: USERENV('LANG'),
1010: sysdate,
1011: FND_GLOBAL.USER_ID,
1012: sysdate,
1013: FND_GLOBAL.USER_ID,
1014: FND_GLOBAL.LOGIN_ID
1015: FROM

Line 1013: FND_GLOBAL.USER_ID,

1009: USERENV('LANG'),
1010: sysdate,
1011: FND_GLOBAL.USER_ID,
1012: sysdate,
1013: FND_GLOBAL.USER_ID,
1014: FND_GLOBAL.LOGIN_ID
1015: FROM
1016: pa_rbs_element_names_b a,
1017: pa_rbs_elem_in_temp b,

Line 1014: FND_GLOBAL.LOGIN_ID

1010: sysdate,
1011: FND_GLOBAL.USER_ID,
1012: sysdate,
1013: FND_GLOBAL.USER_ID,
1014: FND_GLOBAL.LOGIN_ID
1015: FROM
1016: pa_rbs_element_names_b a,
1017: pa_rbs_elem_in_temp b,
1018: po_vendors c,

Line 1074: FND_GLOBAL.USER_ID,

1070: c.name,
1071: c.language,
1072: c.source_lang,
1073: sysdate,
1074: FND_GLOBAL.USER_ID,
1075: sysdate,
1076: FND_GLOBAL.USER_ID,
1077: FND_GLOBAL.LOGIN_ID
1078: FROM

Line 1076: FND_GLOBAL.USER_ID,

1072: c.source_lang,
1073: sysdate,
1074: FND_GLOBAL.USER_ID,
1075: sysdate,
1076: FND_GLOBAL.USER_ID,
1077: FND_GLOBAL.LOGIN_ID
1078: FROM
1079: pa_rbs_element_names_b a,
1080: pa_rbs_elem_in_temp b,

Line 1077: FND_GLOBAL.LOGIN_ID

1073: sysdate,
1074: FND_GLOBAL.USER_ID,
1075: sysdate,
1076: FND_GLOBAL.USER_ID,
1077: FND_GLOBAL.LOGIN_ID
1078: FROM
1079: pa_rbs_element_names_b a,
1080: pa_rbs_elem_in_temp b,
1081: hr_all_organization_units_tl c

Line 1110: FND_GLOBAL.USER_ID,

1106: c.meaning,
1107: c.language,
1108: c.source_lang,
1109: sysdate,
1110: FND_GLOBAL.USER_ID,
1111: sysdate,
1112: FND_GLOBAL.USER_ID,
1113: FND_GLOBAL.LOGIN_ID
1114: FROM

Line 1112: FND_GLOBAL.USER_ID,

1108: c.source_lang,
1109: sysdate,
1110: FND_GLOBAL.USER_ID,
1111: sysdate,
1112: FND_GLOBAL.USER_ID,
1113: FND_GLOBAL.LOGIN_ID
1114: FROM
1115: pa_rbs_element_names_b a,
1116: pa_rbs_elem_in_temp b,

Line 1113: FND_GLOBAL.LOGIN_ID

1109: sysdate,
1110: FND_GLOBAL.USER_ID,
1111: sysdate,
1112: FND_GLOBAL.USER_ID,
1113: FND_GLOBAL.LOGIN_ID
1114: FROM
1115: pa_rbs_element_names_b a,
1116: pa_rbs_elem_in_temp b,
1117: Pa_Project_Role_Types_tl c

Line 1147: FND_GLOBAL.USER_ID,

1143: c.structure_id, c.category_id),
1144: l.language_code,
1145: USERENV('LANG'),
1146: sysdate,
1147: FND_GLOBAL.USER_ID,
1148: sysdate,
1149: FND_GLOBAL.USER_ID,
1150: FND_GLOBAL.LOGIN_ID
1151: FROM

Line 1149: FND_GLOBAL.USER_ID,

1145: USERENV('LANG'),
1146: sysdate,
1147: FND_GLOBAL.USER_ID,
1148: sysdate,
1149: FND_GLOBAL.USER_ID,
1150: FND_GLOBAL.LOGIN_ID
1151: FROM
1152: pa_rbs_element_names_b a,
1153: pa_rbs_elem_in_temp b,

Line 1150: FND_GLOBAL.LOGIN_ID

1146: sysdate,
1147: FND_GLOBAL.USER_ID,
1148: sysdate,
1149: FND_GLOBAL.USER_ID,
1150: FND_GLOBAL.LOGIN_ID
1151: FROM
1152: pa_rbs_element_names_b a,
1153: pa_rbs_elem_in_temp b,
1154: Fnd_Languages L,

Line 1188: FND_GLOBAL.USER_ID,

1184: d.segment1,
1185: c.language,
1186: c.source_lang,
1187: sysdate,
1188: FND_GLOBAL.USER_ID,
1189: sysdate,
1190: FND_GLOBAL.USER_ID,
1191: FND_GLOBAL.LOGIN_ID
1192: FROM

Line 1190: FND_GLOBAL.USER_ID,

1186: c.source_lang,
1187: sysdate,
1188: FND_GLOBAL.USER_ID,
1189: sysdate,
1190: FND_GLOBAL.USER_ID,
1191: FND_GLOBAL.LOGIN_ID
1192: FROM
1193: pa_rbs_element_names_b a,
1194: pa_rbs_elem_in_temp b,

Line 1191: FND_GLOBAL.LOGIN_ID

1187: sysdate,
1188: FND_GLOBAL.USER_ID,
1189: sysdate,
1190: FND_GLOBAL.USER_ID,
1191: FND_GLOBAL.LOGIN_ID
1192: FROM
1193: pa_rbs_element_names_b a,
1194: pa_rbs_elem_in_temp b,
1195: Mtl_System_Items_tl c,

Line 1584: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));

1580: --Print report heading
1581: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,TO_CHAR(sysdate,'DD-MON-YYYY')||
1582: ' '||
1583: 'PARRCSUB - Refresh RBS Element Names');
1584: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
1585:
1586:
1587: IF PG_DEBUG = 'Y' THEN
1588: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||': '||

Line 1624: fnd_global.user_id,

1620: lk.meaning,
1621: lk.language,
1622: lk.source_lang,
1623: sysdate,
1624: fnd_global.user_id,
1625: sysdate,
1626: fnd_global.user_id,
1627: fnd_global.login_id
1628: FROM --pa_lookups lk,

Line 1626: fnd_global.user_id,

1622: lk.source_lang,
1623: sysdate,
1624: fnd_global.user_id,
1625: sysdate,
1626: fnd_global.user_id,
1627: fnd_global.login_id
1628: FROM --pa_lookups lk,
1629: fnd_lookup_values lk,
1630: pa_rbs_element_names_b a

Line 1627: fnd_global.login_id

1623: sysdate,
1624: fnd_global.user_id,
1625: sysdate,
1626: fnd_global.user_id,
1627: fnd_global.login_id
1628: FROM --pa_lookups lk,
1629: fnd_lookup_values lk,
1630: pa_rbs_element_names_b a
1631: WHERE

Line 1663: fnd_global.user_id,

1659: vertl.name,
1660: vertl.language,
1661: vertl.source_lang,
1662: sysdate,
1663: fnd_global.user_id,
1664: sysdate,
1665: fnd_global.user_id,
1666: fnd_global.login_id
1667: FROM pa_rbs_versions_tl vertl,

Line 1665: fnd_global.user_id,

1661: vertl.source_lang,
1662: sysdate,
1663: fnd_global.user_id,
1664: sysdate,
1665: fnd_global.user_id,
1666: fnd_global.login_id
1667: FROM pa_rbs_versions_tl vertl,
1668: pa_rbs_element_names_b b
1669: WHERE b.resource_type_id = -1

Line 1666: fnd_global.login_id

1662: sysdate,
1663: fnd_global.user_id,
1664: sysdate,
1665: fnd_global.user_id,
1666: fnd_global.login_id
1667: FROM pa_rbs_versions_tl vertl,
1668: pa_rbs_element_names_b b
1669: WHERE b.resource_type_id = -1
1670: AND b.resource_source_id = vertl.rbs_version_id);

Line 1713: fnd_global.user_id,

1709: --b.description,--For bug 3602566
1710: l.language_code,
1711: USERENV('LANG'),
1712: sysdate,
1713: fnd_global.user_id,
1714: sysdate,
1715: fnd_global.user_id,
1716: fnd_global.login_id
1717: FROM bom_resources b,

Line 1715: fnd_global.user_id,

1711: USERENV('LANG'),
1712: sysdate,
1713: fnd_global.user_id,
1714: sysdate,
1715: fnd_global.user_id,
1716: fnd_global.login_id
1717: FROM bom_resources b,
1718: pa_rbs_element_names_b a,
1719: Fnd_Languages L

Line 1716: fnd_global.login_id

1712: sysdate,
1713: fnd_global.user_id,
1714: sysdate,
1715: fnd_global.user_id,
1716: fnd_global.login_id
1717: FROM bom_resources b,
1718: pa_rbs_element_names_b a,
1719: Fnd_Languages L
1720: WHERE a.resource_type_id = 1

Line 1754: fnd_global.user_id,

1750: --b.description,--For bug 3602566
1751: l.language_code,
1752: USERENV('LANG'),
1753: sysdate,
1754: fnd_global.user_id,
1755: sysdate,
1756: fnd_global.user_id,
1757: fnd_global.login_id
1758: FROM bom_resources b,

Line 1756: fnd_global.user_id,

1752: USERENV('LANG'),
1753: sysdate,
1754: fnd_global.user_id,
1755: sysdate,
1756: fnd_global.user_id,
1757: fnd_global.login_id
1758: FROM bom_resources b,
1759: pa_rbs_element_names_b a,
1760: Fnd_Languages L

Line 1757: fnd_global.login_id

1753: sysdate,
1754: fnd_global.user_id,
1755: sysdate,
1756: fnd_global.user_id,
1757: fnd_global.login_id
1758: FROM bom_resources b,
1759: pa_rbs_element_names_b a,
1760: Fnd_Languages L
1761: WHERE a.resource_type_id = 2

Line 1795: fnd_global.user_id,

1791: per.full_name,
1792: l.language_code,
1793: USERENV('LANG'),
1794: sysdate,
1795: fnd_global.user_id,
1796: sysdate,
1797: fnd_global.user_id,
1798: fnd_global.login_id
1799: FROM per_all_people_f per,

Line 1797: fnd_global.user_id,

1793: USERENV('LANG'),
1794: sysdate,
1795: fnd_global.user_id,
1796: sysdate,
1797: fnd_global.user_id,
1798: fnd_global.login_id
1799: FROM per_all_people_f per,
1800: pa_rbs_element_names_b b,
1801: Fnd_Languages L

Line 1798: fnd_global.login_id

1794: sysdate,
1795: fnd_global.user_id,
1796: sysdate,
1797: fnd_global.user_id,
1798: fnd_global.login_id
1799: FROM per_all_people_f per,
1800: pa_rbs_element_names_b b,
1801: Fnd_Languages L
1802: WHERE TRUNC(sysdate) BETWEEN

Line 1839: fnd_global.user_id,

1835: E.EVENT_TYPE,
1836: l.language_code,
1837: USERENV('LANG'),
1838: sysdate,
1839: fnd_global.user_id,
1840: sysdate,
1841: fnd_global.user_id,
1842: fnd_global.login_id
1843: FROM PA_EVENT_TYPES E,

Line 1841: fnd_global.user_id,

1837: USERENV('LANG'),
1838: sysdate,
1839: fnd_global.user_id,
1840: sysdate,
1841: fnd_global.user_id,
1842: fnd_global.login_id
1843: FROM PA_EVENT_TYPES E,
1844: pa_rbs_element_names_b a,
1845: Fnd_Languages L

Line 1842: fnd_global.login_id

1838: sysdate,
1839: fnd_global.user_id,
1840: sysdate,
1841: fnd_global.user_id,
1842: fnd_global.login_id
1843: FROM PA_EVENT_TYPES E,
1844: pa_rbs_element_names_b a,
1845: Fnd_Languages L
1846: WHERE a.resource_type_id=4

Line 1881: fnd_global.user_id,

1877: ec.EXPENDITURE_CATEGORY,
1878: l.language_code,
1879: USERENV('LANG'),
1880: sysdate,
1881: fnd_global.user_id,
1882: sysdate,
1883: fnd_global.user_id,
1884: fnd_global.login_id
1885: FROM pa_expenditure_categories ec,

Line 1883: fnd_global.user_id,

1879: USERENV('LANG'),
1880: sysdate,
1881: fnd_global.user_id,
1882: sysdate,
1883: fnd_global.user_id,
1884: fnd_global.login_id
1885: FROM pa_expenditure_categories ec,
1886: pa_rbs_element_names_b a,
1887: Fnd_Languages L

Line 1884: fnd_global.login_id

1880: sysdate,
1881: fnd_global.user_id,
1882: sysdate,
1883: fnd_global.user_id,
1884: fnd_global.login_id
1885: FROM pa_expenditure_categories ec,
1886: pa_rbs_element_names_b a,
1887: Fnd_Languages L
1888: WHERE a.resource_type_id = 5

Line 1922: fnd_global.user_id,

1918: ec.expenditure_type,
1919: l.language_code,
1920: USERENV('LANG'),
1921: sysdate,
1922: fnd_global.user_id,
1923: sysdate,
1924: fnd_global.user_id,
1925: fnd_global.login_id
1926: FROM pa_expenditure_types ec,

Line 1924: fnd_global.user_id,

1920: USERENV('LANG'),
1921: sysdate,
1922: fnd_global.user_id,
1923: sysdate,
1924: fnd_global.user_id,
1925: fnd_global.login_id
1926: FROM pa_expenditure_types ec,
1927: pa_rbs_element_names_b a,
1928: Fnd_Languages L

Line 1925: fnd_global.login_id

1921: sysdate,
1922: fnd_global.user_id,
1923: sysdate,
1924: fnd_global.user_id,
1925: fnd_global.login_id
1926: FROM pa_expenditure_types ec,
1927: pa_rbs_element_names_b a,
1928: Fnd_Languages L
1929: WHERE a.resource_type_id = 6

Line 1964: fnd_global.user_id,

1960: c.structure_id, c.category_id),
1961: l.language_code,
1962: USERENV('LANG'),
1963: sysdate,
1964: fnd_global.user_id,
1965: sysdate,
1966: fnd_global.user_id,
1967: fnd_global.login_id
1968: FROM mtl_categories_v c,

Line 1966: fnd_global.user_id,

1962: USERENV('LANG'),
1963: sysdate,
1964: fnd_global.user_id,
1965: sysdate,
1966: fnd_global.user_id,
1967: fnd_global.login_id
1968: FROM mtl_categories_v c,
1969: Fnd_Languages L,
1970: pa_rbs_element_names_b a

Line 1967: fnd_global.login_id

1963: sysdate,
1964: fnd_global.user_id,
1965: sysdate,
1966: fnd_global.user_id,
1967: fnd_global.login_id
1968: FROM mtl_categories_v c,
1969: Fnd_Languages L,
1970: pa_rbs_element_names_b a
1971: WHERE a.resource_source_id=c.CATEGORY_ID

Line 2003: fnd_global.user_id,

1999: b.segment1, --For bug 3602566
2000: t.language,
2001: t.source_lang,
2002: sysdate,
2003: fnd_global.user_id,
2004: sysdate,
2005: fnd_global.user_id,
2006: fnd_global.login_id
2007: FROM MTL_SYSTEM_ITEMS_tl t,

Line 2005: fnd_global.user_id,

2001: t.source_lang,
2002: sysdate,
2003: fnd_global.user_id,
2004: sysdate,
2005: fnd_global.user_id,
2006: fnd_global.login_id
2007: FROM MTL_SYSTEM_ITEMS_tl t,
2008: MTL_SYSTEM_ITEMS_b b,
2009: pa_plan_res_defaults p,

Line 2006: fnd_global.login_id

2002: sysdate,
2003: fnd_global.user_id,
2004: sysdate,
2005: fnd_global.user_id,
2006: fnd_global.login_id
2007: FROM MTL_SYSTEM_ITEMS_tl t,
2008: MTL_SYSTEM_ITEMS_b b,
2009: pa_plan_res_defaults p,
2010: pa_rbs_element_names_b a

Line 2047: fnd_global.user_id,

2043: job.name,
2044: l.language_code,
2045: USERENV('LANG'),
2046: sysdate,
2047: fnd_global.user_id,
2048: sysdate,
2049: fnd_global.user_id,
2050: fnd_global.login_id
2051: FROM per_jobs job,

Line 2049: fnd_global.user_id,

2045: USERENV('LANG'),
2046: sysdate,
2047: fnd_global.user_id,
2048: sysdate,
2049: fnd_global.user_id,
2050: fnd_global.login_id
2051: FROM per_jobs job,
2052: pa_rbs_element_names_b a,
2053: Fnd_Languages L

Line 2050: fnd_global.login_id

2046: sysdate,
2047: fnd_global.user_id,
2048: sysdate,
2049: fnd_global.user_id,
2050: fnd_global.login_id
2051: FROM per_jobs job,
2052: pa_rbs_element_names_b a,
2053: Fnd_Languages L
2054: WHERE a.resource_type_id=9

Line 2087: fnd_global.user_id,

2083: tl.name,
2084: tl.language,
2085: tl.source_lang,
2086: sysdate,
2087: fnd_global.user_id,
2088: sysdate,
2089: fnd_global.user_id,
2090: fnd_global.login_id
2091: FROM hr_all_organization_units_tl tl,

Line 2089: fnd_global.user_id,

2085: tl.source_lang,
2086: sysdate,
2087: fnd_global.user_id,
2088: sysdate,
2089: fnd_global.user_id,
2090: fnd_global.login_id
2091: FROM hr_all_organization_units_tl tl,
2092: pa_rbs_element_names_b a,
2093: Fnd_Languages L

Line 2090: fnd_global.login_id

2086: sysdate,
2087: fnd_global.user_id,
2088: sysdate,
2089: fnd_global.user_id,
2090: fnd_global.login_id
2091: FROM hr_all_organization_units_tl tl,
2092: pa_rbs_element_names_b a,
2093: Fnd_Languages L
2094: WHERE tl.organization_id = a.resource_source_id

Line 2124: fnd_global.user_id,

2120: lk.meaning,
2121: lk.language,
2122: lk.source_lang,
2123: sysdate,
2124: fnd_global.user_id,
2125: sysdate,
2126: fnd_global.user_id,
2127: fnd_global.login_id
2128: FROM pa_rbs_element_map map,-- For bug 3799582

Line 2126: fnd_global.user_id,

2122: lk.source_lang,
2123: sysdate,
2124: fnd_global.user_id,
2125: sysdate,
2126: fnd_global.user_id,
2127: fnd_global.login_id
2128: FROM pa_rbs_element_map map,-- For bug 3799582
2129: fnd_lookup_values lk,
2130: pa_rbs_element_names_b a

Line 2127: fnd_global.login_id

2123: sysdate,
2124: fnd_global.user_id,
2125: sysdate,
2126: fnd_global.user_id,
2127: fnd_global.login_id
2128: FROM pa_rbs_element_map map,-- For bug 3799582
2129: fnd_lookup_values lk,
2130: pa_rbs_element_names_b a
2131: WHERE map.resource_type_id = a.resource_type_id

Line 2167: fnd_global.user_id,

2163: r.NON_LABOR_RESOURCE,
2164: l.language_code,
2165: USERENV('LANG'),
2166: sysdate,
2167: fnd_global.user_id,
2168: sysdate,
2169: fnd_global.user_id,
2170: fnd_global.login_id
2171: FROM pa_non_labor_resources r,

Line 2169: fnd_global.user_id,

2165: USERENV('LANG'),
2166: sysdate,
2167: fnd_global.user_id,
2168: sysdate,
2169: fnd_global.user_id,
2170: fnd_global.login_id
2171: FROM pa_non_labor_resources r,
2172: pa_rbs_element_names_b a,
2173: Fnd_Languages L

Line 2170: fnd_global.login_id

2166: sysdate,
2167: fnd_global.user_id,
2168: sysdate,
2169: fnd_global.user_id,
2170: fnd_global.login_id
2171: FROM pa_non_labor_resources r,
2172: pa_rbs_element_names_b a,
2173: Fnd_Languages L
2174: WHERE a.resource_source_id =

Line 2207: fnd_global.user_id,

2203: tl.name,
2204: tl.language,
2205: tl.source_lang,
2206: sysdate,
2207: fnd_global.user_id,
2208: sysdate,
2209: fnd_global.user_id,
2210: fnd_global.login_id
2211: FROM pa_resource_classes_tl tl,

Line 2209: fnd_global.user_id,

2205: tl.source_lang,
2206: sysdate,
2207: fnd_global.user_id,
2208: sysdate,
2209: fnd_global.user_id,
2210: fnd_global.login_id
2211: FROM pa_resource_classes_tl tl,
2212: pa_rbs_element_names_b a
2213: WHERE a.resource_source_id=tl.resource_class_id

Line 2210: fnd_global.login_id

2206: sysdate,
2207: fnd_global.user_id,
2208: sysdate,
2209: fnd_global.user_id,
2210: fnd_global.login_id
2211: FROM pa_resource_classes_tl tl,
2212: pa_rbs_element_names_b a
2213: WHERE a.resource_source_id=tl.resource_class_id
2214: AND a.resource_type_id=13);

Line 2244: fnd_global.user_id,

2240: lk.meaning,
2241: lk.language,
2242: lk.source_lang,
2243: sysdate,
2244: fnd_global.user_id,
2245: sysdate,
2246: fnd_global.user_id,
2247: fnd_global.login_id
2248: FROM fnd_lookup_values lk,

Line 2246: fnd_global.user_id,

2242: lk.source_lang,
2243: sysdate,
2244: fnd_global.user_id,
2245: sysdate,
2246: fnd_global.user_id,
2247: fnd_global.login_id
2248: FROM fnd_lookup_values lk,
2249: pa_rbs_element_names_b a,
2250: pa_rbs_element_map map

Line 2247: fnd_global.login_id

2243: sysdate,
2244: fnd_global.user_id,
2245: sysdate,
2246: fnd_global.user_id,
2247: fnd_global.login_id
2248: FROM fnd_lookup_values lk,
2249: pa_rbs_element_names_b a,
2250: pa_rbs_element_map map
2251: WHERE a.resource_source_id=map.resource_id

Line 2284: fnd_global.user_id,

2280: tl.meaning,
2281: tl.language,
2282: tl.source_lang,
2283: sysdate,
2284: fnd_global.user_id,
2285: sysdate,
2286: fnd_global.user_id,
2287: fnd_global.login_id
2288: FROM pa_project_role_types_tl tl,

Line 2286: fnd_global.user_id,

2282: tl.source_lang,
2283: sysdate,
2284: fnd_global.user_id,
2285: sysdate,
2286: fnd_global.user_id,
2287: fnd_global.login_id
2288: FROM pa_project_role_types_tl tl,
2289: pa_rbs_element_names_b a
2290: WHERE a.resource_type_id = 15

Line 2287: fnd_global.login_id

2283: sysdate,
2284: fnd_global.user_id,
2285: sysdate,
2286: fnd_global.user_id,
2287: fnd_global.login_id
2288: FROM pa_project_role_types_tl tl,
2289: pa_rbs_element_names_b a
2290: WHERE a.resource_type_id = 15
2291: AND a.resource_source_id = tl.project_role_id);

Line 2322: fnd_global.user_id,

2318: v.vendor_name,
2319: l.language_code,
2320: USERENV('LANG'),
2321: sysdate,
2322: fnd_global.user_id,
2323: sysdate,
2324: fnd_global.user_id,
2325: fnd_global.login_id
2326: FROM po_vendors v,

Line 2324: fnd_global.user_id,

2320: USERENV('LANG'),
2321: sysdate,
2322: fnd_global.user_id,
2323: sysdate,
2324: fnd_global.user_id,
2325: fnd_global.login_id
2326: FROM po_vendors v,
2327: pa_rbs_element_names_b a,
2328: Fnd_Languages L

Line 2325: fnd_global.login_id

2321: sysdate,
2322: fnd_global.user_id,
2323: sysdate,
2324: fnd_global.user_id,
2325: fnd_global.login_id
2326: FROM po_vendors v,
2327: pa_rbs_element_names_b a,
2328: Fnd_Languages L
2329: WHERE a.resource_type_id = 16

Line 2363: fnd_global.user_id,

2359: map.resource_name,
2360: l.language_code,
2361: USERENV('LANG'),
2362: sysdate,
2363: fnd_global.user_id,
2364: sysdate,
2365: fnd_global.user_id,
2366: fnd_global.login_id
2367: FROM pa_rbs_element_map map,

Line 2365: fnd_global.user_id,

2361: USERENV('LANG'),
2362: sysdate,
2363: fnd_global.user_id,
2364: sysdate,
2365: fnd_global.user_id,
2366: fnd_global.login_id
2367: FROM pa_rbs_element_map map,
2368: pa_rbs_element_names_b a,
2369: Fnd_Languages L

Line 2366: fnd_global.login_id

2362: sysdate,
2363: fnd_global.user_id,
2364: sysdate,
2365: fnd_global.user_id,
2366: fnd_global.login_id
2367: FROM pa_rbs_element_map map,
2368: pa_rbs_element_names_b a,
2369: Fnd_Languages L
2370: WHERE a.resource_type_id = 18

Line 2388: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));

2384: END IF;
2385: Commit;
2386:
2387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Refresh_Resource_Names completed successfully.');
2388: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
2389:
2390: EXCEPTION
2391:
2392: WHEN OTHERS THEN

Line 2395: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));

2391:
2392: WHEN OTHERS THEN
2393: Rollback;
2394: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Unexpected error: '||SQLCODE||' '||SQLERRM);
2395: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
2396:
2397: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error: '||SQLCODE||' '||SQLERRM);
2398: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
2399:

Line 2398: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));

2394: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Unexpected error: '||SQLCODE||' '||SQLERRM);
2395: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
2396:
2397: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error: '||SQLCODE||' '||SQLERRM);
2398: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
2399:
2400: retcode := SQLCODE;
2401: errbuf := SQLERRM;
2402: RAISE;

Line 2679: fnd_global.user_id,

2675: l_list.start_date_active,
2676: l_list.end_date_active,
2677: l_list.business_group_id,
2678: sysdate,
2679: fnd_global.user_id,
2680: sysdate,
2681: fnd_global.user_id,
2682: fnd_global.login_id,
2683: 1,

Line 2681: fnd_global.user_id,

2677: l_list.business_group_id,
2678: sysdate,
2679: fnd_global.user_id,
2680: sysdate,
2681: fnd_global.user_id,
2682: fnd_global.login_id,
2683: 1,
2684: 'Y');
2685:

Line 2682: fnd_global.login_id,

2678: sysdate,
2679: fnd_global.user_id,
2680: sysdate,
2681: fnd_global.user_id,
2682: fnd_global.login_id,
2683: 1,
2684: 'Y');
2685:
2686: --dbms_output.put_line('Created RBS Header : ' || l_rbs_header_id);

Line 2740: fnd_global.user_id,

2736: l_names.description,
2737: l_names.language,
2738: l_names.source_lang,
2739: sysdate,
2740: fnd_global.user_id,
2741: sysdate,
2742: fnd_global.user_id,
2743: fnd_global.login_id);
2744: END LOOP; -- End RBS H TL names Loop

Line 2742: fnd_global.user_id,

2738: l_names.source_lang,
2739: sysdate,
2740: fnd_global.user_id,
2741: sysdate,
2742: fnd_global.user_id,
2743: fnd_global.login_id);
2744: END LOOP; -- End RBS H TL names Loop
2745: -- Done with RBS Headers
2746: --dbms_output.put_line('Done RBS Header');

Line 2743: fnd_global.login_id);

2739: sysdate,
2740: fnd_global.user_id,
2741: sysdate,
2742: fnd_global.user_id,
2743: fnd_global.login_id);
2744: END LOOP; -- End RBS H TL names Loop
2745: -- Done with RBS Headers
2746: --dbms_output.put_line('Done RBS Header');
2747:

Line 2787: fnd_global.user_id,

2783: 'N',
2784: 'Y',
2785: 'FROZEN',
2786: sysdate,
2787: fnd_global.user_id,
2788: sysdate,
2789: fnd_global.user_id,
2790: fnd_global.login_id,
2791: 1,

Line 2789: fnd_global.user_id,

2785: 'FROZEN',
2786: sysdate,
2787: fnd_global.user_id,
2788: sysdate,
2789: fnd_global.user_id,
2790: fnd_global.login_id,
2791: 1,
2792: 'Y');
2793:

Line 2790: fnd_global.login_id,

2786: sysdate,
2787: fnd_global.user_id,
2788: sysdate,
2789: fnd_global.user_id,
2790: fnd_global.login_id,
2791: 1,
2792: 'Y');
2793:
2794: --dbms_output.put_line('Created RBS Version : ' || l_rbs_version_id);

Line 2817: fnd_global.user_id,

2813: l_names.description,
2814: l_names.language,
2815: l_names.source_lang,
2816: sysdate,
2817: fnd_global.user_id,
2818: sysdate,
2819: fnd_global.user_id,
2820: fnd_global.login_id);
2821: END LOOP; -- End RBS V TL names Loop Version

Line 2819: fnd_global.user_id,

2815: l_names.source_lang,
2816: sysdate,
2817: fnd_global.user_id,
2818: sysdate,
2819: fnd_global.user_id,
2820: fnd_global.login_id);
2821: END LOOP; -- End RBS V TL names Loop Version
2822:
2823: -- Stamp frozen version ID on pa_resource_lists_all_bg

Line 2820: fnd_global.login_id);

2816: sysdate,
2817: fnd_global.user_id,
2818: sysdate,
2819: fnd_global.user_id,
2820: fnd_global.login_id);
2821: END LOOP; -- End RBS V TL names Loop Version
2822:
2823: -- Stamp frozen version ID on pa_resource_lists_all_bg
2824:

Line 3036: fnd_global.user_id,

3032: 1,
3033: l_rbs_identifier_id,
3034: 'N',
3035: sysdate,
3036: fnd_global.user_id,
3037: sysdate,
3038: fnd_global.user_id,
3039: fnd_global.login_id,
3040: 1);

Line 3038: fnd_global.user_id,

3034: 'N',
3035: sysdate,
3036: fnd_global.user_id,
3037: sysdate,
3038: fnd_global.user_id,
3039: fnd_global.login_id,
3040: 1);
3041:
3042: -- First create the parent elements if the list

Line 3039: fnd_global.login_id,

3035: sysdate,
3036: fnd_global.user_id,
3037: sysdate,
3038: fnd_global.user_id,
3039: fnd_global.login_id,
3040: 1);
3041:
3042: -- First create the parent elements if the list
3043: -- is grouped.

Line 3153: fnd_global.user_id,

3149: 2,
3150: l_rbs_identifier_id,
3151: 'N',
3152: sysdate,
3153: fnd_global.user_id,
3154: sysdate,
3155: fnd_global.user_id,
3156: fnd_global.login_id,
3157: 1);

Line 3155: fnd_global.user_id,

3151: 'N',
3152: sysdate,
3153: fnd_global.user_id,
3154: sysdate,
3155: fnd_global.user_id,
3156: fnd_global.login_id,
3157: 1);
3158: -- Stamp rbs element ID on pa_resource_list_members for
3159: -- parent

Line 3156: fnd_global.login_id,

3152: sysdate,
3153: fnd_global.user_id,
3154: sysdate,
3155: fnd_global.user_id,
3156: fnd_global.login_id,
3157: 1);
3158: -- Stamp rbs element ID on pa_resource_list_members for
3159: -- parent
3160:

Line 3364: fnd_global.user_id,

3360: l_rbs_level,
3361: l_rbs_identifier_id,
3362: 'N',
3363: sysdate,
3364: fnd_global.user_id,
3365: sysdate,
3366: fnd_global.user_id,
3367: fnd_global.login_id,
3368: 1);

Line 3366: fnd_global.user_id,

3362: 'N',
3363: sysdate,
3364: fnd_global.user_id,
3365: sysdate,
3366: fnd_global.user_id,
3367: fnd_global.login_id,
3368: 1);
3369:
3370: -- Stamp rbs element ID on pa_resource_list_members for

Line 3367: fnd_global.login_id,

3363: sysdate,
3364: fnd_global.user_id,
3365: sysdate,
3366: fnd_global.user_id,
3367: fnd_global.login_id,
3368: 1);
3369:
3370: -- Stamp rbs element ID on pa_resource_list_members for
3371: -- parent

Line 3563: fnd_global.user_id,

3559: 'N',
3560: decode(rpa.primary_reporting_rbs_flag, 'Y', 'N', pru.default_flag),
3561: 'ACTIVE',
3562: sysdate,
3563: fnd_global.user_id,
3564: sysdate,
3565: fnd_global.user_id,
3566: fnd_global.login_id,
3567: 1

Line 3565: fnd_global.user_id,

3561: 'ACTIVE',
3562: sysdate,
3563: fnd_global.user_id,
3564: sysdate,
3565: fnd_global.user_id,
3566: fnd_global.login_id,
3567: 1
3568: FROM pa_resource_list_assignments asg,
3569: pa_resource_list_uses pru,

Line 3566: fnd_global.login_id,

3562: sysdate,
3563: fnd_global.user_id,
3564: sysdate,
3565: fnd_global.user_id,
3566: fnd_global.login_id,
3567: 1
3568: FROM pa_resource_list_assignments asg,
3569: pa_resource_list_uses pru,
3570: pa_rbs_prj_assignments rpa

Line 3633: fnd_global.user_id,

3629: 'N',
3630: 'Y',
3631: 'WORKING',
3632: sysdate,
3633: fnd_global.user_id,
3634: sysdate,
3635: fnd_global.user_id,
3636: fnd_global.login_id,
3637: 1,

Line 3635: fnd_global.user_id,

3631: 'WORKING',
3632: sysdate,
3633: fnd_global.user_id,
3634: sysdate,
3635: fnd_global.user_id,
3636: fnd_global.login_id,
3637: 1,
3638: 'N');
3639:

Line 3636: fnd_global.login_id,

3632: sysdate,
3633: fnd_global.user_id,
3634: sysdate,
3635: fnd_global.user_id,
3636: fnd_global.login_id,
3637: 1,
3638: 'N');
3639:
3640: --dbms_output.put_line('Created RBS Version : ' || l_rbs_version_id);

Line 3663: fnd_global.user_id,

3659: l_names.description,
3660: l_names.language,
3661: l_names.source_lang,
3662: sysdate,
3663: fnd_global.user_id,
3664: sysdate,
3665: fnd_global.user_id,
3666: fnd_global.login_id);
3667: END LOOP; -- End RBS V TL names Loop Version

Line 3665: fnd_global.user_id,

3661: l_names.source_lang,
3662: sysdate,
3663: fnd_global.user_id,
3664: sysdate,
3665: fnd_global.user_id,
3666: fnd_global.login_id);
3667: END LOOP; -- End RBS V TL names Loop Version
3668:
3669: --dbms_output.put_line('Created RBS Working : ' || l_rbs_version_id);

Line 3666: fnd_global.login_id);

3662: sysdate,
3663: fnd_global.user_id,
3664: sysdate,
3665: fnd_global.user_id,
3666: fnd_global.login_id);
3667: END LOOP; -- End RBS V TL names Loop Version
3668:
3669: --dbms_output.put_line('Created RBS Working : ' || l_rbs_version_id);
3670: