APPS.AMS_PROD_TEMPLATE_ATTR_PKG dependencies on AMS_PROD_TEMPLATE_ATTR

Line 1: package body AMS_PROD_TEMPLATE_ATTR_PKG as

1: package body AMS_PROD_TEMPLATE_ATTR_PKG as
2: /* $Header: amstptab.pls 115.5 2003/03/11 00:25:59 mukumar ship $ */
3:
4:
5: procedure LOAD_ROW(

Line 28: from ams_prod_template_attr

24:
25:
26: cursor c_obj_verno is
27: select object_version_number
28: from ams_prod_template_attr
29: where template_attribute_id = X_TEMPLATE_attribute_ID;
30:
31: cursor c_chk_temp_attr_exists is
32: select 'x'

Line 33: from ams_prod_template_attr

29: where template_attribute_id = X_TEMPLATE_attribute_ID;
30:
31: cursor c_chk_temp_attr_exists is
32: select 'x'
33: from ams_prod_template_attr
34: where template_attribute_id = X_TEMPLATE_attribute_ID;
35:
36: cursor c_get_temp_attr_id is
37: select ams_prod_template_attr_S.nextval

Line 37: select ams_prod_template_attr_S.nextval

33: from ams_prod_template_attr
34: where template_attribute_id = X_TEMPLATE_attribute_ID;
35:
36: cursor c_get_temp_attr_id is
37: select ams_prod_template_attr_S.nextval
38: from dual;
39:
40: cursor c_db_data_details is
41: select last_updated_by, nvl(object_version_number,1)

Line 42: from ams_prod_template_attr

38: from dual;
39:
40: cursor c_db_data_details is
41: select last_updated_by, nvl(object_version_number,1)
42: from ams_prod_template_attr
43: where template_attribute_id = X_TEMPLATE_attribute_ID;
44:
45:
46: BEGIN

Line 74: INSERT INTO ams_prod_template_attr(

70: end if;
71:
72: l_obj_verno := 1;
73:
74: INSERT INTO ams_prod_template_attr(
75: TEMPLATE_ATTRIBUTE_ID,
76: template_id,
77: last_update_date,
78: last_updated_by,

Line 117: Update ams_prod_template_attr

113: fetch c_db_data_details into l_db_luby_id, l_obj_verno;
114: close c_db_data_details;
115: if (l_db_luby_id IN (1,2,0)
116: OR NVL(x_custom_mode,'PRESERVE') = 'FORCE') THEN
117: Update ams_prod_template_attr
118: SET last_update_date = sysdate,
119: last_updated_by = l_user_id,
120: object_version_number = l_obj_verno +1,
121: last_update_login = 0,

Line 135: end AMS_PROD_TEMPLATE_ATTR_PKG;

131: end if;
132:
133: END LOAD_ROW;
134:
135: end AMS_PROD_TEMPLATE_ATTR_PKG;