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_EXP_LINE_DTL_PKG

Source


1 PACKAGE pn_rec_exp_line_dtl_pkg AUTHID CURRENT_USER AS
2 /* $Header: PNREXLDS.pls 115.3 2003/08/15 23:13:01 ftanudja noship $ */
3 
4 PROCEDURE insert_row(
5              x_org_id                   pn_rec_exp_line_dtl.org_id%TYPE,
6              x_expense_line_id          pn_rec_exp_line_dtl.expense_line_id%TYPE,
7              x_expense_line_dtl_id      IN OUT NOCOPY pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,
8              x_parent_expense_line_id   pn_rec_exp_line_dtl.parent_expense_line_id%TYPE,
9              x_location_id              pn_rec_exp_line_dtl.location_id%TYPE,
10              x_property_id              pn_rec_exp_line_dtl.property_id%TYPE,
11              x_expense_type_code        pn_rec_exp_line_dtl.expense_type_code%TYPE,
12              x_expense_account_id       pn_rec_exp_line_dtl.expense_account_id%TYPE,
13              x_account_description      pn_rec_exp_line_dtl.account_description%TYPE,
14              x_actual_amount            pn_rec_exp_line_dtl.actual_amount%TYPE,
15              x_actual_amount_ovr        pn_rec_exp_line_dtl.actual_amount_ovr%TYPE,
16              x_budgeted_amount          pn_rec_exp_line_dtl.budgeted_amount%TYPE,
17              x_budgeted_amount_ovr      pn_rec_exp_line_dtl.budgeted_amount_ovr%TYPE,
18              x_budgeted_pct             pn_rec_exp_line_dtl.budgeted_pct%TYPE,
19              x_actual_pct               pn_rec_exp_line_dtl.actual_pct%TYPE,
20              x_currency_code            pn_rec_exp_line_dtl.currency_code%TYPE,
21              x_recoverable_flag         pn_rec_exp_line_dtl.recoverable_flag%TYPE,
22              x_expense_line_indicator   pn_rec_exp_line_dtl.expense_line_indicator%TYPE,
23              x_last_update_date         pn_rec_exp_line_dtl.last_update_date%TYPE,
24              x_last_updated_by          pn_rec_exp_line_dtl.last_updated_by%TYPE,
25              x_creation_date            pn_rec_exp_line_dtl.creation_date%TYPE,
26              x_created_by               pn_rec_exp_line_dtl.created_by%TYPE,
27              x_last_update_login        pn_rec_exp_line_dtl.last_update_login%TYPE,
28              x_attribute_category       pn_rec_exp_line_dtl.attribute_category%TYPE,
29              x_attribute1               pn_rec_exp_line_dtl.attribute1%TYPE,
30              x_attribute2               pn_rec_exp_line_dtl.attribute2%TYPE,
31              x_attribute3               pn_rec_exp_line_dtl.attribute3%TYPE,
32              x_attribute4               pn_rec_exp_line_dtl.attribute4%TYPE,
33              x_attribute5               pn_rec_exp_line_dtl.attribute5%TYPE,
34              x_attribute6               pn_rec_exp_line_dtl.attribute6%TYPE,
35              x_attribute7               pn_rec_exp_line_dtl.attribute7%TYPE,
36              x_attribute8               pn_rec_exp_line_dtl.attribute8%TYPE,
37              x_attribute9               pn_rec_exp_line_dtl.attribute9%TYPE,
38              x_attribute10              pn_rec_exp_line_dtl.attribute10%TYPE,
39              x_attribute11              pn_rec_exp_line_dtl.attribute11%TYPE,
40              x_attribute12              pn_rec_exp_line_dtl.attribute12%TYPE,
41              x_attribute13              pn_rec_exp_line_dtl.attribute13%TYPE,
42              x_attribute14              pn_rec_exp_line_dtl.attribute14%TYPE,
43              x_attribute15              pn_rec_exp_line_dtl.attribute15%TYPE);
44 
45 PROCEDURE update_row(
46              x_expense_line_dtl_id      pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,
47              x_parent_expense_line_id   pn_rec_exp_line_dtl.parent_expense_line_id%TYPE,
48              x_location_id              pn_rec_exp_line_dtl.location_id%TYPE,
49              x_property_id              pn_rec_exp_line_dtl.property_id%TYPE,
50              x_expense_type_code        pn_rec_exp_line_dtl.expense_type_code%TYPE,
51              x_expense_account_id       pn_rec_exp_line_dtl.expense_account_id%TYPE,
52              x_account_description      pn_rec_exp_line_dtl.account_description%TYPE,
53              x_actual_amount            pn_rec_exp_line_dtl.actual_amount%TYPE,
54              x_actual_amount_ovr        pn_rec_exp_line_dtl.actual_amount_ovr%TYPE,
55              x_budgeted_amount          pn_rec_exp_line_dtl.budgeted_amount%TYPE,
56              x_budgeted_amount_ovr      pn_rec_exp_line_dtl.budgeted_amount_ovr%TYPE,
57              x_budgeted_pct             pn_rec_exp_line_dtl.budgeted_pct%TYPE,
58              x_actual_pct               pn_rec_exp_line_dtl.actual_pct%TYPE,
59              x_currency_code            pn_rec_exp_line_dtl.currency_code%TYPE,
60              x_recoverable_flag         pn_rec_exp_line_dtl.recoverable_flag%TYPE,
61              x_expense_line_indicator   pn_rec_exp_line_dtl.expense_line_indicator%TYPE,
62              x_last_update_date         pn_rec_exp_line_dtl.last_update_date%TYPE,
63              x_last_updated_by          pn_rec_exp_line_dtl.last_updated_by%TYPE,
64              x_creation_date            pn_rec_exp_line_dtl.creation_date%TYPE,
65              x_created_by               pn_rec_exp_line_dtl.created_by%TYPE,
66              x_last_update_login        pn_rec_exp_line_dtl.last_update_login%TYPE,
67              x_attribute_category       pn_rec_exp_line_dtl.attribute_category%TYPE,
68              x_attribute1               pn_rec_exp_line_dtl.attribute1%TYPE,
69              x_attribute2               pn_rec_exp_line_dtl.attribute2%TYPE,
70              x_attribute3               pn_rec_exp_line_dtl.attribute3%TYPE,
71              x_attribute4               pn_rec_exp_line_dtl.attribute4%TYPE,
72              x_attribute5               pn_rec_exp_line_dtl.attribute5%TYPE,
73              x_attribute6               pn_rec_exp_line_dtl.attribute6%TYPE,
74              x_attribute7               pn_rec_exp_line_dtl.attribute7%TYPE,
75              x_attribute8               pn_rec_exp_line_dtl.attribute8%TYPE,
76              x_attribute9               pn_rec_exp_line_dtl.attribute9%TYPE,
77              x_attribute10              pn_rec_exp_line_dtl.attribute10%TYPE,
78              x_attribute11              pn_rec_exp_line_dtl.attribute11%TYPE,
79              x_attribute12              pn_rec_exp_line_dtl.attribute12%TYPE,
80              x_attribute13              pn_rec_exp_line_dtl.attribute13%TYPE,
81              x_attribute14              pn_rec_exp_line_dtl.attribute14%TYPE,
82              x_attribute15              pn_rec_exp_line_dtl.attribute15%TYPE);
83 
84 PROCEDURE delete_row(x_expense_line_dtl_id      pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE);
85 
86 END pn_rec_exp_line_dtl_pkg;