APPS.QP_BULK_PREQ_GRP dependencies on QP_INT_LDETS

Line 450: insert into qp_int_ldets

446:
447: If l_debug = 'T' Then
448: oe_debug_pub.add ('Started QPBGPREB Adjs:' ||SQLERRM);
449: End If;
450: insert into qp_int_ldets
451: (LINE_DETAIL_INDEX,
452: LINE_DETAIL_TYPE_CODE,
453: PRICE_BREAK_TYPE_CODE,
454: LINE_INDEX,

Line 542: select nvl(max(line_detail_index),0) into line_ldet_count from qp_int_ldets; -- fix for bug 3406218

538: --and lines_iface.header_id = line.header_id
539: and ll.list_line_id = adj_iface.list_line_id
540: and lhdr.list_header_id = ll.list_header_id);
541:
542: select nvl(max(line_detail_index),0) into line_ldet_count from qp_int_ldets; -- fix for bug 3406218
543:
544: If l_debug = 'T' Then
545: oe_debug_pub.add('Number of line level adjustments are '||line_ldet_count);
546: End if;

Line 549: insert into qp_int_ldets

545: oe_debug_pub.add('Number of line level adjustments are '||line_ldet_count);
546: End if;
547:
548: --UNION --split the insert statement for bug 3406218
549: insert into qp_int_ldets
550: (LINE_DETAIL_INDEX,
551: LINE_DETAIL_TYPE_CODE,
552: PRICE_BREAK_TYPE_CODE,
553: LINE_INDEX,

Line 666: ,created_from_list_line_id, automatic_flag, override_flag from qp_int_ldets)

662: END IF;
663:
664: IF l_debug = FND_API.G_TRUE THEN
665: FOR cl in (select line_index, line_detail_index, operand_value, operand_calculation_code, updated_flag, applied_flag
666: ,created_from_list_line_id, automatic_flag, override_flag from qp_int_ldets)
667: LOOP
668: oe_debug_pub.add('Inserted ldet details: line_index '||cl.line_index||' line_detail_index '||cl.line_detail_index
669: ||' created_from_list_line_id '||cl.created_from_list_line_id||' operand_value '||cl.operand_value||' arithmetic_operator '
670: ||cl.operand_calculation_code||' updated_flag '||cl.updated_flag||' applied_flag '||cl.applied_flag||' automatic_flag '