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.1 2005/08/12 02:54:54 saradhak noship $ */
3:
4:
5: --HISTORY

Line 104: insert into ASG_PUB_ITEM (

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

Line 265: from asg_pub_item

261: l_access_owner varchar2(30);
262:
263: begin
264: select pub_name into l_pub_name
265: from asg_pub_item
266: where item_id = x_item_id;
267:
268: BEGIN
269: select nvl(custom, 'N') into l_custom_flag

Line 270: from asg_pub

266: where item_id = x_item_id;
267:
268: BEGIN
269: select nvl(custom, 'N') into l_custom_flag
270: from asg_pub
271: where pub_id = l_pub_name;
272: EXCEPTION
273: when no_data_found then
274: l_custom_flag := 'N';

Line 303: update asg_pub_item set

299: when others then
300: l_access_owner := x_access_owner;
301: end;
302:
303: update asg_pub_item set
304: ITEM_ID = X_ITEM_ID,
305: NAME = X_NAME,
306: PUB_NAME = x_pub_Name,
307: BASE_OWNER = L_BASE_OWNER,

Line 413: asg_pub_item_pkg.UPDATE_ROW (

409: if (p_owner = 'SEED') then
410: l_user_id := 1;
411: end if;
412:
413: asg_pub_item_pkg.UPDATE_ROW (
414: X_ITEM_ID => x_ITEM_ID,
415: X_NAME => x_NAME,
416: X_PUB_NAME => x_PUB_NAME,
417: X_BASE_OWNER => x_BASE_OWNER,

Line 463: asg_pub_item_pkg.insert_row (

459:
460: EXCEPTION
461: WHEN NO_DATA_FOUND THEN
462:
463: asg_pub_item_pkg.insert_row (
464: X_ITEM_ID => x_ITEM_ID,
465: X_NAME => x_NAME,
466: X_PUB_NAME => x_PUB_NAME,
467: X_BASE_OWNER => x_BASE_OWNER,

Line 512: END ASG_PUB_ITEM_PKG;

508: X_LAST_UPDATED_BY => l_user_id);
509:
510: END load_row;
511:
512: END ASG_PUB_ITEM_PKG;