APPS.CN_PAYMENT_WORKSHEETS_PKG dependencies on CN_PAYMENT_WORKSHEETS

Line 1: PACKAGE cn_payment_worksheets_pkg AUTHID CURRENT_USER AS

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

Line 6: -- Purpose : Insert a Record in CN_PAYMENT_WORKSHEETS

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,

Line 9: x_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE := NULL,

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,

Line 10: x_payrun_id cn_payment_worksheets.payrun_id%TYPE,

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,

Line 11: x_salesrep_id cn_payment_worksheets.salesrep_id%TYPE,

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,

Line 12: x_quota_id cn_payment_worksheets.quota_id%TYPE := NULL,

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,

Line 13: x_cost_center_id cn_payment_worksheets.cost_center_id%TYPE := NULL,

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,

Line 14: x_role_id cn_payment_worksheets.role_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,

Line 15: x_credit_type_id cn_payment_worksheets.credit_type_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,

Line 16: x_calc_pmt_amount cn_payment_worksheets.pmt_amount_calc%TYPE := 0,

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,

Line 17: x_adj_pmt_amount_rec cn_payment_worksheets.pmt_amount_calc%TYPE := 0,

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,

Line 18: x_adj_pmt_amount_nrec cn_payment_worksheets.pmt_amount_calc%TYPE := 0,

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,

Line 19: x_adj_pmt_amount cn_payment_worksheets.pmt_amount_calc%TYPE := 0,

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,

Line 20: x_held_amount cn_payment_worksheets.held_amount%TYPE := 0,

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,

Line 21: x_pmt_amount_recovery 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,

Line 22: x_comm_paid cn_payment_worksheets.draw_ptd%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,

Line 23: x_bonus_paid cn_payment_worksheets.draw_ptd%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,

Line 24: x_draw_paid cn_payment_worksheets.draw_ptd%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,

Line 25: x_comm_nrec cn_payment_worksheets.draw_ptd%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,

Line 26: x_created_by cn_payment_worksheets.created_by%TYPE,

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

Line 27: x_creation_date cn_payment_worksheets.creation_date%TYPE,

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: );

Line 28: x_worksheet_status cn_payment_worksheets.worksheet_status%TYPE,

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:

Line 29: p_org_id cn_payment_worksheets.org_id%TYPE,

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: --============================================================================

Line 30: p_object_version_number cn_payment_worksheets.object_version_number%TYPE

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

Line 46: x_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE,

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,

Line 47: x_payrun_id cn_payment_worksheets.payrun_id%TYPE := cn_api.g_miss_id,

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,

Line 48: x_salesrep_id cn_payment_worksheets.salesrep_id%TYPE := cn_api.g_miss_id,

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 := '~',

Line 49: x_cost_center_id cn_payment_worksheets.cost_center_id%TYPE := cn_api.g_miss_id,

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 := '~',

Line 50: x_role_id cn_payment_worksheets.role_id%TYPE := cn_api.g_miss_id,

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,

Line 51: x_credit_type_id cn_payment_worksheets.credit_type_id%TYPE := cn_api.g_miss_id,

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,

Line 52: x_returned_funds_flag cn_payment_worksheets.returned_funds_flag%TYPE := '~',

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,

Line 53: x_post_subledger_flag cn_payment_worksheets.post_subledger_flag%TYPE := '~',

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,

Line 54: x_pay_cap cn_payment_worksheets.pay_cap%TYPE := fnd_api.g_miss_num,

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,

Line 55: x_minimum_amount cn_payment_worksheets.minimum_amount%TYPE := fnd_api.g_miss_num,

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,

Line 56: x_comm_due_bb cn_payment_worksheets.comm_due_bb%TYPE := fnd_api.g_miss_num,

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,

Line 57: x_comm_ptd cn_payment_worksheets.comm_ptd%TYPE := fnd_api.g_miss_num,

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,

Line 58: x_draw_paid cn_payment_worksheets.draw_paid%TYPE := fnd_api.g_miss_num,

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,

Line 59: x_comm_nrec cn_payment_worksheets.comm_nrec%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,

Line 60: x_comm_draw cn_payment_worksheets.comm_draw%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,

Line 61: x_comm_paid cn_payment_worksheets.comm_paid%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,

Line 62: x_reg_bonus_due_bb cn_payment_worksheets.reg_bonus_due_bb%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,

Line 63: x_reg_bonus_ptd cn_payment_worksheets.reg_bonus_ptd%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,

Line 64: x_reg_bonus_rec cn_payment_worksheets.reg_bonus_rec%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,

Line 65: x_reg_bonus_to_rec cn_payment_worksheets.reg_bonus_to_rec%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,

Line 66: x_reg_bonus_paid cn_payment_worksheets.reg_bonus_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,

Line 67: x_bonus_due_bb cn_payment_worksheets.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,

Line 68: x_bonus_ptd cn_payment_worksheets.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,

Line 69: x_bonus_paid cn_payment_worksheets.bonus_paid%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,

Line 70: x_payee_comm_due_bb cn_payment_worksheets.payee_comm_due_bb%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,

Line 71: x_payee_comm_ptd cn_payment_worksheets.payee_comm_ptd%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,

Line 72: x_payee_comm_paid cn_payment_worksheets.payee_comm_paid%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,

Line 73: x_payee_bonus_due_bb cn_payment_worksheets.payee_bonus_due_bb%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,

Line 74: x_payee_bonus_ptd cn_payment_worksheets.payee_bonus_ptd%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,

Line 75: x_payee_bonus_paid cn_payment_worksheets.payee_bonus_paid%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,

Line 76: x_convert_to_type_id cn_payment_worksheets.convert_to_type_id%TYPE := cn_api.g_miss_id,

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,

Line 77: x_credit_conv_fct_id cn_payment_worksheets.credit_conv_fct_id%TYPE := cn_api.g_miss_id,

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,

Line 78: x_convert_to_paid cn_payment_worksheets.convert_to_paid%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,

Line 79: x_reviewed_by_analyst cn_payment_worksheets_all.reviewed_by_analyst%TYPE := fnd_api.g_miss_char,

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,

Line 80: x_analyst_notes cn_payment_worksheets_all.analyst_notes%TYPE := fnd_api.g_miss_char,

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,

Line 81: x_posting_status cn_payment_worksheets.posting_status%TYPE := fnd_api.g_miss_char,

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,

Line 82: x_draw_recoverable_begin cn_payment_worksheets.draw_recoverable_begin%TYPE := fnd_api.g_miss_num,

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,

Line 83: x_adjust_paid cn_payment_worksheets.adjust_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,

Line 84: x_bonus_draw cn_payment_worksheets.bonus_draw%TYPE := fnd_api.g_miss_num,

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,

Line 85: x_reason cn_payment_worksheets.reason%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,

Line 86: x_bonus_reason cn_payment_worksheets.bonus_reason%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,

Line 87: x_recovery_method cn_payment_worksheets.recovery_method%TYPE := fnd_api.g_miss_char,

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,

Line 88: x_draw_ptd cn_payment_worksheets.draw_ptd%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,

Line 89: x_bonus_given cn_payment_worksheets.bonus_given%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,

Line 90: x_guarantee cn_payment_worksheets.guarantee%TYPE := fnd_api.g_miss_num,

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

Line 91: x_worksheet_status cn_payment_worksheets.worksheet_status%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: );

Line 92: x_last_update_date cn_payment_worksheets.last_update_date%TYPE,

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:

Line 93: x_last_updated_by cn_payment_worksheets.last_updated_by%TYPE,

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: --============================================================================

Line 94: x_last_update_login cn_payment_worksheets.last_update_login%TYPE

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

Line 111: x_object_version_number OUT NOCOPY cn_payment_worksheets.object_version_number%TYPE

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

Line 145: END cn_payment_worksheets_pkg;

141: x_payment_worksheet_id NUMBER
142: );
143:
144:
145: END cn_payment_worksheets_pkg;