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 1195: FROM QP_LIST_HEADERS_B

1191: l_LIMITS_rec1 := Query_Row(p_LIMITS_rec.limit_id);
1192:
1193: SELECT active_flag
1194: INTO l_active_flag
1195: FROM QP_LIST_HEADERS_B
1196: WHERE list_header_id=p_LIMITS_rec.list_header_id;
1197:
1198: UPDATE QP_LIMITS
1199: SET AMOUNT = p_LIMITS_rec.amount

Line 1332: FROM QP_LIST_HEADERS_B

1328: BEGIN
1329: l_LIMITS_rec := p_LIMITS_rec;
1330: SELECT active_flag
1331: INTO l_active_flag
1332: FROM QP_LIST_HEADERS_B
1333: WHERE list_header_id=p_LIMITS_rec.list_header_id;
1334:
1335: INSERT INTO QP_LIMITS
1336: ( AMOUNT