APPS.PA_OBJECT_DIST_LISTS_PKG dependencies on PA_OBJECT_DIST_LISTS

Line 1: PACKAGE BODY PA_OBJECT_DIST_LISTS_PKG AS

1: PACKAGE BODY PA_OBJECT_DIST_LISTS_PKG AS
2: /* $Header: PATODLHB.pls 115.1 2002/04/09 11:33:36 pkm ship $ */
3: procedure INSERT_ROW (
4: P_LIST_ID in NUMBER,
5: P_OBJECT_TYPE in VARCHAR2,

Line 16: FROM PA_OBJECT_DIST_LISTS

12: P_LAST_UPDATE_LOGIN in NUMBER
13: ) IS
14: CURSOR c1 IS
15: SELECT rowid
16: FROM PA_OBJECT_DIST_LISTS
17: WHERE list_id = p_list_id
18: AND object_type = p_object_type
19: AND object_id = p_object_id;
20: l_row_id ROWID;

Line 22: Insert into PA_OBJECT_DIST_LISTS (

18: AND object_type = p_object_type
19: AND object_id = p_object_id;
20: l_row_id ROWID;
21: BEGIN
22: Insert into PA_OBJECT_DIST_LISTS (
23: LIST_ID ,
24: object_type ,
25: object_id ,
26: RECORD_VERSION_NUMBER ,

Line 68: UPDATE PA_OBJECT_DIST_LISTS

64: P_LAST_UPDATE_DATE in DATE,
65: P_LAST_UPDATE_LOGIN in NUMBER
66: ) IS
67: BEGIN
68: UPDATE PA_OBJECT_DIST_LISTS
69: SET
70: RECORD_VERSION_NUMBER = nvl(P_RECORD_VERSION_NUMBER,1) + 1,
71: LAST_UPDATED_BY = P_LAST_UPDATED_BY,
72: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,

Line 89: DELETE FROM PA_OBJECT_DIST_LISTS

85: P_OBJECT_ID in NUMBER
86: )
87: IS
88: BEGIN
89: DELETE FROM PA_OBJECT_DIST_LISTS
90: WHERE LIST_ID = P_LIST_ID
91: AND OBJECT_TYPE = P_OBJECT_TYPE
92: AND OBJECT_ID = P_OBJECT_ID;
93:

Line 99: END PA_OBJECT_DIST_LISTS_PKG;

95: WHEN OTHERS THEN
96: RAISE;
97: END DELETE_ROW;
98:
99: END PA_OBJECT_DIST_LISTS_PKG;