PACKAGE: APPS.PO_AUTOCREATE_GROUPING_PVT

Source

1 PACKAGE PO_AUTOCREATE_GROUPING_PVT AS
2 /* $Header: PO_AUTOCREATE_GROUPING_PVT.pls 120.0 2005/09/30 15:07 vilee noship $ */
3 
4 FUNCTION get_line_action_tbl(
5   p_po_line_number_tbl IN PO_TBL_NUMBER,
6   p_add_to_po_header_id IN NUMBER
7 ) RETURN PO_TBL_VARCHAR5;
8 
9 PROCEDURE check_po_line_numbers(
10   p_style_id IN NUMBER,
11   p_agreement_id IN NUMBER,
12   p_supplier_id IN NUMBER,
13   p_site_id IN NUMBER,
14   p_req_line_id_tbl IN PO_TBL_NUMBER,
15   p_po_line_number_tbl IN PO_TBL_NUMBER,
16   p_add_to_po_header_id IN NUMBER,
17   x_message_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
18   x_token_name_tbl OUT NOCOPY PO_TBL_VARCHAR30,
19   x_token_value_tbl OUT NOCOPY PO_TBL_VARCHAR2000
20 );
21 
22 PROCEDURE lines_match(
23   p_agreement_id IN NUMBER,
24   p_supplier_id IN NUMBER,
25   p_site_id IN NUMBER,
26   p_req_line_id IN NUMBER,
27   p_req_line_id_to_compare IN NUMBER,
28   p_po_line_id_to_compare IN NUMBER,
29   x_message_code OUT NOCOPY VARCHAR2,
30   x_token_name OUT NOCOPY VARCHAR2,
31   x_token_value OUT NOCOPY VARCHAR2
32 );
33 
34 FUNCTION group_req_lines
35 (   p_req_line_id_tbl      IN  PO_TBL_NUMBER
36 ,   p_req_line_num_tbl     IN  PO_TBL_NUMBER
37 ,   p_po_line_num_tbl      IN  PO_TBL_NUMBER
38 ,   p_add_to_po_header_id  IN  NUMBER
39 ,   p_builder_agreement_id IN  NUMBER
40 ,   p_builder_supplier_id  IN  NUMBER
41 ,   p_builder_site_id      IN  NUMBER
42 ,   p_builder_org_id       IN  NUMBER
43 ,   p_start_index          IN  NUMBER
44 ,   p_end_index            IN  NUMBER
45 ,   p_grouping_method      IN  VARCHAR2
46 ) RETURN PO_TBL_NUMBER;
47 
48 END PO_AUTOCREATE_GROUPING_PVT;