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.PA_PROJECT_ASSIGNMENTS_PKG dependencies on PA_TEAM_TEMPLATES

Line 368: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;

364: INDEX BY BINARY_INTEGER;
365: l_rowid rowid_table;
366:
367: l_index NUMBER;
368: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;
369:
370: CURSOR check_team_template_wf IS
371: SELECT workflow_in_progress_flag
372: FROM pa_team_templates

Line 372: FROM pa_team_templates

368: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;
369:
370: CURSOR check_team_template_wf IS
371: SELECT workflow_in_progress_flag
372: FROM pa_team_templates
373: WHERE team_template_id = p_assignment_template_id;
374:
375: BEGIN
376:

Line 786: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;

782:
783:
784: l_row_id ROWID := p_assignment_row_id;
785: l_record_version_number NUMBER;
786: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;
787:
788: TYPE assignment_id IS TABLE OF pa_project_assignments.assignment_id%TYPE
789: INDEX BY BINARY_INTEGER;
790: l_assignment_id assignment_id;

Line 800: FROM pa_team_templates

796: WHERE assignment_id = p_assignment_id;
797:
798: CURSOR check_team_template_wf IS
799: SELECT workflow_in_progress_flag
800: FROM pa_team_templates
801: WHERE team_template_id = p_assignment_template_id;
802:
803: /*
804: -- do not have to check mass_wf_in_progress_flag again

Line 1000: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;

996: )
997: IS
998:
999: l_row_id ROWID;
1000: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;
1001: l_mass_wf_in_progress_flag pa_project_assignments.mass_wf_in_progress_flag%TYPE;
1002:
1003: CURSOR check_team_template_wf IS
1004: SELECT tt.workflow_in_progress_flag

Line 1006: pa_team_templates tt

1002:
1003: CURSOR check_team_template_wf IS
1004: SELECT tt.workflow_in_progress_flag
1005: FROM pa_project_assignments asgn,
1006: pa_team_templates tt
1007: WHERE asgn.assignment_id = p_assignment_id
1008: AND asgn.template_flag = 'Y'
1009: AND tt.team_template_id = asgn.assignment_template_id;
1010: