[Home] [Help]
PACKAGE: APPS.PN_REC_EXPCL_DTL_PKG
Source
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,
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
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,
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
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;