eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_GE_CHKLST_PKG dependencies on FND_API

Line 84: DECODE( px_checklist_item_id, FND_API.G_MISS_NUM, NULL, px_checklist_item_id),

80: last_updated_by,
81: last_update_date,
82: last_update_login
83: ) VALUES (
84: DECODE( px_checklist_item_id, FND_API.G_MISS_NUM, NULL, px_checklist_item_id),
85: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
86: DECODE( p_arc_used_by_entity_code, FND_API.g_miss_char, NULL, p_arc_used_by_entity_code),
87: DECODE( p_used_by_entity_id, FND_API.G_MISS_NUM, NULL, p_used_by_entity_id),
88: DECODE( p_sequence_num, FND_API.G_MISS_NUM, NULL, p_sequence_num),

Line 85: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),

81: last_update_date,
82: last_update_login
83: ) VALUES (
84: DECODE( px_checklist_item_id, FND_API.G_MISS_NUM, NULL, px_checklist_item_id),
85: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
86: DECODE( p_arc_used_by_entity_code, FND_API.g_miss_char, NULL, p_arc_used_by_entity_code),
87: DECODE( p_used_by_entity_id, FND_API.G_MISS_NUM, NULL, p_used_by_entity_id),
88: DECODE( p_sequence_num, FND_API.G_MISS_NUM, NULL, p_sequence_num),
89: DECODE( p_is_required_flag, FND_API.g_miss_char, NULL, p_is_required_flag),

Line 86: DECODE( p_arc_used_by_entity_code, FND_API.g_miss_char, NULL, p_arc_used_by_entity_code),

82: last_update_login
83: ) VALUES (
84: DECODE( px_checklist_item_id, FND_API.G_MISS_NUM, NULL, px_checklist_item_id),
85: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
86: DECODE( p_arc_used_by_entity_code, FND_API.g_miss_char, NULL, p_arc_used_by_entity_code),
87: DECODE( p_used_by_entity_id, FND_API.G_MISS_NUM, NULL, p_used_by_entity_id),
88: DECODE( p_sequence_num, FND_API.G_MISS_NUM, NULL, p_sequence_num),
89: DECODE( p_is_required_flag, FND_API.g_miss_char, NULL, p_is_required_flag),
90: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),

Line 87: DECODE( p_used_by_entity_id, FND_API.G_MISS_NUM, NULL, p_used_by_entity_id),

83: ) VALUES (
84: DECODE( px_checklist_item_id, FND_API.G_MISS_NUM, NULL, px_checklist_item_id),
85: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
86: DECODE( p_arc_used_by_entity_code, FND_API.g_miss_char, NULL, p_arc_used_by_entity_code),
87: DECODE( p_used_by_entity_id, FND_API.G_MISS_NUM, NULL, p_used_by_entity_id),
88: DECODE( p_sequence_num, FND_API.G_MISS_NUM, NULL, p_sequence_num),
89: DECODE( p_is_required_flag, FND_API.g_miss_char, NULL, p_is_required_flag),
90: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
91: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

Line 88: DECODE( p_sequence_num, FND_API.G_MISS_NUM, NULL, p_sequence_num),

84: DECODE( px_checklist_item_id, FND_API.G_MISS_NUM, NULL, px_checklist_item_id),
85: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
86: DECODE( p_arc_used_by_entity_code, FND_API.g_miss_char, NULL, p_arc_used_by_entity_code),
87: DECODE( p_used_by_entity_id, FND_API.G_MISS_NUM, NULL, p_used_by_entity_id),
88: DECODE( p_sequence_num, FND_API.G_MISS_NUM, NULL, p_sequence_num),
89: DECODE( p_is_required_flag, FND_API.g_miss_char, NULL, p_is_required_flag),
90: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
91: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
92: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

Line 89: DECODE( p_is_required_flag, FND_API.g_miss_char, NULL, p_is_required_flag),

85: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
86: DECODE( p_arc_used_by_entity_code, FND_API.g_miss_char, NULL, p_arc_used_by_entity_code),
87: DECODE( p_used_by_entity_id, FND_API.G_MISS_NUM, NULL, p_used_by_entity_id),
88: DECODE( p_sequence_num, FND_API.G_MISS_NUM, NULL, p_sequence_num),
89: DECODE( p_is_required_flag, FND_API.g_miss_char, NULL, p_is_required_flag),
90: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
91: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
92: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
93: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

Line 90: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),

86: DECODE( p_arc_used_by_entity_code, FND_API.g_miss_char, NULL, p_arc_used_by_entity_code),
87: DECODE( p_used_by_entity_id, FND_API.G_MISS_NUM, NULL, p_used_by_entity_id),
88: DECODE( p_sequence_num, FND_API.G_MISS_NUM, NULL, p_sequence_num),
89: DECODE( p_is_required_flag, FND_API.g_miss_char, NULL, p_is_required_flag),
90: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
91: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
92: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
93: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
94: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

Line 91: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

87: DECODE( p_used_by_entity_id, FND_API.G_MISS_NUM, NULL, p_used_by_entity_id),
88: DECODE( p_sequence_num, FND_API.G_MISS_NUM, NULL, p_sequence_num),
89: DECODE( p_is_required_flag, FND_API.g_miss_char, NULL, p_is_required_flag),
90: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
91: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
92: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
93: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
94: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
95: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));

Line 92: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

88: DECODE( p_sequence_num, FND_API.G_MISS_NUM, NULL, p_sequence_num),
89: DECODE( p_is_required_flag, FND_API.g_miss_char, NULL, p_is_required_flag),
90: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
91: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
92: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
93: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
94: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
95: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
96:

Line 93: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

89: DECODE( p_is_required_flag, FND_API.g_miss_char, NULL, p_is_required_flag),
90: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
91: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
92: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
93: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
94: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
95: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
96:
97: INSERT INTO pv_ge_chklst_items_tl(

Line 94: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

90: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
91: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
92: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
93: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
94: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
95: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
96:
97: INSERT INTO pv_ge_chklst_items_tl(
98: checklist_item_id ,

Line 95: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));

91: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
92: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
93: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
94: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
95: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
96:
97: INSERT INTO pv_ge_chklst_items_tl(
98: checklist_item_id ,
99: language ,

Line 109: DECODE( px_checklist_item_id, FND_API.G_MISS_NUM, NULL, px_checklist_item_id),

105: source_lang ,
106: checklist_item_name
107: )
108: SELECT
109: DECODE( px_checklist_item_id, FND_API.G_MISS_NUM, NULL, px_checklist_item_id),
110: l.language_code,
111: DECODE( p_last_update_date, NULL, SYSDATE, p_last_update_date),
112: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
113: DECODE( p_creation_date, NULL, SYSDATE, p_creation_date),

Line 117: DECODE( p_checklist_item_name , FND_API.G_MISS_CHAR, NULL, p_checklist_item_name)

113: DECODE( p_creation_date, NULL, SYSDATE, p_creation_date),
114: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
115: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
116: USERENV('LANG'),
117: DECODE( p_checklist_item_name , FND_API.G_MISS_CHAR, NULL, p_checklist_item_name)
118: FROM fnd_languages l
119: WHERE l.installed_flag IN ('I','B')
120: AND NOT EXISTS(SELECT NULL FROM pv_ge_chklst_items_tl t
121: WHERE t.checklist_item_id = DECODE( px_checklist_item_id, FND_API.G_MISS_NUM, NULL, px_checklist_item_id)

Line 121: WHERE t.checklist_item_id = DECODE( px_checklist_item_id, FND_API.G_MISS_NUM, NULL, px_checklist_item_id)

117: DECODE( p_checklist_item_name , FND_API.G_MISS_CHAR, NULL, p_checklist_item_name)
118: FROM fnd_languages l
119: WHERE l.installed_flag IN ('I','B')
120: AND NOT EXISTS(SELECT NULL FROM pv_ge_chklst_items_tl t
121: WHERE t.checklist_item_id = DECODE( px_checklist_item_id, FND_API.G_MISS_NUM, NULL, px_checklist_item_id)
122: AND t.language = l.language_code);
123: END Insert_Row;
124:
125:

Line 158: checklist_item_id = DECODE( p_checklist_item_id, null, checklist_item_id, FND_API.G_MISS_NUM, null, p_checklist_item_id),

154: IS
155: BEGIN
156: Update pv_ge_chklst_items_b
157: SET
158: checklist_item_id = DECODE( p_checklist_item_id, null, checklist_item_id, FND_API.G_MISS_NUM, null, p_checklist_item_id),
159: object_version_number = nvl(p_object_version_number,0) + 1 ,
160: arc_used_by_entity_code = DECODE( p_arc_used_by_entity_code, null, arc_used_by_entity_code, FND_API.g_miss_char, null, p_arc_used_by_entity_code),
161: used_by_entity_id = DECODE( p_used_by_entity_id, null, used_by_entity_id, FND_API.G_MISS_NUM, null, p_used_by_entity_id),
162: sequence_num = DECODE( p_sequence_num, null, sequence_num, FND_API.G_MISS_NUM, null, p_sequence_num),

Line 160: arc_used_by_entity_code = DECODE( p_arc_used_by_entity_code, null, arc_used_by_entity_code, FND_API.g_miss_char, null, p_arc_used_by_entity_code),

156: Update pv_ge_chklst_items_b
157: SET
158: checklist_item_id = DECODE( p_checklist_item_id, null, checklist_item_id, FND_API.G_MISS_NUM, null, p_checklist_item_id),
159: object_version_number = nvl(p_object_version_number,0) + 1 ,
160: arc_used_by_entity_code = DECODE( p_arc_used_by_entity_code, null, arc_used_by_entity_code, FND_API.g_miss_char, null, p_arc_used_by_entity_code),
161: used_by_entity_id = DECODE( p_used_by_entity_id, null, used_by_entity_id, FND_API.G_MISS_NUM, null, p_used_by_entity_id),
162: sequence_num = DECODE( p_sequence_num, null, sequence_num, FND_API.G_MISS_NUM, null, p_sequence_num),
163: is_required_flag = DECODE( p_is_required_flag, null, is_required_flag, FND_API.g_miss_char, null, p_is_required_flag),
164: enabled_flag = DECODE( p_enabled_flag, null, enabled_flag, FND_API.g_miss_char, null, p_enabled_flag),

Line 161: used_by_entity_id = DECODE( p_used_by_entity_id, null, used_by_entity_id, FND_API.G_MISS_NUM, null, p_used_by_entity_id),

157: SET
158: checklist_item_id = DECODE( p_checklist_item_id, null, checklist_item_id, FND_API.G_MISS_NUM, null, p_checklist_item_id),
159: object_version_number = nvl(p_object_version_number,0) + 1 ,
160: arc_used_by_entity_code = DECODE( p_arc_used_by_entity_code, null, arc_used_by_entity_code, FND_API.g_miss_char, null, p_arc_used_by_entity_code),
161: used_by_entity_id = DECODE( p_used_by_entity_id, null, used_by_entity_id, FND_API.G_MISS_NUM, null, p_used_by_entity_id),
162: sequence_num = DECODE( p_sequence_num, null, sequence_num, FND_API.G_MISS_NUM, null, p_sequence_num),
163: is_required_flag = DECODE( p_is_required_flag, null, is_required_flag, FND_API.g_miss_char, null, p_is_required_flag),
164: enabled_flag = DECODE( p_enabled_flag, null, enabled_flag, FND_API.g_miss_char, null, p_enabled_flag),
165: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

Line 162: sequence_num = DECODE( p_sequence_num, null, sequence_num, FND_API.G_MISS_NUM, null, p_sequence_num),

158: checklist_item_id = DECODE( p_checklist_item_id, null, checklist_item_id, FND_API.G_MISS_NUM, null, p_checklist_item_id),
159: object_version_number = nvl(p_object_version_number,0) + 1 ,
160: arc_used_by_entity_code = DECODE( p_arc_used_by_entity_code, null, arc_used_by_entity_code, FND_API.g_miss_char, null, p_arc_used_by_entity_code),
161: used_by_entity_id = DECODE( p_used_by_entity_id, null, used_by_entity_id, FND_API.G_MISS_NUM, null, p_used_by_entity_id),
162: sequence_num = DECODE( p_sequence_num, null, sequence_num, FND_API.G_MISS_NUM, null, p_sequence_num),
163: is_required_flag = DECODE( p_is_required_flag, null, is_required_flag, FND_API.g_miss_char, null, p_is_required_flag),
164: enabled_flag = DECODE( p_enabled_flag, null, enabled_flag, FND_API.g_miss_char, null, p_enabled_flag),
165: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
166: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

Line 163: is_required_flag = DECODE( p_is_required_flag, null, is_required_flag, FND_API.g_miss_char, null, p_is_required_flag),

159: object_version_number = nvl(p_object_version_number,0) + 1 ,
160: arc_used_by_entity_code = DECODE( p_arc_used_by_entity_code, null, arc_used_by_entity_code, FND_API.g_miss_char, null, p_arc_used_by_entity_code),
161: used_by_entity_id = DECODE( p_used_by_entity_id, null, used_by_entity_id, FND_API.G_MISS_NUM, null, p_used_by_entity_id),
162: sequence_num = DECODE( p_sequence_num, null, sequence_num, FND_API.G_MISS_NUM, null, p_sequence_num),
163: is_required_flag = DECODE( p_is_required_flag, null, is_required_flag, FND_API.g_miss_char, null, p_is_required_flag),
164: enabled_flag = DECODE( p_enabled_flag, null, enabled_flag, FND_API.g_miss_char, null, p_enabled_flag),
165: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
166: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
167: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)

Line 164: enabled_flag = DECODE( p_enabled_flag, null, enabled_flag, FND_API.g_miss_char, null, p_enabled_flag),

160: arc_used_by_entity_code = DECODE( p_arc_used_by_entity_code, null, arc_used_by_entity_code, FND_API.g_miss_char, null, p_arc_used_by_entity_code),
161: used_by_entity_id = DECODE( p_used_by_entity_id, null, used_by_entity_id, FND_API.G_MISS_NUM, null, p_used_by_entity_id),
162: sequence_num = DECODE( p_sequence_num, null, sequence_num, FND_API.G_MISS_NUM, null, p_sequence_num),
163: is_required_flag = DECODE( p_is_required_flag, null, is_required_flag, FND_API.g_miss_char, null, p_is_required_flag),
164: enabled_flag = DECODE( p_enabled_flag, null, enabled_flag, FND_API.g_miss_char, null, p_enabled_flag),
165: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
166: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
167: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
168: WHERE checklist_item_id = p_checklist_item_id;

Line 165: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

161: used_by_entity_id = DECODE( p_used_by_entity_id, null, used_by_entity_id, FND_API.G_MISS_NUM, null, p_used_by_entity_id),
162: sequence_num = DECODE( p_sequence_num, null, sequence_num, FND_API.G_MISS_NUM, null, p_sequence_num),
163: is_required_flag = DECODE( p_is_required_flag, null, is_required_flag, FND_API.g_miss_char, null, p_is_required_flag),
164: enabled_flag = DECODE( p_enabled_flag, null, enabled_flag, FND_API.g_miss_char, null, p_enabled_flag),
165: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
166: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
167: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
168: WHERE checklist_item_id = p_checklist_item_id;
169: --AND object_version_number = p_object_version_number;

