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_GQ_ELEMENTS_PKG dependencies on FND_API

Line 86: DECODE( px_qsnr_element_id, FND_API.G_MISS_NUM, NULL, px_qsnr_element_id),

82: last_updated_by,
83: last_update_date,
84: last_update_login
85: ) VALUES (
86: DECODE( px_qsnr_element_id, FND_API.G_MISS_NUM, NULL, px_qsnr_element_id),
87: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
88: DECODE( p_arc_used_by_entity_code, FND_API.g_miss_char, NULL, p_arc_used_by_entity_code),
89: DECODE( p_used_by_entity_id, FND_API.G_MISS_NUM, NULL, p_used_by_entity_id),
90: DECODE( p_qsnr_elmt_seq_num, FND_API.G_MISS_NUM, NULL, p_qsnr_elmt_seq_num),

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

83: last_update_date,
84: last_update_login
85: ) VALUES (
86: DECODE( px_qsnr_element_id, FND_API.G_MISS_NUM, NULL, px_qsnr_element_id),
87: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
88: DECODE( p_arc_used_by_entity_code, FND_API.g_miss_char, NULL, p_arc_used_by_entity_code),
89: DECODE( p_used_by_entity_id, FND_API.G_MISS_NUM, NULL, p_used_by_entity_id),
90: DECODE( p_qsnr_elmt_seq_num, FND_API.G_MISS_NUM, NULL, p_qsnr_elmt_seq_num),
91: DECODE( p_qsnr_elmt_type, FND_API.g_miss_char, NULL, p_qsnr_elmt_type),

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

84: last_update_login
85: ) VALUES (
86: DECODE( px_qsnr_element_id, FND_API.G_MISS_NUM, NULL, px_qsnr_element_id),
87: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
88: DECODE( p_arc_used_by_entity_code, FND_API.g_miss_char, NULL, p_arc_used_by_entity_code),
89: DECODE( p_used_by_entity_id, FND_API.G_MISS_NUM, NULL, p_used_by_entity_id),
90: DECODE( p_qsnr_elmt_seq_num, FND_API.G_MISS_NUM, NULL, p_qsnr_elmt_seq_num),
91: DECODE( p_qsnr_elmt_type, FND_API.g_miss_char, NULL, p_qsnr_elmt_type),
92: DECODE( p_entity_attr_id, FND_API.G_MISS_NUM, NULL, p_entity_attr_id),

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

85: ) VALUES (
86: DECODE( px_qsnr_element_id, FND_API.G_MISS_NUM, NULL, px_qsnr_element_id),
87: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
88: DECODE( p_arc_used_by_entity_code, FND_API.g_miss_char, NULL, p_arc_used_by_entity_code),
89: DECODE( p_used_by_entity_id, FND_API.G_MISS_NUM, NULL, p_used_by_entity_id),
90: DECODE( p_qsnr_elmt_seq_num, FND_API.G_MISS_NUM, NULL, p_qsnr_elmt_seq_num),
91: DECODE( p_qsnr_elmt_type, FND_API.g_miss_char, NULL, p_qsnr_elmt_type),
92: DECODE( p_entity_attr_id, FND_API.G_MISS_NUM, NULL, p_entity_attr_id),
93: DECODE( p_qsnr_elmt_page_num, FND_API.G_MISS_NUM, NULL, p_qsnr_elmt_page_num),

Line 90: DECODE( p_qsnr_elmt_seq_num, FND_API.G_MISS_NUM, NULL, p_qsnr_elmt_seq_num),

86: DECODE( px_qsnr_element_id, FND_API.G_MISS_NUM, NULL, px_qsnr_element_id),
87: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
88: DECODE( p_arc_used_by_entity_code, FND_API.g_miss_char, NULL, p_arc_used_by_entity_code),
89: DECODE( p_used_by_entity_id, FND_API.G_MISS_NUM, NULL, p_used_by_entity_id),
90: DECODE( p_qsnr_elmt_seq_num, FND_API.G_MISS_NUM, NULL, p_qsnr_elmt_seq_num),
91: DECODE( p_qsnr_elmt_type, FND_API.g_miss_char, NULL, p_qsnr_elmt_type),
92: DECODE( p_entity_attr_id, FND_API.G_MISS_NUM, NULL, p_entity_attr_id),
93: DECODE( p_qsnr_elmt_page_num, FND_API.G_MISS_NUM, NULL, p_qsnr_elmt_page_num),
94: DECODE( p_is_required_flag, FND_API.g_miss_char, NULL, p_is_required_flag),

Line 91: DECODE( p_qsnr_elmt_type, FND_API.g_miss_char, NULL, p_qsnr_elmt_type),

87: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
88: DECODE( p_arc_used_by_entity_code, FND_API.g_miss_char, NULL, p_arc_used_by_entity_code),
89: DECODE( p_used_by_entity_id, FND_API.G_MISS_NUM, NULL, p_used_by_entity_id),
90: DECODE( p_qsnr_elmt_seq_num, FND_API.G_MISS_NUM, NULL, p_qsnr_elmt_seq_num),
91: DECODE( p_qsnr_elmt_type, FND_API.g_miss_char, NULL, p_qsnr_elmt_type),
92: DECODE( p_entity_attr_id, FND_API.G_MISS_NUM, NULL, p_entity_attr_id),
93: DECODE( p_qsnr_elmt_page_num, FND_API.G_MISS_NUM, NULL, p_qsnr_elmt_page_num),
94: DECODE( p_is_required_flag, FND_API.g_miss_char, NULL, p_is_required_flag),
95: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

Line 92: DECODE( p_entity_attr_id, FND_API.G_MISS_NUM, NULL, p_entity_attr_id),

88: DECODE( p_arc_used_by_entity_code, FND_API.g_miss_char, NULL, p_arc_used_by_entity_code),
89: DECODE( p_used_by_entity_id, FND_API.G_MISS_NUM, NULL, p_used_by_entity_id),
90: DECODE( p_qsnr_elmt_seq_num, FND_API.G_MISS_NUM, NULL, p_qsnr_elmt_seq_num),
91: DECODE( p_qsnr_elmt_type, FND_API.g_miss_char, NULL, p_qsnr_elmt_type),
92: DECODE( p_entity_attr_id, FND_API.G_MISS_NUM, NULL, p_entity_attr_id),
93: DECODE( p_qsnr_elmt_page_num, FND_API.G_MISS_NUM, NULL, p_qsnr_elmt_page_num),
94: DECODE( p_is_required_flag, FND_API.g_miss_char, NULL, p_is_required_flag),
95: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
96: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

Line 93: DECODE( p_qsnr_elmt_page_num, FND_API.G_MISS_NUM, NULL, p_qsnr_elmt_page_num),

89: DECODE( p_used_by_entity_id, FND_API.G_MISS_NUM, NULL, p_used_by_entity_id),
90: DECODE( p_qsnr_elmt_seq_num, FND_API.G_MISS_NUM, NULL, p_qsnr_elmt_seq_num),
91: DECODE( p_qsnr_elmt_type, FND_API.g_miss_char, NULL, p_qsnr_elmt_type),
92: DECODE( p_entity_attr_id, FND_API.G_MISS_NUM, NULL, p_entity_attr_id),
93: DECODE( p_qsnr_elmt_page_num, FND_API.G_MISS_NUM, NULL, p_qsnr_elmt_page_num),
94: DECODE( p_is_required_flag, FND_API.g_miss_char, NULL, p_is_required_flag),
95: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
96: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
97: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

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

90: DECODE( p_qsnr_elmt_seq_num, FND_API.G_MISS_NUM, NULL, p_qsnr_elmt_seq_num),
91: DECODE( p_qsnr_elmt_type, FND_API.g_miss_char, NULL, p_qsnr_elmt_type),
92: DECODE( p_entity_attr_id, FND_API.G_MISS_NUM, NULL, p_entity_attr_id),
93: DECODE( p_qsnr_elmt_page_num, FND_API.G_MISS_NUM, NULL, p_qsnr_elmt_page_num),
94: DECODE( p_is_required_flag, FND_API.g_miss_char, NULL, p_is_required_flag),
95: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
96: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
97: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
98: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

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

91: DECODE( p_qsnr_elmt_type, FND_API.g_miss_char, NULL, p_qsnr_elmt_type),
92: DECODE( p_entity_attr_id, FND_API.G_MISS_NUM, NULL, p_entity_attr_id),
93: DECODE( p_qsnr_elmt_page_num, FND_API.G_MISS_NUM, NULL, p_qsnr_elmt_page_num),
94: DECODE( p_is_required_flag, FND_API.g_miss_char, NULL, p_is_required_flag),
95: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
96: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
97: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
98: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
99: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));

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

92: DECODE( p_entity_attr_id, FND_API.G_MISS_NUM, NULL, p_entity_attr_id),
93: DECODE( p_qsnr_elmt_page_num, FND_API.G_MISS_NUM, NULL, p_qsnr_elmt_page_num),
94: DECODE( p_is_required_flag, FND_API.g_miss_char, NULL, p_is_required_flag),
95: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
96: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
97: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
98: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
99: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
100:

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

93: DECODE( p_qsnr_elmt_page_num, FND_API.G_MISS_NUM, NULL, p_qsnr_elmt_page_num),
94: DECODE( p_is_required_flag, FND_API.g_miss_char, NULL, p_is_required_flag),
95: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
96: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
97: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
98: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
99: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
100:
101: INSERT INTO pv_ge_qsnr_elements_tl(

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

94: DECODE( p_is_required_flag, FND_API.g_miss_char, NULL, p_is_required_flag),
95: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
96: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
97: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
98: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
99: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
100:
101: INSERT INTO pv_ge_qsnr_elements_tl(
102: qsnr_element_id ,

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

95: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
96: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
97: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
98: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
99: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
100:
101: INSERT INTO pv_ge_qsnr_elements_tl(
102: qsnr_element_id ,
103: --object_version_number,

Line 114: DECODE( px_qsnr_element_id, FND_API.G_MISS_NUM, NULL, px_qsnr_element_id),

110: source_lang ,
111: elmt_content
112: )
113: SELECT
114: DECODE( px_qsnr_element_id, FND_API.G_MISS_NUM, NULL, px_qsnr_element_id),
115: --DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
116: l.language_code,
117: DECODE( p_last_update_date, NULL, SYSDATE, p_last_update_date),
118: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),

Line 115: --DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),

