APPS.ASG_PUB_ITEM_PKG dependencies on ASG_PUB

Line 1: PACKAGE BODY ASG_PUB_ITEM_PKG as

1: PACKAGE BODY ASG_PUB_ITEM_PKG as
2: /* $Header: asgpubib.pls 120.2.12020000.2 2013/04/09 11:56:42 saradhak ship $ */
3:
4:
5: --HISTORY

Line 105: insert into ASG_PUB_ITEM (

101: when others then
102: l_access_owner := x_access_owner;
103: end;
104:
105: insert into ASG_PUB_ITEM (
106: ITEM_ID,
107: NAME,
108: PUB_NAME,
109: BASE_OWNER,

Line 269: from asg_pub_item

265: l_multi_plat VARCHAR2(1);
266: begin
267: select pub_name,CURRENT_RELEASE_VERSION,HTML5_OFFLINE
268: into l_pub_name,l_current_release_version,l_multi_plat
269: from asg_pub_item
270: where item_id = x_item_id;
271:
272: BEGIN
273: select nvl(custom, 'N') into l_custom_flag

Line 274: from asg_pub

270: where item_id = x_item_id;
271:
272: BEGIN
273: select nvl(custom, 'N') into l_custom_flag
274: from asg_pub
275: where pub_id = l_pub_name;
276: EXCEPTION
277: when no_data_found then
278: l_custom_flag := 'N';

Line 307: update asg_pub_item set

303: when others then
304: l_access_owner := x_access_owner;
305: end;
306:
307: update asg_pub_item set
308: ITEM_ID = X_ITEM_ID,
309: NAME = X_NAME,
310: PUB_NAME = x_pub_Name,
311: BASE_OWNER = L_BASE_OWNER,

Line 425: asg_pub_item_pkg.UPDATE_ROW (

421: if (p_owner = 'SEED') then
422: l_user_id := 1;
423: end if;
424:
425: asg_pub_item_pkg.UPDATE_ROW (
426: X_ITEM_ID => x_ITEM_ID,
427: X_NAME => x_NAME,
428: X_PUB_NAME => x_PUB_NAME,
429: X_BASE_OWNER => x_BASE_OWNER,

Line 475: asg_pub_item_pkg.insert_row (

471:
472: EXCEPTION
473: WHEN NO_DATA_FOUND THEN
474:
475: asg_pub_item_pkg.insert_row (
476: X_ITEM_ID => x_ITEM_ID,
477: X_NAME => x_NAME,
478: X_PUB_NAME => x_PUB_NAME,
479: X_BASE_OWNER => x_BASE_OWNER,

Line 524: END ASG_PUB_ITEM_PKG;

520: X_LAST_UPDATED_BY => l_user_id);
521:
522: END load_row;
523:
524: END ASG_PUB_ITEM_PKG;