1: PACKAGE BODY cn_payment_worksheets_pkg AS
2: -- $Header: cntwkshb.pls 120.4 2005/09/24 14:11:13 fmburu ship $
3:
4: --============================================================================
5: -- Procedure Name : Insert_Record
6: -- Purpose : Main insert procedure
7: -- Called from : cn_prepost_pvt
8: --============================================================================
9: PROCEDURE INSERT_RECORD (
10: x_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE := NULL,
11: x_payrun_id cn_payment_worksheets.payrun_id%TYPE,
12: x_salesrep_id cn_payment_worksheets.salesrep_id%TYPE,
13: x_quota_id cn_payment_worksheets.quota_id%TYPE := NULL,
14: x_cost_center_id cn_payment_worksheets.cost_center_id%TYPE := NULL,
7: -- Called from : cn_prepost_pvt
8: --============================================================================
9: PROCEDURE INSERT_RECORD (
10: x_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE := NULL,
11: x_payrun_id cn_payment_worksheets.payrun_id%TYPE,
12: x_salesrep_id cn_payment_worksheets.salesrep_id%TYPE,
13: x_quota_id cn_payment_worksheets.quota_id%TYPE := NULL,
14: x_cost_center_id cn_payment_worksheets.cost_center_id%TYPE := NULL,
15: x_role_id cn_payment_worksheets.role_id%TYPE := NULL,
8: --============================================================================
9: PROCEDURE INSERT_RECORD (
10: x_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE := NULL,
11: x_payrun_id cn_payment_worksheets.payrun_id%TYPE,
12: x_salesrep_id cn_payment_worksheets.salesrep_id%TYPE,
13: x_quota_id cn_payment_worksheets.quota_id%TYPE := NULL,
14: x_cost_center_id cn_payment_worksheets.cost_center_id%TYPE := NULL,
15: x_role_id cn_payment_worksheets.role_id%TYPE := NULL,
16: x_credit_type_id cn_payment_worksheets.credit_type_id%TYPE,
9: PROCEDURE INSERT_RECORD (
10: x_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE := NULL,
11: x_payrun_id cn_payment_worksheets.payrun_id%TYPE,
12: x_salesrep_id cn_payment_worksheets.salesrep_id%TYPE,
13: x_quota_id cn_payment_worksheets.quota_id%TYPE := NULL,
14: x_cost_center_id cn_payment_worksheets.cost_center_id%TYPE := NULL,
15: x_role_id cn_payment_worksheets.role_id%TYPE := NULL,
16: x_credit_type_id cn_payment_worksheets.credit_type_id%TYPE,
17: x_calc_pmt_amount cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
10: x_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE := NULL,
11: x_payrun_id cn_payment_worksheets.payrun_id%TYPE,
12: x_salesrep_id cn_payment_worksheets.salesrep_id%TYPE,
13: x_quota_id cn_payment_worksheets.quota_id%TYPE := NULL,
14: x_cost_center_id cn_payment_worksheets.cost_center_id%TYPE := NULL,
15: x_role_id cn_payment_worksheets.role_id%TYPE := NULL,
16: x_credit_type_id cn_payment_worksheets.credit_type_id%TYPE,
17: x_calc_pmt_amount cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
18: x_adj_pmt_amount_rec cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
11: x_payrun_id cn_payment_worksheets.payrun_id%TYPE,
12: x_salesrep_id cn_payment_worksheets.salesrep_id%TYPE,
13: x_quota_id cn_payment_worksheets.quota_id%TYPE := NULL,
14: x_cost_center_id cn_payment_worksheets.cost_center_id%TYPE := NULL,
15: x_role_id cn_payment_worksheets.role_id%TYPE := NULL,
16: x_credit_type_id cn_payment_worksheets.credit_type_id%TYPE,
17: x_calc_pmt_amount cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
18: x_adj_pmt_amount_rec cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
19: x_adj_pmt_amount_nrec cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
12: x_salesrep_id cn_payment_worksheets.salesrep_id%TYPE,
13: x_quota_id cn_payment_worksheets.quota_id%TYPE := NULL,
14: x_cost_center_id cn_payment_worksheets.cost_center_id%TYPE := NULL,
15: x_role_id cn_payment_worksheets.role_id%TYPE := NULL,
16: x_credit_type_id cn_payment_worksheets.credit_type_id%TYPE,
17: x_calc_pmt_amount cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
18: x_adj_pmt_amount_rec cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
19: x_adj_pmt_amount_nrec cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
20: x_adj_pmt_amount cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
13: x_quota_id cn_payment_worksheets.quota_id%TYPE := NULL,
14: x_cost_center_id cn_payment_worksheets.cost_center_id%TYPE := NULL,
15: x_role_id cn_payment_worksheets.role_id%TYPE := NULL,
16: x_credit_type_id cn_payment_worksheets.credit_type_id%TYPE,
17: x_calc_pmt_amount cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
18: x_adj_pmt_amount_rec cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
19: x_adj_pmt_amount_nrec cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
20: x_adj_pmt_amount cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
21: x_held_amount cn_payment_worksheets.held_amount%TYPE := 0,
14: x_cost_center_id cn_payment_worksheets.cost_center_id%TYPE := NULL,
15: x_role_id cn_payment_worksheets.role_id%TYPE := NULL,
16: x_credit_type_id cn_payment_worksheets.credit_type_id%TYPE,
17: x_calc_pmt_amount cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
18: x_adj_pmt_amount_rec cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
19: x_adj_pmt_amount_nrec cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
20: x_adj_pmt_amount cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
21: x_held_amount cn_payment_worksheets.held_amount%TYPE := 0,
22: x_pmt_amount_recovery cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
15: x_role_id cn_payment_worksheets.role_id%TYPE := NULL,
16: x_credit_type_id cn_payment_worksheets.credit_type_id%TYPE,
17: x_calc_pmt_amount cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
18: x_adj_pmt_amount_rec cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
19: x_adj_pmt_amount_nrec cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
20: x_adj_pmt_amount cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
21: x_held_amount cn_payment_worksheets.held_amount%TYPE := 0,
22: x_pmt_amount_recovery cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
23: x_comm_paid cn_payment_worksheets.draw_ptd%TYPE := 0,
16: x_credit_type_id cn_payment_worksheets.credit_type_id%TYPE,
17: x_calc_pmt_amount cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
18: x_adj_pmt_amount_rec cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
19: x_adj_pmt_amount_nrec cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
20: x_adj_pmt_amount cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
21: x_held_amount cn_payment_worksheets.held_amount%TYPE := 0,
22: x_pmt_amount_recovery cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
23: x_comm_paid cn_payment_worksheets.draw_ptd%TYPE := 0,
24: x_bonus_paid cn_payment_worksheets.draw_ptd%TYPE := 0,
17: x_calc_pmt_amount cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
18: x_adj_pmt_amount_rec cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
19: x_adj_pmt_amount_nrec cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
20: x_adj_pmt_amount cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
21: x_held_amount cn_payment_worksheets.held_amount%TYPE := 0,
22: x_pmt_amount_recovery cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
23: x_comm_paid cn_payment_worksheets.draw_ptd%TYPE := 0,
24: x_bonus_paid cn_payment_worksheets.draw_ptd%TYPE := 0,
25: x_draw_paid cn_payment_worksheets.draw_ptd%TYPE := 0,
18: x_adj_pmt_amount_rec cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
19: x_adj_pmt_amount_nrec cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
20: x_adj_pmt_amount cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
21: x_held_amount cn_payment_worksheets.held_amount%TYPE := 0,
22: x_pmt_amount_recovery cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
23: x_comm_paid cn_payment_worksheets.draw_ptd%TYPE := 0,
24: x_bonus_paid cn_payment_worksheets.draw_ptd%TYPE := 0,
25: x_draw_paid cn_payment_worksheets.draw_ptd%TYPE := 0,
26: x_comm_nrec cn_payment_worksheets.draw_ptd%TYPE := 0,
19: x_adj_pmt_amount_nrec cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
20: x_adj_pmt_amount cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
21: x_held_amount cn_payment_worksheets.held_amount%TYPE := 0,
22: x_pmt_amount_recovery cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
23: x_comm_paid cn_payment_worksheets.draw_ptd%TYPE := 0,
24: x_bonus_paid cn_payment_worksheets.draw_ptd%TYPE := 0,
25: x_draw_paid cn_payment_worksheets.draw_ptd%TYPE := 0,
26: x_comm_nrec cn_payment_worksheets.draw_ptd%TYPE := 0,
27: x_created_by cn_payment_worksheets.created_by%TYPE,
20: x_adj_pmt_amount cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
21: x_held_amount cn_payment_worksheets.held_amount%TYPE := 0,
22: x_pmt_amount_recovery cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
23: x_comm_paid cn_payment_worksheets.draw_ptd%TYPE := 0,
24: x_bonus_paid cn_payment_worksheets.draw_ptd%TYPE := 0,
25: x_draw_paid cn_payment_worksheets.draw_ptd%TYPE := 0,
26: x_comm_nrec cn_payment_worksheets.draw_ptd%TYPE := 0,
27: x_created_by cn_payment_worksheets.created_by%TYPE,
28: x_creation_date cn_payment_worksheets.creation_date%TYPE,
21: x_held_amount cn_payment_worksheets.held_amount%TYPE := 0,
22: x_pmt_amount_recovery cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
23: x_comm_paid cn_payment_worksheets.draw_ptd%TYPE := 0,
24: x_bonus_paid cn_payment_worksheets.draw_ptd%TYPE := 0,
25: x_draw_paid cn_payment_worksheets.draw_ptd%TYPE := 0,
26: x_comm_nrec cn_payment_worksheets.draw_ptd%TYPE := 0,
27: x_created_by cn_payment_worksheets.created_by%TYPE,
28: x_creation_date cn_payment_worksheets.creation_date%TYPE,
29: x_worksheet_status cn_payment_worksheets.worksheet_status%TYPE,
22: x_pmt_amount_recovery cn_payment_worksheets.pmt_amount_calc%TYPE := 0,
23: x_comm_paid cn_payment_worksheets.draw_ptd%TYPE := 0,
24: x_bonus_paid cn_payment_worksheets.draw_ptd%TYPE := 0,
25: x_draw_paid cn_payment_worksheets.draw_ptd%TYPE := 0,
26: x_comm_nrec cn_payment_worksheets.draw_ptd%TYPE := 0,
27: x_created_by cn_payment_worksheets.created_by%TYPE,
28: x_creation_date cn_payment_worksheets.creation_date%TYPE,
29: x_worksheet_status cn_payment_worksheets.worksheet_status%TYPE,
30: p_org_id cn_payment_worksheets.org_id%TYPE,
23: x_comm_paid cn_payment_worksheets.draw_ptd%TYPE := 0,
24: x_bonus_paid cn_payment_worksheets.draw_ptd%TYPE := 0,
25: x_draw_paid cn_payment_worksheets.draw_ptd%TYPE := 0,
26: x_comm_nrec cn_payment_worksheets.draw_ptd%TYPE := 0,
27: x_created_by cn_payment_worksheets.created_by%TYPE,
28: x_creation_date cn_payment_worksheets.creation_date%TYPE,
29: x_worksheet_status cn_payment_worksheets.worksheet_status%TYPE,
30: p_org_id cn_payment_worksheets.org_id%TYPE,
31: p_object_version_number cn_payment_worksheets.object_version_number%TYPE
24: x_bonus_paid cn_payment_worksheets.draw_ptd%TYPE := 0,
25: x_draw_paid cn_payment_worksheets.draw_ptd%TYPE := 0,
26: x_comm_nrec cn_payment_worksheets.draw_ptd%TYPE := 0,
27: x_created_by cn_payment_worksheets.created_by%TYPE,
28: x_creation_date cn_payment_worksheets.creation_date%TYPE,
29: x_worksheet_status cn_payment_worksheets.worksheet_status%TYPE,
30: p_org_id cn_payment_worksheets.org_id%TYPE,
31: p_object_version_number cn_payment_worksheets.object_version_number%TYPE
32: )
25: x_draw_paid cn_payment_worksheets.draw_ptd%TYPE := 0,
26: x_comm_nrec cn_payment_worksheets.draw_ptd%TYPE := 0,
27: x_created_by cn_payment_worksheets.created_by%TYPE,
28: x_creation_date cn_payment_worksheets.creation_date%TYPE,
29: x_worksheet_status cn_payment_worksheets.worksheet_status%TYPE,
30: p_org_id cn_payment_worksheets.org_id%TYPE,
31: p_object_version_number cn_payment_worksheets.object_version_number%TYPE
32: )
33: IS
26: x_comm_nrec cn_payment_worksheets.draw_ptd%TYPE := 0,
27: x_created_by cn_payment_worksheets.created_by%TYPE,
28: x_creation_date cn_payment_worksheets.creation_date%TYPE,
29: x_worksheet_status cn_payment_worksheets.worksheet_status%TYPE,
30: p_org_id cn_payment_worksheets.org_id%TYPE,
31: p_object_version_number cn_payment_worksheets.object_version_number%TYPE
32: )
33: IS
34: BEGIN
27: x_created_by cn_payment_worksheets.created_by%TYPE,
28: x_creation_date cn_payment_worksheets.creation_date%TYPE,
29: x_worksheet_status cn_payment_worksheets.worksheet_status%TYPE,
30: p_org_id cn_payment_worksheets.org_id%TYPE,
31: p_object_version_number cn_payment_worksheets.object_version_number%TYPE
32: )
33: IS
34: BEGIN
35: INSERT INTO cn_payment_worksheets
31: p_object_version_number cn_payment_worksheets.object_version_number%TYPE
32: )
33: IS
34: BEGIN
35: INSERT INTO cn_payment_worksheets
36: (payment_worksheet_id,
37: payrun_id,
38: salesrep_id,
39: cost_center_id,
56: --R12
57: org_id,
58: object_version_number
59: )
60: VALUES (NVL (x_payment_worksheet_id, cn_payment_worksheets_s.NEXTVAL),
61: x_payrun_id,
62: x_salesrep_id,
63: x_cost_center_id,
64: x_quota_id,
94: IS
95: CURSOR c
96: IS
97: SELECT *
98: FROM cn_payment_worksheets
99: WHERE payment_worksheet_id = x_payment_worksheet_id
100: FOR UPDATE OF payment_worksheet_id NOWAIT;
101:
102: recinfo c%ROWTYPE;
129: -- Procedure Name : Update Record
130: -- Purpose : To Update the Payment worksheet
131: --============================================================================
132: PROCEDURE UPDATE_RECORD (
133: x_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE,
134: x_payrun_id cn_payment_worksheets.payrun_id%TYPE := cn_api.g_miss_id,
135: x_salesrep_id cn_payment_worksheets.salesrep_id%TYPE := cn_api.g_miss_id,
136: x_cost_center_id cn_payment_worksheets.cost_center_id%TYPE := cn_api.g_miss_id,
137: x_role_id cn_payment_worksheets.role_id%TYPE := cn_api.g_miss_id,
130: -- Purpose : To Update the Payment worksheet
131: --============================================================================
132: PROCEDURE UPDATE_RECORD (
133: x_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE,
134: x_payrun_id cn_payment_worksheets.payrun_id%TYPE := cn_api.g_miss_id,
135: x_salesrep_id cn_payment_worksheets.salesrep_id%TYPE := cn_api.g_miss_id,
136: x_cost_center_id cn_payment_worksheets.cost_center_id%TYPE := cn_api.g_miss_id,
137: x_role_id cn_payment_worksheets.role_id%TYPE := cn_api.g_miss_id,
138: x_credit_type_id cn_payment_worksheets.credit_type_id%TYPE := cn_api.g_miss_id,
131: --============================================================================
132: PROCEDURE UPDATE_RECORD (
133: x_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE,
134: x_payrun_id cn_payment_worksheets.payrun_id%TYPE := cn_api.g_miss_id,
135: x_salesrep_id cn_payment_worksheets.salesrep_id%TYPE := cn_api.g_miss_id,
136: x_cost_center_id cn_payment_worksheets.cost_center_id%TYPE := cn_api.g_miss_id,
137: x_role_id cn_payment_worksheets.role_id%TYPE := cn_api.g_miss_id,
138: x_credit_type_id cn_payment_worksheets.credit_type_id%TYPE := cn_api.g_miss_id,
139: x_returned_funds_flag cn_payment_worksheets.returned_funds_flag%TYPE := '~',
132: PROCEDURE UPDATE_RECORD (
133: x_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE,
134: x_payrun_id cn_payment_worksheets.payrun_id%TYPE := cn_api.g_miss_id,
135: x_salesrep_id cn_payment_worksheets.salesrep_id%TYPE := cn_api.g_miss_id,
136: x_cost_center_id cn_payment_worksheets.cost_center_id%TYPE := cn_api.g_miss_id,
137: x_role_id cn_payment_worksheets.role_id%TYPE := cn_api.g_miss_id,
138: x_credit_type_id cn_payment_worksheets.credit_type_id%TYPE := cn_api.g_miss_id,
139: x_returned_funds_flag cn_payment_worksheets.returned_funds_flag%TYPE := '~',
140: x_post_subledger_flag cn_payment_worksheets.post_subledger_flag%TYPE := '~',
133: x_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE,
134: x_payrun_id cn_payment_worksheets.payrun_id%TYPE := cn_api.g_miss_id,
135: x_salesrep_id cn_payment_worksheets.salesrep_id%TYPE := cn_api.g_miss_id,
136: x_cost_center_id cn_payment_worksheets.cost_center_id%TYPE := cn_api.g_miss_id,
137: x_role_id cn_payment_worksheets.role_id%TYPE := cn_api.g_miss_id,
138: x_credit_type_id cn_payment_worksheets.credit_type_id%TYPE := cn_api.g_miss_id,
139: x_returned_funds_flag cn_payment_worksheets.returned_funds_flag%TYPE := '~',
140: x_post_subledger_flag cn_payment_worksheets.post_subledger_flag%TYPE := '~',
141: x_pay_cap cn_payment_worksheets.pay_cap%TYPE := fnd_api.g_miss_num,
134: x_payrun_id cn_payment_worksheets.payrun_id%TYPE := cn_api.g_miss_id,
135: x_salesrep_id cn_payment_worksheets.salesrep_id%TYPE := cn_api.g_miss_id,
136: x_cost_center_id cn_payment_worksheets.cost_center_id%TYPE := cn_api.g_miss_id,
137: x_role_id cn_payment_worksheets.role_id%TYPE := cn_api.g_miss_id,
138: x_credit_type_id cn_payment_worksheets.credit_type_id%TYPE := cn_api.g_miss_id,
139: x_returned_funds_flag cn_payment_worksheets.returned_funds_flag%TYPE := '~',
140: x_post_subledger_flag cn_payment_worksheets.post_subledger_flag%TYPE := '~',
141: x_pay_cap cn_payment_worksheets.pay_cap%TYPE := fnd_api.g_miss_num,
142: x_minimum_amount cn_payment_worksheets.minimum_amount%TYPE := fnd_api.g_miss_num,
135: x_salesrep_id cn_payment_worksheets.salesrep_id%TYPE := cn_api.g_miss_id,
136: x_cost_center_id cn_payment_worksheets.cost_center_id%TYPE := cn_api.g_miss_id,
137: x_role_id cn_payment_worksheets.role_id%TYPE := cn_api.g_miss_id,
138: x_credit_type_id cn_payment_worksheets.credit_type_id%TYPE := cn_api.g_miss_id,
139: x_returned_funds_flag cn_payment_worksheets.returned_funds_flag%TYPE := '~',
140: x_post_subledger_flag cn_payment_worksheets.post_subledger_flag%TYPE := '~',
141: x_pay_cap cn_payment_worksheets.pay_cap%TYPE := fnd_api.g_miss_num,
142: x_minimum_amount cn_payment_worksheets.minimum_amount%TYPE := fnd_api.g_miss_num,
143: x_comm_due_bb cn_payment_worksheets.comm_due_bb%TYPE := fnd_api.g_miss_num,
136: x_cost_center_id cn_payment_worksheets.cost_center_id%TYPE := cn_api.g_miss_id,
137: x_role_id cn_payment_worksheets.role_id%TYPE := cn_api.g_miss_id,
138: x_credit_type_id cn_payment_worksheets.credit_type_id%TYPE := cn_api.g_miss_id,
139: x_returned_funds_flag cn_payment_worksheets.returned_funds_flag%TYPE := '~',
140: x_post_subledger_flag cn_payment_worksheets.post_subledger_flag%TYPE := '~',
141: x_pay_cap cn_payment_worksheets.pay_cap%TYPE := fnd_api.g_miss_num,
142: x_minimum_amount cn_payment_worksheets.minimum_amount%TYPE := fnd_api.g_miss_num,
143: x_comm_due_bb cn_payment_worksheets.comm_due_bb%TYPE := fnd_api.g_miss_num,
144: x_comm_ptd cn_payment_worksheets.comm_ptd%TYPE := fnd_api.g_miss_num,
137: x_role_id cn_payment_worksheets.role_id%TYPE := cn_api.g_miss_id,
138: x_credit_type_id cn_payment_worksheets.credit_type_id%TYPE := cn_api.g_miss_id,
139: x_returned_funds_flag cn_payment_worksheets.returned_funds_flag%TYPE := '~',
140: x_post_subledger_flag cn_payment_worksheets.post_subledger_flag%TYPE := '~',
141: x_pay_cap cn_payment_worksheets.pay_cap%TYPE := fnd_api.g_miss_num,
142: x_minimum_amount cn_payment_worksheets.minimum_amount%TYPE := fnd_api.g_miss_num,
143: x_comm_due_bb cn_payment_worksheets.comm_due_bb%TYPE := fnd_api.g_miss_num,
144: x_comm_ptd cn_payment_worksheets.comm_ptd%TYPE := fnd_api.g_miss_num,
145: x_draw_paid cn_payment_worksheets.draw_paid%TYPE := fnd_api.g_miss_num,
138: x_credit_type_id cn_payment_worksheets.credit_type_id%TYPE := cn_api.g_miss_id,
139: x_returned_funds_flag cn_payment_worksheets.returned_funds_flag%TYPE := '~',
140: x_post_subledger_flag cn_payment_worksheets.post_subledger_flag%TYPE := '~',
141: x_pay_cap cn_payment_worksheets.pay_cap%TYPE := fnd_api.g_miss_num,
142: x_minimum_amount cn_payment_worksheets.minimum_amount%TYPE := fnd_api.g_miss_num,
143: x_comm_due_bb cn_payment_worksheets.comm_due_bb%TYPE := fnd_api.g_miss_num,
144: x_comm_ptd cn_payment_worksheets.comm_ptd%TYPE := fnd_api.g_miss_num,
145: x_draw_paid cn_payment_worksheets.draw_paid%TYPE := fnd_api.g_miss_num,
146: x_comm_nrec cn_payment_worksheets.comm_nrec%TYPE := fnd_api.g_miss_num,
139: x_returned_funds_flag cn_payment_worksheets.returned_funds_flag%TYPE := '~',
140: x_post_subledger_flag cn_payment_worksheets.post_subledger_flag%TYPE := '~',
141: x_pay_cap cn_payment_worksheets.pay_cap%TYPE := fnd_api.g_miss_num,
142: x_minimum_amount cn_payment_worksheets.minimum_amount%TYPE := fnd_api.g_miss_num,
143: x_comm_due_bb cn_payment_worksheets.comm_due_bb%TYPE := fnd_api.g_miss_num,
144: x_comm_ptd cn_payment_worksheets.comm_ptd%TYPE := fnd_api.g_miss_num,
145: x_draw_paid cn_payment_worksheets.draw_paid%TYPE := fnd_api.g_miss_num,
146: x_comm_nrec cn_payment_worksheets.comm_nrec%TYPE := fnd_api.g_miss_num,
147: x_comm_draw cn_payment_worksheets.comm_draw%TYPE := fnd_api.g_miss_num,
140: x_post_subledger_flag cn_payment_worksheets.post_subledger_flag%TYPE := '~',
141: x_pay_cap cn_payment_worksheets.pay_cap%TYPE := fnd_api.g_miss_num,
142: x_minimum_amount cn_payment_worksheets.minimum_amount%TYPE := fnd_api.g_miss_num,
143: x_comm_due_bb cn_payment_worksheets.comm_due_bb%TYPE := fnd_api.g_miss_num,
144: x_comm_ptd cn_payment_worksheets.comm_ptd%TYPE := fnd_api.g_miss_num,
145: x_draw_paid cn_payment_worksheets.draw_paid%TYPE := fnd_api.g_miss_num,
146: x_comm_nrec cn_payment_worksheets.comm_nrec%TYPE := fnd_api.g_miss_num,
147: x_comm_draw cn_payment_worksheets.comm_draw%TYPE := fnd_api.g_miss_num,
148: x_comm_paid cn_payment_worksheets.comm_paid%TYPE := fnd_api.g_miss_num,
141: x_pay_cap cn_payment_worksheets.pay_cap%TYPE := fnd_api.g_miss_num,
142: x_minimum_amount cn_payment_worksheets.minimum_amount%TYPE := fnd_api.g_miss_num,
143: x_comm_due_bb cn_payment_worksheets.comm_due_bb%TYPE := fnd_api.g_miss_num,
144: x_comm_ptd cn_payment_worksheets.comm_ptd%TYPE := fnd_api.g_miss_num,
145: x_draw_paid cn_payment_worksheets.draw_paid%TYPE := fnd_api.g_miss_num,
146: x_comm_nrec cn_payment_worksheets.comm_nrec%TYPE := fnd_api.g_miss_num,
147: x_comm_draw cn_payment_worksheets.comm_draw%TYPE := fnd_api.g_miss_num,
148: x_comm_paid cn_payment_worksheets.comm_paid%TYPE := fnd_api.g_miss_num,
149: x_reg_bonus_due_bb cn_payment_worksheets.reg_bonus_due_bb%TYPE := fnd_api.g_miss_num,
142: x_minimum_amount cn_payment_worksheets.minimum_amount%TYPE := fnd_api.g_miss_num,
143: x_comm_due_bb cn_payment_worksheets.comm_due_bb%TYPE := fnd_api.g_miss_num,
144: x_comm_ptd cn_payment_worksheets.comm_ptd%TYPE := fnd_api.g_miss_num,
145: x_draw_paid cn_payment_worksheets.draw_paid%TYPE := fnd_api.g_miss_num,
146: x_comm_nrec cn_payment_worksheets.comm_nrec%TYPE := fnd_api.g_miss_num,
147: x_comm_draw cn_payment_worksheets.comm_draw%TYPE := fnd_api.g_miss_num,
148: x_comm_paid cn_payment_worksheets.comm_paid%TYPE := fnd_api.g_miss_num,
149: x_reg_bonus_due_bb cn_payment_worksheets.reg_bonus_due_bb%TYPE := fnd_api.g_miss_num,
150: x_reg_bonus_ptd cn_payment_worksheets.reg_bonus_ptd%TYPE := fnd_api.g_miss_num,
143: x_comm_due_bb cn_payment_worksheets.comm_due_bb%TYPE := fnd_api.g_miss_num,
144: x_comm_ptd cn_payment_worksheets.comm_ptd%TYPE := fnd_api.g_miss_num,
145: x_draw_paid cn_payment_worksheets.draw_paid%TYPE := fnd_api.g_miss_num,
146: x_comm_nrec cn_payment_worksheets.comm_nrec%TYPE := fnd_api.g_miss_num,
147: x_comm_draw cn_payment_worksheets.comm_draw%TYPE := fnd_api.g_miss_num,
148: x_comm_paid cn_payment_worksheets.comm_paid%TYPE := fnd_api.g_miss_num,
149: x_reg_bonus_due_bb cn_payment_worksheets.reg_bonus_due_bb%TYPE := fnd_api.g_miss_num,
150: x_reg_bonus_ptd cn_payment_worksheets.reg_bonus_ptd%TYPE := fnd_api.g_miss_num,
151: x_reg_bonus_rec cn_payment_worksheets.reg_bonus_rec%TYPE := fnd_api.g_miss_num,
144: x_comm_ptd cn_payment_worksheets.comm_ptd%TYPE := fnd_api.g_miss_num,
145: x_draw_paid cn_payment_worksheets.draw_paid%TYPE := fnd_api.g_miss_num,
146: x_comm_nrec cn_payment_worksheets.comm_nrec%TYPE := fnd_api.g_miss_num,
147: x_comm_draw cn_payment_worksheets.comm_draw%TYPE := fnd_api.g_miss_num,
148: x_comm_paid cn_payment_worksheets.comm_paid%TYPE := fnd_api.g_miss_num,
149: x_reg_bonus_due_bb cn_payment_worksheets.reg_bonus_due_bb%TYPE := fnd_api.g_miss_num,
150: x_reg_bonus_ptd cn_payment_worksheets.reg_bonus_ptd%TYPE := fnd_api.g_miss_num,
151: x_reg_bonus_rec cn_payment_worksheets.reg_bonus_rec%TYPE := fnd_api.g_miss_num,
152: x_reg_bonus_to_rec cn_payment_worksheets.reg_bonus_to_rec%TYPE := fnd_api.g_miss_num,
145: x_draw_paid cn_payment_worksheets.draw_paid%TYPE := fnd_api.g_miss_num,
146: x_comm_nrec cn_payment_worksheets.comm_nrec%TYPE := fnd_api.g_miss_num,
147: x_comm_draw cn_payment_worksheets.comm_draw%TYPE := fnd_api.g_miss_num,
148: x_comm_paid cn_payment_worksheets.comm_paid%TYPE := fnd_api.g_miss_num,
149: x_reg_bonus_due_bb cn_payment_worksheets.reg_bonus_due_bb%TYPE := fnd_api.g_miss_num,
150: x_reg_bonus_ptd cn_payment_worksheets.reg_bonus_ptd%TYPE := fnd_api.g_miss_num,
151: x_reg_bonus_rec cn_payment_worksheets.reg_bonus_rec%TYPE := fnd_api.g_miss_num,
152: x_reg_bonus_to_rec cn_payment_worksheets.reg_bonus_to_rec%TYPE := fnd_api.g_miss_num,
153: x_reg_bonus_paid cn_payment_worksheets.reg_bonus_paid%TYPE := fnd_api.g_miss_num,
146: x_comm_nrec cn_payment_worksheets.comm_nrec%TYPE := fnd_api.g_miss_num,
147: x_comm_draw cn_payment_worksheets.comm_draw%TYPE := fnd_api.g_miss_num,
148: x_comm_paid cn_payment_worksheets.comm_paid%TYPE := fnd_api.g_miss_num,
149: x_reg_bonus_due_bb cn_payment_worksheets.reg_bonus_due_bb%TYPE := fnd_api.g_miss_num,
150: x_reg_bonus_ptd cn_payment_worksheets.reg_bonus_ptd%TYPE := fnd_api.g_miss_num,
151: x_reg_bonus_rec cn_payment_worksheets.reg_bonus_rec%TYPE := fnd_api.g_miss_num,
152: x_reg_bonus_to_rec cn_payment_worksheets.reg_bonus_to_rec%TYPE := fnd_api.g_miss_num,
153: x_reg_bonus_paid cn_payment_worksheets.reg_bonus_paid%TYPE := fnd_api.g_miss_num,
154: x_bonus_due_bb cn_payment_worksheets.bonus_due_bb%TYPE := fnd_api.g_miss_num,
147: x_comm_draw cn_payment_worksheets.comm_draw%TYPE := fnd_api.g_miss_num,
148: x_comm_paid cn_payment_worksheets.comm_paid%TYPE := fnd_api.g_miss_num,
149: x_reg_bonus_due_bb cn_payment_worksheets.reg_bonus_due_bb%TYPE := fnd_api.g_miss_num,
150: x_reg_bonus_ptd cn_payment_worksheets.reg_bonus_ptd%TYPE := fnd_api.g_miss_num,
151: x_reg_bonus_rec cn_payment_worksheets.reg_bonus_rec%TYPE := fnd_api.g_miss_num,
152: x_reg_bonus_to_rec cn_payment_worksheets.reg_bonus_to_rec%TYPE := fnd_api.g_miss_num,
153: x_reg_bonus_paid cn_payment_worksheets.reg_bonus_paid%TYPE := fnd_api.g_miss_num,
154: x_bonus_due_bb cn_payment_worksheets.bonus_due_bb%TYPE := fnd_api.g_miss_num,
155: x_bonus_ptd cn_payment_worksheets.bonus_ptd%TYPE := fnd_api.g_miss_num,
148: x_comm_paid cn_payment_worksheets.comm_paid%TYPE := fnd_api.g_miss_num,
149: x_reg_bonus_due_bb cn_payment_worksheets.reg_bonus_due_bb%TYPE := fnd_api.g_miss_num,
150: x_reg_bonus_ptd cn_payment_worksheets.reg_bonus_ptd%TYPE := fnd_api.g_miss_num,
151: x_reg_bonus_rec cn_payment_worksheets.reg_bonus_rec%TYPE := fnd_api.g_miss_num,
152: x_reg_bonus_to_rec cn_payment_worksheets.reg_bonus_to_rec%TYPE := fnd_api.g_miss_num,
153: x_reg_bonus_paid cn_payment_worksheets.reg_bonus_paid%TYPE := fnd_api.g_miss_num,
154: x_bonus_due_bb cn_payment_worksheets.bonus_due_bb%TYPE := fnd_api.g_miss_num,
155: x_bonus_ptd cn_payment_worksheets.bonus_ptd%TYPE := fnd_api.g_miss_num,
156: x_bonus_paid cn_payment_worksheets.bonus_paid%TYPE := fnd_api.g_miss_num,
149: x_reg_bonus_due_bb cn_payment_worksheets.reg_bonus_due_bb%TYPE := fnd_api.g_miss_num,
150: x_reg_bonus_ptd cn_payment_worksheets.reg_bonus_ptd%TYPE := fnd_api.g_miss_num,
151: x_reg_bonus_rec cn_payment_worksheets.reg_bonus_rec%TYPE := fnd_api.g_miss_num,
152: x_reg_bonus_to_rec cn_payment_worksheets.reg_bonus_to_rec%TYPE := fnd_api.g_miss_num,
153: x_reg_bonus_paid cn_payment_worksheets.reg_bonus_paid%TYPE := fnd_api.g_miss_num,
154: x_bonus_due_bb cn_payment_worksheets.bonus_due_bb%TYPE := fnd_api.g_miss_num,
155: x_bonus_ptd cn_payment_worksheets.bonus_ptd%TYPE := fnd_api.g_miss_num,
156: x_bonus_paid cn_payment_worksheets.bonus_paid%TYPE := fnd_api.g_miss_num,
157: x_payee_comm_due_bb cn_payment_worksheets.payee_comm_due_bb%TYPE := fnd_api.g_miss_num,
150: x_reg_bonus_ptd cn_payment_worksheets.reg_bonus_ptd%TYPE := fnd_api.g_miss_num,
151: x_reg_bonus_rec cn_payment_worksheets.reg_bonus_rec%TYPE := fnd_api.g_miss_num,
152: x_reg_bonus_to_rec cn_payment_worksheets.reg_bonus_to_rec%TYPE := fnd_api.g_miss_num,
153: x_reg_bonus_paid cn_payment_worksheets.reg_bonus_paid%TYPE := fnd_api.g_miss_num,
154: x_bonus_due_bb cn_payment_worksheets.bonus_due_bb%TYPE := fnd_api.g_miss_num,
155: x_bonus_ptd cn_payment_worksheets.bonus_ptd%TYPE := fnd_api.g_miss_num,
156: x_bonus_paid cn_payment_worksheets.bonus_paid%TYPE := fnd_api.g_miss_num,
157: x_payee_comm_due_bb cn_payment_worksheets.payee_comm_due_bb%TYPE := fnd_api.g_miss_num,
158: x_payee_comm_ptd cn_payment_worksheets.payee_comm_ptd%TYPE := fnd_api.g_miss_num,
151: x_reg_bonus_rec cn_payment_worksheets.reg_bonus_rec%TYPE := fnd_api.g_miss_num,
152: x_reg_bonus_to_rec cn_payment_worksheets.reg_bonus_to_rec%TYPE := fnd_api.g_miss_num,
153: x_reg_bonus_paid cn_payment_worksheets.reg_bonus_paid%TYPE := fnd_api.g_miss_num,
154: x_bonus_due_bb cn_payment_worksheets.bonus_due_bb%TYPE := fnd_api.g_miss_num,
155: x_bonus_ptd cn_payment_worksheets.bonus_ptd%TYPE := fnd_api.g_miss_num,
156: x_bonus_paid cn_payment_worksheets.bonus_paid%TYPE := fnd_api.g_miss_num,
157: x_payee_comm_due_bb cn_payment_worksheets.payee_comm_due_bb%TYPE := fnd_api.g_miss_num,
158: x_payee_comm_ptd cn_payment_worksheets.payee_comm_ptd%TYPE := fnd_api.g_miss_num,
159: x_payee_comm_paid cn_payment_worksheets.payee_comm_paid%TYPE := fnd_api.g_miss_num,
152: x_reg_bonus_to_rec cn_payment_worksheets.reg_bonus_to_rec%TYPE := fnd_api.g_miss_num,
153: x_reg_bonus_paid cn_payment_worksheets.reg_bonus_paid%TYPE := fnd_api.g_miss_num,
154: x_bonus_due_bb cn_payment_worksheets.bonus_due_bb%TYPE := fnd_api.g_miss_num,
155: x_bonus_ptd cn_payment_worksheets.bonus_ptd%TYPE := fnd_api.g_miss_num,
156: x_bonus_paid cn_payment_worksheets.bonus_paid%TYPE := fnd_api.g_miss_num,
157: x_payee_comm_due_bb cn_payment_worksheets.payee_comm_due_bb%TYPE := fnd_api.g_miss_num,
158: x_payee_comm_ptd cn_payment_worksheets.payee_comm_ptd%TYPE := fnd_api.g_miss_num,
159: x_payee_comm_paid cn_payment_worksheets.payee_comm_paid%TYPE := fnd_api.g_miss_num,
160: x_payee_bonus_due_bb cn_payment_worksheets.payee_bonus_due_bb%TYPE := fnd_api.g_miss_num,
153: x_reg_bonus_paid cn_payment_worksheets.reg_bonus_paid%TYPE := fnd_api.g_miss_num,
154: x_bonus_due_bb cn_payment_worksheets.bonus_due_bb%TYPE := fnd_api.g_miss_num,
155: x_bonus_ptd cn_payment_worksheets.bonus_ptd%TYPE := fnd_api.g_miss_num,
156: x_bonus_paid cn_payment_worksheets.bonus_paid%TYPE := fnd_api.g_miss_num,
157: x_payee_comm_due_bb cn_payment_worksheets.payee_comm_due_bb%TYPE := fnd_api.g_miss_num,
158: x_payee_comm_ptd cn_payment_worksheets.payee_comm_ptd%TYPE := fnd_api.g_miss_num,
159: x_payee_comm_paid cn_payment_worksheets.payee_comm_paid%TYPE := fnd_api.g_miss_num,
160: x_payee_bonus_due_bb cn_payment_worksheets.payee_bonus_due_bb%TYPE := fnd_api.g_miss_num,
161: x_payee_bonus_ptd cn_payment_worksheets.payee_bonus_ptd%TYPE := fnd_api.g_miss_num,
154: x_bonus_due_bb cn_payment_worksheets.bonus_due_bb%TYPE := fnd_api.g_miss_num,
155: x_bonus_ptd cn_payment_worksheets.bonus_ptd%TYPE := fnd_api.g_miss_num,
156: x_bonus_paid cn_payment_worksheets.bonus_paid%TYPE := fnd_api.g_miss_num,
157: x_payee_comm_due_bb cn_payment_worksheets.payee_comm_due_bb%TYPE := fnd_api.g_miss_num,
158: x_payee_comm_ptd cn_payment_worksheets.payee_comm_ptd%TYPE := fnd_api.g_miss_num,
159: x_payee_comm_paid cn_payment_worksheets.payee_comm_paid%TYPE := fnd_api.g_miss_num,
160: x_payee_bonus_due_bb cn_payment_worksheets.payee_bonus_due_bb%TYPE := fnd_api.g_miss_num,
161: x_payee_bonus_ptd cn_payment_worksheets.payee_bonus_ptd%TYPE := fnd_api.g_miss_num,
162: x_payee_bonus_paid cn_payment_worksheets.payee_bonus_paid%TYPE := fnd_api.g_miss_num,
155: x_bonus_ptd cn_payment_worksheets.bonus_ptd%TYPE := fnd_api.g_miss_num,
156: x_bonus_paid cn_payment_worksheets.bonus_paid%TYPE := fnd_api.g_miss_num,
157: x_payee_comm_due_bb cn_payment_worksheets.payee_comm_due_bb%TYPE := fnd_api.g_miss_num,
158: x_payee_comm_ptd cn_payment_worksheets.payee_comm_ptd%TYPE := fnd_api.g_miss_num,
159: x_payee_comm_paid cn_payment_worksheets.payee_comm_paid%TYPE := fnd_api.g_miss_num,
160: x_payee_bonus_due_bb cn_payment_worksheets.payee_bonus_due_bb%TYPE := fnd_api.g_miss_num,
161: x_payee_bonus_ptd cn_payment_worksheets.payee_bonus_ptd%TYPE := fnd_api.g_miss_num,
162: x_payee_bonus_paid cn_payment_worksheets.payee_bonus_paid%TYPE := fnd_api.g_miss_num,
163: x_convert_to_type_id cn_payment_worksheets.convert_to_type_id%TYPE := cn_api.g_miss_id,
156: x_bonus_paid cn_payment_worksheets.bonus_paid%TYPE := fnd_api.g_miss_num,
157: x_payee_comm_due_bb cn_payment_worksheets.payee_comm_due_bb%TYPE := fnd_api.g_miss_num,
158: x_payee_comm_ptd cn_payment_worksheets.payee_comm_ptd%TYPE := fnd_api.g_miss_num,
159: x_payee_comm_paid cn_payment_worksheets.payee_comm_paid%TYPE := fnd_api.g_miss_num,
160: x_payee_bonus_due_bb cn_payment_worksheets.payee_bonus_due_bb%TYPE := fnd_api.g_miss_num,
161: x_payee_bonus_ptd cn_payment_worksheets.payee_bonus_ptd%TYPE := fnd_api.g_miss_num,
162: x_payee_bonus_paid cn_payment_worksheets.payee_bonus_paid%TYPE := fnd_api.g_miss_num,
163: x_convert_to_type_id cn_payment_worksheets.convert_to_type_id%TYPE := cn_api.g_miss_id,
164: x_credit_conv_fct_id cn_payment_worksheets.credit_conv_fct_id%TYPE := cn_api.g_miss_id,
157: x_payee_comm_due_bb cn_payment_worksheets.payee_comm_due_bb%TYPE := fnd_api.g_miss_num,
158: x_payee_comm_ptd cn_payment_worksheets.payee_comm_ptd%TYPE := fnd_api.g_miss_num,
159: x_payee_comm_paid cn_payment_worksheets.payee_comm_paid%TYPE := fnd_api.g_miss_num,
160: x_payee_bonus_due_bb cn_payment_worksheets.payee_bonus_due_bb%TYPE := fnd_api.g_miss_num,
161: x_payee_bonus_ptd cn_payment_worksheets.payee_bonus_ptd%TYPE := fnd_api.g_miss_num,
162: x_payee_bonus_paid cn_payment_worksheets.payee_bonus_paid%TYPE := fnd_api.g_miss_num,
163: x_convert_to_type_id cn_payment_worksheets.convert_to_type_id%TYPE := cn_api.g_miss_id,
164: x_credit_conv_fct_id cn_payment_worksheets.credit_conv_fct_id%TYPE := cn_api.g_miss_id,
165: x_convert_to_paid cn_payment_worksheets.convert_to_paid%TYPE := fnd_api.g_miss_num,
158: x_payee_comm_ptd cn_payment_worksheets.payee_comm_ptd%TYPE := fnd_api.g_miss_num,
159: x_payee_comm_paid cn_payment_worksheets.payee_comm_paid%TYPE := fnd_api.g_miss_num,
160: x_payee_bonus_due_bb cn_payment_worksheets.payee_bonus_due_bb%TYPE := fnd_api.g_miss_num,
161: x_payee_bonus_ptd cn_payment_worksheets.payee_bonus_ptd%TYPE := fnd_api.g_miss_num,
162: x_payee_bonus_paid cn_payment_worksheets.payee_bonus_paid%TYPE := fnd_api.g_miss_num,
163: x_convert_to_type_id cn_payment_worksheets.convert_to_type_id%TYPE := cn_api.g_miss_id,
164: x_credit_conv_fct_id cn_payment_worksheets.credit_conv_fct_id%TYPE := cn_api.g_miss_id,
165: x_convert_to_paid cn_payment_worksheets.convert_to_paid%TYPE := fnd_api.g_miss_num,
166: x_reviewed_by_analyst cn_payment_worksheets_all.reviewed_by_analyst%TYPE := fnd_api.g_miss_char,
159: x_payee_comm_paid cn_payment_worksheets.payee_comm_paid%TYPE := fnd_api.g_miss_num,
160: x_payee_bonus_due_bb cn_payment_worksheets.payee_bonus_due_bb%TYPE := fnd_api.g_miss_num,
161: x_payee_bonus_ptd cn_payment_worksheets.payee_bonus_ptd%TYPE := fnd_api.g_miss_num,
162: x_payee_bonus_paid cn_payment_worksheets.payee_bonus_paid%TYPE := fnd_api.g_miss_num,
163: x_convert_to_type_id cn_payment_worksheets.convert_to_type_id%TYPE := cn_api.g_miss_id,
164: x_credit_conv_fct_id cn_payment_worksheets.credit_conv_fct_id%TYPE := cn_api.g_miss_id,
165: x_convert_to_paid cn_payment_worksheets.convert_to_paid%TYPE := fnd_api.g_miss_num,
166: x_reviewed_by_analyst cn_payment_worksheets_all.reviewed_by_analyst%TYPE := fnd_api.g_miss_char,
167: x_analyst_notes cn_payment_worksheets_all.analyst_notes%TYPE := fnd_api.g_miss_char,
160: x_payee_bonus_due_bb cn_payment_worksheets.payee_bonus_due_bb%TYPE := fnd_api.g_miss_num,
161: x_payee_bonus_ptd cn_payment_worksheets.payee_bonus_ptd%TYPE := fnd_api.g_miss_num,
162: x_payee_bonus_paid cn_payment_worksheets.payee_bonus_paid%TYPE := fnd_api.g_miss_num,
163: x_convert_to_type_id cn_payment_worksheets.convert_to_type_id%TYPE := cn_api.g_miss_id,
164: x_credit_conv_fct_id cn_payment_worksheets.credit_conv_fct_id%TYPE := cn_api.g_miss_id,
165: x_convert_to_paid cn_payment_worksheets.convert_to_paid%TYPE := fnd_api.g_miss_num,
166: x_reviewed_by_analyst cn_payment_worksheets_all.reviewed_by_analyst%TYPE := fnd_api.g_miss_char,
167: x_analyst_notes cn_payment_worksheets_all.analyst_notes%TYPE := fnd_api.g_miss_char,
168: x_posting_status cn_payment_worksheets.posting_status%TYPE := fnd_api.g_miss_char,
161: x_payee_bonus_ptd cn_payment_worksheets.payee_bonus_ptd%TYPE := fnd_api.g_miss_num,
162: x_payee_bonus_paid cn_payment_worksheets.payee_bonus_paid%TYPE := fnd_api.g_miss_num,
163: x_convert_to_type_id cn_payment_worksheets.convert_to_type_id%TYPE := cn_api.g_miss_id,
164: x_credit_conv_fct_id cn_payment_worksheets.credit_conv_fct_id%TYPE := cn_api.g_miss_id,
165: x_convert_to_paid cn_payment_worksheets.convert_to_paid%TYPE := fnd_api.g_miss_num,
166: x_reviewed_by_analyst cn_payment_worksheets_all.reviewed_by_analyst%TYPE := fnd_api.g_miss_char,
167: x_analyst_notes cn_payment_worksheets_all.analyst_notes%TYPE := fnd_api.g_miss_char,
168: x_posting_status cn_payment_worksheets.posting_status%TYPE := fnd_api.g_miss_char,
169: x_draw_recoverable_begin cn_payment_worksheets.draw_recoverable_begin%TYPE := fnd_api.g_miss_num,
162: x_payee_bonus_paid cn_payment_worksheets.payee_bonus_paid%TYPE := fnd_api.g_miss_num,
163: x_convert_to_type_id cn_payment_worksheets.convert_to_type_id%TYPE := cn_api.g_miss_id,
164: x_credit_conv_fct_id cn_payment_worksheets.credit_conv_fct_id%TYPE := cn_api.g_miss_id,
165: x_convert_to_paid cn_payment_worksheets.convert_to_paid%TYPE := fnd_api.g_miss_num,
166: x_reviewed_by_analyst cn_payment_worksheets_all.reviewed_by_analyst%TYPE := fnd_api.g_miss_char,
167: x_analyst_notes cn_payment_worksheets_all.analyst_notes%TYPE := fnd_api.g_miss_char,
168: x_posting_status cn_payment_worksheets.posting_status%TYPE := fnd_api.g_miss_char,
169: x_draw_recoverable_begin cn_payment_worksheets.draw_recoverable_begin%TYPE := fnd_api.g_miss_num,
170: x_adjust_paid cn_payment_worksheets.adjust_paid%TYPE := fnd_api.g_miss_num,
163: x_convert_to_type_id cn_payment_worksheets.convert_to_type_id%TYPE := cn_api.g_miss_id,
164: x_credit_conv_fct_id cn_payment_worksheets.credit_conv_fct_id%TYPE := cn_api.g_miss_id,
165: x_convert_to_paid cn_payment_worksheets.convert_to_paid%TYPE := fnd_api.g_miss_num,
166: x_reviewed_by_analyst cn_payment_worksheets_all.reviewed_by_analyst%TYPE := fnd_api.g_miss_char,
167: x_analyst_notes cn_payment_worksheets_all.analyst_notes%TYPE := fnd_api.g_miss_char,
168: x_posting_status cn_payment_worksheets.posting_status%TYPE := fnd_api.g_miss_char,
169: x_draw_recoverable_begin cn_payment_worksheets.draw_recoverable_begin%TYPE := fnd_api.g_miss_num,
170: x_adjust_paid cn_payment_worksheets.adjust_paid%TYPE := fnd_api.g_miss_num,
171: x_bonus_draw cn_payment_worksheets.bonus_draw%TYPE := fnd_api.g_miss_num,
164: x_credit_conv_fct_id cn_payment_worksheets.credit_conv_fct_id%TYPE := cn_api.g_miss_id,
165: x_convert_to_paid cn_payment_worksheets.convert_to_paid%TYPE := fnd_api.g_miss_num,
166: x_reviewed_by_analyst cn_payment_worksheets_all.reviewed_by_analyst%TYPE := fnd_api.g_miss_char,
167: x_analyst_notes cn_payment_worksheets_all.analyst_notes%TYPE := fnd_api.g_miss_char,
168: x_posting_status cn_payment_worksheets.posting_status%TYPE := fnd_api.g_miss_char,
169: x_draw_recoverable_begin cn_payment_worksheets.draw_recoverable_begin%TYPE := fnd_api.g_miss_num,
170: x_adjust_paid cn_payment_worksheets.adjust_paid%TYPE := fnd_api.g_miss_num,
171: x_bonus_draw cn_payment_worksheets.bonus_draw%TYPE := fnd_api.g_miss_num,
172: x_reason cn_payment_worksheets.reason%TYPE := fnd_api.g_miss_char,
165: x_convert_to_paid cn_payment_worksheets.convert_to_paid%TYPE := fnd_api.g_miss_num,
166: x_reviewed_by_analyst cn_payment_worksheets_all.reviewed_by_analyst%TYPE := fnd_api.g_miss_char,
167: x_analyst_notes cn_payment_worksheets_all.analyst_notes%TYPE := fnd_api.g_miss_char,
168: x_posting_status cn_payment_worksheets.posting_status%TYPE := fnd_api.g_miss_char,
169: x_draw_recoverable_begin cn_payment_worksheets.draw_recoverable_begin%TYPE := fnd_api.g_miss_num,
170: x_adjust_paid cn_payment_worksheets.adjust_paid%TYPE := fnd_api.g_miss_num,
171: x_bonus_draw cn_payment_worksheets.bonus_draw%TYPE := fnd_api.g_miss_num,
172: x_reason cn_payment_worksheets.reason%TYPE := fnd_api.g_miss_char,
173: x_bonus_reason cn_payment_worksheets.bonus_reason%TYPE := fnd_api.g_miss_char,
166: x_reviewed_by_analyst cn_payment_worksheets_all.reviewed_by_analyst%TYPE := fnd_api.g_miss_char,
167: x_analyst_notes cn_payment_worksheets_all.analyst_notes%TYPE := fnd_api.g_miss_char,
168: x_posting_status cn_payment_worksheets.posting_status%TYPE := fnd_api.g_miss_char,
169: x_draw_recoverable_begin cn_payment_worksheets.draw_recoverable_begin%TYPE := fnd_api.g_miss_num,
170: x_adjust_paid cn_payment_worksheets.adjust_paid%TYPE := fnd_api.g_miss_num,
171: x_bonus_draw cn_payment_worksheets.bonus_draw%TYPE := fnd_api.g_miss_num,
172: x_reason cn_payment_worksheets.reason%TYPE := fnd_api.g_miss_char,
173: x_bonus_reason cn_payment_worksheets.bonus_reason%TYPE := fnd_api.g_miss_char,
174: x_recovery_method cn_payment_worksheets.recovery_method%TYPE := fnd_api.g_miss_char,
167: x_analyst_notes cn_payment_worksheets_all.analyst_notes%TYPE := fnd_api.g_miss_char,
168: x_posting_status cn_payment_worksheets.posting_status%TYPE := fnd_api.g_miss_char,
169: x_draw_recoverable_begin cn_payment_worksheets.draw_recoverable_begin%TYPE := fnd_api.g_miss_num,
170: x_adjust_paid cn_payment_worksheets.adjust_paid%TYPE := fnd_api.g_miss_num,
171: x_bonus_draw cn_payment_worksheets.bonus_draw%TYPE := fnd_api.g_miss_num,
172: x_reason cn_payment_worksheets.reason%TYPE := fnd_api.g_miss_char,
173: x_bonus_reason cn_payment_worksheets.bonus_reason%TYPE := fnd_api.g_miss_char,
174: x_recovery_method cn_payment_worksheets.recovery_method%TYPE := fnd_api.g_miss_char,
175: x_draw_ptd cn_payment_worksheets.draw_ptd%TYPE := fnd_api.g_miss_num,
168: x_posting_status cn_payment_worksheets.posting_status%TYPE := fnd_api.g_miss_char,
169: x_draw_recoverable_begin cn_payment_worksheets.draw_recoverable_begin%TYPE := fnd_api.g_miss_num,
170: x_adjust_paid cn_payment_worksheets.adjust_paid%TYPE := fnd_api.g_miss_num,
171: x_bonus_draw cn_payment_worksheets.bonus_draw%TYPE := fnd_api.g_miss_num,
172: x_reason cn_payment_worksheets.reason%TYPE := fnd_api.g_miss_char,
173: x_bonus_reason cn_payment_worksheets.bonus_reason%TYPE := fnd_api.g_miss_char,
174: x_recovery_method cn_payment_worksheets.recovery_method%TYPE := fnd_api.g_miss_char,
175: x_draw_ptd cn_payment_worksheets.draw_ptd%TYPE := fnd_api.g_miss_num,
176: x_bonus_given cn_payment_worksheets.bonus_given%TYPE := fnd_api.g_miss_num,
169: x_draw_recoverable_begin cn_payment_worksheets.draw_recoverable_begin%TYPE := fnd_api.g_miss_num,
170: x_adjust_paid cn_payment_worksheets.adjust_paid%TYPE := fnd_api.g_miss_num,
171: x_bonus_draw cn_payment_worksheets.bonus_draw%TYPE := fnd_api.g_miss_num,
172: x_reason cn_payment_worksheets.reason%TYPE := fnd_api.g_miss_char,
173: x_bonus_reason cn_payment_worksheets.bonus_reason%TYPE := fnd_api.g_miss_char,
174: x_recovery_method cn_payment_worksheets.recovery_method%TYPE := fnd_api.g_miss_char,
175: x_draw_ptd cn_payment_worksheets.draw_ptd%TYPE := fnd_api.g_miss_num,
176: x_bonus_given cn_payment_worksheets.bonus_given%TYPE := fnd_api.g_miss_num,
177: x_guarantee cn_payment_worksheets.guarantee%TYPE := fnd_api.g_miss_num,
170: x_adjust_paid cn_payment_worksheets.adjust_paid%TYPE := fnd_api.g_miss_num,
171: x_bonus_draw cn_payment_worksheets.bonus_draw%TYPE := fnd_api.g_miss_num,
172: x_reason cn_payment_worksheets.reason%TYPE := fnd_api.g_miss_char,
173: x_bonus_reason cn_payment_worksheets.bonus_reason%TYPE := fnd_api.g_miss_char,
174: x_recovery_method cn_payment_worksheets.recovery_method%TYPE := fnd_api.g_miss_char,
175: x_draw_ptd cn_payment_worksheets.draw_ptd%TYPE := fnd_api.g_miss_num,
176: x_bonus_given cn_payment_worksheets.bonus_given%TYPE := fnd_api.g_miss_num,
177: x_guarantee cn_payment_worksheets.guarantee%TYPE := fnd_api.g_miss_num,
178: x_worksheet_status cn_payment_worksheets.worksheet_status%TYPE := fnd_api.g_miss_char,
171: x_bonus_draw cn_payment_worksheets.bonus_draw%TYPE := fnd_api.g_miss_num,
172: x_reason cn_payment_worksheets.reason%TYPE := fnd_api.g_miss_char,
173: x_bonus_reason cn_payment_worksheets.bonus_reason%TYPE := fnd_api.g_miss_char,
174: x_recovery_method cn_payment_worksheets.recovery_method%TYPE := fnd_api.g_miss_char,
175: x_draw_ptd cn_payment_worksheets.draw_ptd%TYPE := fnd_api.g_miss_num,
176: x_bonus_given cn_payment_worksheets.bonus_given%TYPE := fnd_api.g_miss_num,
177: x_guarantee cn_payment_worksheets.guarantee%TYPE := fnd_api.g_miss_num,
178: x_worksheet_status cn_payment_worksheets.worksheet_status%TYPE := fnd_api.g_miss_char,
179: x_last_update_date cn_payment_worksheets.last_update_date%TYPE,
172: x_reason cn_payment_worksheets.reason%TYPE := fnd_api.g_miss_char,
173: x_bonus_reason cn_payment_worksheets.bonus_reason%TYPE := fnd_api.g_miss_char,
174: x_recovery_method cn_payment_worksheets.recovery_method%TYPE := fnd_api.g_miss_char,
175: x_draw_ptd cn_payment_worksheets.draw_ptd%TYPE := fnd_api.g_miss_num,
176: x_bonus_given cn_payment_worksheets.bonus_given%TYPE := fnd_api.g_miss_num,
177: x_guarantee cn_payment_worksheets.guarantee%TYPE := fnd_api.g_miss_num,
178: x_worksheet_status cn_payment_worksheets.worksheet_status%TYPE := fnd_api.g_miss_char,
179: x_last_update_date cn_payment_worksheets.last_update_date%TYPE,
180: x_last_updated_by cn_payment_worksheets.last_updated_by%TYPE,
173: x_bonus_reason cn_payment_worksheets.bonus_reason%TYPE := fnd_api.g_miss_char,
174: x_recovery_method cn_payment_worksheets.recovery_method%TYPE := fnd_api.g_miss_char,
175: x_draw_ptd cn_payment_worksheets.draw_ptd%TYPE := fnd_api.g_miss_num,
176: x_bonus_given cn_payment_worksheets.bonus_given%TYPE := fnd_api.g_miss_num,
177: x_guarantee cn_payment_worksheets.guarantee%TYPE := fnd_api.g_miss_num,
178: x_worksheet_status cn_payment_worksheets.worksheet_status%TYPE := fnd_api.g_miss_char,
179: x_last_update_date cn_payment_worksheets.last_update_date%TYPE,
180: x_last_updated_by cn_payment_worksheets.last_updated_by%TYPE,
181: x_last_update_login cn_payment_worksheets.last_update_login%TYPE
174: x_recovery_method cn_payment_worksheets.recovery_method%TYPE := fnd_api.g_miss_char,
175: x_draw_ptd cn_payment_worksheets.draw_ptd%TYPE := fnd_api.g_miss_num,
176: x_bonus_given cn_payment_worksheets.bonus_given%TYPE := fnd_api.g_miss_num,
177: x_guarantee cn_payment_worksheets.guarantee%TYPE := fnd_api.g_miss_num,
178: x_worksheet_status cn_payment_worksheets.worksheet_status%TYPE := fnd_api.g_miss_char,
179: x_last_update_date cn_payment_worksheets.last_update_date%TYPE,
180: x_last_updated_by cn_payment_worksheets.last_updated_by%TYPE,
181: x_last_update_login cn_payment_worksheets.last_update_login%TYPE
182: )
175: x_draw_ptd cn_payment_worksheets.draw_ptd%TYPE := fnd_api.g_miss_num,
176: x_bonus_given cn_payment_worksheets.bonus_given%TYPE := fnd_api.g_miss_num,
177: x_guarantee cn_payment_worksheets.guarantee%TYPE := fnd_api.g_miss_num,
178: x_worksheet_status cn_payment_worksheets.worksheet_status%TYPE := fnd_api.g_miss_char,
179: x_last_update_date cn_payment_worksheets.last_update_date%TYPE,
180: x_last_updated_by cn_payment_worksheets.last_updated_by%TYPE,
181: x_last_update_login cn_payment_worksheets.last_update_login%TYPE
182: )
183: IS
176: x_bonus_given cn_payment_worksheets.bonus_given%TYPE := fnd_api.g_miss_num,
177: x_guarantee cn_payment_worksheets.guarantee%TYPE := fnd_api.g_miss_num,
178: x_worksheet_status cn_payment_worksheets.worksheet_status%TYPE := fnd_api.g_miss_char,
179: x_last_update_date cn_payment_worksheets.last_update_date%TYPE,
180: x_last_updated_by cn_payment_worksheets.last_updated_by%TYPE,
181: x_last_update_login cn_payment_worksheets.last_update_login%TYPE
182: )
183: IS
184: l_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE;
177: x_guarantee cn_payment_worksheets.guarantee%TYPE := fnd_api.g_miss_num,
178: x_worksheet_status cn_payment_worksheets.worksheet_status%TYPE := fnd_api.g_miss_char,
179: x_last_update_date cn_payment_worksheets.last_update_date%TYPE,
180: x_last_updated_by cn_payment_worksheets.last_updated_by%TYPE,
181: x_last_update_login cn_payment_worksheets.last_update_login%TYPE
182: )
183: IS
184: l_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE;
185: l_payrun_id cn_payment_worksheets.payrun_id%TYPE;
180: x_last_updated_by cn_payment_worksheets.last_updated_by%TYPE,
181: x_last_update_login cn_payment_worksheets.last_update_login%TYPE
182: )
183: IS
184: l_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE;
185: l_payrun_id cn_payment_worksheets.payrun_id%TYPE;
186: l_salesrep_id cn_payment_worksheets.salesrep_id%TYPE;
187: l_cost_center_id cn_payment_worksheets.cost_center_id%TYPE;
188: l_role_id cn_payment_worksheets.role_id%TYPE;
181: x_last_update_login cn_payment_worksheets.last_update_login%TYPE
182: )
183: IS
184: l_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE;
185: l_payrun_id cn_payment_worksheets.payrun_id%TYPE;
186: l_salesrep_id cn_payment_worksheets.salesrep_id%TYPE;
187: l_cost_center_id cn_payment_worksheets.cost_center_id%TYPE;
188: l_role_id cn_payment_worksheets.role_id%TYPE;
189: l_credit_type_id cn_payment_worksheets.credit_type_id%TYPE;
182: )
183: IS
184: l_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE;
185: l_payrun_id cn_payment_worksheets.payrun_id%TYPE;
186: l_salesrep_id cn_payment_worksheets.salesrep_id%TYPE;
187: l_cost_center_id cn_payment_worksheets.cost_center_id%TYPE;
188: l_role_id cn_payment_worksheets.role_id%TYPE;
189: l_credit_type_id cn_payment_worksheets.credit_type_id%TYPE;
190: l_returned_funds_flag cn_payment_worksheets.returned_funds_flag%TYPE;
183: IS
184: l_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE;
185: l_payrun_id cn_payment_worksheets.payrun_id%TYPE;
186: l_salesrep_id cn_payment_worksheets.salesrep_id%TYPE;
187: l_cost_center_id cn_payment_worksheets.cost_center_id%TYPE;
188: l_role_id cn_payment_worksheets.role_id%TYPE;
189: l_credit_type_id cn_payment_worksheets.credit_type_id%TYPE;
190: l_returned_funds_flag cn_payment_worksheets.returned_funds_flag%TYPE;
191: l_post_subledger_flag cn_payment_worksheets.post_subledger_flag%TYPE;
184: l_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE;
185: l_payrun_id cn_payment_worksheets.payrun_id%TYPE;
186: l_salesrep_id cn_payment_worksheets.salesrep_id%TYPE;
187: l_cost_center_id cn_payment_worksheets.cost_center_id%TYPE;
188: l_role_id cn_payment_worksheets.role_id%TYPE;
189: l_credit_type_id cn_payment_worksheets.credit_type_id%TYPE;
190: l_returned_funds_flag cn_payment_worksheets.returned_funds_flag%TYPE;
191: l_post_subledger_flag cn_payment_worksheets.post_subledger_flag%TYPE;
192: l_pay_cap cn_payment_worksheets.pay_cap%TYPE;
185: l_payrun_id cn_payment_worksheets.payrun_id%TYPE;
186: l_salesrep_id cn_payment_worksheets.salesrep_id%TYPE;
187: l_cost_center_id cn_payment_worksheets.cost_center_id%TYPE;
188: l_role_id cn_payment_worksheets.role_id%TYPE;
189: l_credit_type_id cn_payment_worksheets.credit_type_id%TYPE;
190: l_returned_funds_flag cn_payment_worksheets.returned_funds_flag%TYPE;
191: l_post_subledger_flag cn_payment_worksheets.post_subledger_flag%TYPE;
192: l_pay_cap cn_payment_worksheets.pay_cap%TYPE;
193: l_minimum_amount cn_payment_worksheets.minimum_amount%TYPE;
186: l_salesrep_id cn_payment_worksheets.salesrep_id%TYPE;
187: l_cost_center_id cn_payment_worksheets.cost_center_id%TYPE;
188: l_role_id cn_payment_worksheets.role_id%TYPE;
189: l_credit_type_id cn_payment_worksheets.credit_type_id%TYPE;
190: l_returned_funds_flag cn_payment_worksheets.returned_funds_flag%TYPE;
191: l_post_subledger_flag cn_payment_worksheets.post_subledger_flag%TYPE;
192: l_pay_cap cn_payment_worksheets.pay_cap%TYPE;
193: l_minimum_amount cn_payment_worksheets.minimum_amount%TYPE;
194: l_comm_due_bb cn_payment_worksheets.comm_due_bb%TYPE;
187: l_cost_center_id cn_payment_worksheets.cost_center_id%TYPE;
188: l_role_id cn_payment_worksheets.role_id%TYPE;
189: l_credit_type_id cn_payment_worksheets.credit_type_id%TYPE;
190: l_returned_funds_flag cn_payment_worksheets.returned_funds_flag%TYPE;
191: l_post_subledger_flag cn_payment_worksheets.post_subledger_flag%TYPE;
192: l_pay_cap cn_payment_worksheets.pay_cap%TYPE;
193: l_minimum_amount cn_payment_worksheets.minimum_amount%TYPE;
194: l_comm_due_bb cn_payment_worksheets.comm_due_bb%TYPE;
195: l_comm_ptd cn_payment_worksheets.comm_ptd%TYPE;
188: l_role_id cn_payment_worksheets.role_id%TYPE;
189: l_credit_type_id cn_payment_worksheets.credit_type_id%TYPE;
190: l_returned_funds_flag cn_payment_worksheets.returned_funds_flag%TYPE;
191: l_post_subledger_flag cn_payment_worksheets.post_subledger_flag%TYPE;
192: l_pay_cap cn_payment_worksheets.pay_cap%TYPE;
193: l_minimum_amount cn_payment_worksheets.minimum_amount%TYPE;
194: l_comm_due_bb cn_payment_worksheets.comm_due_bb%TYPE;
195: l_comm_ptd cn_payment_worksheets.comm_ptd%TYPE;
196: l_draw_paid cn_payment_worksheets.draw_paid%TYPE;
189: l_credit_type_id cn_payment_worksheets.credit_type_id%TYPE;
190: l_returned_funds_flag cn_payment_worksheets.returned_funds_flag%TYPE;
191: l_post_subledger_flag cn_payment_worksheets.post_subledger_flag%TYPE;
192: l_pay_cap cn_payment_worksheets.pay_cap%TYPE;
193: l_minimum_amount cn_payment_worksheets.minimum_amount%TYPE;
194: l_comm_due_bb cn_payment_worksheets.comm_due_bb%TYPE;
195: l_comm_ptd cn_payment_worksheets.comm_ptd%TYPE;
196: l_draw_paid cn_payment_worksheets.draw_paid%TYPE;
197: l_comm_nrec cn_payment_worksheets.comm_nrec%TYPE;
190: l_returned_funds_flag cn_payment_worksheets.returned_funds_flag%TYPE;
191: l_post_subledger_flag cn_payment_worksheets.post_subledger_flag%TYPE;
192: l_pay_cap cn_payment_worksheets.pay_cap%TYPE;
193: l_minimum_amount cn_payment_worksheets.minimum_amount%TYPE;
194: l_comm_due_bb cn_payment_worksheets.comm_due_bb%TYPE;
195: l_comm_ptd cn_payment_worksheets.comm_ptd%TYPE;
196: l_draw_paid cn_payment_worksheets.draw_paid%TYPE;
197: l_comm_nrec cn_payment_worksheets.comm_nrec%TYPE;
198: l_comm_draw cn_payment_worksheets.comm_draw%TYPE;
191: l_post_subledger_flag cn_payment_worksheets.post_subledger_flag%TYPE;
192: l_pay_cap cn_payment_worksheets.pay_cap%TYPE;
193: l_minimum_amount cn_payment_worksheets.minimum_amount%TYPE;
194: l_comm_due_bb cn_payment_worksheets.comm_due_bb%TYPE;
195: l_comm_ptd cn_payment_worksheets.comm_ptd%TYPE;
196: l_draw_paid cn_payment_worksheets.draw_paid%TYPE;
197: l_comm_nrec cn_payment_worksheets.comm_nrec%TYPE;
198: l_comm_draw cn_payment_worksheets.comm_draw%TYPE;
199: l_comm_paid cn_payment_worksheets.comm_paid%TYPE;
192: l_pay_cap cn_payment_worksheets.pay_cap%TYPE;
193: l_minimum_amount cn_payment_worksheets.minimum_amount%TYPE;
194: l_comm_due_bb cn_payment_worksheets.comm_due_bb%TYPE;
195: l_comm_ptd cn_payment_worksheets.comm_ptd%TYPE;
196: l_draw_paid cn_payment_worksheets.draw_paid%TYPE;
197: l_comm_nrec cn_payment_worksheets.comm_nrec%TYPE;
198: l_comm_draw cn_payment_worksheets.comm_draw%TYPE;
199: l_comm_paid cn_payment_worksheets.comm_paid%TYPE;
200: l_reg_bonus_due_bb cn_payment_worksheets.reg_bonus_due_bb%TYPE;
193: l_minimum_amount cn_payment_worksheets.minimum_amount%TYPE;
194: l_comm_due_bb cn_payment_worksheets.comm_due_bb%TYPE;
195: l_comm_ptd cn_payment_worksheets.comm_ptd%TYPE;
196: l_draw_paid cn_payment_worksheets.draw_paid%TYPE;
197: l_comm_nrec cn_payment_worksheets.comm_nrec%TYPE;
198: l_comm_draw cn_payment_worksheets.comm_draw%TYPE;
199: l_comm_paid cn_payment_worksheets.comm_paid%TYPE;
200: l_reg_bonus_due_bb cn_payment_worksheets.reg_bonus_due_bb%TYPE;
201: l_reg_bonus_ptd cn_payment_worksheets.reg_bonus_ptd%TYPE;
194: l_comm_due_bb cn_payment_worksheets.comm_due_bb%TYPE;
195: l_comm_ptd cn_payment_worksheets.comm_ptd%TYPE;
196: l_draw_paid cn_payment_worksheets.draw_paid%TYPE;
197: l_comm_nrec cn_payment_worksheets.comm_nrec%TYPE;
198: l_comm_draw cn_payment_worksheets.comm_draw%TYPE;
199: l_comm_paid cn_payment_worksheets.comm_paid%TYPE;
200: l_reg_bonus_due_bb cn_payment_worksheets.reg_bonus_due_bb%TYPE;
201: l_reg_bonus_ptd cn_payment_worksheets.reg_bonus_ptd%TYPE;
202: l_reg_bonus_rec cn_payment_worksheets.reg_bonus_rec%TYPE;
195: l_comm_ptd cn_payment_worksheets.comm_ptd%TYPE;
196: l_draw_paid cn_payment_worksheets.draw_paid%TYPE;
197: l_comm_nrec cn_payment_worksheets.comm_nrec%TYPE;
198: l_comm_draw cn_payment_worksheets.comm_draw%TYPE;
199: l_comm_paid cn_payment_worksheets.comm_paid%TYPE;
200: l_reg_bonus_due_bb cn_payment_worksheets.reg_bonus_due_bb%TYPE;
201: l_reg_bonus_ptd cn_payment_worksheets.reg_bonus_ptd%TYPE;
202: l_reg_bonus_rec cn_payment_worksheets.reg_bonus_rec%TYPE;
203: l_reg_bonus_to_rec cn_payment_worksheets.reg_bonus_to_rec%TYPE;
196: l_draw_paid cn_payment_worksheets.draw_paid%TYPE;
197: l_comm_nrec cn_payment_worksheets.comm_nrec%TYPE;
198: l_comm_draw cn_payment_worksheets.comm_draw%TYPE;
199: l_comm_paid cn_payment_worksheets.comm_paid%TYPE;
200: l_reg_bonus_due_bb cn_payment_worksheets.reg_bonus_due_bb%TYPE;
201: l_reg_bonus_ptd cn_payment_worksheets.reg_bonus_ptd%TYPE;
202: l_reg_bonus_rec cn_payment_worksheets.reg_bonus_rec%TYPE;
203: l_reg_bonus_to_rec cn_payment_worksheets.reg_bonus_to_rec%TYPE;
204: l_reg_bonus_paid cn_payment_worksheets.reg_bonus_paid%TYPE;
197: l_comm_nrec cn_payment_worksheets.comm_nrec%TYPE;
198: l_comm_draw cn_payment_worksheets.comm_draw%TYPE;
199: l_comm_paid cn_payment_worksheets.comm_paid%TYPE;
200: l_reg_bonus_due_bb cn_payment_worksheets.reg_bonus_due_bb%TYPE;
201: l_reg_bonus_ptd cn_payment_worksheets.reg_bonus_ptd%TYPE;
202: l_reg_bonus_rec cn_payment_worksheets.reg_bonus_rec%TYPE;
203: l_reg_bonus_to_rec cn_payment_worksheets.reg_bonus_to_rec%TYPE;
204: l_reg_bonus_paid cn_payment_worksheets.reg_bonus_paid%TYPE;
205: l_bonus_due_bb cn_payment_worksheets.bonus_due_bb%TYPE;
198: l_comm_draw cn_payment_worksheets.comm_draw%TYPE;
199: l_comm_paid cn_payment_worksheets.comm_paid%TYPE;
200: l_reg_bonus_due_bb cn_payment_worksheets.reg_bonus_due_bb%TYPE;
201: l_reg_bonus_ptd cn_payment_worksheets.reg_bonus_ptd%TYPE;
202: l_reg_bonus_rec cn_payment_worksheets.reg_bonus_rec%TYPE;
203: l_reg_bonus_to_rec cn_payment_worksheets.reg_bonus_to_rec%TYPE;
204: l_reg_bonus_paid cn_payment_worksheets.reg_bonus_paid%TYPE;
205: l_bonus_due_bb cn_payment_worksheets.bonus_due_bb%TYPE;
206: l_bonus_ptd cn_payment_worksheets.bonus_ptd%TYPE;
199: l_comm_paid cn_payment_worksheets.comm_paid%TYPE;
200: l_reg_bonus_due_bb cn_payment_worksheets.reg_bonus_due_bb%TYPE;
201: l_reg_bonus_ptd cn_payment_worksheets.reg_bonus_ptd%TYPE;
202: l_reg_bonus_rec cn_payment_worksheets.reg_bonus_rec%TYPE;
203: l_reg_bonus_to_rec cn_payment_worksheets.reg_bonus_to_rec%TYPE;
204: l_reg_bonus_paid cn_payment_worksheets.reg_bonus_paid%TYPE;
205: l_bonus_due_bb cn_payment_worksheets.bonus_due_bb%TYPE;
206: l_bonus_ptd cn_payment_worksheets.bonus_ptd%TYPE;
207: l_bonus_paid cn_payment_worksheets.bonus_paid%TYPE;
200: l_reg_bonus_due_bb cn_payment_worksheets.reg_bonus_due_bb%TYPE;
201: l_reg_bonus_ptd cn_payment_worksheets.reg_bonus_ptd%TYPE;
202: l_reg_bonus_rec cn_payment_worksheets.reg_bonus_rec%TYPE;
203: l_reg_bonus_to_rec cn_payment_worksheets.reg_bonus_to_rec%TYPE;
204: l_reg_bonus_paid cn_payment_worksheets.reg_bonus_paid%TYPE;
205: l_bonus_due_bb cn_payment_worksheets.bonus_due_bb%TYPE;
206: l_bonus_ptd cn_payment_worksheets.bonus_ptd%TYPE;
207: l_bonus_paid cn_payment_worksheets.bonus_paid%TYPE;
208: l_payee_comm_due_bb cn_payment_worksheets.payee_comm_due_bb%TYPE;
201: l_reg_bonus_ptd cn_payment_worksheets.reg_bonus_ptd%TYPE;
202: l_reg_bonus_rec cn_payment_worksheets.reg_bonus_rec%TYPE;
203: l_reg_bonus_to_rec cn_payment_worksheets.reg_bonus_to_rec%TYPE;
204: l_reg_bonus_paid cn_payment_worksheets.reg_bonus_paid%TYPE;
205: l_bonus_due_bb cn_payment_worksheets.bonus_due_bb%TYPE;
206: l_bonus_ptd cn_payment_worksheets.bonus_ptd%TYPE;
207: l_bonus_paid cn_payment_worksheets.bonus_paid%TYPE;
208: l_payee_comm_due_bb cn_payment_worksheets.payee_comm_due_bb%TYPE;
209: l_payee_comm_ptd cn_payment_worksheets.payee_comm_ptd%TYPE;
202: l_reg_bonus_rec cn_payment_worksheets.reg_bonus_rec%TYPE;
203: l_reg_bonus_to_rec cn_payment_worksheets.reg_bonus_to_rec%TYPE;
204: l_reg_bonus_paid cn_payment_worksheets.reg_bonus_paid%TYPE;
205: l_bonus_due_bb cn_payment_worksheets.bonus_due_bb%TYPE;
206: l_bonus_ptd cn_payment_worksheets.bonus_ptd%TYPE;
207: l_bonus_paid cn_payment_worksheets.bonus_paid%TYPE;
208: l_payee_comm_due_bb cn_payment_worksheets.payee_comm_due_bb%TYPE;
209: l_payee_comm_ptd cn_payment_worksheets.payee_comm_ptd%TYPE;
210: l_payee_comm_paid cn_payment_worksheets.payee_comm_paid%TYPE;
203: l_reg_bonus_to_rec cn_payment_worksheets.reg_bonus_to_rec%TYPE;
204: l_reg_bonus_paid cn_payment_worksheets.reg_bonus_paid%TYPE;
205: l_bonus_due_bb cn_payment_worksheets.bonus_due_bb%TYPE;
206: l_bonus_ptd cn_payment_worksheets.bonus_ptd%TYPE;
207: l_bonus_paid cn_payment_worksheets.bonus_paid%TYPE;
208: l_payee_comm_due_bb cn_payment_worksheets.payee_comm_due_bb%TYPE;
209: l_payee_comm_ptd cn_payment_worksheets.payee_comm_ptd%TYPE;
210: l_payee_comm_paid cn_payment_worksheets.payee_comm_paid%TYPE;
211: l_payee_bonus_due_bb cn_payment_worksheets.payee_bonus_due_bb%TYPE;
204: l_reg_bonus_paid cn_payment_worksheets.reg_bonus_paid%TYPE;
205: l_bonus_due_bb cn_payment_worksheets.bonus_due_bb%TYPE;
206: l_bonus_ptd cn_payment_worksheets.bonus_ptd%TYPE;
207: l_bonus_paid cn_payment_worksheets.bonus_paid%TYPE;
208: l_payee_comm_due_bb cn_payment_worksheets.payee_comm_due_bb%TYPE;
209: l_payee_comm_ptd cn_payment_worksheets.payee_comm_ptd%TYPE;
210: l_payee_comm_paid cn_payment_worksheets.payee_comm_paid%TYPE;
211: l_payee_bonus_due_bb cn_payment_worksheets.payee_bonus_due_bb%TYPE;
212: l_payee_bonus_ptd cn_payment_worksheets.payee_bonus_ptd%TYPE;
205: l_bonus_due_bb cn_payment_worksheets.bonus_due_bb%TYPE;
206: l_bonus_ptd cn_payment_worksheets.bonus_ptd%TYPE;
207: l_bonus_paid cn_payment_worksheets.bonus_paid%TYPE;
208: l_payee_comm_due_bb cn_payment_worksheets.payee_comm_due_bb%TYPE;
209: l_payee_comm_ptd cn_payment_worksheets.payee_comm_ptd%TYPE;
210: l_payee_comm_paid cn_payment_worksheets.payee_comm_paid%TYPE;
211: l_payee_bonus_due_bb cn_payment_worksheets.payee_bonus_due_bb%TYPE;
212: l_payee_bonus_ptd cn_payment_worksheets.payee_bonus_ptd%TYPE;
213: l_payee_bonus_paid cn_payment_worksheets.payee_bonus_paid%TYPE;
206: l_bonus_ptd cn_payment_worksheets.bonus_ptd%TYPE;
207: l_bonus_paid cn_payment_worksheets.bonus_paid%TYPE;
208: l_payee_comm_due_bb cn_payment_worksheets.payee_comm_due_bb%TYPE;
209: l_payee_comm_ptd cn_payment_worksheets.payee_comm_ptd%TYPE;
210: l_payee_comm_paid cn_payment_worksheets.payee_comm_paid%TYPE;
211: l_payee_bonus_due_bb cn_payment_worksheets.payee_bonus_due_bb%TYPE;
212: l_payee_bonus_ptd cn_payment_worksheets.payee_bonus_ptd%TYPE;
213: l_payee_bonus_paid cn_payment_worksheets.payee_bonus_paid%TYPE;
214: l_convert_to_type_id cn_payment_worksheets.convert_to_type_id%TYPE;
207: l_bonus_paid cn_payment_worksheets.bonus_paid%TYPE;
208: l_payee_comm_due_bb cn_payment_worksheets.payee_comm_due_bb%TYPE;
209: l_payee_comm_ptd cn_payment_worksheets.payee_comm_ptd%TYPE;
210: l_payee_comm_paid cn_payment_worksheets.payee_comm_paid%TYPE;
211: l_payee_bonus_due_bb cn_payment_worksheets.payee_bonus_due_bb%TYPE;
212: l_payee_bonus_ptd cn_payment_worksheets.payee_bonus_ptd%TYPE;
213: l_payee_bonus_paid cn_payment_worksheets.payee_bonus_paid%TYPE;
214: l_convert_to_type_id cn_payment_worksheets.convert_to_type_id%TYPE;
215: l_credit_conv_fct_id cn_payment_worksheets.credit_conv_fct_id%TYPE;
208: l_payee_comm_due_bb cn_payment_worksheets.payee_comm_due_bb%TYPE;
209: l_payee_comm_ptd cn_payment_worksheets.payee_comm_ptd%TYPE;
210: l_payee_comm_paid cn_payment_worksheets.payee_comm_paid%TYPE;
211: l_payee_bonus_due_bb cn_payment_worksheets.payee_bonus_due_bb%TYPE;
212: l_payee_bonus_ptd cn_payment_worksheets.payee_bonus_ptd%TYPE;
213: l_payee_bonus_paid cn_payment_worksheets.payee_bonus_paid%TYPE;
214: l_convert_to_type_id cn_payment_worksheets.convert_to_type_id%TYPE;
215: l_credit_conv_fct_id cn_payment_worksheets.credit_conv_fct_id%TYPE;
216: l_convert_to_paid cn_payment_worksheets.convert_to_paid%TYPE;
209: l_payee_comm_ptd cn_payment_worksheets.payee_comm_ptd%TYPE;
210: l_payee_comm_paid cn_payment_worksheets.payee_comm_paid%TYPE;
211: l_payee_bonus_due_bb cn_payment_worksheets.payee_bonus_due_bb%TYPE;
212: l_payee_bonus_ptd cn_payment_worksheets.payee_bonus_ptd%TYPE;
213: l_payee_bonus_paid cn_payment_worksheets.payee_bonus_paid%TYPE;
214: l_convert_to_type_id cn_payment_worksheets.convert_to_type_id%TYPE;
215: l_credit_conv_fct_id cn_payment_worksheets.credit_conv_fct_id%TYPE;
216: l_convert_to_paid cn_payment_worksheets.convert_to_paid%TYPE;
217: l_posting_status cn_payment_worksheets.posting_status%TYPE;
210: l_payee_comm_paid cn_payment_worksheets.payee_comm_paid%TYPE;
211: l_payee_bonus_due_bb cn_payment_worksheets.payee_bonus_due_bb%TYPE;
212: l_payee_bonus_ptd cn_payment_worksheets.payee_bonus_ptd%TYPE;
213: l_payee_bonus_paid cn_payment_worksheets.payee_bonus_paid%TYPE;
214: l_convert_to_type_id cn_payment_worksheets.convert_to_type_id%TYPE;
215: l_credit_conv_fct_id cn_payment_worksheets.credit_conv_fct_id%TYPE;
216: l_convert_to_paid cn_payment_worksheets.convert_to_paid%TYPE;
217: l_posting_status cn_payment_worksheets.posting_status%TYPE;
218: l_draw_recoverable_begin cn_payment_worksheets.draw_recoverable_begin%TYPE;
211: l_payee_bonus_due_bb cn_payment_worksheets.payee_bonus_due_bb%TYPE;
212: l_payee_bonus_ptd cn_payment_worksheets.payee_bonus_ptd%TYPE;
213: l_payee_bonus_paid cn_payment_worksheets.payee_bonus_paid%TYPE;
214: l_convert_to_type_id cn_payment_worksheets.convert_to_type_id%TYPE;
215: l_credit_conv_fct_id cn_payment_worksheets.credit_conv_fct_id%TYPE;
216: l_convert_to_paid cn_payment_worksheets.convert_to_paid%TYPE;
217: l_posting_status cn_payment_worksheets.posting_status%TYPE;
218: l_draw_recoverable_begin cn_payment_worksheets.draw_recoverable_begin%TYPE;
219: l_adjust_paid cn_payment_worksheets.adjust_paid%TYPE;
212: l_payee_bonus_ptd cn_payment_worksheets.payee_bonus_ptd%TYPE;
213: l_payee_bonus_paid cn_payment_worksheets.payee_bonus_paid%TYPE;
214: l_convert_to_type_id cn_payment_worksheets.convert_to_type_id%TYPE;
215: l_credit_conv_fct_id cn_payment_worksheets.credit_conv_fct_id%TYPE;
216: l_convert_to_paid cn_payment_worksheets.convert_to_paid%TYPE;
217: l_posting_status cn_payment_worksheets.posting_status%TYPE;
218: l_draw_recoverable_begin cn_payment_worksheets.draw_recoverable_begin%TYPE;
219: l_adjust_paid cn_payment_worksheets.adjust_paid%TYPE;
220: l_bonus_draw cn_payment_worksheets.bonus_draw%TYPE;
213: l_payee_bonus_paid cn_payment_worksheets.payee_bonus_paid%TYPE;
214: l_convert_to_type_id cn_payment_worksheets.convert_to_type_id%TYPE;
215: l_credit_conv_fct_id cn_payment_worksheets.credit_conv_fct_id%TYPE;
216: l_convert_to_paid cn_payment_worksheets.convert_to_paid%TYPE;
217: l_posting_status cn_payment_worksheets.posting_status%TYPE;
218: l_draw_recoverable_begin cn_payment_worksheets.draw_recoverable_begin%TYPE;
219: l_adjust_paid cn_payment_worksheets.adjust_paid%TYPE;
220: l_bonus_draw cn_payment_worksheets.bonus_draw%TYPE;
221: l_reason cn_payment_worksheets.reason%TYPE;
214: l_convert_to_type_id cn_payment_worksheets.convert_to_type_id%TYPE;
215: l_credit_conv_fct_id cn_payment_worksheets.credit_conv_fct_id%TYPE;
216: l_convert_to_paid cn_payment_worksheets.convert_to_paid%TYPE;
217: l_posting_status cn_payment_worksheets.posting_status%TYPE;
218: l_draw_recoverable_begin cn_payment_worksheets.draw_recoverable_begin%TYPE;
219: l_adjust_paid cn_payment_worksheets.adjust_paid%TYPE;
220: l_bonus_draw cn_payment_worksheets.bonus_draw%TYPE;
221: l_reason cn_payment_worksheets.reason%TYPE;
222: l_bonus_reason cn_payment_worksheets.bonus_reason%TYPE;
215: l_credit_conv_fct_id cn_payment_worksheets.credit_conv_fct_id%TYPE;
216: l_convert_to_paid cn_payment_worksheets.convert_to_paid%TYPE;
217: l_posting_status cn_payment_worksheets.posting_status%TYPE;
218: l_draw_recoverable_begin cn_payment_worksheets.draw_recoverable_begin%TYPE;
219: l_adjust_paid cn_payment_worksheets.adjust_paid%TYPE;
220: l_bonus_draw cn_payment_worksheets.bonus_draw%TYPE;
221: l_reason cn_payment_worksheets.reason%TYPE;
222: l_bonus_reason cn_payment_worksheets.bonus_reason%TYPE;
223: l_recovery_method cn_payment_worksheets.recovery_method%TYPE;
216: l_convert_to_paid cn_payment_worksheets.convert_to_paid%TYPE;
217: l_posting_status cn_payment_worksheets.posting_status%TYPE;
218: l_draw_recoverable_begin cn_payment_worksheets.draw_recoverable_begin%TYPE;
219: l_adjust_paid cn_payment_worksheets.adjust_paid%TYPE;
220: l_bonus_draw cn_payment_worksheets.bonus_draw%TYPE;
221: l_reason cn_payment_worksheets.reason%TYPE;
222: l_bonus_reason cn_payment_worksheets.bonus_reason%TYPE;
223: l_recovery_method cn_payment_worksheets.recovery_method%TYPE;
224: l_draw_ptd cn_payment_worksheets.draw_ptd%TYPE;
217: l_posting_status cn_payment_worksheets.posting_status%TYPE;
218: l_draw_recoverable_begin cn_payment_worksheets.draw_recoverable_begin%TYPE;
219: l_adjust_paid cn_payment_worksheets.adjust_paid%TYPE;
220: l_bonus_draw cn_payment_worksheets.bonus_draw%TYPE;
221: l_reason cn_payment_worksheets.reason%TYPE;
222: l_bonus_reason cn_payment_worksheets.bonus_reason%TYPE;
223: l_recovery_method cn_payment_worksheets.recovery_method%TYPE;
224: l_draw_ptd cn_payment_worksheets.draw_ptd%TYPE;
225: l_bonus_given cn_payment_worksheets.bonus_given%TYPE;
218: l_draw_recoverable_begin cn_payment_worksheets.draw_recoverable_begin%TYPE;
219: l_adjust_paid cn_payment_worksheets.adjust_paid%TYPE;
220: l_bonus_draw cn_payment_worksheets.bonus_draw%TYPE;
221: l_reason cn_payment_worksheets.reason%TYPE;
222: l_bonus_reason cn_payment_worksheets.bonus_reason%TYPE;
223: l_recovery_method cn_payment_worksheets.recovery_method%TYPE;
224: l_draw_ptd cn_payment_worksheets.draw_ptd%TYPE;
225: l_bonus_given cn_payment_worksheets.bonus_given%TYPE;
226: l_guarantee cn_payment_worksheets.guarantee%TYPE;
219: l_adjust_paid cn_payment_worksheets.adjust_paid%TYPE;
220: l_bonus_draw cn_payment_worksheets.bonus_draw%TYPE;
221: l_reason cn_payment_worksheets.reason%TYPE;
222: l_bonus_reason cn_payment_worksheets.bonus_reason%TYPE;
223: l_recovery_method cn_payment_worksheets.recovery_method%TYPE;
224: l_draw_ptd cn_payment_worksheets.draw_ptd%TYPE;
225: l_bonus_given cn_payment_worksheets.bonus_given%TYPE;
226: l_guarantee cn_payment_worksheets.guarantee%TYPE;
227: l_worksheet_status cn_payment_worksheets.worksheet_status%TYPE;
220: l_bonus_draw cn_payment_worksheets.bonus_draw%TYPE;
221: l_reason cn_payment_worksheets.reason%TYPE;
222: l_bonus_reason cn_payment_worksheets.bonus_reason%TYPE;
223: l_recovery_method cn_payment_worksheets.recovery_method%TYPE;
224: l_draw_ptd cn_payment_worksheets.draw_ptd%TYPE;
225: l_bonus_given cn_payment_worksheets.bonus_given%TYPE;
226: l_guarantee cn_payment_worksheets.guarantee%TYPE;
227: l_worksheet_status cn_payment_worksheets.worksheet_status%TYPE;
228: l_reviewed_by_analyst cn_payment_worksheets.reviewed_by_analyst%TYPE;
221: l_reason cn_payment_worksheets.reason%TYPE;
222: l_bonus_reason cn_payment_worksheets.bonus_reason%TYPE;
223: l_recovery_method cn_payment_worksheets.recovery_method%TYPE;
224: l_draw_ptd cn_payment_worksheets.draw_ptd%TYPE;
225: l_bonus_given cn_payment_worksheets.bonus_given%TYPE;
226: l_guarantee cn_payment_worksheets.guarantee%TYPE;
227: l_worksheet_status cn_payment_worksheets.worksheet_status%TYPE;
228: l_reviewed_by_analyst cn_payment_worksheets.reviewed_by_analyst%TYPE;
229: l_analyst_notes cn_payment_worksheets.analyst_notes%TYPE;
222: l_bonus_reason cn_payment_worksheets.bonus_reason%TYPE;
223: l_recovery_method cn_payment_worksheets.recovery_method%TYPE;
224: l_draw_ptd cn_payment_worksheets.draw_ptd%TYPE;
225: l_bonus_given cn_payment_worksheets.bonus_given%TYPE;
226: l_guarantee cn_payment_worksheets.guarantee%TYPE;
227: l_worksheet_status cn_payment_worksheets.worksheet_status%TYPE;
228: l_reviewed_by_analyst cn_payment_worksheets.reviewed_by_analyst%TYPE;
229: l_analyst_notes cn_payment_worksheets.analyst_notes%TYPE;
230:
223: l_recovery_method cn_payment_worksheets.recovery_method%TYPE;
224: l_draw_ptd cn_payment_worksheets.draw_ptd%TYPE;
225: l_bonus_given cn_payment_worksheets.bonus_given%TYPE;
226: l_guarantee cn_payment_worksheets.guarantee%TYPE;
227: l_worksheet_status cn_payment_worksheets.worksheet_status%TYPE;
228: l_reviewed_by_analyst cn_payment_worksheets.reviewed_by_analyst%TYPE;
229: l_analyst_notes cn_payment_worksheets.analyst_notes%TYPE;
230:
231: CURSOR payment_worksheet_cur
224: l_draw_ptd cn_payment_worksheets.draw_ptd%TYPE;
225: l_bonus_given cn_payment_worksheets.bonus_given%TYPE;
226: l_guarantee cn_payment_worksheets.guarantee%TYPE;
227: l_worksheet_status cn_payment_worksheets.worksheet_status%TYPE;
228: l_reviewed_by_analyst cn_payment_worksheets.reviewed_by_analyst%TYPE;
229: l_analyst_notes cn_payment_worksheets.analyst_notes%TYPE;
230:
231: CURSOR payment_worksheet_cur
232: IS
225: l_bonus_given cn_payment_worksheets.bonus_given%TYPE;
226: l_guarantee cn_payment_worksheets.guarantee%TYPE;
227: l_worksheet_status cn_payment_worksheets.worksheet_status%TYPE;
228: l_reviewed_by_analyst cn_payment_worksheets.reviewed_by_analyst%TYPE;
229: l_analyst_notes cn_payment_worksheets.analyst_notes%TYPE;
230:
231: CURSOR payment_worksheet_cur
232: IS
233: SELECT *
230:
231: CURSOR payment_worksheet_cur
232: IS
233: SELECT *
234: FROM cn_payment_worksheets
235: WHERE payment_worksheet_id = x_payment_worksheet_id;
236:
237: l_payment_worksheet_rec payment_worksheet_cur%ROWTYPE;
238: BEGIN
332: l_guarantee,
333: l_worksheet_status
334: FROM DUAL;
335:
336: UPDATE cn_payment_worksheets
337: SET salesrep_id = l_salesrep_id,
338: cost_center_id = l_cost_center_id,
339: role_id = l_role_id,
340: credit_type_id = l_credit_type_id,
403: p_pmt_amount_adj_rec NUMBER := 0,
404: p_pmt_amount_adj_nrec NUMBER := 0,
405: p_pmt_amount_recovery NUMBER := 0,
406: p_pmt_amount_adj NUMBER := 0,
407: x_object_version_number OUT NOCOPY cn_payment_worksheets.object_version_number%TYPE
408: )
409: IS
410: BEGIN
411: SELECT NVL(object_version_number,0) + 1
409: IS
410: BEGIN
411: SELECT NVL(object_version_number,0) + 1
412: INTO x_object_version_number
413: FROM cn_payment_worksheets
414: WHERE salesrep_id = p_salesrep_id
415: AND payrun_id = p_payrun_id;
416:
417: UPDATE cn_payment_worksheets
413: FROM cn_payment_worksheets
414: WHERE salesrep_id = p_salesrep_id
415: AND payrun_id = p_payrun_id;
416:
417: UPDATE cn_payment_worksheets
418: SET pmt_amount_adj_nrec = NVL (pmt_amount_adj_nrec, 0) + NVL (p_pmt_amount_adj_nrec, 0),
419: pmt_amount_adj_rec = NVL (pmt_amount_adj_rec, 0) + NVL (p_pmt_amount_adj_rec, 0),
420: pmt_amount_adj = NVL (pmt_amount_adj, 0) + NVL (p_pmt_amount_adj, 0),
421: pmt_amount_calc = NVL (pmt_amount_calc, 0) + NVL (p_pmt_amount_calc, 0),
441: )
442: IS
443: BEGIN
444:
445: UPDATE cn_payment_worksheets
446: SET worksheet_status = p_worksheet_status,
447: last_updated_by = fnd_global.user_id,
448: last_update_date = SYSDATE,
449: last_update_login = fnd_global.login_id,
463: )
464: IS
465: BEGIN
466: DELETE
467: FROM cn_payment_worksheets
468: WHERE salesrep_id = p_salesrep_id
469: AND payrun_id = p_payrun_id;
470:
471: END DELETE_RECORD;
479: )
480: IS
481: BEGIN
482: DELETE
483: FROM cn_payment_worksheets
484: WHERE payment_worksheet_id = x_payment_worksheet_id;
485:
486: END DELETE_RECORD;
487:
485:
486: END DELETE_RECORD;
487:
488:
489: END cn_payment_worksheets_pkg;