DBA Data[Home] [Help]

APPS.AS_FUND_CONTACTS_PKG dependencies on AS_FUND_CONTACTS

Line 1: PACKAGE BODY AS_FUND_CONTACTS_PKG AS

1: PACKAGE BODY AS_FUND_CONTACTS_PKG AS
2: /* $Header: asxiffcb.pls 115.4 2002/11/06 00:41:09 appldev ship $ */
3: -- Start of Comments
4: -- Package name : AS_FUND_CONTACTS_PKG
5:

Line 4: -- Package name : AS_FUND_CONTACTS_PKG

1: PACKAGE BODY AS_FUND_CONTACTS_PKG AS
2: /* $Header: asxiffcb.pls 115.4 2002/11/06 00:41:09 appldev ship $ */
3: -- Start of Comments
4: -- Package name : AS_FUND_CONTACTS_PKG
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AS_FUND_CONTACTS_PKG';
7: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asxiffcb.pls';
8:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AS_FUND_CONTACTS_PKG';

2: /* $Header: asxiffcb.pls 115.4 2002/11/06 00:41:09 appldev ship $ */
3: -- Start of Comments
4: -- Package name : AS_FUND_CONTACTS_PKG
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AS_FUND_CONTACTS_PKG';
7: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asxiffcb.pls';
8:
9: PROCEDURE insert_row(
10: p_row_id IN OUT VARCHAR2,

Line 39: INSERT INTO AS_FUND_CONTACTS (

35:
36: BEGIN
37:
38: -- throw exception if data is null???
39: INSERT INTO AS_FUND_CONTACTS (
40: fund_id,
41: party_id,
42: contact_role_code,
43: last_update_date,

Line 119: UPDATE AS_FUND_CONTACTS SET

115: p_attribute15 IN VARCHAR2) IS
116:
117: BEGIN
118:
119: UPDATE AS_FUND_CONTACTS SET
120: fund_id = p_fund_id,
121: party_id = p_party_id,
122: contact_role_code = DECODE(p_contact_role_code, FND_API.G_MISS_CHAR, contact_role_code, p_contact_role_code),
123: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, last_update_date, p_last_update_date),

Line 161: DELETE FROM AS_FUND_CONTACTS

157:
158: BEGIN
159:
160: -- throw exception if data is null??
161: DELETE FROM AS_FUND_CONTACTS
162: WHERE fund_id = p_fund_id
163: AND party_id = p_party_id;
164:
165: IF (SQL%NOTFOUND) THEN

Line 205: END AS_FUND_CONTACTS_PKG;

201: END IF;
202:
203: END lock_row;
204: */
205: END AS_FUND_CONTACTS_PKG;