APPS.IBE_SH_QUOTE_ACCESS_PKG dependencies on IBE_SH_QUOTE_ACCESS

Line 1: PACKAGE BODY IBE_SH_QUOTE_ACCESS_PKG as

1: PACKAGE BODY IBE_SH_QUOTE_ACCESS_PKG as
2: /* $Header: IBEVSCSB.pls 115.3 2003/01/30 03:29:33 mannamra ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_SH_QUOTE_ACCESS_PVT';
5:

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

1: PACKAGE BODY IBE_SH_QUOTE_ACCESS_PKG as
2: /* $Header: IBEVSCSB.pls 115.3 2003/01/30 03:29:33 mannamra ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_SH_QUOTE_ACCESS_PVT';
5:
6: PROCEDURE Insert_Row
7: (
8: p_quote_sharee_id IN NUMBER := FND_API.G_MISS_NUM,

Line 34: INSERT INTO IBE_SH_QUOTE_ACCESS (

30: IS
31:
32: BEGIN
33:
34: INSERT INTO IBE_SH_QUOTE_ACCESS (
35: QUOTE_SHAREE_ID ,
36: REQUEST_ID ,
37: PROGRAM_APPLICATION_ID ,
38: PROGRAM_ID ,

Line 136: UPDATE IBE_SH_QUOTE_ACCESS

132: IS
133:
134: BEGIN
135:
136: UPDATE IBE_SH_QUOTE_ACCESS
137: SET
138: -- QUOTE_SHAREE_ID = decode(p_QUOTE_SHAREE_ID,FND_API.G_MISS_NUM,QUOTE_SHAREE_ID, p_QUOTE_SHAREE_ID),
139: REQUEST_ID = decode(p_REQUEST_ID,FND_API.G_MISS_NUM,REQUEST_ID, p_REQUEST_ID),
140: PROGRAM_APPLICATION_ID = decode(p_PROGRAM_APPLICATION_ID,FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,

Line 187: DELETE FROM IBE_SH_QUOTE_ACCESS

183: IS
184:
185: BEGIN
186:
187: DELETE FROM IBE_SH_QUOTE_ACCESS
188: WHERE quote_header_id = p_quote_header_id
189: and party_id = p_party_id
190: and cust_account_id = p_cust_account_id;
191:

Line 200: END IBE_SH_QUOTE_ACCESS_PKG;

196: END Delete_Row;
197:
198:
199:
200: END IBE_SH_QUOTE_ACCESS_PKG;