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.OZF_CODE_CONVERSION_PVT dependencies on OZF_CODE_CONVERSIONS

Line 146: SELECT ozf_code_conversions_all_s.nextval INTO l_code_conversion_id FROM DUAL;

142:
143: l_org_id := l_code_conversion_rec.org_id;
144:
145:
146: SELECT ozf_code_conversions_all_s.nextval INTO l_code_conversion_id FROM DUAL;
147:
148: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
149: OZF_UTILITY_PVT.debug_message( 'l_org_id ' || l_org_id);
150: OZF_UTILITY_PVT.debug_message( 'Code Conversion ID '|| l_code_conversion_id);

Line 320: FROM ozf_code_conversions_all

316: attribute13,
317: attribute14,
318: attribute15,
319: security_group_id
320: FROM ozf_code_conversions_all
321: WHERE code_conversion_id = cv_code_conversion_id;
322:
323: CURSOR get_org
324: IS

Line 1671: FROM ozf_code_conversions

1667: , cv_code_conversion_type VARCHAR2
1668: , cv_org_id NUMBER)
1669: IS
1670: SELECT COUNT(party_id)
1671: FROM ozf_code_conversions
1672: WHERE party_id = cv_party_id
1673: AND code_conversion_type = cv_code_conversion_type -- Bug#11906081
1674: AND org_id = NVL(cv_org_id,0)
1675: AND UPPER(external_code) LIKE UPPER(cv_external_code)

Line 1689: FROM ozf_code_conversions

1685: ,cv_code_conversion_type VARCHAR2
1686: ,cv_org_id NUMBER)
1687: IS
1688: SELECT COUNT(cust_account_id)
1689: FROM ozf_code_conversions
1690: WHERE cust_account_id = cv_cust_account_id
1691: AND code_conversion_type = cv_code_conversion_type -- Bug#11906081
1692: AND org_id = NVL(cv_org_id,0)
1693: AND UPPER(external_code) LIKE UPPER(cv_external_code)

Line 1705: FROM ozf_code_conversions

1701: cv_code_conversion_type VARCHAR2,
1702: cv_org_id NUMBER)
1703: IS
1704: SELECT COUNT(external_code)
1705: FROM ozf_code_conversions
1706: WHERE UPPER(external_code) LIKE UPPER(cv_external_code)
1707: AND code_conversion_type = cv_code_conversion_type -- Bug#11906081
1708: AND org_id = NVL(cv_org_id,0)
1709: AND TRUNC(start_date_active) <= TRUNC(NVL(cv_start_date_active,SYSDATE))

Line 2155: FROM ozf_code_conversions

2151: , cv_external_code VARCHAR2
2152: , cv_conv_type varchar2 )
2153: IS
2154: SELECT internal_code
2155: FROM ozf_code_conversions
2156: WHERE cust_account_id = cv_cust_account_id
2157: AND UPPER(external_code) LIKE UPPER(cv_external_code)
2158: AND start_date_active <= SYSDATE
2159: AND (end_date_active >= SYSDATE

Line 2167: FROM ozf_code_conversions

2163: CURSOR csr_get_internal_code_Party( cv_party_Id NUMBER,
2164: cv_external_code VARCHAR2,
2165: cv_conv_type VARCHAR2 ) IS
2166: SELECT internal_code
2167: FROM ozf_code_conversions
2168: WHERE party_id = cv_party_id
2169: AND UPPER(external_code) LIKE UPPER(cv_external_code)
2170: AND start_date_active <= SYSDATE
2171: AND (end_date_active >= SYSDATE

Line 2179: FROM ozf_code_conversions

2175:
2176: CURSOR csr_get_internal_code( cv_external_code VARCHAR2,
2177: cv_conv_type VARCHAR2) IS
2178: SELECT internal_code
2179: FROM ozf_code_conversions
2180: WHERE UPPER(external_code) LIKE UPPER(cv_external_code)
2181: AND start_date_active <= SYSDATE
2182: AND (end_date_active >= SYSDATE
2183: or end_date_active IS NULL)