APPS.QP_LIMITS_UTIL dependencies on QP_LIST_HEADERS_B

Line 22: UPDATE QP_LIST_HEADERS_B

18:
19: IF (p_LIMITS_rec.operation = QP_GLOBALS.g_opr_create) THEN
20:
21: IF p_LIMITS_rec.list_header_id IS NOT NULL THEN
22: UPDATE QP_LIST_HEADERS_B
23: SET LIMIT_EXISTS_FLAG = 'Y'
24: WHERE list_header_id = p_LIMITS_rec.list_header_id
25: and nvl(LIMIT_EXISTS_FLAG,'N') <> 'Y' ; --Bug no 6193752
26: l_updated := 1; --pattern

Line 43: FROM QP_LIST_HEADERS_B WHERE list_header_id = p_LIMITS_rec.list_header_id;

39: IF p_LIMITS_rec.list_header_id IS NOT NULL THEN
40:
41: l_dummy := 0;
42: SELECT COUNT(*) INTO l_dummy
43: FROM QP_LIST_HEADERS_B WHERE list_header_id = p_LIMITS_rec.list_header_id;
44:
45: IF l_dummy > 0 THEN -- LIST HEADER EXISTS THEN
46:
47: l_dummy1 := 0;

Line 52: UPDATE QP_LIST_HEADERS_B SET LIMIT_EXISTS_FLAG = 'N'

48: SELECT COUNT(*) INTO l_dummy1
49: FROM QP_LIMITS WHERE list_header_id = p_LIMITS_rec.list_header_id;
50:
51: IF l_dummy1 = 0 THEN
52: UPDATE QP_LIST_HEADERS_B SET LIMIT_EXISTS_FLAG = 'N'
53: WHERE list_header_id = p_LIMITS_rec.list_header_id
54: and nvl(LIMIT_EXISTS_FLAG,'Y') <> 'N' ; --Bug no 6193752
55: l_updated := 1; --pattern
56: ELSIF l_dummy1 > 0 THEN

Line 57: UPDATE QP_LIST_HEADERS_B SET LIMIT_EXISTS_FLAG = 'Y'

53: WHERE list_header_id = p_LIMITS_rec.list_header_id
54: and nvl(LIMIT_EXISTS_FLAG,'Y') <> 'N' ; --Bug no 6193752
55: l_updated := 1; --pattern
56: ELSIF l_dummy1 > 0 THEN
57: UPDATE QP_LIST_HEADERS_B SET LIMIT_EXISTS_FLAG = 'Y'
58: WHERE list_header_id = p_LIMITS_rec.list_header_id
59: and nvl(LIMIT_EXISTS_FLAG,'N') <> 'Y' ; --Bug no 6193752
60: l_updated := 1; --pattern
61: END IF;

Line 1164: FROM QP_LIST_HEADERS_B

1160: l_LIMITS_rec1 := Query_Row(p_LIMITS_rec.limit_id);
1161:
1162: SELECT active_flag
1163: INTO l_active_flag
1164: FROM QP_LIST_HEADERS_B
1165: WHERE list_header_id=p_LIMITS_rec.list_header_id;
1166:
1167: UPDATE QP_LIMITS
1168: SET AMOUNT = p_LIMITS_rec.amount

Line 1301: FROM QP_LIST_HEADERS_B

1297: BEGIN
1298: l_LIMITS_rec := p_LIMITS_rec;
1299: SELECT active_flag
1300: INTO l_active_flag
1301: FROM QP_LIST_HEADERS_B
1302: WHERE list_header_id=p_LIMITS_rec.list_header_id;
1303:
1304: INSERT INTO QP_LIMITS
1305: ( AMOUNT