APPS.POR_IFT_ADMIN_PKG dependencies on POR_TEMPLATES_ALL_B

Line 17: INSERT INTO POR_TEMPLATES_ALL_B (

13: l_count_obj NUMBER;
14: BEGIN
15:
16: l_progress := '001';
17: INSERT INTO POR_TEMPLATES_ALL_B (
18: TEMPLATE_CODE,
19: ORG_ID,
20: ATTACHMENT_CATEGORY_ID,
21: CREATED_BY,

Line 84: FROM por_templates_all_b

80: p_user_id IN NUMBER,
81: p_login_id IN NUMBER) IS
82: CURSOR c_rec(p_row_id VARCHAR2) IS
83: SELECT *
84: FROM por_templates_all_b
85: WHERE rowid = p_row_id
86: FOR UPDATE NOWAIT;
87:
88: CURSOR c_tl_rec(p_template_code VARCHAR2) IS

Line 155: UPDATE POR_TEMPLATES_ALL_B

151: l_progress VARCHAR2(10) := '000';
152: BEGIN
153:
154: l_progress := '001';
155: UPDATE POR_TEMPLATES_ALL_B
156: SET
157: ORG_ID = p_org_id,
158: ATTACHMENT_CATEGORY_ID = p_attach_cat_id,
159: LAST_UPDATED_BY = p_user_id,

Line 207: DELETE FROM POR_TEMPLATES_ALL_B

203: DELETE FROM POR_TEMPLATE_ATTRIBUTES_B
204: WHERE TEMPLATE_CODE = l_template_code;
205:
206: l_progress := '004';
207: DELETE FROM POR_TEMPLATES_ALL_B
208: WHERE TEMPLATE_CODE = l_template_code;
209:
210: l_progress := '005';
211: DELETE FROM POR_TEMPLATES_ALL_TL