APPS.IEB_SERVICEPLAN_PVT dependencies on IEB_SERVICE_PLANS_TL

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 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 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 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 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 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 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 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 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: