APPS.PNP_UTIL_FUNC dependencies on PN_MO_CACHE_UTILS

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

1620: BEGIN
1621:
1622: IF p_column_name IS NULL THEN
1623:
1624: l_set_of_books_id := TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
1625: p_org_id));
1626:
1627: OPEN get_coa_id(l_set_of_books_id);
1628: FETCH get_coa_id INTO l_coa_id;

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

1831: l_set_of_books_id NUMBER;
1832: coa_id NUMBER;
1833:
1834: BEGIN
1835: l_set_of_books_id := to_number(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
1836: p_org_id));
1837:
1838: SELECT chart_of_accounts_id
1839: INTO coa_id

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

1904:
1905: BEGIN
1906:
1907: --Bug#6366630: Added the IF condition to control Cost Center Validation using Profile Option --
1908: IF nvl(pn_mo_cache_utils.get_profile_value('PN_VALIDATE_ASSIGN_CC', p_org_id),'Y') = 'Y' THEN
1909: l_column_name := ltrim(rtrim(get_segment_column_name(p_org_id)));
1910: l_cost_center := p_cost_center;
1911: l_cursor := dbms_sql.open_cursor;
1912:

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

2200: l_start_date DATE;
2201:
2202: BEGIN
2203:
2204: l_Set_Of_Books_Id := pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
2205: p_org_id);
2206:
2207: IF (p_period_name = NULL) THEN
2208: l_start_date := SYSDATE;

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

5327: SELECT period_name
5328: INTO l_gl_period_name
5329: FROM gl_period_statuses
5330: WHERE closing_status IN ('O', 'F')
5331: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
5332: p_org_id)
5333: AND application_id = p_application_id
5334: AND adjustment_period_flag = 'N'
5335: AND p_sch_date BETWEEN start_date AND end_date;

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

5348: SELECT period_name
5349: INTO l_gl_period_name
5350: FROM gl_period_statuses
5351: WHERE closing_status IN ('O', 'F')
5352: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
5353: p_org_id)
5354: AND application_id = p_application_id
5355: AND adjustment_period_flag = 'N'
5356: AND start_date = (SELECT MIN(start_date)

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

5355: AND adjustment_period_flag = 'N'
5356: AND start_date = (SELECT MIN(start_date)
5357: FROM gl_period_statuses
5358: WHERE closing_status IN ('O', 'F')
5359: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
5360: p_org_id)
5361: AND application_id = p_application_id
5362: AND adjustment_period_flag = 'N'
5363: AND start_date >= p_sch_date);

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

6252: WHERE currency_code = p_curr_code;
6253:
6254: BEGIN
6255:
6256: l_prof_optn_curr_type := pn_mo_cache_utils.get_profile_value('PN_CURRENCY_CONV_RATE_TYPE',
6257: p_org_id);
6258:
6259: IF l_prof_optn_curr_type IS NOT NULL THEN
6260: RETURN l_prof_optn_curr_type;