APPS.OKC_TERMS_TMPL_APPROVAL_PVT dependencies on OKC_XPRT_TEMPLATE_RULES

Line 992: -- Delete from okc_xprt_template_rules

988: last_update_login = FND_GLOBAL.LOGIN_ID
989: WHERE template_id= l_tmpl_id
990: AND question_rule_status = 'ACTIVE';
991:
992: -- Delete from okc_xprt_template_rules
993: DELETE FROM okc_xprt_template_rules
994: WHERE NVL(deleted_flag,'N') = 'Y'
995: AND template_id = l_tmpl_id;
996:

Line 993: DELETE FROM okc_xprt_template_rules

989: WHERE template_id= l_tmpl_id
990: AND question_rule_status = 'ACTIVE';
991:
992: -- Delete from okc_xprt_template_rules
993: DELETE FROM okc_xprt_template_rules
994: WHERE NVL(deleted_flag,'N') = 'Y'
995: AND template_id = l_tmpl_id;
996:
997: -- Update published_flag in okc_xprt_template_rules

Line 997: -- Update published_flag in okc_xprt_template_rules

993: DELETE FROM okc_xprt_template_rules
994: WHERE NVL(deleted_flag,'N') = 'Y'
995: AND template_id = l_tmpl_id;
996:
997: -- Update published_flag in okc_xprt_template_rules
998: UPDATE okc_xprt_template_rules
999: SET published_flag = 'Y'
1000: WHERE template_id= l_tmpl_id ;
1001:

Line 998: UPDATE okc_xprt_template_rules

994: WHERE NVL(deleted_flag,'N') = 'Y'
995: AND template_id = l_tmpl_id;
996:
997: -- Update published_flag in okc_xprt_template_rules
998: UPDATE okc_xprt_template_rules
999: SET published_flag = 'Y'
1000: WHERE template_id= l_tmpl_id ;
1001:
1002: