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
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'
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
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
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,
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
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
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,
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
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
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,
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,
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
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,
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,
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
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,
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,
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
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,
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,
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
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,
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,
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
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,
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
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
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,
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,
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
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,
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,
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
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,
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,
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
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,
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,
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
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,
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,
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
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,
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,
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
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,
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
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
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,
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
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
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,
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,
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
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,
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,
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')||': '||
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,
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
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
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,
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
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);
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,
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
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
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,
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
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
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,
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
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
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,
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
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
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,
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
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
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,
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
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
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,
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
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
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,
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,
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
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,
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
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
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,
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
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
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
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
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
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,
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
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 =
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,
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
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);
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,
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
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
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,
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
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);
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,
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
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
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,
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
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
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
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:
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;
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,
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:
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);
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
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');
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:
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,
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:
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);
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
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
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:
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);
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
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.
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);
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
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:
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);
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
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
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
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,
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
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,
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:
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);
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
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);
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: