APPS.AMS_PROD_TEMPLATE_PKG dependencies on AMS_PROD_TEMPLATES_B

Line 10: from AMS_PROD_TEMPLATES_B B

6: begin
7: delete from AMS_PROD_TEMPLATES_TL T
8: where not exists
9: (select NULL
10: from AMS_PROD_TEMPLATES_B B
11: where B.TEMPLATE_ID = T.TEMPLATE_ID
12: );
13:
14: update AMS_PROD_TEMPLATES_TL T set (

Line 111: from AMS_PROD_TEMPLATES_B

107: l_db_luby_id number;
108:
109: cursor c_obj_verno is
110: select object_version_number
111: from AMS_PROD_TEMPLATES_B
112: where template_id = X_TEMPLATE_ID;
113:
114: cursor c_chk_temp_exists is
115: select 'x'

Line 116: from AMS_PROD_TEMPLATES_B

112: where template_id = X_TEMPLATE_ID;
113:
114: cursor c_chk_temp_exists is
115: select 'x'
116: from AMS_PROD_TEMPLATES_B
117: where template_id = X_TEMPLATE_ID;
118:
119: cursor c_get_tempid is
120: select AMS_PROD_TEMPLATES_B_S.nextval

Line 120: select AMS_PROD_TEMPLATES_B_S.nextval

116: from AMS_PROD_TEMPLATES_B
117: where template_id = X_TEMPLATE_ID;
118:
119: cursor c_get_tempid is
120: select AMS_PROD_TEMPLATES_B_S.nextval
121: from dual;
122:
123: cursor c_db_data_details is
124: select last_updated_by, nvl(object_version_number,1)

Line 125: from AMS_PROD_TEMPLATES_B

121: from dual;
122:
123: cursor c_db_data_details is
124: select last_updated_by, nvl(object_version_number,1)
125: from AMS_PROD_TEMPLATES_B
126: where template_id = X_TEMPLATE_ID;
127:
128: BEGIN
129:

Line 155: INSERT INTO AMS_PROD_TEMPLATES_B(

151: end if;
152:
153: l_obj_verno := 1;
154:
155: INSERT INTO AMS_PROD_TEMPLATES_B(
156: template_id,
157: last_update_date,
158: last_updated_by,
159: creation_date,

Line 212: Update AMS_PROD_TEMPLATES_B

208: close c_db_data_details;
209:
210: if (l_db_luby_id IN (1,2,0)
211: OR NVL(x_custom_mode,'PRESERVE') = 'FORCE') THEN
212: Update AMS_PROD_TEMPLATES_B
213: SET last_update_date = sysdate,
214: last_updated_by = l_user_id,
215: object_version_number = l_obj_verno +1,
216: last_update_login = 0,