APPS.OKI_DBI_SCM_RSG_API_PVT dependencies on OKI_DBI_SCM_RSG_API_PVT

Line 1: PACKAGE BODY OKI_DBI_SCM_RSG_API_PVT AS

1: PACKAGE BODY OKI_DBI_SCM_RSG_API_PVT AS
2: /*$Header: OKIMVIMB.pls 120.2 2005/06/14 19:13:02 appldev $*/
3:
4: PROCEDURE Oki_Custom_Api(p_param IN OUT NOCOPY BIS_BIA_RSG_PARAMETER_TBL) IS
5:

Line 89: OKI_DBI_SCM_RSG_API_PVT.Drop_Index(p_obj_name,l_owner, p_retcode);

85: , industry => l_industry
86: , oracle_schema => l_owner)) THEN
87:
88: IF (p_mode = 'BEFORE') THEN
89: OKI_DBI_SCM_RSG_API_PVT.Drop_Index(p_obj_name,l_owner, p_retcode);
90: ELSIF (p_mode = 'AFTER') THEN
91: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Creating the column indexes at '|| FND_DATE.Date_To_DisplayDt(sysdate));
92: OKI_DBI_SCM_RSG_API_PVT.Create_Index(p_obj_name, l_owner, p_retcode);
93: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Finished creating the column indexes at '|| FND_DATE.Date_To_DisplayDt(sysdate));

Line 92: OKI_DBI_SCM_RSG_API_PVT.Create_Index(p_obj_name, l_owner, p_retcode);

88: IF (p_mode = 'BEFORE') THEN
89: OKI_DBI_SCM_RSG_API_PVT.Drop_Index(p_obj_name,l_owner, p_retcode);
90: ELSIF (p_mode = 'AFTER') THEN
91: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Creating the column indexes at '|| FND_DATE.Date_To_DisplayDt(sysdate));
92: OKI_DBI_SCM_RSG_API_PVT.Create_Index(p_obj_name, l_owner, p_retcode);
93: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Finished creating the column indexes at '|| FND_DATE.Date_To_DisplayDt(sysdate));
94: END IF;
95:
96: COMMIT;

Line 332: END; -- OKI_DBI_SCM_RSG_API_PVT

328: BIS_BIA_RSG_CUSTOM_API_MGMNT.Set_Param(p_param, BIS_BIA_RSG_CUSTOM_API_MGMNT.Para_Message, sqlerrm);
329: RAISE;
330:
331: END sleep;
332: END; -- OKI_DBI_SCM_RSG_API_PVT