APPS.QP_CURR_LISTS_UTIL dependencies on QP_CURRENCY_LISTS_B

Line 921: UPDATE QP_CURRENCY_LISTS_B

917: -- oe_debug_pub.add('Base base_markup_operator=' || p_CURR_LISTS_rec.base_markup_operator);
918: -- oe_debug_pub.add('Base base_markup_formula=' || p_CURR_LISTS_rec.base_markup_formula_id);
919:
920:
921: UPDATE QP_CURRENCY_LISTS_B
922: SET ATTRIBUTE1 = p_CURR_LISTS_rec.attribute1
923: , ATTRIBUTE10 = p_CURR_LISTS_rec.attribute10
924: , ATTRIBUTE11 = p_CURR_LISTS_rec.attribute11
925: , ATTRIBUTE12 = p_CURR_LISTS_rec.attribute12

Line 1180: INSERT INTO QP_CURRENCY_LISTS_B

1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1177:
1178: End;
1179:
1180: INSERT INTO QP_CURRENCY_LISTS_B
1181: ( ATTRIBUTE1
1182: , ATTRIBUTE10
1183: , ATTRIBUTE11
1184: , ATTRIBUTE12

Line 1265: DELETE FROM QP_CURRENCY_LISTS_B

1261: )
1262: IS
1263: BEGIN
1264:
1265: DELETE FROM QP_CURRENCY_LISTS_B
1266: WHERE CURRENCY_HEADER_ID = p_currency_header_id
1267: ;
1268:
1269: -- Added by Sunil

Line 1359: FROM QP_CURRENCY_LISTS_B

1355: , l_CURR_LISTS_rec.program_update_date
1356: , l_CURR_LISTS_rec.request_id
1357: --, l_CURR_LISTS_rec.row_id
1358: --FROM QP_CURRENCY_LISTS_VL
1359: FROM QP_CURRENCY_LISTS_B
1360: WHERE CURRENCY_HEADER_ID = p_currency_header_id
1361: ;
1362:
1363: -- Added by Sunil

Line 1483: FROM QP_CURRENCY_LISTS_B

1479: , l_CURR_LISTS_rec.program_update_date
1480: , l_CURR_LISTS_rec.request_id
1481: -- , l_CURR_LISTS_rec.row_id
1482: -- FROM QP_CURRENCY_LISTS_VL
1483: FROM QP_CURRENCY_LISTS_B
1484: WHERE CURRENCY_HEADER_ID = p_CURR_LISTS_rec.currency_header_id
1485: FOR UPDATE NOWAIT;
1486:
1487: -- Added by Sunil