eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.PN_REC_EXPCL_DTLLN_PKG

Source


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,
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,
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
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,
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,
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);
55 
56 END pn_rec_expcl_dtlln_pkg;