[Home] [Help]
229: IF (i <> l_workers) then
230: l_worker_end := l_worker_end - 1;
231: END IF;
232:
233: QP_Modifier_Upgrade_Util_PVT.insert_line_distribution
234: ( l_worker => i,
235: l_start_line => l_worker_start,
236: l_end_line => l_worker_end,
237: l_type_var => v_type);
433:
434: v_old_discount_id := i.discount_id;
435:
436: -- If the Discount does not exist
437: QP_Modifier_Upgrade_Util_PVT.Create_List_Header(i.creation_date,
438: i.created_by,
439: i.last_update_date,
440: i.last_updated_by,
441: nvl(i.last_update_login,1),
521: raise;
522: END;
523: flex */
524:
525: QP_Modifier_Upgrade_Util_PVT.Create_Qualifier(i.creation_date,
526: i.created_by,
527: i.last_update_date,
528: i.last_updated_by,
529: i.last_update_login,
605:
606: flex */
607:
608: -- Create a GSA Qualifier
609: QP_Modifier_Upgrade_Util_PVT.Create_Qualifier(i.creation_date,
610: i.created_by,
611: i.last_update_date,
612: i.last_updated_by,
613: i.last_update_login,
689: raise;
690: END;
691: flex */
692: -- Create the Qualifier for customer class code
693: QP_Modifier_Upgrade_Util_PVT.Create_Qualifier(i.creation_date,
694: i.created_by,
695: i.last_update_date,
696: i.last_updated_by,
697: i.last_update_login,
765: raise;
766: END;
767: flex */
768: -- Create the qualifier for site_use_id
769: QP_Modifier_Upgrade_Util_PVT.Create_Qualifier(i.creation_date,
770: i.created_by,
771: i.last_update_date,
772: i.last_updated_by,
773: i.last_update_login,
843: raise;
844: END;
845: flex */
846: -- Create the qualifier for customer_id
847: QP_Modifier_Upgrade_Util_PVT.Create_Qualifier(i.creation_date,
848: i.created_by,
849: i.last_update_date,
850: i.last_updated_by,
851: i.last_update_login,
971: AND a.DESCRIPTIVE_FLEX_CONTEXT_CODE = 'ITEM'
972: AND a.APPLICATION_COLUMN_NAME = 'PRICING_ATTRIBUTE3';
973: END IF;
974: -- Create the list line
975: QP_Modifier_Upgrade_Util_PVT.Create_List_Line(i.creation_date,
976: i.created_by,
977: i.last_update_date,
978: i.last_updated_by,
979: i.last_update_login,
1039: IF (v_discount_level = G_LINE_LEVEL) THEN
1040:
1041:
1042: -- Create the Product/Pricing Attribute
1043: QP_Modifier_Upgrade_Util_PVT.Create_Pricing_Attribute(i.creation_date,
1044: i.created_by,
1045: i.last_update_date,
1046: i.last_updated_by,
1047: i.last_update_login,
1191: v_qualification_ind := null;
1192: END IF;*/
1193:
1194: -- Create the list line
1195: QP_Modifier_Upgrade_Util_PVT.Create_List_Line(j.creation_date,
1196: j.created_by,
1197: j.last_update_date,
1198: j.last_updated_by,
1199: j.last_update_login,
1262: l_comparison_operator_code := NULL;
1263: end if;
1264:
1265:
1266: QP_Modifier_Upgrade_Util_PVT.Create_Pricing_Attribute(j.creation_date,
1267: j.created_by,
1268: j.last_update_date,
1269: j.last_updated_by,
1270: j.last_update_login,
1295: -- After discussion with Sripriya
1296:
1297: --IF (v_line_type_code = G_PRICE_BREAK_LINE_TYPE_CODE) THEN
1298:
1299: QP_Modifier_Upgrade_Util_PVT.Create_Pricing_Attribute(j.creation_date,
1300: j.created_by,
1301: j.last_update_date,
1302: j.last_updated_by,
1303: j.last_update_login,
1543: v_qualification_ind := null;
1544: END IF;*/
1545:
1546: IF (v_product_flag = TRUE OR v_qualifier_flag = TRUE) THEN
1547: QP_Modifier_Upgrade_Util_PVT.Create_List_Line(j.creation_date,
1548: j.created_by,
1549: j.last_update_date,
1550: j.last_updated_by,
1551: j.last_update_login,
1612:
1613: IF (v_product_flag = TRUE) THEN
1614:
1615: -- Create the Product/Pricing Attribute
1616: QP_Modifier_Upgrade_Util_PVT.Create_Pricing_Attribute(j.creation_date,
1617: j.created_by,
1618: j.last_update_date,
1619: j.last_updated_by,
1620: j.last_update_login,
1654: IF (v_qualifier_flag = TRUE) THEN
1655:
1656:
1657: -- Create the Qualifier
1658: QP_Modifier_Upgrade_Util_PVT.Create_Qualifier(i.creation_date,
1659: i.created_by,
1660: i.last_update_date,
1661: i.last_updated_by,
1662: i.last_update_login,
1733: -- PBH Children
1734: v_qualification_ind := 2;
1735:
1736: -- Create a list line for each price break line
1737: QP_Modifier_Upgrade_Util_PVT.Create_List_Line(k.creation_date,
1738: k.created_by,
1739: k.last_update_date,
1740: k.last_updated_by,
1741: k.last_update_login,
1790: v_line_seq_num := x_list_line_id;
1791: v_new_line_flag := FALSE;
1792:
1793: -- Insert a record into related modifier table
1794: QP_Modifier_Upgrade_Util_PVT.Create_Related_Modifier(k.creation_date,
1795: k.created_by,
1796: k.last_update_date,
1797: k.last_updated_by,
1798: k.last_update_login,
1811: IF (v_product_flag = TRUE ) THEN
1812:
1813: -- Create the Product/Pricing Attribute
1814:
1815: QP_Modifier_Upgrade_Util_PVT.Create_Pricing_Attribute_Break(k.creation_date,
1816: k.created_by,
1817: k.last_update_date,
1818: k.last_updated_by,
1819: k.last_update_login,
1845: -- This record the product record in qp_pricing_attributes for PBH Line(Parent Line)
1846: -- Insert only 1 record
1847: IF (v_qualifier_flag = TRUE and v_break_count = 0 ) THEN
1848: -- Create the Product/Pricing Attribute
1849: QP_Modifier_Upgrade_Util_PVT.Create_Pricing_Attribute(j.creation_date,
1850: j.created_by,
1851: j.last_update_date,
1852: j.last_updated_by,
1853: j.last_update_login,
1878: IF (v_qualifier_flag = TRUE OR v_pricing_flag = TRUE) THEN
1879:
1880:
1881: -- Create the Pricing Attribute
1882: QP_Modifier_Upgrade_Util_PVT.Create_Pricing_Attribute_Break(k.creation_date,
1883: k.created_by,
1884: k.last_update_date,
1885: k.last_updated_by,
1886: k.last_update_login,