APPS.OZF_DISC_LINE_PKG dependencies on OZF_OFFER_DISCOUNT_LINES

Line 95: INSERT INTO ozf_offer_discount_lines(

91:
92: px_object_version_number := nvl(px_object_version_number, 1);
93:
94:
95: INSERT INTO ozf_offer_discount_lines(
96: offer_discount_line_id,
97: parent_discount_line_id,
98: volume_from,
99: volume_to,

Line 260: INSERT INTO ozf_offer_discount_lines(

256:
257: px_object_version_number := nvl(px_object_version_number, 1);
258:
259:
260: INSERT INTO ozf_offer_discount_lines(
261: offer_discount_line_id,
262: parent_discount_line_id,
263: volume_from,
264: volume_to,

Line 422: Update ozf_offer_discount_lines

418: p_offer_id NUMBER)
419:
420: IS
421: BEGIN
422: Update ozf_offer_discount_lines
423: SET
424: offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id),
425: parent_discount_line_id = DECODE( p_parent_discount_line_id, null, parent_discount_line_id, FND_API.G_MISS_NUM, null, p_parent_discount_line_id),
426: volume_from = DECODE( p_volume_from, null, volume_from, FND_API.G_MISS_NUM, null, p_volume_from),

Line 540: Update ozf_offer_discount_lines

536: p_formula_id NUMBER)
537:
538: IS
539: BEGIN
540: Update ozf_offer_discount_lines
541: SET
542: offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id),
543: parent_discount_line_id = DECODE( p_parent_discount_line_id, null, parent_discount_line_id, FND_API.G_MISS_NUM, null, p_parent_discount_line_id),
544: volume_from = DECODE( p_volume_from, null, volume_from, FND_API.G_MISS_NUM, null, p_volume_from),

Line 616: DELETE FROM ozf_offer_discount_lines

612: p_offer_discount_line_id NUMBER,
613: p_object_version_number NUMBER)
614: IS
615: BEGIN
616: DELETE FROM ozf_offer_discount_lines
617: WHERE offer_discount_line_id = p_offer_discount_line_id
618: AND object_version_number = p_object_version_number;
619: If (SQL%NOTFOUND) then
620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 630: DELETE FROM ozf_offer_discount_lines WHERE parent_discount_line_id = p_offer_discount_line_id;

626:
627: PROCEDURE delete_tiers(p_offer_discount_line_id NUMBER)
628: IS
629: BEGIN
630: DELETE FROM ozf_offer_discount_lines WHERE parent_discount_line_id = p_offer_discount_line_id;
631:
632: If (SQL%NOTFOUND) then
633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
634: End If;

Line 655: FROM ozf_offer_discount_lines

651: p_object_version_number NUMBER)
652: IS
653: CURSOR C IS
654: SELECT *
655: FROM ozf_offer_discount_lines
656: WHERE offer_discount_line_id = p_offer_discount_line_id
657: AND object_version_number = p_object_version_number
658: FOR UPDATE OF offer_discount_line_id NOWAIT;
659: Recinfo C%ROWTYPE;