Line 166: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

162: sequence_num = DECODE( p_sequence_num, null, sequence_num, FND_API.G_MISS_NUM, null, p_sequence_num),
163: is_required_flag = DECODE( p_is_required_flag, null, is_required_flag, FND_API.g_miss_char, null, p_is_required_flag),
164: enabled_flag = DECODE( p_enabled_flag, null, enabled_flag, FND_API.g_miss_char, null, p_enabled_flag),
165: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
166: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
167: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
168: WHERE checklist_item_id = p_checklist_item_id;
169: --AND object_version_number = p_object_version_number;
170:

Line 167: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)

163: is_required_flag = DECODE( p_is_required_flag, null, is_required_flag, FND_API.g_miss_char, null, p_is_required_flag),
164: enabled_flag = DECODE( p_enabled_flag, null, enabled_flag, FND_API.g_miss_char, null, p_enabled_flag),
165: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
166: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
167: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
168: WHERE checklist_item_id = p_checklist_item_id;
169: --AND object_version_number = p_object_version_number;
170:
171: UPDATE pv_ge_chklst_items_tl

Line 172: set checklist_item_name = DECODE( p_checklist_item_name, null, checklist_item_name, FND_API.g_miss_char, null, p_checklist_item_name),

168: WHERE checklist_item_id = p_checklist_item_id;
169: --AND object_version_number = p_object_version_number;
170:
171: UPDATE pv_ge_chklst_items_tl
172: set checklist_item_name = DECODE( p_checklist_item_name, null, checklist_item_name, FND_API.g_miss_char, null, p_checklist_item_name),
173: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
174: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
175: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
176: source_lang = USERENV('LANG')

Line 173: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

169: --AND object_version_number = p_object_version_number;
170:
171: UPDATE pv_ge_chklst_items_tl
172: set checklist_item_name = DECODE( p_checklist_item_name, null, checklist_item_name, FND_API.g_miss_char, null, p_checklist_item_name),
173: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
174: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
175: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
176: source_lang = USERENV('LANG')
177: WHERE checklist_item_id = p_checklist_item_id

Line 174: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

170:
171: UPDATE pv_ge_chklst_items_tl
172: set checklist_item_name = DECODE( p_checklist_item_name, null, checklist_item_name, FND_API.g_miss_char, null, p_checklist_item_name),
173: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
174: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
175: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
176: source_lang = USERENV('LANG')
177: WHERE checklist_item_id = p_checklist_item_id
178: AND USERENV('LANG') IN (language, source_lang);

Line 175: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

171: UPDATE pv_ge_chklst_items_tl
172: set checklist_item_name = DECODE( p_checklist_item_name, null, checklist_item_name, FND_API.g_miss_char, null, p_checklist_item_name),
173: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
174: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
175: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
176: source_lang = USERENV('LANG')
177: WHERE checklist_item_id = p_checklist_item_id
178: AND USERENV('LANG') IN (language, source_lang);
179:

Line 181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

177: WHERE checklist_item_id = p_checklist_item_id
178: AND USERENV('LANG') IN (language, source_lang);
179:
180: IF (SQL%NOTFOUND) THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: END IF;
183:
184:
185: END Update_Row;

Line 211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

207: DELETE FROM pv_ge_chklst_items_b
208: WHERE checklist_item_id = p_checklist_item_id
209: AND object_version_number = p_object_version_number;
210: If (SQL%NOTFOUND) then
211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: End If;
213: END Delete_Row ;
214:
215:

Line 249: RAISE FND_API.g_exc_error;

245: FETCH c INTO Recinfo;
246: IF (c%NOTFOUND) THEN
247: CLOSE c;
248: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
249: RAISE FND_API.g_exc_error;
250: END IF;
251: CLOSE c;
252: END Lock_Row;
253: