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_EXPCL_DTLLN_PKG dependencies on PN_REC_EXPCL_DTLLN

Line 1: PACKAGE BODY pn_rec_expcl_dtlln_pkg AS

1: PACKAGE BODY pn_rec_expcl_dtlln_pkg AS
2: /* $Header: PNRECLNB.pls 120.2 2005/11/30 23:38:27 appldev noship $ */
3:
4: -------------------------------------------------------------------------------
5: -- PROCDURE : INSERT_ROW

Line 13: x_org_id pn_rec_expcl_dtlln.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_expcl_dtlln.org_id%TYPE,
14: x_expense_class_dtl_id pn_rec_expcl_dtlln.expense_class_dtl_id%TYPE,
15: x_expense_class_line_id IN OUT NOCOPY pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
16: x_location_id pn_rec_expcl_dtlln.location_id%TYPE,
17: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,

Line 14: x_expense_class_dtl_id pn_rec_expcl_dtlln.expense_class_dtl_id%TYPE,

10: -- 28-NOV-05 pikhar o fetched org_id using cursor
11: -------------------------------------------------------------------------------
12: PROCEDURE insert_row(
13: x_org_id pn_rec_expcl_dtlln.org_id%TYPE,
14: x_expense_class_dtl_id pn_rec_expcl_dtlln.expense_class_dtl_id%TYPE,
15: x_expense_class_line_id IN OUT NOCOPY pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
16: x_location_id pn_rec_expcl_dtlln.location_id%TYPE,
17: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,
18: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,

Line 15: x_expense_class_line_id IN OUT NOCOPY pn_rec_expcl_dtlln.expense_class_line_id%TYPE,

11: -------------------------------------------------------------------------------
12: PROCEDURE insert_row(
13: x_org_id pn_rec_expcl_dtlln.org_id%TYPE,
14: x_expense_class_dtl_id pn_rec_expcl_dtlln.expense_class_dtl_id%TYPE,
15: x_expense_class_line_id IN OUT NOCOPY pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
16: x_location_id pn_rec_expcl_dtlln.location_id%TYPE,
17: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,
18: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
19: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,

Line 16: x_location_id pn_rec_expcl_dtlln.location_id%TYPE,

12: PROCEDURE insert_row(
13: x_org_id pn_rec_expcl_dtlln.org_id%TYPE,
14: x_expense_class_dtl_id pn_rec_expcl_dtlln.expense_class_dtl_id%TYPE,
15: x_expense_class_line_id IN OUT NOCOPY pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
16: x_location_id pn_rec_expcl_dtlln.location_id%TYPE,
17: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,
18: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
19: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
20: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,

Line 17: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,

13: x_org_id pn_rec_expcl_dtlln.org_id%TYPE,
14: x_expense_class_dtl_id pn_rec_expcl_dtlln.expense_class_dtl_id%TYPE,
15: x_expense_class_line_id IN OUT NOCOPY pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
16: x_location_id pn_rec_expcl_dtlln.location_id%TYPE,
17: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,
18: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
19: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
20: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
21: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,

Line 18: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,

14: x_expense_class_dtl_id pn_rec_expcl_dtlln.expense_class_dtl_id%TYPE,
15: x_expense_class_line_id IN OUT NOCOPY pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
16: x_location_id pn_rec_expcl_dtlln.location_id%TYPE,
17: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,
18: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
19: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
20: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
21: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
22: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,

Line 19: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,

15: x_expense_class_line_id IN OUT NOCOPY pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
16: x_location_id pn_rec_expcl_dtlln.location_id%TYPE,
17: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,
18: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
19: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
20: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
21: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
22: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,
23: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,

Line 20: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,

16: x_location_id pn_rec_expcl_dtlln.location_id%TYPE,
17: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,
18: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
19: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
20: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
21: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
22: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,
23: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,
24: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,

Line 21: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,

17: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,
18: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
19: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
20: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
21: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
22: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,
23: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,
24: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,
25: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,

Line 22: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,

18: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
19: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
20: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
21: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
22: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,
23: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,
24: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,
25: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
26: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,

Line 23: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,

19: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
20: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
21: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
22: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,
23: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,
24: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,
25: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
26: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
27: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,

Line 24: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,

20: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
21: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
22: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,
23: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,
24: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,
25: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
26: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
27: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
28: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,

Line 25: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,

21: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
22: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,
23: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,
24: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,
25: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
26: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
27: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
28: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
29: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,

Line 26: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,

22: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,
23: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,
24: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,
25: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
26: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
27: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
28: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
29: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,
30: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,

Line 27: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,

23: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,
24: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,
25: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
26: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
27: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
28: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
29: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,
30: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,
31: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,

Line 28: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,

24: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,
25: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
26: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
27: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
28: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
29: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,
30: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,
31: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,
32: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,

Line 29: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,

25: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
26: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
27: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
28: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
29: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,
30: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,
31: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,
32: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,
33: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,

Line 30: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,

26: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
27: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
28: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
29: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,
30: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,
31: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,
32: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,
33: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,
34: x_created_by pn_rec_expcl_dtlln.created_by%TYPE,

Line 31: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,

27: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
28: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
29: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,
30: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,
31: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,
32: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,
33: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,
34: x_created_by pn_rec_expcl_dtlln.created_by%TYPE,
35: x_last_update_login pn_rec_expcl_dtlln.last_update_login%TYPE

Line 32: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,

28: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
29: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,
30: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,
31: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,
32: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,
33: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,
34: x_created_by pn_rec_expcl_dtlln.created_by%TYPE,
35: x_last_update_login pn_rec_expcl_dtlln.last_update_login%TYPE
36: )

Line 33: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,

29: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,
30: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,
31: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,
32: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,
33: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,
34: x_created_by pn_rec_expcl_dtlln.created_by%TYPE,
35: x_last_update_login pn_rec_expcl_dtlln.last_update_login%TYPE
36: )
37: IS

Line 34: x_created_by pn_rec_expcl_dtlln.created_by%TYPE,

30: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,
31: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,
32: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,
33: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,
34: x_created_by pn_rec_expcl_dtlln.created_by%TYPE,
35: x_last_update_login pn_rec_expcl_dtlln.last_update_login%TYPE
36: )
37: IS
38: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlln_pkg.insert_row';

