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.JG_RX_FAREG dependencies on DBMS_SQL

Line 353: DBMS_SQL.bind_variable(c, 'b_period_to_date', PARM.p_end_period_to_date);

349: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.fa_ASSET_bind()+');
350:
351: IF PARM.p_end_period_to_date IS NOT NULL THEN
352: FA_RX_UTIL_PKG.debug('Binding b_period_to_date');
353: DBMS_SQL.bind_variable(c, 'b_period_to_date', PARM.p_end_period_to_date);
354: END IF;
355:
356: IF PARM.p_major_category IS NOT NULL THEN
357: FA_RX_UTIL_PKG.debug('Binding major_category');

Line 358: DBMS_SQL.bind_variable(c, 'b_major_category', PARM.p_major_category);

354: END IF;
355:
356: IF PARM.p_major_category IS NOT NULL THEN
357: FA_RX_UTIL_PKG.debug('Binding major_category');
358: DBMS_SQL.bind_variable(c, 'b_major_category', PARM.p_major_category);
359: END IF;
360:
361: IF PARM.p_minor_category IS NOT NULL THEN
362: FA_RX_UTIL_PKG.debug('Binding b_minor_category');

Line 363: DBMS_SQL.bind_variable(c, 'b_minor_category', PARM.p_minor_category);

359: END IF;
360:
361: IF PARM.p_minor_category IS NOT NULL THEN
362: FA_RX_UTIL_PKG.debug('Binding b_minor_category');
363: DBMS_SQL.bind_variable(c, 'b_minor_category', PARM.p_minor_category);
364: END IF;
365:
366: IF PARM.p_book_type_code IS NOT NULL THEN
367: FA_RX_UTIL_PKG.debug('Binding b_book_type_code '|| PARM.p_book_type_code);

Line 368: DBMS_SQL.bind_variable(c, 'b_book_type_code', PARM.p_book_type_code);

364: END IF;
365:
366: IF PARM.p_book_type_code IS NOT NULL THEN
367: FA_RX_UTIL_PKG.debug('Binding b_book_type_code '|| PARM.p_book_type_code);
368: DBMS_SQL.bind_variable(c, 'b_book_type_code', PARM.p_book_type_code);
369: END IF;
370:
371: IF PARM.p_fiscal_year_start_date IS NOT NULL THEN
372: FA_RX_UTIL_PKG.debug('Binding b_fiscal_year_start_date'|| to_char( PARM.p_fiscal_year_start_date ,'DD/MM/YY'));

Line 373: DBMS_SQL.bind_variable(c, 'b_fiscal_year_start_date', PARM.p_fiscal_year_start_date);

369: END IF;
370:
371: IF PARM.p_fiscal_year_start_date IS NOT NULL THEN
372: FA_RX_UTIL_PKG.debug('Binding b_fiscal_year_start_date'|| to_char( PARM.p_fiscal_year_start_date ,'DD/MM/YY'));
373: DBMS_SQL.bind_variable(c, 'b_fiscal_year_start_date', PARM.p_fiscal_year_start_date);
374: END IF;
375:
376:
377: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.fa_ASSET_bind()-');

Line 659: DBMS_SQL.bind_variable(c, 'b_period_from_date', PARM.p_begin_period_from_date);

655: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.fa_RTRMNT_bind()+');
656:
657: IF PARM.p_begin_period_from_date IS NOT NULL THEN
658: FA_RX_UTIL_PKG.debug('Binding b_period_from_date');
659: DBMS_SQL.bind_variable(c, 'b_period_from_date', PARM.p_begin_period_from_date);
660: END IF;
661:
662: IF PARM.p_end_period_to_date IS NOT NULL THEN
663: FA_RX_UTIL_PKG.debug('Binding b_period_to_date');

Line 664: DBMS_SQL.bind_variable(c, 'b_period_to_date', PARM.p_end_period_to_date);

660: END IF;
661:
662: IF PARM.p_end_period_to_date IS NOT NULL THEN
663: FA_RX_UTIL_PKG.debug('Binding b_period_to_date');
664: DBMS_SQL.bind_variable(c, 'b_period_to_date', PARM.p_end_period_to_date);
665: END IF;
666:
667: IF PARM.p_major_category IS NOT NULL THEN
668: FA_RX_UTIL_PKG.debug('Binding major_category');

Line 669: DBMS_SQL.bind_variable(c, 'b_major_category', PARM.p_major_category);

665: END IF;
666:
667: IF PARM.p_major_category IS NOT NULL THEN
668: FA_RX_UTIL_PKG.debug('Binding major_category');
669: DBMS_SQL.bind_variable(c, 'b_major_category', PARM.p_major_category);
670: END IF;
671:
672: IF PARM.p_minor_category IS NOT NULL THEN
673: FA_RX_UTIL_PKG.debug('Binding b_minor_category');

Line 674: DBMS_SQL.bind_variable(c, 'b_minor_category', PARM.p_minor_category);

670: END IF;
671:
672: IF PARM.p_minor_category IS NOT NULL THEN
673: FA_RX_UTIL_PKG.debug('Binding b_minor_category');
674: DBMS_SQL.bind_variable(c, 'b_minor_category', PARM.p_minor_category);
675: END IF;
676:
677: IF PARM.p_book_type_code IS NOT NULL THEN
678: FA_RX_UTIL_PKG.debug('Binding b_book_type_code');

Line 679: DBMS_SQL.bind_variable(c, 'b_book_type_code', PARM.p_book_type_code);

675: END IF;
676:
677: IF PARM.p_book_type_code IS NOT NULL THEN
678: FA_RX_UTIL_PKG.debug('Binding b_book_type_code');
679: DBMS_SQL.bind_variable(c, 'b_book_type_code', PARM.p_book_type_code);
680: END IF;
681:
682: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.fa_RTRMNT_bind()-');
683:

Line 1228: v_cursorId := DBMS_SQL.OPEN_CURSOR;

1224: v_dummy integer ;
1225: BEGIN
1226: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_Deprn_Account()+');
1227: JG_RX_FAREG.var.expense_account := NULL;
1228: v_cursorId := DBMS_SQL.OPEN_CURSOR;
1229: v_Selectstmnt1 :=
1230: 'select distinct '||X_account_segment||' from '||
1231: ' fa_distribution_history dih,'||
1232: ' gl_code_combinations gcc'||

Line 1245: DBMS_SQL.PARSE(V_cursorId,v_selectstmnt1||v_selectstmnt2||v_selectstmnt3,DBMS_SQL.V7);

1241: ' dih1.book_type_code =dih.book_type_code and'||
1242: ' dih1.transaction_header_id_in = trh.transaction_header_id and';
1243: v_selectstmnt3 := ' transaction_date_entered <= '||''''||PARM.p_end_period_to_date||''''||')';
1244:
1245: DBMS_SQL.PARSE(V_cursorId,v_selectstmnt1||v_selectstmnt2||v_selectstmnt3,DBMS_SQL.V7);
1246: DBMS_SQL.DEFINE_COLUMN(V_cursorId,1,V_expense_account,100);
1247: V_DUMMY := DBMS_SQL.EXECUTE(V_cursorId);
1248: LOOP
1249: IF DBMS_SQL.FETCH_ROWS(V_cursorId) = 0 THEN

Line 1246: DBMS_SQL.DEFINE_COLUMN(V_cursorId,1,V_expense_account,100);

1242: ' dih1.transaction_header_id_in = trh.transaction_header_id and';
1243: v_selectstmnt3 := ' transaction_date_entered <= '||''''||PARM.p_end_period_to_date||''''||')';
1244:
1245: DBMS_SQL.PARSE(V_cursorId,v_selectstmnt1||v_selectstmnt2||v_selectstmnt3,DBMS_SQL.V7);
1246: DBMS_SQL.DEFINE_COLUMN(V_cursorId,1,V_expense_account,100);
1247: V_DUMMY := DBMS_SQL.EXECUTE(V_cursorId);
1248: LOOP
1249: IF DBMS_SQL.FETCH_ROWS(V_cursorId) = 0 THEN
1250: EXIT;

Line 1247: V_DUMMY := DBMS_SQL.EXECUTE(V_cursorId);

1243: v_selectstmnt3 := ' transaction_date_entered <= '||''''||PARM.p_end_period_to_date||''''||')';
1244:
1245: DBMS_SQL.PARSE(V_cursorId,v_selectstmnt1||v_selectstmnt2||v_selectstmnt3,DBMS_SQL.V7);
1246: DBMS_SQL.DEFINE_COLUMN(V_cursorId,1,V_expense_account,100);
1247: V_DUMMY := DBMS_SQL.EXECUTE(V_cursorId);
1248: LOOP
1249: IF DBMS_SQL.FETCH_ROWS(V_cursorId) = 0 THEN
1250: EXIT;
1251: END IF;

Line 1249: IF DBMS_SQL.FETCH_ROWS(V_cursorId) = 0 THEN

1245: DBMS_SQL.PARSE(V_cursorId,v_selectstmnt1||v_selectstmnt2||v_selectstmnt3,DBMS_SQL.V7);
1246: DBMS_SQL.DEFINE_COLUMN(V_cursorId,1,V_expense_account,100);
1247: V_DUMMY := DBMS_SQL.EXECUTE(V_cursorId);
1248: LOOP
1249: IF DBMS_SQL.FETCH_ROWS(V_cursorId) = 0 THEN
1250: EXIT;
1251: END IF;
1252: DBMS_SQL.COLUMN_VALUE(V_cursorId,1,V_expense_account);
1253: JG_RX_FAREG.var.expense_account:= JG_RX_FAREG.var.expense_account||V_expense_account;

Line 1252: DBMS_SQL.COLUMN_VALUE(V_cursorId,1,V_expense_account);

1248: LOOP
1249: IF DBMS_SQL.FETCH_ROWS(V_cursorId) = 0 THEN
1250: EXIT;
1251: END IF;
1252: DBMS_SQL.COLUMN_VALUE(V_cursorId,1,V_expense_account);
1253: JG_RX_FAREG.var.expense_account:= JG_RX_FAREG.var.expense_account||V_expense_account;
1254: END LOOP;
1255: dbms_sql.close_cursor(v_cursorId);
1256: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.expense_account = ' || JG_RX_FAREG.var.expense_account);

Line 1255: dbms_sql.close_cursor(v_cursorId);

1251: END IF;
1252: DBMS_SQL.COLUMN_VALUE(V_cursorId,1,V_expense_account);
1253: JG_RX_FAREG.var.expense_account:= JG_RX_FAREG.var.expense_account||V_expense_account;
1254: END LOOP;
1255: dbms_sql.close_cursor(v_cursorId);
1256: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.expense_account = ' || JG_RX_FAREG.var.expense_account);
1257: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_depr_account()-');
1258: END Get_deprn_accounts;
1259: