DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_WRAPPER dependencies on FND_INSTALLATION

Line 60: l_return_value := fnd_installation.get_app_info(

56: p_msg_level=>fnd_log.level_procedure);
57: END IF;
58:
59: --Get ar and apps schema name
60: l_return_value := fnd_installation.get_app_info(
61: 'AR', l_status, l_industry, l_ar_schema);
62:
63: IF NOT l_return_value THEN
64: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 67: l_return_value := fnd_installation.get_app_info(

63: IF NOT l_return_value THEN
64: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
65: END IF;
66:
67: l_return_value := fnd_installation.get_app_info(
68: 'FND', l_status, l_industry, l_aol_schema);
69:
70: IF NOT l_return_value THEN
71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 546: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_tmp,l_schema);

542: p_prefix=>'',
543: p_msg_level=>fnd_log.level_procedure);
544: END IF;
545:
546: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_tmp,l_schema);
547:
548: IF P_OPERATION = 'I' THEN
549: /* Increase increment for muti-table insert for parties */
550: execute immediate 'alter sequence ' || l_schema || '.hz_organization_profiles_s increment by 3';

Line 650: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_tmp,l_schema);

646: p_prefix=>'',
647: p_msg_level=>fnd_log.level_procedure);
648: END IF;
649:
650: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_tmp,l_schema);
651:
652: IF P_BATCH_MODE_FLAG = 'Y' THEN
653: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_PARTIES_SG TRUNCATE PARTITION batchpar DROP STORAGE';
654: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_ADDRESSES_SG TRUNCATE PARTITION batchpar DROP STORAGE';

Line 4634: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_tmp,l_schema);

4630: when others then
4631: est_count := null;
4632: end;
4633:
4634: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_tmp,l_schema);
4635:
4636: select num_rows into party_count
4637: from sys.dba_tables where upper(table_name) = 'HZ_IMP_PARTIES_INT'
4638: and owner = l_schema;