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,
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
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
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
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;