Line 35: x_last_update_login pn_rec_expcl_dtlln.last_update_login%TYPE

31: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,
32: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,
33: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,
34: x_created_by pn_rec_expcl_dtlln.created_by%TYPE,
35: x_last_update_login pn_rec_expcl_dtlln.last_update_login%TYPE
36: )
37: IS
38: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlln_pkg.insert_row';
39: CURSOR org_cur IS

Line 38: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlln_pkg.insert_row';

34: x_created_by pn_rec_expcl_dtlln.created_by%TYPE,
35: x_last_update_login pn_rec_expcl_dtlln.last_update_login%TYPE
36: )
37: IS
38: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlln_pkg.insert_row';
39: CURSOR org_cur IS
40: SELECT org_id
41: FROM pn_rec_expcl_dtl_all
42: WHERE expense_class_dtl_id = x_expense_class_dtl_id;

Line 59: INSERT INTO pn_rec_expcl_dtlln_all

55: ELSE
56: l_org_id := x_org_id;
57: END IF;
58:
59: INSERT INTO pn_rec_expcl_dtlln_all
60: (
61: org_id,
62: expense_class_dtl_id,
63: expense_class_line_id,

Line 87: pn_rec_expcl_dtlln_s.nextval,

83: last_update_login
84: ) VALUES (
85: l_org_id,
86: x_expense_class_dtl_id,
87: pn_rec_expcl_dtlln_s.nextval,
88: x_location_id,
89: x_cust_space_assign_id,
90: x_cust_account_id,
91: x_lease_id,

Line 126: x_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,

122: -- HISTORY :
123: -- 15-JUL-05 sdmahesh o Replaced base views with their _ALL table.
124: -------------------------------------------------------------------------------
125: PROCEDURE update_row(
126: x_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
127: x_location_id pn_rec_expcl_dtlln.location_id%TYPE,
128: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,
129: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
130: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,

Line 127: x_location_id pn_rec_expcl_dtlln.location_id%TYPE,

123: -- 15-JUL-05 sdmahesh o Replaced base views with their _ALL table.
124: -------------------------------------------------------------------------------
125: PROCEDURE update_row(
126: x_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
127: x_location_id pn_rec_expcl_dtlln.location_id%TYPE,
128: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,
129: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
130: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
131: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,

Line 128: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,

124: -------------------------------------------------------------------------------
125: PROCEDURE update_row(
126: x_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
127: x_location_id pn_rec_expcl_dtlln.location_id%TYPE,
128: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,
129: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
130: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
131: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
132: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,

Line 129: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,

125: PROCEDURE update_row(
126: x_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
127: x_location_id pn_rec_expcl_dtlln.location_id%TYPE,
128: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,
129: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
130: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
131: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
132: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
133: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,

Line 130: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,

126: x_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
127: x_location_id pn_rec_expcl_dtlln.location_id%TYPE,
128: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,
129: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
130: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
131: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
132: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
133: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,
134: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,

Line 131: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,

127: x_location_id pn_rec_expcl_dtlln.location_id%TYPE,
128: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,
129: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
130: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
131: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
132: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
133: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,
134: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,
135: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,

Line 132: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,

128: x_cust_space_assign_id pn_rec_expcl_dtlln.cust_space_assign_id%TYPE,
129: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
130: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
131: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
132: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
133: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,
134: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,
135: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,
136: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,

Line 133: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,

129: x_cust_account_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
130: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
131: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
132: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
133: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,
134: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,
135: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,
136: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
137: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,

Line 134: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,

130: x_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
131: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
132: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
133: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,
134: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,
135: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,
136: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
137: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
138: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,

Line 135: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,

131: x_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
132: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
133: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,
134: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,
135: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,
136: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
137: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
138: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
139: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,

Line 136: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,

132: x_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
133: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,
134: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,
135: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,
136: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
137: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
138: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
139: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
140: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,

Line 137: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,

133: x_budgeted_amt pn_rec_expcl_dtlln.budgeted_amt%TYPE,
134: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,
135: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,
136: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
137: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
138: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
139: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
140: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,
141: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,

Line 138: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,

134: x_expense_amt pn_rec_expcl_dtlln.expense_amt%TYPE,
135: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,
136: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
137: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
138: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
139: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
140: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,
141: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,
142: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,

Line 139: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,

135: x_recoverable_amt pn_rec_expcl_dtlln.recoverable_amt%TYPE,
136: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
137: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
138: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
139: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
140: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,
141: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,
142: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,
143: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,

Line 140: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,

136: x_computed_recoverable_amt pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
137: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
138: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
139: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
140: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,
141: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,
142: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,
143: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,
144: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,

Line 141: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,

137: x_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
138: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
139: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
140: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,
141: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,
142: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,
143: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,
144: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,
145: x_created_by pn_rec_expcl_dtlln.created_by%TYPE,

Line 142: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,

138: x_cls_line_fee_bf_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
139: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
140: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,
141: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,
142: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,
143: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,
144: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,
145: x_created_by pn_rec_expcl_dtlln.created_by%TYPE,
146: x_last_update_login pn_rec_expcl_dtlln.last_update_login%TYPE)

Line 143: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,

139: x_cls_line_fee_af_ct_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
140: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,
141: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,
142: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,
143: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,
144: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,
145: x_created_by pn_rec_expcl_dtlln.created_by%TYPE,
146: x_last_update_login pn_rec_expcl_dtlln.last_update_login%TYPE)
147: IS

Line 144: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,

140: x_use_share_pct_flag pn_rec_expcl_dtlln.use_share_pct_flag%TYPE,
141: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,
142: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,
143: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,
144: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,
145: x_created_by pn_rec_expcl_dtlln.created_by%TYPE,
146: x_last_update_login pn_rec_expcl_dtlln.last_update_login%TYPE)
147: IS
148: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlln_pkg.update_row';

Line 145: x_created_by pn_rec_expcl_dtlln.created_by%TYPE,

141: x_use_fee_before_contr_flag pn_rec_expcl_dtlln.use_fee_before_contr_flag%TYPE,
142: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,
143: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,
144: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,
145: x_created_by pn_rec_expcl_dtlln.created_by%TYPE,
146: x_last_update_login pn_rec_expcl_dtlln.last_update_login%TYPE)
147: IS
148: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlln_pkg.update_row';
149: BEGIN

Line 146: x_last_update_login pn_rec_expcl_dtlln.last_update_login%TYPE)

