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.

APPS.PN_REC_EXP_LINE_DTL_PKG dependencies on PN_REC_EXP_LINE_DTL

Line 1: PACKAGE BODY pn_rec_exp_line_dtl_pkg AS

1: PACKAGE BODY pn_rec_exp_line_dtl_pkg AS
2: /* $Header: PNREXLDB.pls 120.2 2005/11/30 23:40:33 appldev noship $ */
3:
4: -------------------------------------------------------------------------------
5: -- PROCDURE : INSERT_ROW

Line 13: x_org_id pn_rec_exp_line_dtl.org_id%TYPE,

9: -- 15-JUL-05 sdmahesh o Replaced base views with their _ALL table.
10: -- 28-NOV-05 pikhar o fetched org_id using cursor
11: -------------------------------------------------------------------------------
12: PROCEDURE insert_row(
13: x_org_id pn_rec_exp_line_dtl.org_id%TYPE,
14: x_expense_line_id pn_rec_exp_line_dtl.expense_line_id%TYPE,
15: x_expense_line_dtl_id IN OUT NOCOPY pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,
16: x_parent_expense_line_id pn_rec_exp_line_dtl.parent_expense_line_id%TYPE,
17: x_location_id pn_rec_exp_line_dtl.location_id%TYPE,

Line 14: x_expense_line_id pn_rec_exp_line_dtl.expense_line_id%TYPE,

10: -- 28-NOV-05 pikhar o fetched org_id using cursor
11: -------------------------------------------------------------------------------
12: PROCEDURE insert_row(
13: x_org_id pn_rec_exp_line_dtl.org_id%TYPE,
14: x_expense_line_id pn_rec_exp_line_dtl.expense_line_id%TYPE,
15: x_expense_line_dtl_id IN OUT NOCOPY pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,
16: x_parent_expense_line_id pn_rec_exp_line_dtl.parent_expense_line_id%TYPE,
17: x_location_id pn_rec_exp_line_dtl.location_id%TYPE,
18: x_property_id pn_rec_exp_line_dtl.property_id%TYPE,

Line 15: x_expense_line_dtl_id IN OUT NOCOPY pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,

11: -------------------------------------------------------------------------------
12: PROCEDURE insert_row(
13: x_org_id pn_rec_exp_line_dtl.org_id%TYPE,
14: x_expense_line_id pn_rec_exp_line_dtl.expense_line_id%TYPE,
15: x_expense_line_dtl_id IN OUT NOCOPY pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,
16: x_parent_expense_line_id pn_rec_exp_line_dtl.parent_expense_line_id%TYPE,
17: x_location_id pn_rec_exp_line_dtl.location_id%TYPE,
18: x_property_id pn_rec_exp_line_dtl.property_id%TYPE,
19: x_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,

Line 16: x_parent_expense_line_id pn_rec_exp_line_dtl.parent_expense_line_id%TYPE,

12: PROCEDURE insert_row(
13: x_org_id pn_rec_exp_line_dtl.org_id%TYPE,
14: x_expense_line_id pn_rec_exp_line_dtl.expense_line_id%TYPE,
15: x_expense_line_dtl_id IN OUT NOCOPY pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,
16: x_parent_expense_line_id pn_rec_exp_line_dtl.parent_expense_line_id%TYPE,
17: x_location_id pn_rec_exp_line_dtl.location_id%TYPE,
18: x_property_id pn_rec_exp_line_dtl.property_id%TYPE,
19: x_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
20: x_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,

Line 17: x_location_id pn_rec_exp_line_dtl.location_id%TYPE,

13: x_org_id pn_rec_exp_line_dtl.org_id%TYPE,
14: x_expense_line_id pn_rec_exp_line_dtl.expense_line_id%TYPE,
15: x_expense_line_dtl_id IN OUT NOCOPY pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,
16: x_parent_expense_line_id pn_rec_exp_line_dtl.parent_expense_line_id%TYPE,
17: x_location_id pn_rec_exp_line_dtl.location_id%TYPE,
18: x_property_id pn_rec_exp_line_dtl.property_id%TYPE,
19: x_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
20: x_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
21: x_account_description pn_rec_exp_line_dtl.account_description%TYPE,

Line 18: x_property_id pn_rec_exp_line_dtl.property_id%TYPE,

14: x_expense_line_id pn_rec_exp_line_dtl.expense_line_id%TYPE,
15: x_expense_line_dtl_id IN OUT NOCOPY pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,
16: x_parent_expense_line_id pn_rec_exp_line_dtl.parent_expense_line_id%TYPE,
17: x_location_id pn_rec_exp_line_dtl.location_id%TYPE,
18: x_property_id pn_rec_exp_line_dtl.property_id%TYPE,
19: x_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
20: x_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
21: x_account_description pn_rec_exp_line_dtl.account_description%TYPE,
22: x_actual_amount pn_rec_exp_line_dtl.actual_amount%TYPE,

Line 19: x_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,

15: x_expense_line_dtl_id IN OUT NOCOPY pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,
16: x_parent_expense_line_id pn_rec_exp_line_dtl.parent_expense_line_id%TYPE,
17: x_location_id pn_rec_exp_line_dtl.location_id%TYPE,
18: x_property_id pn_rec_exp_line_dtl.property_id%TYPE,
19: x_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
20: x_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
21: x_account_description pn_rec_exp_line_dtl.account_description%TYPE,
22: x_actual_amount pn_rec_exp_line_dtl.actual_amount%TYPE,
23: x_actual_amount_ovr pn_rec_exp_line_dtl.actual_amount_ovr%TYPE,

Line 20: x_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,

16: x_parent_expense_line_id pn_rec_exp_line_dtl.parent_expense_line_id%TYPE,
17: x_location_id pn_rec_exp_line_dtl.location_id%TYPE,
18: x_property_id pn_rec_exp_line_dtl.property_id%TYPE,
19: x_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
20: x_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
21: x_account_description pn_rec_exp_line_dtl.account_description%TYPE,
22: x_actual_amount pn_rec_exp_line_dtl.actual_amount%TYPE,
23: x_actual_amount_ovr pn_rec_exp_line_dtl.actual_amount_ovr%TYPE,
24: x_budgeted_amount pn_rec_exp_line_dtl.budgeted_amount%TYPE,

Line 21: x_account_description pn_rec_exp_line_dtl.account_description%TYPE,

17: x_location_id pn_rec_exp_line_dtl.location_id%TYPE,
18: x_property_id pn_rec_exp_line_dtl.property_id%TYPE,
19: x_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
20: x_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
21: x_account_description pn_rec_exp_line_dtl.account_description%TYPE,
22: x_actual_amount pn_rec_exp_line_dtl.actual_amount%TYPE,
23: x_actual_amount_ovr pn_rec_exp_line_dtl.actual_amount_ovr%TYPE,
24: x_budgeted_amount pn_rec_exp_line_dtl.budgeted_amount%TYPE,
25: x_budgeted_amount_ovr pn_rec_exp_line_dtl.budgeted_amount_ovr%TYPE,

Line 22: x_actual_amount pn_rec_exp_line_dtl.actual_amount%TYPE,

18: x_property_id pn_rec_exp_line_dtl.property_id%TYPE,
19: x_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
20: x_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
21: x_account_description pn_rec_exp_line_dtl.account_description%TYPE,
22: x_actual_amount pn_rec_exp_line_dtl.actual_amount%TYPE,
23: x_actual_amount_ovr pn_rec_exp_line_dtl.actual_amount_ovr%TYPE,
24: x_budgeted_amount pn_rec_exp_line_dtl.budgeted_amount%TYPE,
25: x_budgeted_amount_ovr pn_rec_exp_line_dtl.budgeted_amount_ovr%TYPE,
26: x_budgeted_pct pn_rec_exp_line_dtl.budgeted_pct%TYPE,

Line 23: x_actual_amount_ovr pn_rec_exp_line_dtl.actual_amount_ovr%TYPE,

19: x_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
20: x_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
21: x_account_description pn_rec_exp_line_dtl.account_description%TYPE,
22: x_actual_amount pn_rec_exp_line_dtl.actual_amount%TYPE,
23: x_actual_amount_ovr pn_rec_exp_line_dtl.actual_amount_ovr%TYPE,
24: x_budgeted_amount pn_rec_exp_line_dtl.budgeted_amount%TYPE,
25: x_budgeted_amount_ovr pn_rec_exp_line_dtl.budgeted_amount_ovr%TYPE,
26: x_budgeted_pct pn_rec_exp_line_dtl.budgeted_pct%TYPE,
27: x_actual_pct pn_rec_exp_line_dtl.actual_pct%TYPE,

Line 24: x_budgeted_amount pn_rec_exp_line_dtl.budgeted_amount%TYPE,

20: x_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
21: x_account_description pn_rec_exp_line_dtl.account_description%TYPE,
22: x_actual_amount pn_rec_exp_line_dtl.actual_amount%TYPE,
23: x_actual_amount_ovr pn_rec_exp_line_dtl.actual_amount_ovr%TYPE,
24: x_budgeted_amount pn_rec_exp_line_dtl.budgeted_amount%TYPE,
25: x_budgeted_amount_ovr pn_rec_exp_line_dtl.budgeted_amount_ovr%TYPE,
26: x_budgeted_pct pn_rec_exp_line_dtl.budgeted_pct%TYPE,
27: x_actual_pct pn_rec_exp_line_dtl.actual_pct%TYPE,
28: x_currency_code pn_rec_exp_line_dtl.currency_code%TYPE,

Line 25: x_budgeted_amount_ovr pn_rec_exp_line_dtl.budgeted_amount_ovr%TYPE,

21: x_account_description pn_rec_exp_line_dtl.account_description%TYPE,
22: x_actual_amount pn_rec_exp_line_dtl.actual_amount%TYPE,
23: x_actual_amount_ovr pn_rec_exp_line_dtl.actual_amount_ovr%TYPE,
24: x_budgeted_amount pn_rec_exp_line_dtl.budgeted_amount%TYPE,
25: x_budgeted_amount_ovr pn_rec_exp_line_dtl.budgeted_amount_ovr%TYPE,
26: x_budgeted_pct pn_rec_exp_line_dtl.budgeted_pct%TYPE,
27: x_actual_pct pn_rec_exp_line_dtl.actual_pct%TYPE,
28: x_currency_code pn_rec_exp_line_dtl.currency_code%TYPE,
29: x_recoverable_flag pn_rec_exp_line_dtl.recoverable_flag%TYPE,

Line 26: x_budgeted_pct pn_rec_exp_line_dtl.budgeted_pct%TYPE,

22: x_actual_amount pn_rec_exp_line_dtl.actual_amount%TYPE,
23: x_actual_amount_ovr pn_rec_exp_line_dtl.actual_amount_ovr%TYPE,
24: x_budgeted_amount pn_rec_exp_line_dtl.budgeted_amount%TYPE,
25: x_budgeted_amount_ovr pn_rec_exp_line_dtl.budgeted_amount_ovr%TYPE,
26: x_budgeted_pct pn_rec_exp_line_dtl.budgeted_pct%TYPE,
27: x_actual_pct pn_rec_exp_line_dtl.actual_pct%TYPE,
28: x_currency_code pn_rec_exp_line_dtl.currency_code%TYPE,
29: x_recoverable_flag pn_rec_exp_line_dtl.recoverable_flag%TYPE,
30: x_expense_line_indicator pn_rec_exp_line_dtl.expense_line_indicator%TYPE,

Line 27: x_actual_pct pn_rec_exp_line_dtl.actual_pct%TYPE,

23: x_actual_amount_ovr pn_rec_exp_line_dtl.actual_amount_ovr%TYPE,
24: x_budgeted_amount pn_rec_exp_line_dtl.budgeted_amount%TYPE,
25: x_budgeted_amount_ovr pn_rec_exp_line_dtl.budgeted_amount_ovr%TYPE,
26: x_budgeted_pct pn_rec_exp_line_dtl.budgeted_pct%TYPE,
27: x_actual_pct pn_rec_exp_line_dtl.actual_pct%TYPE,
28: x_currency_code pn_rec_exp_line_dtl.currency_code%TYPE,
29: x_recoverable_flag pn_rec_exp_line_dtl.recoverable_flag%TYPE,
30: x_expense_line_indicator pn_rec_exp_line_dtl.expense_line_indicator%TYPE,
31: x_last_update_date pn_rec_exp_line_dtl.last_update_date%TYPE,

Line 28: x_currency_code pn_rec_exp_line_dtl.currency_code%TYPE,

24: x_budgeted_amount pn_rec_exp_line_dtl.budgeted_amount%TYPE,
25: x_budgeted_amount_ovr pn_rec_exp_line_dtl.budgeted_amount_ovr%TYPE,
26: x_budgeted_pct pn_rec_exp_line_dtl.budgeted_pct%TYPE,
27: x_actual_pct pn_rec_exp_line_dtl.actual_pct%TYPE,
28: x_currency_code pn_rec_exp_line_dtl.currency_code%TYPE,
29: x_recoverable_flag pn_rec_exp_line_dtl.recoverable_flag%TYPE,
30: x_expense_line_indicator pn_rec_exp_line_dtl.expense_line_indicator%TYPE,
31: x_last_update_date pn_rec_exp_line_dtl.last_update_date%TYPE,
32: x_last_updated_by pn_rec_exp_line_dtl.last_updated_by%TYPE,

Line 29: x_recoverable_flag pn_rec_exp_line_dtl.recoverable_flag%TYPE,

25: x_budgeted_amount_ovr pn_rec_exp_line_dtl.budgeted_amount_ovr%TYPE,
26: x_budgeted_pct pn_rec_exp_line_dtl.budgeted_pct%TYPE,
27: x_actual_pct pn_rec_exp_line_dtl.actual_pct%TYPE,
28: x_currency_code pn_rec_exp_line_dtl.currency_code%TYPE,
29: x_recoverable_flag pn_rec_exp_line_dtl.recoverable_flag%TYPE,
30: x_expense_line_indicator pn_rec_exp_line_dtl.expense_line_indicator%TYPE,
31: x_last_update_date pn_rec_exp_line_dtl.last_update_date%TYPE,
32: x_last_updated_by pn_rec_exp_line_dtl.last_updated_by%TYPE,
33: x_creation_date pn_rec_exp_line_dtl.creation_date%TYPE,

Line 30: x_expense_line_indicator pn_rec_exp_line_dtl.expense_line_indicator%TYPE,

26: x_budgeted_pct pn_rec_exp_line_dtl.budgeted_pct%TYPE,
27: x_actual_pct pn_rec_exp_line_dtl.actual_pct%TYPE,
28: x_currency_code pn_rec_exp_line_dtl.currency_code%TYPE,
29: x_recoverable_flag pn_rec_exp_line_dtl.recoverable_flag%TYPE,
30: x_expense_line_indicator pn_rec_exp_line_dtl.expense_line_indicator%TYPE,
31: x_last_update_date pn_rec_exp_line_dtl.last_update_date%TYPE,
32: x_last_updated_by pn_rec_exp_line_dtl.last_updated_by%TYPE,
33: x_creation_date pn_rec_exp_line_dtl.creation_date%TYPE,
34: x_created_by pn_rec_exp_line_dtl.created_by%TYPE,

Line 31: x_last_update_date pn_rec_exp_line_dtl.last_update_date%TYPE,

27: x_actual_pct pn_rec_exp_line_dtl.actual_pct%TYPE,
28: x_currency_code pn_rec_exp_line_dtl.currency_code%TYPE,
29: x_recoverable_flag pn_rec_exp_line_dtl.recoverable_flag%TYPE,
30: x_expense_line_indicator pn_rec_exp_line_dtl.expense_line_indicator%TYPE,
31: x_last_update_date pn_rec_exp_line_dtl.last_update_date%TYPE,
32: x_last_updated_by pn_rec_exp_line_dtl.last_updated_by%TYPE,
33: x_creation_date pn_rec_exp_line_dtl.creation_date%TYPE,
34: x_created_by pn_rec_exp_line_dtl.created_by%TYPE,
35: x_last_update_login pn_rec_exp_line_dtl.last_update_login%TYPE,

Line 32: x_last_updated_by pn_rec_exp_line_dtl.last_updated_by%TYPE,

28: x_currency_code pn_rec_exp_line_dtl.currency_code%TYPE,
29: x_recoverable_flag pn_rec_exp_line_dtl.recoverable_flag%TYPE,
30: x_expense_line_indicator pn_rec_exp_line_dtl.expense_line_indicator%TYPE,
31: x_last_update_date pn_rec_exp_line_dtl.last_update_date%TYPE,
32: x_last_updated_by pn_rec_exp_line_dtl.last_updated_by%TYPE,
33: x_creation_date pn_rec_exp_line_dtl.creation_date%TYPE,
34: x_created_by pn_rec_exp_line_dtl.created_by%TYPE,
35: x_last_update_login pn_rec_exp_line_dtl.last_update_login%TYPE,
36: x_attribute_category pn_rec_exp_line_dtl.attribute_category%TYPE,

Line 33: x_creation_date pn_rec_exp_line_dtl.creation_date%TYPE,

29: x_recoverable_flag pn_rec_exp_line_dtl.recoverable_flag%TYPE,
30: x_expense_line_indicator pn_rec_exp_line_dtl.expense_line_indicator%TYPE,
31: x_last_update_date pn_rec_exp_line_dtl.last_update_date%TYPE,
32: x_last_updated_by pn_rec_exp_line_dtl.last_updated_by%TYPE,
33: x_creation_date pn_rec_exp_line_dtl.creation_date%TYPE,
34: x_created_by pn_rec_exp_line_dtl.created_by%TYPE,
35: x_last_update_login pn_rec_exp_line_dtl.last_update_login%TYPE,
36: x_attribute_category pn_rec_exp_line_dtl.attribute_category%TYPE,
37: x_attribute1 pn_rec_exp_line_dtl.attribute1%TYPE,

Line 34: x_created_by pn_rec_exp_line_dtl.created_by%TYPE,

30: x_expense_line_indicator pn_rec_exp_line_dtl.expense_line_indicator%TYPE,
31: x_last_update_date pn_rec_exp_line_dtl.last_update_date%TYPE,
32: x_last_updated_by pn_rec_exp_line_dtl.last_updated_by%TYPE,
33: x_creation_date pn_rec_exp_line_dtl.creation_date%TYPE,
34: x_created_by pn_rec_exp_line_dtl.created_by%TYPE,
35: x_last_update_login pn_rec_exp_line_dtl.last_update_login%TYPE,
36: x_attribute_category pn_rec_exp_line_dtl.attribute_category%TYPE,
37: x_attribute1 pn_rec_exp_line_dtl.attribute1%TYPE,
38: x_attribute2 pn_rec_exp_line_dtl.attribute2%TYPE,

Line 35: x_last_update_login pn_rec_exp_line_dtl.last_update_login%TYPE,

31: x_last_update_date pn_rec_exp_line_dtl.last_update_date%TYPE,
32: x_last_updated_by pn_rec_exp_line_dtl.last_updated_by%TYPE,
33: x_creation_date pn_rec_exp_line_dtl.creation_date%TYPE,
34: x_created_by pn_rec_exp_line_dtl.created_by%TYPE,
35: x_last_update_login pn_rec_exp_line_dtl.last_update_login%TYPE,
36: x_attribute_category pn_rec_exp_line_dtl.attribute_category%TYPE,
37: x_attribute1 pn_rec_exp_line_dtl.attribute1%TYPE,
38: x_attribute2 pn_rec_exp_line_dtl.attribute2%TYPE,
39: x_attribute3 pn_rec_exp_line_dtl.attribute3%TYPE,

Line 36: x_attribute_category pn_rec_exp_line_dtl.attribute_category%TYPE,

32: x_last_updated_by pn_rec_exp_line_dtl.last_updated_by%TYPE,
33: x_creation_date pn_rec_exp_line_dtl.creation_date%TYPE,
34: x_created_by pn_rec_exp_line_dtl.created_by%TYPE,
35: x_last_update_login pn_rec_exp_line_dtl.last_update_login%TYPE,
36: x_attribute_category pn_rec_exp_line_dtl.attribute_category%TYPE,
37: x_attribute1 pn_rec_exp_line_dtl.attribute1%TYPE,
38: x_attribute2 pn_rec_exp_line_dtl.attribute2%TYPE,
39: x_attribute3 pn_rec_exp_line_dtl.attribute3%TYPE,
40: x_attribute4 pn_rec_exp_line_dtl.attribute4%TYPE,

Line 37: x_attribute1 pn_rec_exp_line_dtl.attribute1%TYPE,

33: x_creation_date pn_rec_exp_line_dtl.creation_date%TYPE,
34: x_created_by pn_rec_exp_line_dtl.created_by%TYPE,
35: x_last_update_login pn_rec_exp_line_dtl.last_update_login%TYPE,
36: x_attribute_category pn_rec_exp_line_dtl.attribute_category%TYPE,
37: x_attribute1 pn_rec_exp_line_dtl.attribute1%TYPE,
38: x_attribute2 pn_rec_exp_line_dtl.attribute2%TYPE,
39: x_attribute3 pn_rec_exp_line_dtl.attribute3%TYPE,
40: x_attribute4 pn_rec_exp_line_dtl.attribute4%TYPE,
41: x_attribute5 pn_rec_exp_line_dtl.attribute5%TYPE,

Line 38: x_attribute2 pn_rec_exp_line_dtl.attribute2%TYPE,

34: x_created_by pn_rec_exp_line_dtl.created_by%TYPE,
35: x_last_update_login pn_rec_exp_line_dtl.last_update_login%TYPE,
36: x_attribute_category pn_rec_exp_line_dtl.attribute_category%TYPE,
37: x_attribute1 pn_rec_exp_line_dtl.attribute1%TYPE,
38: x_attribute2 pn_rec_exp_line_dtl.attribute2%TYPE,
39: x_attribute3 pn_rec_exp_line_dtl.attribute3%TYPE,
40: x_attribute4 pn_rec_exp_line_dtl.attribute4%TYPE,
41: x_attribute5 pn_rec_exp_line_dtl.attribute5%TYPE,
42: x_attribute6 pn_rec_exp_line_dtl.attribute6%TYPE,

Line 39: x_attribute3 pn_rec_exp_line_dtl.attribute3%TYPE,

35: x_last_update_login pn_rec_exp_line_dtl.last_update_login%TYPE,
36: x_attribute_category pn_rec_exp_line_dtl.attribute_category%TYPE,
37: x_attribute1 pn_rec_exp_line_dtl.attribute1%TYPE,
38: x_attribute2 pn_rec_exp_line_dtl.attribute2%TYPE,
39: x_attribute3 pn_rec_exp_line_dtl.attribute3%TYPE,
40: x_attribute4 pn_rec_exp_line_dtl.attribute4%TYPE,
41: x_attribute5 pn_rec_exp_line_dtl.attribute5%TYPE,
42: x_attribute6 pn_rec_exp_line_dtl.attribute6%TYPE,
43: x_attribute7 pn_rec_exp_line_dtl.attribute7%TYPE,

Line 40: x_attribute4 pn_rec_exp_line_dtl.attribute4%TYPE,

36: x_attribute_category pn_rec_exp_line_dtl.attribute_category%TYPE,
37: x_attribute1 pn_rec_exp_line_dtl.attribute1%TYPE,
38: x_attribute2 pn_rec_exp_line_dtl.attribute2%TYPE,
39: x_attribute3 pn_rec_exp_line_dtl.attribute3%TYPE,
40: x_attribute4 pn_rec_exp_line_dtl.attribute4%TYPE,
41: x_attribute5 pn_rec_exp_line_dtl.attribute5%TYPE,
42: x_attribute6 pn_rec_exp_line_dtl.attribute6%TYPE,
43: x_attribute7 pn_rec_exp_line_dtl.attribute7%TYPE,
44: x_attribute8 pn_rec_exp_line_dtl.attribute8%TYPE,

Line 41: x_attribute5 pn_rec_exp_line_dtl.attribute5%TYPE,

37: x_attribute1 pn_rec_exp_line_dtl.attribute1%TYPE,
38: x_attribute2 pn_rec_exp_line_dtl.attribute2%TYPE,
39: x_attribute3 pn_rec_exp_line_dtl.attribute3%TYPE,
40: x_attribute4 pn_rec_exp_line_dtl.attribute4%TYPE,
41: x_attribute5 pn_rec_exp_line_dtl.attribute5%TYPE,
42: x_attribute6 pn_rec_exp_line_dtl.attribute6%TYPE,
43: x_attribute7 pn_rec_exp_line_dtl.attribute7%TYPE,
44: x_attribute8 pn_rec_exp_line_dtl.attribute8%TYPE,
45: x_attribute9 pn_rec_exp_line_dtl.attribute9%TYPE,

Line 42: x_attribute6 pn_rec_exp_line_dtl.attribute6%TYPE,

38: x_attribute2 pn_rec_exp_line_dtl.attribute2%TYPE,
39: x_attribute3 pn_rec_exp_line_dtl.attribute3%TYPE,
40: x_attribute4 pn_rec_exp_line_dtl.attribute4%TYPE,
41: x_attribute5 pn_rec_exp_line_dtl.attribute5%TYPE,
42: x_attribute6 pn_rec_exp_line_dtl.attribute6%TYPE,
43: x_attribute7 pn_rec_exp_line_dtl.attribute7%TYPE,
44: x_attribute8 pn_rec_exp_line_dtl.attribute8%TYPE,
45: x_attribute9 pn_rec_exp_line_dtl.attribute9%TYPE,
46: x_attribute10 pn_rec_exp_line_dtl.attribute10%TYPE,

Line 43: x_attribute7 pn_rec_exp_line_dtl.attribute7%TYPE,

39: x_attribute3 pn_rec_exp_line_dtl.attribute3%TYPE,
40: x_attribute4 pn_rec_exp_line_dtl.attribute4%TYPE,
41: x_attribute5 pn_rec_exp_line_dtl.attribute5%TYPE,
42: x_attribute6 pn_rec_exp_line_dtl.attribute6%TYPE,
43: x_attribute7 pn_rec_exp_line_dtl.attribute7%TYPE,
44: x_attribute8 pn_rec_exp_line_dtl.attribute8%TYPE,
45: x_attribute9 pn_rec_exp_line_dtl.attribute9%TYPE,
46: x_attribute10 pn_rec_exp_line_dtl.attribute10%TYPE,
47: x_attribute11 pn_rec_exp_line_dtl.attribute11%TYPE,

Line 44: x_attribute8 pn_rec_exp_line_dtl.attribute8%TYPE,

40: x_attribute4 pn_rec_exp_line_dtl.attribute4%TYPE,
41: x_attribute5 pn_rec_exp_line_dtl.attribute5%TYPE,
42: x_attribute6 pn_rec_exp_line_dtl.attribute6%TYPE,
43: x_attribute7 pn_rec_exp_line_dtl.attribute7%TYPE,
44: x_attribute8 pn_rec_exp_line_dtl.attribute8%TYPE,
45: x_attribute9 pn_rec_exp_line_dtl.attribute9%TYPE,
46: x_attribute10 pn_rec_exp_line_dtl.attribute10%TYPE,
47: x_attribute11 pn_rec_exp_line_dtl.attribute11%TYPE,
48: x_attribute12 pn_rec_exp_line_dtl.attribute12%TYPE,

Line 45: x_attribute9 pn_rec_exp_line_dtl.attribute9%TYPE,

41: x_attribute5 pn_rec_exp_line_dtl.attribute5%TYPE,
42: x_attribute6 pn_rec_exp_line_dtl.attribute6%TYPE,
43: x_attribute7 pn_rec_exp_line_dtl.attribute7%TYPE,
44: x_attribute8 pn_rec_exp_line_dtl.attribute8%TYPE,
45: x_attribute9 pn_rec_exp_line_dtl.attribute9%TYPE,
46: x_attribute10 pn_rec_exp_line_dtl.attribute10%TYPE,
47: x_attribute11 pn_rec_exp_line_dtl.attribute11%TYPE,
48: x_attribute12 pn_rec_exp_line_dtl.attribute12%TYPE,
49: x_attribute13 pn_rec_exp_line_dtl.attribute13%TYPE,

Line 46: x_attribute10 pn_rec_exp_line_dtl.attribute10%TYPE,

42: x_attribute6 pn_rec_exp_line_dtl.attribute6%TYPE,
43: x_attribute7 pn_rec_exp_line_dtl.attribute7%TYPE,
44: x_attribute8 pn_rec_exp_line_dtl.attribute8%TYPE,
45: x_attribute9 pn_rec_exp_line_dtl.attribute9%TYPE,
46: x_attribute10 pn_rec_exp_line_dtl.attribute10%TYPE,
47: x_attribute11 pn_rec_exp_line_dtl.attribute11%TYPE,
48: x_attribute12 pn_rec_exp_line_dtl.attribute12%TYPE,
49: x_attribute13 pn_rec_exp_line_dtl.attribute13%TYPE,
50: x_attribute14 pn_rec_exp_line_dtl.attribute14%TYPE,

Line 47: x_attribute11 pn_rec_exp_line_dtl.attribute11%TYPE,

43: x_attribute7 pn_rec_exp_line_dtl.attribute7%TYPE,
44: x_attribute8 pn_rec_exp_line_dtl.attribute8%TYPE,
45: x_attribute9 pn_rec_exp_line_dtl.attribute9%TYPE,
46: x_attribute10 pn_rec_exp_line_dtl.attribute10%TYPE,
47: x_attribute11 pn_rec_exp_line_dtl.attribute11%TYPE,
48: x_attribute12 pn_rec_exp_line_dtl.attribute12%TYPE,
49: x_attribute13 pn_rec_exp_line_dtl.attribute13%TYPE,
50: x_attribute14 pn_rec_exp_line_dtl.attribute14%TYPE,
51: x_attribute15 pn_rec_exp_line_dtl.attribute15%TYPE)

Line 48: x_attribute12 pn_rec_exp_line_dtl.attribute12%TYPE,

44: x_attribute8 pn_rec_exp_line_dtl.attribute8%TYPE,
45: x_attribute9 pn_rec_exp_line_dtl.attribute9%TYPE,
46: x_attribute10 pn_rec_exp_line_dtl.attribute10%TYPE,
47: x_attribute11 pn_rec_exp_line_dtl.attribute11%TYPE,
48: x_attribute12 pn_rec_exp_line_dtl.attribute12%TYPE,
49: x_attribute13 pn_rec_exp_line_dtl.attribute13%TYPE,
50: x_attribute14 pn_rec_exp_line_dtl.attribute14%TYPE,
51: x_attribute15 pn_rec_exp_line_dtl.attribute15%TYPE)
52: IS

Line 49: x_attribute13 pn_rec_exp_line_dtl.attribute13%TYPE,

45: x_attribute9 pn_rec_exp_line_dtl.attribute9%TYPE,
46: x_attribute10 pn_rec_exp_line_dtl.attribute10%TYPE,
47: x_attribute11 pn_rec_exp_line_dtl.attribute11%TYPE,
48: x_attribute12 pn_rec_exp_line_dtl.attribute12%TYPE,
49: x_attribute13 pn_rec_exp_line_dtl.attribute13%TYPE,
50: x_attribute14 pn_rec_exp_line_dtl.attribute14%TYPE,
51: x_attribute15 pn_rec_exp_line_dtl.attribute15%TYPE)
52: IS
53: l_desc VARCHAR2(100) := 'pn_rec_exp_line_dtl_pkg.insert_row';

Line 50: x_attribute14 pn_rec_exp_line_dtl.attribute14%TYPE,

46: x_attribute10 pn_rec_exp_line_dtl.attribute10%TYPE,
47: x_attribute11 pn_rec_exp_line_dtl.attribute11%TYPE,
48: x_attribute12 pn_rec_exp_line_dtl.attribute12%TYPE,
49: x_attribute13 pn_rec_exp_line_dtl.attribute13%TYPE,
50: x_attribute14 pn_rec_exp_line_dtl.attribute14%TYPE,
51: x_attribute15 pn_rec_exp_line_dtl.attribute15%TYPE)
52: IS
53: l_desc VARCHAR2(100) := 'pn_rec_exp_line_dtl_pkg.insert_row';
54:

