PACKAGE: APPS.PO_PDOI_UTL

Source

1 PACKAGE PO_PDOI_UTL AS
2 /* $Header: PO_PDOI_UTL.pls 120.4 2006/09/15 22:26:24 jinwang noship $ */
3 
4 -- define pls integer table type (used by FORALL statement)
5 TYPE pls_integer_tbl_type IS TABLE OF PLS_INTEGER;
6 
7 PROCEDURE remove_session_gt_records
8 ( p_key IN NUMBER
9 );
10 
11 PROCEDURE commit_work;
12 
13 FUNCTION get_next_batch_id RETURN NUMBER;
14 
15 PROCEDURE reject_headers_intf
16 ( p_id_param_type IN VARCHAR2,
17   p_id_tbl IN PO_TBL_NUMBER,
18   p_cascade IN VARCHAR2
19 );
20 
21 PROCEDURE reject_lines_intf
22 ( p_id_param_type IN VARCHAR2,
23   p_id_tbl IN PO_TBL_NUMBER,
24   p_cascade IN VARCHAR2
25 );
26 
27 PROCEDURE reject_line_locations_intf
28 ( p_id_param_type IN VARCHAR2,
29   p_id_tbl IN PO_TBL_NUMBER,
30   p_cascade IN VARCHAR2
31 );
32 
33 PROCEDURE reject_distributions_intf
34 ( p_id_param_type IN VARCHAR2,
35   p_id_tbl IN PO_TBL_NUMBER
36 );
37 
38 PROCEDURE reject_price_diff_intf
39 ( p_id_param_type IN VARCHAR2,
40   p_id_tbl IN PO_TBL_NUMBER
41 );
42 
43 PROCEDURE reject_attr_values_intf
44 ( p_id_param_type IN VARCHAR2,
45   p_id_tbl IN PO_TBL_NUMBER
46 );
47 
48 PROCEDURE reject_attr_values_tlp_intf
49 ( p_id_param_type IN VARCHAR2,
50   p_id_tbl IN PO_TBL_NUMBER
51 );
52 
53 PROCEDURE post_reject_document
54 ( p_interface_header_id IN NUMBER,
55   p_po_header_id IN NUMBER,
56   p_draft_id IN NUMBER,
57   p_remove_draft IN VARCHAR2   -- bug5129752
58 );
59 
60 PROCEDURE generate_ordered_num_list
61 ( p_size IN NUMBER,
62   x_num_list OUT NOCOPY DBMS_SQL.NUMBER_TABLE
63 );
64 
65 PROCEDURE get_processing_doctype_info
66 ( x_doc_type    OUT NOCOPY VARCHAR2,
67   x_doc_subtype OUT NOCOPY VARCHAR2
68 );
69 
70 FUNCTION is_old_request_complete
71 ( p_old_request_id IN NUMBER
72 ) RETURN VARCHAR2;
73 
74 PROCEDURE reject_unprocessed_intf
75 (
76   p_intf_header_id IN NUMBER
77 );
78 
79 END PO_PDOI_UTL;