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

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

327: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_ASSET_bind()+');
328:
329: IF PARM.p_end_period_to_date IS NOT NULL THEN
330: FA_RX_UTIL_PKG.debug('Binding b_period_to_date');
331: DBMS_SQL.bind_variable(c, 'b_period_to_date', PARM.p_end_period_to_date);
332: END IF;
333:
334: IF PARM.p_major_category IS NOT NULL THEN
335: FA_RX_UTIL_PKG.debug('Binding major_category');

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

332: END IF;
333:
334: IF PARM.p_major_category IS NOT NULL THEN
335: FA_RX_UTIL_PKG.debug('Binding major_category');
336: DBMS_SQL.bind_variable(c, 'b_major_category', PARM.p_major_category);
337: END IF;
338:
339: IF PARM.p_minor_category IS NOT NULL THEN
340: FA_RX_UTIL_PKG.debug('Binding b_minor_category');

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

337: END IF;
338:
339: IF PARM.p_minor_category IS NOT NULL THEN
340: FA_RX_UTIL_PKG.debug('Binding b_minor_category');
341: DBMS_SQL.bind_variable(c, 'b_minor_category', PARM.p_minor_category);
342: END IF;
343:
344: IF PARM.p_book_type_code IS NOT NULL THEN
345: FA_RX_UTIL_PKG.debug('Binding b_book_type_code');

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

342: END IF;
343:
344: IF PARM.p_book_type_code IS NOT NULL THEN
345: FA_RX_UTIL_PKG.debug('Binding b_book_type_code');
346: DBMS_SQL.bind_variable(c, 'b_book_type_code', PARM.p_book_type_code);
347: END IF;
348:
349: IF PARM.p_fiscal_year_start_date IS NOT NULL THEN
350: FA_RX_UTIL_PKG.debug('Binding b_fiscal_year_start_date');

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

347: END IF;
348:
349: IF PARM.p_fiscal_year_start_date IS NOT NULL THEN
350: FA_RX_UTIL_PKG.debug('Binding b_fiscal_year_start_date');
351: DBMS_SQL.bind_variable(c, 'b_fiscal_year_start_date', PARM.p_fiscal_year_start_date);
352: END IF;
353:
354:
355: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_ASSET_bind()-');

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

566: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_RTRMNT_bind()+');
567:
568: IF PARM.p_begin_period_from_date IS NOT NULL THEN
569: FA_RX_UTIL_PKG.debug('Binding b_period_from_date');
570: DBMS_SQL.bind_variable(c, 'b_period_from_date', PARM.p_begin_period_from_date);
571: END IF;
572:
573: IF PARM.p_end_period_to_date IS NOT NULL THEN
574: FA_RX_UTIL_PKG.debug('Binding b_period_to_date');

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

571: END IF;
572:
573: IF PARM.p_end_period_to_date IS NOT NULL THEN
574: FA_RX_UTIL_PKG.debug('Binding b_period_to_date');
575: DBMS_SQL.bind_variable(c, 'b_period_to_date', PARM.p_end_period_to_date);
576: END IF;
577:
578: IF PARM.p_major_category IS NOT NULL THEN
579: FA_RX_UTIL_PKG.debug('Binding major_category');

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

576: END IF;
577:
578: IF PARM.p_major_category IS NOT NULL THEN
579: FA_RX_UTIL_PKG.debug('Binding major_category');
580: DBMS_SQL.bind_variable(c, 'b_major_category', PARM.p_major_category);
581: END IF;
582:
583: IF PARM.p_minor_category IS NOT NULL THEN
584: FA_RX_UTIL_PKG.debug('Binding b_minor_category');

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

581: END IF;
582:
583: IF PARM.p_minor_category IS NOT NULL THEN
584: FA_RX_UTIL_PKG.debug('Binding b_minor_category');
585: DBMS_SQL.bind_variable(c, 'b_minor_category', PARM.p_minor_category);
586: END IF;
587:
588: IF PARM.p_book_type_code IS NOT NULL THEN
589: FA_RX_UTIL_PKG.debug('Binding b_book_type_code');

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

586: END IF;
587:
588: IF PARM.p_book_type_code IS NOT NULL THEN
589: FA_RX_UTIL_PKG.debug('Binding b_book_type_code');
590: DBMS_SQL.bind_variable(c, 'b_book_type_code', PARM.p_book_type_code);
591: END IF;
592:
593: FA_RX_UTIL_PKG.debug('JGRX_FAREG.fa_RTRMNT_bind()-');
594:

Line 979: v_cursorId := DBMS_SQL.OPEN_CURSOR;

975: v_dummy integer ;
976: BEGIN
977: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_Deprn_Account()+');
978: JGRX_FAREG.var.expense_account := NULL;
979: v_cursorId := DBMS_SQL.OPEN_CURSOR;
980: v_Selectstmnt1 :=
981: 'select '||X_account_segment||' from '||
982: ' fa_distribution_history dih,'||
983: ' gl_code_combinations gcc'||

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

992: ' dih1.book_type_code =dih.book_type_code and'||
993: ' dih1.transaction_header_id_in = trh.transaction_header_id and';
994: v_selectstmnt3 := ' transaction_date_entered <= '||''''||PARM.p_end_period_to_date||''''||')';
995:
996: DBMS_SQL.PARSE(V_cursorId,v_selectstmnt1||v_selectstmnt2||v_selectstmnt3,DBMS_SQL.V7);
997: DBMS_SQL.DEFINE_COLUMN(V_cursorId,1,V_expense_account,100);
998: V_DUMMY := DBMS_SQL.EXECUTE(V_cursorId);
999: LOOP
1000: IF DBMS_SQL.FETCH_ROWS(V_cursorId) = 0 THEN

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

993: ' dih1.transaction_header_id_in = trh.transaction_header_id and';
994: v_selectstmnt3 := ' transaction_date_entered <= '||''''||PARM.p_end_period_to_date||''''||')';
995:
996: DBMS_SQL.PARSE(V_cursorId,v_selectstmnt1||v_selectstmnt2||v_selectstmnt3,DBMS_SQL.V7);
997: DBMS_SQL.DEFINE_COLUMN(V_cursorId,1,V_expense_account,100);
998: V_DUMMY := DBMS_SQL.EXECUTE(V_cursorId);
999: LOOP
1000: IF DBMS_SQL.FETCH_ROWS(V_cursorId) = 0 THEN
1001: EXIT;

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

994: v_selectstmnt3 := ' transaction_date_entered <= '||''''||PARM.p_end_period_to_date||''''||')';
995:
996: DBMS_SQL.PARSE(V_cursorId,v_selectstmnt1||v_selectstmnt2||v_selectstmnt3,DBMS_SQL.V7);
997: DBMS_SQL.DEFINE_COLUMN(V_cursorId,1,V_expense_account,100);
998: V_DUMMY := DBMS_SQL.EXECUTE(V_cursorId);
999: LOOP
1000: IF DBMS_SQL.FETCH_ROWS(V_cursorId) = 0 THEN
1001: EXIT;
1002: END IF;

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

996: DBMS_SQL.PARSE(V_cursorId,v_selectstmnt1||v_selectstmnt2||v_selectstmnt3,DBMS_SQL.V7);
997: DBMS_SQL.DEFINE_COLUMN(V_cursorId,1,V_expense_account,100);
998: V_DUMMY := DBMS_SQL.EXECUTE(V_cursorId);
999: LOOP
1000: IF DBMS_SQL.FETCH_ROWS(V_cursorId) = 0 THEN
1001: EXIT;
1002: END IF;
1003: DBMS_SQL.COLUMN_VALUE(V_cursorId,1,V_expense_account);
1004: JGRX_FAREG.var.expense_account:= JGRX_FAREG.var.expense_account||V_expense_account;

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

999: LOOP
1000: IF DBMS_SQL.FETCH_ROWS(V_cursorId) = 0 THEN
1001: EXIT;
1002: END IF;
1003: DBMS_SQL.COLUMN_VALUE(V_cursorId,1,V_expense_account);
1004: JGRX_FAREG.var.expense_account:= JGRX_FAREG.var.expense_account||V_expense_account;
1005: END LOOP;
1006: dbms_sql.close_cursor(v_cursorId);
1007: FA_RX_UTIL_PKG.debug('JGRX_FAREG.expense_account = ' || JGRX_FAREG.var.expense_account);

Line 1006: dbms_sql.close_cursor(v_cursorId);

1002: END IF;
1003: DBMS_SQL.COLUMN_VALUE(V_cursorId,1,V_expense_account);
1004: JGRX_FAREG.var.expense_account:= JGRX_FAREG.var.expense_account||V_expense_account;
1005: END LOOP;
1006: dbms_sql.close_cursor(v_cursorId);
1007: FA_RX_UTIL_PKG.debug('JGRX_FAREG.expense_account = ' || JGRX_FAREG.var.expense_account);
1008: FA_RX_UTIL_PKG.debug('JGRX_FAREG.Get_depr_account()-');
1009: END Get_deprn_accounts;
1010: