61: l_proc VARCHAR2(72) := g_package||'Chk_Training_Plan_Id';
62: l_status varchar2(30);
63: l_industry varchar2(30);
64: l_owner varchar2(30);
65: l_ret boolean := FND_INSTALLATION.GET_APP_INFO ('OTA', l_status,
66: l_industry, l_owner);
67: l_result VARCHAR2(255);
68:
69: l_stmt_chk_tpc_exist varchar2(32000) :=
122: l_proc VARCHAR2(72) := g_package||'Chk_Training_Plan_Member_Id';
123: l_status varchar2(30);
124: l_industry varchar2(30);
125: l_owner varchar2(30);
126: l_ret boolean := FND_INSTALLATION.GET_APP_INFO ('OTA', l_status,
127: l_industry, l_owner);
128:
129: l_result VARCHAR2(255);
130: -- dynamic sql statments to check if the training plan member table exists