DBA Data[Home] [Help]

APPS.OZF_PROCESS_SETUP_PVT dependencies on DUAL

Line 131: SELECT ozf_process_setup_all_s.nextval INTO l_process_setup_id FROM DUAL;

127: l_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID(); -- R12 Enhancements
128: ELSE
129: l_org_id := l_process_setup_rec.org_id;
130: END IF;
131: SELECT ozf_process_setup_all_s.nextval INTO l_process_setup_id FROM DUAL;
132:
133: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
134: OZF_UTILITY_PVT.debug_message( 'l_org_id ' || l_org_id);
135: OZF_UTILITY_PVT.debug_message( 'Process Setup ID '|| l_process_setup_id);

Line 236: SELECT ozf_process_setup_all_s.nextval INTO l_process_setup_id FROM DUAL;

232: OZF_UTILITY_PVT.debug_message('for p_process_setup_tbl(j).process_code'||'--'||process_code_tbl(i));
233: end if;
234: IF (flag = true) THEN
235:
236: SELECT ozf_process_setup_all_s.nextval INTO l_process_setup_id FROM DUAL;
237:
238: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
239: OZF_UTILITY_PVT.debug_message('l_process_setup_id and i '||i||l_process_setup_id);
240: OZF_UTILITY_PVT.debug_message('org_id and i '||i||l_org_id);