111: elmt_content
112: )
113: SELECT
114: DECODE( px_qsnr_element_id, FND_API.G_MISS_NUM, NULL, px_qsnr_element_id),
115: --DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
116: l.language_code,
117: DECODE( p_last_update_date, NULL, SYSDATE, p_last_update_date),
118: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
119: DECODE( p_creation_date, NULL, SYSDATE, p_creation_date),

Line 123: DECODE( p_elmt_content, FND_API.G_MISS_CHAR, NULL, p_elmt_content)

119: DECODE( p_creation_date, NULL, SYSDATE, p_creation_date),
120: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
121: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
122: USERENV('LANG'),
123: DECODE( p_elmt_content, FND_API.G_MISS_CHAR, NULL, p_elmt_content)
124: FROM fnd_languages l
125: WHERE l.installed_flag IN ('I','B')
126: AND NOT EXISTS(SELECT NULL FROM pv_ge_qsnr_elements_tl t
127: WHERE t.qsnr_element_id = DECODE( px_qsnr_element_id, FND_API.G_MISS_NUM, NULL, px_qsnr_element_id)

Line 127: WHERE t.qsnr_element_id = DECODE( px_qsnr_element_id, FND_API.G_MISS_NUM, NULL, px_qsnr_element_id)

123: DECODE( p_elmt_content, FND_API.G_MISS_CHAR, NULL, p_elmt_content)
124: FROM fnd_languages l
125: WHERE l.installed_flag IN ('I','B')
126: AND NOT EXISTS(SELECT NULL FROM pv_ge_qsnr_elements_tl t
127: WHERE t.qsnr_element_id = DECODE( px_qsnr_element_id, FND_API.G_MISS_NUM, NULL, px_qsnr_element_id)
128: AND t.language = l.language_code);
129: END Insert_Row;
130:
131:

Line 166: qsnr_element_id = DECODE( p_qsnr_element_id, null, qsnr_element_id, FND_API.G_MISS_NUM, null, p_qsnr_element_id),

162: IS
163: BEGIN
164: Update pv_ge_qsnr_elements_b
165: SET
166: qsnr_element_id = DECODE( p_qsnr_element_id, null, qsnr_element_id, FND_API.G_MISS_NUM, null, p_qsnr_element_id),
167: --object_version_number = object_version_number + 1 ,
168: object_version_number = DECODE( px_object_version_number, NULL, object_version_number, FND_API.g_miss_num, NULL, px_object_version_number+1),
169: 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),
170: 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),

Line 168: object_version_number = DECODE( px_object_version_number, NULL, object_version_number, FND_API.g_miss_num, NULL, px_object_version_number+1),

164: Update pv_ge_qsnr_elements_b
165: SET
166: qsnr_element_id = DECODE( p_qsnr_element_id, null, qsnr_element_id, FND_API.G_MISS_NUM, null, p_qsnr_element_id),
167: --object_version_number = object_version_number + 1 ,
168: object_version_number = DECODE( px_object_version_number, NULL, object_version_number, FND_API.g_miss_num, NULL, px_object_version_number+1),
169: 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),
170: 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),
171: qsnr_elmt_seq_num = DECODE( p_qsnr_elmt_seq_num, null, qsnr_elmt_seq_num, FND_API.G_MISS_NUM, null, p_qsnr_elmt_seq_num),
172: qsnr_elmt_type = DECODE( p_qsnr_elmt_type, null, qsnr_elmt_type, FND_API.g_miss_char, null, p_qsnr_elmt_type),

Line 169: 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),

165: SET
166: qsnr_element_id = DECODE( p_qsnr_element_id, null, qsnr_element_id, FND_API.G_MISS_NUM, null, p_qsnr_element_id),
167: --object_version_number = object_version_number + 1 ,
168: object_version_number = DECODE( px_object_version_number, NULL, object_version_number, FND_API.g_miss_num, NULL, px_object_version_number+1),
169: 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),
170: 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),
171: qsnr_elmt_seq_num = DECODE( p_qsnr_elmt_seq_num, null, qsnr_elmt_seq_num, FND_API.G_MISS_NUM, null, p_qsnr_elmt_seq_num),
172: qsnr_elmt_type = DECODE( p_qsnr_elmt_type, null, qsnr_elmt_type, FND_API.g_miss_char, null, p_qsnr_elmt_type),
173: entity_attr_id = DECODE( p_entity_attr_id, null, entity_attr_id, FND_API.G_MISS_NUM, null, p_entity_attr_id),

Line 170: 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),

166: qsnr_element_id = DECODE( p_qsnr_element_id, null, qsnr_element_id, FND_API.G_MISS_NUM, null, p_qsnr_element_id),
167: --object_version_number = object_version_number + 1 ,
168: object_version_number = DECODE( px_object_version_number, NULL, object_version_number, FND_API.g_miss_num, NULL, px_object_version_number+1),
169: 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),
170: 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),
171: qsnr_elmt_seq_num = DECODE( p_qsnr_elmt_seq_num, null, qsnr_elmt_seq_num, FND_API.G_MISS_NUM, null, p_qsnr_elmt_seq_num),
172: qsnr_elmt_type = DECODE( p_qsnr_elmt_type, null, qsnr_elmt_type, FND_API.g_miss_char, null, p_qsnr_elmt_type),
173: entity_attr_id = DECODE( p_entity_attr_id, null, entity_attr_id, FND_API.G_MISS_NUM, null, p_entity_attr_id),
174: qsnr_elmt_page_num = DECODE( p_qsnr_elmt_page_num, null, qsnr_elmt_page_num, FND_API.G_MISS_NUM, null, p_qsnr_elmt_page_num),

Line 171: qsnr_elmt_seq_num = DECODE( p_qsnr_elmt_seq_num, null, qsnr_elmt_seq_num, FND_API.G_MISS_NUM, null, p_qsnr_elmt_seq_num),

167: --object_version_number = object_version_number + 1 ,
168: object_version_number = DECODE( px_object_version_number, NULL, object_version_number, FND_API.g_miss_num, NULL, px_object_version_number+1),
169: 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),
170: 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),
171: qsnr_elmt_seq_num = DECODE( p_qsnr_elmt_seq_num, null, qsnr_elmt_seq_num, FND_API.G_MISS_NUM, null, p_qsnr_elmt_seq_num),
172: qsnr_elmt_type = DECODE( p_qsnr_elmt_type, null, qsnr_elmt_type, FND_API.g_miss_char, null, p_qsnr_elmt_type),
173: entity_attr_id = DECODE( p_entity_attr_id, null, entity_attr_id, FND_API.G_MISS_NUM, null, p_entity_attr_id),
174: qsnr_elmt_page_num = DECODE( p_qsnr_elmt_page_num, null, qsnr_elmt_page_num, FND_API.G_MISS_NUM, null, p_qsnr_elmt_page_num),
175: is_required_flag = DECODE( p_is_required_flag, null, is_required_flag, FND_API.g_miss_char, null, p_is_required_flag),

Line 172: qsnr_elmt_type = DECODE( p_qsnr_elmt_type, null, qsnr_elmt_type, FND_API.g_miss_char, null, p_qsnr_elmt_type),

