APPS.PSP_SUM_TRANS dependencies on GL_JE_CATEGORIES

Line 1416: get_gl_je_categories(l_user_je_category_name,

1412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1413: END IF;
1414:
1415: -- get the category name
1416: get_gl_je_categories(l_user_je_category_name,
1417: l_return_status);
1418: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1420: END IF;

Line 1747: PROCEDURE get_gl_je_categories(P_USER_JE_CATEGORY_NAME OUT NOCOPY VARCHAR2,

1743: p_return_status := fnd_api.g_ret_sts_unexp_error;
1744: END;
1745:
1746: ---------------------- GET_GL_CATEGORIES --------------------------------------------------
1747: PROCEDURE get_gl_je_categories(P_USER_JE_CATEGORY_NAME OUT NOCOPY VARCHAR2,
1748: P_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
1749: l_error VARCHAR2(100);
1750: l_product VARCHAR2(3);
1751: BEGIN

Line 1754: FROM gl_je_categories

1750: l_product VARCHAR2(3);
1751: BEGIN
1752: SELECT user_je_category_name
1753: INTO p_user_je_category_name
1754: FROM gl_je_categories
1755: WHERE je_category_name = 'OLD';
1756: EXCEPTION
1757: WHEN NO_DATA_FOUND THEN
1758: l_error := 'JE CATEGORY = OLD';