APPS.CS_SR_LINK_VALID_OBJ_PKG dependencies on CS_SR_LINK_VALID_OBJ

Line 1: PACKAGE BODY CS_SR_LINK_VALID_OBJ_PKG AS

1: PACKAGE BODY CS_SR_LINK_VALID_OBJ_PKG AS
2: /* $Header: cstlnvob.pls 115.2 2002/12/09 20:13:59 dejoseph noship $ */
3:
4: PROCEDURE INSERT_ROW (
5: PX_LINK_VALID_OBJ_ID IN OUT NOCOPY NUMBER,

Line 19: select cs_sr_link_valid_obj_s.nextval

15: P_SEEDED_FLAG IN VARCHAR2,
16: P_OBJECT_VERSION_NUMBER IN NUMBER )
17: IS
18: cursor c1 is
19: select cs_sr_link_valid_obj_s.nextval
20: from dual;
21: BEGIN
22:
23: if ( px_link_valid_obj_id IS NULL ) OR

Line 30: INSERT INTO CS_SR_LINK_VALID_OBJ (

26: fetch c1 into px_link_valid_obj_id;
27: close c1;
28: end if;
29:
30: INSERT INTO CS_SR_LINK_VALID_OBJ (
31: LINK_VALID_OBJ_ID, SUBJECT_TYPE, OBJECT_TYPE,
32: LINK_TYPE_ID, START_DATE_ACTIVE, END_DATE_ACTIVE,
33: CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE,
34: LAST_UPDATED_BY, LAST_UPDATE_LOGIN, APPLICATION_ID,

Line 51: from cs_sr_link_valid_obj

47: P_OBJECT_VERSION_NUMBER IN NUMBER )
48: IS
49: cursor c is
50: select 1
51: from cs_sr_link_valid_obj
52: where link_valid_obj_id = p_link_valid_obj_id
53: and object_version_number = p_object_version_number;
54:
55: l_dummy number(3);

Line 85: UPDATE CS_SR_LINK_VALID_OBJ SET

81: IS
82:
83: BEGIN
84:
85: UPDATE CS_SR_LINK_VALID_OBJ SET
86: SUBJECT_TYPE = P_SUBJECT_TYPE,
87: OBJECT_TYPE = P_OBJECT_TYPE,
88: LINK_TYPE_ID = P_LINK_TYPE_ID,
89: START_DATE_ACTIVE = P_START_DATE_ACTIVE,

Line 110: delete from cs_sr_link_valid_obj

106: PROCEDURE DELETE_ROW (
107: P_LINK_VALID_OBJ_ID in NUMBER )
108: IS
109: BEGIN
110: delete from cs_sr_link_valid_obj
111: where link_valid_obj_id = p_link_valid_obj_id;
112:
113: if (sql%notfound) then
114: raise no_data_found;

Line 175: END CS_SR_LINK_VALID_OBJ_PKG;

171: P_OBJECT_VERSION_NUMBER => p_object_version_number );
172:
173: END LOAD_ROW;
174:
175: END CS_SR_LINK_VALID_OBJ_PKG;