DBA Data[Home] [Help]

APPS.PSP_SUM_ADJ dependencies on GL_JE_CATEGORIES

Line 1331: get_gl_je_categories(l_user_je_category_name,

1327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1328: END IF;
1329:
1330: -- get the category name
1331: get_gl_je_categories(l_user_je_category_name,
1332: l_return_status);
1333: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1335: END IF;

Line 1610: PROCEDURE get_gl_je_categories(P_USER_JE_CATEGORY_NAME OUT NOCOPY VARCHAR2,

1606: p_return_status := fnd_api.g_ret_sts_unexp_error;
1607: END;
1608:
1609: ---------------------- GET_GL_CATEGORIES --------------------------------------------------
1610: PROCEDURE get_gl_je_categories(P_USER_JE_CATEGORY_NAME OUT NOCOPY VARCHAR2,
1611: P_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
1612: -- Included the following cursor for bug fix 1765678
1613: CURSOR gl_je_category_cur IS
1614: SELECT user_je_category_name

Line 1615: FROM gl_je_categories

1611: P_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
1612: -- Included the following cursor for bug fix 1765678
1613: CURSOR gl_je_category_cur IS
1614: SELECT user_je_category_name
1615: FROM gl_je_categories
1616: WHERE je_category_name = 'OLD';
1617: l_error VARCHAR2(100);
1618: l_product VARCHAR2(3);
1619: BEGIN