[Home] [Help]
PACKAGE: APPS.MSC_X_VMI_POREQ
Source
1 PACKAGE MSC_X_VMI_POREQ AUTHID CURRENT_USER AS
2 /* $Header: MSCXVMOS.pls 120.1 2011/08/11 11:21:38 vjuluri ship $ */
3
4 G_CREATE CONSTANT NUMBER := 1;
5 G_UPDATE CONSTANT NUMBER := 2;
6
7 G_SUCCESS CONSTANT NUMBER := 1;
8 G_ERROR CONSTANT NUMBER := 2;
9
10 SYS_YES CONSTANT NUMBER := 1;
11 SYS_NO CONSTANT NUMBER := 2;
12
13 PROCEDURE INITIALIZE
14 ( p_user_name IN VARCHAR2,
15 p_resp_name IN VARCHAR2,
16 p_application_name IN VARCHAR2);
17
18 PROCEDURE LD_PO_REQUISITIONS_INTERFACE1 (
19 p_user_name in varchar2,
20 p_application_name in varchar2,
21 p_resp_name in varchar2,
22 p_po_group_by_name in varchar2,
23 p_instance_id IN NUMBER,
24 p_instance_code IN VARCHAR2,
25 p_dblink IN VARCHAR2,
26 o_request_id out nocopy number);
27
28 PROCEDURE LD_PO_REQUISITIONS_INTERFACE2 (
29 p_user_name IN VARCHAR2,
30 p_po_group_by_name IN VARCHAR2);
31
32 PROCEDURE LD_SO_RELEASE_INTERFACE (
33 p_user_name IN VARCHAR2,
34 p_resp_name IN VARCHAR2,
35 p_application_name IN VARCHAR2,
36 p_release_id IN NUMBER,
37 p_instance_id IN NUMBER, -- bug 3436758
38 p_instance_code IN VARCHAR2,
39 p_a2m_dblink IN VARCHAR2,
40 o_status OUT nocopy NUMBER,
41 o_header_id OUT nocopy NUMBER,
42 o_line_id OUT nocopy NUMBER,
43 o_sales_order_number OUT nocopy NUMBER,
44 o_ship_from_org_id OUT nocopy NUMBER,
45 o_schedule_ship_date OUT nocopy DATE,
46 o_schedule_arriv_date OUT nocopy DATE,
47 o_schedule_date_change OUT nocopy NUMBER,
48 o_error_message OUT nocopy VARCHAR2);
49
50 PROCEDURE START_RELEASE_PROGRAM(
51 ERRBUF OUT NOCOPY VARCHAR2,
52 RETCODE OUT NOCOPY NUMBER,
53 p_user_name IN VARCHAR2,
54 p_resp_name IN VARCHAR2,
55 p_application_name IN VARCHAR2,
56 pItem_name IN VARCHAR2,
57 pCustomer_name IN VARCHAR2,
58 pCustomer_site_name IN VARCHAR2,
59 pItemtype IN VARCHAR2,
60 pItemkey IN VARCHAR2,
61 pRelease_Id IN NUMBER,
62 p_instance_id IN NUMBER,
63 p_instance_code IN VARCHAR2,
64 p_a2m_dblink IN VARCHAR2,
65 o_request_id OUT NOCOPY NUMBER);
66
67 PROCEDURE WAIT_FOR_REQUEST(
68 p_request_id IN NUMBER,
69 p_timeout IN NUMBER,
70 o_retcode OUT NOCOPY NUMBER);
71
72 END MSC_X_VMI_POREQ;