1 PACKAGE PO_PDOI_GRP AUTHID CURRENT_USER AS
2 /* $Header: PO_PDOI_GRP.pls 120.4.12020000.4 2013/02/10 21:24:23 vegajula ship $ */
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 p_clm_flag IN VARCHAR2 DEFAULT 'N' --CLM PDOI Project
28 );
29
30
31 PROCEDURE catalog_upload
32 ( p_api_version IN NUMBER,
33 p_init_msg_list IN VARCHAR2,
34 p_validation_level IN NUMBER,
35 p_commit IN VARCHAR2,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_error_message OUT NOCOPY VARCHAR2,
38 p_gather_intf_tbl_stat IN VARCHAR2,
39 p_selected_batch_id IN NUMBER,
40 p_batch_size IN NUMBER,
41 p_buyer_id IN NUMBER,
42 p_document_type IN VARCHAR2,
43 p_document_subtype IN VARCHAR2,
44 p_create_items IN VARCHAR2,
45 p_create_sourcing_rules_flag IN VARCHAR2,
46 p_rel_gen_method IN VARCHAR2,
47 p_sourcing_level IN VARCHAR2,
48 p_sourcing_inv_org_id IN NUMBER,
49 p_approved_status IN VARCHAR2,
50 p_process_code IN VARCHAR2,
51 p_interface_header_id IN NUMBER,
52 p_org_id IN NUMBER,
53 p_ga_flag IN VARCHAR2,
54 p_submit_dft_flag IN VARCHAR2,
55 p_role IN VARCHAR2,
56 p_catalog_to_expire IN VARCHAR2,
57 p_err_lines_tolerance IN NUMBER,
58 x_processed_lines_count OUT NOCOPY NUMBER,
59 x_rejected_lines_count OUT NOCOPY NUMBER,
60 x_err_tolerance_exceeded OUT NOCOPY VARCHAR2,
61 p_clm_flag IN VARCHAR2 DEFAULT 'N' --<Bug 14465697>
62 );
63
64 PROCEDURE handle_price_tolerance_resp
65 ( p_api_version IN NUMBER,
66 p_init_msg_list IN VARCHAR2,
67 p_validation_level IN NUMBER,
68 p_commit IN VARCHAR2,
69 x_return_status OUT NOCOPY VARCHAR2,
70 p_selected_batch_id IN NUMBER,
71 p_document_type IN VARCHAR2,
72 p_document_subtype IN VARCHAR2,
73 p_interface_header_id IN NUMBER,
74 p_org_id IN NUMBER,
75 p_clm_flag IN VARCHAR2 DEFAULT 'N' --<Bug 14465697>
76 );
77
78
79 END PO_PDOI_GRP;