APPS.ASG_PUB_PKG dependencies on ASG_PUB

Line 1: PACKAGE BODY ASG_PUB_PKG as

1: PACKAGE BODY ASG_PUB_PKG as
2: /* $Header: asgppubb.pls 120.1 2005/08/12 02:53:07 saradhak noship $ */
3:
4: -- HISTORY
5: -- AUG 21, 2003 ytian Modified the update_row, need to update the entry

Line 2: /* $Header: asgppubb.pls 120.1 2005/08/12 02:53:07 saradhak noship $ */

1: PACKAGE BODY ASG_PUB_PKG as
2: /* $Header: asgppubb.pls 120.1 2005/08/12 02:53:07 saradhak noship $ */
3:
4: -- HISTORY
5: -- AUG 21, 2003 ytian Modified the update_row, need to update the entry
6: -- for the custom publication as well.

Line 44: insert into ASG_PUB (

40:
41: begin
42:
43:
44: insert into ASG_PUB (
45: PUB_ID,
46: NAME,
47: ENABLED,
48: STATUS,

Line 119: from asg_pub

115: begin
116:
117: select nvl(custom, 'N')
118: into l_update_flag
119: from asg_pub
120: where pub_id = x_pub_id;
121:
122: if (l_update_flag = 'N' ) then
123: update asg_pub set

Line 123: update asg_pub set

119: from asg_pub
120: where pub_id = x_pub_id;
121:
122: if (l_update_flag = 'N' ) then
123: update asg_pub set
124: PUB_ID = X_PUB_ID,
125: NAME = X_NAME,
126: ENABLED = X_ENABLED,
127: -- STATUS = X_STATUS,

Line 142: update asg_pub set

138: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
139: LAST_UPDATED_BY = X_LAST_UPDATED_BY
140: where PUB_ID = X_PUB_ID;
141: else
142: update asg_pub set
143: ADDITIONAL_DEVICE_TYPE = X_ADDITIONAL_DEVICE_TYPE
144: where PUB_ID = X_PUB_ID;
145: end if;
146:

Line 182: asg_pub_pkg.UPDATE_ROW (

178: if (p_owner = 'SEED') then
179: l_user_id := 1;
180: end if;
181:
182: asg_pub_pkg.UPDATE_ROW (
183: X_PUB_ID => x_PUB_ID,
184: X_NAME => x_NAME,
185: X_ENABLED => x_ENABLED,
186: X_STATUS => x_STATUS,

Line 204: asg_pub_pkg.insert_row (

200:
201: EXCEPTION
202: WHEN NO_DATA_FOUND THEN
203:
204: asg_pub_pkg.insert_row (
205: X_PUB_ID => x_PUB_ID,
206: X_NAME => x_NAME,
207: X_ENABLED => x_ENABLED,
208: X_STATUS => x_STATUS,

Line 225: END ASG_PUB_PKG;

221: X_LAST_UPDATED_BY => l_user_id);
222:
223: END load_row;
224:
225: END ASG_PUB_PKG;