eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_EXP_TO_AR dependencies on PN_MO_CACHE_UTILS

Line 102: AND NVL(bs.org_id,-99) = NVL(pn_mo_cache_utils.get_current_org_id,-99); --Bug#6319026

98: WHERE gb.GROUPING_TRX_TYPE_ID = gt.GROUPING_TRX_TYPE_ID
99: AND gt.GROUPING_RULE_ID = gr.GROUPING_RULE_ID
100: AND gr.GROUPING_RULE_ID = bs.GROUPING_RULE_ID
101: AND bs.BATCH_SOURCE_ID = 24
102: AND NVL(bs.org_id,-99) = NVL(pn_mo_cache_utils.get_current_org_id,-99); --Bug#6319026
103:
104: CURSOR get_post_to_gl(p_trx_type_id NUMBER, p_org_id NUMBER) IS
105: SELECT post_to_gl
106: FROM ra_cust_trx_types_all

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

183: l_amt_where_clause VARCHAR2(4000);
184: l_customer_where_clause VARCHAR2(4000);
185: l_param_where_clause VARCHAR2(30000);
186: l_groupId VARCHAR2(10);
187: l_set_of_books_id NUMBER := to_number(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
188: pn_mo_cache_utils.get_current_org_id));
189:
190:
191: BEGIN

Line 188: pn_mo_cache_utils.get_current_org_id));

184: l_customer_where_clause VARCHAR2(4000);
185: l_param_where_clause VARCHAR2(30000);
186: l_groupId VARCHAR2(10);
187: l_set_of_books_id NUMBER := to_number(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
188: pn_mo_cache_utils.get_current_org_id));
189:
190:
191: BEGIN
192: pnp_debug_pkg.log('-------- PN_EXP_TO_AR.EXP_TO_AR --------- (+)');

Line 220: pn_mo_cache_utils.get_current_org_id)

216: pt.location_id, NVL(pld.send_entries, ''Y''),
217: pd.account_id as rec_account,
218: TO_DATE(DECODE(pt.inv_rule_id||pt.account_rule_id||cust_trx.post_to_gl
219: ,''Y'', to_char(PNP_UTIL_FUNC.Get_Start_Date(ps.period_name,
220: pn_mo_cache_utils.get_current_org_id)
221: , ''MM/DD/YYYY'')
222: ,NULL)
223: ,''MM/DD/YYYY'') as gl_date,
224: DECODE(UPPER('''||l_func_curr_code||''')

Line 227: pn_mo_cache_utils.get_current_org_id))

223: ,''MM/DD/YYYY'') as gl_date,
224: DECODE(UPPER('''||l_func_curr_code||''')
225: ,UPPER(pi.export_currency_code),1
226: ,DECODE(UPPER(PNP_UTIL_FUNC.check_conversion_type('''||l_func_curr_code||''',
227: pn_mo_cache_utils.get_current_org_id))
228: ,''USER'',pi.rate
229: ,NULL)) as conv_rate,
230: DECODE(UPPER('''||l_func_curr_code||''')
231: ,UPPER(pi.export_currency_code),''User''

Line 233: pn_mo_cache_utils.get_current_org_id)

229: ,NULL)) as conv_rate,
230: DECODE(UPPER('''||l_func_curr_code||''')
231: ,UPPER(pi.export_currency_code),''User''
232: ,PNP_UTIL_FUNC.check_conversion_type('''||l_func_curr_code||''',
233: pn_mo_cache_utils.get_current_org_id)
234: ) as conv_rate_type,
235: pt.payment_purpose_code as payment_purpose,
236: pt.payment_term_type_code as payment_type,
237: TO_DATE(DECODE(rr.type||rr.frequency ,''ASPECIFIC'',NULL,

Line 239: pn_mo_cache_utils.get_current_org_id)

235: pt.payment_purpose_code as payment_purpose,
236: pt.payment_term_type_code as payment_type,
237: TO_DATE(DECODE(rr.type||rr.frequency ,''ASPECIFIC'',NULL,
238: to_char(PNP_UTIL_FUNC.Get_Start_Date(ps.period_name,
239: pn_mo_cache_utils.get_current_org_id)
240: , ''MM/DD/YYYY''))
241: ,''MM/DD/YYYY'') as rule_gl_date,
242: ps.schedule_date as schedule_date
243: FROM PN_PAYMENT_ITEMS pi, PN_PAYMENT_SCHEDULES_ALL ps,

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

606: l_sal_cred VARCHAR2(1);
607: l_total_rev_amt NUMBER := 0;
608: l_total_rev_percent NUMBER := 0;
609: l_diff_amt NUMBER := 0;
610: l_set_of_books_id NUMBER := to_number(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
611: pn_mo_cache_utils.get_current_org_id));
612: l_func_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;
613: exp_ar_tbl exp_ar_tbl_type;
614: l_total_items NUMBER := 0;

Line 611: pn_mo_cache_utils.get_current_org_id));

607: l_total_rev_amt NUMBER := 0;
608: l_total_rev_percent NUMBER := 0;
609: l_diff_amt NUMBER := 0;
610: l_set_of_books_id NUMBER := to_number(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
611: pn_mo_cache_utils.get_current_org_id));
612: l_func_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;
613: exp_ar_tbl exp_ar_tbl_type;
614: l_total_items NUMBER := 0;
615: l_index NUMBER := 1;

Line 887: l_prof_optn := pn_mo_cache_utils.get_profile_value('PN_ACCOUNTING_OPTION',

883: l_rev_flag := 'N';
884: l_rec_flag := 'N';
885: l_ast_flag := 'N';
886: l_rec_cnt := 0;
887: l_prof_optn := pn_mo_cache_utils.get_profile_value('PN_ACCOUNTING_OPTION',
888: pn_mo_cache_utils.get_current_org_id);
889:
890: FOR dist_rec IN acnt_cls_cur(exp_ar_tbl(l_index).pn_payment_term_id)
891: LOOP

Line 888: pn_mo_cache_utils.get_current_org_id);

884: l_rec_flag := 'N';
885: l_ast_flag := 'N';
886: l_rec_cnt := 0;
887: l_prof_optn := pn_mo_cache_utils.get_profile_value('PN_ACCOUNTING_OPTION',
888: pn_mo_cache_utils.get_current_org_id);
889:
890: FOR dist_rec IN acnt_cls_cur(exp_ar_tbl(l_index).pn_payment_term_id)
891: LOOP
892:

Line 960: := to_number(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',

956:
957: END IF;
958:
959: exp_ar_tbl(l_index).set_of_books_id
960: := to_number(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
961: pn_mo_cache_utils.get_current_org_id));
962: -- increase the index only if the item needs to be inserted into interface tables
963: l_index := l_index+1;
964:

Line 961: pn_mo_cache_utils.get_current_org_id));

957: END IF;
958:
959: exp_ar_tbl(l_index).set_of_books_id
960: := to_number(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
961: pn_mo_cache_utils.get_current_org_id));
962: -- increase the index only if the item needs to be inserted into interface tables
963: l_index := l_index+1;
964:
965: EXCEPTION

Line 1377: ,pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',

1373: ,exp_ar_tbl(l_grp).pn_salesrep_id
1374: ,l_salesrep_number
1375: ,exp_ar_tbl(l_grp).pn_po_number
1376: ,l_batch_name
1377: ,pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
1378: pn_mo_cache_utils.get_current_org_id)
1379: ,'LINE'
1380: ,l_desc
1381: ,exp_ar_tbl(l_grp).pn_export_currency_code

Line 1378: pn_mo_cache_utils.get_current_org_id)

1374: ,l_salesrep_number
1375: ,exp_ar_tbl(l_grp).pn_po_number
1376: ,l_batch_name
1377: ,pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
1378: pn_mo_cache_utils.get_current_org_id)
1379: ,'LINE'
1380: ,l_desc
1381: ,exp_ar_tbl(l_grp).pn_export_currency_code
1382: ,round(exp_ar_tbl(l_grp).pn_export_currency_amount,l_precision)

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

1904: l_sal_cred VARCHAR2(1);
1905: l_total_rev_amt NUMBER := 0;
1906: l_total_rev_percent NUMBER := 0;
1907: l_diff_amt NUMBER := 0;
1908: l_set_of_books_id NUMBER := to_number(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
1909: pn_mo_cache_utils.get_current_org_id));
1910: l_func_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;
1911: l_conv_rate_type PN_CURRENCIES.conversion_type%TYPE;
1912: l_conv_rate PN_PAYMENT_ITEMS.rate%TYPE;

Line 1909: pn_mo_cache_utils.get_current_org_id));

1905: l_total_rev_amt NUMBER := 0;
1906: l_total_rev_percent NUMBER := 0;
1907: l_diff_amt NUMBER := 0;
1908: l_set_of_books_id NUMBER := to_number(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
1909: pn_mo_cache_utils.get_current_org_id));
1910: l_func_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;
1911: l_conv_rate_type PN_CURRENCIES.conversion_type%TYPE;
1912: l_conv_rate PN_PAYMENT_ITEMS.rate%TYPE;
1913: v_location_id PN_LOCATIONS.location_id%TYPE;

Line 2137: pn_mo_cache_utils.get_current_org_id);

2133: l_conv_rate_type := 'User';
2134:
2135: ELSE
2136: l_conv_rate_type := PNP_UTIL_FUNC.check_conversion_type(l_func_curr_code,
2137: pn_mo_cache_utils.get_current_org_id);
2138: IF UPPER(l_conv_rate_type) = 'USER' THEN
2139: l_conv_rate := v_pn_rate;
2140: ELSE
2141: l_conv_rate := NULL;

Line 2173: l_prof_optn := pn_mo_cache_utils.get_profile_value('PN_ACCOUNTING_OPTION',

2169: l_ast_flag := 'N';
2170: l_rec_cnt := 0;
2171: l_total_rev_amt := 0;
2172: l_total_rev_percent := 0;
2173: l_prof_optn := pn_mo_cache_utils.get_profile_value('PN_ACCOUNTING_OPTION',
2174: pn_mo_cache_utils.get_current_org_id);
2175:
2176: FOR dist_rec IN acnt_cls_cur(v_pn_payment_term_id)
2177: LOOP

Line 2174: pn_mo_cache_utils.get_current_org_id);

2170: l_rec_cnt := 0;
2171: l_total_rev_amt := 0;
2172: l_total_rev_percent := 0;
2173: l_prof_optn := pn_mo_cache_utils.get_profile_value('PN_ACCOUNTING_OPTION',
2174: pn_mo_cache_utils.get_current_org_id);
2175:
2176: FOR dist_rec IN acnt_cls_cur(v_pn_payment_term_id)
2177: LOOP
2178:

Line 2260: pn_mo_cache_utils.get_current_org_id);

2256: l_start_date := null;
2257: ELSE
2258:
2259: l_start_date := PNP_UTIL_FUNC.Get_Start_Date(v_pn_period_name,
2260: pn_mo_cache_utils.get_current_org_id);
2261: END IF;
2262:
2263: pnp_debug_pkg.put_log_msg('
2264: ================================================================================');

Line 2486: ,pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',

2482: ,v_pn_salesrep_id
2483: ,l_salesrep_number
2484: ,v_pn_po_number
2485: ,l_batch_name
2486: ,pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
2487: pn_mo_cache_utils.get_current_org_id)
2488: ,'LINE'
2489: ,l_desc
2490: ,v_pn_export_currency_code

Line 2487: pn_mo_cache_utils.get_current_org_id)

2483: ,l_salesrep_number
2484: ,v_pn_po_number
2485: ,l_batch_name
2486: ,pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
2487: pn_mo_cache_utils.get_current_org_id)
2488: ,'LINE'
2489: ,l_desc
2490: ,v_pn_export_currency_code
2491: ,round(v_pn_export_currency_amount,l_precision)