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.IEB_SERVICEPLAN_PVT dependencies on IEB_SERVICE_PLANS

Line 33: l_svc_plan_id IEB_SERVICE_PLANS.SVCPLN_ID%type;

29: l_return_status VARCHAR2(4);
30:
31: l_msg_count NUMBER(2);
32:
33: l_svc_plan_id IEB_SERVICE_PLANS.SVCPLN_ID%type;
34: l_temp_str varchar2(80);
35:
36: BEGIN
37:

Line 51: EXECUTE immediate 'INSERT INTO IEB_SERVICE_PLANS '||

47:
48:
49: select IEB_SVC_PLAN_S1.nextval into l_svc_plan_id from dual;
50:
51: EXECUTE immediate 'INSERT INTO IEB_SERVICE_PLANS '||
52: '( SVCPLN_ID, ' ||
53: ' CREATED_BY, ' ||
54: ' CREATION_DATE, ' ||
55: ' LAST_UPDATED_BY,' ||

Line 96: insert into IEB_SERVICE_PLANS_TL (

92: 0;
93:
94:
95:
96: insert into IEB_SERVICE_PLANS_TL (
97: CREATION_DATE,
98: LAST_UPDATED_BY,
99: LAST_UPDATE_DATE,
100: CREATED_BY,

Line 124: from IEB_SERVICE_PLANS_TL T

120: FROM FND_LANGUAGES L
121: where L.INSTALLED_FLAG in ('I', 'B')
122: and not exists
123: (select NULL
124: from IEB_SERVICE_PLANS_TL T
125: where T.SERVICE_PLAN_ID = l_svc_plan_id
126: and T.LANGUAGE = L.LANGUAGE_CODE);
127:
128:

Line 183: l_svc_plan_id IEB_SERVICE_PLANS.SVCPLN_ID%type;

179: l_return_status VARCHAR2(4);
180:
181: l_msg_count NUMBER(2);
182:
183: l_svc_plan_id IEB_SERVICE_PLANS.SVCPLN_ID%type;
184:
185: l_isvccov_id IEB_INB_SVC_COVERAGES.ISVCCOV_ID%type;
186:
187: l_osvccov_id IEB_OUTB_SVC_COVERAGES.OSVCCOV_ID%type;

Line 452: l_svc_plan_id IEB_SERVICE_PLANS.SVCPLN_ID%type;

448: l_return_status VARCHAR2(4);
449:
450: l_msg_count NUMBER(2);
451:
452: l_svc_plan_id IEB_SERVICE_PLANS.SVCPLN_ID%type;
453:
454: l_isvccov_id IEB_INB_SVC_COVERAGES.ISVCCOV_ID%type;
455:
456: l_osvccov_id IEB_OUTB_SVC_COVERAGES.OSVCCOV_ID%type;

Line 1072: l_svc_plan_id IEB_SERVICE_PLANS.SVCPLN_ID%type;

1068: l_return_status VARCHAR2(4);
1069:
1070: l_msg_count NUMBER(2);
1071:
1072: l_svc_plan_id IEB_SERVICE_PLANS.SVCPLN_ID%type;
1073:
1074: BEGIN
1075:
1076:

Line 1182: l_svc_plan_id IEB_SERVICE_PLANS.SVCPLN_ID%type;

1178: l_return_status VARCHAR2(4);
1179:
1180: l_msg_count NUMBER(2);
1181:
1182: l_svc_plan_id IEB_SERVICE_PLANS.SVCPLN_ID%type;
1183:
1184: l_map_id IEB_GROUP_PLAN_MAPS.MAP_ID%type;
1185:
1186: BEGIN

Line 1679: l_service_plan_b_id IEB_SERVICE_PLANS.SVCPLN_ID%type;

1675: )
1676: as
1677:
1678:
1679: l_service_plan_b_id IEB_SERVICE_PLANS.SVCPLN_ID%type;
1680:
1681: l_service_plan_tl_id IEB_SERVICE_PLANS_TL.SERVICE_PLAN_ID%type;
1682: l_language VARCHAR2(4);
1683:

Line 1681: l_service_plan_tl_id IEB_SERVICE_PLANS_TL.SERVICE_PLAN_ID%type;

1677:
1678:
1679: l_service_plan_b_id IEB_SERVICE_PLANS.SVCPLN_ID%type;
1680:
1681: l_service_plan_tl_id IEB_SERVICE_PLANS_TL.SERVICE_PLAN_ID%type;
1682: l_language VARCHAR2(4);
1683:
1684:
1685: BEGIN

Line 1693: ' delete from IEB_SERVICE_PLANS where SVCPLN_ID = :1 or SVCPLN_ID in ( select SERVICE_PLAN_ID from ieb_regional_plans where base_plan_id = :2)'

1689: x_msg_count := 0;
1690: x_msg_data := '';
1691:
1692: EXECUTE immediate
1693: ' delete from IEB_SERVICE_PLANS where SVCPLN_ID = :1 or SVCPLN_ID in ( select SERVICE_PLAN_ID from ieb_regional_plans where base_plan_id = :2)'
1694: USING x_service_plan_id, x_service_plan_id;
1695: if (sql%notfound) then
1696: null;
1697: end if;

Line 1700: ' delete from IEB_SERVICE_PLANS_TL where SERVICE_PLAN_ID = :1 or SERVICE_PLAN_ID in ( select SERVICE_PLAN_ID from ieb_regional_plans where base_plan_id =:2)'

1696: null;
1697: end if;
1698:
1699: EXECUTE immediate
1700: ' delete from IEB_SERVICE_PLANS_TL where SERVICE_PLAN_ID = :1 or SERVICE_PLAN_ID in ( select SERVICE_PLAN_ID from ieb_regional_plans where base_plan_id =:2)'
1701: USING x_service_plan_id, x_service_plan_id;
1702:
1703: if (sql%notfound) then
1704: null;

Line 1778: l_service_plan_b_id IEB_SERVICE_PLANS.SVCPLN_ID%type;

1774: )
1775: as
1776:
1777:
1778: l_service_plan_b_id IEB_SERVICE_PLANS.SVCPLN_ID%type;
1779:
1780: l_service_plan_tl_id IEB_SERVICE_PLANS_TL.SERVICE_PLAN_ID%type;
1781: l_language VARCHAR2(4);
1782:

