APPS.OZF_PROCESS_SETUP_PVT dependencies on OZF_PROCESS_SETUP_ALL

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);

Line 402: FROM ozf_process_setup_all

398: attribute13,
399: attribute14,
400: attribute15,
401: security_group_id
402: FROM ozf_process_setup_all
403: WHERE process_setup_id = cv_process_setup_id;
404:
405: CURSOR get_org
406: IS

Line 884: FROM ozf_process_setup_all

880: CURSOR csr_pro_setup_4stp(cv_supp_trade_profile_id NUMBER
881: ,cv_process_code VARCHAR2)
882: IS
883: SELECT COUNT(process_setup_id)
884: FROM ozf_process_setup_all
885: WHERE process_code = cv_process_code
886: AND supp_trade_profile_id = cv_supp_trade_profile_id ;
887:
888: CURSOR csr_pro_setup_4org(cv_process_code VARCHAR2,

Line 893: FROM ozf_process_setup_all

889: cv_org_id NUMBER
890: )
891: IS
892: SELECT COUNT(process_setup_id)
893: FROM ozf_process_setup_all
894: WHERE supp_trade_profile_id IS NULL
895: AND org_id = cv_org_id
896: AND process_code = cv_process_code ;
897: