PACKAGE: APPS.PO_R12_CAT_UPG_UTL

Source

1 PACKAGE PO_R12_CAT_UPG_UTL AUTHID CURRENT_USER AS
2 /* $Header: PO_R12_CAT_UPG_UTL.pls 120.2 2006/02/20 11:07:24 pthapliy noship $ */
3 
4   g_SNAPSHOT_TOO_OLD EXCEPTION;
5   PRAGMA EXCEPTION_INIT(g_SNAPSHOT_TOO_OLD, -1555);
6 
7 PROCEDURE add_fatal_error
8 (
9   p_interface_header_id IN NUMBER default NULL,
10   p_interface_line_id IN NUMBER default NULL,
11   p_interface_line_location_id IN NUMBER default NULL,
12   p_interface_distribution_id IN NUMBER default NULL,
13   p_price_diff_interface_id IN NUMBER default NULL,
14   p_interface_attr_values_id IN NUMBER default NULL,
15   p_interface_attr_values_tlp_id IN NUMBER default NULL,
16   p_error_message_name IN VARCHAR2 default NULL,
17   p_table_name IN VARCHAR2 default NULL,
18   p_column_name IN VARCHAR2 default NULL,
19   p_column_value IN VARCHAR2 default NULL,
20   p_token1_name IN VARCHAR2 default NULL,
21   p_token1_value IN VARCHAR2 default NULL,
22   p_token2_name IN VARCHAR2 default NULL,
23   p_token2_value IN VARCHAR2 default NULL,
24   p_token3_name IN VARCHAR2 default NULL,
25   p_token3_value IN VARCHAR2 default NULL,
26   p_token4_name IN VARCHAR2 default NULL,
27   p_token4_value IN VARCHAR2 default NULL,
28   p_token5_name IN VARCHAR2 default NULL,
29   p_token5_value IN VARCHAR2 default NULL,
30   p_token6_name IN VARCHAR2 default NULL,
31   p_token6_value IN VARCHAR2 default NULL
32 );
33 
34 PROCEDURE reject_headers_intf
35 (
36   p_id_param_type IN VARCHAR2,
37   p_id_tbl IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
38   p_cascade IN VARCHAR2
39 );
40 
41 PROCEDURE reject_lines_intf
42 (
43   p_id_param_type IN VARCHAR2,
44   p_id_tbl IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
45   p_cascade IN VARCHAR2
46 );
47 
48 PROCEDURE reject_attr_values_intf
49 (
50   p_id_param_type IN VARCHAR2,
51   p_id_tbl        IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
52 );
53 
54 PROCEDURE reject_attr_values_tlp_intf
55 (
56   p_id_param_type IN VARCHAR2,
57   p_id_tbl IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
58 );
59 
60 FUNCTION construct_subscript_array
61 (
62   p_size IN NUMBER
63 ) RETURN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
64 
65 PROCEDURE assign_processing_id;
66 
67 PROCEDURE init_startup_values
68 (
69   p_commit IN VARCHAR2,
70   p_selected_batch_id IN NUMBER,
71   p_batch_size IN NUMBER,
72   p_buyer_id IN NUMBER,
73   p_document_type IN VARCHAR2,
74   p_document_subtype IN VARCHAR2,
75   p_create_items IN VARCHAR2,
76   p_create_sourcing_rules_flag IN VARCHAR2,
77   p_rel_gen_method IN VARCHAR2,
78   p_approved_status IN VARCHAR2,
79   p_process_code IN VARCHAR2,
80   p_interface_header_id IN NUMBER,
81   p_org_id IN NUMBER,
82   p_ga_flag IN VARCHAR2,
83   p_role IN VARCHAR2,
84   p_error_threshold IN NUMBER,
85   p_validate_only_mode IN VARCHAR2
86 );
87 
88 FUNCTION get_base_lang RETURN VARCHAR2;
89 
90 FUNCTION get_num_languages RETURN NUMBER;
91 
92 END PO_R12_CAT_UPG_UTL;