Line 1780: l_service_plan_tl_id IEB_SERVICE_PLANS_TL.SERVICE_PLAN_ID%type;

1776:
1777:
1778: l_service_plan_b_id IEB_SERVICE_PLANS.SVCPLN_ID%type;
1779:
1780: l_service_plan_tl_id IEB_SERVICE_PLANS_TL.SERVICE_PLAN_ID%type;
1781: l_language VARCHAR2(4);
1782:
1783:
1784: BEGIN

Line 1851: l_service_plan_b_id IEB_SERVICE_PLANS.SVCPLN_ID%type;

1847: p_media_type_id in NUMBER
1848: ) as
1849:
1850:
1851: l_service_plan_b_id IEB_SERVICE_PLANS.SVCPLN_ID%type;
1852:
1853: l_service_plan_tl_id IEB_SERVICE_PLANS_TL.SERVICE_PLAN_ID%type;
1854: l_language VARCHAR2(4);
1855:

Line 1853: l_service_plan_tl_id IEB_SERVICE_PLANS_TL.SERVICE_PLAN_ID%type;

1849:
1850:
1851: l_service_plan_b_id IEB_SERVICE_PLANS.SVCPLN_ID%type;
1852:
1853: l_service_plan_tl_id IEB_SERVICE_PLANS_TL.SERVICE_PLAN_ID%type;
1854: l_language VARCHAR2(4);
1855:
1856:
1857: BEGIN

Line 1910: l_service_plan_b_id IEB_SERVICE_PLANS.SVCPLN_ID%type;

