APPS.BNE_LCT_TOOLS_PKG dependencies on FND_APPLICATION

Line 4: function APP_ID_TO_ASN(X_APP_ID IN NUMBER) RETURN FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE

1: package body BNE_LCT_TOOLS_PKG as
2: /* $Header: bnelcttoolsb.pls 120.6 2005/12/07 16:09:24 dagroves noship $ */
3:
4: function APP_ID_TO_ASN(X_APP_ID IN NUMBER) RETURN FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE
5: is
6: V_ASN FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE;
7: begin
8: if X_APP_ID is null

Line 6: V_ASN FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE;

2: /* $Header: bnelcttoolsb.pls 120.6 2005/12/07 16:09:24 dagroves noship $ */
3:
4: function APP_ID_TO_ASN(X_APP_ID IN NUMBER) RETURN FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE
5: is
6: V_ASN FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE;
7: begin
8: if X_APP_ID is null
9: then
10: return(null);

Line 15: FROM FND_APPLICATION

11: end if;
12: --
13: SELECT APPLICATION_SHORT_NAME
14: INTO V_ASN
15: FROM FND_APPLICATION
16: WHERE APPLICATION_ID = X_APP_ID;
17: --
18: return(V_ASN);
19: exception

Line 24: function ASN_TO_APP_ID(X_ASN IN VARCHAR2) RETURN FND_APPLICATION.APPLICATION_ID%TYPE

20: when no_data_found then
21: raise_application_error(-20000, 'No Application is registered in Applications with an application id of '||to_char(X_APP_ID)||'.');
22: end APP_ID_TO_ASN;
23:
24: function ASN_TO_APP_ID(X_ASN IN VARCHAR2) RETURN FND_APPLICATION.APPLICATION_ID%TYPE
25: is
26: V_APP_ID FND_APPLICATION.APPLICATION_ID%TYPE;
27: begin
28: if X_ASN is null

Line 26: V_APP_ID FND_APPLICATION.APPLICATION_ID%TYPE;

22: end APP_ID_TO_ASN;
23:
24: function ASN_TO_APP_ID(X_ASN IN VARCHAR2) RETURN FND_APPLICATION.APPLICATION_ID%TYPE
25: is
26: V_APP_ID FND_APPLICATION.APPLICATION_ID%TYPE;
27: begin
28: if X_ASN is null
29: then
30: return(null);

Line 35: FROM FND_APPLICATION

31: end if;
32: --
33: SELECT APPLICATION_ID
34: INTO V_APP_ID
35: FROM FND_APPLICATION
36: WHERE APPLICATION_SHORT_NAME = X_ASN;
37: --
38: return(V_APP_ID);
39: exception