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

Line 428: cur:= dbms_sql.open_cursor;

424: --
425: -- Open the cursor before we enter the loop so that it doesn't get
426: -- opened multiple times.
427: --
428: cur:= dbms_sql.open_cursor;
429:
430: --
431: -- Go through all the values and if any value has changed then only take some action
432: --

Line 503: dbms_sql.parse(cur, l_statement,DBMS_SQL.NATIVE);

499: ',P_USER_ROW_USER_KEY => :USER_ROW_USER_KEY ' ||
500: ',P_USER_COLUMN_USER_KEY => :USER_COLUMN_USER_KEY );' ||
501: ' END;' ;
502:
503: dbms_sql.parse(cur, l_statement,DBMS_SQL.NATIVE);
504: dbms_sql.bind_variable(cur,'batch_id',p_batch_id);
505: dbms_sql.bind_variable(cur,'data_pump_batch_line_id',l_batch_line_id);
506: dbms_sql.bind_variable(cur,'user_sequence',40);
507: dbms_sql.bind_variable(cur,'link_value',l_link_value);

Line 504: dbms_sql.bind_variable(cur,'batch_id',p_batch_id);

500: ',P_USER_COLUMN_USER_KEY => :USER_COLUMN_USER_KEY );' ||
501: ' END;' ;
502:
503: dbms_sql.parse(cur, l_statement,DBMS_SQL.NATIVE);
504: dbms_sql.bind_variable(cur,'batch_id',p_batch_id);
505: dbms_sql.bind_variable(cur,'data_pump_batch_line_id',l_batch_line_id);
506: dbms_sql.bind_variable(cur,'user_sequence',40);
507: dbms_sql.bind_variable(cur,'link_value',l_link_value);
508: dbms_sql.bind_variable(cur,'data_pump_business_grp_name',p_data_pump_business_grp_name);

Line 505: dbms_sql.bind_variable(cur,'data_pump_batch_line_id',l_batch_line_id);

501: ' END;' ;
502:
503: dbms_sql.parse(cur, l_statement,DBMS_SQL.NATIVE);
504: dbms_sql.bind_variable(cur,'batch_id',p_batch_id);
505: dbms_sql.bind_variable(cur,'data_pump_batch_line_id',l_batch_line_id);
506: dbms_sql.bind_variable(cur,'user_sequence',40);
507: dbms_sql.bind_variable(cur,'link_value',l_link_value);
508: dbms_sql.bind_variable(cur,'data_pump_business_grp_name',p_data_pump_business_grp_name);
509: dbms_sql.bind_variable(cur,'EFFECTIVE_DATE',P_EFFECTIVE_DATE);

Line 506: dbms_sql.bind_variable(cur,'user_sequence',40);

502:
503: dbms_sql.parse(cur, l_statement,DBMS_SQL.NATIVE);
504: dbms_sql.bind_variable(cur,'batch_id',p_batch_id);
505: dbms_sql.bind_variable(cur,'data_pump_batch_line_id',l_batch_line_id);
506: dbms_sql.bind_variable(cur,'user_sequence',40);
507: dbms_sql.bind_variable(cur,'link_value',l_link_value);
508: dbms_sql.bind_variable(cur,'data_pump_business_grp_name',p_data_pump_business_grp_name);
509: dbms_sql.bind_variable(cur,'EFFECTIVE_DATE',P_EFFECTIVE_DATE);
510: dbms_sql.bind_variable(cur,'VALUE',l_user_column_user_keys(i).user_column_value);

Line 507: dbms_sql.bind_variable(cur,'link_value',l_link_value);

503: dbms_sql.parse(cur, l_statement,DBMS_SQL.NATIVE);
504: dbms_sql.bind_variable(cur,'batch_id',p_batch_id);
505: dbms_sql.bind_variable(cur,'data_pump_batch_line_id',l_batch_line_id);
506: dbms_sql.bind_variable(cur,'user_sequence',40);
507: dbms_sql.bind_variable(cur,'link_value',l_link_value);
508: dbms_sql.bind_variable(cur,'data_pump_business_grp_name',p_data_pump_business_grp_name);
509: dbms_sql.bind_variable(cur,'EFFECTIVE_DATE',P_EFFECTIVE_DATE);
510: dbms_sql.bind_variable(cur,'VALUE',l_user_column_user_keys(i).user_column_value);
511: dbms_sql.bind_variable(cur,'USER_ROW_USER_KEY',l_user_row_user_key);

Line 508: dbms_sql.bind_variable(cur,'data_pump_business_grp_name',p_data_pump_business_grp_name);

