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_DTLACC_PKG dependencies on PN_REC_EXPCL_DTLACC

Line 1: PACKAGE BODY pn_rec_expcl_dtlacc_pkg AS

1: PACKAGE BODY pn_rec_expcl_dtlacc_pkg AS
2: /* $Header: PNRECLDB.pls 120.2 2005/11/30 23:37:27 appldev noship $ */
3:
4:
5: -------------------------------------------------------------------------------

Line 15: x_org_id pn_rec_expcl_dtlacc.org_id%TYPE,

11: -- 28-NOV-05 pikhar o fetched org_id using cursor
12: -------------------------------------------------------------------------------
13: PROCEDURE insert_row
14: (
15: x_org_id pn_rec_expcl_dtlacc.org_id%TYPE,
16: x_expense_class_line_id pn_rec_expcl_dtlacc.expense_class_line_id%TYPE,
17: x_expense_class_line_dtl_id IN OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
18: x_expense_line_dtl_id pn_rec_expcl_dtlacc.expense_line_dtl_id%TYPE,
19: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,

Line 16: x_expense_class_line_id pn_rec_expcl_dtlacc.expense_class_line_id%TYPE,

12: -------------------------------------------------------------------------------
13: PROCEDURE insert_row
14: (
15: x_org_id pn_rec_expcl_dtlacc.org_id%TYPE,
16: x_expense_class_line_id pn_rec_expcl_dtlacc.expense_class_line_id%TYPE,
17: x_expense_class_line_dtl_id IN OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
18: x_expense_line_dtl_id pn_rec_expcl_dtlacc.expense_line_dtl_id%TYPE,
19: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
20: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,

Line 17: x_expense_class_line_dtl_id IN OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,

13: PROCEDURE insert_row
14: (
15: x_org_id pn_rec_expcl_dtlacc.org_id%TYPE,
16: x_expense_class_line_id pn_rec_expcl_dtlacc.expense_class_line_id%TYPE,
17: x_expense_class_line_dtl_id IN OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
18: x_expense_line_dtl_id pn_rec_expcl_dtlacc.expense_line_dtl_id%TYPE,
19: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
20: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
21: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,

Line 18: x_expense_line_dtl_id pn_rec_expcl_dtlacc.expense_line_dtl_id%TYPE,

14: (
15: x_org_id pn_rec_expcl_dtlacc.org_id%TYPE,
16: x_expense_class_line_id pn_rec_expcl_dtlacc.expense_class_line_id%TYPE,
17: x_expense_class_line_dtl_id IN OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
18: x_expense_line_dtl_id pn_rec_expcl_dtlacc.expense_line_dtl_id%TYPE,
19: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
20: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
21: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
22: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,

Line 19: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,

15: x_org_id pn_rec_expcl_dtlacc.org_id%TYPE,
16: x_expense_class_line_id pn_rec_expcl_dtlacc.expense_class_line_id%TYPE,
17: x_expense_class_line_dtl_id IN OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
18: x_expense_line_dtl_id pn_rec_expcl_dtlacc.expense_line_dtl_id%TYPE,
19: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
20: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
21: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
22: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
23: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,

Line 20: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,

16: x_expense_class_line_id pn_rec_expcl_dtlacc.expense_class_line_id%TYPE,
17: x_expense_class_line_dtl_id IN OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
18: x_expense_line_dtl_id pn_rec_expcl_dtlacc.expense_line_dtl_id%TYPE,
19: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
20: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
21: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
22: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
23: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
24: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,

Line 21: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,

17: x_expense_class_line_dtl_id IN OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
18: x_expense_line_dtl_id pn_rec_expcl_dtlacc.expense_line_dtl_id%TYPE,
19: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
20: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
21: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
22: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
23: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
24: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
25: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,

Line 22: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,

18: x_expense_line_dtl_id pn_rec_expcl_dtlacc.expense_line_dtl_id%TYPE,
19: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
20: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
21: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
22: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
23: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
24: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
25: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
26: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,

Line 23: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,

19: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
20: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
21: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
22: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
23: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
24: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
25: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
26: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
27: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,

Line 24: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,

20: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
21: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
22: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
23: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
24: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
25: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
26: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
27: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
28: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,

Line 25: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,

21: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
22: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
23: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
24: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
25: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
26: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
27: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
28: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
29: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,

Line 26: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,

22: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
23: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
24: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
25: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
26: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
27: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
28: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
29: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
30: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,

Line 27: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,

23: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
24: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
25: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
26: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
27: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
28: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
29: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
30: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,
31: x_creation_date pn_rec_expcl_dtlacc.creation_date%TYPE,

Line 28: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,

24: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
25: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
26: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
27: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
28: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
29: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
30: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,
31: x_creation_date pn_rec_expcl_dtlacc.creation_date%TYPE,
32: x_created_by pn_rec_expcl_dtlacc.created_by%TYPE,

Line 29: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,

25: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
26: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
27: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
28: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
29: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
30: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,
31: x_creation_date pn_rec_expcl_dtlacc.creation_date%TYPE,
32: x_created_by pn_rec_expcl_dtlacc.created_by%TYPE,
33: x_last_update_login pn_rec_expcl_dtlacc.last_update_login%TYPE

Line 30: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,

26: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
27: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
28: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
29: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
30: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,
31: x_creation_date pn_rec_expcl_dtlacc.creation_date%TYPE,
32: x_created_by pn_rec_expcl_dtlacc.created_by%TYPE,
33: x_last_update_login pn_rec_expcl_dtlacc.last_update_login%TYPE
34: )

Line 31: x_creation_date pn_rec_expcl_dtlacc.creation_date%TYPE,

27: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
28: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
29: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
30: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,
31: x_creation_date pn_rec_expcl_dtlacc.creation_date%TYPE,
32: x_created_by pn_rec_expcl_dtlacc.created_by%TYPE,
33: x_last_update_login pn_rec_expcl_dtlacc.last_update_login%TYPE
34: )
35: IS

Line 32: x_created_by pn_rec_expcl_dtlacc.created_by%TYPE,

28: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
29: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
30: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,
31: x_creation_date pn_rec_expcl_dtlacc.creation_date%TYPE,
32: x_created_by pn_rec_expcl_dtlacc.created_by%TYPE,
33: x_last_update_login pn_rec_expcl_dtlacc.last_update_login%TYPE
34: )
35: IS
36: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlacc_pkg.insert_row';

Line 33: x_last_update_login pn_rec_expcl_dtlacc.last_update_login%TYPE

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

Line 36: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlacc_pkg.insert_row';

32: x_created_by pn_rec_expcl_dtlacc.created_by%TYPE,
33: x_last_update_login pn_rec_expcl_dtlacc.last_update_login%TYPE
34: )
35: IS
36: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlacc_pkg.insert_row';
37:
38: CURSOR org_cur IS
39: SELECT org_id
40: FROM pn_rec_expcl_dtlln_all

Line 58: INSERT INTO pn_rec_expcl_dtlacc_all

54: ELSE
55: l_org_id := x_org_id;
56: END IF;
57:
58: INSERT INTO pn_rec_expcl_dtlacc_all
59: (
60: org_id,
61: expense_class_line_dtl_id,
62: expense_class_line_id,

Line 83: pn_rec_expcl_dtlacc_s.nextval,

79: )
80: VALUES
81: (
82: l_org_id,
83: pn_rec_expcl_dtlacc_s.nextval,
84: x_expense_class_line_id,
85: x_expense_line_dtl_id,
86: x_cls_line_dtl_share_pct,
87: x_cls_line_dtl_share_pct_ovr,

Line 120: x_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,

116: -- HISTORY :
117: -- 15-JUL-05 sdmahesh o Replaced base views with their _ALL table.
118: -------------------------------------------------------------------------------
119: PROCEDURE update_row(
120: x_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
121: x_expense_line_dtl_id pn_rec_expcl_dtlacc.expense_line_dtl_id%TYPE,
122: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
123: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
124: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,

Line 121: x_expense_line_dtl_id pn_rec_expcl_dtlacc.expense_line_dtl_id%TYPE,

117: -- 15-JUL-05 sdmahesh o Replaced base views with their _ALL table.
118: -------------------------------------------------------------------------------
119: PROCEDURE update_row(
120: x_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
121: x_expense_line_dtl_id pn_rec_expcl_dtlacc.expense_line_dtl_id%TYPE,
122: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
123: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
124: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
125: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,

Line 122: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,

118: -------------------------------------------------------------------------------
119: PROCEDURE update_row(
120: x_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
121: x_expense_line_dtl_id pn_rec_expcl_dtlacc.expense_line_dtl_id%TYPE,
122: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
123: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
124: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
125: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
126: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,

Line 123: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,

119: PROCEDURE update_row(
120: x_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
121: x_expense_line_dtl_id pn_rec_expcl_dtlacc.expense_line_dtl_id%TYPE,
122: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
123: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
124: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
125: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
126: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
127: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,

Line 124: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,

120: x_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
121: x_expense_line_dtl_id pn_rec_expcl_dtlacc.expense_line_dtl_id%TYPE,
122: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
123: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
124: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
125: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
126: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
127: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
128: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,

Line 125: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,

121: x_expense_line_dtl_id pn_rec_expcl_dtlacc.expense_line_dtl_id%TYPE,
122: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
123: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
124: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
125: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
126: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
127: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
128: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
129: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,

Line 126: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,

122: x_cls_line_dtl_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
123: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
124: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
125: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
126: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
127: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
128: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
129: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
130: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,

Line 127: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,

123: x_cls_line_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct_ovr%TYPE,
124: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
125: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
126: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
127: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
128: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
129: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
130: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
131: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,

Line 128: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,

124: x_cls_line_dtl_fee_bf_ct pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
125: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
126: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
127: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
128: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
129: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
130: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
131: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
132: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,

Line 129: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,

125: x_cls_line_dtl_fee_bf_ct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr_ovr%TYPE,
126: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
127: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
128: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
129: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
130: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
131: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
132: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
133: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,

Line 130: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,

126: x_expense_account_id pn_rec_expcl_dtlacc.expense_account_id%TYPE,
127: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
128: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
129: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
130: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
131: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
132: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
133: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,
134: x_creation_date pn_rec_expcl_dtlacc.creation_date%TYPE,

Line 131: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,

127: x_expense_type_code pn_rec_expcl_dtlacc.expense_type_code%TYPE,
128: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
129: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
130: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
131: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
132: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
133: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,
134: x_creation_date pn_rec_expcl_dtlacc.creation_date%TYPE,
135: x_created_by pn_rec_expcl_dtlacc.created_by%TYPE,

Line 132: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,

128: x_budgeted_amt pn_rec_expcl_dtlacc.budgeted_amt%TYPE,
129: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
130: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
131: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
132: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
133: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,
134: x_creation_date pn_rec_expcl_dtlacc.creation_date%TYPE,
135: x_created_by pn_rec_expcl_dtlacc.created_by%TYPE,
136: x_last_update_login pn_rec_expcl_dtlacc.last_update_login%TYPE)

Line 133: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,

129: x_expense_amt pn_rec_expcl_dtlacc.expense_amt%TYPE,
130: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
131: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
132: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
133: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,
134: x_creation_date pn_rec_expcl_dtlacc.creation_date%TYPE,
135: x_created_by pn_rec_expcl_dtlacc.created_by%TYPE,
136: x_last_update_login pn_rec_expcl_dtlacc.last_update_login%TYPE)
137: IS

Line 134: x_creation_date pn_rec_expcl_dtlacc.creation_date%TYPE,

130: x_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
131: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
132: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
133: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,
134: x_creation_date pn_rec_expcl_dtlacc.creation_date%TYPE,
135: x_created_by pn_rec_expcl_dtlacc.created_by%TYPE,
136: x_last_update_login pn_rec_expcl_dtlacc.last_update_login%TYPE)
137: IS
138: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlacc_pkg.update_row';

Line 135: x_created_by pn_rec_expcl_dtlacc.created_by%TYPE,

131: x_computed_recoverable_amt pn_rec_expcl_dtlacc.recoverable_amt%TYPE,
132: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
133: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,
134: x_creation_date pn_rec_expcl_dtlacc.creation_date%TYPE,
135: x_created_by pn_rec_expcl_dtlacc.created_by%TYPE,
136: x_last_update_login pn_rec_expcl_dtlacc.last_update_login%TYPE)
137: IS
138: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlacc_pkg.update_row';
139: BEGIN

Line 136: x_last_update_login pn_rec_expcl_dtlacc.last_update_login%TYPE)

