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.8 2006/03/14 15:32:07 jhkuo ship $ */
3:
4: l_debug VARCHAR2(3);
5: G_GSA_INDICATOR_FLAGS QP_PREQ_GRP.FLAG_TYPE;
6:
7: Procedure Get_Customer_Info(p_cust_id NUMBER)
8: IS
9:

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

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

Line 419: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

415: returns_total_qty NUMBER := 0;
416:
417: BEGIN
418:
419: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
420: if qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then
421: --Bug 2718722, Added exception handling and replaced pricing_quantity by ordered_quantity
422: If QP_UTIL_PUB.HVOP_Pricing_On = 'Y' Then
423:

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

416:
417: BEGIN
418:
419: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
420: if qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then
421: --Bug 2718722, Added exception handling and replaced pricing_quantity by ordered_quantity
422: If QP_UTIL_PUB.HVOP_Pricing_On = 'Y' Then
423:
424: For i in QP_BULK_PREQ_GRP.G_Line_Rec.header_id.first..QP_BULK_PREQ_GRP.G_Line_Rec.header_id.last

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

1062: l_sob_currency VARCHAR2(30);
1063:
1064: BEGIN
1065:
1066: if qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then
1067:
1068: BEGIN
1069:
1070: SELECT period1_total_amount

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

1145: l_sob_currency VARCHAR2(30);
1146:
1147: BEGIN
1148:
1149: if qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then
1150:
1151: BEGIN
1152:
1153: SELECT period2_total_amount

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

1227: l_sob_currency VARCHAR2(30);
1228:
1229: BEGIN
1230:
1231: if qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then
1232:
1233: BEGIN
1234:
1235: SELECT period3_total_amount

Line 1389: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

1385: l_uom_code VARCHAR2(3);
1386: l_uom_rate NUMBER;
1387: BEGIN
1388:
1389: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
1390: IF p_uom_class NOT IN ('Weight','Volume')
1391: THEN
1392: IF l_debug = FND_API.G_TRUE THEN
1393: oe_debug_pub.add('Invalide parameter' || p_uom_class);

Line 1448: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

1444: WHERE header_id = header_id_in;
1445:
1446: BEGIN
1447:
1448: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
1449: if qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then
1450:
1451: IF p_uom_class NOT IN ('Weight','Volume')
1452: THEN

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

1445:
1446: BEGIN
1447:
1448: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
1449: if qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then
1450:
1451: IF p_uom_class NOT IN ('Weight','Volume')
1452: THEN
1453: IF l_debug = FND_API.G_TRUE THEN

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

1534: x_count NUMBER;
1535:
1536: BEGIN
1537:
1538: if qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then
1539:
1540: l_shippable_flag := 'N';
1541:
1542: begin

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

1632: WHERE cust_account_id = cust_id_in;
1633:
1634: BEGIN
1635:
1636: if qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then
1637:
1638: G_Customer_Info.customer_id := p_cust_id;
1639:
1640: -- Getting info from HZ_CUST_ACCOUNTS