DBA Data[Home] [Help]

APPS.OKI_DBI_LOAD_CLEB_PVT dependencies on FND_INSTALLATION

Line 215: IF (FND_INSTALLATION.GET_APP_INFO('OKI', l_status, l_industry, l_oki_schema)) THEN

211:
212: BEGIN
213: retcode := 0;
214:
215: IF (FND_INSTALLATION.GET_APP_INFO('OKI', l_status, l_industry, l_oki_schema)) THEN
216:
217: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema || '.OKI_DBI_CHR_STAGE_INC' ;
218: EXECUTE IMMEDIATE l_sql_string ;
219: rlog( 'Truncated Table OKI_DBI_CHR_STAGE_INC',2);

Line 1114: IF (FND_INSTALLATION.GET_APP_INFO(

1110: INTO l_batch_size
1111: FROM DUAL ;
1112:
1113: g_batch_size := l_batch_size;
1114: IF (FND_INSTALLATION.GET_APP_INFO(
1115: application_short_name => 'OKI'
1116: , status => l_status
1117: , industry => l_industry
1118: , oracle_schema => l_oki_schema )) THEN

Line 2130: IF (FND_INSTALLATION.GET_APP_INFO(

2126:
2127: BEGIN
2128:
2129: -- Delete the records from the last load from the delete table;
2130: IF (FND_INSTALLATION.GET_APP_INFO(
2131: application_short_name => 'OKI'
2132: , status => l_status
2133: , industry => l_industry
2134: , oracle_schema => l_oki_schema)) THEN

Line 5832: IF (FND_INSTALLATION.GET_APP_INFO(

5828: l_oki_schema VARCHAR2(30);
5829: l_status VARCHAR2(30);
5830: l_industry VARCHAR2(30);
5831: BEGIN
5832: IF (FND_INSTALLATION.GET_APP_INFO(
5833: application_short_name => 'OKI'
5834: , status => l_status
5835: , industry => l_industry
5836: , oracle_schema => l_oki_schema)) THEN