Line 51: x_attribute15 pn_rec_exp_line_dtl.attribute15%TYPE)

47: x_attribute11 pn_rec_exp_line_dtl.attribute11%TYPE,
48: x_attribute12 pn_rec_exp_line_dtl.attribute12%TYPE,
49: x_attribute13 pn_rec_exp_line_dtl.attribute13%TYPE,
50: x_attribute14 pn_rec_exp_line_dtl.attribute14%TYPE,
51: x_attribute15 pn_rec_exp_line_dtl.attribute15%TYPE)
52: IS
53: l_desc VARCHAR2(100) := 'pn_rec_exp_line_dtl_pkg.insert_row';
54:
55: CURSOR org_cur IS

Line 53: l_desc VARCHAR2(100) := 'pn_rec_exp_line_dtl_pkg.insert_row';

49: x_attribute13 pn_rec_exp_line_dtl.attribute13%TYPE,
50: x_attribute14 pn_rec_exp_line_dtl.attribute14%TYPE,
51: x_attribute15 pn_rec_exp_line_dtl.attribute15%TYPE)
52: IS
53: l_desc VARCHAR2(100) := 'pn_rec_exp_line_dtl_pkg.insert_row';
54:
55: CURSOR org_cur IS
56: SELECT org_id
57: FROM pn_rec_exp_line_all

