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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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: )
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
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';
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
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;
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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)
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
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';
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
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:
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:
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,
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:
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:
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:
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;