1 PACKAGE MRP_SCATP_PUB AUTHID CURRENT_USER AS
2 /* $Header: MRPPATPS.pls 115.7 2003/02/06 22:16:21 ichoudhu ship $ */
3
4 PROCEDURE Insert_Line_MDI (
5 p_api_version IN NUMBER,
6 x_return_status OUT NOCOPY VARCHAR2,
7 x_msg_count OUT NOCOPY NUMBER,
8 x_msg_data OUT NOCOPY VARCHAR2,
9 p_line_id IN NUMBER,
10 p_assignment_set_id IN NUMBER,
11 p_atp_group_id IN OUT NOCOPY NUMBER,
12 x_session_id OUT NOCOPY NUMBER );
13
14 PROCEDURE Insert_Supply_Sources_MDI (
15 p_api_version IN NUMBER,
16 x_return_status OUT NOCOPY VARCHAR2,
17 x_msg_count OUT NOCOPY NUMBER,
18 x_msg_data OUT NOCOPY VARCHAR2,
19 p_atp_group_id IN NUMBER,
20 p_assignment_set_id IN NUMBER,
21 x_session_id OUT NOCOPY NUMBER );
22
23 PROCEDURE Uncheck (
24 p_api_version IN NUMBER,
25 x_return_status OUT NOCOPY VARCHAR2,
26 x_msg_count OUT NOCOPY NUMBER,
27 x_msg_data OUT NOCOPY VARCHAR2,
28 p_atp_group_id IN NUMBER );
29
30 PROCEDURE Insert_Res_MDI (
31 x_err_num OUT NOCOPY NUMBER,
32 x_err_msg OUT NOCOPY VARCHAR2,
33 p_atp_group_id IN NUMBER );
34
35 PROCEDURE Insert_Comp_MDI (
36 p_api_version IN NUMBER,
37 x_return_status OUT NOCOPY VARCHAR2,
38 x_msg_count OUT NOCOPY NUMBER,
39 x_msg_data OUT NOCOPY VARCHAR2,
40 p_atp_group_id IN NUMBER );
41
42 FUNCTION required_component(
43 p_top_bill_seq_id IN NUMBER,
44 p_plan_level IN NUMBER,
45 p_request_date IN DATE,
46 p_comp_seq_id IN NUMBER,
47 p_component_code IN VARCHAR2)
48 return NUMBER;
49
50 FUNCTION mtl_wip_supply_type(
51 p_top_bill_seq_id IN NUMBER,
52 p_comp_id IN NUMBER)
53 return NUMBER;
54
55 END MRP_SCATP_PUB;