APPS.PN_EXP_TO_AP dependencies on PN_MO_CACHE_UTILS

Line 48: PNP_UTIL_FUNC.get_start_date(ps.period_name,pn_mo_cache_utils.get_current_org_id) as gl_date,

44: le.lease_id,
45: NVL(pld.send_entries, ''Y'') as send_entries,
46: pi.payment_schedule_id,
47: ps.period_name,
48: PNP_UTIL_FUNC.get_start_date(ps.period_name,pn_mo_cache_utils.get_current_org_id) as gl_date,
49: pt.normalize,
50: pi.due_date,
51: pt.ap_ar_term_id,
52: TRUNC(pi.accounted_date),

Line 61: decode(UPPER(PNP_UTIL_FUNC.check_conversion_type('''||l_func_curr_code||''',pn_mo_cache_utils.get_current_org_id))

57: pn_exp_to_ap.get_liability_acc(pi.payment_term_id,
58: pi.vendor_id,
59: pi.vendor_site_id) as lia_account,
60: pt.legal_entity_id as legal_entity_id,
61: decode(UPPER(PNP_UTIL_FUNC.check_conversion_type('''||l_func_curr_code||''',pn_mo_cache_utils.get_current_org_id))
62: , ''USER'', decode(pi.export_currency_code
63: ,'''||l_func_curr_code||''', 1
64: ,pi.rate)
65: , NULL) as conv_rate,

Line 66: PNP_UTIL_FUNC.check_conversion_type('''||l_func_curr_code||''',pn_mo_cache_utils.get_current_org_id)

62: , ''USER'', decode(pi.export_currency_code
63: ,'''||l_func_curr_code||''', 1
64: ,pi.rate)
65: , NULL) as conv_rate,
66: PNP_UTIL_FUNC.check_conversion_type('''||l_func_curr_code||''',pn_mo_cache_utils.get_current_org_id)
67: as conv_rate_type,
68: pi.grouping_rule_id as item_grouping_rule_id,
69: pt.grouping_rule_id as term_grouping_rule_id,
70: pld.grouping_rule_id as lease_grouping_rule_id

Line 2205: TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',

2201:
2202: l_context := 'Getting functional currency code';
2203:
2204: l_set_of_books_id :=
2205: TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
2206: pn_mo_cache_utils.get_current_org_id));
2207:
2208: FOR rec IN get_func_curr_code(l_set_of_books_id) LOOP
2209: l_func_curr_code := rec.currency_code;

Line 2206: pn_mo_cache_utils.get_current_org_id));

2202: l_context := 'Getting functional currency code';
2203:
2204: l_set_of_books_id :=
2205: TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
2206: pn_mo_cache_utils.get_current_org_id));
2207:
2208: FOR rec IN get_func_curr_code(l_set_of_books_id) LOOP
2209: l_func_curr_code := rec.currency_code;
2210: END LOOP;

Line 2495: FOR rec IN get_system_grouping_rule_id(pn_mo_cache_utils.get_current_org_id) LOOP

2491: PNP_DEBUG_PKG.log(l_context);
2492:
2493: l_id := -1;
2494:
2495: FOR rec IN get_system_grouping_rule_id(pn_mo_cache_utils.get_current_org_id) LOOP
2496: l_system_grouping_rule_id := rec.grouping_rule_id;
2497: END LOOP;
2498:
2499: IF l_system_grouping_rule_id IS NULL THEN