DBA Data[Home] [Help]

APPS.QP_CURR_DETAILS_UTIL dependencies on QP_CURRENCY_DETAILS

Line 1144: UPDATE QP_CURRENCY_DETAILS

1140: )
1141: IS
1142: BEGIN
1143:
1144: UPDATE QP_CURRENCY_DETAILS
1145: SET ATTRIBUTE1 = p_CURR_DETAILS_rec.attribute1
1146: , ATTRIBUTE10 = p_CURR_DETAILS_rec.attribute10
1147: , ATTRIBUTE11 = p_CURR_DETAILS_rec.attribute11
1148: , ATTRIBUTE12 = p_CURR_DETAILS_rec.attribute12

Line 1218: INSERT INTO QP_CURRENCY_DETAILS

1214: )
1215: IS
1216: BEGIN
1217:
1218: INSERT INTO QP_CURRENCY_DETAILS
1219: ( ATTRIBUTE1
1220: , ATTRIBUTE10
1221: , ATTRIBUTE11
1222: , ATTRIBUTE12

Line 1339: DELETE FROM QP_CURRENCY_DETAILS

1335: )
1336: IS
1337: BEGIN
1338:
1339: DELETE FROM QP_CURRENCY_DETAILS
1340: WHERE CURRENCY_DETAIL_ID = p_currency_detail_id
1341: ;
1342:
1343: EXCEPTION

Line 1434: FROM QP_CURRENCY_DETAILS

1430: , CURR_ATTRIBUTE_CONTEXT
1431: , CURR_ATTRIBUTE
1432: , CURR_ATTRIBUTE_VALUE
1433: , PRECEDENCE
1434: FROM QP_CURRENCY_DETAILS
1435: WHERE ( CURRENCY_DETAIL_ID = p_currency_detail_id
1436: )
1437: OR ( CURRENCY_HEADER_ID = p_currency_header_id
1438: );

Line 1662: FROM QP_CURRENCY_DETAILS

1658: , l_CURR_DETAILS_rec.curr_attribute_context
1659: , l_CURR_DETAILS_rec.curr_attribute
1660: , l_CURR_DETAILS_rec.curr_attribute_value
1661: , l_CURR_DETAILS_rec.precedence
1662: FROM QP_CURRENCY_DETAILS
1663: WHERE CURRENCY_DETAIL_ID = p_CURR_DETAILS_rec.currency_detail_id
1664: FOR UPDATE NOWAIT;
1665:
1666: -- Row locked. Compare IN attributes to DB attributes.