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_EVENTS_WRAPPER dependencies on PAY_INTERPRETER_PKG

Line 53: Ed Jones 02-Jun-2003 115.11 2984406 Moved pay_interpreter_pkg.event_group_tables

49: updates to supervisor as well as
50: corrections.
51: Ed Jones 10-Apr-2003 115.10 Changes to pick up correct start date
52: for updated supervisor correctly
53: Ed Jones 02-Jun-2003 115.11 2984406 Moved pay_interpreter_pkg.event_group_tables
54: call and reset of g_DATED_TABLE_EXTRAS
55: cache to a separate procedure (from
56: get_event_details) so that it's only
57: called once per run.

Line 429: IF NVL(pay_interpreter_pkg.t_distinct_tab.FIRST,0) > 0 THEN

425: --
426: -- Try to find the table the event occurred on in the cache
427: l_tab_idx := -1;
428: --
429: IF NVL(pay_interpreter_pkg.t_distinct_tab.FIRST,0) > 0 THEN
430: FOR k IN pay_interpreter_pkg.t_distinct_tab.FIRST .. pay_interpreter_pkg.t_distinct_tab.LAST LOOP
431: IF pay_interpreter_pkg.t_distinct_tab(k).table_id = p_dated_table_id THEN
432: msg('Found dated table '||p_dated_table_id||' at index '||k);
433: l_tab_idx := k;

Line 430: FOR k IN pay_interpreter_pkg.t_distinct_tab.FIRST .. pay_interpreter_pkg.t_distinct_tab.LAST LOOP

426: -- Try to find the table the event occurred on in the cache
427: l_tab_idx := -1;
428: --
429: IF NVL(pay_interpreter_pkg.t_distinct_tab.FIRST,0) > 0 THEN
430: FOR k IN pay_interpreter_pkg.t_distinct_tab.FIRST .. pay_interpreter_pkg.t_distinct_tab.LAST LOOP
431: IF pay_interpreter_pkg.t_distinct_tab(k).table_id = p_dated_table_id THEN
432: msg('Found dated table '||p_dated_table_id||' at index '||k);
433: l_tab_idx := k;
434: EXIT;

Line 431: IF pay_interpreter_pkg.t_distinct_tab(k).table_id = p_dated_table_id THEN

427: l_tab_idx := -1;
428: --
429: IF NVL(pay_interpreter_pkg.t_distinct_tab.FIRST,0) > 0 THEN
430: FOR k IN pay_interpreter_pkg.t_distinct_tab.FIRST .. pay_interpreter_pkg.t_distinct_tab.LAST LOOP
431: IF pay_interpreter_pkg.t_distinct_tab(k).table_id = p_dated_table_id THEN
432: msg('Found dated table '||p_dated_table_id||' at index '||k);
433: l_tab_idx := k;
434: EXIT;
435: END IF;

Line 473: p_detailed_output IN OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type,

469: p_start_date IN DATE,
470: p_end_date IN DATE,
471: p_assignment_id IN NUMBER,
472: p_element_entry_id IN NUMBER,
473: p_detailed_output IN OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type,
474: p_proration_dates IN OUT NOCOPY pay_interpreter_pkg.t_proration_dates_table_type
475: ) IS
476: -- Business group ID
477: l_business_group_id NUMBER;

Line 474: p_proration_dates IN OUT NOCOPY pay_interpreter_pkg.t_proration_dates_table_type

470: p_end_date IN DATE,
471: p_assignment_id IN NUMBER,
472: p_element_entry_id IN NUMBER,
473: p_detailed_output IN OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type,
474: p_proration_dates IN OUT NOCOPY pay_interpreter_pkg.t_proration_dates_table_type
475: ) IS
476: -- Business group ID
477: l_business_group_id NUMBER;
478: --

Line 481: l_dynamic_sql pay_interpreter_pkg.t_dynamic_sql_tab;

477: l_business_group_id NUMBER;
478: --
479: -- Temporary table variables to hold the results from the event model
480: -- procedure calls. These results aren't used
481: l_dynamic_sql pay_interpreter_pkg.t_dynamic_sql_tab;
482: l_proration_change_type pay_interpreter_pkg.t_proration_type_table_type;
483: l_proration_type pay_interpreter_pkg.t_proration_type_table_type;
484: --
485: BEGIN

Line 482: l_proration_change_type pay_interpreter_pkg.t_proration_type_table_type;

478: --
479: -- Temporary table variables to hold the results from the event model
480: -- procedure calls. These results aren't used
481: l_dynamic_sql pay_interpreter_pkg.t_dynamic_sql_tab;
482: l_proration_change_type pay_interpreter_pkg.t_proration_type_table_type;
483: l_proration_type pay_interpreter_pkg.t_proration_type_table_type;
484: --
485: BEGIN
486: msg('Getting event details for assignment: '||p_assignment_id);

Line 483: l_proration_type pay_interpreter_pkg.t_proration_type_table_type;

479: -- Temporary table variables to hold the results from the event model
480: -- procedure calls. These results aren't used
481: l_dynamic_sql pay_interpreter_pkg.t_dynamic_sql_tab;
482: l_proration_change_type pay_interpreter_pkg.t_proration_type_table_type;
483: l_proration_type pay_interpreter_pkg.t_proration_type_table_type;
484: --
485: BEGIN
486: msg('Getting event details for assignment: '||p_assignment_id);
487: --

Line 496: pay_interpreter_pkg.event_group_tables_affected(

492: -- unique_sort as we do in entry_affected, since we do actually want
493: -- a list of all the events that occurred and the effective date of
494: -- each one, not just the unique dates, since we'll later merge the
495: -- events up to the supervisor level
496: pay_interpreter_pkg.event_group_tables_affected(
497: p_element_entry_id,
498: NULL,
499: g_EVENT_GROUP_ID,
500: p_assignment_id,

Line 517: p_table_info IN pay_interpreter_pkg.t_distinct_table_rec,

513: END get_event_details;
514: --
515: -- Get a flag to indicated whether or not the given table has the requested column
516: PROCEDURE get_column_flag(
517: p_table_info IN pay_interpreter_pkg.t_distinct_table_rec,
518: p_column IN VARCHAR2,
519: p_flag IN OUT NOCOPY VARCHAR2
520: ) IS
521: -- Find the column in the data-dictionary

Line 573: p_rec IN OUT NOCOPY pay_interpreter_pkg.t_distinct_table_rec,

569: -- Set the column flags in the dated table cache and return a copy of
570: -- the record we modified
571: PROCEDURE set_dated_table_column_flags(
572: p_idx IN NUMBER,
573: p_rec IN OUT NOCOPY pay_interpreter_pkg.t_distinct_table_rec,
574: p_xrec IN OUT NOCOPY t_dated_table_extras_rec
575: ) IS
576: BEGIN
577: -- See if there's a supervisor ID on the dated table

Line 579: pay_interpreter_pkg.t_distinct_tab(p_idx),

575: ) IS
576: BEGIN
577: -- See if there's a supervisor ID on the dated table
578: get_column_flag(
579: pay_interpreter_pkg.t_distinct_tab(p_idx),
580: 'SUPERVISOR_ID',
581: g_DATED_TABLE_EXTRAS(p_idx).has_supervisor_id
582: );
583: -- See if there's a location ID on the dated table

Line 585: pay_interpreter_pkg.t_distinct_tab(p_idx),

581: g_DATED_TABLE_EXTRAS(p_idx).has_supervisor_id
582: );
583: -- See if there's a location ID on the dated table
584: get_column_flag(
585: pay_interpreter_pkg.t_distinct_tab(p_idx),
586: 'LOCATION_ID',
587: g_DATED_TABLE_EXTRAS(p_idx).has_location_id
588: );
589: --

Line 592: pay_interpreter_pkg.t_distinct_tab(p_idx),

588: );
589: --
590: -- See if we've got an assignment ID (only really need one if supervisor or location is missing)
591: get_column_flag(
592: pay_interpreter_pkg.t_distinct_tab(p_idx),
593: 'ASSIGNMENT_ID',
594: g_DATED_TABLE_EXTRAS(p_idx).has_assignment_id
595: );
596: --

Line 598: p_rec := pay_interpreter_pkg.t_distinct_tab(p_idx);

594: g_DATED_TABLE_EXTRAS(p_idx).has_assignment_id
595: );
596: --
597: -- Copy the records we updated to the return parameter
598: p_rec := pay_interpreter_pkg.t_distinct_tab(p_idx);
599: p_xrec := g_DATED_TABLE_EXTRAS(p_idx);
600: --
601: END set_dated_table_column_flags;
602: --

Line 614: l_tab_info pay_interpreter_pkg.t_distinct_table_rec;

610: p_want_location IN BOOLEAN,
611: p_sql IN OUT NOCOPY VARCHAR2
612: ) IS
613: --
614: l_tab_info pay_interpreter_pkg.t_distinct_table_rec;
615: l_tab_extra t_dated_table_extras_rec;
616: l_used_skt BOOLEAN := FALSE;
617: l_used_paf BOOLEAN := FALSE;
618: l_tab_idx NUMBER;

Line 825: pay_interpreter_pkg.event_group_tables(g_EVENT_GROUP_ID);

821: CLOSE get_evt;
822: --
823: -- Populate the internal package global caches to hold details of all
824: -- the dated tables that this event group uses
825: pay_interpreter_pkg.event_group_tables(g_EVENT_GROUP_ID);
826: --
827: -- Make sure we've got enough extra information records for all the
828: -- dated tables we're going to use
829: FOR i IN pay_interpreter_pkg.t_distinct_tab.FIRST .. pay_interpreter_pkg.t_distinct_tab.LAST LOOP

Line 829: FOR i IN pay_interpreter_pkg.t_distinct_tab.FIRST .. pay_interpreter_pkg.t_distinct_tab.LAST LOOP

825: pay_interpreter_pkg.event_group_tables(g_EVENT_GROUP_ID);
826: --
827: -- Make sure we've got enough extra information records for all the
828: -- dated tables we're going to use
829: FOR i IN pay_interpreter_pkg.t_distinct_tab.FIRST .. pay_interpreter_pkg.t_distinct_tab.LAST LOOP
830: g_DATED_TABLE_EXTRAS(i).has_supervisor_id := 'X';
831: g_DATED_TABLE_EXTRAS(i).has_location_id := 'X';
832: g_DATED_TABLE_EXTRAS(i).has_assignment_id := 'X';
833: g_DATED_TABLE_EXTRAS(i).sql_statement := NULL;

Line 899: p_detailed_output IN pay_interpreter_pkg.t_detailed_output_table_type,

895: END set_debugging;
896: --
897: -- Process the detailed output information from an assignment event
898: PROCEDURE process_event_details(
899: p_detailed_output IN pay_interpreter_pkg.t_detailed_output_table_type,
900: p_proration_dates IN pay_interpreter_pkg.t_proration_dates_table_type,
901: p_summary_refresh IN OUT NOCOPY t_summary_refresh_tab_type,
902: p_location_stripe IN BOOLEAN DEFAULT FALSE
903: ) IS

Line 900: p_proration_dates IN pay_interpreter_pkg.t_proration_dates_table_type,

896: --
897: -- Process the detailed output information from an assignment event
898: PROCEDURE process_event_details(
899: p_detailed_output IN pay_interpreter_pkg.t_detailed_output_table_type,
900: p_proration_dates IN pay_interpreter_pkg.t_proration_dates_table_type,
901: p_summary_refresh IN OUT NOCOPY t_summary_refresh_tab_type,
902: p_location_stripe IN BOOLEAN DEFAULT FALSE
903: ) IS
904: --

Line 1234: l_detailed_output pay_interpreter_pkg.t_detailed_output_table_type;

1230: p_location_stripe IN BOOLEAN DEFAULT FALSE
1231: ) IS
1232: --
1233: -- Local table-type variables for use with processing the event details
1234: l_detailed_output pay_interpreter_pkg.t_detailed_output_table_type;
1235: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
1236: --
1237: BEGIN
1238: --

Line 1235: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;

1231: ) IS
1232: --
1233: -- Local table-type variables for use with processing the event details
1234: l_detailed_output pay_interpreter_pkg.t_detailed_output_table_type;
1235: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
1236: --
1237: BEGIN
1238: --
1239: -- Check we've got something to process