APPS.PSP_SUM_ADJ dependencies on GL_JE_CATEGORIES

Line 1237: get_gl_je_categories(l_user_je_category_name,

1233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1234: END IF;
1235:
1236: -- get the category name
1237: get_gl_je_categories(l_user_je_category_name,
1238: l_return_status);
1239: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1241: END IF;

Line 1503: PROCEDURE get_gl_je_categories(P_USER_JE_CATEGORY_NAME OUT NOCOPY VARCHAR2,

1499: p_return_status := fnd_api.g_ret_sts_unexp_error;
1500: END;
1501:
1502: ---------------------- GET_GL_CATEGORIES --------------------------------------------------
1503: PROCEDURE get_gl_je_categories(P_USER_JE_CATEGORY_NAME OUT NOCOPY VARCHAR2,
1504: P_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
1505: -- Included the following cursor for bug fix 1765678
1506: CURSOR gl_je_category_cur IS
1507: SELECT user_je_category_name

Line 1508: FROM gl_je_categories

1504: P_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
1505: -- Included the following cursor for bug fix 1765678
1506: CURSOR gl_je_category_cur IS
1507: SELECT user_je_category_name
1508: FROM gl_je_categories
1509: WHERE je_category_name = 'OLD';
1510: l_error VARCHAR2(100);
1511: l_product VARCHAR2(3);
1512: BEGIN