504: dbms_sql.bind_variable(cur,'batch_id',p_batch_id);
505: dbms_sql.bind_variable(cur,'data_pump_batch_line_id',l_batch_line_id);
506: dbms_sql.bind_variable(cur,'user_sequence',40);
507: dbms_sql.bind_variable(cur,'link_value',l_link_value);
508: dbms_sql.bind_variable(cur,'data_pump_business_grp_name',p_data_pump_business_grp_name);
509: dbms_sql.bind_variable(cur,'EFFECTIVE_DATE',P_EFFECTIVE_DATE);
510: dbms_sql.bind_variable(cur,'VALUE',l_user_column_user_keys(i).user_column_value);
511: dbms_sql.bind_variable(cur,'USER_ROW_USER_KEY',l_user_row_user_key);
512: dbms_sql.bind_variable(cur,'USER_COLUMN_USER_KEY',l_user_column_user_keys(i).user_column_key);

Line 509: dbms_sql.bind_variable(cur,'EFFECTIVE_DATE',P_EFFECTIVE_DATE);

505: dbms_sql.bind_variable(cur,'data_pump_batch_line_id',l_batch_line_id);
506: dbms_sql.bind_variable(cur,'user_sequence',40);
507: dbms_sql.bind_variable(cur,'link_value',l_link_value);
508: dbms_sql.bind_variable(cur,'data_pump_business_grp_name',p_data_pump_business_grp_name);
509: dbms_sql.bind_variable(cur,'EFFECTIVE_DATE',P_EFFECTIVE_DATE);
510: dbms_sql.bind_variable(cur,'VALUE',l_user_column_user_keys(i).user_column_value);
511: dbms_sql.bind_variable(cur,'USER_ROW_USER_KEY',l_user_row_user_key);
512: dbms_sql.bind_variable(cur,'USER_COLUMN_USER_KEY',l_user_column_user_keys(i).user_column_key);
513:

Line 510: dbms_sql.bind_variable(cur,'VALUE',l_user_column_user_keys(i).user_column_value);

506: dbms_sql.bind_variable(cur,'user_sequence',40);
507: dbms_sql.bind_variable(cur,'link_value',l_link_value);
508: dbms_sql.bind_variable(cur,'data_pump_business_grp_name',p_data_pump_business_grp_name);
509: dbms_sql.bind_variable(cur,'EFFECTIVE_DATE',P_EFFECTIVE_DATE);
510: dbms_sql.bind_variable(cur,'VALUE',l_user_column_user_keys(i).user_column_value);
511: dbms_sql.bind_variable(cur,'USER_ROW_USER_KEY',l_user_row_user_key);
512: dbms_sql.bind_variable(cur,'USER_COLUMN_USER_KEY',l_user_column_user_keys(i).user_column_key);
513:
514: l_ret_status := dbms_sql.execute (cur);

Line 511: dbms_sql.bind_variable(cur,'USER_ROW_USER_KEY',l_user_row_user_key);

507: dbms_sql.bind_variable(cur,'link_value',l_link_value);
508: dbms_sql.bind_variable(cur,'data_pump_business_grp_name',p_data_pump_business_grp_name);
509: dbms_sql.bind_variable(cur,'EFFECTIVE_DATE',P_EFFECTIVE_DATE);
510: dbms_sql.bind_variable(cur,'VALUE',l_user_column_user_keys(i).user_column_value);
511: dbms_sql.bind_variable(cur,'USER_ROW_USER_KEY',l_user_row_user_key);
512: dbms_sql.bind_variable(cur,'USER_COLUMN_USER_KEY',l_user_column_user_keys(i).user_column_key);
513:
514: l_ret_status := dbms_sql.execute (cur);
515: end if;

Line 512: dbms_sql.bind_variable(cur,'USER_COLUMN_USER_KEY',l_user_column_user_keys(i).user_column_key);

508: dbms_sql.bind_variable(cur,'data_pump_business_grp_name',p_data_pump_business_grp_name);
509: dbms_sql.bind_variable(cur,'EFFECTIVE_DATE',P_EFFECTIVE_DATE);
510: dbms_sql.bind_variable(cur,'VALUE',l_user_column_user_keys(i).user_column_value);
511: dbms_sql.bind_variable(cur,'USER_ROW_USER_KEY',l_user_row_user_key);
512: dbms_sql.bind_variable(cur,'USER_COLUMN_USER_KEY',l_user_column_user_keys(i).user_column_key);
513:
514: l_ret_status := dbms_sql.execute (cur);
515: end if;
516: end if;

Line 514: l_ret_status := dbms_sql.execute (cur);

510: dbms_sql.bind_variable(cur,'VALUE',l_user_column_user_keys(i).user_column_value);
511: dbms_sql.bind_variable(cur,'USER_ROW_USER_KEY',l_user_row_user_key);
512: dbms_sql.bind_variable(cur,'USER_COLUMN_USER_KEY',l_user_column_user_keys(i).user_column_key);
513:
514: l_ret_status := dbms_sql.execute (cur);
515: end if;
516: end if;
517: end loop;
518: dbms_sql.close_cursor (cur);

Line 518: dbms_sql.close_cursor (cur);

514: l_ret_status := dbms_sql.execute (cur);
515: end if;
516: end if;
517: end loop;
518: dbms_sql.close_cursor (cur);
519: commit;
520: end create_data_pump_batch_lines;
521:
522: --