DBA Data[Home] [Help]

APPS.OZF_CHARGEBACK_PVT dependencies on QP_PREQ_PUB

Line 1445: l_is_error := p_line_tbl(i).pricing_status_code <> QP_PREQ_PUB.G_STATUS_NEW AND

1441:
1442: -- LOOP through the result to find if there is an error in the result.
1443: FOR i in 1..p_line_tbl.LAST
1444: LOOP
1445: l_is_error := p_line_tbl(i).pricing_status_code <> QP_PREQ_PUB.G_STATUS_NEW AND
1446: p_line_tbl(i).pricing_status_code <> QP_PREQ_PUB.G_STATUS_UNCHANGED AND
1447: p_line_tbl(i).pricing_status_code <> QP_PREQ_PUB.G_STATUS_UPDATED;
1448: IF OZF_DEBUG_LOW_ON THEN
1449: OZF_UTILITY_PVT.debug_message('pricing status code ' || p_line_tbl(i).pricing_status_code);

Line 1446: p_line_tbl(i).pricing_status_code <> QP_PREQ_PUB.G_STATUS_UNCHANGED AND

1442: -- LOOP through the result to find if there is an error in the result.
1443: FOR i in 1..p_line_tbl.LAST
1444: LOOP
1445: l_is_error := p_line_tbl(i).pricing_status_code <> QP_PREQ_PUB.G_STATUS_NEW AND
1446: p_line_tbl(i).pricing_status_code <> QP_PREQ_PUB.G_STATUS_UNCHANGED AND
1447: p_line_tbl(i).pricing_status_code <> QP_PREQ_PUB.G_STATUS_UPDATED;
1448: IF OZF_DEBUG_LOW_ON THEN
1449: OZF_UTILITY_PVT.debug_message('pricing status code ' || p_line_tbl(i).pricing_status_code);
1450: END IF;

Line 1447: p_line_tbl(i).pricing_status_code <> QP_PREQ_PUB.G_STATUS_UPDATED;

1443: FOR i in 1..p_line_tbl.LAST
1444: LOOP
1445: l_is_error := p_line_tbl(i).pricing_status_code <> QP_PREQ_PUB.G_STATUS_NEW AND
1446: p_line_tbl(i).pricing_status_code <> QP_PREQ_PUB.G_STATUS_UNCHANGED AND
1447: p_line_tbl(i).pricing_status_code <> QP_PREQ_PUB.G_STATUS_UPDATED;
1448: IF OZF_DEBUG_LOW_ON THEN
1449: OZF_UTILITY_PVT.debug_message('pricing status code ' || p_line_tbl(i).pricing_status_code);
1450: END IF;
1451:

Line 1579: l_pricing_error := p_line_tbl(i).pricing_status_code <> QP_PREQ_PUB.G_STATUS_NEW AND

1575: -- FOR each chargeback of the line, we will UPDATE the line
1576: --//Bugfix : 12719436 - added logic for l_pricing_error
1577: FOR i in 1..p_line_tbl.LAST LOOP
1578: l_pricing_error := FALSE;
1579: l_pricing_error := p_line_tbl(i).pricing_status_code <> QP_PREQ_PUB.G_STATUS_NEW AND
1580: p_line_tbl(i).pricing_status_code <> QP_PREQ_PUB.G_STATUS_UNCHANGED AND
1581: p_line_tbl(i).pricing_status_code <> QP_PREQ_PUB.G_STATUS_UPDATED;
1582:
1583: IF p_line_tbl(i).line_type_code = 'LINE' AND NOT l_pricing_error THEN

Line 1580: p_line_tbl(i).pricing_status_code <> QP_PREQ_PUB.G_STATUS_UNCHANGED AND

1576: --//Bugfix : 12719436 - added logic for l_pricing_error
1577: FOR i in 1..p_line_tbl.LAST LOOP
1578: l_pricing_error := FALSE;
1579: l_pricing_error := p_line_tbl(i).pricing_status_code <> QP_PREQ_PUB.G_STATUS_NEW AND
1580: p_line_tbl(i).pricing_status_code <> QP_PREQ_PUB.G_STATUS_UNCHANGED AND
1581: p_line_tbl(i).pricing_status_code <> QP_PREQ_PUB.G_STATUS_UPDATED;
1582:
1583: IF p_line_tbl(i).line_type_code = 'LINE' AND NOT l_pricing_error THEN
1584: OPEN OZF_RESALE_COMMON_PVT.g_interface_rec_csr(p_line_tbl(i).chargeback_int_id);

Line 1581: p_line_tbl(i).pricing_status_code <> QP_PREQ_PUB.G_STATUS_UPDATED;

1577: FOR i in 1..p_line_tbl.LAST LOOP
1578: l_pricing_error := FALSE;
1579: l_pricing_error := p_line_tbl(i).pricing_status_code <> QP_PREQ_PUB.G_STATUS_NEW AND
1580: p_line_tbl(i).pricing_status_code <> QP_PREQ_PUB.G_STATUS_UNCHANGED AND
1581: p_line_tbl(i).pricing_status_code <> QP_PREQ_PUB.G_STATUS_UPDATED;
1582:
1583: IF p_line_tbl(i).line_type_code = 'LINE' AND NOT l_pricing_error THEN
1584: OPEN OZF_RESALE_COMMON_PVT.g_interface_rec_csr(p_line_tbl(i).chargeback_int_id);
1585: FETCH OZF_RESALE_COMMON_PVT.g_interface_rec_csr INTO l_resale_int_rec;