APPS.PN_REC_EXPCL_DTLLN_PKG dependencies on PN_REC_EXPCL_DTLLN

Line 1: PACKAGE pn_rec_expcl_dtlln_pkg AUTHID CURRENT_USER AS

1: PACKAGE pn_rec_expcl_dtlln_pkg AUTHID CURRENT_USER AS
2: /* $Header: PNRECLNS.pls 115.2 2003/05/12 18:35:53 ftanudja noship $ */
3:
4: PROCEDURE insert_row(
5: x_org_id pn_rec_expcl_dtlln.org_id%TYPE,

Line 5: x_org_id pn_rec_expcl_dtlln.org_id%TYPE,

1: PACKAGE pn_rec_expcl_dtlln_pkg AUTHID CURRENT_USER AS
2: /* $Header: PNRECLNS.pls 115.2 2003/05/12 18:35:53 ftanudja noship $ */
3:
4: PROCEDURE insert_row(
5: x_org_id pn_rec_expcl_dtlln.org_id%TYPE,
6: x_expense_class_dtl_id pn_rec_expcl_dtlln.expense_class_dtl_id%TYPE,
7: x_expense_class_line_id IN OUT NOCOPY pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
8: x_location_id pn_rec_expcl_dtlln.location_id%TYPE,
9: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,

Line 6: x_expense_class_dtl_id pn_rec_expcl_dtlln.expense_class_dtl_id%TYPE,

2: /* $Header: PNRECLNS.pls 115.2 2003/05/12 18:35:53 ftanudja noship $ */
3:
4: PROCEDURE insert_row(
5: x_org_id pn_rec_expcl_dtlln.org_id%TYPE,
6: x_expense_class_dtl_id pn_rec_expcl_dtlln.expense_class_dtl_id%TYPE,
7: x_expense_class_line_id IN OUT NOCOPY pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
8: x_location_id pn_rec_expcl_dtlln.location_id%TYPE,
9: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,
10: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,

Line 7: x_expense_class_line_id IN OUT NOCOPY pn_rec_expcl_dtlln.expense_class_line_id%TYPE,

3:
4: PROCEDURE insert_row(
5: x_org_id pn_rec_expcl_dtlln.org_id%TYPE,
6: x_expense_class_dtl_id pn_rec_expcl_dtlln.expense_class_dtl_id%TYPE,
7: x_expense_class_line_id IN OUT NOCOPY pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
8: x_location_id pn_rec_expcl_dtlln.location_id%TYPE,
9: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,
10: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
11: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,

Line 8: x_location_id pn_rec_expcl_dtlln.location_id%TYPE,

4: PROCEDURE insert_row(
5: x_org_id pn_rec_expcl_dtlln.org_id%TYPE,
6: x_expense_class_dtl_id pn_rec_expcl_dtlln.expense_class_dtl_id%TYPE,
7: x_expense_class_line_id IN OUT NOCOPY pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
8: x_location_id pn_rec_expcl_dtlln.location_id%TYPE,
9: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,
10: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
11: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
12: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,

Line 9: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,

5: x_org_id pn_rec_expcl_dtlln.org_id%TYPE,
6: x_expense_class_dtl_id pn_rec_expcl_dtlln.expense_class_dtl_id%TYPE,
7: x_expense_class_line_id IN OUT NOCOPY pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
8: x_location_id pn_rec_expcl_dtlln.location_id%TYPE,
9: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,
10: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
11: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
12: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
13: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,

Line 10: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,

6: x_expense_class_dtl_id pn_rec_expcl_dtlln.expense_class_dtl_id%TYPE,
7: x_expense_class_line_id IN OUT NOCOPY pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
8: x_location_id pn_rec_expcl_dtlln.location_id%TYPE,
9: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,
10: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
11: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
12: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
13: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
14: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,

Line 11: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,

7: x_expense_class_line_id IN OUT NOCOPY pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
8: x_location_id pn_rec_expcl_dtlln.location_id%TYPE,
9: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,
10: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
11: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
12: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
13: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
14: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,
15: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,

Line 12: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,

8: x_location_id pn_rec_expcl_dtlln.location_id%TYPE,
9: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,
10: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
11: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
12: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
13: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
14: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,
15: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,
16: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,

Line 13: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,

9: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,
10: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
11: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
12: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
13: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
14: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,
15: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,
16: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,
17: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,

Line 14: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,

10: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
11: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
12: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
13: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
14: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,
15: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,
16: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,
17: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
18: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,

Line 15: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,

11: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
12: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
13: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
14: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,
15: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,
16: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,
17: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
18: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
19: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,

Line 16: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,

12: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
13: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
14: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,
15: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,
16: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,
17: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
18: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
19: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
20: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,

Line 17: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,

13: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
14: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,
15: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,
16: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,
17: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
18: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
19: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
20: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
21: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,

Line 18: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,

14: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,
15: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,
16: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,
17: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
18: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
19: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
20: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
21: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,
22: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,

Line 19: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,

15: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,
16: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,
17: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
18: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
19: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
20: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
21: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,
22: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,
23: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,

Line 20: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,

16: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,
17: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
18: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
19: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
20: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
21: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,
22: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,
23: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,
24: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,

Line 21: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,

17: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
18: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
19: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
20: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
21: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,
22: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,
23: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,
24: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,
25: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,

Line 22: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,

18: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
19: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
20: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
21: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,
22: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,
23: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,
24: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,
25: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,
26: x_created_by pn_rec_expcl_dtlln.created_by%TYPE,

Line 23: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,

19: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
20: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
21: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,
22: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,
23: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,
24: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,
25: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,
26: x_created_by pn_rec_expcl_dtlln.created_by%TYPE,
27: x_last_update_login pn_rec_expcl_dtlln.last_update_login%TYPE

Line 24: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,

20: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
21: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,
22: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,
23: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,
24: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,
25: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,
26: x_created_by pn_rec_expcl_dtlln.created_by%TYPE,
27: x_last_update_login pn_rec_expcl_dtlln.last_update_login%TYPE
28: );

Line 25: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,

21: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,
22: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,
23: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,
24: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,
25: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,
26: x_created_by pn_rec_expcl_dtlln.created_by%TYPE,
27: x_last_update_login pn_rec_expcl_dtlln.last_update_login%TYPE
28: );
29:

Line 26: x_created_by pn_rec_expcl_dtlln.created_by%TYPE,

22: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,
23: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,
24: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,
25: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,
26: x_created_by pn_rec_expcl_dtlln.created_by%TYPE,
27: x_last_update_login pn_rec_expcl_dtlln.last_update_login%TYPE
28: );
29:
30: PROCEDURE update_row(

Line 27: x_last_update_login pn_rec_expcl_dtlln.last_update_login%TYPE

23: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,
24: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,
25: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,
26: x_created_by pn_rec_expcl_dtlln.created_by%TYPE,
27: x_last_update_login pn_rec_expcl_dtlln.last_update_login%TYPE
28: );
29:
30: PROCEDURE update_row(
31: x_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,

Line 31: x_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,

27: x_last_update_login pn_rec_expcl_dtlln.last_update_login%TYPE
28: );
29:
30: PROCEDURE update_row(
31: x_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
32: x_location_id pn_rec_expcl_dtlln.location_id%TYPE,
33: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,
34: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
35: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,

Line 32: x_location_id pn_rec_expcl_dtlln.location_id%TYPE,

28: );
29:
30: PROCEDURE update_row(
31: x_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
32: x_location_id pn_rec_expcl_dtlln.location_id%TYPE,
33: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,
34: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
35: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
36: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,

Line 33: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,

29:
30: PROCEDURE update_row(
31: x_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
32: x_location_id pn_rec_expcl_dtlln.location_id%TYPE,
33: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,
34: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
35: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
36: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
37: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,

Line 34: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,

30: PROCEDURE update_row(
31: x_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
32: x_location_id pn_rec_expcl_dtlln.location_id%TYPE,
33: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,
34: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
35: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
36: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
37: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
38: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,

Line 35: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,

31: x_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
32: x_location_id pn_rec_expcl_dtlln.location_id%TYPE,
33: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,
34: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
35: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
36: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
37: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
38: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,
39: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,

Line 36: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,

32: x_location_id pn_rec_expcl_dtlln.location_id%TYPE,
33: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,
34: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
35: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
36: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
37: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
38: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,
39: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,
40: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,

Line 37: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,

33: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,
34: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
35: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
36: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
37: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
38: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,
39: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,
40: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,
41: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,

Line 38: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,

34: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
35: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
36: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
37: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
38: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,
39: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,
40: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,
41: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
42: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,

Line 39: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,

35: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
36: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
37: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
38: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,
39: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,
40: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,
41: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
42: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
43: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,

Line 40: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,

36: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
37: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
38: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,
39: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,
40: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,
41: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
42: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
43: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
44: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,

Line 41: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,

37: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
38: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,
39: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,
40: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,
41: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
42: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
43: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
44: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
45: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,

Line 42: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,

38: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,
39: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,
40: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,
41: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
42: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
43: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
44: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
45: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,
46: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,

Line 43: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,

39: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,
40: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,
41: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
42: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
43: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
44: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
45: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,
46: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,
47: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,

Line 44: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,

40: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,
41: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
42: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
43: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
44: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
45: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,
46: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,
47: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,
48: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,

Line 45: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,

41: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
42: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
43: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
44: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
45: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,
46: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,
47: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,
48: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,
49: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,

Line 46: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,

42: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
43: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
44: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
45: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,
46: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,
47: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,
48: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,
49: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,
50: x_created_by pn_rec_expcl_dtlln.created_by%TYPE,

Line 47: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,

43: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
44: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
45: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,
46: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,
47: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,
48: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,
49: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,
50: x_created_by pn_rec_expcl_dtlln.created_by%TYPE,
51: x_last_update_login pn_rec_expcl_dtlln.last_update_login%TYPE

Line 48: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,

44: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
45: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,
46: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,
47: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,
48: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,
49: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,
50: x_created_by pn_rec_expcl_dtlln.created_by%TYPE,
51: x_last_update_login pn_rec_expcl_dtlln.last_update_login%TYPE
52: );

Line 49: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,

45: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,
46: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,
47: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,
48: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,
49: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,
50: x_created_by pn_rec_expcl_dtlln.created_by%TYPE,
51: x_last_update_login pn_rec_expcl_dtlln.last_update_login%TYPE
52: );
53:

Line 50: x_created_by pn_rec_expcl_dtlln.created_by%TYPE,

46: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,
47: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,
48: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,
49: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,
50: x_created_by pn_rec_expcl_dtlln.created_by%TYPE,
51: x_last_update_login pn_rec_expcl_dtlln.last_update_login%TYPE
52: );
53:
54: PROCEDURE delete_row(x_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE);

Line 51: x_last_update_login pn_rec_expcl_dtlln.last_update_login%TYPE

47: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,
48: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,
49: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,
50: x_created_by pn_rec_expcl_dtlln.created_by%TYPE,
51: x_last_update_login pn_rec_expcl_dtlln.last_update_login%TYPE
52: );
53:
54: PROCEDURE delete_row(x_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE);
55:

Line 54: PROCEDURE delete_row(x_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE);

50: x_created_by pn_rec_expcl_dtlln.created_by%TYPE,
51: x_last_update_login pn_rec_expcl_dtlln.last_update_login%TYPE
52: );
53:
54: PROCEDURE delete_row(x_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE);
55:
56: END pn_rec_expcl_dtlln_pkg;

Line 56: END pn_rec_expcl_dtlln_pkg;

52: );
53:
54: PROCEDURE delete_row(x_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE);
55:
56: END pn_rec_expcl_dtlln_pkg;