DBA Data[Home] [Help]

APPS.BIM_FUND_FACTS dependencies on BIM_R_FUND_WEEKLY_FACTS_S

Line 2216: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 1000';

2212: l_table_name :='bim_r_fund_weekly_facts';
2213: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
2214: fnd_message.set_token('table_name', l_table_name, FALSE);
2215: fnd_file.put_line(fnd_file.log,fnd_message.get);
2216: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 1000';
2217: INSERT /*+ append parallel(fwf,p_para_num) */ INTO bim_r_fund_weekly_facts fwf(
2218: fund_transaction_id
2219: ,creation_date
2220: ,last_update_date

Line 2251: bim_r_fund_weekly_facts_s.nextval

2247: ,fis_qtr
2248: ,fis_year
2249: ,business_unit_id)
2250: SELECT /*+ parallel(inner, p_para_num) */
2251: bim_r_fund_weekly_facts_s.nextval
2252: ,sysdate
2253: ,sysdate
2254: ,l_user_id
2255: ,l_user_id

Line 2325: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 20';

2321: ,status
2322: ,original_budget
2323: ,currency_code_fc) inner;
2324: EXECUTE IMMEDIATE 'commit';
2325: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 20';
2326: EXCEPTION
2327: WHEN others THEN
2328: FND_FILE.put_line(fnd_file.log,'Error insertg fund weekly:'||sqlerrm(sqlcode));
2329: -- dbms_output.put_line('Errorin inserting fund weekly:'||sqlerrm(sqlcode));

Line 2330: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 20';

2326: EXCEPTION
2327: WHEN others THEN
2328: FND_FILE.put_line(fnd_file.log,'Error insertg fund weekly:'||sqlerrm(sqlcode));
2329: -- dbms_output.put_line('Errorin inserting fund weekly:'||sqlerrm(sqlcode));
2330: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 20';
2331: x_return_status := FND_API.G_RET_STS_ERROR;
2332: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
2333: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
2334: FND_MSG_PUB.Add;

Line 4125: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 1000';

4121: l_table_name :='bim_r_fund_weekly_facts';
4122: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
4123: fnd_message.set_token('table_name', l_table_name, FALSE);
4124: fnd_file.put_line(fnd_file.log,fnd_message.get);
4125: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 1000';
4126: INSERT /*+ append parallel(fwf,p_para_num) */ INTO bim_r_fund_weekly_facts fwf(
4127: fund_transaction_id
4128: ,creation_date
4129: ,last_update_date

Line 4160: bim_r_fund_weekly_facts_s.nextval

4156: ,fis_qtr
4157: ,fis_year
4158: ,business_unit_id)
4159: SELECT /*+ parallel(inner, p_para_num) */
4160: bim_r_fund_weekly_facts_s.nextval
4161: ,sysdate
4162: ,sysdate
4163: ,l_user_id
4164: ,l_user_id

Line 4234: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 20';

4230: ,status
4231: ,original_budget
4232: ,currency_code_fc) inner;
4233: EXECUTE IMMEDIATE 'commit';
4234: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 20';
4235: EXCEPTION
4236: WHEN others THEN
4237: FND_FILE.put_line(fnd_file.log,'Error insertg fund weekly:'||sqlerrm(sqlcode));
4238: --dbms_output.put_line('Errorin inserting fund weekly:'||sqlerrm(sqlcode));

Line 4239: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 20';

4235: EXCEPTION
4236: WHEN others THEN
4237: FND_FILE.put_line(fnd_file.log,'Error insertg fund weekly:'||sqlerrm(sqlcode));
4238: --dbms_output.put_line('Errorin inserting fund weekly:'||sqlerrm(sqlcode));
4239: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 20';
4240: x_return_status := FND_API.G_RET_STS_ERROR;
4241: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
4242: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
4243: FND_MSG_PUB.Add;