1: PACKAGE pon_auc_doctypes_pkg AS
2: /* $Header: PONDOCTS.pls 120.3 2006/05/24 17:22:37 mxfang noship $ */
3:
4:
5:
3:
4:
5:
6: PROCEDURE insert_row (
7: p_doctype_id IN pon_auc_doctypes.doctype_id%TYPE
8: ,p_internal_name IN pon_auc_doctypes.internal_name%TYPE
9: ,p_scope IN pon_auc_doctypes.scope%TYPE
10: ,p_status IN pon_auc_doctypes.status%TYPE
11: ,p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE
4:
5:
6: PROCEDURE insert_row (
7: p_doctype_id IN pon_auc_doctypes.doctype_id%TYPE
8: ,p_internal_name IN pon_auc_doctypes.internal_name%TYPE
9: ,p_scope IN pon_auc_doctypes.scope%TYPE
10: ,p_status IN pon_auc_doctypes.status%TYPE
11: ,p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE
12: ,p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE
5:
6: PROCEDURE insert_row (
7: p_doctype_id IN pon_auc_doctypes.doctype_id%TYPE
8: ,p_internal_name IN pon_auc_doctypes.internal_name%TYPE
9: ,p_scope IN pon_auc_doctypes.scope%TYPE
10: ,p_status IN pon_auc_doctypes.status%TYPE
11: ,p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE
12: ,p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE
13: ,p_created_by IN pon_auc_doctypes.created_by%TYPE
6: PROCEDURE insert_row (
7: p_doctype_id IN pon_auc_doctypes.doctype_id%TYPE
8: ,p_internal_name IN pon_auc_doctypes.internal_name%TYPE
9: ,p_scope IN pon_auc_doctypes.scope%TYPE
10: ,p_status IN pon_auc_doctypes.status%TYPE
11: ,p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE
12: ,p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE
13: ,p_created_by IN pon_auc_doctypes.created_by%TYPE
14: ,p_creation_date IN pon_auc_doctypes.creation_date%TYPE
7: p_doctype_id IN pon_auc_doctypes.doctype_id%TYPE
8: ,p_internal_name IN pon_auc_doctypes.internal_name%TYPE
9: ,p_scope IN pon_auc_doctypes.scope%TYPE
10: ,p_status IN pon_auc_doctypes.status%TYPE
11: ,p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE
12: ,p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE
13: ,p_created_by IN pon_auc_doctypes.created_by%TYPE
14: ,p_creation_date IN pon_auc_doctypes.creation_date%TYPE
15: ,p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE
8: ,p_internal_name IN pon_auc_doctypes.internal_name%TYPE
9: ,p_scope IN pon_auc_doctypes.scope%TYPE
10: ,p_status IN pon_auc_doctypes.status%TYPE
11: ,p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE
12: ,p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE
13: ,p_created_by IN pon_auc_doctypes.created_by%TYPE
14: ,p_creation_date IN pon_auc_doctypes.creation_date%TYPE
15: ,p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE
16: ,p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE
9: ,p_scope IN pon_auc_doctypes.scope%TYPE
10: ,p_status IN pon_auc_doctypes.status%TYPE
11: ,p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE
12: ,p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE
13: ,p_created_by IN pon_auc_doctypes.created_by%TYPE
14: ,p_creation_date IN pon_auc_doctypes.creation_date%TYPE
15: ,p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE
16: ,p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE
17: ,p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE
10: ,p_status IN pon_auc_doctypes.status%TYPE
11: ,p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE
12: ,p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE
13: ,p_created_by IN pon_auc_doctypes.created_by%TYPE
14: ,p_creation_date IN pon_auc_doctypes.creation_date%TYPE
15: ,p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE
16: ,p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE
17: ,p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE
18: ,p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE
11: ,p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE
12: ,p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE
13: ,p_created_by IN pon_auc_doctypes.created_by%TYPE
14: ,p_creation_date IN pon_auc_doctypes.creation_date%TYPE
15: ,p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE
16: ,p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE
17: ,p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE
18: ,p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE
19: ,p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE
12: ,p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE
13: ,p_created_by IN pon_auc_doctypes.created_by%TYPE
14: ,p_creation_date IN pon_auc_doctypes.creation_date%TYPE
15: ,p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE
16: ,p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE
17: ,p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE
18: ,p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE
19: ,p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE
20: ,p_name IN pon_auc_doctypes_tl.name%TYPE);
13: ,p_created_by IN pon_auc_doctypes.created_by%TYPE
14: ,p_creation_date IN pon_auc_doctypes.creation_date%TYPE
15: ,p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE
16: ,p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE
17: ,p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE
18: ,p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE
19: ,p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE
20: ,p_name IN pon_auc_doctypes_tl.name%TYPE);
21:
14: ,p_creation_date IN pon_auc_doctypes.creation_date%TYPE
15: ,p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE
16: ,p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE
17: ,p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE
18: ,p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE
19: ,p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE
20: ,p_name IN pon_auc_doctypes_tl.name%TYPE);
21:
22: PROCEDURE update_row (
15: ,p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE
16: ,p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE
17: ,p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE
18: ,p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE
19: ,p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE
20: ,p_name IN pon_auc_doctypes_tl.name%TYPE);
21:
22: PROCEDURE update_row (
23: p_internal_name IN pon_auc_doctypes.internal_name%TYPE,
16: ,p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE
17: ,p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE
18: ,p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE
19: ,p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE
20: ,p_name IN pon_auc_doctypes_tl.name%TYPE);
21:
22: PROCEDURE update_row (
23: p_internal_name IN pon_auc_doctypes.internal_name%TYPE,
24: p_scope IN pon_auc_doctypes.scope%TYPE,
19: ,p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE
20: ,p_name IN pon_auc_doctypes_tl.name%TYPE);
21:
22: PROCEDURE update_row (
23: p_internal_name IN pon_auc_doctypes.internal_name%TYPE,
24: p_scope IN pon_auc_doctypes.scope%TYPE,
25: p_status IN pon_auc_doctypes.status%TYPE,
26: p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE,
27: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
20: ,p_name IN pon_auc_doctypes_tl.name%TYPE);
21:
22: PROCEDURE update_row (
23: p_internal_name IN pon_auc_doctypes.internal_name%TYPE,
24: p_scope IN pon_auc_doctypes.scope%TYPE,
25: p_status IN pon_auc_doctypes.status%TYPE,
26: p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE,
27: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
28: p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE,
21:
22: PROCEDURE update_row (
23: p_internal_name IN pon_auc_doctypes.internal_name%TYPE,
24: p_scope IN pon_auc_doctypes.scope%TYPE,
25: p_status IN pon_auc_doctypes.status%TYPE,
26: p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE,
27: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
28: p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE,
29: p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE,
22: PROCEDURE update_row (
23: p_internal_name IN pon_auc_doctypes.internal_name%TYPE,
24: p_scope IN pon_auc_doctypes.scope%TYPE,
25: p_status IN pon_auc_doctypes.status%TYPE,
26: p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE,
27: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
28: p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE,
29: p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE,
30: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,
23: p_internal_name IN pon_auc_doctypes.internal_name%TYPE,
24: p_scope IN pon_auc_doctypes.scope%TYPE,
25: p_status IN pon_auc_doctypes.status%TYPE,
26: p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE,
27: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
28: p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE,
29: p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE,
30: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,
31: p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE,
24: p_scope IN pon_auc_doctypes.scope%TYPE,
25: p_status IN pon_auc_doctypes.status%TYPE,
26: p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE,
27: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
28: p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE,
29: p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE,
30: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,
31: p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE,
32: p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE,
25: p_status IN pon_auc_doctypes.status%TYPE,
26: p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE,
27: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
28: p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE,
29: p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE,
30: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,
31: p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE,
32: p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE,
33: p_name IN pon_auc_doctypes_tl.name%TYPE);
26: p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE,
27: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
28: p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE,
29: p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE,
30: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,
31: p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE,
32: p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE,
33: p_name IN pon_auc_doctypes_tl.name%TYPE);
34:
27: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
28: p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE,
29: p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE,
30: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,
31: p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE,
32: p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE,
33: p_name IN pon_auc_doctypes_tl.name%TYPE);
34:
35: PROCEDURE translate_row (
28: p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE,
29: p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE,
30: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,
31: p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE,
32: p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE,
33: p_name IN pon_auc_doctypes_tl.name%TYPE);
34:
35: PROCEDURE translate_row (
36: p_internal_name IN pon_auc_doctypes.internal_name%TYPE,
29: p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE,
30: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,
31: p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE,
32: p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE,
33: p_name IN pon_auc_doctypes_tl.name%TYPE);
34:
35: PROCEDURE translate_row (
36: p_internal_name IN pon_auc_doctypes.internal_name%TYPE,
37: p_name IN pon_auc_doctypes_tl.name%TYPE,
32: p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE,
33: p_name IN pon_auc_doctypes_tl.name%TYPE);
34:
35: PROCEDURE translate_row (
36: p_internal_name IN pon_auc_doctypes.internal_name%TYPE,
37: p_name IN pon_auc_doctypes_tl.name%TYPE,
38: p_owner IN VARCHAR2,
39: p_custom_mode IN VARCHAR2,
40: p_last_update_date IN VARCHAR2);
33: p_name IN pon_auc_doctypes_tl.name%TYPE);
34:
35: PROCEDURE translate_row (
36: p_internal_name IN pon_auc_doctypes.internal_name%TYPE,
37: p_name IN pon_auc_doctypes_tl.name%TYPE,
38: p_owner IN VARCHAR2,
39: p_custom_mode IN VARCHAR2,
40: p_last_update_date IN VARCHAR2);
41:
39: p_custom_mode IN VARCHAR2,
40: p_last_update_date IN VARCHAR2);
41:
42: PROCEDURE load_row (
43: p_internal_name IN pon_auc_doctypes.internal_name%TYPE,
44: p_owner IN VARCHAR2,
45: p_last_update_date IN VARCHAR2,
46: p_custom_mode IN VARCHAR2, -- Custom mode can be FORCE
47: -- to force data to be uploaded
45: p_last_update_date IN VARCHAR2,
46: p_custom_mode IN VARCHAR2, -- Custom mode can be FORCE
47: -- to force data to be uploaded
48: -- irrespective of current status
49: p_scope IN pon_auc_doctypes.scope%TYPE,
50: p_status IN pon_auc_doctypes.status%TYPE,
51: p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE,
52: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
53: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,
46: p_custom_mode IN VARCHAR2, -- Custom mode can be FORCE
47: -- to force data to be uploaded
48: -- irrespective of current status
49: p_scope IN pon_auc_doctypes.scope%TYPE,
50: p_status IN pon_auc_doctypes.status%TYPE,
51: p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE,
52: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
53: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,
54: p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE,
47: -- to force data to be uploaded
48: -- irrespective of current status
49: p_scope IN pon_auc_doctypes.scope%TYPE,
50: p_status IN pon_auc_doctypes.status%TYPE,
51: p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE,
52: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
53: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,
54: p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE,
55: p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE,
48: -- irrespective of current status
49: p_scope IN pon_auc_doctypes.scope%TYPE,
50: p_status IN pon_auc_doctypes.status%TYPE,
51: p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE,
52: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
53: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,
54: p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE,
55: p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE,
56: p_name IN pon_auc_doctypes_tl.name%TYPE);
49: p_scope IN pon_auc_doctypes.scope%TYPE,
50: p_status IN pon_auc_doctypes.status%TYPE,
51: p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE,
52: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
53: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,
54: p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE,
55: p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE,
56: p_name IN pon_auc_doctypes_tl.name%TYPE);
57:
50: p_status IN pon_auc_doctypes.status%TYPE,
51: p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE,
52: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
53: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,
54: p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE,
55: p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE,
56: p_name IN pon_auc_doctypes_tl.name%TYPE);
57:
58:
51: p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE,
52: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
53: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,
54: p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE,
55: p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE,
56: p_name IN pon_auc_doctypes_tl.name%TYPE);
57:
58:
59: PROCEDURE delete_row (
52: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
53: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,
54: p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE,
55: p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE,
56: p_name IN pon_auc_doctypes_tl.name%TYPE);
57:
58:
59: PROCEDURE delete_row (
60: p_internal_name pon_auc_doctypes.internal_name%TYPE
56: p_name IN pon_auc_doctypes_tl.name%TYPE);
57:
58:
59: PROCEDURE delete_row (
60: p_internal_name pon_auc_doctypes.internal_name%TYPE
61: );
62:
63: PROCEDURE add_language;
64:
61: );
62:
63: PROCEDURE add_language;
64:
65: END pon_auc_doctypes_pkg;