1 PACKAGE PO_PDOI_GRP AS
2 /* $Header: PO_PDOI_GRP.pls 120.4 2005/09/20 17:42 bao noship $ */
3
4 PROCEDURE start_process
5 ( p_api_version IN NUMBER,
6 p_init_msg_list IN VARCHAR2,
7 p_validation_level IN NUMBER,
8 p_commit IN VARCHAR2,
9 x_return_status OUT NOCOPY VARCHAR2,
10 p_gather_intf_tbl_stat IN VARCHAR2,
11 p_calling_module IN VARCHAR2,
12 p_selected_batch_id IN NUMBER,
13 p_batch_size IN NUMBER,
14 p_buyer_id IN NUMBER,
15 p_document_type IN VARCHAR2,
16 p_document_subtype IN VARCHAR2,
17 p_create_items IN VARCHAR2,
18 p_create_sourcing_rules_flag IN VARCHAR2,
19 p_rel_gen_method IN VARCHAR2,
20 p_sourcing_level IN VARCHAR2,
21 p_sourcing_inv_org_id IN NUMBER,
22 p_approved_status IN VARCHAR2,
23 p_process_code IN VARCHAR2,
24 p_interface_header_id IN NUMBER,
25 p_org_id IN NUMBER,
26 p_ga_flag IN VARCHAR2
27 );
28
29
30 PROCEDURE catalog_upload
31 ( p_api_version IN NUMBER,
32 p_init_msg_list IN VARCHAR2,
33 p_validation_level IN NUMBER,
34 p_commit IN VARCHAR2,
35 x_return_status OUT NOCOPY VARCHAR2,
36 x_error_message OUT NOCOPY VARCHAR2,
37 p_gather_intf_tbl_stat IN VARCHAR2,
38 p_selected_batch_id IN NUMBER,
39 p_batch_size IN NUMBER,
40 p_buyer_id IN NUMBER,
41 p_document_type IN VARCHAR2,
42 p_document_subtype IN VARCHAR2,
43 p_create_items IN VARCHAR2,
44 p_create_sourcing_rules_flag IN VARCHAR2,
45 p_rel_gen_method IN VARCHAR2,
46 p_sourcing_level IN VARCHAR2,
47 p_sourcing_inv_org_id IN NUMBER,
48 p_approved_status IN VARCHAR2,
49 p_process_code IN VARCHAR2,
50 p_interface_header_id IN NUMBER,
51 p_org_id IN NUMBER,
52 p_ga_flag IN VARCHAR2,
53 p_submit_dft_flag IN VARCHAR2,
54 p_role IN VARCHAR2,
55 p_catalog_to_expire IN VARCHAR2,
56 p_err_lines_tolerance IN NUMBER,
57 x_processed_lines_count OUT NOCOPY NUMBER,
58 x_rejected_lines_count OUT NOCOPY NUMBER,
59 x_err_tolerance_exceeded OUT NOCOPY VARCHAR2
60 );
61
62 PROCEDURE handle_price_tolerance_resp
63 ( p_api_version IN NUMBER,
64 p_init_msg_list IN VARCHAR2,
65 p_validation_level IN NUMBER,
66 p_commit IN VARCHAR2,
67 x_return_status OUT NOCOPY VARCHAR2,
68 p_selected_batch_id IN NUMBER,
69 p_document_type IN VARCHAR2,
70 p_document_subtype IN VARCHAR2,
71 p_interface_header_id IN NUMBER,
72 p_org_id IN NUMBER
73 );
74
75
76 END PO_PDOI_GRP;