APPS.PSP_SUM_TRANS dependencies on GL_JE_CATEGORIES

Line 1330: get_gl_je_categories(l_user_je_category_name,

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

Line 1641: PROCEDURE get_gl_je_categories(P_USER_JE_CATEGORY_NAME OUT NOCOPY VARCHAR2,

1637: p_return_status := fnd_api.g_ret_sts_unexp_error;
1638: END;
1639:
1640: ---------------------- GET_GL_CATEGORIES --------------------------------------------------
1641: PROCEDURE get_gl_je_categories(P_USER_JE_CATEGORY_NAME OUT NOCOPY VARCHAR2,
1642: P_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
1643: l_error VARCHAR2(100);
1644: l_product VARCHAR2(3);
1645: BEGIN

Line 1648: FROM gl_je_categories

1644: l_product VARCHAR2(3);
1645: BEGIN
1646: SELECT user_je_category_name
1647: INTO p_user_je_category_name
1648: FROM gl_je_categories
1649: WHERE je_category_name = 'OLD';
1650: EXCEPTION
1651: WHEN NO_DATA_FOUND THEN
1652: l_error := 'JE CATEGORY = OLD';