1: PACKAGE pn_rec_expcl_dtl_pkg AUTHID CURRENT_USER AS
2: /* $Header: PNRECLSS.pls 115.1 2003/05/12 18:35:08 ftanudja noship $ */
3:
4: PROCEDURE insert_row(
5: x_org_id pn_rec_expcl_dtl.org_id%TYPE,
1: PACKAGE pn_rec_expcl_dtl_pkg AUTHID CURRENT_USER AS
2: /* $Header: PNRECLSS.pls 115.1 2003/05/12 18:35:08 ftanudja noship $ */
3:
4: PROCEDURE insert_row(
5: x_org_id pn_rec_expcl_dtl.org_id%TYPE,
6: x_expense_class_id pn_rec_expcl_dtl.expense_class_id%TYPE,
7: x_expense_line_id pn_rec_expcl_dtl.expense_line_id%TYPE,
8: x_expense_class_dtl_id IN OUT NOCOPY pn_rec_expcl_dtl.expense_class_dtl_id%TYPE,
9: x_status pn_rec_expcl_dtl.status%TYPE,
2: /* $Header: PNRECLSS.pls 115.1 2003/05/12 18:35:08 ftanudja noship $ */
3:
4: PROCEDURE insert_row(
5: x_org_id pn_rec_expcl_dtl.org_id%TYPE,
6: x_expense_class_id pn_rec_expcl_dtl.expense_class_id%TYPE,
7: x_expense_line_id pn_rec_expcl_dtl.expense_line_id%TYPE,
8: x_expense_class_dtl_id IN OUT NOCOPY pn_rec_expcl_dtl.expense_class_dtl_id%TYPE,
9: x_status pn_rec_expcl_dtl.status%TYPE,
10: x_def_area_cls_id pn_rec_expcl_dtl.default_area_class_id%TYPE,
3:
4: PROCEDURE insert_row(
5: x_org_id pn_rec_expcl_dtl.org_id%TYPE,
6: x_expense_class_id pn_rec_expcl_dtl.expense_class_id%TYPE,
7: x_expense_line_id pn_rec_expcl_dtl.expense_line_id%TYPE,
8: x_expense_class_dtl_id IN OUT NOCOPY pn_rec_expcl_dtl.expense_class_dtl_id%TYPE,
9: x_status pn_rec_expcl_dtl.status%TYPE,
10: x_def_area_cls_id pn_rec_expcl_dtl.default_area_class_id%TYPE,
11: x_cls_line_fee_bf_ct pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE,
4: PROCEDURE insert_row(
5: x_org_id pn_rec_expcl_dtl.org_id%TYPE,
6: x_expense_class_id pn_rec_expcl_dtl.expense_class_id%TYPE,
7: x_expense_line_id pn_rec_expcl_dtl.expense_line_id%TYPE,
8: x_expense_class_dtl_id IN OUT NOCOPY pn_rec_expcl_dtl.expense_class_dtl_id%TYPE,
9: x_status pn_rec_expcl_dtl.status%TYPE,
10: x_def_area_cls_id pn_rec_expcl_dtl.default_area_class_id%TYPE,
11: x_cls_line_fee_bf_ct pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE,
12: x_cls_line_fee_af_ct pn_rec_expcl_dtl.cls_line_fee_after_contr%TYPE,
5: x_org_id pn_rec_expcl_dtl.org_id%TYPE,
6: x_expense_class_id pn_rec_expcl_dtl.expense_class_id%TYPE,
7: x_expense_line_id pn_rec_expcl_dtl.expense_line_id%TYPE,
8: x_expense_class_dtl_id IN OUT NOCOPY pn_rec_expcl_dtl.expense_class_dtl_id%TYPE,
9: x_status pn_rec_expcl_dtl.status%TYPE,
10: x_def_area_cls_id pn_rec_expcl_dtl.default_area_class_id%TYPE,
11: x_cls_line_fee_bf_ct pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE,
12: x_cls_line_fee_af_ct pn_rec_expcl_dtl.cls_line_fee_after_contr%TYPE,
13: x_cls_line_portion_pct pn_rec_expcl_dtl.cls_line_portion_pct%TYPE,
6: x_expense_class_id pn_rec_expcl_dtl.expense_class_id%TYPE,
7: x_expense_line_id pn_rec_expcl_dtl.expense_line_id%TYPE,
8: x_expense_class_dtl_id IN OUT NOCOPY pn_rec_expcl_dtl.expense_class_dtl_id%TYPE,
9: x_status pn_rec_expcl_dtl.status%TYPE,
10: x_def_area_cls_id pn_rec_expcl_dtl.default_area_class_id%TYPE,
11: x_cls_line_fee_bf_ct pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE,
12: x_cls_line_fee_af_ct pn_rec_expcl_dtl.cls_line_fee_after_contr%TYPE,
13: x_cls_line_portion_pct pn_rec_expcl_dtl.cls_line_portion_pct%TYPE,
14: x_last_update_date pn_rec_expcl_dtl.last_update_date%TYPE,
7: x_expense_line_id pn_rec_expcl_dtl.expense_line_id%TYPE,
8: x_expense_class_dtl_id IN OUT NOCOPY pn_rec_expcl_dtl.expense_class_dtl_id%TYPE,
9: x_status pn_rec_expcl_dtl.status%TYPE,
10: x_def_area_cls_id pn_rec_expcl_dtl.default_area_class_id%TYPE,
11: x_cls_line_fee_bf_ct pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE,
12: x_cls_line_fee_af_ct pn_rec_expcl_dtl.cls_line_fee_after_contr%TYPE,
13: x_cls_line_portion_pct pn_rec_expcl_dtl.cls_line_portion_pct%TYPE,
14: x_last_update_date pn_rec_expcl_dtl.last_update_date%TYPE,
15: x_last_updated_by pn_rec_expcl_dtl.last_updated_by%TYPE,
8: x_expense_class_dtl_id IN OUT NOCOPY pn_rec_expcl_dtl.expense_class_dtl_id%TYPE,
9: x_status pn_rec_expcl_dtl.status%TYPE,
10: x_def_area_cls_id pn_rec_expcl_dtl.default_area_class_id%TYPE,
11: x_cls_line_fee_bf_ct pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE,
12: x_cls_line_fee_af_ct pn_rec_expcl_dtl.cls_line_fee_after_contr%TYPE,
13: x_cls_line_portion_pct pn_rec_expcl_dtl.cls_line_portion_pct%TYPE,
14: x_last_update_date pn_rec_expcl_dtl.last_update_date%TYPE,
15: x_last_updated_by pn_rec_expcl_dtl.last_updated_by%TYPE,
16: x_creation_date pn_rec_expcl_dtl.creation_date%TYPE,
9: x_status pn_rec_expcl_dtl.status%TYPE,
10: x_def_area_cls_id pn_rec_expcl_dtl.default_area_class_id%TYPE,
11: x_cls_line_fee_bf_ct pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE,
12: x_cls_line_fee_af_ct pn_rec_expcl_dtl.cls_line_fee_after_contr%TYPE,
13: x_cls_line_portion_pct pn_rec_expcl_dtl.cls_line_portion_pct%TYPE,
14: x_last_update_date pn_rec_expcl_dtl.last_update_date%TYPE,
15: x_last_updated_by pn_rec_expcl_dtl.last_updated_by%TYPE,
16: x_creation_date pn_rec_expcl_dtl.creation_date%TYPE,
17: x_created_by pn_rec_expcl_dtl.created_by%TYPE,
10: x_def_area_cls_id pn_rec_expcl_dtl.default_area_class_id%TYPE,
11: x_cls_line_fee_bf_ct pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE,
12: x_cls_line_fee_af_ct pn_rec_expcl_dtl.cls_line_fee_after_contr%TYPE,
13: x_cls_line_portion_pct pn_rec_expcl_dtl.cls_line_portion_pct%TYPE,
14: x_last_update_date pn_rec_expcl_dtl.last_update_date%TYPE,
15: x_last_updated_by pn_rec_expcl_dtl.last_updated_by%TYPE,
16: x_creation_date pn_rec_expcl_dtl.creation_date%TYPE,
17: x_created_by pn_rec_expcl_dtl.created_by%TYPE,
18: x_last_update_login pn_rec_expcl_dtl.last_update_login%TYPE
11: x_cls_line_fee_bf_ct pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE,
12: x_cls_line_fee_af_ct pn_rec_expcl_dtl.cls_line_fee_after_contr%TYPE,
13: x_cls_line_portion_pct pn_rec_expcl_dtl.cls_line_portion_pct%TYPE,
14: x_last_update_date pn_rec_expcl_dtl.last_update_date%TYPE,
15: x_last_updated_by pn_rec_expcl_dtl.last_updated_by%TYPE,
16: x_creation_date pn_rec_expcl_dtl.creation_date%TYPE,
17: x_created_by pn_rec_expcl_dtl.created_by%TYPE,
18: x_last_update_login pn_rec_expcl_dtl.last_update_login%TYPE
19: );
12: x_cls_line_fee_af_ct pn_rec_expcl_dtl.cls_line_fee_after_contr%TYPE,
13: x_cls_line_portion_pct pn_rec_expcl_dtl.cls_line_portion_pct%TYPE,
14: x_last_update_date pn_rec_expcl_dtl.last_update_date%TYPE,
15: x_last_updated_by pn_rec_expcl_dtl.last_updated_by%TYPE,
16: x_creation_date pn_rec_expcl_dtl.creation_date%TYPE,
17: x_created_by pn_rec_expcl_dtl.created_by%TYPE,
18: x_last_update_login pn_rec_expcl_dtl.last_update_login%TYPE
19: );
20:
13: x_cls_line_portion_pct pn_rec_expcl_dtl.cls_line_portion_pct%TYPE,
14: x_last_update_date pn_rec_expcl_dtl.last_update_date%TYPE,
15: x_last_updated_by pn_rec_expcl_dtl.last_updated_by%TYPE,
16: x_creation_date pn_rec_expcl_dtl.creation_date%TYPE,
17: x_created_by pn_rec_expcl_dtl.created_by%TYPE,
18: x_last_update_login pn_rec_expcl_dtl.last_update_login%TYPE
19: );
20:
21: PROCEDURE update_row(
14: x_last_update_date pn_rec_expcl_dtl.last_update_date%TYPE,
15: x_last_updated_by pn_rec_expcl_dtl.last_updated_by%TYPE,
16: x_creation_date pn_rec_expcl_dtl.creation_date%TYPE,
17: x_created_by pn_rec_expcl_dtl.created_by%TYPE,
18: x_last_update_login pn_rec_expcl_dtl.last_update_login%TYPE
19: );
20:
21: PROCEDURE update_row(
22: x_expense_class_id pn_rec_expcl_dtl.expense_class_id%TYPE,
18: x_last_update_login pn_rec_expcl_dtl.last_update_login%TYPE
19: );
20:
21: PROCEDURE update_row(
22: x_expense_class_id pn_rec_expcl_dtl.expense_class_id%TYPE,
23: x_expense_line_id pn_rec_expcl_dtl.expense_line_id%TYPE,
24: x_expense_class_dtl_id pn_rec_expcl_dtl.expense_class_dtl_id%TYPE,
25: x_status pn_rec_expcl_dtl.status%TYPE,
26: x_def_area_cls_id pn_rec_expcl_dtl.default_area_class_id%TYPE,
19: );
20:
21: PROCEDURE update_row(
22: x_expense_class_id pn_rec_expcl_dtl.expense_class_id%TYPE,
23: x_expense_line_id pn_rec_expcl_dtl.expense_line_id%TYPE,
24: x_expense_class_dtl_id pn_rec_expcl_dtl.expense_class_dtl_id%TYPE,
25: x_status pn_rec_expcl_dtl.status%TYPE,
26: x_def_area_cls_id pn_rec_expcl_dtl.default_area_class_id%TYPE,
27: x_cls_line_fee_bf_ct pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE,
20:
21: PROCEDURE update_row(
22: x_expense_class_id pn_rec_expcl_dtl.expense_class_id%TYPE,
23: x_expense_line_id pn_rec_expcl_dtl.expense_line_id%TYPE,
24: x_expense_class_dtl_id pn_rec_expcl_dtl.expense_class_dtl_id%TYPE,
25: x_status pn_rec_expcl_dtl.status%TYPE,
26: x_def_area_cls_id pn_rec_expcl_dtl.default_area_class_id%TYPE,
27: x_cls_line_fee_bf_ct pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE,
28: x_cls_line_fee_af_ct pn_rec_expcl_dtl.cls_line_fee_after_contr%TYPE,
21: PROCEDURE update_row(
22: x_expense_class_id pn_rec_expcl_dtl.expense_class_id%TYPE,
23: x_expense_line_id pn_rec_expcl_dtl.expense_line_id%TYPE,
24: x_expense_class_dtl_id pn_rec_expcl_dtl.expense_class_dtl_id%TYPE,
25: x_status pn_rec_expcl_dtl.status%TYPE,
26: x_def_area_cls_id pn_rec_expcl_dtl.default_area_class_id%TYPE,
27: x_cls_line_fee_bf_ct pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE,
28: x_cls_line_fee_af_ct pn_rec_expcl_dtl.cls_line_fee_after_contr%TYPE,
29: x_cls_line_portion_pct pn_rec_expcl_dtl.cls_line_portion_pct%TYPE,
22: x_expense_class_id pn_rec_expcl_dtl.expense_class_id%TYPE,
23: x_expense_line_id pn_rec_expcl_dtl.expense_line_id%TYPE,
24: x_expense_class_dtl_id pn_rec_expcl_dtl.expense_class_dtl_id%TYPE,
25: x_status pn_rec_expcl_dtl.status%TYPE,
26: x_def_area_cls_id pn_rec_expcl_dtl.default_area_class_id%TYPE,
27: x_cls_line_fee_bf_ct pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE,
28: x_cls_line_fee_af_ct pn_rec_expcl_dtl.cls_line_fee_after_contr%TYPE,
29: x_cls_line_portion_pct pn_rec_expcl_dtl.cls_line_portion_pct%TYPE,
30: x_last_update_date pn_rec_expcl_dtl.last_update_date%TYPE,
23: x_expense_line_id pn_rec_expcl_dtl.expense_line_id%TYPE,
24: x_expense_class_dtl_id pn_rec_expcl_dtl.expense_class_dtl_id%TYPE,
25: x_status pn_rec_expcl_dtl.status%TYPE,
26: x_def_area_cls_id pn_rec_expcl_dtl.default_area_class_id%TYPE,
27: x_cls_line_fee_bf_ct pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE,
28: x_cls_line_fee_af_ct pn_rec_expcl_dtl.cls_line_fee_after_contr%TYPE,
29: x_cls_line_portion_pct pn_rec_expcl_dtl.cls_line_portion_pct%TYPE,
30: x_last_update_date pn_rec_expcl_dtl.last_update_date%TYPE,
31: x_last_updated_by pn_rec_expcl_dtl.last_updated_by%TYPE,
24: x_expense_class_dtl_id pn_rec_expcl_dtl.expense_class_dtl_id%TYPE,
25: x_status pn_rec_expcl_dtl.status%TYPE,
26: x_def_area_cls_id pn_rec_expcl_dtl.default_area_class_id%TYPE,
27: x_cls_line_fee_bf_ct pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE,
28: x_cls_line_fee_af_ct pn_rec_expcl_dtl.cls_line_fee_after_contr%TYPE,
29: x_cls_line_portion_pct pn_rec_expcl_dtl.cls_line_portion_pct%TYPE,
30: x_last_update_date pn_rec_expcl_dtl.last_update_date%TYPE,
31: x_last_updated_by pn_rec_expcl_dtl.last_updated_by%TYPE,
32: x_creation_date pn_rec_expcl_dtl.creation_date%TYPE,
25: x_status pn_rec_expcl_dtl.status%TYPE,
26: x_def_area_cls_id pn_rec_expcl_dtl.default_area_class_id%TYPE,
27: x_cls_line_fee_bf_ct pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE,
28: x_cls_line_fee_af_ct pn_rec_expcl_dtl.cls_line_fee_after_contr%TYPE,
29: x_cls_line_portion_pct pn_rec_expcl_dtl.cls_line_portion_pct%TYPE,
30: x_last_update_date pn_rec_expcl_dtl.last_update_date%TYPE,
31: x_last_updated_by pn_rec_expcl_dtl.last_updated_by%TYPE,
32: x_creation_date pn_rec_expcl_dtl.creation_date%TYPE,
33: x_created_by pn_rec_expcl_dtl.created_by%TYPE,
26: x_def_area_cls_id pn_rec_expcl_dtl.default_area_class_id%TYPE,
27: x_cls_line_fee_bf_ct pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE,
28: x_cls_line_fee_af_ct pn_rec_expcl_dtl.cls_line_fee_after_contr%TYPE,
29: x_cls_line_portion_pct pn_rec_expcl_dtl.cls_line_portion_pct%TYPE,
30: x_last_update_date pn_rec_expcl_dtl.last_update_date%TYPE,
31: x_last_updated_by pn_rec_expcl_dtl.last_updated_by%TYPE,
32: x_creation_date pn_rec_expcl_dtl.creation_date%TYPE,
33: x_created_by pn_rec_expcl_dtl.created_by%TYPE,
34: x_last_update_login pn_rec_expcl_dtl.last_update_login%TYPE
27: x_cls_line_fee_bf_ct pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE,
28: x_cls_line_fee_af_ct pn_rec_expcl_dtl.cls_line_fee_after_contr%TYPE,
29: x_cls_line_portion_pct pn_rec_expcl_dtl.cls_line_portion_pct%TYPE,
30: x_last_update_date pn_rec_expcl_dtl.last_update_date%TYPE,
31: x_last_updated_by pn_rec_expcl_dtl.last_updated_by%TYPE,
32: x_creation_date pn_rec_expcl_dtl.creation_date%TYPE,
33: x_created_by pn_rec_expcl_dtl.created_by%TYPE,
34: x_last_update_login pn_rec_expcl_dtl.last_update_login%TYPE
35: );
28: x_cls_line_fee_af_ct pn_rec_expcl_dtl.cls_line_fee_after_contr%TYPE,
29: x_cls_line_portion_pct pn_rec_expcl_dtl.cls_line_portion_pct%TYPE,
30: x_last_update_date pn_rec_expcl_dtl.last_update_date%TYPE,
31: x_last_updated_by pn_rec_expcl_dtl.last_updated_by%TYPE,
32: x_creation_date pn_rec_expcl_dtl.creation_date%TYPE,
33: x_created_by pn_rec_expcl_dtl.created_by%TYPE,
34: x_last_update_login pn_rec_expcl_dtl.last_update_login%TYPE
35: );
36:
29: x_cls_line_portion_pct pn_rec_expcl_dtl.cls_line_portion_pct%TYPE,
30: x_last_update_date pn_rec_expcl_dtl.last_update_date%TYPE,
31: x_last_updated_by pn_rec_expcl_dtl.last_updated_by%TYPE,
32: x_creation_date pn_rec_expcl_dtl.creation_date%TYPE,
33: x_created_by pn_rec_expcl_dtl.created_by%TYPE,
34: x_last_update_login pn_rec_expcl_dtl.last_update_login%TYPE
35: );
36:
37: PROCEDURE delete_row(x_expense_class_dtl_id pn_rec_expcl_dtl.expense_class_dtl_id%TYPE);
30: x_last_update_date pn_rec_expcl_dtl.last_update_date%TYPE,
31: x_last_updated_by pn_rec_expcl_dtl.last_updated_by%TYPE,
32: x_creation_date pn_rec_expcl_dtl.creation_date%TYPE,
33: x_created_by pn_rec_expcl_dtl.created_by%TYPE,
34: x_last_update_login pn_rec_expcl_dtl.last_update_login%TYPE
35: );
36:
37: PROCEDURE delete_row(x_expense_class_dtl_id pn_rec_expcl_dtl.expense_class_dtl_id%TYPE);
38:
33: x_created_by pn_rec_expcl_dtl.created_by%TYPE,
34: x_last_update_login pn_rec_expcl_dtl.last_update_login%TYPE
35: );
36:
37: PROCEDURE delete_row(x_expense_class_dtl_id pn_rec_expcl_dtl.expense_class_dtl_id%TYPE);
38:
39: END pn_rec_expcl_dtl_pkg;
35: );
36:
37: PROCEDURE delete_row(x_expense_class_dtl_id pn_rec_expcl_dtl.expense_class_dtl_id%TYPE);
38:
39: END pn_rec_expcl_dtl_pkg;