1 PACKAGE CN_WKSHT_BONUS_PKG AUTHID CURRENT_USER AS
2 /* $Header: cntwbons.pls 115.4 2001/10/29 17:17:24 pkm ship $ */
3 --
4 -- Package Name
5 -- CN_WKSHT_BONUS_PKG
6 -- Purpose
7 -- Table Handler for CN_WORKSHEET_BONUSES
8 -- FORM CNSBPS
9 -- BLOCK BONUSES
10 --
11 -- History
12 -- 26-May-99 Renu Chintalapati Created
13
14 --/*-------------------------------------------------------------------------*
15 -- Procedure Name
16 -- Insert_row
17 -- Purpose
18 -- Main insert procedure
19 -- *-------------------------------------------------------------------------*/
20 PROCEDURE insert_row
21 (x_payrun_id IN NUMBER
22 ,x_salesrep_id IN NUMBER
23 ,x_quota_id IN NUMBER
24 ,x_comp_plan_id IN NUMBER
25 ,x_amount IN NUMBER
26 ,x_srp_plan_assign_id IN NUMBER
27 ,x_payment_worksheet_id IN NUMBER
28 ,x_created_by IN NUMBER
29 ,x_creation_date IN DATE
30 );
31
32 -- /*-------------------------------------------------------------------------*
33 -- Procedure Name
34 -- Lock_row
35 -- Purpose
36 -- Lock db row after form record is changed
37 -- Notes
38 -- Only called from the form
39 -- *-------------------------------------------------------------------------*/
40 PROCEDURE lock_row
41 ( x_payment_worksheet_id IN NUMBER
42 ,x_quota_id IN NUMBER
43 ,x_comp_plan_id IN NUMBER
44 );
45
46 -- /*-------------------------------------------------------------------------*
47 -- Procedure Name
48 -- Update Record
49 -- Purpose
50 -- To Update the Srp Payment Plan Assign
51 --
52 -- *-------------------------------------------------------------------------*/
53 PROCEDURE update_row (
54 x_payment_worksheet_id NUMBER
55 ,x_quota_id NUMBER
56 ,x_comp_plan_id NUMBER
57 ,x_amount NUMBER := fnd_api.g_miss_num
58 ,x_last_updated_by NUMBER
59 ,x_last_update_login NUMBER
60 ,x_last_update_date DATE
61 );
62
63 --/*-------------------------------------------------------------------------*
64 -- Procedure Name
65 -- Delete_row
66 -- Purpose
67 -- Delete the Srp Payment Plan Assign
68 --*-------------------------------------------------------------------------*/
69 PROCEDURE Delete_row( x_payment_worksheet_id NUMBER );
70
71 END CN_WKSHT_BONUS_PKG;