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.GMF_GET_MAPPINGS dependencies on GMF_GET_MAPPINGS

Line 1: PACKAGE BODY GMF_GET_MAPPINGS AS

1: PACKAGE BODY GMF_GET_MAPPINGS AS
2: /* $Header: gmfactmb.pls 115.27 2003/05/21 20:34:01 sschinch ship $ */
3:
4: /* Declarations for AR merge */
5:

Line 111: x_order_by gmf_get_mappings.my_order_by;

107: IS
108: X_sqlstmt VARCHAR2(2000);
109: X_sqlwhere VARCHAR2(2000);
110: X_sqlwhere1 VARCHAR2(2000) DEFAULT '';
111: x_order_by gmf_get_mappings.my_order_by;
112: X_my_order_by VARCHAR2(200);
113: X_sqlwhere2 VARCHAR2(2000);
114: X_sqlwhere3 VARCHAR2(2000);
115: X_sqlwhere4 VARCHAR2(2000);

Line 212: --X_sqlstmt2 := ' WHERE acct_ttl_type = '||to_char(Cur_subevtacct_ttl.acct_ttl_type) || ' AND gmf_get_mappings.fstrcmp(co_code,'''||v_co_code||''')=1 AND delete_mark = 0 ORDER BY 1 desc';

208: --
209: X_sqlstmt1 := 'charge_pri,currency_code_pri, reason_code_pri,routing_pri, aqui_cost_code_pri,resource_pri, ' ||
210: 'cost_cmpntcls_pri,cost_analysis_pri, order_type_pri, gl_business_class_pri, gl_product_line_pri, line_type_pri, ar_trx_type_pri FROM gl_acct_hrc ';
211:
212: --X_sqlstmt2 := ' WHERE acct_ttl_type = '||to_char(Cur_subevtacct_ttl.acct_ttl_type) || ' AND gmf_get_mappings.fstrcmp(co_code,'''||v_co_code||''')=1 AND delete_mark = 0 ORDER BY 1 desc';
213:
214: X_sqlstmt2 := ' WHERE acct_ttl_type = :pacct_ttl_type AND (co_code IS NULL OR co_code = :pco_code) AND delete_mark = 0 ORDER BY 1 desc';
215:
216:

Line 266: ' AND gmf_get_mappings.fstrcmp(co_code, ''' || X_co_code || ''')=1' ||

262: END LOOP;
263: DBMS_SQL.CLOSE_CURSOR(X_cursor_handle);
264:
265: /* X_sqlwhere := 'WHERE acct_ttl_type = '||to_char(Cur_subevtacct_ttl.acct_ttl_type)||
266: ' AND gmf_get_mappings.fstrcmp(co_code, ''' || X_co_code || ''')=1' ||
267: ' AND gmf_get_mappings.fstrcmp(whse_code, ''' || v_whse_code || ''')=1'; */
268:
269: X_sqlwhere := 'WHERE acct_ttl_type = :pacct_ttl_type AND (co_code IS NULL OR co_code = :pco_code) '||
270: ' AND (whse_code IS NULL OR whse_code = :pwhse_code) ';

Line 267: ' AND gmf_get_mappings.fstrcmp(whse_code, ''' || v_whse_code || ''')=1'; */

263: DBMS_SQL.CLOSE_CURSOR(X_cursor_handle);
264:
265: /* X_sqlwhere := 'WHERE acct_ttl_type = '||to_char(Cur_subevtacct_ttl.acct_ttl_type)||
266: ' AND gmf_get_mappings.fstrcmp(co_code, ''' || X_co_code || ''')=1' ||
267: ' AND gmf_get_mappings.fstrcmp(whse_code, ''' || v_whse_code || ''')=1'; */
268:
269: X_sqlwhere := 'WHERE acct_ttl_type = :pacct_ttl_type AND (co_code IS NULL OR co_code = :pco_code) '||
270: ' AND (whse_code IS NULL OR whse_code = :pwhse_code) ';
271:

Line 272: /*X_sqlwhere1:= ' AND gmf_get_mappings.fstrcmp(orgn_code, ''' || X_map_orgn_code || ''')=1' ||

268:
269: X_sqlwhere := 'WHERE acct_ttl_type = :pacct_ttl_type AND (co_code IS NULL OR co_code = :pco_code) '||
270: ' AND (whse_code IS NULL OR whse_code = :pwhse_code) ';
271:
272: /*X_sqlwhere1:= ' AND gmf_get_mappings.fstrcmp(orgn_code, ''' || X_map_orgn_code || ''')=1' ||
273: ' AND gmf_get_mappings.fnumcmp(item_id, ' || NVL(v_item_id, 0) || ')=1 ' ||
274: ' AND gmf_get_mappings.fnumcmp(vendor_id, ' || NVL(v_vendor_id,0) || ')=1 ' ; */
275:
276: X_sqlwhere1:= ' AND (orgn_code IS NULL OR orgn_code = :pmap_orgn_code ) '||

Line 273: ' AND gmf_get_mappings.fnumcmp(item_id, ' || NVL(v_item_id, 0) || ')=1 ' ||

269: X_sqlwhere := 'WHERE acct_ttl_type = :pacct_ttl_type AND (co_code IS NULL OR co_code = :pco_code) '||
270: ' AND (whse_code IS NULL OR whse_code = :pwhse_code) ';
271:
272: /*X_sqlwhere1:= ' AND gmf_get_mappings.fstrcmp(orgn_code, ''' || X_map_orgn_code || ''')=1' ||
273: ' AND gmf_get_mappings.fnumcmp(item_id, ' || NVL(v_item_id, 0) || ')=1 ' ||
274: ' AND gmf_get_mappings.fnumcmp(vendor_id, ' || NVL(v_vendor_id,0) || ')=1 ' ; */
275:
276: X_sqlwhere1:= ' AND (orgn_code IS NULL OR orgn_code = :pmap_orgn_code ) '||
277: ' AND (item_id IS NULL OR item_id = :pitem_id) AND (vendor_id IS NULL OR vendor_id = :pvendor_id) ' ;

Line 274: ' AND gmf_get_mappings.fnumcmp(vendor_id, ' || NVL(v_vendor_id,0) || ')=1 ' ; */

270: ' AND (whse_code IS NULL OR whse_code = :pwhse_code) ';
271:
272: /*X_sqlwhere1:= ' AND gmf_get_mappings.fstrcmp(orgn_code, ''' || X_map_orgn_code || ''')=1' ||
273: ' AND gmf_get_mappings.fnumcmp(item_id, ' || NVL(v_item_id, 0) || ')=1 ' ||
274: ' AND gmf_get_mappings.fnumcmp(vendor_id, ' || NVL(v_vendor_id,0) || ')=1 ' ; */
275:
276: X_sqlwhere1:= ' AND (orgn_code IS NULL OR orgn_code = :pmap_orgn_code ) '||
277: ' AND (item_id IS NULL OR item_id = :pitem_id) AND (vendor_id IS NULL OR vendor_id = :pvendor_id) ' ;
278:

Line 280: /* X_sqlwhere2:= ' AND gmf_get_mappings.fnumcmp(cust_id, ' || NVL(v_cust_id,0) || ')=1' ||

276: X_sqlwhere1:= ' AND (orgn_code IS NULL OR orgn_code = :pmap_orgn_code ) '||
277: ' AND (item_id IS NULL OR item_id = :pitem_id) AND (vendor_id IS NULL OR vendor_id = :pvendor_id) ' ;
278:
279:
280: /* X_sqlwhere2:= ' AND gmf_get_mappings.fnumcmp(cust_id, ' || NVL(v_cust_id,0) || ')=1' ||
281: ' AND gmf_get_mappings.fstrcmp(reason_code, ''' || v_reason_code || ''')=1' ||
282: ' AND gmf_get_mappings.fstrcmp(icgl_class, ''' || v_icgl_class || ''')=1'; */
283:
284: X_sqlwhere2:= ' AND (cust_id IS NULL OR cust_id = :pcust_id) '||

Line 281: ' AND gmf_get_mappings.fstrcmp(reason_code, ''' || v_reason_code || ''')=1' ||

277: ' AND (item_id IS NULL OR item_id = :pitem_id) AND (vendor_id IS NULL OR vendor_id = :pvendor_id) ' ;
278:
279:
280: /* X_sqlwhere2:= ' AND gmf_get_mappings.fnumcmp(cust_id, ' || NVL(v_cust_id,0) || ')=1' ||
281: ' AND gmf_get_mappings.fstrcmp(reason_code, ''' || v_reason_code || ''')=1' ||
282: ' AND gmf_get_mappings.fstrcmp(icgl_class, ''' || v_icgl_class || ''')=1'; */
283:
284: X_sqlwhere2:= ' AND (cust_id IS NULL OR cust_id = :pcust_id) '||
285: ' AND (reason_code IS NULL OR reason_code = :preason_code) '||

Line 282: ' AND gmf_get_mappings.fstrcmp(icgl_class, ''' || v_icgl_class || ''')=1'; */

278:
279:
280: /* X_sqlwhere2:= ' AND gmf_get_mappings.fnumcmp(cust_id, ' || NVL(v_cust_id,0) || ')=1' ||
281: ' AND gmf_get_mappings.fstrcmp(reason_code, ''' || v_reason_code || ''')=1' ||
282: ' AND gmf_get_mappings.fstrcmp(icgl_class, ''' || v_icgl_class || ''')=1'; */
283:
284: X_sqlwhere2:= ' AND (cust_id IS NULL OR cust_id = :pcust_id) '||
285: ' AND (reason_code IS NULL OR reason_code = :preason_code) '||
286: ' AND (icgl_class IS NULL OR icgl_class = :picgl_class) ';

Line 289: /* X_sqlwhere3:= ' AND gmf_get_mappings.fstrcmp(vendgl_class, ''' || v_vendgl_class || ''')=1' ||

285: ' AND (reason_code IS NULL OR reason_code = :preason_code) '||
286: ' AND (icgl_class IS NULL OR icgl_class = :picgl_class) ';
287:
288:
289: /* X_sqlwhere3:= ' AND gmf_get_mappings.fstrcmp(vendgl_class, ''' || v_vendgl_class || ''')=1' ||
290: ' AND gmf_get_mappings.fstrcmp(custgl_class, ''' || v_custgl_class || ''')=1'; */
291:
292: X_sqlwhere3:= ' AND (vendgl_class IS NULL OR vendgl_class = :pvendgl_class) '||
293: ' AND (custgl_class IS NULL OR custgl_class = :pcustgl_class) ';

Line 290: ' AND gmf_get_mappings.fstrcmp(custgl_class, ''' || v_custgl_class || ''')=1'; */

286: ' AND (icgl_class IS NULL OR icgl_class = :picgl_class) ';
287:
288:
289: /* X_sqlwhere3:= ' AND gmf_get_mappings.fstrcmp(vendgl_class, ''' || v_vendgl_class || ''')=1' ||
290: ' AND gmf_get_mappings.fstrcmp(custgl_class, ''' || v_custgl_class || ''')=1'; */
291:
292: X_sqlwhere3:= ' AND (vendgl_class IS NULL OR vendgl_class = :pvendgl_class) '||
293: ' AND (custgl_class IS NULL OR custgl_class = :pcustgl_class) ';
294:

Line 296: /* X_sqlwhere4:= ' AND gmf_get_mappings.fstrcmp(currency_code, '''||v_currency_code||''')=1' ||

292: X_sqlwhere3:= ' AND (vendgl_class IS NULL OR vendgl_class = :pvendgl_class) '||
293: ' AND (custgl_class IS NULL OR custgl_class = :pcustgl_class) ';
294:
295:
296: /* X_sqlwhere4:= ' AND gmf_get_mappings.fstrcmp(currency_code, '''||v_currency_code||''')=1' ||
297: ' AND gmf_get_mappings.fnumcmp(routing_id, '||nvl(v_routing_id,0)||')=1'; */
298:
299: X_sqlwhere4:= ' AND (currency_code IS NULL OR currency_code = :pcurrency_code) '||
300: ' AND (routing_id IS NULL OR routing_id = :prouting_id) ';

Line 297: ' AND gmf_get_mappings.fnumcmp(routing_id, '||nvl(v_routing_id,0)||')=1'; */

293: ' AND (custgl_class IS NULL OR custgl_class = :pcustgl_class) ';
294:
295:
296: /* X_sqlwhere4:= ' AND gmf_get_mappings.fstrcmp(currency_code, '''||v_currency_code||''')=1' ||
297: ' AND gmf_get_mappings.fnumcmp(routing_id, '||nvl(v_routing_id,0)||')=1'; */
298:
299: X_sqlwhere4:= ' AND (currency_code IS NULL OR currency_code = :pcurrency_code) '||
300: ' AND (routing_id IS NULL OR routing_id = :prouting_id) ';
301:

Line 302: /* X_sqlwhere5:= ' AND gmf_get_mappings.fnumcmp(charge_id, '||nvl(v_charge_id,0)||')=1' ||

298:
299: X_sqlwhere4:= ' AND (currency_code IS NULL OR currency_code = :pcurrency_code) '||
300: ' AND (routing_id IS NULL OR routing_id = :prouting_id) ';
301:
302: /* X_sqlwhere5:= ' AND gmf_get_mappings.fnumcmp(charge_id, '||nvl(v_charge_id,0)||')=1' ||
303: ' AND gmf_get_mappings.fnumcmp(taxauth_id, '||nvl(v_taxauth_id,0)||')=1' ||
304: ' AND gmf_get_mappings.fnumcmp(aqui_cost_id, '||nvl(v_aqui_cost_id,0)||')=1' ; */
305:
306: X_sqlwhere5:= ' AND (charge_id IS NULL OR charge_id = :pcharge_id) ' ||

Line 303: ' AND gmf_get_mappings.fnumcmp(taxauth_id, '||nvl(v_taxauth_id,0)||')=1' ||

299: X_sqlwhere4:= ' AND (currency_code IS NULL OR currency_code = :pcurrency_code) '||
300: ' AND (routing_id IS NULL OR routing_id = :prouting_id) ';
301:
302: /* X_sqlwhere5:= ' AND gmf_get_mappings.fnumcmp(charge_id, '||nvl(v_charge_id,0)||')=1' ||
303: ' AND gmf_get_mappings.fnumcmp(taxauth_id, '||nvl(v_taxauth_id,0)||')=1' ||
304: ' AND gmf_get_mappings.fnumcmp(aqui_cost_id, '||nvl(v_aqui_cost_id,0)||')=1' ; */
305:
306: X_sqlwhere5:= ' AND (charge_id IS NULL OR charge_id = :pcharge_id) ' ||
307: ' AND (taxauth_id IS NULL OR taxauth_id = :ptaxauth_id) ' ||

Line 304: ' AND gmf_get_mappings.fnumcmp(aqui_cost_id, '||nvl(v_aqui_cost_id,0)||')=1' ; */

300: ' AND (routing_id IS NULL OR routing_id = :prouting_id) ';
301:
302: /* X_sqlwhere5:= ' AND gmf_get_mappings.fnumcmp(charge_id, '||nvl(v_charge_id,0)||')=1' ||
303: ' AND gmf_get_mappings.fnumcmp(taxauth_id, '||nvl(v_taxauth_id,0)||')=1' ||
304: ' AND gmf_get_mappings.fnumcmp(aqui_cost_id, '||nvl(v_aqui_cost_id,0)||')=1' ; */
305:
306: X_sqlwhere5:= ' AND (charge_id IS NULL OR charge_id = :pcharge_id) ' ||
307: ' AND (taxauth_id IS NULL OR taxauth_id = :ptaxauth_id) ' ||
308: ' AND (aqui_cost_id IS NULL OR aqui_cost_id = :paqui_cost_id) ' ;

Line 310: /* X_sqlwhere6 := ' AND gmf_get_mappings.fstrcmp(resources, '''||v_resources||''')=1' ||

306: X_sqlwhere5:= ' AND (charge_id IS NULL OR charge_id = :pcharge_id) ' ||
307: ' AND (taxauth_id IS NULL OR taxauth_id = :ptaxauth_id) ' ||
308: ' AND (aqui_cost_id IS NULL OR aqui_cost_id = :paqui_cost_id) ' ;
309:
310: /* X_sqlwhere6 := ' AND gmf_get_mappings.fstrcmp(resources, '''||v_resources||''')=1' ||
311: ' AND gmf_get_mappings.fnumcmp(cost_cmpntcls_id, '||nvl(v_cost_cmpntcls_id,0)||')=1' ||
312: ' AND gmf_get_mappings.fstrcmp(cost_analysis_code, '''||v_cost_analysis_code||''')=1' ||
313: ' AND delete_mark = 0 '; */
314:

Line 311: ' AND gmf_get_mappings.fnumcmp(cost_cmpntcls_id, '||nvl(v_cost_cmpntcls_id,0)||')=1' ||

307: ' AND (taxauth_id IS NULL OR taxauth_id = :ptaxauth_id) ' ||
308: ' AND (aqui_cost_id IS NULL OR aqui_cost_id = :paqui_cost_id) ' ;
309:
310: /* X_sqlwhere6 := ' AND gmf_get_mappings.fstrcmp(resources, '''||v_resources||''')=1' ||
311: ' AND gmf_get_mappings.fnumcmp(cost_cmpntcls_id, '||nvl(v_cost_cmpntcls_id,0)||')=1' ||
312: ' AND gmf_get_mappings.fstrcmp(cost_analysis_code, '''||v_cost_analysis_code||''')=1' ||
313: ' AND delete_mark = 0 '; */
314:
315: X_sqlwhere6 := ' AND (resources IS NULL OR resources = :presources) ' ||

Line 312: ' AND gmf_get_mappings.fstrcmp(cost_analysis_code, '''||v_cost_analysis_code||''')=1' ||

308: ' AND (aqui_cost_id IS NULL OR aqui_cost_id = :paqui_cost_id) ' ;
309:
310: /* X_sqlwhere6 := ' AND gmf_get_mappings.fstrcmp(resources, '''||v_resources||''')=1' ||
311: ' AND gmf_get_mappings.fnumcmp(cost_cmpntcls_id, '||nvl(v_cost_cmpntcls_id,0)||')=1' ||
312: ' AND gmf_get_mappings.fstrcmp(cost_analysis_code, '''||v_cost_analysis_code||''')=1' ||
313: ' AND delete_mark = 0 '; */
314:
315: X_sqlwhere6 := ' AND (resources IS NULL OR resources = :presources) ' ||
316: ' AND (cost_cmpntcls_id IS NULL OR cost_cmpntcls_id = :pcost_cmpntcls_id) ' ||

Line 330: ' AND gmf_get_mappings.fnumcmp(order_type, '||nvl(v_order_type,0)||')=1 ) ';

326: IF( v_source = 11 )
327: THEN
328: /* Bug 2431861
329: X_sqlwhere6 := X_sqlwhere6 || ' AND ( source_type = 11 ' ||
330: ' AND gmf_get_mappings.fnumcmp(order_type, '||nvl(v_order_type,0)||')=1 ) ';
331:
332: X_sqlwhere6 := X_sqlwhere6 || ' AND (( source_type = 11 ' ||
333: ' AND order_type = '||to_char(nvl(v_order_type,0))||')'||' OR order_type IS NULL)'; */
334:

Line 340: ' AND gmf_get_mappings.fnumcmp(order_type, '||nvl(v_order_type,0)||')=1 ) '; */

336: ' AND (order_type = :porder_type OR order_type IS NULL))';
337:
338: ELSE
339: /* X_sqlwhere6 := X_sqlwhere6 || ' AND ( source_type IS NULL ' ||
340: ' AND gmf_get_mappings.fnumcmp(order_type, '||nvl(v_order_type,0)||')=1 ) '; */
341:
342: X_sqlwhere6 := X_sqlwhere6 || ' AND ( source_type IS NULL ' ||
343: ' AND (order_type IS NULL OR order_type = :porder_type)) ';
344:

Line 350: -- X_sqlwhere6 := X_sqlwhere6 || ' AND gmf_get_mappings.fnumcmp(order_type, '||nvl(v_order_type,0)||')=1 ';

346: END IF;
347:
348: ELSE
349: /* Do it as before */
350: -- X_sqlwhere6 := X_sqlwhere6 || ' AND gmf_get_mappings.fnumcmp(order_type, '||nvl(v_order_type,0)||')=1 ';
351: X_sqlwhere6 := X_sqlwhere6 || ' AND (order_type IS NULL OR order_type = :porder_type) ';
352:
353: END IF;
354: /* End B1408077 */

Line 363: ' AND gmf_get_mappings.fnumcmp(gl_business_class_cat_id, ' ||

359: * Bug 2423983 - umoogala : Added ar_trx_type_id
360: */
361:
362: /* X_sqlwhere6 := X_sqlwhere6 ||
363: ' AND gmf_get_mappings.fnumcmp(gl_business_class_cat_id, ' ||
364: nvl(v_business_class_cat_id,0)||')=1 ' ||
365: ' AND gmf_get_mappings.fnumcmp(gl_product_line_cat_id, ' ||
366: nvl(v_product_line_cat_id,0)||')=1 ' ||
367: ' AND gmf_get_mappings.fnumcmp(line_type, ' ||

Line 365: ' AND gmf_get_mappings.fnumcmp(gl_product_line_cat_id, ' ||

361:
362: /* X_sqlwhere6 := X_sqlwhere6 ||
363: ' AND gmf_get_mappings.fnumcmp(gl_business_class_cat_id, ' ||
364: nvl(v_business_class_cat_id,0)||')=1 ' ||
365: ' AND gmf_get_mappings.fnumcmp(gl_product_line_cat_id, ' ||
366: nvl(v_product_line_cat_id,0)||')=1 ' ||
367: ' AND gmf_get_mappings.fnumcmp(line_type, ' ||
368: nvl(v_line_type,0)||')=1 ' ||
369: ' AND gmf_get_mappings.fnumcmp(ar_trx_type_id, ' ||

Line 367: ' AND gmf_get_mappings.fnumcmp(line_type, ' ||

363: ' AND gmf_get_mappings.fnumcmp(gl_business_class_cat_id, ' ||
364: nvl(v_business_class_cat_id,0)||')=1 ' ||
365: ' AND gmf_get_mappings.fnumcmp(gl_product_line_cat_id, ' ||
366: nvl(v_product_line_cat_id,0)||')=1 ' ||
367: ' AND gmf_get_mappings.fnumcmp(line_type, ' ||
368: nvl(v_line_type,0)||')=1 ' ||
369: ' AND gmf_get_mappings.fnumcmp(ar_trx_type_id, ' ||
370: nvl(v_ar_trx_type_id,0)||')=1 ' ; */
371:

Line 369: ' AND gmf_get_mappings.fnumcmp(ar_trx_type_id, ' ||

365: ' AND gmf_get_mappings.fnumcmp(gl_product_line_cat_id, ' ||
366: nvl(v_product_line_cat_id,0)||')=1 ' ||
367: ' AND gmf_get_mappings.fnumcmp(line_type, ' ||
368: nvl(v_line_type,0)||')=1 ' ||
369: ' AND gmf_get_mappings.fnumcmp(ar_trx_type_id, ' ||
370: nvl(v_ar_trx_type_id,0)||')=1 ' ; */
371:
372: X_sqlwhere6 := X_sqlwhere6 ||
373: ' AND (gl_business_class_cat_id IS NULL OR gl_business_class_cat_id = :pbusiness_class_cat_id) ' ||

Line 460: DBMS_SQL.COLUMN_VALUE(X_cursor_handle,24,gmf_get_mappings.my_accounts(i).acct_id);

456: IF (DBMS_SQL.FETCH_ROWS(X_cursor_handle) > 0) THEN
457: i:= i + 1;
458: -- Bug 2031374 - umoogala : 20 -> 22, Bug 2468912: 22 to 23
459: -- Bug 2423983: 23 to 24
460: DBMS_SQL.COLUMN_VALUE(X_cursor_handle,24,gmf_get_mappings.my_accounts(i).acct_id);
461: gmf_get_mappings.my_accounts(i).acct_ttl_type := Cur_subevtacct_ttl.acct_ttl_type;
462: END IF;
463: DBMS_SQL.CLOSE_CURSOR(x_cursor_handle);
464: END LOOP;

Line 461: gmf_get_mappings.my_accounts(i).acct_ttl_type := Cur_subevtacct_ttl.acct_ttl_type;

457: i:= i + 1;
458: -- Bug 2031374 - umoogala : 20 -> 22, Bug 2468912: 22 to 23
459: -- Bug 2423983: 23 to 24
460: DBMS_SQL.COLUMN_VALUE(X_cursor_handle,24,gmf_get_mappings.my_accounts(i).acct_id);
461: gmf_get_mappings.my_accounts(i).acct_ttl_type := Cur_subevtacct_ttl.acct_ttl_type;
462: END IF;
463: DBMS_SQL.CLOSE_CURSOR(x_cursor_handle);
464: END LOOP;
465: no_of_rows := i;

Line 487: AND gmf_get_mappings.fstrcmp(orgn_code, X_map_orgn_code) = 1

483: v_acctg_unit_id := -1;
484: /* FOR crec IN (SELECT acctg_unit_id
485: FROM gl_accu_map
486: WHERE co_code = X_co_code
487: AND gmf_get_mappings.fstrcmp(orgn_code, X_map_orgn_code) = 1
488: AND gmf_get_mappings.fstrcmp(whse_code, v_whse_code) = 1
489: AND delete_mark = 0
490: ORDER BY nvl(orgn_code,' ') DESC, nvl(whse_code,' ') DESC
491: ) */

Line 488: AND gmf_get_mappings.fstrcmp(whse_code, v_whse_code) = 1

484: /* FOR crec IN (SELECT acctg_unit_id
485: FROM gl_accu_map
486: WHERE co_code = X_co_code
487: AND gmf_get_mappings.fstrcmp(orgn_code, X_map_orgn_code) = 1
488: AND gmf_get_mappings.fstrcmp(whse_code, v_whse_code) = 1
489: AND delete_mark = 0
490: ORDER BY nvl(orgn_code,' ') DESC, nvl(whse_code,' ') DESC
491: ) */
492:

Line 684: x_order_by gmf_get_mappings.my_order_by;

680: ) IS
681: X_sqlstmt VARCHAR2(2000);
682: X_sqlwhere VARCHAR2(2000);
683: X_sqlwhere1 VARCHAR2(2000) DEFAULT '';
684: x_order_by gmf_get_mappings.my_order_by;
685: X_my_order_by VARCHAR2(200);
686: X_sqlwhere2 VARCHAR2(2000);
687: X_sqlwhere3 VARCHAR2(2000);
688: X_sqlwhere4 VARCHAR2(2000);

Line 1026: DBMS_SQL.COLUMN_VALUE(X_cursor_handle,24,gmf_get_mappings.my_accounts(i).acct_id);

1022: IF (dbms_sql.fetch_rows(X_cursor_handle) > 0) THEN
1023: i:= i + 1;
1024: -- Bug 2031374 - umoogala: 20 -> 22, Bug 2468912: 22 to 23
1025: -- Bug 2423983 - umoogala: 23 -> 24
1026: DBMS_SQL.COLUMN_VALUE(X_cursor_handle,24,gmf_get_mappings.my_accounts(i).acct_id);
1027: gmf_get_mappings.my_accounts(i).acct_ttl_type := Cur_subevtacct_ttl.acct_ttl_type;
1028: END IF;
1029: DBMS_SQL.CLOSE_CURSOR(x_cursor_handle);
1030: END LOOP;

Line 1027: gmf_get_mappings.my_accounts(i).acct_ttl_type := Cur_subevtacct_ttl.acct_ttl_type;

1023: i:= i + 1;
1024: -- Bug 2031374 - umoogala: 20 -> 22, Bug 2468912: 22 to 23
1025: -- Bug 2423983 - umoogala: 23 -> 24
1026: DBMS_SQL.COLUMN_VALUE(X_cursor_handle,24,gmf_get_mappings.my_accounts(i).acct_id);
1027: gmf_get_mappings.my_accounts(i).acct_ttl_type := Cur_subevtacct_ttl.acct_ttl_type;
1028: END IF;
1029: DBMS_SQL.CLOSE_CURSOR(x_cursor_handle);
1030: END LOOP;
1031: no_of_rows := i;

Line 1049: IF (gmf_get_mappings.no_of_rows > 0) THEN

1045:
1046:
1047: FUNCTION get_account_value(v_acct_ttl_type NUMBER) RETURN NUMBER IS
1048: BEGIN
1049: IF (gmf_get_mappings.no_of_rows > 0) THEN
1050: FOR i IN 1..no_of_rows LOOP
1051: IF (gmf_get_mappings.my_accounts(i).acct_ttl_type = v_acct_ttl_type) THEN
1052: RETURN(nvl(gmf_get_mappings.my_accounts(i).acct_id,0));
1053: END IF;

Line 1051: IF (gmf_get_mappings.my_accounts(i).acct_ttl_type = v_acct_ttl_type) THEN

1047: FUNCTION get_account_value(v_acct_ttl_type NUMBER) RETURN NUMBER IS
1048: BEGIN
1049: IF (gmf_get_mappings.no_of_rows > 0) THEN
1050: FOR i IN 1..no_of_rows LOOP
1051: IF (gmf_get_mappings.my_accounts(i).acct_ttl_type = v_acct_ttl_type) THEN
1052: RETURN(nvl(gmf_get_mappings.my_accounts(i).acct_id,0));
1053: END IF;
1054: END LOOP;
1055: ELSE

Line 1052: RETURN(nvl(gmf_get_mappings.my_accounts(i).acct_id,0));

1048: BEGIN
1049: IF (gmf_get_mappings.no_of_rows > 0) THEN
1050: FOR i IN 1..no_of_rows LOOP
1051: IF (gmf_get_mappings.my_accounts(i).acct_ttl_type = v_acct_ttl_type) THEN
1052: RETURN(nvl(gmf_get_mappings.my_accounts(i).acct_id,0));
1053: END IF;
1054: END LOOP;
1055: ELSE
1056: RETURN(-1); /* No row retrieved.*/

Line 1647: END GMF_GET_MAPPINGS;

1643: RETURN l_opm_account_err;
1644:
1645: END parse_ccid;
1646:
1647: END GMF_GET_MAPPINGS;