168: object_version_number = DECODE( px_object_version_number, NULL, object_version_number, FND_API.g_miss_num, NULL, px_object_version_number+1),
169: 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),
170: 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),
171: qsnr_elmt_seq_num = DECODE( p_qsnr_elmt_seq_num, null, qsnr_elmt_seq_num, FND_API.G_MISS_NUM, null, p_qsnr_elmt_seq_num),
172: qsnr_elmt_type = DECODE( p_qsnr_elmt_type, null, qsnr_elmt_type, FND_API.g_miss_char, null, p_qsnr_elmt_type),
173: entity_attr_id = DECODE( p_entity_attr_id, null, entity_attr_id, FND_API.G_MISS_NUM, null, p_entity_attr_id),
174: qsnr_elmt_page_num = DECODE( p_qsnr_elmt_page_num, null, qsnr_elmt_page_num, FND_API.G_MISS_NUM, null, p_qsnr_elmt_page_num),
175: is_required_flag = DECODE( p_is_required_flag, null, is_required_flag, FND_API.g_miss_char, null, p_is_required_flag),
176: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

Line 173: entity_attr_id = DECODE( p_entity_attr_id, null, entity_attr_id, FND_API.G_MISS_NUM, null, p_entity_attr_id),

169: 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),
170: 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),
171: qsnr_elmt_seq_num = DECODE( p_qsnr_elmt_seq_num, null, qsnr_elmt_seq_num, FND_API.G_MISS_NUM, null, p_qsnr_elmt_seq_num),
172: qsnr_elmt_type = DECODE( p_qsnr_elmt_type, null, qsnr_elmt_type, FND_API.g_miss_char, null, p_qsnr_elmt_type),
173: entity_attr_id = DECODE( p_entity_attr_id, null, entity_attr_id, FND_API.G_MISS_NUM, null, p_entity_attr_id),
174: qsnr_elmt_page_num = DECODE( p_qsnr_elmt_page_num, null, qsnr_elmt_page_num, FND_API.G_MISS_NUM, null, p_qsnr_elmt_page_num),
175: is_required_flag = DECODE( p_is_required_flag, null, is_required_flag, FND_API.g_miss_char, null, p_is_required_flag),
176: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
177: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

Line 174: qsnr_elmt_page_num = DECODE( p_qsnr_elmt_page_num, null, qsnr_elmt_page_num, FND_API.G_MISS_NUM, null, p_qsnr_elmt_page_num),

170: 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),
171: qsnr_elmt_seq_num = DECODE( p_qsnr_elmt_seq_num, null, qsnr_elmt_seq_num, FND_API.G_MISS_NUM, null, p_qsnr_elmt_seq_num),
172: qsnr_elmt_type = DECODE( p_qsnr_elmt_type, null, qsnr_elmt_type, FND_API.g_miss_char, null, p_qsnr_elmt_type),
173: entity_attr_id = DECODE( p_entity_attr_id, null, entity_attr_id, FND_API.G_MISS_NUM, null, p_entity_attr_id),
174: qsnr_elmt_page_num = DECODE( p_qsnr_elmt_page_num, null, qsnr_elmt_page_num, FND_API.G_MISS_NUM, null, p_qsnr_elmt_page_num),
175: is_required_flag = DECODE( p_is_required_flag, null, is_required_flag, FND_API.g_miss_char, null, p_is_required_flag),
176: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
177: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
178: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)

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

171: qsnr_elmt_seq_num = DECODE( p_qsnr_elmt_seq_num, null, qsnr_elmt_seq_num, FND_API.G_MISS_NUM, null, p_qsnr_elmt_seq_num),
172: qsnr_elmt_type = DECODE( p_qsnr_elmt_type, null, qsnr_elmt_type, FND_API.g_miss_char, null, p_qsnr_elmt_type),
173: entity_attr_id = DECODE( p_entity_attr_id, null, entity_attr_id, FND_API.G_MISS_NUM, null, p_entity_attr_id),
174: qsnr_elmt_page_num = DECODE( p_qsnr_elmt_page_num, null, qsnr_elmt_page_num, FND_API.G_MISS_NUM, null, p_qsnr_elmt_page_num),
175: is_required_flag = DECODE( p_is_required_flag, null, is_required_flag, FND_API.g_miss_char, null, p_is_required_flag),
176: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
177: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
178: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
179: WHERE qsnr_element_id = p_qsnr_element_id

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

