APPS.OZF_CODE_CONVERSION_PVT dependencies on OZF_CODE_CONVERSIONS

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

129: l_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID(); -- R12 Enhancements
130: ELSE
131: l_org_id := l_code_conversion_rec.org_id;
132: END IF;
133: SELECT ozf_code_conversions_all_s.nextval INTO l_code_conversion_id FROM DUAL;
134:
135: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
136: OZF_UTILITY_PVT.debug_message( 'l_org_id ' || l_org_id);
137: OZF_UTILITY_PVT.debug_message( 'Code Conversion ID '|| l_code_conversion_id);

Line 307: FROM ozf_code_conversions_all

303: attribute13,
304: attribute14,
305: attribute15,
306: security_group_id
307: FROM ozf_code_conversions_all
308: WHERE code_conversion_id = cv_code_conversion_id;
309:
310: CURSOR get_org
311: IS

Line 1656: FROM ozf_code_conversions

1652: , cv_start_date_active DATE
1653: , cv_end_date_active DATE)
1654: IS
1655: SELECT COUNT(party_id)
1656: FROM ozf_code_conversions
1657: WHERE party_id = cv_party_id
1658: AND UPPER(external_code) LIKE UPPER(cv_external_code)
1659: AND TRUNC(start_date_active) <= TRUNC(NVL(cv_start_date_active,SYSDATE))
1660: AND TRUNC(NVL(end_date_active,NVL(cv_end_date_active,SYSDATE)+1)) >= TRUNC(NVL(cv_end_date_active,SYSDATE))

Line 1670: FROM ozf_code_conversions

1666: ,cv_start_date_active DATE
1667: ,cv_end_date_active DATE)
1668: IS
1669: SELECT COUNT(cust_account_id)
1670: FROM ozf_code_conversions
1671: WHERE cust_account_id = cv_cust_account_id
1672: AND UPPER(external_code) LIKE UPPER(cv_external_code)
1673: AND TRUNC(start_date_active) <= TRUNC(NVL(cv_start_date_active,SYSDATE))
1674: AND TRUNC(NVL(end_date_active,NVL(cv_start_date_active,SYSDATE)+1)) >= TRUNC(NVL(cv_start_date_active,SYSDATE))

Line 1683: FROM ozf_code_conversions

1679: cv_end_date_active DATE
1680: )
1681: IS
1682: SELECT COUNT(external_code)
1683: FROM ozf_code_conversions
1684: WHERE UPPER(external_code) LIKE UPPER(cv_external_code)
1685: AND TRUNC(start_date_active) <= TRUNC(NVL(cv_start_date_active,SYSDATE))
1686: AND TRUNC(NVL(end_date_active,NVL(cv_start_date_active,SYSDATE)+1)) >= TRUNC(NVL(cv_start_date_active,SYSDATE))
1687: AND TRUNC(NVL(end_date_active,NVL(cv_end_date_active,SYSDATE)+1)) >= TRUNC(NVL(cv_end_date_active,SYSDATE))

Line 2124: FROM ozf_code_conversions

2120: , cv_external_code VARCHAR2
2121: , cv_conv_type varchar2 )
2122: IS
2123: SELECT internal_code
2124: FROM ozf_code_conversions
2125: WHERE cust_account_id = cv_cust_account_id
2126: AND UPPER(external_code) LIKE UPPER(cv_external_code)
2127: AND start_date_active <= SYSDATE
2128: AND (end_date_active >= SYSDATE

Line 2136: FROM ozf_code_conversions

2132: CURSOR csr_get_internal_code_Party( cv_party_Id NUMBER,
2133: cv_external_code VARCHAR2,
2134: cv_conv_type VARCHAR2 ) IS
2135: SELECT internal_code
2136: FROM ozf_code_conversions
2137: WHERE party_id = cv_party_id
2138: AND UPPER(external_code) LIKE UPPER(cv_external_code)
2139: AND start_date_active <= SYSDATE
2140: AND (end_date_active >= SYSDATE

Line 2148: FROM ozf_code_conversions

2144:
2145: CURSOR csr_get_internal_code( cv_external_code VARCHAR2,
2146: cv_conv_type VARCHAR2) IS
2147: SELECT internal_code
2148: FROM ozf_code_conversions
2149: WHERE UPPER(external_code) LIKE UPPER(cv_external_code)
2150: AND start_date_active <= SYSDATE
2151: AND (end_date_active >= SYSDATE
2152: or end_date_active IS NULL)