1: PACKAGE pn_rec_expcl_dtlacc_pkg AUTHID CURRENT_USER AS
2: /* $Header: PNRECLDS.pls 115.2 2003/05/13 18:22:52 ftanudja noship $ */
3:
4: PROCEDURE insert_row(
5: x_org_id pn_rec_expcl_dtlacc.org_id%TYPE,
1: PACKAGE pn_rec_expcl_dtlacc_pkg AUTHID CURRENT_USER AS
2: /* $Header: PNRECLDS.pls 115.2 2003/05/13 18:22:52 ftanudja noship $ */
3:
4: PROCEDURE insert_row(
5: x_org_id pn_rec_expcl_dtlacc.org_id%TYPE,
6: x_expense_class_line_id pn_rec_expcl_dtlacc.expense_class_line_id%TYPE,
7: x_expense_class_line_dtl_id IN OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
8: x_expense_line_dtl_id pn_rec_expcl_dtlacc.expense_line_dtl_id%TYPE,
9: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
2: /* $Header: PNRECLDS.pls 115.2 2003/05/13 18:22:52 ftanudja noship $ */
3:
4: PROCEDURE insert_row(
5: x_org_id pn_rec_expcl_dtlacc.org_id%TYPE,
6: x_expense_class_line_id pn_rec_expcl_dtlacc.expense_class_line_id%TYPE,
7: x_expense_class_line_dtl_id IN OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
8: x_expense_line_dtl_id pn_rec_expcl_dtlacc.expense_line_dtl_id%TYPE,
9: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
10: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
3:
4: PROCEDURE insert_row(
5: x_org_id pn_rec_expcl_dtlacc.org_id%TYPE,
6: x_expense_class_line_id pn_rec_expcl_dtlacc.expense_class_line_id%TYPE,
7: x_expense_class_line_dtl_id IN OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
8: x_expense_line_dtl_id pn_rec_expcl_dtlacc.expense_line_dtl_id%TYPE,
9: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
10: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
11: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
4: PROCEDURE insert_row(
5: x_org_id pn_rec_expcl_dtlacc.org_id%TYPE,
6: x_expense_class_line_id pn_rec_expcl_dtlacc.expense_class_line_id%TYPE,
7: x_expense_class_line_dtl_id IN OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
8: x_expense_line_dtl_id pn_rec_expcl_dtlacc.expense_line_dtl_id%TYPE,
9: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
10: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
11: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
12: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
5: x_org_id pn_rec_expcl_dtlacc.org_id%TYPE,
6: x_expense_class_line_id pn_rec_expcl_dtlacc.expense_class_line_id%TYPE,
7: x_expense_class_line_dtl_id IN OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
8: x_expense_line_dtl_id pn_rec_expcl_dtlacc.expense_line_dtl_id%TYPE,
9: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
10: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
11: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
12: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
13: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
6: x_expense_class_line_id pn_rec_expcl_dtlacc.expense_class_line_id%TYPE,
7: x_expense_class_line_dtl_id IN OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
8: x_expense_line_dtl_id pn_rec_expcl_dtlacc.expense_line_dtl_id%TYPE,
9: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
10: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
11: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
12: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
13: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
14: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
7: x_expense_class_line_dtl_id IN OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
8: x_expense_line_dtl_id pn_rec_expcl_dtlacc.expense_line_dtl_id%TYPE,
9: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
10: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
11: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
12: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
13: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
14: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
15: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
8: x_expense_line_dtl_id pn_rec_expcl_dtlacc.expense_line_dtl_id%TYPE,
9: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
10: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
11: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
12: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
13: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
14: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
15: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
16: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
9: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
10: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
11: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
12: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
13: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
14: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
15: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
16: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
17: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
10: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
11: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
12: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
13: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
14: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
15: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
16: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
17: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
18: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
11: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
12: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
13: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
14: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
15: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
16: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
17: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
18: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
19: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
12: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
13: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
14: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
15: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
16: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
17: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
18: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
19: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
20: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,
13: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
14: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
15: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
16: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
17: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
18: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
19: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
20: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,
21: x_creation_date pn_rec_expcl_dtlacc.creation_date%TYPE,
14: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
15: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
16: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
17: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
18: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
19: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
20: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,
21: x_creation_date pn_rec_expcl_dtlacc.creation_date%TYPE,
22: x_created_by pn_rec_expcl_dtlacc.created_by%TYPE,
15: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
16: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
17: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
18: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
19: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
20: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,
21: x_creation_date pn_rec_expcl_dtlacc.creation_date%TYPE,
22: x_created_by pn_rec_expcl_dtlacc.created_by%TYPE,
23: x_last_update_login pn_rec_expcl_dtlacc.last_update_login%TYPE
16: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
17: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
18: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
19: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
20: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,
21: x_creation_date pn_rec_expcl_dtlacc.creation_date%TYPE,
22: x_created_by pn_rec_expcl_dtlacc.created_by%TYPE,
23: x_last_update_login pn_rec_expcl_dtlacc.last_update_login%TYPE
24: );
17: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
18: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
19: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
20: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,
21: x_creation_date pn_rec_expcl_dtlacc.creation_date%TYPE,
22: x_created_by pn_rec_expcl_dtlacc.created_by%TYPE,
23: x_last_update_login pn_rec_expcl_dtlacc.last_update_login%TYPE
24: );
25:
18: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
19: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
20: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,
21: x_creation_date pn_rec_expcl_dtlacc.creation_date%TYPE,
22: x_created_by pn_rec_expcl_dtlacc.created_by%TYPE,
23: x_last_update_login pn_rec_expcl_dtlacc.last_update_login%TYPE
24: );
25:
26: PROCEDURE update_row(
19: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
20: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,
21: x_creation_date pn_rec_expcl_dtlacc.creation_date%TYPE,
22: x_created_by pn_rec_expcl_dtlacc.created_by%TYPE,
23: x_last_update_login pn_rec_expcl_dtlacc.last_update_login%TYPE
24: );
25:
26: PROCEDURE update_row(
27: x_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
23: x_last_update_login pn_rec_expcl_dtlacc.last_update_login%TYPE
24: );
25:
26: PROCEDURE update_row(
27: x_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
28: x_expense_line_dtl_id pn_rec_expcl_dtlacc.expense_line_dtl_id%TYPE,
29: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
30: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
31: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
24: );
25:
26: PROCEDURE update_row(
27: x_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
28: x_expense_line_dtl_id pn_rec_expcl_dtlacc.expense_line_dtl_id%TYPE,
29: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
30: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
31: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
32: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
25:
26: PROCEDURE update_row(
27: x_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
28: x_expense_line_dtl_id pn_rec_expcl_dtlacc.expense_line_dtl_id%TYPE,
29: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
30: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
31: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
32: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
33: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
26: PROCEDURE update_row(
27: x_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
28: x_expense_line_dtl_id pn_rec_expcl_dtlacc.expense_line_dtl_id%TYPE,
29: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
30: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
31: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
32: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
33: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
34: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
27: x_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
28: x_expense_line_dtl_id pn_rec_expcl_dtlacc.expense_line_dtl_id%TYPE,
29: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
30: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
31: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
32: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
33: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
34: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
35: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
28: x_expense_line_dtl_id pn_rec_expcl_dtlacc.expense_line_dtl_id%TYPE,
29: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
30: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
31: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
32: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
33: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
34: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
35: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
36: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
29: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
30: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
31: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
32: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
33: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
34: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
35: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
36: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
37: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
30: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
31: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
32: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
33: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
34: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
35: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
36: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
37: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
38: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
31: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
32: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
33: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
34: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
35: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
36: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
37: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
38: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
39: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
32: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
33: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
34: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
35: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
36: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
37: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
38: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
39: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
40: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,
33: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
34: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
35: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
36: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
37: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
38: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
39: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
40: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,
41: x_creation_date pn_rec_expcl_dtlacc.creation_date%TYPE,
34: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
35: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
36: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
37: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
38: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
39: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
40: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,
41: x_creation_date pn_rec_expcl_dtlacc.creation_date%TYPE,
42: x_created_by pn_rec_expcl_dtlacc.created_by%TYPE,
35: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
36: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
37: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
38: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
39: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
40: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,
41: x_creation_date pn_rec_expcl_dtlacc.creation_date%TYPE,
42: x_created_by pn_rec_expcl_dtlacc.created_by%TYPE,
43: x_last_update_login pn_rec_expcl_dtlacc.last_update_login%TYPE
36: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
37: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
38: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
39: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
40: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,
41: x_creation_date pn_rec_expcl_dtlacc.creation_date%TYPE,
42: x_created_by pn_rec_expcl_dtlacc.created_by%TYPE,
43: x_last_update_login pn_rec_expcl_dtlacc.last_update_login%TYPE
44: );
37: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
38: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
39: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
40: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,
41: x_creation_date pn_rec_expcl_dtlacc.creation_date%TYPE,
42: x_created_by pn_rec_expcl_dtlacc.created_by%TYPE,
43: x_last_update_login pn_rec_expcl_dtlacc.last_update_login%TYPE
44: );
45:
38: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
39: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
40: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,
41: x_creation_date pn_rec_expcl_dtlacc.creation_date%TYPE,
42: x_created_by pn_rec_expcl_dtlacc.created_by%TYPE,
43: x_last_update_login pn_rec_expcl_dtlacc.last_update_login%TYPE
44: );
45:
46: PROCEDURE delete_row(x_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE);
39: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
40: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,
41: x_creation_date pn_rec_expcl_dtlacc.creation_date%TYPE,
42: x_created_by pn_rec_expcl_dtlacc.created_by%TYPE,
43: x_last_update_login pn_rec_expcl_dtlacc.last_update_login%TYPE
44: );
45:
46: PROCEDURE delete_row(x_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE);
47:
42: x_created_by pn_rec_expcl_dtlacc.created_by%TYPE,
43: x_last_update_login pn_rec_expcl_dtlacc.last_update_login%TYPE
44: );
45:
46: PROCEDURE delete_row(x_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE);
47:
48: END pn_rec_expcl_dtlacc_pkg;
44: );
45:
46: PROCEDURE delete_row(x_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE);
47:
48: END pn_rec_expcl_dtlacc_pkg;