APPS.ASO_PRICE_ADJUSTMENTS_PKG dependencies on ASO_PRICE_ADJUSTMENTS

Line 1: PACKAGE BODY ASO_PRICE_ADJUSTMENTS_PKG as

1: PACKAGE BODY ASO_PRICE_ADJUSTMENTS_PKG as
2: /* $Header: asotpadb.pls 120.1 2005/06/29 12:39:37 appldev ship $ */
3: -- Start of Comments
4: -- Package name : ASO_PRICE_ADJUSTMENTS_PKG
5: -- Purpose :

Line 4: -- Package name : ASO_PRICE_ADJUSTMENTS_PKG

1: PACKAGE BODY ASO_PRICE_ADJUSTMENTS_PKG as
2: /* $Header: asotpadb.pls 120.1 2005/06/29 12:39:37 appldev ship $ */
3: -- Start of Comments
4: -- Package name : ASO_PRICE_ADJUSTMENTS_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 12: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_PRICE_ADJUSTMENTS_PKG';

8: -- End of Comments
9:
10:
11:
12: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_PRICE_ADJUSTMENTS_PKG';
13: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asotpadb.pls';
14:
15: PROCEDURE Insert_Row(
16: px_PRICE_ADJUSTMENT_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 111: CURSOR C2 IS SELECT ASO_PRICE_ADJUSTMENTS_S.nextval FROM sys.dual;

107: p_ADJUSTED_AMOUNT_PER_PQTY NUMBER := NULL,
108: p_OBJECT_VERSION_NUMBER NUMBER)
109:
110: IS
111: CURSOR C2 IS SELECT ASO_PRICE_ADJUSTMENTS_S.nextval FROM sys.dual;
112: BEGIN
113: If (px_PRICE_ADJUSTMENT_ID IS NULL) OR (px_PRICE_ADJUSTMENT_ID = FND_API.G_MISS_NUM) then
114: OPEN C2;
115: FETCH C2 INTO px_PRICE_ADJUSTMENT_ID;

Line 118: INSERT INTO ASO_PRICE_ADJUSTMENTS(

114: OPEN C2;
115: FETCH C2 INTO px_PRICE_ADJUSTMENT_ID;
116: CLOSE C2;
117: End If;
118: INSERT INTO ASO_PRICE_ADJUSTMENTS(
119: PRICE_ADJUSTMENT_ID,
120: CREATION_DATE,
121: CREATED_BY,
122: LAST_UPDATE_DATE,

Line 402: Update ASO_PRICE_ADJUSTMENTS

398: )
399:
400: IS
401: BEGIN
402: Update ASO_PRICE_ADJUSTMENTS
403: SET
404: /* CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
405: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),*/
406: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

Line 504: DELETE FROM ASO_PRICE_ADJUSTMENTS

500: PROCEDURE Delete_Row(
501: p_PRICE_ADJUSTMENT_ID NUMBER)
502: IS
503: BEGIN
504: DELETE FROM ASO_PRICE_ADJUSTMENTS
505: WHERE PRICE_ADJUSTMENT_ID = p_PRICE_ADJUSTMENT_ID;
506: If (SQL%NOTFOUND) then
507: RAISE NO_DATA_FOUND;
508: End If;

Line 524: -- delete from aso_price adjustments the id and the related id

520: If (SQL%NOTFOUND) then
521: null;
522: End If;
523:
524: -- delete from aso_price adjustments the id and the related id
525: DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS
526: WHERE PRICE_ADJUSTMENT_ID = p_PRICE_ADJ_ID
527: OR RLTD_PRICE_ADJ_ID = p_PRICE_ADJ_ID;
528: If (SQL%NOTFOUND) then

Line 533: -- delete from aso_price_adjustments

529: null;
530: End If;
531:
532:
533: -- delete from aso_price_adjustments
534:
535: DELETE FROM ASO_PRICE_ADJUSTMENTS
536: WHERE PRICE_ADJUSTMENT_ID = p_PRICE_ADJ_ID;
537: If (SQL%NOTFOUND) then

Line 535: DELETE FROM ASO_PRICE_ADJUSTMENTS

531:
532:
533: -- delete from aso_price_adjustments
534:
535: DELETE FROM ASO_PRICE_ADJUSTMENTS
536: WHERE PRICE_ADJUSTMENT_ID = p_PRICE_ADJ_ID;
537: If (SQL%NOTFOUND) then
538: null;
539: RAISE NO_DATA_FOUND;

Line 552: FROM aso_price_adjustments

548:
549:
550: Cursor C_line_adj(l_quote_line_id NUMBER) IS
551: SELECT price_adjustment_id
552: FROM aso_price_adjustments
553: where quote_line_id = l_quote_line_id;
554:
555: Cursor C_shipment_adj(l_quote_shipment_id NUMBER) IS
556: SELECT price_adjustment_id

Line 557: FROM aso_price_adjustments

553: where quote_line_id = l_quote_line_id;
554:
555: Cursor C_shipment_adj(l_quote_shipment_id NUMBER) IS
556: SELECT price_adjustment_id
557: FROM aso_price_adjustments
558: where quote_shipment_id = l_quote_shipment_id;
559:
560: BEGIN
561:

Line 766: FROM ASO_PRICE_ADJUSTMENTS

762: CHANGE_SEQUENCE,
763: LIST_HEADER_ID,
764: LIST_LINE_ID,
765: quote_shipment_id
766: FROM ASO_PRICE_ADJUSTMENTS
767: WHERE PRICE_ADJUSTMENT_ID = p_PRICE_ADJUSTMENT_ID
768: FOR UPDATE of PRICE_ADJUSTMENT_ID NOWAIT;
769: Recinfo C%ROWTYPE;
770: BEGIN

Line 1038: End ASO_PRICE_ADJUSTMENTS_PKG;

1034: APP_EXCEPTION.RAISE_EXCEPTION;
1035: End If;
1036: END Lock_Row;
1037:
1038: End ASO_PRICE_ADJUSTMENTS_PKG;