1906: p_plan_id IN VARCHAR2
1907: )as
1908:
1909:
1910: l_service_plan_b_id IEB_SERVICE_PLANS.SVCPLN_ID%type;
1911:
1912: l_service_plan_tl_id IEB_SERVICE_PLANS_TL.SERVICE_PLAN_ID%type;
1913: l_language VARCHAR2(4);
1914:

Line 1912: l_service_plan_tl_id IEB_SERVICE_PLANS_TL.SERVICE_PLAN_ID%type;

1908:
1909:
1910: l_service_plan_b_id IEB_SERVICE_PLANS.SVCPLN_ID%type;
1911:
1912: l_service_plan_tl_id IEB_SERVICE_PLANS_TL.SERVICE_PLAN_ID%type;
1913: l_language VARCHAR2(4);
1914:
1915:
1916: BEGIN

Line 1961: l_media_type_id IEB_SERVICE_PLANS.MEDIA_TYPE_ID%type;

1957: p_base_plan_id IN NUMBER,
1958: p_reg_plan_id IN NUMBER )as
1959:
1960:
1961: l_media_type_id IEB_SERVICE_PLANS.MEDIA_TYPE_ID%type;
1962:
1963: l_service_plan_tl_id IEB_SERVICE_PLANS_TL.SERVICE_PLAN_ID%type;
1964: l_language VARCHAR2(4);
1965:

Line 1963: l_service_plan_tl_id IEB_SERVICE_PLANS_TL.SERVICE_PLAN_ID%type;

1959:
1960:
1961: l_media_type_id IEB_SERVICE_PLANS.MEDIA_TYPE_ID%type;
1962:
1963: l_service_plan_tl_id IEB_SERVICE_PLANS_TL.SERVICE_PLAN_ID%type;
1964: l_language VARCHAR2(4);
1965:
1966: l_source_lang VARCHAR2(4);
1967:

Line 1977: select MEDIA_TYPE_ID into l_media_type_id from IEB_SERVICE_PLANS where SVCPLN_ID = p_base_plan_id;

1973: x_msg_count := 0;
1974: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1975: x_msg_data := '';
1976:
1977: select MEDIA_TYPE_ID into l_media_type_id from IEB_SERVICE_PLANS where SVCPLN_ID = p_base_plan_id;
1978:
1979: update IEB_WB_SVC_CATS set
1980: svcpln_svcpln_id = p_base_plan_id,
1981: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 2021: ' delete from IEB_SERVICE_PLANS where SVCPLN_ID = :1'

2017: if (sql%notfound) then
2018: null;
2019: end if;
2020: EXECUTE immediate
2021: ' delete from IEB_SERVICE_PLANS where SVCPLN_ID = :1'
2022: USING p_reg_plan_id;
2023:
2024: if (sql%notfound) then
2025: null;

Line 2029: ' delete from IEB_SERVICE_PLANS_TL where SERVICE_PLAN_ID = :1'

2025: null;
2026: end if;
2027:
2028: EXECUTE immediate
2029: ' delete from IEB_SERVICE_PLANS_TL where SERVICE_PLAN_ID = :1'
2030: USING p_reg_plan_id;
2031:
2032: if (sql%notfound) then
2033: null;

Line 2108: l_media_type_id IEB_SERVICE_PLANS.MEDIA_TYPE_ID%type;

2104: p_spec_date IN VARCHAR2
2105: )as
2106:
2107:
2108: l_media_type_id IEB_SERVICE_PLANS.MEDIA_TYPE_ID%type;
2109:
2110: l_service_plan_tl_id IEB_SERVICE_PLANS_TL.SERVICE_PLAN_ID%type;
2111: l_language VARCHAR2(4);
2112:

Line 2110: l_service_plan_tl_id IEB_SERVICE_PLANS_TL.SERVICE_PLAN_ID%type;

2106:
2107:
2108: l_media_type_id IEB_SERVICE_PLANS.MEDIA_TYPE_ID%type;
2109:
2110: l_service_plan_tl_id IEB_SERVICE_PLANS_TL.SERVICE_PLAN_ID%type;
2111: l_language VARCHAR2(4);
2112:
2113: l_source_lang VARCHAR2(4);
2114: