DBA Data[Home] [Help]

APPS.CN_TABLE_MAPS_PKG dependencies on CN_API

Line 151: x_object_version_number NUMBER := cn_api.G_MISS_NUM,

147: X_delete_flag cn_table_maps.delete_flag%TYPE,
148: X_last_update_date cn_table_maps.last_update_date%TYPE,
149: X_last_updated_by cn_table_maps.last_updated_by%TYPE,
150: X_last_update_login cn_table_maps.last_update_login%TYPE,
151: x_object_version_number NUMBER := cn_api.G_MISS_NUM,
152: x_org_id cn_table_maps.org_id%TYPE) IS
153:
154:
155: CURSOR l_ovn_csr IS

Line 168: SELECT DECODE(x_object_version_number, cn_api.G_MISS_NUM,

164: OPEN l_ovn_csr;
165: FETCH l_ovn_csr INTO l_ovn;
166: CLOSE l_ovn_csr;
167:
168: SELECT DECODE(x_object_version_number, cn_api.G_MISS_NUM,
169: l_ovn,x_object_version_number)
170: INTO l_ovn FROM dual;
171:
172: UPDATE cn_table_maps SET