APPS.AMS_COND_STRUCT_RESTR_VAL_PKG dependencies on AMS_COND_STRUCT_RESTRICT_VALUE

Line 18: insert into AMS_COND_STRUCT_RESTRICT_VALUE (

14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER
16: ) is
17: begin
18: insert into AMS_COND_STRUCT_RESTRICT_VALUE (
19: COND_STRUCT_RESTRICT_ID,
20: QUERY_COND_DISP_STRUCT_ID,
21: CODE,
22: INCLUDED_FLAG,

Line 63: from AMS_COND_STRUCT_RESTRICT_VALUE

59: CODE,
60: INCLUDED_FLAG,
61: CODE_IND_FLAG,
62: OBJECT_VERSION_NUMBER
63: from AMS_COND_STRUCT_RESTRICT_VALUE
64: where COND_STRUCT_RESTRICT_ID = X_COND_STRUCT_RESTRICT_ID
65: for update of COND_STRUCT_RESTRICT_ID nowait;
66: begin
67:

Line 103: update AMS_COND_STRUCT_RESTRICT_VALUE set

99: X_LAST_UPDATED_BY in NUMBER,
100: X_LAST_UPDATE_LOGIN in NUMBER
101: ) is
102: begin
103: update AMS_COND_STRUCT_RESTRICT_VALUE set
104: QUERY_COND_DISP_STRUCT_ID = X_QUERY_COND_DISP_STRUCT_ID,
105: CODE = X_CODE,
106: INCLUDED_FLAG = X_INCLUDED_FLAG,
107: CODE_IND_FLAG = X_CODE_IND_FLAG,

Line 125: delete from AMS_COND_STRUCT_RESTRICT_VALUE

121: procedure DELETE_ROW (
122: X_COND_STRUCT_RESTRICT_ID in NUMBER
123: ) is
124: begin
125: delete from AMS_COND_STRUCT_RESTRICT_VALUE
126: where COND_STRUCT_RESTRICT_ID = X_COND_STRUCT_RESTRICT_ID;
127:
128: if (sql%notfound) then
129: raise no_data_found;

Line 153: FROM AMS_COND_STRUCT_RESTRICT_VALUE

149: l_db_luby_id number;
150:
151: CURSOR c_obj_verno IS
152: SELECT object_version_number, last_updated_by
153: FROM AMS_COND_STRUCT_RESTRICT_VALUE
154: WHERE COND_STRUCT_RESTRICT_ID = x_COND_STRUCT_RESTRICT_ID;
155:
156: CURSOR c_chk_exists is
157: SELECT 'x'

Line 158: FROM AMS_COND_STRUCT_RESTRICT_VALUE

154: WHERE COND_STRUCT_RESTRICT_ID = x_COND_STRUCT_RESTRICT_ID;
155:
156: CURSOR c_chk_exists is
157: SELECT 'x'
158: FROM AMS_COND_STRUCT_RESTRICT_VALUE
159: WHERE COND_STRUCT_RESTRICT_ID = x_COND_STRUCT_RESTRICT_ID;
160:
161: CURSOR c_get_id is
162: SELECT AMS_COND_STRUCT_RESTRICT_VAL_s.NEXTVAL