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 PA_RBS_ELEMENT_NAMES_TL

Line 472: * pa_rbs_element_names_tl table.

468:
469: /******************************************************
470: * Procedure : Insert_non_tl_names
471: * Description : This API is used to insert into the
472: * pa_rbs_element_names_tl table.
473: * For those res_type_codes for which there
474: * is no Multi lang support.
475: * We are going to insert the value based
476: * on the values inserted into the

Line 488: INSERT INTO Pa_rbs_element_names_tl

484: l_count Number;
485: l_temp_count Number;
486: BEGIN
487: IF p_resource_type_code = 'VERSION' THEN--VERSION
488: INSERT INTO Pa_rbs_element_names_tl
489: (RBS_ELEMENT_NAME_ID,
490: RESOURCE_NAME,
491: Language,
492: Source_Lang,

Line 517: FROM pa_rbs_element_names_tl tl

513: AND a.resource_type_id = p_resource_type_id
514: AND b.resource_type_id = p_resource_type_id
515: AND c.rbs_version_id = a.resource_source_id
516: AND NOT EXISTS (select 'Y'
517: FROM pa_rbs_element_names_tl tl
518: where tl.rbs_element_name_id = a.rbs_element_name_id
519: and tl.language = c.language);
520: END IF;--VERSION
521:

Line 523: INSERT INTO Pa_rbs_element_names_tl

519: and tl.language = c.language);
520: END IF;--VERSION
521:
522: IF p_resource_type_code = 'RULE' THEN--RULE
523: INSERT INTO Pa_rbs_element_names_tl
524: (RBS_ELEMENT_NAME_ID,
525: RESOURCE_NAME,
526: Language,
527: Source_Lang,

Line 554: FROM pa_rbs_element_names_tl tl

550: AND c.lookup_type = 'RBS_RULE_RESOURCE'
551: AND c.lookup_code = 'USER_DEFINED_RESOURCE'
552: AND c.view_application_id = 275
553: AND NOT EXISTS (select 'Y'
554: FROM pa_rbs_element_names_tl tl
555: where tl.rbs_element_name_id = a.rbs_element_name_id
556: and tl.language = c.language);
557: END IF;--RULE
558:

Line 561: INSERT INTO Pa_rbs_element_names_tl

557: END IF;--RULE
558:
559: --MLS Changes.
560: IF p_resource_type_code = 'NAMED_PERSON' THEN--NAMED_PERSON
561: INSERT INTO Pa_rbs_element_names_tl
562: (RBS_ELEMENT_NAME_ID,
563: RESOURCE_NAME,
564: Language,
565: Source_Lang,

Line 594: FROM pa_rbs_element_names_tl tl

590: and sysdate between c.effective_start_date
591: and c.effective_end_date
592: and l.Installed_Flag in ('I', 'B')
593: AND NOT EXISTS (select 'Y'
594: FROM pa_rbs_element_names_tl tl
595: where tl.rbs_element_name_id = a.rbs_element_name_id
596: and tl.language = l.language_code);
597: END IF;--NAMED_PERSON
598:

Line 601: INSERT INTO Pa_rbs_element_names_tl

597: END IF;--NAMED_PERSON
598:
599: --MLS Changes.
600: IF p_resource_type_code = 'JOB' THEN--JOB
601: INSERT INTO Pa_rbs_element_names_tl
602: (RBS_ELEMENT_NAME_ID,
603: RESOURCE_NAME,
604: Language,
605: Source_Lang,

Line 632: FROM pa_rbs_element_names_tl tl

628: AND b.resource_type_id = p_resource_type_id
629: AND c.Job_Id = a.resource_source_id
630: and l.Installed_Flag in ('I', 'B')
631: AND NOT EXISTS (select 'Y'
632: FROM pa_rbs_element_names_tl tl
633: where tl.rbs_element_name_id = a.rbs_element_name_id
634: and tl.language = l.language_code);
635: END IF;--JOB
636:

Line 638: INSERT INTO Pa_rbs_element_names_tl

634: and tl.language = l.language_code);
635: END IF;--JOB
636:
637: IF p_resource_type_code = 'PERSON_TYPE' THEN --PERSON_TYPE
638: INSERT INTO Pa_rbs_element_names_tl
639: (RBS_ELEMENT_NAME_ID,
640: RESOURCE_NAME,
641: Language,
642: Source_Lang,

Line 672: FROM pa_rbs_element_names_tl tl

668: and c.resource_id = a.resource_source_id
669: and c.resource_type_id = p_resource_type_id
670: and lk.lookup_code = c.resource_name
671: and NOT EXISTS (select 'Y'
672: FROM pa_rbs_element_names_tl tl
673: where tl.rbs_element_name_id = a.rbs_element_name_id
674: and tl.language = lk.language);
675: END IF;--PERSON_TYPE
676:

Line 680: INSERT INTO Pa_rbs_element_names_tl

676:
677: --MLS Changes.
678: IF p_resource_type_code IN ('BOM_LABOR','BOM_EQUIPMENT') THEN
679: --BOM_LABOR,BOM_EQUIPMENT
680: INSERT INTO Pa_rbs_element_names_tl
681: (RBS_ELEMENT_NAME_ID,
682: RESOURCE_NAME,
683: Language,
684: Source_Lang,

Line 713: FROM pa_rbs_element_names_tl tl

709: AND a.resource_type_id = p_resource_type_id
710: AND b.resource_type_id = p_resource_type_id
711: and L.Installed_Flag in ('I', 'B')
712: AND NOT EXISTS (select 'Y'
713: FROM pa_rbs_element_names_tl tl
714: where tl.rbs_element_name_id = a.rbs_element_name_id
715: and tl.language = l.language_code);
716: END IF;--BOM_LABOR,BOM_EQUIPMENT
717:

Line 721: INSERT INTO Pa_rbs_element_names_tl

717:
718: --MLS Changes.
719: IF p_resource_type_code = 'NON_LABOR_RESOURCE' THEN
720: --NON_LABOR_RESOURCE
721: INSERT INTO Pa_rbs_element_names_tl
722: (RBS_ELEMENT_NAME_ID,
723: RESOURCE_NAME,
724: Language,
725: Source_Lang,

Line 752: FROM pa_rbs_element_names_tl tl

748: AND b.resource_type_id = p_resource_type_id
749: and c.non_labor_resource_id = a.resource_source_id
750: and L.Installed_Flag in ('I', 'B')
751: AND NOT EXISTS (select 'Y'
752: FROM pa_rbs_element_names_tl tl
753: where tl.rbs_element_name_id = a.rbs_element_name_id
754: and tl.language = l.language_code);
755: END IF;--NON_LABOR_RESOURCE
756:

Line 759: INSERT INTO Pa_rbs_element_names_tl

755: END IF;--NON_LABOR_RESOURCE
756:
757: IF p_resource_type_code = 'RESOURCE_CLASS' THEN
758: --RESOURCE_CLASS
759: INSERT INTO Pa_rbs_element_names_tl
760: (RBS_ELEMENT_NAME_ID,
761: RESOURCE_NAME,
762: Language,
763: Source_Lang,

Line 788: FROM pa_rbs_element_names_tl tl

784: AND a.resource_type_id = p_resource_type_id
785: AND b.resource_type_id = p_resource_type_id
786: and c.resource_class_id = a.resource_source_id
787: and NOT EXISTS (select 'Y'
788: FROM pa_rbs_element_names_tl tl
789: where tl.rbs_element_name_id = a.rbs_element_name_id
790: and tl.language = c.language);
791: END IF;--RESOURCE_CLASS
792:

Line 797: INSERT INTO Pa_rbs_element_names_tl

793: --MLS Changes.
794: IF p_resource_type_code IN ('NAMED_ROLE','USER_DEFINED')
795: THEN
796: --NAMED_ROLE, USER_DEFINED
797: INSERT INTO Pa_rbs_element_names_tl
798: (RBS_ELEMENT_NAME_ID,
799: RESOURCE_NAME,
800: Language,
801: Source_Lang,

Line 829: FROM pa_rbs_element_names_tl tl

825: and c.resource_id = a.resource_source_id
826: and c.resource_type_id = p_resource_type_id
827: and L.Installed_Flag in ('I', 'B')
828: AND NOT EXISTS (select 'Y'
829: FROM pa_rbs_element_names_tl tl
830: where tl.rbs_element_name_id = a.rbs_element_name_id
831: and tl.language = l.language_code);
832: END IF;--NAMED_ROLE, USER_DEFINED
833:

Line 837: INSERT INTO Pa_rbs_element_names_tl

833:
834: IF p_resource_type_code IN ('REVENUE_CATEGORY')
835: THEN
836: --REVENUE_CATEGORY
837: INSERT INTO Pa_rbs_element_names_tl
838: (RBS_ELEMENT_NAME_ID,
839: RESOURCE_NAME,
840: Language,
841: Source_Lang,

Line 870: FROM pa_rbs_element_names_tl tl

866: and c.resource_type_id = p_resource_type_id
867: and lk.lookup_type = 'REVENUE CATEGORY'
868: and lk.lookup_code = c.resource_name
869: AND NOT EXISTS (select 'Y'
870: FROM pa_rbs_element_names_tl tl
871: where tl.rbs_element_name_id = a.rbs_element_name_id
872: and tl.language = lk.language);
873: END IF;--REVENUE_CATEGORY
874:

Line 878: INSERT INTO Pa_rbs_element_names_tl

874:
875: --MLS Changes.
876: IF p_resource_type_code = 'EVENT_TYPE' THEN
877: --EVENT_TYPE
878: INSERT INTO Pa_rbs_element_names_tl
879: (RBS_ELEMENT_NAME_ID,
880: RESOURCE_NAME,
881: Language,
882: Source_Lang,

Line 909: FROM pa_rbs_element_names_tl tl

905: AND a.resource_type_id = p_resource_type_id
906: AND b.resource_type_id = p_resource_type_id
907: and L.Installed_Flag in ('I', 'B')
908: AND NOT EXISTS (select 'Y'
909: FROM pa_rbs_element_names_tl tl
910: where tl.rbs_element_name_id = a.rbs_element_name_id
911: and tl.language = l.language_code);
912: END IF;--EVENT_TYPE
913:

Line 917: INSERT INTO Pa_rbs_element_names_tl

913:
914: --MLS Changes.
915: IF p_resource_type_code = 'EXPENDITURE_TYPE' THEN
916: --EXPENDITURE_TYPE
917: INSERT INTO Pa_rbs_element_names_tl
918: (RBS_ELEMENT_NAME_ID,
919: RESOURCE_NAME,
920: Language,
921: Source_Lang,

Line 948: FROM pa_rbs_element_names_tl tl

944: AND a.resource_type_id = p_resource_type_id
945: AND b.resource_type_id = p_resource_type_id
946: and L.Installed_Flag in ('I', 'B')
947: AND NOT EXISTS (select 'Y'
948: FROM pa_rbs_element_names_tl tl
949: where tl.rbs_element_name_id = a.rbs_element_name_id
950: and tl.language = l.language_code);
951: END IF;--EXPENDITURE_TYPE
952:

Line 956: INSERT INTO Pa_rbs_element_names_tl

952:
953: --MLS Changes.
954: IF p_resource_type_code = 'EXPENDITURE_CATEGORY' THEN
955: --EXPENDITURE_CATEGORY
956: INSERT INTO Pa_rbs_element_names_tl
957: (RBS_ELEMENT_NAME_ID,
958: RESOURCE_NAME,
959: Language,
960: Source_Lang,

Line 987: FROM pa_rbs_element_names_tl tl

983: AND a.resource_type_id = p_resource_type_id
984: AND b.resource_type_id = p_resource_type_id
985: and L.Installed_Flag in ('I', 'B')
986: AND NOT EXISTS (select 'Y'
987: FROM pa_rbs_element_names_tl tl
988: where tl.rbs_element_name_id = a.rbs_element_name_id
989: and tl.language = l.language_code);
990: END IF;--EXPENDITURE_CATEGORY
991:

Line 995: INSERT INTO Pa_rbs_element_names_tl

991:
992: --MLS Changes.
993: IF p_resource_type_code = 'SUPPLIER' THEN
994: --SUPPLIER
995: INSERT INTO Pa_rbs_element_names_tl
996: (RBS_ELEMENT_NAME_ID,
997: RESOURCE_NAME,
998: Language,
999: Source_Lang,

Line 1026: FROM pa_rbs_element_names_tl tl

1022: AND a.resource_type_id = p_resource_type_id
1023: AND b.resource_type_id = p_resource_type_id
1024: and L.Installed_Flag in ('I', 'B')
1025: AND NOT EXISTS (select 'Y'
1026: FROM pa_rbs_element_names_tl tl
1027: where tl.rbs_element_name_id = a.rbs_element_name_id
1028: and tl.language = l.language_code);
1029: END IF;--SUPPLIER
1030:

Line 1040: * pa_rbs_element_names_tl table.

1036:
1037: /******************************************************
1038: * Procedure : Insert_tl_names
1039: * Description : This API is used to insert into the
1040: * pa_rbs_element_names_tl table.
1041: * For those res_type_codes for which there
1042: * are corr TL tables
1043: * We are going to insert the value based
1044: * on the values inserted into the

Line 1058: INSERT INTO Pa_rbs_element_names_tl

1054: BEGIN
1055:
1056: IF p_resource_type_code = 'ORGANIZATION' THEN
1057: --ORGANIZATION
1058: INSERT INTO Pa_rbs_element_names_tl
1059: (RBS_ELEMENT_NAME_ID,
1060: RESOURCE_NAME,
1061: Language,
1062: Source_Lang,

Line 1087: from pa_rbs_element_names_tl tl

1083: and c.organization_id = a.resource_source_id
1084: AND a.resource_type_id = p_resource_type_id
1085: AND b.resource_type_id = p_resource_type_id
1086: AND NOT EXISTS (select 'Y'
1087: from pa_rbs_element_names_tl tl
1088: where tl.rbs_element_name_id = a.rbs_element_name_id
1089: and tl.language = c.language);
1090: END IF;--ORGANIZATION
1091:

Line 1094: INSERT INTO Pa_rbs_element_names_tl

1090: END IF;--ORGANIZATION
1091:
1092: IF p_resource_type_code = 'ROLE' THEN
1093: --ROLE
1094: INSERT INTO Pa_rbs_element_names_tl
1095: (RBS_ELEMENT_NAME_ID,
1096: RESOURCE_NAME,
1097: Language,
1098: Source_Lang,

Line 1123: from pa_rbs_element_names_tl tl

1119: and c.project_role_id = a.resource_source_id
1120: AND a.resource_type_id = p_resource_type_id
1121: AND b.resource_type_id = p_resource_type_id
1122: AND NOT EXISTS (select 'Y'
1123: from pa_rbs_element_names_tl tl
1124: where tl.rbs_element_name_id = a.rbs_element_name_id
1125: and tl.language = c.language);
1126: END IF;--ROLE
1127:

Line 1130: INSERT INTO Pa_rbs_element_names_tl

1126: END IF;--ROLE
1127:
1128: IF p_resource_type_code = 'ITEM_CATEGORY' THEN
1129: --ITEM_CATEGORY
1130: INSERT INTO Pa_rbs_element_names_tl
1131: (RBS_ELEMENT_NAME_ID,
1132: RESOURCE_NAME,
1133: Language,
1134: Source_Lang,

Line 1162: FROM pa_rbs_element_names_tl tl

1158: AND a.resource_type_id = p_resource_type_id
1159: AND b.resource_type_id = p_resource_type_id
1160: and L.Installed_Flag in ('I', 'B')
1161: AND NOT EXISTS (select 'Y'
1162: FROM pa_rbs_element_names_tl tl
1163: where tl.rbs_element_name_id = a.rbs_element_name_id
1164: and tl.language = l.language_code);
1165:
1166: END IF;--ITEM_CATEGORY

Line 1170: INSERT INTO Pa_rbs_element_names_tl

1166: END IF;--ITEM_CATEGORY
1167:
1168: IF p_resource_type_code = 'INVENTORY_ITEM' THEN
1169: --INVENTORY_ITEM
1170: INSERT INTO Pa_rbs_element_names_tl
1171: (RBS_ELEMENT_NAME_ID,
1172: RESOURCE_NAME,
1173: Language,
1174: Source_Lang,

Line 1210: from pa_rbs_element_names_tl tl

1206: pa_plan_res_defaults def
1207: where def.resource_class_id = cls.resource_class_id and cls.resource_class_code = 'MATERIAL_ITEMS'
1208: and def.object_type = 'CLASS')
1209: AND NOT EXISTS (select 'Y'
1210: from pa_rbs_element_names_tl tl
1211: where tl.rbs_element_name_id = a.rbs_element_name_id
1212: and tl.language = c.language);
1213: END IF;--INVENTORY_ITEM
1214:

Line 1230: * and pa_rbs_element_names_tl tables.

1226: * -> In the first case we will take in a
1227: * resource_source_id and resource_type_id
1228: * and derive the element_name associated.
1229: * And then insert into the pa_rbs_element_names_b
1230: * and pa_rbs_element_names_tl tables.
1231: * Pass back the element_name_id.
1232: * -> In the 2nd case
1233: * Reads the records from the temp table.
1234: * For each of them derives the element_name

Line 1237: * Inserts into the pa_rbs_element_names_tl

1233: * Reads the records from the temp table.
1234: * For each of them derives the element_name
1235: * Inserts into the pa_rbs_element_names_b
1236: * table.
1237: * Inserts into the pa_rbs_element_names_tl
1238: * table.
1239: * Delete the recs in the temp table.
1240: ********************************************************/
1241: PROCEDURE Populate_RBS_Element_Name

