1 PACKAGE CSC_CUSTOMIZED_PLANS_PKG AUTHID CURRENT_USER as
2 /* $Header: csctcups.pls 115.14 2002/11/25 06:10:09 bhroy ship $ */
3 -- Start of Comments
4 -- Package name : CSC_CUSTOMIZED_PLANS_PKG
5 -- Purpose : Table handler package to insert and delete rows from
6 -- CSC_CUSTOMIZED_PLANS table.
7 -- History :
8 -- DD-MM-YYYY NAME MODIFICATIONS
9 -- 11-04-1999 dejoseph Created.
10 -- 12-08-1999 dejoseph 'Arcs'ed in for first code freeze.
11 -- 12-21-1999 dejoseph 'Arcs'ed in for second code freeze.
12 -- 01-03-2000 dejoseph 'Arcs'ed in for third code freeze. (10-JAN-2000)
13 -- 01-31-2000 dejoseph 'Arcs'ed in for fourth code freeze. (07-FEB-2000)
14 -- 02-13-2000 dejoseph 'Arcs'ed on for fifth code freeze. (21-FEB-2000)
15 -- 02-28-2000 dejoseph 'Arcs'ed on for sixth code freeze. (06-MAR-2000)
16 -- 04-10-2000 dejoseph Removed reference to cust_account_org in lieu of TCA's
17 -- decision to drop column org_id from hz_cust_accounts.
18 -- 02-07-2001 dejoseph Added parameters to the insert_row procedures to record
19 -- ac/party merge concurrent request information.
20 -- 08-29-2001 dejoseph Removed parameter party_status from procedure insert_row. This
21 -- column does not exist in the database. The merge status will
22 -- be determined from PLAN_STATUS_CODE.
23
24 -- 11-12-2002 bhroy NOCOPY changes made
25 -- 11-25-2002 bhroy FND_API default changes made, added check file comments and WHENEVER OSERROR EXIT FAILURE ROLLBACK
26
27 -- NOTE :
28 -- End of Comments
29
30 PROCEDURE Insert_Row(
31 px_ID IN OUT NOCOPY NUMBER,
32 p_plan_id IN NUMBER,
33 p_party_id IN NUMBER,
34 p_cust_account_id IN NUMBER := NULL,
35 p_request_id IN NUMBER := NULL,
36 p_program_application_id IN NUMBER := NULL,
37 p_program_id IN NUMBER := NULL,
38 p_program_update_date IN DATE := NULL,
39 p_plan_status_code IN VARCHAR2 := NULL);
40
41
42 -- For the delete row any one of the parameters should be specified.
43 PROCEDURE Delete_Row(
44 p_ID IN NUMBER := NULL,
45 p_plan_id IN NUMBER := NULL,
46 p_party_id IN NUMBER := NULL);
47
48 End CSC_CUSTOMIZED_PLANS_PKG;