1: PACKAGE pn_rec_exp_line_pkg AUTHID CURRENT_USER AS
2: /* $Header: PNREXLHS.pls 115.2 2003/07/03 01:01:48 ftanudja noship $ */
3:
4: PROCEDURE insert_row(
5: x_org_id pn_rec_exp_line.org_id%TYPE,
1: PACKAGE pn_rec_exp_line_pkg AUTHID CURRENT_USER AS
2: /* $Header: PNREXLHS.pls 115.2 2003/07/03 01:01:48 ftanudja noship $ */
3:
4: PROCEDURE insert_row(
5: x_org_id pn_rec_exp_line.org_id%TYPE,
6: x_expense_line_id IN OUT NOCOPY pn_rec_exp_line.expense_line_id%TYPE,
7: x_expense_extract_code IN OUT NOCOPY pn_rec_exp_line.expense_extract_code%TYPE,
8: x_currency_code pn_rec_exp_line.currency_code%TYPE,
9: x_as_of_date pn_rec_exp_line.as_of_date%TYPE,
2: /* $Header: PNREXLHS.pls 115.2 2003/07/03 01:01:48 ftanudja noship $ */
3:
4: PROCEDURE insert_row(
5: x_org_id pn_rec_exp_line.org_id%TYPE,
6: x_expense_line_id IN OUT NOCOPY pn_rec_exp_line.expense_line_id%TYPE,
7: x_expense_extract_code IN OUT NOCOPY pn_rec_exp_line.expense_extract_code%TYPE,
8: x_currency_code pn_rec_exp_line.currency_code%TYPE,
9: x_as_of_date pn_rec_exp_line.as_of_date%TYPE,
10: x_from_date pn_rec_exp_line.from_date%TYPE,
3:
4: PROCEDURE insert_row(
5: x_org_id pn_rec_exp_line.org_id%TYPE,
6: x_expense_line_id IN OUT NOCOPY pn_rec_exp_line.expense_line_id%TYPE,
7: x_expense_extract_code IN OUT NOCOPY pn_rec_exp_line.expense_extract_code%TYPE,
8: x_currency_code pn_rec_exp_line.currency_code%TYPE,
9: x_as_of_date pn_rec_exp_line.as_of_date%TYPE,
10: x_from_date pn_rec_exp_line.from_date%TYPE,
11: x_to_date pn_rec_exp_line.to_date%TYPE,
4: PROCEDURE insert_row(
5: x_org_id pn_rec_exp_line.org_id%TYPE,
6: x_expense_line_id IN OUT NOCOPY pn_rec_exp_line.expense_line_id%TYPE,
7: x_expense_extract_code IN OUT NOCOPY pn_rec_exp_line.expense_extract_code%TYPE,
8: x_currency_code pn_rec_exp_line.currency_code%TYPE,
9: x_as_of_date pn_rec_exp_line.as_of_date%TYPE,
10: x_from_date pn_rec_exp_line.from_date%TYPE,
11: x_to_date pn_rec_exp_line.to_date%TYPE,
12: x_location_id pn_rec_exp_line.location_id%TYPE,
5: x_org_id pn_rec_exp_line.org_id%TYPE,
6: x_expense_line_id IN OUT NOCOPY pn_rec_exp_line.expense_line_id%TYPE,
7: x_expense_extract_code IN OUT NOCOPY pn_rec_exp_line.expense_extract_code%TYPE,
8: x_currency_code pn_rec_exp_line.currency_code%TYPE,
9: x_as_of_date pn_rec_exp_line.as_of_date%TYPE,
10: x_from_date pn_rec_exp_line.from_date%TYPE,
11: x_to_date pn_rec_exp_line.to_date%TYPE,
12: x_location_id pn_rec_exp_line.location_id%TYPE,
13: x_property_id pn_rec_exp_line.property_id%TYPE,
6: x_expense_line_id IN OUT NOCOPY pn_rec_exp_line.expense_line_id%TYPE,
7: x_expense_extract_code IN OUT NOCOPY pn_rec_exp_line.expense_extract_code%TYPE,
8: x_currency_code pn_rec_exp_line.currency_code%TYPE,
9: x_as_of_date pn_rec_exp_line.as_of_date%TYPE,
10: x_from_date pn_rec_exp_line.from_date%TYPE,
11: x_to_date pn_rec_exp_line.to_date%TYPE,
12: x_location_id pn_rec_exp_line.location_id%TYPE,
13: x_property_id pn_rec_exp_line.property_id%TYPE,
14: x_last_update_date pn_rec_exp_line.last_update_date%TYPE,
7: x_expense_extract_code IN OUT NOCOPY pn_rec_exp_line.expense_extract_code%TYPE,
8: x_currency_code pn_rec_exp_line.currency_code%TYPE,
9: x_as_of_date pn_rec_exp_line.as_of_date%TYPE,
10: x_from_date pn_rec_exp_line.from_date%TYPE,
11: x_to_date pn_rec_exp_line.to_date%TYPE,
12: x_location_id pn_rec_exp_line.location_id%TYPE,
13: x_property_id pn_rec_exp_line.property_id%TYPE,
14: x_last_update_date pn_rec_exp_line.last_update_date%TYPE,
15: x_last_updated_by pn_rec_exp_line.last_updated_by%TYPE,
8: x_currency_code pn_rec_exp_line.currency_code%TYPE,
9: x_as_of_date pn_rec_exp_line.as_of_date%TYPE,
10: x_from_date pn_rec_exp_line.from_date%TYPE,
11: x_to_date pn_rec_exp_line.to_date%TYPE,
12: x_location_id pn_rec_exp_line.location_id%TYPE,
13: x_property_id pn_rec_exp_line.property_id%TYPE,
14: x_last_update_date pn_rec_exp_line.last_update_date%TYPE,
15: x_last_updated_by pn_rec_exp_line.last_updated_by%TYPE,
16: x_creation_date pn_rec_exp_line.creation_date%TYPE,
9: x_as_of_date pn_rec_exp_line.as_of_date%TYPE,
10: x_from_date pn_rec_exp_line.from_date%TYPE,
11: x_to_date pn_rec_exp_line.to_date%TYPE,
12: x_location_id pn_rec_exp_line.location_id%TYPE,
13: x_property_id pn_rec_exp_line.property_id%TYPE,
14: x_last_update_date pn_rec_exp_line.last_update_date%TYPE,
15: x_last_updated_by pn_rec_exp_line.last_updated_by%TYPE,
16: x_creation_date pn_rec_exp_line.creation_date%TYPE,
17: x_created_by pn_rec_exp_line.created_by%TYPE,
10: x_from_date pn_rec_exp_line.from_date%TYPE,
11: x_to_date pn_rec_exp_line.to_date%TYPE,
12: x_location_id pn_rec_exp_line.location_id%TYPE,
13: x_property_id pn_rec_exp_line.property_id%TYPE,
14: x_last_update_date pn_rec_exp_line.last_update_date%TYPE,
15: x_last_updated_by pn_rec_exp_line.last_updated_by%TYPE,
16: x_creation_date pn_rec_exp_line.creation_date%TYPE,
17: x_created_by pn_rec_exp_line.created_by%TYPE,
18: x_last_update_login pn_rec_exp_line.last_update_login%TYPE);
11: x_to_date pn_rec_exp_line.to_date%TYPE,
12: x_location_id pn_rec_exp_line.location_id%TYPE,
13: x_property_id pn_rec_exp_line.property_id%TYPE,
14: x_last_update_date pn_rec_exp_line.last_update_date%TYPE,
15: x_last_updated_by pn_rec_exp_line.last_updated_by%TYPE,
16: x_creation_date pn_rec_exp_line.creation_date%TYPE,
17: x_created_by pn_rec_exp_line.created_by%TYPE,
18: x_last_update_login pn_rec_exp_line.last_update_login%TYPE);
19:
12: x_location_id pn_rec_exp_line.location_id%TYPE,
13: x_property_id pn_rec_exp_line.property_id%TYPE,
14: x_last_update_date pn_rec_exp_line.last_update_date%TYPE,
15: x_last_updated_by pn_rec_exp_line.last_updated_by%TYPE,
16: x_creation_date pn_rec_exp_line.creation_date%TYPE,
17: x_created_by pn_rec_exp_line.created_by%TYPE,
18: x_last_update_login pn_rec_exp_line.last_update_login%TYPE);
19:
20: PROCEDURE update_row(
13: x_property_id pn_rec_exp_line.property_id%TYPE,
14: x_last_update_date pn_rec_exp_line.last_update_date%TYPE,
15: x_last_updated_by pn_rec_exp_line.last_updated_by%TYPE,
16: x_creation_date pn_rec_exp_line.creation_date%TYPE,
17: x_created_by pn_rec_exp_line.created_by%TYPE,
18: x_last_update_login pn_rec_exp_line.last_update_login%TYPE);
19:
20: PROCEDURE update_row(
21: x_expense_line_id pn_rec_exp_line.expense_line_id%TYPE,
14: x_last_update_date pn_rec_exp_line.last_update_date%TYPE,
15: x_last_updated_by pn_rec_exp_line.last_updated_by%TYPE,
16: x_creation_date pn_rec_exp_line.creation_date%TYPE,
17: x_created_by pn_rec_exp_line.created_by%TYPE,
18: x_last_update_login pn_rec_exp_line.last_update_login%TYPE);
19:
20: PROCEDURE update_row(
21: x_expense_line_id pn_rec_exp_line.expense_line_id%TYPE,
22: x_expense_extract_code pn_rec_exp_line.expense_extract_code%TYPE,
17: x_created_by pn_rec_exp_line.created_by%TYPE,
18: x_last_update_login pn_rec_exp_line.last_update_login%TYPE);
19:
20: PROCEDURE update_row(
21: x_expense_line_id pn_rec_exp_line.expense_line_id%TYPE,
22: x_expense_extract_code pn_rec_exp_line.expense_extract_code%TYPE,
23: x_currency_code pn_rec_exp_line.currency_code%TYPE,
24: x_as_of_date pn_rec_exp_line.as_of_date%TYPE,
25: x_from_date pn_rec_exp_line.from_date%TYPE,
18: x_last_update_login pn_rec_exp_line.last_update_login%TYPE);
19:
20: PROCEDURE update_row(
21: x_expense_line_id pn_rec_exp_line.expense_line_id%TYPE,
22: x_expense_extract_code pn_rec_exp_line.expense_extract_code%TYPE,
23: x_currency_code pn_rec_exp_line.currency_code%TYPE,
24: x_as_of_date pn_rec_exp_line.as_of_date%TYPE,
25: x_from_date pn_rec_exp_line.from_date%TYPE,
26: x_to_date pn_rec_exp_line.to_date%TYPE,
19:
20: PROCEDURE update_row(
21: x_expense_line_id pn_rec_exp_line.expense_line_id%TYPE,
22: x_expense_extract_code pn_rec_exp_line.expense_extract_code%TYPE,
23: x_currency_code pn_rec_exp_line.currency_code%TYPE,
24: x_as_of_date pn_rec_exp_line.as_of_date%TYPE,
25: x_from_date pn_rec_exp_line.from_date%TYPE,
26: x_to_date pn_rec_exp_line.to_date%TYPE,
27: x_location_id pn_rec_exp_line.location_id%TYPE,
20: PROCEDURE update_row(
21: x_expense_line_id pn_rec_exp_line.expense_line_id%TYPE,
22: x_expense_extract_code pn_rec_exp_line.expense_extract_code%TYPE,
23: x_currency_code pn_rec_exp_line.currency_code%TYPE,
24: x_as_of_date pn_rec_exp_line.as_of_date%TYPE,
25: x_from_date pn_rec_exp_line.from_date%TYPE,
26: x_to_date pn_rec_exp_line.to_date%TYPE,
27: x_location_id pn_rec_exp_line.location_id%TYPE,
28: x_property_id pn_rec_exp_line.property_id%TYPE,
21: x_expense_line_id pn_rec_exp_line.expense_line_id%TYPE,
22: x_expense_extract_code pn_rec_exp_line.expense_extract_code%TYPE,
23: x_currency_code pn_rec_exp_line.currency_code%TYPE,
24: x_as_of_date pn_rec_exp_line.as_of_date%TYPE,
25: x_from_date pn_rec_exp_line.from_date%TYPE,
26: x_to_date pn_rec_exp_line.to_date%TYPE,
27: x_location_id pn_rec_exp_line.location_id%TYPE,
28: x_property_id pn_rec_exp_line.property_id%TYPE,
29: x_last_update_date pn_rec_exp_line.last_update_date%TYPE,
22: x_expense_extract_code pn_rec_exp_line.expense_extract_code%TYPE,
23: x_currency_code pn_rec_exp_line.currency_code%TYPE,
24: x_as_of_date pn_rec_exp_line.as_of_date%TYPE,
25: x_from_date pn_rec_exp_line.from_date%TYPE,
26: x_to_date pn_rec_exp_line.to_date%TYPE,
27: x_location_id pn_rec_exp_line.location_id%TYPE,
28: x_property_id pn_rec_exp_line.property_id%TYPE,
29: x_last_update_date pn_rec_exp_line.last_update_date%TYPE,
30: x_last_updated_by pn_rec_exp_line.last_updated_by%TYPE,
23: x_currency_code pn_rec_exp_line.currency_code%TYPE,
24: x_as_of_date pn_rec_exp_line.as_of_date%TYPE,
25: x_from_date pn_rec_exp_line.from_date%TYPE,
26: x_to_date pn_rec_exp_line.to_date%TYPE,
27: x_location_id pn_rec_exp_line.location_id%TYPE,
28: x_property_id pn_rec_exp_line.property_id%TYPE,
29: x_last_update_date pn_rec_exp_line.last_update_date%TYPE,
30: x_last_updated_by pn_rec_exp_line.last_updated_by%TYPE,
31: x_creation_date pn_rec_exp_line.creation_date%TYPE,
24: x_as_of_date pn_rec_exp_line.as_of_date%TYPE,
25: x_from_date pn_rec_exp_line.from_date%TYPE,
26: x_to_date pn_rec_exp_line.to_date%TYPE,
27: x_location_id pn_rec_exp_line.location_id%TYPE,
28: x_property_id pn_rec_exp_line.property_id%TYPE,
29: x_last_update_date pn_rec_exp_line.last_update_date%TYPE,
30: x_last_updated_by pn_rec_exp_line.last_updated_by%TYPE,
31: x_creation_date pn_rec_exp_line.creation_date%TYPE,
32: x_created_by pn_rec_exp_line.created_by%TYPE,
25: x_from_date pn_rec_exp_line.from_date%TYPE,
26: x_to_date pn_rec_exp_line.to_date%TYPE,
27: x_location_id pn_rec_exp_line.location_id%TYPE,
28: x_property_id pn_rec_exp_line.property_id%TYPE,
29: x_last_update_date pn_rec_exp_line.last_update_date%TYPE,
30: x_last_updated_by pn_rec_exp_line.last_updated_by%TYPE,
31: x_creation_date pn_rec_exp_line.creation_date%TYPE,
32: x_created_by pn_rec_exp_line.created_by%TYPE,
33: x_last_update_login pn_rec_exp_line.last_update_login%TYPE);
26: x_to_date pn_rec_exp_line.to_date%TYPE,
27: x_location_id pn_rec_exp_line.location_id%TYPE,
28: x_property_id pn_rec_exp_line.property_id%TYPE,
29: x_last_update_date pn_rec_exp_line.last_update_date%TYPE,
30: x_last_updated_by pn_rec_exp_line.last_updated_by%TYPE,
31: x_creation_date pn_rec_exp_line.creation_date%TYPE,
32: x_created_by pn_rec_exp_line.created_by%TYPE,
33: x_last_update_login pn_rec_exp_line.last_update_login%TYPE);
34:
27: x_location_id pn_rec_exp_line.location_id%TYPE,
28: x_property_id pn_rec_exp_line.property_id%TYPE,
29: x_last_update_date pn_rec_exp_line.last_update_date%TYPE,
30: x_last_updated_by pn_rec_exp_line.last_updated_by%TYPE,
31: x_creation_date pn_rec_exp_line.creation_date%TYPE,
32: x_created_by pn_rec_exp_line.created_by%TYPE,
33: x_last_update_login pn_rec_exp_line.last_update_login%TYPE);
34:
35: PROCEDURE delete_row(x_expense_line_id pn_rec_exp_line.expense_line_id%TYPE);
28: x_property_id pn_rec_exp_line.property_id%TYPE,
29: x_last_update_date pn_rec_exp_line.last_update_date%TYPE,
30: x_last_updated_by pn_rec_exp_line.last_updated_by%TYPE,
31: x_creation_date pn_rec_exp_line.creation_date%TYPE,
32: x_created_by pn_rec_exp_line.created_by%TYPE,
33: x_last_update_login pn_rec_exp_line.last_update_login%TYPE);
34:
35: PROCEDURE delete_row(x_expense_line_id pn_rec_exp_line.expense_line_id%TYPE);
36:
29: x_last_update_date pn_rec_exp_line.last_update_date%TYPE,
30: x_last_updated_by pn_rec_exp_line.last_updated_by%TYPE,
31: x_creation_date pn_rec_exp_line.creation_date%TYPE,
32: x_created_by pn_rec_exp_line.created_by%TYPE,
33: x_last_update_login pn_rec_exp_line.last_update_login%TYPE);
34:
35: PROCEDURE delete_row(x_expense_line_id pn_rec_exp_line.expense_line_id%TYPE);
36:
37: END pn_rec_exp_line_pkg;
31: x_creation_date pn_rec_exp_line.creation_date%TYPE,
32: x_created_by pn_rec_exp_line.created_by%TYPE,
33: x_last_update_login pn_rec_exp_line.last_update_login%TYPE);
34:
35: PROCEDURE delete_row(x_expense_line_id pn_rec_exp_line.expense_line_id%TYPE);
36:
37: END pn_rec_exp_line_pkg;
33: x_last_update_login pn_rec_exp_line.last_update_login%TYPE);
34:
35: PROCEDURE delete_row(x_expense_line_id pn_rec_exp_line.expense_line_id%TYPE);
36:
37: END pn_rec_exp_line_pkg;