APPS.AMW_OPINION_VALUE_CODES_PKG dependencies on AMW_OPINION_VALUE_CODES

Line 1: package body AMW_OPINION_VALUE_CODES_PKG as

1: package body AMW_OPINION_VALUE_CODES_PKG as
2: /*$Header: amwtopwb.pls 115.1 2003/10/30 03:08:10 qliu noship $*/
3: procedure INSERT_ROW (
4: X_OPINION_VALUE_CODE_ID in NUMBER,
5: X_OPINION_VALUE_CODE_NAME in VARCHAR2,

Line 17: insert into AMW_OPINION_VALUE_CODES (

13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: begin
17: insert into AMW_OPINION_VALUE_CODES (
18: OPINION_VALUE_CODE_ID,
19: OPINION_VALUE_CODE_NAME,
20: ATTACHMENT_ID,
21: IMAGE_FILE_NAME,

Line 55: update AMW_OPINION_VALUE_CODES set

51: X_LAST_UPDATED_BY in NUMBER,
52: X_LAST_UPDATE_LOGIN in NUMBER
53: ) is
54: begin
55: update AMW_OPINION_VALUE_CODES set
56: OPINION_VALUE_CODE_NAME = X_OPINION_VALUE_CODE_NAME,
57: ATTACHMENT_ID = X_ATTACHMENT_ID,
58: IMAGE_FILE_NAME = X_IMAGE_FILE_NAME,
59: SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,

Line 75: delete from AMW_OPINION_VALUE_CODES

71: procedure DELETE_ROW (
72: X_OPINION_VALUE_CODE_ID in NUMBER
73: ) is
74: begin
75: delete from AMW_OPINION_VALUE_CODES
76: where OPINION_VALUE_CODE_ID = X_OPINION_VALUE_CODE_ID;
77:
78: if (sql%notfound) then
79: raise no_data_found;

Line 106: from AMW_OPINION_VALUE_CODES

102: -- Translate char last_update_date to date
103: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
104:
105: select last_updated_by, last_update_date into db_luby, db_ludate
106: from AMW_OPINION_VALUE_CODES
107: where opinion_value_code_name = X_OPINION_VALUE_CODE_NAME;
108:
109: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))
110: then AMW_OPINION_VALUE_CODES_PKG.UPDATE_ROW(

Line 110: then AMW_OPINION_VALUE_CODES_PKG.UPDATE_ROW(

106: from AMW_OPINION_VALUE_CODES
107: where opinion_value_code_name = X_OPINION_VALUE_CODE_NAME;
108:
109: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))
110: then AMW_OPINION_VALUE_CODES_PKG.UPDATE_ROW(
111: X_OPINION_VALUE_CODE_ID => X_OPINION_VALUE_CODE_ID,
112: X_OPINION_VALUE_CODE_NAME => X_OPINION_VALUE_CODE_NAME,
113: X_ATTACHMENT_ID => X_ATTACHMENT_ID,
114: X_IMAGE_FILE_NAME => X_IMAGE_FILE_NAME,

Line 122: then AMW_OPINION_VALUE_CODES_PKG.INSERT_ROW(

118: X_LAST_UPDATED_BY => f_luby,
119: X_LAST_UPDATE_LOGIN => 0);
120: end if;
121: exception when NO_DATA_FOUND
122: then AMW_OPINION_VALUE_CODES_PKG.INSERT_ROW(
123: X_OPINION_VALUE_CODE_ID => X_OPINION_VALUE_CODE_ID,
124: X_OPINION_VALUE_CODE_NAME => X_OPINION_VALUE_CODE_NAME,
125: X_ATTACHMENT_ID => X_ATTACHMENT_ID,
126: X_IMAGE_FILE_NAME => X_IMAGE_FILE_NAME,

Line 136: end AMW_OPINION_VALUE_CODES_PKG;

132: X_LAST_UPDATED_BY => f_luby,
133: X_LAST_UPDATE_LOGIN => 0);
134: end LOAD_ROW;
135:
136: end AMW_OPINION_VALUE_CODES_PKG;