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_INTERPRETER_PKG dependencies on DBMS_SQL

Line 850: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

846: BEGIN
847:
848: -- The following code creates the dynamic SQL for the column names selected
849: -- above.
850: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
851: hr_utility.trace(p_statement);
852: DBMS_SQL.PARSE(l_cursor_id , p_statement , DBMS_SQL.V7);
853: --
854: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_surrogate_key', p_surrogate_key);

Line 852: DBMS_SQL.PARSE(l_cursor_id , p_statement , DBMS_SQL.V7);

848: -- The following code creates the dynamic SQL for the column names selected
849: -- above.
850: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
851: hr_utility.trace(p_statement);
852: DBMS_SQL.PARSE(l_cursor_id , p_statement , DBMS_SQL.V7);
853: --
854: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_surrogate_key', p_surrogate_key);
855: IF (p_updated_column_name = p_start_date_name) THEN
856: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':col1', p_effective_date - 1);

Line 854: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_surrogate_key', p_surrogate_key);

850: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
851: hr_utility.trace(p_statement);
852: DBMS_SQL.PARSE(l_cursor_id , p_statement , DBMS_SQL.V7);
853: --
854: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_surrogate_key', p_surrogate_key);
855: IF (p_updated_column_name = p_start_date_name) THEN
856: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':col1', p_effective_date - 1);
857: if (g_dbg) then
858: hr_utility.trace('Effective Start Date changed');

Line 856: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':col1', p_effective_date - 1);

852: DBMS_SQL.PARSE(l_cursor_id , p_statement , DBMS_SQL.V7);
853: --
854: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_surrogate_key', p_surrogate_key);
855: IF (p_updated_column_name = p_start_date_name) THEN
856: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':col1', p_effective_date - 1);
857: if (g_dbg) then
858: hr_utility.trace('Effective Start Date changed');
859: hr_utility.trace('date = '||(p_effective_date - 1));
860: hr_utility.trace('key = '||p_surrogate_key);

Line 864: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':col1', p_effective_date);

860: hr_utility.trace('key = '||p_surrogate_key);
861: end if;
862: ELSIF (p_updated_column_name = p_end_date_name) THEN
863: --
864: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':col1', p_effective_date);
865: if (g_dbg) then
866: hr_utility.trace('date = '||p_effective_date);
867: hr_utility.trace('key = '||p_surrogate_key);
868: end if;

Line 874: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, l_counter, t_dynamic_sql(l_counter).old_value, 100);

870: END IF;
871:
872: FOR l_counter IN 1..p_dynamic_counter
873: LOOP
874: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, l_counter, t_dynamic_sql(l_counter).old_value, 100);
875: END LOOP;
876:
877: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
878:

Line 877: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);

873: LOOP
874: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, l_counter, t_dynamic_sql(l_counter).old_value, 100);
875: END LOOP;
876:
877: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
878:
879: LOOP
880: -- This loop will always return a single row or no row
881: l_old_sql_fetch := 0;

Line 882: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN

878:
879: LOOP
880: -- This loop will always return a single row or no row
881: l_old_sql_fetch := 0;
882: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
883: EXIT;
884: END IF;
885:
886: -- The following loop executes for all the columns

Line 894: DBMS_SQL.COLUMN_VALUE(l_cursor_id, l_counter, t_dynamic_sql(l_counter).old_value);

890: -- l_old_sql_fetch variable will become = 1 whenever the
891: -- LOOP is executed. Whenever l_old_sql_fetch becomes = 1,
892: -- It means that a row is fetched from the cursor. This
893: -- variable will be used to decide whether a Delete event occured.
894: DBMS_SQL.COLUMN_VALUE(l_cursor_id, l_counter, t_dynamic_sql(l_counter).old_value);
895: END LOOP;
896: END LOOP;
897:
898: IF (p_updated_column_name = p_start_date_name) THEN

Line 899: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':col1', p_effective_date);

895: END LOOP;
896: END LOOP;
897:
898: IF (p_updated_column_name = p_start_date_name) THEN
899: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':col1', p_effective_date);
900: p_final_effective_date := p_effective_date;
901: if (g_dbg) then
902: hr_utility.trace('Effective Start Date changed');
903: hr_utility.trace('date = '||p_effective_date);

Line 907: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':col1', p_effective_date + 1);

903: hr_utility.trace('date = '||p_effective_date);
904: hr_utility.trace('key = '||p_surrogate_key);
905: end if;
906: ELSIF (p_updated_column_name = p_end_date_name) THEN
907: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':col1', p_effective_date + 1);
908: p_final_effective_date := p_effective_date + 1;
909: if (g_dbg) then
910: hr_utility.trace('Effective End Date changed');
911: hr_utility.trace('date = '||(p_effective_date + 1));

Line 920: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, l_counter,

916: -- The following loop executes for all the columns
917:
918: FOR l_counter IN 1..p_dynamic_counter
919: LOOP
920: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, l_counter,
921: t_dynamic_sql(l_counter).new_value, 100);
922: END LOOP;
923: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
924:

Line 923: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);

919: LOOP
920: DBMS_SQL.DEFINE_COLUMN(l_cursor_id, l_counter,
921: t_dynamic_sql(l_counter).new_value, 100);
922: END LOOP;
923: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
924:
925: if (g_dbg) then
926: hr_utility.trace('Second statement executed ');
927: end if;

Line 935: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN

931: -- This loop will always return a single row or no row
932:
933: l_new_sql_fetch := 0;
934:
935: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
936: EXIT;
937: END IF;
938:
939: FOR l_counter IN 1..p_dynamic_counter

Line 942: DBMS_SQL.COLUMN_VALUE(l_cursor_id, l_counter,t_dynamic_sql(l_counter).new_value);

938:
939: FOR l_counter IN 1..p_dynamic_counter
940: LOOP
941: l_new_sql_fetch := 1;
942: DBMS_SQL.COLUMN_VALUE(l_cursor_id, l_counter,t_dynamic_sql(l_counter).new_value);
943: if (g_traces) then
944: hr_utility.trace('old = '||t_dynamic_sql(l_counter).old_value||' new = '||t_dynamic_sql(l_counter).new_value);
945: end if;
946:

Line 950: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

946:
947: END LOOP;
948: END LOOP;
949:
950: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
951: END;
952:
953: PROCEDURE add_event_procedure
954: (

Line 1173: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

1169: 'p_output_result => :col7,' ||
1170: 'p_date => :col8' ||
1171: '); END;';
1172:
1173: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
1174:
1175: if (g_dbg) then
1176: hr_utility.trace('Parameters');
1177: hr_utility.trace('p_surrogate_key = '||p_surrogate_key);

Line 1184: DBMS_SQL.PARSE(l_cursor_id, l_proc_string, DBMS_SQL.V7);

1180: hr_utility.trace('p_column_name = '||p_column_name);
1181: hr_utility.trace('p_old_value = '||p_old_value);
1182: hr_utility.trace('p_new_value = '||p_new_value);
1183: end if;
1184: DBMS_SQL.PARSE(l_cursor_id, l_proc_string, DBMS_SQL.V7);
1185:
1186: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col1',p_surrogate_key);
1187:
1188: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col2', p_element_entry_id);

Line 1186: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col1',p_surrogate_key);

1182: hr_utility.trace('p_new_value = '||p_new_value);
1183: end if;
1184: DBMS_SQL.PARSE(l_cursor_id, l_proc_string, DBMS_SQL.V7);
1185:
1186: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col1',p_surrogate_key);
1187:
1188: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col2', p_element_entry_id);
1189: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col3', p_assignment_action_id);
1190: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col4', p_column_name);

Line 1188: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col2', p_element_entry_id);

1184: DBMS_SQL.PARSE(l_cursor_id, l_proc_string, DBMS_SQL.V7);
1185:
1186: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col1',p_surrogate_key);
1187:
1188: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col2', p_element_entry_id);
1189: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col3', p_assignment_action_id);
1190: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col4', p_column_name);
1191: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col5', p_old_value);
1192: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col6', p_new_value);

Line 1189: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col3', p_assignment_action_id);

1185:
1186: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col1',p_surrogate_key);
1187:
1188: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col2', p_element_entry_id);
1189: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col3', p_assignment_action_id);
1190: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col4', p_column_name);
1191: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col5', p_old_value);
1192: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col6', p_new_value);
1193: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col7', p_output_result, 40);

Line 1190: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col4', p_column_name);

1186: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col1',p_surrogate_key);
1187:
1188: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col2', p_element_entry_id);
1189: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col3', p_assignment_action_id);
1190: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col4', p_column_name);
1191: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col5', p_old_value);
1192: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col6', p_new_value);
1193: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col7', p_output_result, 40);
1194: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col8', p_final_effective_date);

Line 1191: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col5', p_old_value);

1187:
1188: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col2', p_element_entry_id);
1189: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col3', p_assignment_action_id);
1190: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col4', p_column_name);
1191: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col5', p_old_value);
1192: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col6', p_new_value);
1193: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col7', p_output_result, 40);
1194: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col8', p_final_effective_date);
1195: if (g_dbg) then

Line 1192: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col6', p_new_value);

1188: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col2', p_element_entry_id);
1189: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col3', p_assignment_action_id);
1190: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col4', p_column_name);
1191: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col5', p_old_value);
1192: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col6', p_new_value);
1193: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col7', p_output_result, 40);
1194: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col8', p_final_effective_date);
1195: if (g_dbg) then
1196: hr_utility.trace('All Variables Bound');

Line 1193: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col7', p_output_result, 40);

1189: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col3', p_assignment_action_id);
1190: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col4', p_column_name);
1191: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col5', p_old_value);
1192: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col6', p_new_value);
1193: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col7', p_output_result, 40);
1194: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col8', p_final_effective_date);
1195: if (g_dbg) then
1196: hr_utility.trace('All Variables Bound');
1197: end if;

Line 1194: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col8', p_final_effective_date);

1190: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col4', p_column_name);
1191: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col5', p_old_value);
1192: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col6', p_new_value);
1193: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col7', p_output_result, 40);
1194: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col8', p_final_effective_date);
1195: if (g_dbg) then
1196: hr_utility.trace('All Variables Bound');
1197: end if;
1198:

Line 1199: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);

1195: if (g_dbg) then
1196: hr_utility.trace('All Variables Bound');
1197: end if;
1198:
1199: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
1200:
1201: if (g_dbg) then
1202: hr_utility.trace('Procedure Executed');
1203: end if;

Line 1205: DBMS_SQL.VARIABLE_VALUE(l_cursor_id, ':col7', p_output_result);

1201: if (g_dbg) then
1202: hr_utility.trace('Procedure Executed');
1203: end if;
1204:
1205: DBMS_SQL.VARIABLE_VALUE(l_cursor_id, ':col7', p_output_result);
1206: --hr_utility.trace('Got Results');
1207:
1208: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
1209:

Line 1208: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

1204:
1205: DBMS_SQL.VARIABLE_VALUE(l_cursor_id, ':col7', p_output_result);
1206: --hr_utility.trace('Got Results');
1207:
1208: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
1209:
1210: --hr_utility.trace('Closed cursor');
1211:
1212: IF (p_output_result = 'FALSE') THEN

Line 1976: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

1972: l_proc_string := 'BEGIN :res := ' || g_tim_def_prc_name || '(' ||
1973: 'p_assignment_action_id => :aa' ||
1974: '); END;';
1975:
1976: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
1977:
1978: if (g_dbg) then
1979: hr_utility.trace('Parameters');
1980: end if;

Line 1982: DBMS_SQL.PARSE(l_cursor_id, l_proc_string, DBMS_SQL.V7);

1978: if (g_dbg) then
1979: hr_utility.trace('Parameters');
1980: end if;
1981:
1982: DBMS_SQL.PARSE(l_cursor_id, l_proc_string, DBMS_SQL.V7);
1983:
1984: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':res', l_res);
1985: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':aa',p_assignment_action_id);
1986:

Line 1984: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':res', l_res);

1980: end if;
1981:
1982: DBMS_SQL.PARSE(l_cursor_id, l_proc_string, DBMS_SQL.V7);
1983:
1984: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':res', l_res);
1985: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':aa',p_assignment_action_id);
1986:
1987: if (g_dbg) then
1988: hr_utility.trace('All Variables Bound');

Line 1985: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':aa',p_assignment_action_id);

1981:
1982: DBMS_SQL.PARSE(l_cursor_id, l_proc_string, DBMS_SQL.V7);
1983:
1984: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':res', l_res);
1985: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':aa',p_assignment_action_id);
1986:
1987: if (g_dbg) then
1988: hr_utility.trace('All Variables Bound');
1989: end if;

Line 1991: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);

1987: if (g_dbg) then
1988: hr_utility.trace('All Variables Bound');
1989: end if;
1990:
1991: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
1992:
1993: if (g_dbg) then
1994: hr_utility.trace('Procedure Executed');
1995: end if;

Line 1997: DBMS_SQL.VARIABLE_VALUE(l_cursor_id, ':res', l_res);

1993: if (g_dbg) then
1994: hr_utility.trace('Procedure Executed');
1995: end if;
1996:
1997: DBMS_SQL.VARIABLE_VALUE(l_cursor_id, ':res', l_res);
1998: --
1999: g_process_time_def := TRUE;
2000: if (l_res = 0) then
2001: g_process_time_def := FALSE;

Line 2006: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

2002: end if;
2003: g_assignment_action_id := p_assignment_action_id;
2004: g_time_definition_id := p_time_definition_id;
2005:
2006: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
2007: end;
2008: end if;
2009: --
2010: return g_process_time_def;