APPS.PA_PROJ_PROGRESS_ATTR_PKG dependencies on PA_PROJ_PROGRESS_ATTR

Line 1: package body PA_PROJ_PROGRESS_ATTR_PKG as

1: package body PA_PROJ_PROGRESS_ATTR_PKG as
2: /* $Header: PAPPPKGB.pls 120.2 2005/08/23 02:04:55 avaithia noship $*/
3:
4: procedure INSERT_ROW(
5: X_PROJ_PROGRESS_ATTR_ID IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 29: select PA_PROJ_PROGRESS_ATTR_S.nextval

25: BEGIN
26:
27: IF X_PROJ_PROGRESS_ATTR_ID IS NULL
28: THEN
29: select PA_PROJ_PROGRESS_ATTR_S.nextval
30: into X_PROJ_PROGRESS_ATTR_ID
31: from dual;
32: END IF;
33:

Line 34: insert into PA_PROJ_PROGRESS_ATTR(

30: into X_PROJ_PROGRESS_ATTR_ID
31: from dual;
32: END IF;
33:
34: insert into PA_PROJ_PROGRESS_ATTR(
35: PROJ_PROGRESS_ATTR_ID
36: ,OBJECT_TYPE
37: ,OBJECT_ID
38: ,LAST_UPDATE_DATE

Line 80: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_PROGRESS_ATTR_PKG',

76: exception when others then
77: -- RESET OUT param in Exception block : 4537865 - Start
78: X_PROJ_PROGRESS_ATTR_ID := NULL ;
79: -- End : 4537865
80: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_PROGRESS_ATTR_PKG',
81: p_procedure_name => 'INSERT_ROW',
82: p_error_text => SUBSTRB(SQLERRM,1,240));
83: raise;
84: End INSERT_ROW;

Line 107: UPDATE PA_PROJ_PROGRESS_ATTR

103: ,X_STRUCTURE_TYPE IN VARCHAR2
104: ) IS
105:
106: BEGIN
107: UPDATE PA_PROJ_PROGRESS_ATTR
108: SET
109: OBJECT_TYPE = DECODE( X_OBJECT_TYPE, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
110: OBJECT_TYPE, X_OBJECT_TYPE )
111: ,OBJECT_ID = DECODE( X_OBJECT_ID, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 150: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_PROGRESS_ATTR_PKG',

146: end if;*/
147:
148:
149: exception when others then
150: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_PROGRESS_ATTR_PKG',
151: p_procedure_name => 'UPDATE_ROW',
152: p_error_text => SUBSTRB(SQLERRM,1,240));
153: raise;
154: End;

Line 159: DELETE FROM PA_PROJ_PROGRESS_ATTR

155:
156: Procedure DELETE_ROW(
157: p_row_id VARCHAR2 ) IS
158: BEGIN
159: DELETE FROM PA_PROJ_PROGRESS_ATTR
160: WHERE rowid = p_row_id;
161: END DELETE_ROW;
162:
163: end PA_PROJ_PROGRESS_ATTR_PKG;

Line 163: end PA_PROJ_PROGRESS_ATTR_PKG;

159: DELETE FROM PA_PROJ_PROGRESS_ATTR
160: WHERE rowid = p_row_id;
161: END DELETE_ROW;
162:
163: end PA_PROJ_PROGRESS_ATTR_PKG;
164: