eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_CURR_LISTS_UTIL dependencies on QP_CURRENCY_DETAILS

Line 462: Update QP_CURRENCY_DETAILS

458: IF p_old_CURR_LISTS_rec.base_currency_code <> FND_API.G_MISS_CHAR
459: THEN
460:
461: -- Update details record's to_currency_code with new base_currency_code
462: Update QP_CURRENCY_DETAILS
463: Set to_currency_code = p_CURR_LISTS_rec.base_currency_code
464: Where to_currency_code = p_old_CURR_LISTS_rec.base_currency_code
465: And currency_header_id = p_old_CURR_LISTS_rec.currency_header_id;
466:

Line 468: Delete from QP_CURRENCY_DETAILS

464: Where to_currency_code = p_old_CURR_LISTS_rec.base_currency_code
465: And currency_header_id = p_old_CURR_LISTS_rec.currency_header_id;
466:
467: -- Delete detail record having to_currecny = new.base_currency and conversion_type<>NULL
468: Delete from QP_CURRENCY_DETAILS
469: Where to_currency_code = p_CURR_LISTS_rec.base_currency_code
470: And currency_header_id = p_old_CURR_LISTS_rec.currency_header_id
471: -- And conversion_method is NOT NULL;
472: And conversion_type is NOT NULL;

Line 968: update QP_CURRENCY_DETAILS set

964:
965: -- oe_debug_pub.add('After Update of TL');
966:
967: -- Added by Sunil Pandey 10/01/01
968: update QP_CURRENCY_DETAILS set
969: selling_rounding_factor = p_CURR_LISTS_rec.base_rounding_factor
970: , markup_operator = p_CURR_LISTS_rec.base_markup_operator
971: , markup_value = p_CURR_LISTS_rec.base_markup_value
972: , markup_formula_id = p_CURR_LISTS_rec.base_markup_formula_id

Line 1017: INSERT INTO QP_CURRENCY_DETAILS

1013: -- oe_debug_pub.add('Base base_markup_formula=' || p_CURR_LISTS_rec.base_markup_formula_id);
1014:
1015: -- Added by Sunil Pandey 10/01/01
1016: Begin
1017: INSERT INTO QP_CURRENCY_DETAILS
1018: ( ATTRIBUTE1
1019: , ATTRIBUTE10
1020: , ATTRIBUTE11
1021: , ATTRIBUTE12

Line 1087: , QP_CURRENCY_DETAILS_S.nextval

1083: -- , NULL -- p_CURR_DETAILS_rec.conversion_method
1084: , NULL -- p_CURR_DETAILS_rec.conversion_type
1085: , p_CURR_LISTS_rec.created_by
1086: , p_CURR_LISTS_rec.creation_date
1087: , QP_CURRENCY_DETAILS_S.nextval
1088: , p_CURR_LISTS_rec.currency_header_id
1089: , NULL -- p_CURR_DETAILS_rec.end_date_active
1090: , NULL -- p_CURR_DETAILS_rec.fixed_value
1091: , p_CURR_LISTS_rec.last_updated_by

Line 1383: FROM QP_CURRENCY_DETAILS

1379: INTO l_CURR_LISTS_rec.base_rounding_factor
1380: , l_CURR_LISTS_rec.base_markup_value
1381: , l_CURR_LISTS_rec.base_markup_operator
1382: , l_CURR_LISTS_rec.base_markup_formula_id
1383: FROM QP_CURRENCY_DETAILS
1384: WHERE CURRENCY_HEADER_ID = p_currency_header_id
1385: AND CONVERSION_TYPE IS NULL
1386: AND TO_CURRENCY_CODE = l_CURR_LISTS_rec.base_currency_code;
1387:

Line 1388: -- oe_debug_pub.add('After Select of QP_CURRENCY_DETAILS');

1384: WHERE CURRENCY_HEADER_ID = p_currency_header_id
1385: AND CONVERSION_TYPE IS NULL
1386: AND TO_CURRENCY_CODE = l_CURR_LISTS_rec.base_currency_code;
1387:
1388: -- oe_debug_pub.add('After Select of QP_CURRENCY_DETAILS');
1389:
1390:
1391: RETURN l_CURR_LISTS_rec;
1392:

Line 1505: FROM QP_CURRENCY_DETAILS

1501: INTO l_CURR_LISTS_rec.base_rounding_factor
1502: , l_CURR_LISTS_rec.base_markup_operator
1503: , l_CURR_LISTS_rec.base_markup_value
1504: , l_CURR_LISTS_rec.base_markup_formula_id
1505: FROM QP_CURRENCY_DETAILS
1506: WHERE CURRENCY_HEADER_ID = p_CURR_LISTS_rec.CURRENCY_HEADER_ID
1507: AND TO_CURRENCY_CODE = p_CURR_LISTS_rec.BASE_CURRENCY_CODE;
1508: -- FOR UPDATE NOWAIT;
1509: