DBA Data[Home] [Help]

APPS.ASG_RESP_PKG dependencies on ASG_RESP_PKG

Line 1: PACKAGE BODY ASG_RESP_PKG as

1: PACKAGE BODY ASG_RESP_PKG as
2: /* $Header: asgrespb.pls 120.1 2005/08/12 02:57:16 saradhak noship $ */
3:
4: -- HISTORY
5: -- JUN 03 2002 ytian changed _ID pk type to varchar2.

Line 90: asg_resp_pkg.UPDATE_ROW (

86: if (p_owner = 'SEED') then
87: l_user_id := 1;
88: end if;
89:
90: asg_resp_pkg.UPDATE_ROW (
91: X_PUB_ID => x_PUB_ID,
92: X_RESPONSIBILITY_ID => x_RESPONSIBILITY_ID,
93: X_CREATION_DATE => X_CREATION_DATE,
94: X_CREATED_BY => X_CREATED_BY,

Line 101: asg_resp_pkg.insert_row (

97:
98: EXCEPTION
99: WHEN NO_DATA_FOUND THEN
100:
101: asg_resp_pkg.insert_row (
102: X_PUB_ID => x_PUB_ID,
103: x_RESPONSIBILITY_ID => x_RESPONSIBILITY_Id,
104: X_CREATION_DATE => sysdate,
105: X_CREATED_BY => l_user_id,

Line 111: END ASG_RESP_PKG;

107: X_LAST_UPDATED_BY => l_user_id);
108:
109: END load_row;
110:
111: END ASG_RESP_PKG;