DBA Data[Home] [Help]

APPS.OZF_RESALE_LOGS_PKG dependencies on OZF_RESALE_COMMON_PVT

Line 61: OPEN OZF_RESALE_COMMON_PVT.g_resale_batch_org_id_csr(p_resale_id);

57: INTO px_org_id
58: FROM DUAL;
59: END IF; */
60: IF (px_org_id IS NULL) THEN
61: OPEN OZF_RESALE_COMMON_PVT.g_resale_batch_org_id_csr(p_resale_id);
62: FETCH OZF_RESALE_COMMON_PVT.g_resale_batch_org_id_csr INTO l_batch_org_id;
63: CLOSE OZF_RESALE_COMMON_PVT.g_resale_batch_org_id_csr;
64: px_org_id := MO_GLOBAL.get_valid_org(l_batch_org_id);
65: IF (l_batch_org_id IS NULL OR px_org_id IS NULL) THEN

Line 62: FETCH OZF_RESALE_COMMON_PVT.g_resale_batch_org_id_csr INTO l_batch_org_id;

58: FROM DUAL;
59: END IF; */
60: IF (px_org_id IS NULL) THEN
61: OPEN OZF_RESALE_COMMON_PVT.g_resale_batch_org_id_csr(p_resale_id);
62: FETCH OZF_RESALE_COMMON_PVT.g_resale_batch_org_id_csr INTO l_batch_org_id;
63: CLOSE OZF_RESALE_COMMON_PVT.g_resale_batch_org_id_csr;
64: px_org_id := MO_GLOBAL.get_valid_org(l_batch_org_id);
65: IF (l_batch_org_id IS NULL OR px_org_id IS NULL) THEN
66: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_ORG_ID_NOTFOUND');

Line 63: CLOSE OZF_RESALE_COMMON_PVT.g_resale_batch_org_id_csr;

59: END IF; */
60: IF (px_org_id IS NULL) THEN
61: OPEN OZF_RESALE_COMMON_PVT.g_resale_batch_org_id_csr(p_resale_id);
62: FETCH OZF_RESALE_COMMON_PVT.g_resale_batch_org_id_csr INTO l_batch_org_id;
63: CLOSE OZF_RESALE_COMMON_PVT.g_resale_batch_org_id_csr;
64: px_org_id := MO_GLOBAL.get_valid_org(l_batch_org_id);
65: IF (l_batch_org_id IS NULL OR px_org_id IS NULL) THEN
66: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_ORG_ID_NOTFOUND');
67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;