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 760: FROM qp_interface_qualifiers

756: CURSOR c_error_records IS
757: SELECT orig_sys_qualifier_ref,
758: orig_sys_header_ref,
759: attribute_status
760: FROM qp_interface_qualifiers
761: WHERE request_id = p_request_id
762: AND process_status_flag is null;
763: -- AND attribute_status IS NOT NULL;
764:

Line 813: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', NULL,

809: orig_sys_pricing_attr_ref, error_message)
810: VALUES
811: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
812: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
813: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', NULL,
814: l_err.orig_sys_header_ref,null,l_err.orig_sys_qualifier_ref,null,l_msg_txt);
815:
816: l_first:=l_first+3;
817:

Line 833: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', NULL,

829: orig_sys_pricing_attr_ref, error_message)
830: VALUES
831: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
832: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
833: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', NULL,
834: l_err.orig_sys_header_ref,null,l_err.orig_sys_qualifier_ref,null,l_msg_txt);
835: END IF;
836: NULL;
837: END LOOP;