APPS.PNP_UTIL_FUNC dependencies on PN_MO_CACHE_UTILS

Line 1779: l_set_of_books_id := TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',

1775: BEGIN
1776:
1777: IF p_column_name IS NULL THEN
1778:
1779: l_set_of_books_id := TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
1780: p_org_id));
1781:
1782: OPEN get_coa_id(l_set_of_books_id);
1783: FETCH get_coa_id INTO l_coa_id;

Line 1990: l_set_of_books_id := to_number(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',

1986: l_set_of_books_id NUMBER;
1987: coa_id NUMBER;
1988:
1989: BEGIN
1990: l_set_of_books_id := to_number(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
1991: p_org_id));
1992:
1993: SELECT chart_of_accounts_id
1994: INTO coa_id

Line 2063: IF nvl(pn_mo_cache_utils.get_profile_value('PN_VALIDATE_ASSIGN_CC', p_org_id),'Y') = 'Y' THEN

2059:
2060: BEGIN
2061:
2062: --Bug#6366630: Added the IF condition to control Cost Center Validation using Profile Option --
2063: IF nvl(pn_mo_cache_utils.get_profile_value('PN_VALIDATE_ASSIGN_CC', p_org_id),'Y') = 'Y' THEN
2064: l_column_name := ltrim(rtrim(get_segment_column_name(p_org_id)));
2065: l_cost_center := p_cost_center;
2066: l_cursor := dbms_sql.open_cursor;
2067:

Line 2359: l_Set_Of_Books_Id := pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',

2355: l_start_date DATE;
2356:
2357: BEGIN
2358:
2359: l_Set_Of_Books_Id := pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
2360: p_org_id);
2361:
2362: IF (p_period_name = NULL) THEN
2363: l_start_date := SYSDATE;

Line 5489: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',

5485: SELECT period_name
5486: INTO l_gl_period_name
5487: FROM gl_period_statuses
5488: WHERE closing_status IN ('O', 'F')
5489: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
5490: p_org_id)
5491: AND application_id = p_application_id
5492: AND adjustment_period_flag = 'N'
5493: AND p_sch_date BETWEEN start_date AND end_date;

Line 5510: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',

5506: SELECT period_name
5507: INTO l_gl_period_name
5508: FROM gl_period_statuses
5509: WHERE closing_status IN ('O', 'F')
5510: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
5511: p_org_id)
5512: AND application_id = p_application_id
5513: AND adjustment_period_flag = 'N'
5514: AND start_date = (SELECT MIN(start_date)

Line 5517: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',

5513: AND adjustment_period_flag = 'N'
5514: AND start_date = (SELECT MIN(start_date)
5515: FROM gl_period_statuses
5516: WHERE closing_status IN ('O', 'F')
5517: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
5518: p_org_id)
5519: AND application_id = p_application_id
5520: AND adjustment_period_flag = 'N'
5521: AND start_date >= p_sch_date);

Line 6417: l_prof_optn_curr_type := pn_mo_cache_utils.get_profile_value('PN_CURRENCY_CONV_RATE_TYPE',

6413: WHERE currency_code = p_curr_code;
6414:
6415: BEGIN
6416:
6417: l_prof_optn_curr_type := pn_mo_cache_utils.get_profile_value('PN_CURRENCY_CONV_RATE_TYPE',
6418: p_org_id);
6419:
6420: IF l_prof_optn_curr_type IS NOT NULL THEN
6421: RETURN l_prof_optn_curr_type;