PACKAGE BODY: APPS.GMILOTMP

Source

1 PACKAGE BODY GMILOTMP AS
2 /* $Header: gmilotcb.pls 115.0 2003/04/24 21:01:58 jdiiorio noship $ */
3 
4 
5 FUNCTION  GET_MAX_AUDIT (pconversion_id          IN NUMBER)
6 RETURN NUMBER
7 
8 IS
9 
10 CURSOR get_max   IS
11   SELECT max(conv_audit_id)
12   FROM   gmi_item_Conv_audit
13   WHERE  conversion_id = pconversion_id;
14 
15 x_max number;
16 
17 BEGIN
18  OPEN get_max;
19  FETCH get_max into x_max;
20  CLOSE get_max;
21  RETURN x_max;
22 
23 END GET_MAX_AUDIT;
24 
25 END GMILOTMP;