1 PACKAGE BODY INV_EXTATP_GRP AS
2 /* $Header: INVGEAPB.pls 120.2 2005/09/20 14:08:40 ichoudhu ship $ */
3
4 --
5 -- Package
6 -- INV_EXTATP_GRP
7 -- Purpose
8 -- External ATP. This function calls the external
9 -- procedure which will eventually contain the system integrator's
10 -- code, contained in INV_EXTATP_CALL.External_Atp
11 -- History
12 -- 07/01/97 rmanjuna created
13 -- 07/29/97 nsriniva added functions to support APS integration
14 -- 06/16/99 mpuvathi modifications to the routing cursor in Check_ATP_ATO
15 --
16 -- Note
17 -- 1. Convetion followed for return values of functions :
18 -- a. Success is 0
19 -- b. Failure is 1
20 -- c. Warning is 2
21
22 -- Variables used in this package
23 v_config_item_id NUMBER;
24 v_config_qty NUMBER;
25 v_config_item VARCHAR2(40);
26
27 FUNCTION Check_ATP_ATO(
28 row_id IN rowid,
29 ato_exists OUT NOCOPY VARCHAR2,
30 V_Bom_Table IN OUT NOCOPY INV_EXTATP_GRP.Bom_Tab_Typ,
31 V_Routing_Table IN OUT NOCOPY INV_EXTATP_GRP.Routing_Tab_Typ)
32 RETURN BOOLEAN
33 IS
34 BEGIN
35 return(TRUE);
36 END Check_ATP_ATO;
37
38 FUNCTION Call_ATP( group_id number,
39 insert_flag number,
40 partial_flag number,
41 mrp_status number,
42 schedule_flag number,
43 session_id number,
44 err_message IN OUT NOCOPY varchar2,
45 err_translate IN OUT NOCOPY number)
46 RETURN NUMBER is
47 BEGIN
48 return(INV_EXTATP_GRP.G_ALL_SUCCESS);
49 End Call_ATP;
50
51 END INV_EXTATP_GRP;