Line 1593: --Delete all rows from pa_rbs_element_names_tl table

1589: 'deleting all rows from Tl table');
1590: END IF;
1591:
1592:
1593: --Delete all rows from pa_rbs_element_names_tl table
1594:
1595: DELETE FROM pa_rbs_element_names_tl;
1596:
1597:

Line 1595: DELETE FROM pa_rbs_element_names_tl;

1591:
1592:
1593: --Delete all rows from pa_rbs_element_names_tl table
1594:
1595: DELETE FROM pa_rbs_element_names_tl;
1596:
1597:
1598: --Refreshing Rule based Rbs
1599: IF PG_DEBUG = 'Y' THEN

Line 1606: INSERT INTO pa_rbs_element_names_tl(

1602: END IF;
1603:
1604: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
1605: to remove the GSCC Warning File.Sql.33 */
1606: INSERT INTO pa_rbs_element_names_tl(
1607: RBS_ELEMENT_NAME_ID,
1608: RESOURCE_NAME,
1609: LANGUAGE,
1610: SOURCE_LANG,

Line 1645: INSERT INTO pa_rbs_element_names_tl(

1641: END IF;
1642:
1643: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
1644: to remove the GSCC Warning File.Sql.33 */
1645: INSERT INTO pa_rbs_element_names_tl(
1646: RBS_ELEMENT_NAME_ID,
1647: RESOURCE_NAME,
1648: LANGUAGE,
1649: SOURCE_LANG,

Line 1677: --into pa_rbs_element_names_tl table.

1673: OPEN Res_Types_c;
1674:
1675: --Loop through all resource types reproducing all resources
1676: --associated with all RBS
1677: --into pa_rbs_element_names_tl table.
1678:
1679: LOOP
1680: FETCH Res_Types_c INTO l_res_type_id;
1681:

Line 1694: INSERT INTO pa_rbs_element_names_tl(

1690: END IF;
1691: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
1692: to remove the GSCC Warning File.Sql.33 */
1693: --MLS Changes
1694: INSERT INTO pa_rbs_element_names_tl(
1695: RBS_ELEMENT_NAME_ID,
1696: RESOURCE_NAME,
1697: LANGUAGE,
1698: SOURCE_LANG,

Line 1735: INSERT INTO pa_rbs_element_names_tl(

1731: END IF;
1732: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
1733: to remove the GSCC Warning File.Sql.33 */
1734: --MLS Changes
1735: INSERT INTO pa_rbs_element_names_tl(
1736: RBS_ELEMENT_NAME_ID,
1737: RESOURCE_NAME,
1738: LANGUAGE,
1739: SOURCE_LANG,

Line 1777: INSERT INTO pa_rbs_element_names_tl(

1773: END IF;
1774: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
1775: to remove the GSCC Warning File.Sql.33 */
1776: --MLS Changes
1777: INSERT INTO pa_rbs_element_names_tl(
1778: RBS_ELEMENT_NAME_ID,
1779: RESOURCE_NAME,
1780: LANGUAGE,
1781: SOURCE_LANG,

Line 1821: INSERT INTO pa_rbs_element_names_tl(

1817: END IF;
1818: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
1819: to remove the GSCC Warning File.Sql.33 */
1820: --MLS Changes
1821: INSERT INTO pa_rbs_element_names_tl(
1822: RBS_ELEMENT_NAME_ID,
1823: RESOURCE_NAME,
1824: LANGUAGE,
1825: SOURCE_LANG,

Line 1863: INSERT INTO pa_rbs_element_names_tl(

1859: END IF;
1860: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
1861: to remove the GSCC Warning File.Sql.33 */
1862: --MLS Changes
1863: INSERT INTO pa_rbs_element_names_tl(
1864: RBS_ELEMENT_NAME_ID,
1865: RESOURCE_NAME,
1866: LANGUAGE,
1867: SOURCE_LANG,

Line 1904: INSERT INTO pa_rbs_element_names_tl(

1900:
1901: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
1902: to remove the GSCC Warning File.Sql.33 */
1903: --MLS Changes
1904: INSERT INTO pa_rbs_element_names_tl(
1905: RBS_ELEMENT_NAME_ID,
1906: RESOURCE_NAME,
1907: LANGUAGE,
1908: SOURCE_LANG,

Line 1945: INSERT INTO pa_rbs_element_names_tl(

1941: END IF;
1942:
1943: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
1944: to remove the GSCC Warning File.Sql.33 */
1945: INSERT INTO pa_rbs_element_names_tl(
1946: RBS_ELEMENT_NAME_ID,
1947: RESOURCE_NAME,
1948: LANGUAGE,
1949: SOURCE_LANG,

Line 1985: INSERT INTO pa_rbs_element_names_tl(

1981: END IF;
1982:
1983: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
1984: to remove the GSCC Warning File.Sql.33 */
1985: INSERT INTO pa_rbs_element_names_tl(
1986: RBS_ELEMENT_NAME_ID,
1987: RESOURCE_NAME,
1988: LANGUAGE,
1989: SOURCE_LANG,

Line 2029: INSERT INTO pa_rbs_element_names_tl(

2025:
2026: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
2027: to remove the GSCC Warning File.Sql.33 */
2028: --MLS Changes
2029: INSERT INTO pa_rbs_element_names_tl(
2030: RBS_ELEMENT_NAME_ID,
2031: RESOURCE_NAME,
2032: LANGUAGE,
2033: SOURCE_LANG,

Line 2069: INSERT INTO pa_rbs_element_names_tl(

2065: END IF;
2066:
2067: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
2068: to remove the GSCC Warning File.Sql.33 */
2069: INSERT INTO pa_rbs_element_names_tl(
2070: RBS_ELEMENT_NAME_ID,
2071: RESOURCE_NAME,
2072: LANGUAGE,
2073: SOURCE_LANG,

Line 2107: INSERT INTO pa_rbs_element_names_tl(

2103: END IF;
2104:
2105: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
2106: to remove the GSCC Warning File.Sql.33 */
2107: INSERT INTO pa_rbs_element_names_tl(
2108: RBS_ELEMENT_NAME_ID,
2109: RESOURCE_NAME,
2110: LANGUAGE,
2111: SOURCE_LANG,

Line 2149: INSERT INTO pa_rbs_element_names_tl(

2145:
2146: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
2147: to remove the GSCC Warning File.Sql.33 */
2148: --MLS Changes
2149: INSERT INTO pa_rbs_element_names_tl(
2150: RBS_ELEMENT_NAME_ID,
2151: RESOURCE_NAME,
2152: LANGUAGE,
2153: SOURCE_LANG,

Line 2189: INSERT INTO pa_rbs_element_names_tl(

2185: END IF;
2186:
2187: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
2188: to remove the GSCC Warning File.Sql.33 */
2189: INSERT INTO pa_rbs_element_names_tl(
2190: RBS_ELEMENT_NAME_ID,
2191: RESOURCE_NAME,
2192: LANGUAGE,
2193: SOURCE_LANG,

Line 2226: INSERT INTO pa_rbs_element_names_tl(

2222: END IF;
2223:
2224: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
2225: to remove the GSCC Warning File.Sql.33 */
2226: INSERT INTO pa_rbs_element_names_tl(
2227: RBS_ELEMENT_NAME_ID,
2228: RESOURCE_NAME,
2229: LANGUAGE,
2230: SOURCE_LANG,

Line 2266: INSERT INTO pa_rbs_element_names_tl(

2262: END IF;
2263:
2264: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
2265: to remove the GSCC Warning File.Sql.33 */
2266: INSERT INTO pa_rbs_element_names_tl(
2267: RBS_ELEMENT_NAME_ID,
2268: RESOURCE_NAME,
2269: LANGUAGE,
2270: SOURCE_LANG,

Line 2304: INSERT INTO pa_rbs_element_names_tl(

2300:
2301: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
2302: to remove the GSCC Warning File.Sql.33 */
2303: --MLS Changes
2304: INSERT INTO pa_rbs_element_names_tl(
2305: RBS_ELEMENT_NAME_ID,
2306: RESOURCE_NAME,
2307: LANGUAGE,
2308: SOURCE_LANG,

Line 2345: INSERT INTO pa_rbs_element_names_tl(

2341:
2342: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
2343: to remove the GSCC Warning File.Sql.33 */
2344: --MLS
2345: INSERT INTO pa_rbs_element_names_tl(
2346: RBS_ELEMENT_NAME_ID,
2347: RESOURCE_NAME,
2348: LANGUAGE,
2349: SOURCE_LANG,

Line 3845: delete from pa_rbs_element_names_tl T

3841:
3842: procedure ADD_LANGUAGE
3843: is
3844: begin
3845: delete from pa_rbs_element_names_tl T
3846: where not exists
3847: (select NULL
3848: from pa_rbs_element_names_b B
3849: where B.RBS_ELEMENT_NAME_ID = T.RBS_ELEMENT_NAME_ID

Line 3852: update pa_rbs_element_names_tl T set (

3848: from pa_rbs_element_names_b B
3849: where B.RBS_ELEMENT_NAME_ID = T.RBS_ELEMENT_NAME_ID
3850: );
3851:
3852: update pa_rbs_element_names_tl T set (
3853: RESOURCE_NAME
3854: ) = (select
3855: B.RESOURCE_NAME
3856: from pa_rbs_element_names_tl b

Line 3856: from pa_rbs_element_names_tl b

3852: update pa_rbs_element_names_tl T set (
3853: RESOURCE_NAME
3854: ) = (select
3855: B.RESOURCE_NAME
3856: from pa_rbs_element_names_tl b
3857: where B.RBS_ELEMENT_NAME_ID = T.RBS_ELEMENT_NAME_ID
3858: and B.LANGUAGE = T.SOURCE_LANG)
3859: where (
3860: T.RBS_ELEMENT_NAME_ID,

Line 3865: from pa_rbs_element_names_tl SUBB, pa_rbs_element_names_tl SUBT

3861: T.LANGUAGE
3862: ) in (select
3863: SUBT.RBS_ELEMENT_NAME_ID,
3864: SUBT.LANGUAGE
3865: from pa_rbs_element_names_tl SUBB, pa_rbs_element_names_tl SUBT
3866: where SUBB.RBS_ELEMENT_NAME_ID = SUBT.RBS_ELEMENT_NAME_ID
3867: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
3868: and (SUBB.RESOURCE_NAME <> SUBT.RESOURCE_NAME
3869: ));

Line 3871: insert into pa_rbs_element_names_tl (

3867: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
3868: and (SUBB.RESOURCE_NAME <> SUBT.RESOURCE_NAME
3869: ));
3870:
3871: insert into pa_rbs_element_names_tl (
3872: LAST_UPDATE_LOGIN,
3873: CREATION_DATE,
3874: CREATED_BY,
3875: LAST_UPDATE_DATE,

Line 3891: from pa_rbs_element_names_tl B, FND_LANGUAGES L

3887: B.RBS_ELEMENT_NAME_ID,
3888: B.RESOURCE_NAME,
3889: L.LANGUAGE_CODE,
3890: B.SOURCE_LANG
3891: from pa_rbs_element_names_tl B, FND_LANGUAGES L
3892: where L.INSTALLED_FLAG in ('I', 'B')
3893: and B.LANGUAGE = userenv('LANG')
3894: and not exists
3895: (select NULL

Line 3896: from pa_rbs_element_names_tl T

3892: where L.INSTALLED_FLAG in ('I', 'B')
3893: and B.LANGUAGE = userenv('LANG')
3894: and not exists
3895: (select NULL
3896: from pa_rbs_element_names_tl T
3897: where T.RBS_ELEMENT_NAME_ID = B.RBS_ELEMENT_NAME_ID
3898: and T.LANGUAGE = L.LANGUAGE_CODE);
3899: end ADD_LANGUAGE;
3900: