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

Line 2788: sql_cursor := DBMS_SQL.OPEN_CURSOR;

2784:
2785:
2786: -- Begin Bug 3086960. Added by Sachin.
2787:
2788: sql_cursor := DBMS_SQL.OPEN_CURSOR;
2789: /* -- Commented for PJR Enhancement for resource pull - Bug 5130414
2790: -- Organization is not specified.
2791: IF l_p_org_id IS NULL THEN
2792: -- Employee range is specified

Line 2829: DBMS_SQL.PARSE(sql_cursor, l_stmt, dbms_sql.v7);

2825:
2826: l_stmt := l_sel_clause || l_from_clause || l_where_clause;
2827:
2828: -- hr_utility.trace('l_stmt is : ' || l_stmt);
2829: DBMS_SQL.PARSE(sql_cursor, l_stmt, dbms_sql.v7);
2830: -- Added for Bug4954896
2831: -- Start of Bug 4954896
2832: IF l_p_org_id IS NULL THEN
2833: DBMS_SQL.BIND_VARIABLE(sql_cursor,':from_emp_num',l_from_emp_num);

Line 2833: DBMS_SQL.BIND_VARIABLE(sql_cursor,':from_emp_num',l_from_emp_num);

2829: DBMS_SQL.PARSE(sql_cursor, l_stmt, dbms_sql.v7);
2830: -- Added for Bug4954896
2831: -- Start of Bug 4954896
2832: IF l_p_org_id IS NULL THEN
2833: DBMS_SQL.BIND_VARIABLE(sql_cursor,':from_emp_num',l_from_emp_num);
2834: DBMS_SQL.BIND_VARIABLE(sql_cursor,':to_emp_num',l_to_emp_num);
2835: ELSE
2836: -- Organization is specified
2837: IF

Line 2834: DBMS_SQL.BIND_VARIABLE(sql_cursor,':to_emp_num',l_to_emp_num);

2830: -- Added for Bug4954896
2831: -- Start of Bug 4954896
2832: IF l_p_org_id IS NULL THEN
2833: DBMS_SQL.BIND_VARIABLE(sql_cursor,':from_emp_num',l_from_emp_num);
2834: DBMS_SQL.BIND_VARIABLE(sql_cursor,':to_emp_num',l_to_emp_num);
2835: ELSE
2836: -- Organization is specified
2837: IF
2838: -- Employee range is specified

Line 2841: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_id',l_p_org_id);

2837: IF
2838: -- Employee range is specified
2839: (l_from_emp_num IS NOT NULL AND
2840: l_to_emp_num IS NOT NULL ) THEN
2841: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_id',l_p_org_id);
2842: DBMS_SQL.BIND_VARIABLE(sql_cursor,':from_emp_num',l_from_emp_num);
2843: DBMS_SQL.BIND_VARIABLE(sql_cursor,':to_emp_num',l_to_emp_num);
2844: ELSE
2845: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_id',l_p_org_id);

Line 2842: DBMS_SQL.BIND_VARIABLE(sql_cursor,':from_emp_num',l_from_emp_num);

2838: -- Employee range is specified
2839: (l_from_emp_num IS NOT NULL AND
2840: l_to_emp_num IS NOT NULL ) THEN
2841: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_id',l_p_org_id);
2842: DBMS_SQL.BIND_VARIABLE(sql_cursor,':from_emp_num',l_from_emp_num);
2843: DBMS_SQL.BIND_VARIABLE(sql_cursor,':to_emp_num',l_to_emp_num);
2844: ELSE
2845: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_id',l_p_org_id);
2846: END IF;

Line 2843: DBMS_SQL.BIND_VARIABLE(sql_cursor,':to_emp_num',l_to_emp_num);

2839: (l_from_emp_num IS NOT NULL AND
2840: l_to_emp_num IS NOT NULL ) THEN
2841: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_id',l_p_org_id);
2842: DBMS_SQL.BIND_VARIABLE(sql_cursor,':from_emp_num',l_from_emp_num);
2843: DBMS_SQL.BIND_VARIABLE(sql_cursor,':to_emp_num',l_to_emp_num);
2844: ELSE
2845: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_id',l_p_org_id);
2846: END IF;
2847: END IF;

Line 2845: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_id',l_p_org_id);

2841: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_id',l_p_org_id);
2842: DBMS_SQL.BIND_VARIABLE(sql_cursor,':from_emp_num',l_from_emp_num);
2843: DBMS_SQL.BIND_VARIABLE(sql_cursor,':to_emp_num',l_to_emp_num);
2844: ELSE
2845: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_id',l_p_org_id);
2846: END IF;
2847: END IF;
2848: -- end of 4954896
2849: */

Line 2940: DBMS_SQL.PARSE(sql_cursor, l_stmt, dbms_sql.v7);

2936: END IF;
2937: END IF;
2938:
2939: l_stmt := l_sel_clause || l_from_clause || l_where_clause;
2940: DBMS_SQL.PARSE(sql_cursor, l_stmt, dbms_sql.v7);
2941:
2942: IF l_selection_option = 'EMP_RANGE' THEN
2943: -- Employee range is specified
2944: DBMS_SQL.BIND_VARIABLE(sql_cursor,':from_emp_num',l_from_emp_num);

Line 2944: DBMS_SQL.BIND_VARIABLE(sql_cursor,':from_emp_num',l_from_emp_num);

2940: DBMS_SQL.PARSE(sql_cursor, l_stmt, dbms_sql.v7);
2941:
2942: IF l_selection_option = 'EMP_RANGE' THEN
2943: -- Employee range is specified
2944: DBMS_SQL.BIND_VARIABLE(sql_cursor,':from_emp_num',l_from_emp_num);
2945: DBMS_SQL.BIND_VARIABLE(sql_cursor,':to_emp_num',l_to_emp_num);
2946: ELSIF l_selection_option = 'EMP_RANGE_ORG' THEN
2947: -- Employee range and organization is specified
2948: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_id',l_p_org_id);

Line 2945: DBMS_SQL.BIND_VARIABLE(sql_cursor,':to_emp_num',l_to_emp_num);

2941:
2942: IF l_selection_option = 'EMP_RANGE' THEN
2943: -- Employee range is specified
2944: DBMS_SQL.BIND_VARIABLE(sql_cursor,':from_emp_num',l_from_emp_num);
2945: DBMS_SQL.BIND_VARIABLE(sql_cursor,':to_emp_num',l_to_emp_num);
2946: ELSIF l_selection_option = 'EMP_RANGE_ORG' THEN
2947: -- Employee range and organization is specified
2948: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_id',l_p_org_id);
2949: DBMS_SQL.BIND_VARIABLE(sql_cursor,':from_emp_num',l_from_emp_num);

Line 2948: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_id',l_p_org_id);

2944: DBMS_SQL.BIND_VARIABLE(sql_cursor,':from_emp_num',l_from_emp_num);
2945: DBMS_SQL.BIND_VARIABLE(sql_cursor,':to_emp_num',l_to_emp_num);
2946: ELSIF l_selection_option = 'EMP_RANGE_ORG' THEN
2947: -- Employee range and organization is specified
2948: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_id',l_p_org_id);
2949: DBMS_SQL.BIND_VARIABLE(sql_cursor,':from_emp_num',l_from_emp_num);
2950: DBMS_SQL.BIND_VARIABLE(sql_cursor,':to_emp_num',l_to_emp_num);
2951: ELSIF l_selection_option = 'SINGLE_ORG' THEN
2952: -- Organization is specified

Line 2949: DBMS_SQL.BIND_VARIABLE(sql_cursor,':from_emp_num',l_from_emp_num);

2945: DBMS_SQL.BIND_VARIABLE(sql_cursor,':to_emp_num',l_to_emp_num);
2946: ELSIF l_selection_option = 'EMP_RANGE_ORG' THEN
2947: -- Employee range and organization is specified
2948: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_id',l_p_org_id);
2949: DBMS_SQL.BIND_VARIABLE(sql_cursor,':from_emp_num',l_from_emp_num);
2950: DBMS_SQL.BIND_VARIABLE(sql_cursor,':to_emp_num',l_to_emp_num);
2951: ELSIF l_selection_option = 'SINGLE_ORG' THEN
2952: -- Organization is specified
2953: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_id',l_p_org_id);

Line 2950: DBMS_SQL.BIND_VARIABLE(sql_cursor,':to_emp_num',l_to_emp_num);

2946: ELSIF l_selection_option = 'EMP_RANGE_ORG' THEN
2947: -- Employee range and organization is specified
2948: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_id',l_p_org_id);
2949: DBMS_SQL.BIND_VARIABLE(sql_cursor,':from_emp_num',l_from_emp_num);
2950: DBMS_SQL.BIND_VARIABLE(sql_cursor,':to_emp_num',l_to_emp_num);
2951: ELSIF l_selection_option = 'SINGLE_ORG' THEN
2952: -- Organization is specified
2953: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_id',l_p_org_id);
2954: ELSIF l_selection_option = 'START_ORG' THEN

Line 2953: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_id',l_p_org_id);

2949: DBMS_SQL.BIND_VARIABLE(sql_cursor,':from_emp_num',l_from_emp_num);
2950: DBMS_SQL.BIND_VARIABLE(sql_cursor,':to_emp_num',l_to_emp_num);
2951: ELSIF l_selection_option = 'SINGLE_ORG' THEN
2952: -- Organization is specified
2953: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_id',l_p_org_id);
2954: ELSIF l_selection_option = 'START_ORG' THEN
2955: -- Organization hierarchy and starting organization is specified
2956: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_str_version_id',l_org_str_version_id);
2957: DBMS_SQL.BIND_VARIABLE(sql_cursor,':start_org',l_start_organization_id);

Line 2956: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_str_version_id',l_org_str_version_id);

2952: -- Organization is specified
2953: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_id',l_p_org_id);
2954: ELSIF l_selection_option = 'START_ORG' THEN
2955: -- Organization hierarchy and starting organization is specified
2956: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_str_version_id',l_org_str_version_id);
2957: DBMS_SQL.BIND_VARIABLE(sql_cursor,':start_org',l_start_organization_id);
2958: ELSIF l_selection_option IS NULL THEN
2959: -- Selection option not specified (Will never occur, but a check for backward compliance)
2960: IF l_p_org_id IS NULL THEN

Line 2957: DBMS_SQL.BIND_VARIABLE(sql_cursor,':start_org',l_start_organization_id);

2953: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_id',l_p_org_id);
2954: ELSIF l_selection_option = 'START_ORG' THEN
2955: -- Organization hierarchy and starting organization is specified
2956: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_str_version_id',l_org_str_version_id);
2957: DBMS_SQL.BIND_VARIABLE(sql_cursor,':start_org',l_start_organization_id);
2958: ELSIF l_selection_option IS NULL THEN
2959: -- Selection option not specified (Will never occur, but a check for backward compliance)
2960: IF l_p_org_id IS NULL THEN
2961: -- Employee range is specified

Line 2962: DBMS_SQL.BIND_VARIABLE(sql_cursor,':from_emp_num',l_from_emp_num);

2958: ELSIF l_selection_option IS NULL THEN
2959: -- Selection option not specified (Will never occur, but a check for backward compliance)
2960: IF l_p_org_id IS NULL THEN
2961: -- Employee range is specified
2962: DBMS_SQL.BIND_VARIABLE(sql_cursor,':from_emp_num',l_from_emp_num);
2963: DBMS_SQL.BIND_VARIABLE(sql_cursor,':to_emp_num',l_to_emp_num);
2964: ELSIF (l_from_emp_num IS NOT NULL AND l_to_emp_num IS NOT NULL) THEN
2965: -- Employee range and Organization is specified
2966: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_id',l_p_org_id);

Line 2963: DBMS_SQL.BIND_VARIABLE(sql_cursor,':to_emp_num',l_to_emp_num);

2959: -- Selection option not specified (Will never occur, but a check for backward compliance)
2960: IF l_p_org_id IS NULL THEN
2961: -- Employee range is specified
2962: DBMS_SQL.BIND_VARIABLE(sql_cursor,':from_emp_num',l_from_emp_num);
2963: DBMS_SQL.BIND_VARIABLE(sql_cursor,':to_emp_num',l_to_emp_num);
2964: ELSIF (l_from_emp_num IS NOT NULL AND l_to_emp_num IS NOT NULL) THEN
2965: -- Employee range and Organization is specified
2966: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_id',l_p_org_id);
2967: DBMS_SQL.BIND_VARIABLE(sql_cursor,':from_emp_num',l_from_emp_num);

Line 2966: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_id',l_p_org_id);

2962: DBMS_SQL.BIND_VARIABLE(sql_cursor,':from_emp_num',l_from_emp_num);
2963: DBMS_SQL.BIND_VARIABLE(sql_cursor,':to_emp_num',l_to_emp_num);
2964: ELSIF (l_from_emp_num IS NOT NULL AND l_to_emp_num IS NOT NULL) THEN
2965: -- Employee range and Organization is specified
2966: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_id',l_p_org_id);
2967: DBMS_SQL.BIND_VARIABLE(sql_cursor,':from_emp_num',l_from_emp_num);
2968: DBMS_SQL.BIND_VARIABLE(sql_cursor,':to_emp_num',l_to_emp_num);
2969: ELSE
2970: -- Only Organization is specified

Line 2967: DBMS_SQL.BIND_VARIABLE(sql_cursor,':from_emp_num',l_from_emp_num);

2963: DBMS_SQL.BIND_VARIABLE(sql_cursor,':to_emp_num',l_to_emp_num);
2964: ELSIF (l_from_emp_num IS NOT NULL AND l_to_emp_num IS NOT NULL) THEN
2965: -- Employee range and Organization is specified
2966: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_id',l_p_org_id);
2967: DBMS_SQL.BIND_VARIABLE(sql_cursor,':from_emp_num',l_from_emp_num);
2968: DBMS_SQL.BIND_VARIABLE(sql_cursor,':to_emp_num',l_to_emp_num);
2969: ELSE
2970: -- Only Organization is specified
2971: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_id',l_p_org_id);

Line 2968: DBMS_SQL.BIND_VARIABLE(sql_cursor,':to_emp_num',l_to_emp_num);

2964: ELSIF (l_from_emp_num IS NOT NULL AND l_to_emp_num IS NOT NULL) THEN
2965: -- Employee range and Organization is specified
2966: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_id',l_p_org_id);
2967: DBMS_SQL.BIND_VARIABLE(sql_cursor,':from_emp_num',l_from_emp_num);
2968: DBMS_SQL.BIND_VARIABLE(sql_cursor,':to_emp_num',l_to_emp_num);
2969: ELSE
2970: -- Only Organization is specified
2971: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_id',l_p_org_id);
2972: END IF;

Line 2971: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_id',l_p_org_id);

2967: DBMS_SQL.BIND_VARIABLE(sql_cursor,':from_emp_num',l_from_emp_num);
2968: DBMS_SQL.BIND_VARIABLE(sql_cursor,':to_emp_num',l_to_emp_num);
2969: ELSE
2970: -- Only Organization is specified
2971: DBMS_SQL.BIND_VARIABLE(sql_cursor,':org_id',l_p_org_id);
2972: END IF;
2973: END IF;
2974: -- End - Bug 5130414 - PJR Resource Pull Enhancement
2975:

Line 2976: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 1, l_person_id);

2972: END IF;
2973: END IF;
2974: -- End - Bug 5130414 - PJR Resource Pull Enhancement
2975:
2976: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 1, l_person_id);
2977: l_rows := DBMS_SQL.EXECUTE (sql_cursor);
2978:
2979: -- hr_utility.trace('l_rows is : ' || l_rows);
2980: LOOP

Line 2977: l_rows := DBMS_SQL.EXECUTE (sql_cursor);

2973: END IF;
2974: -- End - Bug 5130414 - PJR Resource Pull Enhancement
2975:
2976: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 1, l_person_id);
2977: l_rows := DBMS_SQL.EXECUTE (sql_cursor);
2978:
2979: -- hr_utility.trace('l_rows is : ' || l_rows);
2980: LOOP
2981: IF DBMS_SQL.FETCH_ROWS(sql_cursor) = 0 THEN

Line 2981: IF DBMS_SQL.FETCH_ROWS(sql_cursor) = 0 THEN

2977: l_rows := DBMS_SQL.EXECUTE (sql_cursor);
2978:
2979: -- hr_utility.trace('l_rows is : ' || l_rows);
2980: LOOP
2981: IF DBMS_SQL.FETCH_ROWS(sql_cursor) = 0 THEN
2982: EXIT;
2983: END IF;
2984: -- Get the person ID to process into l_person_id
2985: DBMS_SQL.COLUMN_VALUE(sql_cursor,1,l_person_id);

Line 2985: DBMS_SQL.COLUMN_VALUE(sql_cursor,1,l_person_id);

2981: IF DBMS_SQL.FETCH_ROWS(sql_cursor) = 0 THEN
2982: EXIT;
2983: END IF;
2984: -- Get the person ID to process into l_person_id
2985: DBMS_SQL.COLUMN_VALUE(sql_cursor,1,l_person_id);
2986:
2987:
2988: -- hr_utility.trace('person id is : ' || l_person_id);
2989: -- Loop through cur_resources cursor

Line 3684: DBMS_SQL.CLOSE_CURSOR(sql_cursor);

3680: END IF;
3681:
3682:
3683: END LOOP; -- Dynamic SQL loop
3684: DBMS_SQL.CLOSE_CURSOR(sql_cursor);
3685:
3686: -- End Bug 3086960
3687:
3688: pa_debug.g_err_stage := 'Log: Calling Populate_Org_Hier_Denorm procedure';