3988: l_return_status VARCHAR2(1);
3989: l_msg_count NUMBER;
3990: l_msg_data VARCHAR2(2000);
3991:
3992: p_price_list_rec qp_price_list_pub.price_list_rec_type;
3993: p_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
3994: p_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
3995: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
3996: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
3989: l_msg_count NUMBER;
3990: l_msg_data VARCHAR2(2000);
3991:
3992: p_price_list_rec qp_price_list_pub.price_list_rec_type;
3993: p_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
3994: p_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
3995: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
3996: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
3997: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
3990: l_msg_data VARCHAR2(2000);
3991:
3992: p_price_list_rec qp_price_list_pub.price_list_rec_type;
3993: p_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
3994: p_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
3995: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
3996: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
3997: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
3998: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
3991:
3992: p_price_list_rec qp_price_list_pub.price_list_rec_type;
3993: p_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
3994: p_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
3995: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
3996: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
3997: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
3998: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
3999: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
3994: p_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
3995: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
3996: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
3997: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
3998: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
3999: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
4000:
4001: l_price_list_rec qp_price_list_pub.price_list_rec_type;
4002: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
3995: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
3996: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
3997: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
3998: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
3999: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
4000:
4001: l_price_list_rec qp_price_list_pub.price_list_rec_type;
4002: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
4003: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
3997: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
3998: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
3999: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
4000:
4001: l_price_list_rec qp_price_list_pub.price_list_rec_type;
4002: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
4003: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
4004: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
4005: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
3998: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
3999: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
4000:
4001: l_price_list_rec qp_price_list_pub.price_list_rec_type;
4002: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
4003: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
4004: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
4005: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4006: l_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
3999: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
4000:
4001: l_price_list_rec qp_price_list_pub.price_list_rec_type;
4002: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
4003: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
4004: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
4005: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4006: l_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4007: l_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
4000:
4001: l_price_list_rec qp_price_list_pub.price_list_rec_type;
4002: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
4003: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
4004: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
4005: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4006: l_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4007: l_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
4008: l_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
4003: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
4004: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
4005: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4006: l_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4007: l_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
4008: l_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
4009:
4010: BEGIN
4011:
4004: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
4005: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4006: l_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4007: l_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
4008: l_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
4009:
4010: BEGIN
4011:
4012: --dbms_output.put_line('create List header called');
4025: IF (AMS_DEBUG_HIGH_ON) THEN
4026: AMS_Utility_PVT.debug_message(l_full_name ||': create pricelist header...');
4027: END IF;
4028:
4029: QP_PRICE_LIST_PUB.Process_Price_List(
4030: p_api_version_number => 1.0,
4031: p_init_msg_list => FND_API.g_false,
4032: p_return_values => FND_API.G_TRUE,
4033: p_commit => FND_API.g_false,
4095: l_return_status VARCHAR2(1);
4096: l_msg_count NUMBER;
4097: l_msg_data VARCHAR2(2000);
4098:
4099: p_price_list_rec qp_price_list_pub.price_list_rec_type;
4100: p_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
4101: p_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
4102: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
4103: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4096: l_msg_count NUMBER;
4097: l_msg_data VARCHAR2(2000);
4098:
4099: p_price_list_rec qp_price_list_pub.price_list_rec_type;
4100: p_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
4101: p_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
4102: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
4103: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4104: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4097: l_msg_data VARCHAR2(2000);
4098:
4099: p_price_list_rec qp_price_list_pub.price_list_rec_type;
4100: p_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
4101: p_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
4102: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
4103: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4104: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4105: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
4098:
4099: p_price_list_rec qp_price_list_pub.price_list_rec_type;
4100: p_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
4101: p_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
4102: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
4103: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4104: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4105: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
4106: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
4101: p_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
4102: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
4103: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4104: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4105: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
4106: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
4107:
4108: l_price_list_rec qp_price_list_pub.price_list_rec_type;
4109: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
4102: p_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
4103: p_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4104: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4105: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
4106: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
4107:
4108: l_price_list_rec qp_price_list_pub.price_list_rec_type;
4109: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
4110: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
4104: p_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4105: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
4106: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
4107:
4108: l_price_list_rec qp_price_list_pub.price_list_rec_type;
4109: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
4110: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
4111: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
4112: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4105: p_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
4106: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
4107:
4108: l_price_list_rec qp_price_list_pub.price_list_rec_type;
4109: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
4110: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
4111: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
4112: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4113: l_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4106: p_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
4107:
4108: l_price_list_rec qp_price_list_pub.price_list_rec_type;
4109: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
4110: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
4111: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
4112: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4113: l_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4114: l_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
4107:
4108: l_price_list_rec qp_price_list_pub.price_list_rec_type;
4109: l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
4110: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
4111: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
4112: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4113: l_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4114: l_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
4115: l_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
4110: l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
4111: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
4112: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4113: l_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4114: l_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
4115: l_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
4116:
4117: BEGIN
4118:
4111: l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
4112: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4113: l_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4114: l_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
4115: l_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
4116:
4117: BEGIN
4118:
4119: --dbms_output.put_line('create List line called');
4139: IF (AMS_DEBUG_HIGH_ON) THEN
4140: AMS_Utility_PVT.debug_message(l_full_name ||': create pricelist line...');
4141: END IF;
4142:
4143: QP_PRICE_LIST_PUB.Process_Price_List(
4144: p_api_version_number => 1.0,
4145: p_init_msg_list => FND_API.g_false,
4146: p_return_values => FND_API.G_TRUE,
4147: p_commit => FND_API.g_false,