APPS.QP_COUPON_PVT dependencies on QP_LIST_LINES

Line 105: INDX,QP_COUPON_PVT.update_qual_ind.update_qual_ind_upd1,QP_LIST_LINES_PK,LIST_LINE_ID,1

101:
102: IF l_line_qual_exists <> 'Y' THEN
103:
104: /*
105: INDX,QP_COUPON_PVT.update_qual_ind.update_qual_ind_upd1,QP_LIST_LINES_PK,LIST_LINE_ID,1
106: */
107: update qp_list_lines qpl set
108: qpl.qualification_ind =
109: nvl(qpl.qualification_ind,0)+8

Line 107: update qp_list_lines qpl set

103:
104: /*
105: INDX,QP_COUPON_PVT.update_qual_ind.update_qual_ind_upd1,QP_LIST_LINES_PK,LIST_LINE_ID,1
106: */
107: update qp_list_lines qpl set
108: qpl.qualification_ind =
109: nvl(qpl.qualification_ind,0)+8
110: where qpl.list_line_id=p_list_line_id
111: returning qpl.qualification_ind into l_qual_ind;

Line 304: INDX,QP_COUPON_PVT.Create_Coupon_Qualifier.Create_Coupon_Qualifier_sel1,QP_LIST_LINES_PK,LIST_LINE_ID,1

300: /*
301: INDX,QP_COUPON_PVT.Create_Coupon_Qualifier.Create_Coupon_Qualifier_sel1,QP_RLTD_MODIFIERS_N1,FROM_RLTD_MODIFIER_ID,1
302: INDX,QP_COUPON_PVT.Create_Coupon_Qualifier.Create_Coupon_Qualifier_sel1,QP_RLTD_MODIFIERS_N1,RLTD_MODIFIER_GRP_TYPE,2
303:
304: INDX,QP_COUPON_PVT.Create_Coupon_Qualifier.Create_Coupon_Qualifier_sel1,QP_LIST_LINES_PK,LIST_LINE_ID,1
305: */
306: SELECT m.to_rltd_modifier_id list_line_id,
307: l.list_header_id,
308: l.qualification_ind

Line 310: FROM qp_rltd_modifiers m, qp_list_lines l

306: SELECT m.to_rltd_modifier_id list_line_id,
307: l.list_header_id,
308: l.qualification_ind
309: INTO l_list_line_id, l_list_header_id,l_qualification_ind
310: FROM qp_rltd_modifiers m, qp_list_lines l
311: WHERE from_rltd_modifier_id = p_list_line_id
312: AND m.to_rltd_modifier_id = l.list_line_id
313: AND m.rltd_modifier_grp_type = QP_COUPON_PVT.G_COUPON_GRP_TYPE;
314: EXCEPTION

Line 402: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_list_line_id)

398: l_qual_attr_value_to_number,
399: 1
400: --ENH Upgrade BOAPI for orig_sys...ref RAVI
401: ,to_char(QP_QUALIFIERS_S.currval)
402: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_list_line_id)
403: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_list_header_id)
404: );
405:
406: update_qual_ind(l_list_header_id,

Line 426: update qp_list_lines set qualification_ind

422: OR l_qualification_ind = QP_PREQ_GRP.G_BLIND_DISCOUNT_IND) THEN
423:
424: l_qualification_ind := l_qualification_ind-QP_PREQ_GRP.G_NO_QUAL_IND;
425:
426: update qp_list_lines set qualification_ind
427: =decode(l_qualification_ind, 0, NULL, l_qualification_ind)
428: where list_line_id = l_list_line_id;
429:
430: END IF;*/

Line 777: INDX,QP_COUPON_PVT.Process_Coupon_Issue.get_coupon_issue_lines,QP_LIST_LINES_PK,LIST_LINE_ID,1

773: -- Get coupon issue line
774: /*
775: INDX,QP_COUPON_PVT.Process_Coupon_Issue.get_coupon_issue_lines,qp_npreq_ldets_tmp_U1,LINE_DETAIL_INDEX,1
776:
777: INDX,QP_COUPON_PVT.Process_Coupon_Issue.get_coupon_issue_lines,QP_LIST_LINES_PK,LIST_LINE_ID,1
778: */
779: CURSOR get_coupon_issue_lines IS
780: SELECT /*+ ORDERED USE_NL(b c) */
781: a.line_index,

Line 809: QP_LIST_LINES c

805: b.applied_flag,
806: b.modifier_level_code
807: FROM qp_npreq_lines_tmp a ,
808: qp_npreq_ldets_tmp b ,
809: QP_LIST_LINES c
810: WHERE a.LINE_INDEX = b.LINE_INDEX
811: AND b.LINE_DETAIL_INDEX = p_line_detail_index
812: AND b.CREATED_FROM_LIST_LINE_ID = c.LIST_LINE_ID
813: AND b.CREATED_FROM_LIST_LINE_TYPE