APPS.ICX_NONCAT_TEMPLATES_PKG dependencies on POR_NONCAT_TEMPLATES_ALL_B

Line 16: cursor C is select ROWID from POR_NONCAT_TEMPLATES_ALL_B

12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from POR_NONCAT_TEMPLATES_ALL_B
17: where TEMPLATE_ID = X_TEMPLATE_ID;
18: begin
19:
20: insert into POR_NONCAT_TEMPLATES_ALL_B (

Line 20: insert into POR_NONCAT_TEMPLATES_ALL_B (

16: cursor C is select ROWID from POR_NONCAT_TEMPLATES_ALL_B
17: where TEMPLATE_ID = X_TEMPLATE_ID;
18: begin
19:
20: insert into POR_NONCAT_TEMPLATES_ALL_B (
21: TEMPLATE_ID,
22: ORG_ID,
23: CREATION_DATE,
24: CREATED_BY,

Line 92: update POR_NONCAT_TEMPLATES_ALL_B set

88: X_LAST_UPDATED_BY in NUMBER,
89: X_LAST_UPDATE_LOGIN in NUMBER
90: ) is
91: begin
92: update POR_NONCAT_TEMPLATES_ALL_B set
93: ORG_ID = X_ORG_ID,
94: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
95: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
96: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 263: from POR_NONCAT_TEMPLATES_ALL_B B

259: begin
260: delete from POR_NONCAT_TEMPLATES_ALL_TL T
261: where not exists
262: (select NULL
263: from POR_NONCAT_TEMPLATES_ALL_B B
264: where B.TEMPLATE_ID = T.TEMPLATE_ID
265: );
266:
267: insert into POR_NONCAT_TEMPLATES_ALL_TL (