APPS.QP_SOURCING_API_PUB dependencies on QP_PREQ_GRP

Line 5: G_GSA_INDICATOR_FLAGS QP_PREQ_GRP.FLAG_TYPE;

1: PACKAGE BODY QP_SOURCING_API_PUB AS
2: /* $Header: QPXPSAPB.pls 120.9.12020000.3 2013/03/01 05:48:57 kdurgasi ship $ */
3:
4: l_debug VARCHAR2(3);
5: G_GSA_INDICATOR_FLAGS QP_PREQ_GRP.FLAG_TYPE;
6: G_Customer_Info_null Customer_Info_Rec_Type;
7:
8: Procedure Get_Customer_Info(p_cust_id NUMBER)
9: IS

Line 35: if qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then

31: PRAGMA EXCEPTION_INIT(NUMERIC_OR_VALUE, -6502);
32:
33: BEGIN
34: g_customer_info:=G_Customer_Info_null;
35: if qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then
36:
37: G_Customer_Info.customer_id := p_cust_id;
38:
39: -- Getting info from HZ_CUST_ACCOUNTS

Line 411: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

407: returns_total_qty NUMBER := 0;
408:
409: BEGIN
410:
411: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
412: if qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then
413: --Bug 2718722, Added exception handling and replaced pricing_quantity by ordered_quantity
414: If QP_UTIL_PUB.HVOP_Pricing_On = 'Y' Then
415:

Line 412: if qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then

408:
409: BEGIN
410:
411: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
412: if qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then
413: --Bug 2718722, Added exception handling and replaced pricing_quantity by ordered_quantity
414: If QP_UTIL_PUB.HVOP_Pricing_On = 'Y' Then
415:
416: For i in QP_BULK_PREQ_GRP.G_Line_Rec.header_id.first..QP_BULK_PREQ_GRP.G_Line_Rec.header_id.last

Line 1058: if qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then

1054: l_sob_currency VARCHAR2(30);
1055:
1056: BEGIN
1057:
1058: if qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then
1059:
1060: BEGIN
1061:
1062: SELECT period1_total_amount

Line 1141: if qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then

1137: l_sob_currency VARCHAR2(30);
1138:
1139: BEGIN
1140:
1141: if qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then
1142:
1143: BEGIN
1144:
1145: SELECT period2_total_amount

Line 1223: if qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then

1219: l_sob_currency VARCHAR2(30);
1220:
1221: BEGIN
1222:
1223: if qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then
1224:
1225: BEGIN
1226:
1227: SELECT period3_total_amount

Line 1381: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

1377: l_uom_code VARCHAR2(3);
1378: l_uom_rate NUMBER;
1379: BEGIN
1380:
1381: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
1382: IF p_uom_class NOT IN ('Weight','Volume')
1383: THEN
1384: IF l_debug = FND_API.G_TRUE THEN
1385: oe_debug_pub.add('Invalide parameter' || p_uom_class);

Line 1440: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

1436: WHERE header_id = header_id_in;
1437:
1438: BEGIN
1439:
1440: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
1441: if qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then
1442:
1443: IF p_uom_class NOT IN ('Weight','Volume')
1444: THEN

Line 1441: if qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then

1437:
1438: BEGIN
1439:
1440: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
1441: if qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then
1442:
1443: IF p_uom_class NOT IN ('Weight','Volume')
1444: THEN
1445: IF l_debug = FND_API.G_TRUE THEN

Line 1530: if qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then

1526: x_count NUMBER;
1527:
1528: BEGIN
1529:
1530: if qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then
1531:
1532: l_shippable_flag := 'N';
1533:
1534: begin

Line 1628: if qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then

1624: WHERE cust_account_id = cust_id_in;
1625:
1626: BEGIN
1627: g_customer_info:=G_Customer_Info_null;
1628: if qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then
1629:
1630: G_Customer_Info.customer_id := p_cust_id;
1631:
1632: -- Getting info from HZ_CUST_ACCOUNTS