APPS.QP_BULK_VALUE_TO_ID dependencies on QP_INTERFACE_QUALIFIERS

Line 128: UPDATE QP_INTERFACE_QUALIFIERS a

124: BEGIN
125:
126: qp_bulk_loader_pub.write_log( 'Entering Value to ID Qualifier');
127: -- 1. CREATED_FROM_RULE
128: UPDATE QP_INTERFACE_QUALIFIERS a
129: SET(CREATED_FROM_RULE_ID, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
130: (SELECT b.QUALIFIER_RULE_ID,
131: DECODE(b.QUALIFIER_RULE_ID, NULL, null, 'P'),
132: DECODE(b.QUALIFIER_RULE_ID,NULL, a.ATTRIBUTE_STATUS||'001', a.ATTRIBUTE_STATUS)

Line 133: FROM QP_QUALIFIER_RULES b, QP_INTERFACE_QUALIFIERS c

129: SET(CREATED_FROM_RULE_ID, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
130: (SELECT b.QUALIFIER_RULE_ID,
131: DECODE(b.QUALIFIER_RULE_ID, NULL, null, 'P'),
132: DECODE(b.QUALIFIER_RULE_ID,NULL, a.ATTRIBUTE_STATUS||'001', a.ATTRIBUTE_STATUS)
133: FROM QP_QUALIFIER_RULES b, QP_INTERFACE_QUALIFIERS c
134: WHERE c.CREATED_FROM_RULE = b.NAME(+)
135: AND a.rowid = c.rowid
136: )
137: WHERE a.REQUEST_ID = P_REQUEST_ID

Line 148: UPDATE QP_INTERFACE_QUALIFIERS a

144: AND a.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');
145:
146: -- 2.QUALIFIER_RULE
147:
148: UPDATE QP_INTERFACE_QUALIFIERS a
149: SET(QUALIFIER_RULE_ID, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
150: (SELECT b.QUALIFIER_RULE_ID,
151: DECODE(b.QUALIFIER_RULE_ID, NULL, null, 'P'),
152: DECODE(b.QUALIFIER_RULE_ID,NULL, a.ATTRIBUTE_STATUS||'002', a.ATTRIBUTE_STATUS)

Line 153: FROM QP_QUALIFIER_RULES b, QP_INTERFACE_QUALIFIERS c

149: SET(QUALIFIER_RULE_ID, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
150: (SELECT b.QUALIFIER_RULE_ID,
151: DECODE(b.QUALIFIER_RULE_ID, NULL, null, 'P'),
152: DECODE(b.QUALIFIER_RULE_ID,NULL, a.ATTRIBUTE_STATUS||'002', a.ATTRIBUTE_STATUS)
153: FROM QP_QUALIFIER_RULES b, QP_INTERFACE_QUALIFIERS c
154: WHERE c.QUALIFIER_RULE = b.NAME(+)
155: AND a.rowid = c.rowid
156: )
157: WHERE a.REQUEST_ID = P_REQUEST_ID

Line 168: UPDATE QP_INTERFACE_QUALIFIERS qiq

164: AND a.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');
165:
166: --3.Qualifier Attribute
167:
168: UPDATE QP_INTERFACE_QUALIFIERS qiq
169: SET(QUALIFIER_ATTRIBUTE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
170: (SELECT a.segment_mapping_column,
171: DECODE(a.segment_mapping_column, NULL, null, 'P'),
172: DECODE(a.segment_mapping_column, NULL, qiq.ATTRIBUTE_STATUS||'003',qiq.ATTRIBUTE_STATUS)

Line 173: FROM qp_segments_v a, qp_prc_contexts_b b, qp_interface_qualifiers c

169: SET(QUALIFIER_ATTRIBUTE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
170: (SELECT a.segment_mapping_column,
171: DECODE(a.segment_mapping_column, NULL, null, 'P'),
172: DECODE(a.segment_mapping_column, NULL, qiq.ATTRIBUTE_STATUS||'003',qiq.ATTRIBUTE_STATUS)
173: FROM qp_segments_v a, qp_prc_contexts_b b, qp_interface_qualifiers c
174: WHERE b.prc_context_id = a.prc_context_id
175: AND b.prc_context_code = c.QUALIFIER_CONTEXT
176: AND a.segment_code = c.QUALIFIER_ATTRIBUTE_CODE
177: AND a.segment_mapping_column like 'QUALIFIER%'

Line 791: FROM qp_interface_qualifiers

787: CURSOR c_error_records IS
788: SELECT orig_sys_qualifier_ref,
789: orig_sys_header_ref,
790: attribute_status
791: FROM qp_interface_qualifiers
792: WHERE request_id = p_request_id
793: AND process_status_flag is null;
794: -- AND attribute_status IS NOT NULL;
795:

Line 844: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', NULL,

840: orig_sys_pricing_attr_ref, error_message)
841: VALUES
842: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
843: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
844: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', NULL,
845: l_err.orig_sys_header_ref,null,l_err.orig_sys_qualifier_ref,null,l_msg_txt);
846:
847: l_first:=l_first+3;
848:

Line 864: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', NULL,

860: orig_sys_pricing_attr_ref, error_message)
861: VALUES
862: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
863: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
864: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', NULL,
865: l_err.orig_sys_header_ref,null,l_err.orig_sys_qualifier_ref,null,l_msg_txt);
866: END IF;
867: NULL;
868: END LOOP;