1 PACKAGE pon_auc_doctypes_pkg AS
2 /* $Header: PONDOCTS.pls 120.3 2006/05/24 17:22:37 mxfang noship $ */
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
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);
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,
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,
38 p_owner IN VARCHAR2,
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
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);
57
58
59 PROCEDURE delete_row (
60 p_internal_name pon_auc_doctypes.internal_name%TYPE
61 );
62
63 PROCEDURE add_language;
64
65 END pon_auc_doctypes_pkg;