APPS.AMW_OBJECT_OPINION_TYPES_PKG dependencies on AMW_OBJECT_OPINION_TYPES

Line 1: package body AMW_OBJECT_OPINION_TYPES_PKG as

1: package body AMW_OBJECT_OPINION_TYPES_PKG as
2: /*$Header: amwtopob.pls 115.3 2003/11/04 01:21:33 cpetriuc noship $*/
3:
4: procedure INSERT_ROW (
5: X_OBJECT_OPINION_TYPE_ID in NUMBER,

Line 19: insert into AMW_OBJECT_OPINION_TYPES (

15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18: begin
19: insert into AMW_OBJECT_OPINION_TYPES (
20: OBJECT_OPINION_TYPE_ID,
21: OBJECT_ID,
22: OPINION_TYPE_ID,
23: VIEW_FUNCTION_ID,

Line 61: update AMW_OBJECT_OPINION_TYPES set

57: X_LAST_UPDATED_BY in NUMBER,
58: X_LAST_UPDATE_LOGIN in NUMBER
59: ) is
60: begin
61: update AMW_OBJECT_OPINION_TYPES set
62: OBJECT_ID = X_OBJECT_ID,
63: OPINION_TYPE_ID = X_OPINION_TYPE_ID,
64: VIEW_FUNCTION_ID = X_VIEW_FUNCTION_ID,
65: PERFORM_FUNCTION_ID = X_PERFORM_FUNCTION_ID,

Line 82: delete from AMW_OBJECT_OPINION_TYPES

78: procedure DELETE_ROW (
79: X_OBJECT_OPINION_TYPE_ID in NUMBER
80: ) is
81: begin
82: delete from AMW_OBJECT_OPINION_TYPES
83: where OBJECT_OPINION_TYPE_ID = X_OBJECT_OPINION_TYPE_ID;
84:
85: if (sql%notfound) then
86: raise no_data_found;

Line 119: from AMW_OBJECT_OPINION_TYPES aoot

115: from FND_OBJECTS
116: where obj_name = X_OBJECT_NAME;
117:
118: select aoot.last_updated_by, aoot.last_update_date into db_luby, db_ludate
119: from AMW_OBJECT_OPINION_TYPES aoot
120: where object_opinion_type_id = X_OBJECT_OPINION_TYPE_ID;
121:
122: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))
123: then AMW_OBJECT_OPINION_TYPES_PKG.UPDATE_ROW(

Line 123: then AMW_OBJECT_OPINION_TYPES_PKG.UPDATE_ROW(

119: from AMW_OBJECT_OPINION_TYPES aoot
120: where object_opinion_type_id = X_OBJECT_OPINION_TYPE_ID;
121:
122: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))
123: then AMW_OBJECT_OPINION_TYPES_PKG.UPDATE_ROW(
124: X_OBJECT_OPINION_TYPE_ID => X_OBJECT_OPINION_TYPE_ID,
125: X_OBJECT_ID => oid,
126: X_OPINION_TYPE_ID => X_OPINION_TYPE_ID,
127: X_VIEW_FUNCTION_ID => X_VIEW_FUNCTION_ID,

Line 136: then AMW_OBJECT_OPINION_TYPES_PKG.INSERT_ROW(

132: X_LAST_UPDATED_BY => f_luby,
133: X_LAST_UPDATE_LOGIN => 0);
134: end if;
135: exception when NO_DATA_FOUND
136: then AMW_OBJECT_OPINION_TYPES_PKG.INSERT_ROW(
137: X_OBJECT_OPINION_TYPE_ID => X_OBJECT_OPINION_TYPE_ID,
138: X_OBJECT_ID => oid,
139: X_OPINION_TYPE_ID => X_OPINION_TYPE_ID,
140: X_VIEW_FUNCTION_ID => X_VIEW_FUNCTION_ID,

Line 151: end AMW_OBJECT_OPINION_TYPES_PKG;

147: X_LAST_UPDATED_BY => f_luby,
148: X_LAST_UPDATE_LOGIN => 0);
149: end LOAD_ROW;
150:
151: end AMW_OBJECT_OPINION_TYPES_PKG;