APPS.CST_PERIODSUMMARY_PVT dependencies on ORG_ACCT_PERIODS

Line 80: FROM org_acct_periods

76:
77: l_stmt_num := 22;
78: SELECT schedule_close_date
79: INTO l_sched_close_date
80: FROM org_acct_periods
81: WHERE acct_period_id = p_period_id;
82:
83: l_stmt_num := 24;
84: SELECT legal_entity

Line 184: UPDATE org_acct_periods

180: l_untransferred_table := 'WIP_TRANSACTION_ACCOUNTS';
181: RAISE l_untransferred_dist;
182: END IF;
183:
184: UPDATE org_acct_periods
185: SET summarized_flag = 'N',
186: open_flag = 'N'
187: WHERE organization_id = p_org_id
188: AND acct_period_id = p_period_id;

Line 257: UPDATE org_acct_periods

253: END IF;
254: END IF;
255: ELSE
256: l_stmt_num := 60;
257: UPDATE org_acct_periods
258: SET open_flag = 'Y'
259: WHERE organization_id = p_org_id
260: AND acct_period_id = p_period_id;
261: l_message := 'Transfer to GL (request_id '||p_request_id||') completed with error';

Line 274: UPDATE org_acct_periods

270: WHEN l_unprocessed_txn THEN
271: ROLLBACK TO WaitOn_Request_PVT;
272: l_message := 'There exist(s) '|| l_count || ' unprocessed transaction(s) in ' || l_unprocessed_table;
273: FND_FILE.put_line(FND_FILE.LOG,l_message);
274: UPDATE org_acct_periods
275: SET open_flag = 'Y'
276: WHERE organization_id = p_org_id
277: AND acct_period_id = p_period_id;
278: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);

Line 283: UPDATE org_acct_periods

279: WHEN l_untransferred_dist THEN
280: ROLLBACK TO WaitOn_Request_PVT;
281: l_message := 'There exist(s) '|| l_count || ' untransferred distribution(s) in ' || l_untransferred_table;
282: FND_FILE.put_line(FND_FILE.LOG,l_message);
283: UPDATE org_acct_periods
284: SET open_flag = 'Y'
285: WHERE organization_id = p_org_id
286: AND acct_period_id = p_period_id;
287: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);