DBA Data[Home] [Help]

APPS.AS_INTEREST_PUB dependencies on AS_INTEREST_PUB

Line 1: PACKAGE BODY AS_INTEREST_PUB as

1: PACKAGE BODY AS_INTEREST_PUB as
2: /* $Header: asxpintb.pls 120.2 2005/08/04 22:16:45 appldev ship $ */
3:
4: --
5: -- NAME

Line 6: -- AS_INTEREST_PUB

2: /* $Header: asxpintb.pls 120.2 2005/08/04 22:16:45 appldev ship $ */
3:
4: --
5: -- NAME
6: -- AS_INTEREST_PUB
7: --
8: -- PURPOSE
9: -- Provide public interest record and table type to be used by APIs that
10: -- import interests/classifications into OSM

Line 32: G_PKG_NAME CONSTANT VARCHAR2(30):='AS_INTEREST_PUB';

28: -- Changed interest rec default value NULL to
29: -- FND_API.G_MISS for update purpose
30: --
31: --
32: G_PKG_NAME CONSTANT VARCHAR2(30):='AS_INTEREST_PUB';
33: G_FILE_NAME CONSTANT VARCHAR2(12):='asxpintb.pls';
34:
35: --------------------------------Public Routines-------------------------------------
36:

Line 279: l_interest_tbl as_interest_pub.interest_tbl_type;

275: l_rowid ROWID;
276: l_interest_id NUMBER;
277: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
278: l_interest_rec as_interest_pvt.interest_rec_type;
279: l_interest_tbl as_interest_pub.interest_tbl_type;
280: l_pvt_interest_tbl as_interest_pvt.interest_tbl_type;
281: l_mode constant varchar2(30) := 'ON-UPDATE';
282: l_lead_id NUMBER;
283: l_address_id NUMBER;

Line 1107: END AS_INTEREST_PUB;

1103: End delete_interest;
1104:
1105:
1106:
1107: END AS_INTEREST_PUB;