APPS.QP_LIMITS_UTIL dependencies on QP_LIST_LINES

Line 30: UPDATE QP_LIST_LINES

26: l_updated := 1; --pattern
27: END IF;
28:
29: IF p_LIMITS_rec.list_line_id IS NOT NULL THEN
30: UPDATE QP_LIST_LINES
31: SET LIMIT_EXISTS_FLAG = 'Y'
32: WHERE list_line_id = p_LIMITS_rec.list_line_id
33: and nvl(LIMIT_EXISTS_FLAG,'N') <> 'Y' ; --Bug no 6193752
34: l_updated := 2; --pattern

Line 71: FROM QP_LIST_LINES WHERE list_line_id = p_LIMITS_rec.list_line_id;

67: IF p_LIMITS_rec.list_line_id IS NOT NULL THEN
68:
69: l_dummy := 0;
70: SELECT COUNT(*) INTO l_dummy
71: FROM QP_LIST_LINES WHERE list_line_id = p_LIMITS_rec.list_line_id;
72:
73: IF l_dummy > 0 THEN -- LIST LINE EXISTS THEN
74:
75: l_dummy1 := 0;

Line 80: UPDATE QP_LIST_LINES SET LIMIT_EXISTS_FLAG = 'N'

76: SELECT COUNT(*) INTO l_dummy1
77: FROM QP_LIMITS WHERE list_line_id = p_LIMITS_rec.list_line_id;
78:
79: IF l_dummy1 = 0 THEN
80: UPDATE QP_LIST_LINES SET LIMIT_EXISTS_FLAG = 'N'
81: WHERE list_line_id = p_LIMITS_rec.list_line_id
82: and nvl(LIMIT_EXISTS_FLAG,'Y') <> 'N' ; --Bug no 6193752
83: l_updated := 2; --pattern
84: ELSIF l_dummy1 > 0 THEN

Line 85: UPDATE QP_LIST_LINES SET LIMIT_EXISTS_FLAG = 'Y'

81: WHERE list_line_id = p_LIMITS_rec.list_line_id
82: and nvl(LIMIT_EXISTS_FLAG,'Y') <> 'N' ; --Bug no 6193752
83: l_updated := 2; --pattern
84: ELSIF l_dummy1 > 0 THEN
85: UPDATE QP_LIST_LINES SET LIMIT_EXISTS_FLAG = 'Y'
86: WHERE list_line_id = p_LIMITS_rec.list_line_id
87: and nvl(LIMIT_EXISTS_FLAG,'N') <> 'Y' ; --Bug no 6193752
88: l_updated := 2; --pattern
89: END IF;