DBA Data[Home] [Help]

APPS.QP_MODIFIER_UPGRADE_UTIL_PVT dependencies on QP_QUALIFIERS

Line 310: -- Create a record in qp_qualifiers

306: END IF;
307:
308: -- mkarya for bug 1955867, the order of p_context, p_start_date_active,p_end_date_active in the VALUES
309: -- clause have been arranged to populate these columns properly
310: -- Create a record in qp_qualifiers
311: INSERT INTO QP_QUALIFIERS (
312: QUALIFIER_ID,CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
313: LAST_UPDATE_LOGIN, LIST_HEADER_ID, LIST_LINE_ID,COMPARISON_OPERATOR_CODE, QUALIFIER_CONTEXT,
314: QUALIFIER_ATTRIBUTE, QUALIFIER_ATTR_VALUE, QUALIFIER_GROUPING_NO,EXCLUDER_FLAG,

Line 311: INSERT INTO QP_QUALIFIERS (

307:
308: -- mkarya for bug 1955867, the order of p_context, p_start_date_active,p_end_date_active in the VALUES
309: -- clause have been arranged to populate these columns properly
310: -- Create a record in qp_qualifiers
311: INSERT INTO QP_QUALIFIERS (
312: QUALIFIER_ID,CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
313: LAST_UPDATE_LOGIN, LIST_HEADER_ID, LIST_LINE_ID,COMPARISON_OPERATOR_CODE, QUALIFIER_CONTEXT,
314: QUALIFIER_ATTRIBUTE, QUALIFIER_ATTR_VALUE, QUALIFIER_GROUPING_NO,EXCLUDER_FLAG,
315: QUALIFIER_PRECEDENCE,QUALIFIER_DATATYPE,START_DATE_ACTIVE,END_DATE_ACTIVE,CONTEXT,ATTRIBUTE1,ATTRIBUTE2,

Line 323: QP_QUALIFIERS_S.nextval,p_creation_date,p_created_by,p_last_update_date,p_last_updated_by,

319: ,ORIG_SYS_QUALIFIER_REF
320: ,ORIG_SYS_LINE_REF
321: ,ORIG_SYS_HEADER_REF)
322: VALUES (
323: QP_QUALIFIERS_S.nextval,p_creation_date,p_created_by,p_last_update_date,p_last_updated_by,
324: p_last_update_login,p_list_header_id,p_list_line_id,p_comparision_operator_code,
325: p_qualifier_context, p_qualifier_attribute,p_qualifier_attr_value,x_qualifier_grouping_no,
326: p_excluder_flag,p_qualifier_precedence,p_qualifier_datatype, p_start_date_active,p_end_date_active, p_context,
327: p_attribute1,p_attribute2,p_attribute3,p_attribute4, p_attribute5,p_attribute6,p_attribute7,

Line 331: ,to_char(QP_QUALIFIERS_S.currval)

327: p_attribute1,p_attribute2,p_attribute3,p_attribute4, p_attribute5,p_attribute6,p_attribute7,
328: p_attribute8,p_attribute9,p_attribute10, p_attribute11,p_attribute12,p_attribute13,
329: p_attribute14,p_attribute15
330: --ENH Upgrade BOAPI for orig_sys...ref RAVI
331: ,to_char(QP_QUALIFIERS_S.currval)
332: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=p_list_line_id)
333: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_list_header_id)
334: );
335: EXCEPTION