APPS.AMS_QUERY_PURP_ASSOC_PKG dependencies on AMS_QUERY_TEMP_PURPOSE_ASSOC

Line 16: insert into AMS_QUERY_TEMP_PURPOSE_ASSOC (

12: X_LAST_UPDATED_BY in NUMBER,
13: X_LAST_UPDATE_LOGIN in NUMBER
14: ) is
15: begin
16: insert into AMS_QUERY_TEMP_PURPOSE_ASSOC (
17: TEMP_PURPOSE_ASSOC_ID,
18: LAST_UPDATE_DATE,
19: LAST_UPDATED_BY,
20: CREATION_DATE,

Line 53: from AMS_QUERY_TEMP_PURPOSE_ASSOC

49: OBJECT_VERSION_NUMBER,
50: QUERY_TEMPLATE_ID,
51: PURPOSE_CODE,
52: TEMP_PURPOSE_ASSOC_ID
53: from AMS_QUERY_TEMP_PURPOSE_ASSOC
54: where TEMP_PURPOSE_ASSOC_ID = X_TEMP_PURPOSE_ASSOC_ID
55: for update of TEMP_PURPOSE_ASSOC_ID nowait;
56: begin
57: for Recinfo in c1 loop

Line 86: update AMS_QUERY_TEMP_PURPOSE_ASSOC set

82: X_LAST_UPDATED_BY in NUMBER,
83: X_LAST_UPDATE_LOGIN in NUMBER
84: ) is
85: begin
86: update AMS_QUERY_TEMP_PURPOSE_ASSOC set
87: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
88: REQUEST_ID = X_REQUEST_ID,
89: QUERY_TEMPLATE_ID = X_QUERY_TEMPLATE_ID,
90: PURPOSE_CODE = X_PURPOSE_CODE,

Line 107: delete from AMS_QUERY_TEMP_PURPOSE_ASSOC

103: procedure DELETE_ROW (
104: X_TEMP_PURPOSE_ASSOC_ID in NUMBER
105: ) is
106: begin
107: delete from AMS_QUERY_TEMP_PURPOSE_ASSOC
108: where TEMP_PURPOSE_ASSOC_ID = X_TEMP_PURPOSE_ASSOC_ID;
109:
110: if (sql%notfound) then
111: raise no_data_found;

Line 134: FROM AMS_QUERY_TEMP_PURPOSE_ASSOC

130: l_db_luby_id number;
131:
132: CURSOR c_obj_verno IS
133: SELECT object_version_number, last_updated_by
134: FROM AMS_QUERY_TEMP_PURPOSE_ASSOC
135: WHERE TEMP_PURPOSE_ASSOC_ID = x_TEMP_PURPOSE_ASSOC_ID;
136:
137: CURSOR c_chk_exists is
138: SELECT 'x'

Line 139: FROM AMS_QUERY_TEMP_PURPOSE_ASSOC

135: WHERE TEMP_PURPOSE_ASSOC_ID = x_TEMP_PURPOSE_ASSOC_ID;
136:
137: CURSOR c_chk_exists is
138: SELECT 'x'
139: FROM AMS_QUERY_TEMP_PURPOSE_ASSOC
140: WHERE TEMP_PURPOSE_ASSOC_ID = x_TEMP_PURPOSE_ASSOC_ID;
141:
142: CURSOR c_get_id is
143: SELECT AMS_QUERY_TEMP_PURPOSE_ASSOC_s.NEXTVAL

Line 143: SELECT AMS_QUERY_TEMP_PURPOSE_ASSOC_s.NEXTVAL

139: FROM AMS_QUERY_TEMP_PURPOSE_ASSOC
140: WHERE TEMP_PURPOSE_ASSOC_ID = x_TEMP_PURPOSE_ASSOC_ID;
141:
142: CURSOR c_get_id is
143: SELECT AMS_QUERY_TEMP_PURPOSE_ASSOC_s.NEXTVAL
144: FROM DUAL;
145: BEGIN
146: if X_OWNER = 'SEED' then
147: l_user_id := 1;