142: x_last_update_date pn_rec_expcl_dtlln.last_update_date%TYPE,
143: x_last_updated_by pn_rec_expcl_dtlln.last_updated_by%TYPE,
144: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,
145: x_created_by pn_rec_expcl_dtlln.created_by%TYPE,
146: x_last_update_login pn_rec_expcl_dtlln.last_update_login%TYPE)
147: IS
148: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlln_pkg.update_row';
149: BEGIN
150:

Line 148: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlln_pkg.update_row';

144: x_creation_date pn_rec_expcl_dtlln.creation_date%TYPE,
145: x_created_by pn_rec_expcl_dtlln.created_by%TYPE,
146: x_last_update_login pn_rec_expcl_dtlln.last_update_login%TYPE)
147: IS
148: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlln_pkg.update_row';
149: BEGIN
150:
151: pnp_debug_pkg.debug(l_desc ||' (+)');
152:

Line 153: UPDATE pn_rec_expcl_dtlln_all

149: BEGIN
150:
151: pnp_debug_pkg.debug(l_desc ||' (+)');
152:
153: UPDATE pn_rec_expcl_dtlln_all
154: SET
155: expense_class_line_id = x_expense_class_line_id,
156: location_id = x_location_id,
157: cust_space_assign_id = x_cust_space_assign_id,

Line 193: PROCEDURE delete_row(x_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE)

189: -- PURPOSE : deletes the row
190: -- HISTORY :
191: -- 15-JUL-05 sdmahesh o Replaced base views with their _ALL table.
192: -------------------------------------------------------------------------------
193: PROCEDURE delete_row(x_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE)
194: IS
195: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlln_pkg.delete_row';
196: BEGIN
197:

Line 195: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlln_pkg.delete_row';

191: -- 15-JUL-05 sdmahesh o Replaced base views with their _ALL table.
192: -------------------------------------------------------------------------------
193: PROCEDURE delete_row(x_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE)
194: IS
195: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlln_pkg.delete_row';
196: BEGIN
197:
198: pnp_debug_pkg.debug(l_desc ||' (+)');
199:

Line 200: DELETE pn_rec_expcl_dtlln_all /sdm14jul/

196: BEGIN
197:
198: pnp_debug_pkg.debug(l_desc ||' (+)');
199:
200: DELETE pn_rec_expcl_dtlln_all /*sdm14jul*/
201: WHERE expense_class_line_id = x_expense_class_line_id;
202:
203: pnp_debug_pkg.debug(l_desc ||' (-)');
204:

Line 211: END pn_rec_expcl_dtlln_pkg;

207: RAISE_APPLICATION_ERROR(-20001, to_char(sqlcode));
208: app_exception.raise_exception;
209: END delete_row;
210:
211: END pn_rec_expcl_dtlln_pkg;