[Home] [Help]
190: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
191: l_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
192: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
193: l_MODIFIERS_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
194: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type := QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL;
195: l_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
196: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
197: l_PRICING_ATTR_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
198: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
191: l_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
192: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
193: l_MODIFIERS_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
194: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type := QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL;
195: l_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
196: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
197: l_PRICING_ATTR_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
198: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
199: l_x_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
198: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
199: l_x_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
200: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
201: l_x_MODIFIERS_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
202: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
203: l_x_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
204: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
205: l_x_PRICING_ATTR_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
206:
199: l_x_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
200: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
201: l_x_MODIFIERS_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
202: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
203: l_x_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
204: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
205: l_x_PRICING_ATTR_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
206:
207: CURSOR qp_modifier_list_CUR IS
511: , 'CREATE' operation
512: , FND_API.G_MISS_CHAR qualify_hier_descendents_flag
513: FROM
514: QP_QUALIFIERS_TEMP Q,
515: QP_QUALIFIER_RULES QR1,
516: QP_QUALIFIER_RULES QR2
517:
518: WHERE Q.CREATEDFROMRULENAME = QR1.NAME(+)
519: AND Q.QUALIFIERFROMRULENAME = QR2.NAME(+)
512: , FND_API.G_MISS_CHAR qualify_hier_descendents_flag
513: FROM
514: QP_QUALIFIERS_TEMP Q,
515: QP_QUALIFIER_RULES QR1,
516: QP_QUALIFIER_RULES QR2
517:
518: WHERE Q.CREATEDFROMRULENAME = QR1.NAME(+)
519: AND Q.QUALIFIERFROMRULENAME = QR2.NAME(+)
520: AND Q.LISTHEADERID = mListHeaderId;