APPS.IEM_ROUTE_RUN_PROC_PVT dependencies on IEM_ROUTE_RUN_PROC_PVT

Line 1: PACKAGE BODY IEM_ROUTE_RUN_PROC_PVT AS

1: PACKAGE BODY IEM_ROUTE_RUN_PROC_PVT AS
2: /* $Header: iemvrunb.pls 120.1 2005/06/23 18:18:04 appldev noship $ */
3: --
4: --
5: -- Purpose: Assistant api to dynamically run procedure.

Line 19: G_PKG_NAME CONSTANT varchar2(30) :='IEM_ROUTE_RUN_PROC_PVT ';

15: -- Liang Xia 11/16/2004 Fixed bug 3982076 procedure name 'test' validation
16: -- Liang Xia 04/06/2005 Fixed GSCC sql.46 ( bug 4256769 )
17: -- --------- ------ ------------------------------------------
18:
19: G_PKG_NAME CONSTANT varchar2(30) :='IEM_ROUTE_RUN_PROC_PVT ';
20:
21: G_created_updated_by NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
22:
23: G_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID') ) ;

Line 326: IEM_ROUTE_RUN_PROC_PVT.validProcedure(

322:
323:
324: IF l_proc_name is NOT NULL THEN
325:
326: IEM_ROUTE_RUN_PROC_PVT.validProcedure(
327: p_api_version_number => P_Api_Version_Number,
328: p_init_msg_list => FND_API.G_FALSE,
329: p_commit => P_Commit,
330: p_ProcName => l_proc_name,

Line 356: l_ProcCall := 'Begin '|| l_proc_name || '(IEM_ROUTE_RUN_PROC_PVT.G_key_value, :' ||l_para_out_name||'); END;';

352: if v_ArgumentName(6) is not null then
353: l_para_out_name := v_ArgumentName(6);
354: end if;
355:
356: l_ProcCall := 'Begin '|| l_proc_name || '(IEM_ROUTE_RUN_PROC_PVT.G_key_value, :' ||l_para_out_name||'); END;';
357: -- l_ProcCall := 'Begin '|| l_proc_name || '(IEM_TAG_RUN_PROC_PVT.G_key_value, :l_para_out_name); END;';
358: -- execute immediate l_ProcCall using OUT l_result;
359:
360: --l_str :='begin api_adm.GetPassword'||G_ADMIN_LINK||'(:a_user,:b_domain,:c_password);end;';

Line 559: END IEM_ROUTE_RUN_PROC_PVT;

555: null;
556: end;
557:
558:
559: END IEM_ROUTE_RUN_PROC_PVT;