132: x_last_update_date pn_rec_expcl_dtlacc.last_update_date%TYPE,
133: x_last_updated_by pn_rec_expcl_dtlacc.last_updated_by%TYPE,
134: x_creation_date pn_rec_expcl_dtlacc.creation_date%TYPE,
135: x_created_by pn_rec_expcl_dtlacc.created_by%TYPE,
136: x_last_update_login pn_rec_expcl_dtlacc.last_update_login%TYPE)
137: IS
138: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlacc_pkg.update_row';
139: BEGIN
140:

Line 138: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlacc_pkg.update_row';

134: x_creation_date pn_rec_expcl_dtlacc.creation_date%TYPE,
135: x_created_by pn_rec_expcl_dtlacc.created_by%TYPE,
136: x_last_update_login pn_rec_expcl_dtlacc.last_update_login%TYPE)
137: IS
138: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlacc_pkg.update_row';
139: BEGIN
140:
141: pnp_debug_pkg.debug(l_desc ||' (+)');
142:

Line 143: UPDATE pn_rec_expcl_dtlacc_all

139: BEGIN
140:
141: pnp_debug_pkg.debug(l_desc ||' (+)');
142:
143: UPDATE pn_rec_expcl_dtlacc_all
144: SET
145: expense_line_dtl_id = x_expense_line_dtl_id,
146: cls_line_dtl_share_pct = x_cls_line_dtl_share_pct,
147: cls_line_dtl_share_pct_ovr = x_cls_line_dtl_share_pct_ovr,

Line 179: PROCEDURE delete_row(x_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE)

175: -- PURPOSE : deletes the row
176: -- HISTORY :
177: -- 15-JUL-05 sdmahesh o Replaced base views with their _ALL table.
178: -------------------------------------------------------------------------------
179: PROCEDURE delete_row(x_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE)
180: IS
181: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlacc_pkg.delete_row';
182: BEGIN
183:

Line 181: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlacc_pkg.delete_row';

177: -- 15-JUL-05 sdmahesh o Replaced base views with their _ALL table.
178: -------------------------------------------------------------------------------
179: PROCEDURE delete_row(x_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE)
180: IS
181: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlacc_pkg.delete_row';
182: BEGIN
183:
184: pnp_debug_pkg.debug(l_desc ||' (+)');
185:

Line 186: DELETE pn_rec_expcl_dtlacc_all

182: BEGIN
183:
184: pnp_debug_pkg.debug(l_desc ||' (+)');
185:
186: DELETE pn_rec_expcl_dtlacc_all
187: WHERE expense_class_line_dtl_id = x_expense_class_line_dtl_id;
188:
189: pnp_debug_pkg.debug(l_desc ||' (-)');
190:

Line 197: END pn_rec_expcl_dtlacc_pkg;

193: RAISE_APPLICATION_ERROR(-20001, to_char(sqlcode));
194: app_exception.raise_exception;
195: END delete_row;
196:
197: END pn_rec_expcl_dtlacc_pkg;