APPS.AMS_PROD_TEMP_RESP_PKG dependencies on AMS_TEMPL_RESPONSIBILITY

Line 22: from AMS_TEMPL_RESPONSIBILITY

18: l_db_luby_id number;
19:
20: cursor c_obj_verno is
21: select object_version_number
22: from AMS_TEMPL_RESPONSIBILITY
23: where TEMPL_RESPONSIBILITY_ID = X_TEMPL_RESPONSIBILITY_ID;
24:
25: cursor c_chk_temp_resp_exists is
26: select 'x'

Line 27: from AMS_TEMPL_RESPONSIBILITY

23: where TEMPL_RESPONSIBILITY_ID = X_TEMPL_RESPONSIBILITY_ID;
24:
25: cursor c_chk_temp_resp_exists is
26: select 'x'
27: from AMS_TEMPL_RESPONSIBILITY
28: where TEMPL_RESPONSIBILITY_ID = X_TEMPL_RESPONSIBILITY_ID;
29:
30: cursor c_get_temp_resp_id is
31: select AMS_TEMPL_RESPONSIBILITY_S.nextval

Line 31: select AMS_TEMPL_RESPONSIBILITY_S.nextval

27: from AMS_TEMPL_RESPONSIBILITY
28: where TEMPL_RESPONSIBILITY_ID = X_TEMPL_RESPONSIBILITY_ID;
29:
30: cursor c_get_temp_resp_id is
31: select AMS_TEMPL_RESPONSIBILITY_S.nextval
32: from dual;
33:
34: cursor c_db_data_details is
35: select last_updated_by, nvl(object_version_number,1)

Line 36: from AMS_TEMPL_RESPONSIBILITY

32: from dual;
33:
34: cursor c_db_data_details is
35: select last_updated_by, nvl(object_version_number,1)
36: from AMS_TEMPL_RESPONSIBILITY
37: where TEMPL_RESPONSIBILITY_ID = X_TEMPL_RESPONSIBILITY_ID;
38:
39: BEGIN
40:

Line 67: INSERT INTO AMS_TEMPL_RESPONSIBILITY(

63:
64: l_obj_verno := 1;
65:
66:
67: INSERT INTO AMS_TEMPL_RESPONSIBILITY(
68: TEMPL_RESPONSIBILITY_ID,
69: template_id,
70: RESPONSIBILITY_ID,
71: last_update_date,

Line 96: Update AMS_TEMPL_RESPONSIBILITY

92: fetch c_db_data_details into l_db_luby_id, l_obj_verno;
93: close c_db_data_details;
94: if (l_db_luby_id IN (1,2,0)
95: OR NVL(x_custom_mode,'PRESERVE') = 'FORCE') THEN
96: Update AMS_TEMPL_RESPONSIBILITY
97: SET last_update_date = sysdate,
98: last_updated_by = l_user_id,
99: object_version_number = l_obj_verno +1,
100: last_update_login = 0,