[Home] [Help]
PACKAGE: APPS.CN_PAYMENT_WORKSHEETS_PKG
Source
1 PACKAGE cn_payment_worksheets_pkg AUTHID CURRENT_USER AS
2 -- $Header: cntwkshs.pls 120.4 2005/09/24 14:11:25 fmburu ship $
3
4 --============================================================================
5 -- Procedure Name : Insert_Record
6 -- Purpose : Insert a Record in CN_PAYMENT_WORKSHEETS
7 --============================================================================
8 PROCEDURE INSERT_RECORD (
9 x_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE := NULL,
10 x_payrun_id cn_payment_worksheets.payrun_id%TYPE,
11 x_salesrep_id cn_payment_worksheets.salesrep_id%TYPE,
12 x_quota_id cn_payment_worksheets.quota_id%TYPE := NULL,
13 x_cost_center_id cn_payment_worksheets.cost_center_id%TYPE := NULL,
14 x_role_id cn_payment_worksheets.role_id%TYPE := NULL,
15 x_credit_type_id cn_payment_worksheets.credit_type_id%TYPE,
16 x_calc_pmt_amount cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
17 x_adj_pmt_amount_rec cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
18 x_adj_pmt_amount_nrec cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
19 x_adj_pmt_amount cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
20 x_held_amount cn_payment_worksheets.held_amount%TYPE := 0,
21 x_pmt_amount_recovery cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
22 x_comm_paid cn_payment_worksheets.draw_ptd%TYPE := 0,
23 x_bonus_paid cn_payment_worksheets.draw_ptd%TYPE := 0,
24 x_draw_paid cn_payment_worksheets.draw_ptd%TYPE := 0,
25 x_comm_nrec cn_payment_worksheets.draw_ptd%TYPE := 0,
26 x_created_by cn_payment_worksheets.created_by%TYPE,
27 x_creation_date cn_payment_worksheets.creation_date%TYPE,
28 x_worksheet_status cn_payment_worksheets.worksheet_status%TYPE,
29 p_org_id cn_payment_worksheets.org_id%TYPE,
30 p_object_version_number cn_payment_worksheets.object_version_number%TYPE
31 );
32
33 --============================================================================
34 -- Procedure Name : Lock_Record
35 -- Purpose : Lock Recor
36 --============================================================================
37 PROCEDURE LOCK_RECORD (
38 x_payment_worksheet_id NUMBER
39 );
40
41 --============================================================================
42 -- Procedure Name : Update_Record
43 -- Purpose : Update Record
44 --============================================================================
45 PROCEDURE UPDATE_RECORD (
46 x_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE,
47 x_payrun_id cn_payment_worksheets.payrun_id%TYPE := cn_api.g_miss_id,
48 x_salesrep_id cn_payment_worksheets.salesrep_id%TYPE := cn_api.g_miss_id,
49 x_cost_center_id cn_payment_worksheets.cost_center_id%TYPE := cn_api.g_miss_id,
50 x_role_id cn_payment_worksheets.role_id%TYPE := cn_api.g_miss_id,
51 x_credit_type_id cn_payment_worksheets.credit_type_id%TYPE := cn_api.g_miss_id,
52 x_returned_funds_flag cn_payment_worksheets.returned_funds_flag%TYPE := '~',
53 x_post_subledger_flag cn_payment_worksheets.post_subledger_flag%TYPE := '~',
54 x_pay_cap cn_payment_worksheets.pay_cap%TYPE := fnd_api.g_miss_num,
55 x_minimum_amount cn_payment_worksheets.minimum_amount%TYPE := fnd_api.g_miss_num,
56 x_comm_due_bb cn_payment_worksheets.comm_due_bb%TYPE := fnd_api.g_miss_num,
57 x_comm_ptd cn_payment_worksheets.comm_ptd%TYPE := fnd_api.g_miss_num,
58 x_draw_paid cn_payment_worksheets.draw_paid%TYPE := fnd_api.g_miss_num,
59 x_comm_nrec cn_payment_worksheets.comm_nrec%TYPE := fnd_api.g_miss_num,
60 x_comm_draw cn_payment_worksheets.comm_draw%TYPE := fnd_api.g_miss_num,
61 x_comm_paid cn_payment_worksheets.comm_paid%TYPE := fnd_api.g_miss_num,
62 x_reg_bonus_due_bb cn_payment_worksheets.reg_bonus_due_bb%TYPE := fnd_api.g_miss_num,
63 x_reg_bonus_ptd cn_payment_worksheets.reg_bonus_ptd%TYPE := fnd_api.g_miss_num,
64 x_reg_bonus_rec cn_payment_worksheets.reg_bonus_rec%TYPE := fnd_api.g_miss_num,
65 x_reg_bonus_to_rec cn_payment_worksheets.reg_bonus_to_rec%TYPE := fnd_api.g_miss_num,
66 x_reg_bonus_paid cn_payment_worksheets.reg_bonus_paid%TYPE := fnd_api.g_miss_num,
67 x_bonus_due_bb cn_payment_worksheets.bonus_due_bb%TYPE := fnd_api.g_miss_num,
68 x_bonus_ptd cn_payment_worksheets.bonus_ptd%TYPE := fnd_api.g_miss_num,
69 x_bonus_paid cn_payment_worksheets.bonus_paid%TYPE := fnd_api.g_miss_num,
70 x_payee_comm_due_bb cn_payment_worksheets.payee_comm_due_bb%TYPE := fnd_api.g_miss_num,
71 x_payee_comm_ptd cn_payment_worksheets.payee_comm_ptd%TYPE := fnd_api.g_miss_num,
72 x_payee_comm_paid cn_payment_worksheets.payee_comm_paid%TYPE := fnd_api.g_miss_num,
73 x_payee_bonus_due_bb cn_payment_worksheets.payee_bonus_due_bb%TYPE := fnd_api.g_miss_num,
74 x_payee_bonus_ptd cn_payment_worksheets.payee_bonus_ptd%TYPE := fnd_api.g_miss_num,
75 x_payee_bonus_paid cn_payment_worksheets.payee_bonus_paid%TYPE := fnd_api.g_miss_num,
76 x_convert_to_type_id cn_payment_worksheets.convert_to_type_id%TYPE := cn_api.g_miss_id,
77 x_credit_conv_fct_id cn_payment_worksheets.credit_conv_fct_id%TYPE := cn_api.g_miss_id,
78 x_convert_to_paid cn_payment_worksheets.convert_to_paid%TYPE := fnd_api.g_miss_num,
79 x_reviewed_by_analyst cn_payment_worksheets_all.reviewed_by_analyst%TYPE := fnd_api.g_miss_char,
80 x_analyst_notes cn_payment_worksheets_all.analyst_notes%TYPE := fnd_api.g_miss_char,
81 x_posting_status cn_payment_worksheets.posting_status%TYPE := fnd_api.g_miss_char,
82 x_draw_recoverable_begin cn_payment_worksheets.draw_recoverable_begin%TYPE := fnd_api.g_miss_num,
83 x_adjust_paid cn_payment_worksheets.adjust_paid%TYPE := fnd_api.g_miss_num,
84 x_bonus_draw cn_payment_worksheets.bonus_draw%TYPE := fnd_api.g_miss_num,
85 x_reason cn_payment_worksheets.reason%TYPE := fnd_api.g_miss_char,
86 x_bonus_reason cn_payment_worksheets.bonus_reason%TYPE := fnd_api.g_miss_char,
87 x_recovery_method cn_payment_worksheets.recovery_method%TYPE := fnd_api.g_miss_char,
88 x_draw_ptd cn_payment_worksheets.draw_ptd%TYPE := fnd_api.g_miss_num,
89 x_bonus_given cn_payment_worksheets.bonus_given%TYPE := fnd_api.g_miss_num,
90 x_guarantee cn_payment_worksheets.guarantee%TYPE := fnd_api.g_miss_num,
91 x_worksheet_status cn_payment_worksheets.worksheet_status%TYPE := fnd_api.g_miss_char,
92 x_last_update_date cn_payment_worksheets.last_update_date%TYPE,
93 x_last_updated_by cn_payment_worksheets.last_updated_by%TYPE,
94 x_last_update_login cn_payment_worksheets.last_update_login%TYPE
95 );
96
97 --============================================================================
98 -- Procedure Name : Update_Record
99 -- Purpose : Update the Payment Worksheets ( batch Update )
100 -- : Called from Payment Transactions cnvpmtrb.pls
101 --============================================================================
102 PROCEDURE UPDATE_RECORD (
103 p_salesrep_id NUMBER,
104 p_payrun_id NUMBER,
105 p_quota_id NUMBER,
106 p_pmt_amount_calc NUMBER := 0,
107 p_pmt_amount_adj_rec NUMBER := 0,
108 p_pmt_amount_adj_nrec NUMBER := 0,
109 p_pmt_amount_recovery NUMBER := 0,
110 p_pmt_amount_adj NUMBER := 0,
111 x_object_version_number OUT NOCOPY cn_payment_worksheets.object_version_number%TYPE
112 );
113
114 --============================================================================
115 -- Procedure Name : Update_Record
116 -- Purpose : Update the Payment Worksheets ( batch Update )
117 -- : Called from Update Worksheets
118 --============================================================================
119 PROCEDURE UPDATE_STATUS (
120 p_salesrep_id NUMBER,
121 p_payrun_id NUMBER,
122 p_worksheet_status VARCHAR2
123 );
124
125 --============================================================================
126 -- Procedure Name : Delete_Record ( Batch Operation )
127 -- Purpose : Delete Worksheet
128 -- Description : Delete all the Worksheet for the Given salesrep_id and
129 -- Payrun_id
130 --============================================================================
131 PROCEDURE DELETE_RECORD (
132 p_payrun_id NUMBER,
133 p_salesrep_id NUMBER
134 );
135
136 --============================================================================
137 -- Procedure Name : Delete_Record
138 -- Purpose : Delete Worksheet
139 --============================================================================
140 PROCEDURE DELETE_RECORD (
141 x_payment_worksheet_id NUMBER
142 );
143
144
145 END cn_payment_worksheets_pkg;