APPS.QP_BULK_VALUE_TO_ID dependencies on QP_INTERFACE_LIST_LINES

Line 257: UPDATE QP_INTERFACE_LIST_LINES a

253: BEGIN
254: qp_bulk_loader_pub.write_log( 'Entering Value to ID Lines');
255: -- 1.PRICE_BY_FORMULA
256:
257: UPDATE QP_INTERFACE_LIST_LINES a
258: SET(PRICE_BY_FORMULA_ID, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
259: (SELECT b.PRICE_FORMULA_ID,
260: DECODE(b.PRICE_FORMULA_ID, NULL, null, 'P'),
261: DECODE(b.PRICE_FORMULA_ID,NULL, a.ATTRIBUTE_STATUS||'001', a.ATTRIBUTE_STATUS)

Line 262: FROM QP_PRICE_FORMULAS_VL b, QP_INTERFACE_LIST_LINES c

258: SET(PRICE_BY_FORMULA_ID, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
259: (SELECT b.PRICE_FORMULA_ID,
260: DECODE(b.PRICE_FORMULA_ID, NULL, null, 'P'),
261: DECODE(b.PRICE_FORMULA_ID,NULL, a.ATTRIBUTE_STATUS||'001', a.ATTRIBUTE_STATUS)
262: FROM QP_PRICE_FORMULAS_VL b, QP_INTERFACE_LIST_LINES c
263: WHERE c.PRICE_BY_FORMULA = b.NAME(+)
264: AND a.rowid = c.rowid
265: )
266: WHERE a.REQUEST_ID = P_REQUEST_ID

Line 275: UPDATE QP_INTERFACE_LIST_LINES a

271: and a.PRICE_BY_FORMULA <> QP_BULK_LOADER_PUB.G_NULL_CHAR
272: AND a.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');
273:
274: -- 2.GENERATE_USING_FORMULA
275: UPDATE QP_INTERFACE_LIST_LINES a
276: SET(GENERATE_USING_FORMULA_ID, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
277: (SELECT b.PRICE_FORMULA_ID,
278: DECODE(b.PRICE_FORMULA_ID, NULL, null, 'P'),
279: DECODE(b.PRICE_FORMULA_ID,NULL, a.ATTRIBUTE_STATUS||'002', a.ATTRIBUTE_STATUS)

Line 280: FROM QP_PRICE_FORMULAS_VL b, QP_INTERFACE_LIST_LINES c

276: SET(GENERATE_USING_FORMULA_ID, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
277: (SELECT b.PRICE_FORMULA_ID,
278: DECODE(b.PRICE_FORMULA_ID, NULL, null, 'P'),
279: DECODE(b.PRICE_FORMULA_ID,NULL, a.ATTRIBUTE_STATUS||'002', a.ATTRIBUTE_STATUS)
280: FROM QP_PRICE_FORMULAS_VL b, QP_INTERFACE_LIST_LINES c
281: WHERE c.GENERATE_USING_FORMULA = b.NAME(+)
282: AND a.rowid = c.rowid
283: )
284: WHERE a.REQUEST_ID = P_REQUEST_ID

Line 316: UPDATE QP_INTERFACE_LIST_LINES qill

312: AND qipa.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');
313:
314: -- 5.Product Precedence.
315: qp_bulk_loader_pub.write_log( 'Entering Value to ID Lines Product Precedence');
316: UPDATE QP_INTERFACE_LIST_LINES qill
317: SET PRODUCT_PRECEDENCE=
318: (SELECT NVL(a.USER_PRECEDENCE, a.SEEDED_PRECEDENCE)
319: FROM qp_segments_v a, qp_prc_contexts_b b, qp_interface_pricing_attribs c
320: WHERE b.prc_context_id = a.prc_context_id

Line 543: UPDATE QP_INTERFACE_LIST_LINES

539: );
540:
541: qp_bulk_loader_pub.write_log('line ref'||rec.orig_sys_line_ref||'error_code'||to_char(l_error_code));
542: If l_error_code = 0 Then
543: UPDATE QP_INTERFACE_LIST_LINES
544: SET PRODUCT_PRECEDENCE = l_precedence
545: WHERE ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF
546: AND PROCESS_STATUS_FLAG = 'P'
547: AND PRODUCT_PRECEDENCE IS NULL;

Line 549: UPDATE QP_INTERFACE_LIST_LINES

545: WHERE ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF
546: AND PROCESS_STATUS_FLAG = 'P'
547: AND PRODUCT_PRECEDENCE IS NULL;
548: else
549: UPDATE QP_INTERFACE_LIST_LINES
550: SET PROCESS_STATUS_FLAG = NULL,
551: ATTRIBUTE_STATUS=ATTRIBUTE_STATUS||'004'
552: WHERE ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF
553: AND PROCESS_STATUS_FLAG = 'P'; --IS NULL;

Line 862: 'QP_INTERFACE_LIST_LINES' table_name

858: SELECT orig_sys_header_ref orig_header_ref,
859: orig_sys_line_ref orig_line_ref,
860: null orig_attr_ref,
861: attribute_status, null pac, null pa, null pcac, null pca, null pav, null pavd,
862: 'QP_INTERFACE_LIST_LINES' table_name
863: FROM qp_interface_list_lines
864: WHERE request_id = p_request_id
865: AND process_status_flag is null
866: AND attribute_status IS NOT NULL

Line 863: FROM qp_interface_list_lines

859: orig_sys_line_ref orig_line_ref,
860: null orig_attr_ref,
861: attribute_status, null pac, null pa, null pcac, null pca, null pav, null pavd,
862: 'QP_INTERFACE_LIST_LINES' table_name
863: FROM qp_interface_list_lines
864: WHERE request_id = p_request_id
865: AND process_status_flag is null
866: AND attribute_status IS NOT NULL
867: UNION