[Home] [Help]
PACKAGE: APPS.CN_SRP_PAYOUT_DTLS_PKG
Source
1 PACKAGE CN_SRP_PAYOUT_DTLS_PKG AUTHID CURRENT_USER AS
2 -- $Header: cntmdtls.pls 115.0 2003/08/25 21:52:01 nkodkani noship $
3 -- +======================================================================|
4 -- | Copyright (c) 2000 Oracle Corporation |
5 -- | Redwood Shores, California, USA |
6 -- | All rights reserved. |
7 -- | Package Name |
8 -- | CN_SRP_PAYOUT_DTLS_pkg |
9 -- | Purpose |
10 -- | This is the table handler for cn_srp_payout_dtls table; it takes |
11 -- | care of the insert, update and delete on the table. Refer high level|
12 -- | design documentation for the business perspective. |
13 -- | |
14 -- |History |
15 -- | 06-JUN-2001 sbadami Created |
16 -- +======================================================================|
17 PROCEDURE insert_row
18 (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
19 p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
20 p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE := NULL,
21 p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
22 p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
23 p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
24 p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
25 p_percent IN cn_srp_payout_dtls.percent%TYPE,
26 p_payout IN cn_srp_payout_dtls.payout%TYPE,
27 p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
28 p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
29 p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
30 p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
31 p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
32 p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
33 p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
34 p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
35 p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
36 p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
37 p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
38 p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
39 p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
40 p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
41 p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
42 p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
43 p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
44 p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,
45 p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE := NULL,
46 p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE := NULL,
47 p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE := NULL);
48
49 PROCEDURE update_row
50 (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
51 p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
52 p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE :=NULL,
53 p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
54 p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
55 p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
56 p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
57 p_percent IN cn_srp_payout_dtls.percent%TYPE,
58 p_payout IN cn_srp_payout_dtls.payout%TYPE,
59 p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
60 p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
61 p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
62 p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
63 p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
64 p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
65 p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
66 p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
67 p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
68 p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
69 p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
70 p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
71 p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
72 p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
73 p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
74 p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
75 p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,
76 p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE,
77 p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE,
78 p_object_version_number IN cn_srp_payout_dtls.object_version_number%TYPE);
79
80 PROCEDURE delete_row
81 (p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE);
82
83 END CN_SRP_payout_dtlS_pkg;