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 425: IF NVL(pay_interpreter_pkg.t_distinct_tab.FIRST,0) > 0 THEN

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

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

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

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

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

Line 469: p_detailed_output IN OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type,

465: p_start_date IN DATE,
466: p_end_date IN DATE,
467: p_assignment_id IN NUMBER,
468: p_element_entry_id IN NUMBER,
469: p_detailed_output IN OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type,
470: p_proration_dates IN OUT NOCOPY pay_interpreter_pkg.t_proration_dates_table_type
471: ) IS
472: -- Business group ID
473: l_business_group_id NUMBER;

Line 470: p_proration_dates IN OUT NOCOPY pay_interpreter_pkg.t_proration_dates_table_type

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

Line 477: l_dynamic_sql pay_interpreter_pkg.t_dynamic_sql_tab;

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

Line 478: l_proration_change_type pay_interpreter_pkg.t_proration_type_table_type;

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

Line 479: l_proration_type pay_interpreter_pkg.t_proration_type_table_type;

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

Line 492: pay_interpreter_pkg.event_group_tables_affected(

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

Line 513: p_table_info IN pay_interpreter_pkg.t_distinct_table_rec,

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

Line 555: p_rec IN OUT NOCOPY pay_interpreter_pkg.t_distinct_table_rec,

551: -- Set the column flags in the dated table cache and return a copy of
552: -- the record we modified
553: PROCEDURE set_dated_table_column_flags(
554: p_idx IN NUMBER,
555: p_rec IN OUT NOCOPY pay_interpreter_pkg.t_distinct_table_rec,
556: p_xrec IN OUT NOCOPY t_dated_table_extras_rec
557: ) IS
558: BEGIN
559: -- See if there's a supervisor ID on the dated table

Line 561: pay_interpreter_pkg.t_distinct_tab(p_idx),

557: ) IS
558: BEGIN
559: -- See if there's a supervisor ID on the dated table
560: get_column_flag(
561: pay_interpreter_pkg.t_distinct_tab(p_idx),
562: 'SUPERVISOR_ID',
563: g_DATED_TABLE_EXTRAS(p_idx).has_supervisor_id
564: );
565: -- See if there's a location ID on the dated table

Line 567: pay_interpreter_pkg.t_distinct_tab(p_idx),

563: g_DATED_TABLE_EXTRAS(p_idx).has_supervisor_id
564: );
565: -- See if there's a location ID on the dated table
566: get_column_flag(
567: pay_interpreter_pkg.t_distinct_tab(p_idx),
568: 'LOCATION_ID',
569: g_DATED_TABLE_EXTRAS(p_idx).has_location_id
570: );
571: --

Line 574: pay_interpreter_pkg.t_distinct_tab(p_idx),

570: );
571: --
572: -- See if we've got an assignment ID (only really need one if supervisor or location is missing)
573: get_column_flag(
574: pay_interpreter_pkg.t_distinct_tab(p_idx),
575: 'ASSIGNMENT_ID',
576: g_DATED_TABLE_EXTRAS(p_idx).has_assignment_id
577: );
578: --

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

576: g_DATED_TABLE_EXTRAS(p_idx).has_assignment_id
577: );
578: --
579: -- Copy the records we updated to the return parameter
580: p_rec := pay_interpreter_pkg.t_distinct_tab(p_idx);
581: p_xrec := g_DATED_TABLE_EXTRAS(p_idx);
582: --
583: END set_dated_table_column_flags;
584: --

Line 596: l_tab_info pay_interpreter_pkg.t_distinct_table_rec;

592: p_want_location IN BOOLEAN,
593: p_sql IN OUT NOCOPY VARCHAR2
594: ) IS
595: --
596: l_tab_info pay_interpreter_pkg.t_distinct_table_rec;
597: l_tab_extra t_dated_table_extras_rec;
598: l_used_skt BOOLEAN := FALSE;
599: l_used_paf BOOLEAN := FALSE;
600: l_tab_idx NUMBER;

Line 807: pay_interpreter_pkg.event_group_tables(g_EVENT_GROUP_ID);

803: CLOSE get_evt;
804: --
805: -- Populate the internal package global caches to hold details of all
806: -- the dated tables that this event group uses
807: pay_interpreter_pkg.event_group_tables(g_EVENT_GROUP_ID);
808: --
809: -- Make sure we've got enough extra information records for all the
810: -- dated tables we're going to use
811: FOR i IN pay_interpreter_pkg.t_distinct_tab.FIRST .. pay_interpreter_pkg.t_distinct_tab.LAST LOOP

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

807: pay_interpreter_pkg.event_group_tables(g_EVENT_GROUP_ID);
808: --
809: -- Make sure we've got enough extra information records for all the
810: -- dated tables we're going to use
811: FOR i IN pay_interpreter_pkg.t_distinct_tab.FIRST .. pay_interpreter_pkg.t_distinct_tab.LAST LOOP
812: g_DATED_TABLE_EXTRAS(i).has_supervisor_id := 'X';
813: g_DATED_TABLE_EXTRAS(i).has_location_id := 'X';
814: g_DATED_TABLE_EXTRAS(i).has_assignment_id := 'X';
815: g_DATED_TABLE_EXTRAS(i).sql_statement := NULL;

Line 881: p_detailed_output IN pay_interpreter_pkg.t_detailed_output_table_type,

877: END set_debugging;
878: --
879: -- Process the detailed output information from an assignment event
880: PROCEDURE process_event_details(
881: p_detailed_output IN pay_interpreter_pkg.t_detailed_output_table_type,
882: p_proration_dates IN pay_interpreter_pkg.t_proration_dates_table_type,
883: p_summary_refresh IN OUT NOCOPY t_summary_refresh_tab_type,
884: p_location_stripe IN BOOLEAN DEFAULT FALSE
885: ) IS

Line 882: p_proration_dates IN pay_interpreter_pkg.t_proration_dates_table_type,

878: --
879: -- Process the detailed output information from an assignment event
880: PROCEDURE process_event_details(
881: p_detailed_output IN pay_interpreter_pkg.t_detailed_output_table_type,
882: p_proration_dates IN pay_interpreter_pkg.t_proration_dates_table_type,
883: p_summary_refresh IN OUT NOCOPY t_summary_refresh_tab_type,
884: p_location_stripe IN BOOLEAN DEFAULT FALSE
885: ) IS
886: --

Line 1216: l_detailed_output pay_interpreter_pkg.t_detailed_output_table_type;

1212: p_location_stripe IN BOOLEAN DEFAULT FALSE
1213: ) IS
1214: --
1215: -- Local table-type variables for use with processing the event details
1216: l_detailed_output pay_interpreter_pkg.t_detailed_output_table_type;
1217: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
1218: --
1219: BEGIN
1220: --

Line 1217: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;

1213: ) IS
1214: --
1215: -- Local table-type variables for use with processing the event details
1216: l_detailed_output pay_interpreter_pkg.t_detailed_output_table_type;
1217: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
1218: --
1219: BEGIN
1220: --
1221: -- Check we've got something to process