APPS.ASO_CHANGED_QUOTES_PKG dependencies on ASO_CHANGED_QUOTES

Line 1: PACKAGE BODY ASO_CHANGED_QUOTES_PKG AS

1: PACKAGE BODY ASO_CHANGED_QUOTES_PKG AS
2: /* $Header: asotcqtb.pls 120.0 2005/08/29 23:54:05 gsachdev noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_CHANGED_QUOTES_PKG';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asotcqtb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_CHANGED_QUOTES_PKG';

1: PACKAGE BODY ASO_CHANGED_QUOTES_PKG AS
2: /* $Header: asotcqtb.pls 120.0 2005/08/29 23:54:05 gsachdev noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_CHANGED_QUOTES_PKG';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asotcqtb.pls';
6:
7: procedure INSERT_ROW (
8: P_QUOTE_NUMBER IN NUMBER,

Line 23: insert into ASO_CHANGED_QUOTES (

19: )
20: IS
21:
22: BEGIN
23: insert into ASO_CHANGED_QUOTES (
24: QUOTE_NUMBER,
25: LAST_UPDATE_DATE,
26: LAST_UPDATED_BY,
27: CREATION_DATE,

Line 67: update ASO_CHANGED_QUOTES

63: P_CONC_REQUEST_ID IN NUMBER
64: )
65: IS
66: BEGIN
67: update ASO_CHANGED_QUOTES
68: set
69: QUOTE_NUMBER = decode( P_QUOTE_NUMBER, FND_API.G_MISS_NUM, QUOTE_NUMBER, P_QUOTE_NUMBER),
70: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
71: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

Line 91: delete from ASO_CHANGED_QUOTES

87: P_QUOTE_NUMBER IN NUMBER,
88: P_CONC_REQUEST_ID IN NUMBER
89: ) is
90: begin
91: delete from ASO_CHANGED_QUOTES
92: where QUOTE_NUMBER = P_QUOTE_NUMBER
93: and CONC_REQUEST_ID = P_CONC_REQUEST_ID;
94:
95: if (sql%notfound) then

Line 127: from ASO_CHANGED_QUOTES

123: PROGRAM_APPLICATION_ID,
124: PROGRAM_ID,
125: PROGRAM_UPDATE_DATE,
126: CONC_REQUEST_ID
127: from ASO_CHANGED_QUOTES
128: where QUOTE_NUMBER = P_QUOTE_NUMBER
129: for update of CONC_REQUEST_ID nowait;
130:
131: recinfo C1%ROWTYPE;

Line 153: end ASO_CHANGED_QUOTES_PKG;

149: app_exception.raise_exception;
150: end if;
151: end LOCK_ROW;
152:
153: end ASO_CHANGED_QUOTES_PKG;