172: qsnr_elmt_type = DECODE( p_qsnr_elmt_type, null, qsnr_elmt_type, FND_API.g_miss_char, null, p_qsnr_elmt_type),
173: entity_attr_id = DECODE( p_entity_attr_id, null, entity_attr_id, FND_API.G_MISS_NUM, null, p_entity_attr_id),
174: qsnr_elmt_page_num = DECODE( p_qsnr_elmt_page_num, null, qsnr_elmt_page_num, FND_API.G_MISS_NUM, null, p_qsnr_elmt_page_num),
175: is_required_flag = DECODE( p_is_required_flag, null, is_required_flag, FND_API.g_miss_char, null, p_is_required_flag),
176: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
177: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
178: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
179: WHERE qsnr_element_id = p_qsnr_element_id
180: AND object_version_number = px_object_version_number;

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

173: entity_attr_id = DECODE( p_entity_attr_id, null, entity_attr_id, FND_API.G_MISS_NUM, null, p_entity_attr_id),
174: qsnr_elmt_page_num = DECODE( p_qsnr_elmt_page_num, null, qsnr_elmt_page_num, FND_API.G_MISS_NUM, null, p_qsnr_elmt_page_num),
175: is_required_flag = DECODE( p_is_required_flag, null, is_required_flag, FND_API.g_miss_char, null, p_is_required_flag),
176: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
177: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
178: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
179: WHERE qsnr_element_id = p_qsnr_element_id
180: AND object_version_number = px_object_version_number;
181:

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

174: qsnr_elmt_page_num = DECODE( p_qsnr_elmt_page_num, null, qsnr_elmt_page_num, FND_API.G_MISS_NUM, null, p_qsnr_elmt_page_num),
175: is_required_flag = DECODE( p_is_required_flag, null, is_required_flag, FND_API.g_miss_char, null, p_is_required_flag),
176: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
177: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
178: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
179: WHERE qsnr_element_id = p_qsnr_element_id
180: AND object_version_number = px_object_version_number;
181:
182: UPDATE pv_ge_qsnr_elements_tl

Line 183: set elmt_content = DECODE( p_elmt_content, null, elmt_content, FND_API.g_miss_char, null, p_elmt_content),

179: WHERE qsnr_element_id = p_qsnr_element_id
180: AND object_version_number = px_object_version_number;
181:
182: UPDATE pv_ge_qsnr_elements_tl
183: set elmt_content = DECODE( p_elmt_content, null, elmt_content, FND_API.g_miss_char, null, p_elmt_content),
184: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
185: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
186: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
187: source_lang = USERENV('LANG')

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

180: AND object_version_number = px_object_version_number;
181:
182: UPDATE pv_ge_qsnr_elements_tl
183: set elmt_content = DECODE( p_elmt_content, null, elmt_content, FND_API.g_miss_char, null, p_elmt_content),
184: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
185: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
186: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
187: source_lang = USERENV('LANG')
188: WHERE qsnr_element_id = p_qsnr_element_id

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

181:
182: UPDATE pv_ge_qsnr_elements_tl
183: set elmt_content = DECODE( p_elmt_content, null, elmt_content, FND_API.g_miss_char, null, p_elmt_content),
184: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
185: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
186: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
187: source_lang = USERENV('LANG')
188: WHERE qsnr_element_id = p_qsnr_element_id
189: AND USERENV('LANG') IN (language, source_lang);

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

182: UPDATE pv_ge_qsnr_elements_tl
183: set elmt_content = DECODE( p_elmt_content, null, elmt_content, FND_API.g_miss_char, null, p_elmt_content),
184: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
185: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
186: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
187: source_lang = USERENV('LANG')
188: WHERE qsnr_element_id = p_qsnr_element_id
189: AND USERENV('LANG') IN (language, source_lang);
190:

Line 192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

188: WHERE qsnr_element_id = p_qsnr_element_id
189: AND USERENV('LANG') IN (language, source_lang);
190:
191: IF (SQL%NOTFOUND) THEN
192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
193: END IF;
194:
195: px_object_version_number := nvl(px_object_version_number,0) + 1;
196:

Line 223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

219: DELETE FROM pv_ge_qsnr_elements_b
220: WHERE qsnr_element_id = p_qsnr_element_id
221: AND object_version_number = p_object_version_number;
222: If (SQL%NOTFOUND) then
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: End If;
225: END Delete_Row ;
226:
227:

Line 261: RAISE FND_API.g_exc_error;

257: FETCH c INTO Recinfo;
258: IF (c%NOTFOUND) THEN
259: CLOSE c;
260: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
261: RAISE FND_API.g_exc_error;
262: END IF;
263: CLOSE c;
264: END Lock_Row;
265: