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 574: UPDATE QP_INTERFACE_LIST_LINES

570: );
571:
572: qp_bulk_loader_pub.write_log('line ref'||rec.orig_sys_line_ref||'error_code'||to_char(l_error_code));
573: If l_error_code = 0 Then
574: UPDATE QP_INTERFACE_LIST_LINES
575: SET PRODUCT_PRECEDENCE = l_precedence
576: WHERE ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF
577: AND PROCESS_STATUS_FLAG = 'P'
578: AND PRODUCT_PRECEDENCE IS NULL;

Line 580: UPDATE QP_INTERFACE_LIST_LINES

576: WHERE ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF
577: AND PROCESS_STATUS_FLAG = 'P'
578: AND PRODUCT_PRECEDENCE IS NULL;
579: else
580: UPDATE QP_INTERFACE_LIST_LINES
581: SET PROCESS_STATUS_FLAG = NULL,
582: ATTRIBUTE_STATUS=ATTRIBUTE_STATUS||'004'
583: WHERE ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF
584: AND PROCESS_STATUS_FLAG = 'P'; --IS NULL;

Line 893: 'QP_INTERFACE_LIST_LINES' table_name

889: SELECT orig_sys_header_ref orig_header_ref,
890: orig_sys_line_ref orig_line_ref,
891: null orig_attr_ref,
892: attribute_status, null pac, null pa, null pcac, null pca, null pav, null pavd,
893: 'QP_INTERFACE_LIST_LINES' table_name
894: FROM qp_interface_list_lines
895: WHERE request_id = p_request_id
896: AND process_status_flag is null
897: AND attribute_status IS NOT NULL

Line 894: FROM qp_interface_list_lines

890: orig_sys_line_ref orig_line_ref,
891: null orig_attr_ref,
892: attribute_status, null pac, null pa, null pcac, null pca, null pav, null pavd,
893: 'QP_INTERFACE_LIST_LINES' table_name
894: FROM qp_interface_list_lines
895: WHERE request_id = p_request_id
896: AND process_status_flag is null
897: AND attribute_status IS NOT NULL
898: UNION