APPS.ASO_QUOTE_PARTIES_PKG dependencies on ASO_QUOTE_PARTIES

Line 1: PACKAGE BODY ASO_QUOTE_PARTIES_PKG as

1: PACKAGE BODY ASO_QUOTE_PARTIES_PKG as
2: /* $Header: asotqptb.pls 120.0 2005/05/31 12:03:26 appldev noship $ */
3: -- Start of Comments
4: -- Package name : ASO_QUOTE_PARTIES_PKG
5: -- Purpose :

Line 4: -- Package name : ASO_QUOTE_PARTIES_PKG

1: PACKAGE BODY ASO_QUOTE_PARTIES_PKG as
2: /* $Header: asotqptb.pls 120.0 2005/05/31 12:03:26 appldev noship $ */
3: -- Start of Comments
4: -- Package name : ASO_QUOTE_PARTIES_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_QUOTE_PARTIES_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asotqptb.pls';
13:
14: PROCEDURE Insert_Row(
15: px_QUOTE_PARTY_ID IN OUT NOCOPY NUMBER,

Line 53: CURSOR C2 IS SELECT ASO_QUOTE_PARTIES_S.nextval FROM sys.dual;

49: )
50: -- p_SECURITY_GROUP_ID NUMBER,
51:
52: IS
53: CURSOR C2 IS SELECT ASO_QUOTE_PARTIES_S.nextval FROM sys.dual;
54: BEGIN
55: If (px_QUOTE_PARTY_ID IS NULL) OR (px_QUOTE_PARTY_ID = FND_API.G_MISS_NUM) then
56: OPEN C2;
57: FETCH C2 INTO px_QUOTE_PARTY_ID;

Line 60: INSERT INTO ASO_QUOTE_PARTIES(

56: OPEN C2;
57: FETCH C2 INTO px_QUOTE_PARTY_ID;
58: CLOSE C2;
59: End If;
60: INSERT INTO ASO_QUOTE_PARTIES(
61: QUOTE_PARTY_ID,
62: CREATION_DATE,
63: CREATED_BY,
64: LAST_UPDATE_DATE,

Line 175: Update ASO_QUOTE_PARTIES

171: -- p_SECURITY_GROUP_ID NUMBER,
172:
173: IS
174: BEGIN
175: Update ASO_QUOTE_PARTIES
176: SET
177: /* CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
178: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),*/
179: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

Line 222: DELETE FROM ASO_QUOTE_PARTIES

218: PROCEDURE Delete_Row(
219: p_QUOTE_PARTY_ID NUMBER)
220: IS
221: BEGIN
222: DELETE FROM ASO_QUOTE_PARTIES
223: WHERE QUOTE_PARTY_ID = p_QUOTE_PARTY_ID;
224: If (SQL%NOTFOUND) then
225: RAISE NO_DATA_FOUND;
226: End If;

Line 304: FROM ASO_QUOTE_PARTIES

300: ATTRIBUTE13,
301: ATTRIBUTE14,
302: ATTRIBUTE15
303: -- SECURITY_GROUP_ID,
304: FROM ASO_QUOTE_PARTIES
305: WHERE QUOTE_PARTY_ID = p_QUOTE_PARTY_ID
306: FOR UPDATE of QUOTE_PARTY_ID NOWAIT;
307: Recinfo C%ROWTYPE;
308: BEGIN

Line 442: DELETE FROM ASO_QUOTE_PARTIES

438: PROCEDURE Delete_Row(
439: p_QUOTE_LINE_ID NUMBER)
440: IS
441: BEGIN
442: DELETE FROM ASO_QUOTE_PARTIES
443: WHERE QUOTE_LINE_ID = p_QUOTE_LINE_ID;
444: If (SQL%NOTFOUND) then
445: null;
446: End If;

Line 453: DELETE FROM ASO_QUOTE_PARTIES

449: PROCEDURE Delete_Row(
450: p_QUOTE_HEADER_ID NUMBER)
451: IS
452: BEGIN
453: DELETE FROM ASO_QUOTE_PARTIES
454: WHERE QUOTE_HEADER_ID = p_QUOTE_HEADER_ID;
455: If (SQL%NOTFOUND) then
456: null;
457: End If;

Line 464: DELETE FROM ASO_QUOTE_PARTIES

460: PROCEDURE Delete_Row(
461: p_QUOTE_SHIPMENT_ID NUMBER)
462: IS
463: BEGIN
464: DELETE FROM ASO_QUOTE_PARTIES
465: WHERE QUOTE_SHIPMENT_ID = p_QUOTE_SHIPMENT_ID;
466: If (SQL%NOTFOUND) then
467: null;
468: End If;

Line 473: End ASO_QUOTE_PARTIES_PKG;

469: END;
470:
471:
472:
473: End ASO_QUOTE_PARTIES_PKG;