Line 75: INSERT INTO pn_rec_exp_line_dtl_all(

71: ELSE
72: l_org_id := x_org_id;
73: END IF;
74:
75: INSERT INTO pn_rec_exp_line_dtl_all(
76: org_id,
77: expense_line_id,
78: expense_line_dtl_id,
79: parent_expense_line_id,

Line 118: pn_rec_exp_line_dtl_s.nextval,

114: attribute15)
115: VALUES(
116: l_org_id,
117: x_expense_line_id,
118: pn_rec_exp_line_dtl_s.nextval,
119: x_parent_expense_line_id,
120: x_property_id,
121: x_location_id,
122: x_expense_type_code,

Line 172: x_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,

168: -- HISTORY :
169: -- 15-JUL-05 sdmahesh o Replaced base views with their _ALL table.
170: -------------------------------------------------------------------------------
171: PROCEDURE update_row(
172: x_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,
173: x_parent_expense_line_id pn_rec_exp_line_dtl.parent_expense_line_id%TYPE,
174: x_location_id pn_rec_exp_line_dtl.location_id%TYPE,
175: x_property_id pn_rec_exp_line_dtl.property_id%TYPE,
176: x_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,

Line 173: x_parent_expense_line_id pn_rec_exp_line_dtl.parent_expense_line_id%TYPE,

169: -- 15-JUL-05 sdmahesh o Replaced base views with their _ALL table.
170: -------------------------------------------------------------------------------
171: PROCEDURE update_row(
172: x_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,
173: x_parent_expense_line_id pn_rec_exp_line_dtl.parent_expense_line_id%TYPE,
174: x_location_id pn_rec_exp_line_dtl.location_id%TYPE,
175: x_property_id pn_rec_exp_line_dtl.property_id%TYPE,
176: x_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
177: x_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,

Line 174: x_location_id pn_rec_exp_line_dtl.location_id%TYPE,

170: -------------------------------------------------------------------------------
171: PROCEDURE update_row(
172: x_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,
173: x_parent_expense_line_id pn_rec_exp_line_dtl.parent_expense_line_id%TYPE,
174: x_location_id pn_rec_exp_line_dtl.location_id%TYPE,
175: x_property_id pn_rec_exp_line_dtl.property_id%TYPE,
176: x_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
177: x_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
178: x_account_description pn_rec_exp_line_dtl.account_description%TYPE,

Line 175: x_property_id pn_rec_exp_line_dtl.property_id%TYPE,

171: PROCEDURE update_row(
172: x_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,
173: x_parent_expense_line_id pn_rec_exp_line_dtl.parent_expense_line_id%TYPE,
174: x_location_id pn_rec_exp_line_dtl.location_id%TYPE,
175: x_property_id pn_rec_exp_line_dtl.property_id%TYPE,
176: x_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
177: x_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
178: x_account_description pn_rec_exp_line_dtl.account_description%TYPE,
179: x_actual_amount pn_rec_exp_line_dtl.actual_amount%TYPE,

Line 176: x_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,

172: x_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,
173: x_parent_expense_line_id pn_rec_exp_line_dtl.parent_expense_line_id%TYPE,
174: x_location_id pn_rec_exp_line_dtl.location_id%TYPE,
175: x_property_id pn_rec_exp_line_dtl.property_id%TYPE,
176: x_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
177: x_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
178: x_account_description pn_rec_exp_line_dtl.account_description%TYPE,
179: x_actual_amount pn_rec_exp_line_dtl.actual_amount%TYPE,
180: x_actual_amount_ovr pn_rec_exp_line_dtl.actual_amount_ovr%TYPE,

Line 177: x_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,

173: x_parent_expense_line_id pn_rec_exp_line_dtl.parent_expense_line_id%TYPE,
174: x_location_id pn_rec_exp_line_dtl.location_id%TYPE,
175: x_property_id pn_rec_exp_line_dtl.property_id%TYPE,
176: x_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
177: x_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
178: x_account_description pn_rec_exp_line_dtl.account_description%TYPE,
179: x_actual_amount pn_rec_exp_line_dtl.actual_amount%TYPE,
180: x_actual_amount_ovr pn_rec_exp_line_dtl.actual_amount_ovr%TYPE,
181: x_budgeted_amount pn_rec_exp_line_dtl.budgeted_amount%TYPE,

Line 178: x_account_description pn_rec_exp_line_dtl.account_description%TYPE,

174: x_location_id pn_rec_exp_line_dtl.location_id%TYPE,
175: x_property_id pn_rec_exp_line_dtl.property_id%TYPE,
176: x_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
177: x_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
178: x_account_description pn_rec_exp_line_dtl.account_description%TYPE,
179: x_actual_amount pn_rec_exp_line_dtl.actual_amount%TYPE,
180: x_actual_amount_ovr pn_rec_exp_line_dtl.actual_amount_ovr%TYPE,
181: x_budgeted_amount pn_rec_exp_line_dtl.budgeted_amount%TYPE,
182: x_budgeted_amount_ovr pn_rec_exp_line_dtl.budgeted_amount_ovr%TYPE,

Line 179: x_actual_amount pn_rec_exp_line_dtl.actual_amount%TYPE,

175: x_property_id pn_rec_exp_line_dtl.property_id%TYPE,
176: x_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
177: x_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
178: x_account_description pn_rec_exp_line_dtl.account_description%TYPE,
179: x_actual_amount pn_rec_exp_line_dtl.actual_amount%TYPE,
180: x_actual_amount_ovr pn_rec_exp_line_dtl.actual_amount_ovr%TYPE,
181: x_budgeted_amount pn_rec_exp_line_dtl.budgeted_amount%TYPE,
182: x_budgeted_amount_ovr pn_rec_exp_line_dtl.budgeted_amount_ovr%TYPE,
183: x_budgeted_pct pn_rec_exp_line_dtl.budgeted_pct%TYPE,

Line 180: x_actual_amount_ovr pn_rec_exp_line_dtl.actual_amount_ovr%TYPE,

176: x_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
177: x_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
178: x_account_description pn_rec_exp_line_dtl.account_description%TYPE,
179: x_actual_amount pn_rec_exp_line_dtl.actual_amount%TYPE,
180: x_actual_amount_ovr pn_rec_exp_line_dtl.actual_amount_ovr%TYPE,
181: x_budgeted_amount pn_rec_exp_line_dtl.budgeted_amount%TYPE,
182: x_budgeted_amount_ovr pn_rec_exp_line_dtl.budgeted_amount_ovr%TYPE,
183: x_budgeted_pct pn_rec_exp_line_dtl.budgeted_pct%TYPE,
184: x_actual_pct pn_rec_exp_line_dtl.actual_pct%TYPE,

Line 181: x_budgeted_amount pn_rec_exp_line_dtl.budgeted_amount%TYPE,

177: x_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
178: x_account_description pn_rec_exp_line_dtl.account_description%TYPE,
179: x_actual_amount pn_rec_exp_line_dtl.actual_amount%TYPE,
180: x_actual_amount_ovr pn_rec_exp_line_dtl.actual_amount_ovr%TYPE,
181: x_budgeted_amount pn_rec_exp_line_dtl.budgeted_amount%TYPE,
182: x_budgeted_amount_ovr pn_rec_exp_line_dtl.budgeted_amount_ovr%TYPE,
183: x_budgeted_pct pn_rec_exp_line_dtl.budgeted_pct%TYPE,
184: x_actual_pct pn_rec_exp_line_dtl.actual_pct%TYPE,
185: x_currency_code pn_rec_exp_line_dtl.currency_code%TYPE,

Line 182: x_budgeted_amount_ovr pn_rec_exp_line_dtl.budgeted_amount_ovr%TYPE,

178: x_account_description pn_rec_exp_line_dtl.account_description%TYPE,
179: x_actual_amount pn_rec_exp_line_dtl.actual_amount%TYPE,
180: x_actual_amount_ovr pn_rec_exp_line_dtl.actual_amount_ovr%TYPE,
181: x_budgeted_amount pn_rec_exp_line_dtl.budgeted_amount%TYPE,
182: x_budgeted_amount_ovr pn_rec_exp_line_dtl.budgeted_amount_ovr%TYPE,
183: x_budgeted_pct pn_rec_exp_line_dtl.budgeted_pct%TYPE,
184: x_actual_pct pn_rec_exp_line_dtl.actual_pct%TYPE,
185: x_currency_code pn_rec_exp_line_dtl.currency_code%TYPE,
186: x_recoverable_flag pn_rec_exp_line_dtl.recoverable_flag%TYPE,

Line 183: x_budgeted_pct pn_rec_exp_line_dtl.budgeted_pct%TYPE,

179: x_actual_amount pn_rec_exp_line_dtl.actual_amount%TYPE,
180: x_actual_amount_ovr pn_rec_exp_line_dtl.actual_amount_ovr%TYPE,
181: x_budgeted_amount pn_rec_exp_line_dtl.budgeted_amount%TYPE,
182: x_budgeted_amount_ovr pn_rec_exp_line_dtl.budgeted_amount_ovr%TYPE,
183: x_budgeted_pct pn_rec_exp_line_dtl.budgeted_pct%TYPE,
184: x_actual_pct pn_rec_exp_line_dtl.actual_pct%TYPE,
185: x_currency_code pn_rec_exp_line_dtl.currency_code%TYPE,
186: x_recoverable_flag pn_rec_exp_line_dtl.recoverable_flag%TYPE,
187: x_expense_line_indicator pn_rec_exp_line_dtl.expense_line_indicator%TYPE,

Line 184: x_actual_pct pn_rec_exp_line_dtl.actual_pct%TYPE,

180: x_actual_amount_ovr pn_rec_exp_line_dtl.actual_amount_ovr%TYPE,
181: x_budgeted_amount pn_rec_exp_line_dtl.budgeted_amount%TYPE,
182: x_budgeted_amount_ovr pn_rec_exp_line_dtl.budgeted_amount_ovr%TYPE,
183: x_budgeted_pct pn_rec_exp_line_dtl.budgeted_pct%TYPE,
184: x_actual_pct pn_rec_exp_line_dtl.actual_pct%TYPE,
185: x_currency_code pn_rec_exp_line_dtl.currency_code%TYPE,
186: x_recoverable_flag pn_rec_exp_line_dtl.recoverable_flag%TYPE,
187: x_expense_line_indicator pn_rec_exp_line_dtl.expense_line_indicator%TYPE,
188: x_last_update_date pn_rec_exp_line_dtl.last_update_date%TYPE,

Line 185: x_currency_code pn_rec_exp_line_dtl.currency_code%TYPE,

181: x_budgeted_amount pn_rec_exp_line_dtl.budgeted_amount%TYPE,
182: x_budgeted_amount_ovr pn_rec_exp_line_dtl.budgeted_amount_ovr%TYPE,
183: x_budgeted_pct pn_rec_exp_line_dtl.budgeted_pct%TYPE,
184: x_actual_pct pn_rec_exp_line_dtl.actual_pct%TYPE,
185: x_currency_code pn_rec_exp_line_dtl.currency_code%TYPE,
186: x_recoverable_flag pn_rec_exp_line_dtl.recoverable_flag%TYPE,
187: x_expense_line_indicator pn_rec_exp_line_dtl.expense_line_indicator%TYPE,
188: x_last_update_date pn_rec_exp_line_dtl.last_update_date%TYPE,
189: x_last_updated_by pn_rec_exp_line_dtl.last_updated_by%TYPE,

Line 186: x_recoverable_flag pn_rec_exp_line_dtl.recoverable_flag%TYPE,

182: x_budgeted_amount_ovr pn_rec_exp_line_dtl.budgeted_amount_ovr%TYPE,
183: x_budgeted_pct pn_rec_exp_line_dtl.budgeted_pct%TYPE,
184: x_actual_pct pn_rec_exp_line_dtl.actual_pct%TYPE,
185: x_currency_code pn_rec_exp_line_dtl.currency_code%TYPE,
186: x_recoverable_flag pn_rec_exp_line_dtl.recoverable_flag%TYPE,
187: x_expense_line_indicator pn_rec_exp_line_dtl.expense_line_indicator%TYPE,
188: x_last_update_date pn_rec_exp_line_dtl.last_update_date%TYPE,
189: x_last_updated_by pn_rec_exp_line_dtl.last_updated_by%TYPE,
190: x_creation_date pn_rec_exp_line_dtl.creation_date%TYPE,

Line 187: x_expense_line_indicator pn_rec_exp_line_dtl.expense_line_indicator%TYPE,

183: x_budgeted_pct pn_rec_exp_line_dtl.budgeted_pct%TYPE,
184: x_actual_pct pn_rec_exp_line_dtl.actual_pct%TYPE,
185: x_currency_code pn_rec_exp_line_dtl.currency_code%TYPE,
186: x_recoverable_flag pn_rec_exp_line_dtl.recoverable_flag%TYPE,
187: x_expense_line_indicator pn_rec_exp_line_dtl.expense_line_indicator%TYPE,
188: x_last_update_date pn_rec_exp_line_dtl.last_update_date%TYPE,
189: x_last_updated_by pn_rec_exp_line_dtl.last_updated_by%TYPE,
190: x_creation_date pn_rec_exp_line_dtl.creation_date%TYPE,
191: x_created_by pn_rec_exp_line_dtl.created_by%TYPE,

Line 188: x_last_update_date pn_rec_exp_line_dtl.last_update_date%TYPE,

184: x_actual_pct pn_rec_exp_line_dtl.actual_pct%TYPE,
185: x_currency_code pn_rec_exp_line_dtl.currency_code%TYPE,
186: x_recoverable_flag pn_rec_exp_line_dtl.recoverable_flag%TYPE,
187: x_expense_line_indicator pn_rec_exp_line_dtl.expense_line_indicator%TYPE,
188: x_last_update_date pn_rec_exp_line_dtl.last_update_date%TYPE,
189: x_last_updated_by pn_rec_exp_line_dtl.last_updated_by%TYPE,
190: x_creation_date pn_rec_exp_line_dtl.creation_date%TYPE,
191: x_created_by pn_rec_exp_line_dtl.created_by%TYPE,
192: x_last_update_login pn_rec_exp_line_dtl.last_update_login%TYPE,

Line 189: x_last_updated_by pn_rec_exp_line_dtl.last_updated_by%TYPE,

185: x_currency_code pn_rec_exp_line_dtl.currency_code%TYPE,
186: x_recoverable_flag pn_rec_exp_line_dtl.recoverable_flag%TYPE,
187: x_expense_line_indicator pn_rec_exp_line_dtl.expense_line_indicator%TYPE,
188: x_last_update_date pn_rec_exp_line_dtl.last_update_date%TYPE,
189: x_last_updated_by pn_rec_exp_line_dtl.last_updated_by%TYPE,
190: x_creation_date pn_rec_exp_line_dtl.creation_date%TYPE,
191: x_created_by pn_rec_exp_line_dtl.created_by%TYPE,
192: x_last_update_login pn_rec_exp_line_dtl.last_update_login%TYPE,
193: x_attribute_category pn_rec_exp_line_dtl.attribute_category%TYPE,

Line 190: x_creation_date pn_rec_exp_line_dtl.creation_date%TYPE,

186: x_recoverable_flag pn_rec_exp_line_dtl.recoverable_flag%TYPE,
187: x_expense_line_indicator pn_rec_exp_line_dtl.expense_line_indicator%TYPE,
188: x_last_update_date pn_rec_exp_line_dtl.last_update_date%TYPE,
189: x_last_updated_by pn_rec_exp_line_dtl.last_updated_by%TYPE,
190: x_creation_date pn_rec_exp_line_dtl.creation_date%TYPE,
191: x_created_by pn_rec_exp_line_dtl.created_by%TYPE,
192: x_last_update_login pn_rec_exp_line_dtl.last_update_login%TYPE,
193: x_attribute_category pn_rec_exp_line_dtl.attribute_category%TYPE,
194: x_attribute1 pn_rec_exp_line_dtl.attribute1%TYPE,

Line 191: x_created_by pn_rec_exp_line_dtl.created_by%TYPE,

187: x_expense_line_indicator pn_rec_exp_line_dtl.expense_line_indicator%TYPE,
188: x_last_update_date pn_rec_exp_line_dtl.last_update_date%TYPE,
189: x_last_updated_by pn_rec_exp_line_dtl.last_updated_by%TYPE,
190: x_creation_date pn_rec_exp_line_dtl.creation_date%TYPE,
191: x_created_by pn_rec_exp_line_dtl.created_by%TYPE,
192: x_last_update_login pn_rec_exp_line_dtl.last_update_login%TYPE,
193: x_attribute_category pn_rec_exp_line_dtl.attribute_category%TYPE,
194: x_attribute1 pn_rec_exp_line_dtl.attribute1%TYPE,
195: x_attribute2 pn_rec_exp_line_dtl.attribute2%TYPE,

Line 192: x_last_update_login pn_rec_exp_line_dtl.last_update_login%TYPE,

188: x_last_update_date pn_rec_exp_line_dtl.last_update_date%TYPE,
189: x_last_updated_by pn_rec_exp_line_dtl.last_updated_by%TYPE,
190: x_creation_date pn_rec_exp_line_dtl.creation_date%TYPE,
191: x_created_by pn_rec_exp_line_dtl.created_by%TYPE,
192: x_last_update_login pn_rec_exp_line_dtl.last_update_login%TYPE,
193: x_attribute_category pn_rec_exp_line_dtl.attribute_category%TYPE,
194: x_attribute1 pn_rec_exp_line_dtl.attribute1%TYPE,
195: x_attribute2 pn_rec_exp_line_dtl.attribute2%TYPE,
196: x_attribute3 pn_rec_exp_line_dtl.attribute3%TYPE,

Line 193: x_attribute_category pn_rec_exp_line_dtl.attribute_category%TYPE,

189: x_last_updated_by pn_rec_exp_line_dtl.last_updated_by%TYPE,
190: x_creation_date pn_rec_exp_line_dtl.creation_date%TYPE,
191: x_created_by pn_rec_exp_line_dtl.created_by%TYPE,
192: x_last_update_login pn_rec_exp_line_dtl.last_update_login%TYPE,
193: x_attribute_category pn_rec_exp_line_dtl.attribute_category%TYPE,
194: x_attribute1 pn_rec_exp_line_dtl.attribute1%TYPE,
195: x_attribute2 pn_rec_exp_line_dtl.attribute2%TYPE,
196: x_attribute3 pn_rec_exp_line_dtl.attribute3%TYPE,
197: x_attribute4 pn_rec_exp_line_dtl.attribute4%TYPE,

Line 194: x_attribute1 pn_rec_exp_line_dtl.attribute1%TYPE,

190: x_creation_date pn_rec_exp_line_dtl.creation_date%TYPE,
191: x_created_by pn_rec_exp_line_dtl.created_by%TYPE,
192: x_last_update_login pn_rec_exp_line_dtl.last_update_login%TYPE,
193: x_attribute_category pn_rec_exp_line_dtl.attribute_category%TYPE,
194: x_attribute1 pn_rec_exp_line_dtl.attribute1%TYPE,
195: x_attribute2 pn_rec_exp_line_dtl.attribute2%TYPE,
196: x_attribute3 pn_rec_exp_line_dtl.attribute3%TYPE,
197: x_attribute4 pn_rec_exp_line_dtl.attribute4%TYPE,
198: x_attribute5 pn_rec_exp_line_dtl.attribute5%TYPE,

Line 195: x_attribute2 pn_rec_exp_line_dtl.attribute2%TYPE,

191: x_created_by pn_rec_exp_line_dtl.created_by%TYPE,
192: x_last_update_login pn_rec_exp_line_dtl.last_update_login%TYPE,
193: x_attribute_category pn_rec_exp_line_dtl.attribute_category%TYPE,
194: x_attribute1 pn_rec_exp_line_dtl.attribute1%TYPE,
195: x_attribute2 pn_rec_exp_line_dtl.attribute2%TYPE,
196: x_attribute3 pn_rec_exp_line_dtl.attribute3%TYPE,
197: x_attribute4 pn_rec_exp_line_dtl.attribute4%TYPE,
198: x_attribute5 pn_rec_exp_line_dtl.attribute5%TYPE,
199: x_attribute6 pn_rec_exp_line_dtl.attribute6%TYPE,

Line 196: x_attribute3 pn_rec_exp_line_dtl.attribute3%TYPE,

192: x_last_update_login pn_rec_exp_line_dtl.last_update_login%TYPE,
193: x_attribute_category pn_rec_exp_line_dtl.attribute_category%TYPE,
194: x_attribute1 pn_rec_exp_line_dtl.attribute1%TYPE,
195: x_attribute2 pn_rec_exp_line_dtl.attribute2%TYPE,
196: x_attribute3 pn_rec_exp_line_dtl.attribute3%TYPE,
197: x_attribute4 pn_rec_exp_line_dtl.attribute4%TYPE,
198: x_attribute5 pn_rec_exp_line_dtl.attribute5%TYPE,
199: x_attribute6 pn_rec_exp_line_dtl.attribute6%TYPE,
200: x_attribute7 pn_rec_exp_line_dtl.attribute7%TYPE,

Line 197: x_attribute4 pn_rec_exp_line_dtl.attribute4%TYPE,

193: x_attribute_category pn_rec_exp_line_dtl.attribute_category%TYPE,
194: x_attribute1 pn_rec_exp_line_dtl.attribute1%TYPE,
195: x_attribute2 pn_rec_exp_line_dtl.attribute2%TYPE,
196: x_attribute3 pn_rec_exp_line_dtl.attribute3%TYPE,
197: x_attribute4 pn_rec_exp_line_dtl.attribute4%TYPE,
198: x_attribute5 pn_rec_exp_line_dtl.attribute5%TYPE,
199: x_attribute6 pn_rec_exp_line_dtl.attribute6%TYPE,
200: x_attribute7 pn_rec_exp_line_dtl.attribute7%TYPE,
201: x_attribute8 pn_rec_exp_line_dtl.attribute8%TYPE,

Line 198: x_attribute5 pn_rec_exp_line_dtl.attribute5%TYPE,

194: x_attribute1 pn_rec_exp_line_dtl.attribute1%TYPE,
195: x_attribute2 pn_rec_exp_line_dtl.attribute2%TYPE,
196: x_attribute3 pn_rec_exp_line_dtl.attribute3%TYPE,
197: x_attribute4 pn_rec_exp_line_dtl.attribute4%TYPE,
198: x_attribute5 pn_rec_exp_line_dtl.attribute5%TYPE,
199: x_attribute6 pn_rec_exp_line_dtl.attribute6%TYPE,
200: x_attribute7 pn_rec_exp_line_dtl.attribute7%TYPE,
201: x_attribute8 pn_rec_exp_line_dtl.attribute8%TYPE,
202: x_attribute9 pn_rec_exp_line_dtl.attribute9%TYPE,

Line 199: x_attribute6 pn_rec_exp_line_dtl.attribute6%TYPE,

195: x_attribute2 pn_rec_exp_line_dtl.attribute2%TYPE,
196: x_attribute3 pn_rec_exp_line_dtl.attribute3%TYPE,
197: x_attribute4 pn_rec_exp_line_dtl.attribute4%TYPE,
198: x_attribute5 pn_rec_exp_line_dtl.attribute5%TYPE,
199: x_attribute6 pn_rec_exp_line_dtl.attribute6%TYPE,
200: x_attribute7 pn_rec_exp_line_dtl.attribute7%TYPE,
201: x_attribute8 pn_rec_exp_line_dtl.attribute8%TYPE,
202: x_attribute9 pn_rec_exp_line_dtl.attribute9%TYPE,
203: x_attribute10 pn_rec_exp_line_dtl.attribute10%TYPE,

Line 200: x_attribute7 pn_rec_exp_line_dtl.attribute7%TYPE,

196: x_attribute3 pn_rec_exp_line_dtl.attribute3%TYPE,
197: x_attribute4 pn_rec_exp_line_dtl.attribute4%TYPE,
198: x_attribute5 pn_rec_exp_line_dtl.attribute5%TYPE,
199: x_attribute6 pn_rec_exp_line_dtl.attribute6%TYPE,
200: x_attribute7 pn_rec_exp_line_dtl.attribute7%TYPE,
201: x_attribute8 pn_rec_exp_line_dtl.attribute8%TYPE,
202: x_attribute9 pn_rec_exp_line_dtl.attribute9%TYPE,
203: x_attribute10 pn_rec_exp_line_dtl.attribute10%TYPE,
204: x_attribute11 pn_rec_exp_line_dtl.attribute11%TYPE,

Line 201: x_attribute8 pn_rec_exp_line_dtl.attribute8%TYPE,

197: x_attribute4 pn_rec_exp_line_dtl.attribute4%TYPE,
198: x_attribute5 pn_rec_exp_line_dtl.attribute5%TYPE,
199: x_attribute6 pn_rec_exp_line_dtl.attribute6%TYPE,
200: x_attribute7 pn_rec_exp_line_dtl.attribute7%TYPE,
201: x_attribute8 pn_rec_exp_line_dtl.attribute8%TYPE,
202: x_attribute9 pn_rec_exp_line_dtl.attribute9%TYPE,
203: x_attribute10 pn_rec_exp_line_dtl.attribute10%TYPE,
204: x_attribute11 pn_rec_exp_line_dtl.attribute11%TYPE,
205: x_attribute12 pn_rec_exp_line_dtl.attribute12%TYPE,

Line 202: x_attribute9 pn_rec_exp_line_dtl.attribute9%TYPE,

198: x_attribute5 pn_rec_exp_line_dtl.attribute5%TYPE,
199: x_attribute6 pn_rec_exp_line_dtl.attribute6%TYPE,
200: x_attribute7 pn_rec_exp_line_dtl.attribute7%TYPE,
201: x_attribute8 pn_rec_exp_line_dtl.attribute8%TYPE,
202: x_attribute9 pn_rec_exp_line_dtl.attribute9%TYPE,
203: x_attribute10 pn_rec_exp_line_dtl.attribute10%TYPE,
204: x_attribute11 pn_rec_exp_line_dtl.attribute11%TYPE,
205: x_attribute12 pn_rec_exp_line_dtl.attribute12%TYPE,
206: x_attribute13 pn_rec_exp_line_dtl.attribute13%TYPE,

Line 203: x_attribute10 pn_rec_exp_line_dtl.attribute10%TYPE,

199: x_attribute6 pn_rec_exp_line_dtl.attribute6%TYPE,
200: x_attribute7 pn_rec_exp_line_dtl.attribute7%TYPE,
201: x_attribute8 pn_rec_exp_line_dtl.attribute8%TYPE,
202: x_attribute9 pn_rec_exp_line_dtl.attribute9%TYPE,
203: x_attribute10 pn_rec_exp_line_dtl.attribute10%TYPE,
204: x_attribute11 pn_rec_exp_line_dtl.attribute11%TYPE,
205: x_attribute12 pn_rec_exp_line_dtl.attribute12%TYPE,
206: x_attribute13 pn_rec_exp_line_dtl.attribute13%TYPE,
207: x_attribute14 pn_rec_exp_line_dtl.attribute14%TYPE,

Line 204: x_attribute11 pn_rec_exp_line_dtl.attribute11%TYPE,

200: x_attribute7 pn_rec_exp_line_dtl.attribute7%TYPE,
201: x_attribute8 pn_rec_exp_line_dtl.attribute8%TYPE,
202: x_attribute9 pn_rec_exp_line_dtl.attribute9%TYPE,
203: x_attribute10 pn_rec_exp_line_dtl.attribute10%TYPE,
204: x_attribute11 pn_rec_exp_line_dtl.attribute11%TYPE,
205: x_attribute12 pn_rec_exp_line_dtl.attribute12%TYPE,
206: x_attribute13 pn_rec_exp_line_dtl.attribute13%TYPE,
207: x_attribute14 pn_rec_exp_line_dtl.attribute14%TYPE,
208: x_attribute15 pn_rec_exp_line_dtl.attribute15%TYPE)

Line 205: x_attribute12 pn_rec_exp_line_dtl.attribute12%TYPE,

201: x_attribute8 pn_rec_exp_line_dtl.attribute8%TYPE,
202: x_attribute9 pn_rec_exp_line_dtl.attribute9%TYPE,
203: x_attribute10 pn_rec_exp_line_dtl.attribute10%TYPE,
204: x_attribute11 pn_rec_exp_line_dtl.attribute11%TYPE,
205: x_attribute12 pn_rec_exp_line_dtl.attribute12%TYPE,
206: x_attribute13 pn_rec_exp_line_dtl.attribute13%TYPE,
207: x_attribute14 pn_rec_exp_line_dtl.attribute14%TYPE,
208: x_attribute15 pn_rec_exp_line_dtl.attribute15%TYPE)
209: IS

Line 206: x_attribute13 pn_rec_exp_line_dtl.attribute13%TYPE,

202: x_attribute9 pn_rec_exp_line_dtl.attribute9%TYPE,
203: x_attribute10 pn_rec_exp_line_dtl.attribute10%TYPE,
204: x_attribute11 pn_rec_exp_line_dtl.attribute11%TYPE,
205: x_attribute12 pn_rec_exp_line_dtl.attribute12%TYPE,
206: x_attribute13 pn_rec_exp_line_dtl.attribute13%TYPE,
207: x_attribute14 pn_rec_exp_line_dtl.attribute14%TYPE,
208: x_attribute15 pn_rec_exp_line_dtl.attribute15%TYPE)
209: IS
210: l_desc VARCHAR2(100) := 'pn_rec_exp_line_dtl_pkg.update_row';

Line 207: x_attribute14 pn_rec_exp_line_dtl.attribute14%TYPE,

203: x_attribute10 pn_rec_exp_line_dtl.attribute10%TYPE,
204: x_attribute11 pn_rec_exp_line_dtl.attribute11%TYPE,
205: x_attribute12 pn_rec_exp_line_dtl.attribute12%TYPE,
206: x_attribute13 pn_rec_exp_line_dtl.attribute13%TYPE,
207: x_attribute14 pn_rec_exp_line_dtl.attribute14%TYPE,
208: x_attribute15 pn_rec_exp_line_dtl.attribute15%TYPE)
209: IS
210: l_desc VARCHAR2(100) := 'pn_rec_exp_line_dtl_pkg.update_row';
211: BEGIN

Line 208: x_attribute15 pn_rec_exp_line_dtl.attribute15%TYPE)

204: x_attribute11 pn_rec_exp_line_dtl.attribute11%TYPE,
205: x_attribute12 pn_rec_exp_line_dtl.attribute12%TYPE,
206: x_attribute13 pn_rec_exp_line_dtl.attribute13%TYPE,
207: x_attribute14 pn_rec_exp_line_dtl.attribute14%TYPE,
208: x_attribute15 pn_rec_exp_line_dtl.attribute15%TYPE)
209: IS
210: l_desc VARCHAR2(100) := 'pn_rec_exp_line_dtl_pkg.update_row';
211: BEGIN
212:

Line 210: l_desc VARCHAR2(100) := 'pn_rec_exp_line_dtl_pkg.update_row';

206: x_attribute13 pn_rec_exp_line_dtl.attribute13%TYPE,
207: x_attribute14 pn_rec_exp_line_dtl.attribute14%TYPE,
208: x_attribute15 pn_rec_exp_line_dtl.attribute15%TYPE)
209: IS
210: l_desc VARCHAR2(100) := 'pn_rec_exp_line_dtl_pkg.update_row';
211: BEGIN
212:
213: pnp_debug_pkg.debug(l_desc ||' (+)');
214:

Line 215: UPDATE pn_rec_exp_line_dtl_all

211: BEGIN
212:
213: pnp_debug_pkg.debug(l_desc ||' (+)');
214:
215: UPDATE pn_rec_exp_line_dtl_all
216: SET parent_expense_line_id = x_parent_expense_line_id,
217: location_id = x_location_id,
218: property_id = x_property_id,
219: expense_type_code = x_expense_type_code,

Line 271: PROCEDURE delete_row(x_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE) IS

267: -- PURPOSE : deletes the row
268: -- HISTORY :
269: -- 15-JUL-05 sdmahesh o Replaced base views with their _ALL table.
270: -------------------------------------------------------------------------------
271: PROCEDURE delete_row(x_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE) IS
272: l_desc VARCHAR2(100) := 'pn_rec_exp_line_dtl_pkg.delete_row';
273: BEGIN
274:
275: pnp_debug_pkg.debug(l_desc ||' (+)');

Line 272: l_desc VARCHAR2(100) := 'pn_rec_exp_line_dtl_pkg.delete_row';

268: -- HISTORY :
269: -- 15-JUL-05 sdmahesh o Replaced base views with their _ALL table.
270: -------------------------------------------------------------------------------
271: PROCEDURE delete_row(x_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE) IS
272: l_desc VARCHAR2(100) := 'pn_rec_exp_line_dtl_pkg.delete_row';
273: BEGIN
274:
275: pnp_debug_pkg.debug(l_desc ||' (+)');
276:

Line 277: DELETE pn_rec_exp_line_dtl_all

273: BEGIN
274:
275: pnp_debug_pkg.debug(l_desc ||' (+)');
276:
277: DELETE pn_rec_exp_line_dtl_all
278: WHERE expense_line_dtl_id = x_expense_line_dtl_id;
279:
280: pnp_debug_pkg.debug(l_desc ||' (-)');
281:

Line 289: END pn_rec_exp_line_dtl_pkg;

285: app_exception.raise_exception;
286:
287: END delete_row;
288:
289: END pn_rec_exp_line_dtl_pkg;