26: BEGIN
27: BEGIN
28: SELECT nvl(freeze_flag, 'N')
29: INTO l_freeze_flag
30: FROM csi_install_parameters
31: WHERE rownum = 1;
32: IF l_freeze_flag = 'Y' THEN
33: return TRUE;
34: ELSE
52: BEGIN
53: BEGIN
54: SELECT nvl(freeze_flag, 'N')
55: INTO l_freeze_flag
56: FROM csi_install_parameters
57: WHERE rownum = 1;
58: IF l_freeze_flag = 'Y' THEN
59: return 'Y';
60: ELSE
424:
425: IF csi_datastructures_pub.g_install_param_rec.freeze_date is NULL then
426: SELECT freeze_date
427: INTO l_freeze_date
428: FROM csi_install_parameters
429: WHERE rownum = 1;
430: ELSE
431: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
432: END IF;
774: BEGIN
775:
776: SELECT freeze_date
777: INTO l_freeze_date
778: FROM csi_install_parameters
779: WHERE rownum = 1;
780:
781: FOR msg_rec in msg_cur(l_freeze_date)
782: LOOP