APPS.QP_COUPON_PVT dependencies on QP_NPREQ_LDETS_TMP

Line 742: INDX,QP_COUPON_PVT.Process_Coupon_Issue.get_coupon_issue_lines,qp_npreq_ldets_tmp_U1,LINE_DETAIL_INDEX,1

738: ) IS
739:
740: -- Get coupon issue line
741: /*
742: INDX,QP_COUPON_PVT.Process_Coupon_Issue.get_coupon_issue_lines,qp_npreq_ldets_tmp_U1,LINE_DETAIL_INDEX,1
743:
744: INDX,QP_COUPON_PVT.Process_Coupon_Issue.get_coupon_issue_lines,QP_LIST_LINES_PK,LIST_LINE_ID,1
745: */
746: CURSOR get_coupon_issue_lines IS

Line 775: qp_npreq_ldets_tmp b ,

771: b.process_code,
772: b.applied_flag,
773: b.modifier_level_code
774: FROM qp_npreq_lines_tmp a ,
775: qp_npreq_ldets_tmp b ,
776: QP_LIST_LINES c
777: WHERE a.LINE_INDEX = b.LINE_INDEX
778: AND b.LINE_DETAIL_INDEX = p_line_detail_index
779: AND b.CREATED_FROM_LIST_LINE_ID = c.LIST_LINE_ID

Line 884: INDX,QP_COUPON_PVT.Process_Coupon_Issue.Process_Coupon_Issue_upd1,qp_npreq_ldets_tmp_U1,LINE_DETAIL_INDEX,1

880: IF (J = 1) THEN
881:
882: --DBMS_OUTPUT.PUT_LINE('Update Coupon No'||l_coupon_number);
883: /*
884: INDX,QP_COUPON_PVT.Process_Coupon_Issue.Process_Coupon_Issue_upd1,qp_npreq_ldets_tmp_U1,LINE_DETAIL_INDEX,1
885: */
886: UPDATE qp_npreq_ldets_tmp
887: SET PROCESSED_FLAG = 'Y',
888: LIST_LINE_NO = l_coupon_number,

Line 886: UPDATE qp_npreq_ldets_tmp

882: --DBMS_OUTPUT.PUT_LINE('Update Coupon No'||l_coupon_number);
883: /*
884: INDX,QP_COUPON_PVT.Process_Coupon_Issue.Process_Coupon_Issue_upd1,qp_npreq_ldets_tmp_U1,LINE_DETAIL_INDEX,1
885: */
886: UPDATE qp_npreq_ldets_tmp
887: SET PROCESSED_FLAG = 'Y',
888: LIST_LINE_NO = l_coupon_number,
889: PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW,
890: PRICING_STATUS_TEXT = 'Coupon_Issue'

Line 898: --FROM qp_npreq_ldets_tmp;

894: ELSE
895:
896: --SELECT max(line_detail_index)
897: --INTO l_line_detail_index
898: --FROM qp_npreq_ldets_tmp;
899:
900: l_line_detail_index := QP_PREQ_GRP.GET_LINE_DETAIL_INDEX;
901:
902: --DBMS_OUTPUT.PUT_LINE('max line detail'||l_line_detail_index);

Line 905: INSERT INTO qp_npreq_ldets_tmp(

901:
902: --DBMS_OUTPUT.PUT_LINE('max line detail'||l_line_detail_index);
903: -- 3. create adjustment line
904:
905: INSERT INTO qp_npreq_ldets_tmp(
906: LINE_DETAIL_INDEX,
907: LINE_DETAIL_TYPE_CODE,
908: LINE_INDEX,
909: CREATED_FROM_LIST_HEADER_ID,

Line 985: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_ldets_tmp_N7,PRICING_STATUS_CODE,1

981: )
982: IS
983:
984: /*
985: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_ldets_tmp_N7,PRICING_STATUS_CODE,1
986:
987: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_line_attrs_tmp_N7,LINE_INDEX,1
988: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_line_attrs_tmp_N7,ATTRIBUTE_TYPE,2
989: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_line_attrs_tmp_N7,CONTEXT,3

Line 999: qp_npreq_ldets_tmp qpd,

995: CURSOR get_coupons_ldet IS
996: SELECT /*+ ordered index(qplat) index( qpl) index( qpd)*/ DISTINCT qpc.coupon_number, --5658579
997: qpl.pricing_effective_date
998: FROM qp_npreq_line_attrs_tmp qplat,
999: qp_npreq_ldets_tmp qpd,
1000: qp_npreq_lines_tmp qpl,
1001: qp_coupons qpc
1002: WHERE qplat.line_index = qpd.line_index
1003: and qpl.line_index = qpd.line_index

Line 1019: qp_npreq_ldets_tmp qpd,

1015: CURSOR get_coupons_line IS
1016: SELECT DISTINCT coupon_number,
1017: qpl.pricing_effective_date
1018: FROM qp_npreq_line_attrs_tmp qplat,
1019: qp_npreq_ldets_tmp qpd,
1020: qp_npreq_lines_tmp qpl,
1021: qp_qualifiers qpq,
1022: qp_coupons qpc
1023: WHERE qplat.line_index = qpl.line_index