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.

[Home] [Help]

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 614: l_set_of_books_id NUMBER := to_number(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',

610: l_sal_cred VARCHAR2(1);
611: l_total_rev_amt NUMBER := 0;
612: l_total_rev_percent NUMBER := 0;
613: l_diff_amt NUMBER := 0;
614: l_set_of_books_id NUMBER := to_number(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
615: pn_mo_cache_utils.get_current_org_id));
616: l_func_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;
617: exp_ar_tbl exp_ar_tbl_type;
618: err_ar_tbl err_ar_tbl_type;-- Bug 14762515

Line 615: pn_mo_cache_utils.get_current_org_id));

611: l_total_rev_amt NUMBER := 0;
612: l_total_rev_percent NUMBER := 0;
613: l_diff_amt NUMBER := 0;
614: l_set_of_books_id NUMBER := to_number(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
615: pn_mo_cache_utils.get_current_org_id));
616: l_func_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;
617: exp_ar_tbl exp_ar_tbl_type;
618: err_ar_tbl err_ar_tbl_type;-- Bug 14762515
619: l_total_items NUMBER := 0;

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

893: l_rev_flag := 'N';
894: l_rec_flag := 'N';
895: l_ast_flag := 'N';
896: l_rec_cnt := 0;
897: l_prof_optn := pn_mo_cache_utils.get_profile_value('PN_ACCOUNTING_OPTION',
898: pn_mo_cache_utils.get_current_org_id);
899:
900: FOR dist_rec IN acnt_cls_cur(exp_ar_tbl(l_index).pn_payment_term_id)
901: LOOP

Line 898: pn_mo_cache_utils.get_current_org_id);

894: l_rec_flag := 'N';
895: l_ast_flag := 'N';
896: l_rec_cnt := 0;
897: l_prof_optn := pn_mo_cache_utils.get_profile_value('PN_ACCOUNTING_OPTION',
898: pn_mo_cache_utils.get_current_org_id);
899:
900: FOR dist_rec IN acnt_cls_cur(exp_ar_tbl(l_index).pn_payment_term_id)
901: LOOP
902:

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

966:
967: END IF;
968:
969: exp_ar_tbl(l_index).set_of_books_id
970: := to_number(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
971: pn_mo_cache_utils.get_current_org_id));
972: -- increase the index only if the item needs to be inserted into interface tables
973: l_index := l_index+1;
974:

Line 971: pn_mo_cache_utils.get_current_org_id));

967: END IF;
968:
969: exp_ar_tbl(l_index).set_of_books_id
970: := to_number(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
971: pn_mo_cache_utils.get_current_org_id));
972: -- increase the index only if the item needs to be inserted into interface tables
973: l_index := l_index+1;
974:
975: EXCEPTION

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

1388: ,exp_ar_tbl(l_grp).pn_salesrep_id
1389: ,l_salesrep_number
1390: ,exp_ar_tbl(l_grp).pn_po_number
1391: ,l_batch_name
1392: ,pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
1393: pn_mo_cache_utils.get_current_org_id)
1394: ,'LINE'
1395: ,l_desc
1396: ,exp_ar_tbl(l_grp).pn_export_currency_code

Line 1393: pn_mo_cache_utils.get_current_org_id)

1389: ,l_salesrep_number
1390: ,exp_ar_tbl(l_grp).pn_po_number
1391: ,l_batch_name
1392: ,pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
1393: pn_mo_cache_utils.get_current_org_id)
1394: ,'LINE'
1395: ,l_desc
1396: ,exp_ar_tbl(l_grp).pn_export_currency_code
1397: ,round(exp_ar_tbl(l_grp).pn_export_currency_amount,l_precision)

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

1950: l_sal_cred VARCHAR2(1);
1951: l_total_rev_amt NUMBER := 0;
1952: l_total_rev_percent NUMBER := 0;
1953: l_diff_amt NUMBER := 0;
1954: l_set_of_books_id NUMBER := to_number(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
1955: pn_mo_cache_utils.get_current_org_id));
1956: l_func_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;
1957: l_conv_rate_type PN_CURRENCIES.conversion_type%TYPE;
1958: l_conv_rate PN_PAYMENT_ITEMS.rate%TYPE;

Line 1955: pn_mo_cache_utils.get_current_org_id));

1951: l_total_rev_amt NUMBER := 0;
1952: l_total_rev_percent NUMBER := 0;
1953: l_diff_amt NUMBER := 0;
1954: l_set_of_books_id NUMBER := to_number(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
1955: pn_mo_cache_utils.get_current_org_id));
1956: l_func_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;
1957: l_conv_rate_type PN_CURRENCIES.conversion_type%TYPE;
1958: l_conv_rate PN_PAYMENT_ITEMS.rate%TYPE;
1959: v_location_id PN_LOCATIONS.location_id%TYPE;

Line 2188: pn_mo_cache_utils.get_current_org_id);

2184: l_conv_rate_type := 'User';
2185:
2186: ELSE
2187: l_conv_rate_type := PNP_UTIL_FUNC.check_conversion_type(l_func_curr_code,
2188: pn_mo_cache_utils.get_current_org_id);
2189: IF UPPER(l_conv_rate_type) = 'USER' THEN
2190: l_conv_rate := v_pn_rate;
2191: ELSE
2192: l_conv_rate := NULL;

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

2220: l_ast_flag := 'N';
2221: l_rec_cnt := 0;
2222: l_total_rev_amt := 0;
2223: l_total_rev_percent := 0;
2224: l_prof_optn := pn_mo_cache_utils.get_profile_value('PN_ACCOUNTING_OPTION',
2225: pn_mo_cache_utils.get_current_org_id);
2226:
2227: FOR dist_rec IN acnt_cls_cur(v_pn_payment_term_id)
2228: LOOP

Line 2225: pn_mo_cache_utils.get_current_org_id);

2221: l_rec_cnt := 0;
2222: l_total_rev_amt := 0;
2223: l_total_rev_percent := 0;
2224: l_prof_optn := pn_mo_cache_utils.get_profile_value('PN_ACCOUNTING_OPTION',
2225: pn_mo_cache_utils.get_current_org_id);
2226:
2227: FOR dist_rec IN acnt_cls_cur(v_pn_payment_term_id)
2228: LOOP
2229:

Line 2311: pn_mo_cache_utils.get_current_org_id);

2307: l_start_date := null;
2308: ELSE
2309:
2310: l_start_date := PNP_UTIL_FUNC.Get_Start_Date(v_pn_period_name,
2311: pn_mo_cache_utils.get_current_org_id);
2312: END IF;
2313:
2314: pnp_debug_pkg.put_log_msg('
2315: ================================================================================');

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

2533: ,v_pn_salesrep_id
2534: ,l_salesrep_number
2535: ,v_pn_po_number
2536: ,l_batch_name
2537: ,pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
2538: pn_mo_cache_utils.get_current_org_id)
2539: ,'LINE'
2540: ,l_desc
2541: ,v_pn_export_currency_code

Line 2538: pn_mo_cache_utils.get_current_org_id)

2534: ,l_salesrep_number
2535: ,v_pn_po_number
2536: ,l_batch_name
2537: ,pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
2538: pn_mo_cache_utils.get_current_org_id)
2539: ,'LINE'
2540: ,l_desc
2541: ,v_pn_export_currency_code
2542: ,round(v_pn_export_currency_amount,l_precision)