APPS.PA_PERCENT_COMPLETES_PKG dependencies on PA_PERCENT_COMPLETES

Line 1: package body PA_PERCENT_COMPLETES_PKG as

1: package body PA_PERCENT_COMPLETES_PKG as
2: /* $Header: PAPCPKGB.pls 120.1.12020000.2 2013/03/28 12:52:37 bpottipa ship $*/
3:
4: procedure INSERT_ROW( p_TASK_ID IN NUMBER,
5: p_DATE_COMPUTED IN DATE,

Line 54: select PA_PERCENT_COMPLETES_S.nextval

50: BEGIN
51: l_percent_complete_id := x_percent_complete_id;
52: IF l_PERCENT_COMPLETE_ID IS NULL
53: THEN
54: select PA_PERCENT_COMPLETES_S.nextval
55: into l_percent_complete_id
56: from dual;
57: END IF;
58: insert into pa_percent_completes(TASK_ID,

Line 58: insert into pa_percent_completes(TASK_ID,

54: select PA_PERCENT_COMPLETES_S.nextval
55: into l_percent_complete_id
56: from dual;
57: END IF;
58: insert into pa_percent_completes(TASK_ID,
59: DATE_COMPUTED,
60: LAST_UPDATE_DATE,
61: LAST_UPDATED_BY,
62: CREATION_DATE,

Line 153: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PERCENT_COMPLETES_PKG',

149: );
150: x_percent_complete_id := l_percent_complete_id;
151: exception when others then
152: x_percent_complete_id := NULL;
153: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PERCENT_COMPLETES_PKG',
154: p_procedure_name => 'INSERT_ROW',
155: p_error_text => SUBSTRB(SQLERRM,1,240));
156: raise;
157: End;

Line 205: update pa_percent_completes

201: , X_CBS_ELEMENT_ID IN NUMBER DEFAULT NULL --Added for CBS 16200605
202: ) IS
203:
204: BEGIN
205: update pa_percent_completes
206: set
207: OBJECT_VERSION_ID = decode(P_OBJECT_VERSION_ID,FND_API.G_MISS_NUM,OBJECT_VERSION_ID,P_OBJECT_VERSION_ID),
208: OBJECT_TYPE = decode(p_OBJECT_TYPE,FND_API.G_MISS_CHAR,OBJECT_TYPE,p_OBJECT_TYPE),
209: OBJECT_ID = decode(p_OBJECT_ID,FND_API.G_MISS_NUM,OBJECT_ID,p_OBJECT_ID),

Line 275: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PERCENT_COMPLETES_PKG',

271: fnd_msg_pub.add;
272: end if;
273:
274: exception when others then
275: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PERCENT_COMPLETES_PKG',
276: p_procedure_name => 'UPDATE_ROW',
277: p_error_text => SUBSTRB(SQLERRM,1,240));
278: raise;
279: End UPDATE_ROW;

Line 284: DELETE FROM pa_percent_completes

280:
281: Procedure DELETE_ROW(
282: p_row_id VARCHAR2 ) IS
283: BEGIN
284: DELETE FROM pa_percent_completes
285: WHERE rowid = p_row_id;
286: END DELETE_ROW;
287:
288: end;