APPS.ASO_FREIGHT_CHARGES_PKG dependencies on ASO_FREIGHT_CHARGES

Line 1: PACKAGE BODY ASO_FREIGHT_CHARGES_PKG as

1: PACKAGE BODY ASO_FREIGHT_CHARGES_PKG as
2: /* $Header: asotfchb.pls 120.1 2005/06/29 12:38:49 appldev ship $ */
3: -- Start of Comments
4: -- Package name : ASO_FREIGHT_CHARGES_PKG
5: -- Purpose :

Line 4: -- Package name : ASO_FREIGHT_CHARGES_PKG

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

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_FREIGHT_CHARGES_PKG';

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

Line 46: CURSOR C2 IS SELECT ASO_FREIGHT_CHARGES_S.nextval FROM sys.dual;

42: p_ATTRIBUTE14 VARCHAR2,
43: p_ATTRIBUTE15 VARCHAR2)
44:
45: IS
46: CURSOR C2 IS SELECT ASO_FREIGHT_CHARGES_S.nextval FROM sys.dual;
47: BEGIN
48: If (px_FREIGHT_CHARGE_ID IS NULL) OR (px_FREIGHT_CHARGE_ID = FND_API.G_MISS_NUM) then
49: OPEN C2;
50: FETCH C2 INTO px_FREIGHT_CHARGE_ID;

Line 53: INSERT INTO ASO_FREIGHT_CHARGES(

49: OPEN C2;
50: FETCH C2 INTO px_FREIGHT_CHARGE_ID;
51: CLOSE C2;
52: End If;
53: INSERT INTO ASO_FREIGHT_CHARGES(
54: FREIGHT_CHARGE_ID,
55: CREATION_DATE,
56: CREATED_BY,
57: LAST_UPDATE_DATE,

Line 148: Update ASO_FREIGHT_CHARGES

144: p_ATTRIBUTE15 VARCHAR2)
145:
146: IS
147: BEGIN
148: Update ASO_FREIGHT_CHARGES
149: SET
150: /* CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
151: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),*/
152: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

Line 189: DELETE FROM ASO_FREIGHT_CHARGES

185: PROCEDURE Delete_Row(
186: p_FREIGHT_CHARGE_ID NUMBER)
187: IS
188: BEGIN
189: DELETE FROM ASO_FREIGHT_CHARGES
190: WHERE FREIGHT_CHARGE_ID = p_FREIGHT_CHARGE_ID;
191: If (SQL%NOTFOUND) then
192: RAISE NO_DATA_FOUND;
193: End If;

Line 200: DELETE FROM ASO_FREIGHT_CHARGES

196: PROCEDURE Delete_Row(
197: p_QUOTE_LINE_ID NUMBER)
198: IS
199: BEGIN
200: DELETE FROM ASO_FREIGHT_CHARGES
201: WHERE quote_shipment_id in
202: (select shipment_id from ASO_SHIPMENTS
203: where QUOTE_LINE_ID = p_quote_line_id);
204: If (SQL%NOTFOUND) then

Line 271: FROM ASO_FREIGHT_CHARGES

267: ATTRIBUTE12,
268: ATTRIBUTE13,
269: ATTRIBUTE14,
270: ATTRIBUTE15
271: FROM ASO_FREIGHT_CHARGES
272: WHERE FREIGHT_CHARGE_ID = p_FREIGHT_CHARGE_ID
273: FOR UPDATE of FREIGHT_CHARGE_ID NOWAIT;
274: Recinfo C%ROWTYPE;
275: BEGIN

Line 383: End ASO_FREIGHT_CHARGES_PKG;

379: APP_EXCEPTION.RAISE_EXCEPTION;
380: End If;
381: END Lock_Row;
382:
383: End ASO_FREIGHT_CHARGES_PKG;