APPS.JTF_FM_INT_REQUEST_PKG dependencies on JTF_FM_PARTITION_X_REQUEST

Line 2680: FROM jtf_fm_partition_x_request

2676: IF (l_lines_count > 0)
2677: THEN
2678: SELECT partition_name
2679: INTO l_partition_name
2680: FROM jtf_fm_partition_x_request
2681: WHERE request_id = p_request_id;
2682:
2683: EXECUTE IMMEDIATE 'ALTER TABLE jtf_fm_int_request_lines TRUNCATE PARTITION '|| l_partition_name;
2684: END IF;

Line 2725: FROM jtf_fm_partition_x_request

2721: l_msg_count NUMBER;
2722: l_msg_data VARCHAR2(100);
2723: CURSOR c_partition IS
2724: SELECT partition_id
2725: FROM jtf_fm_partition_x_request
2726: WHERE partition_id = ( SELECT MIN(partition_id)
2727: FROM jtf_fm_partition_x_request
2728: WHERE request_id IS NULL
2729: )

Line 2727: FROM jtf_fm_partition_x_request

2723: CURSOR c_partition IS
2724: SELECT partition_id
2725: FROM jtf_fm_partition_x_request
2726: WHERE partition_id = ( SELECT MIN(partition_id)
2727: FROM jtf_fm_partition_x_request
2728: WHERE request_id IS NULL
2729: )
2730: FOR UPDATE;
2731: BEGIN

Line 2748: FROM jtf_fm_partition_x_request part, jtf_fm_request_history_all history

2744: THEN
2745: SELECT partition_id, request_id
2746: INTO l_partition_id, l_request_id
2747: FROM ( SELECT part.partition_id, part.request_id
2748: FROM jtf_fm_partition_x_request part, jtf_fm_request_history_all history
2749: WHERE part.request_id IS NOT NULL
2750: AND part.request_id = history.hist_req_id
2751: AND history.outcome_code NOT IN ('IN_PROGRESS', 'PAUSED')
2752: ORDER BY request_id ASC )

Line 2795: UPDATE jtf_fm_partition_x_request

2791: , p_request_id IN NUMBER
2792: , p_partition_id IN NUMBER
2793: ) IS
2794: BEGIN
2795: UPDATE jtf_fm_partition_x_request
2796: SET request_id = p_request_id
2797: WHERE partition_id = p_partition_id
2798: AND request_id IS NULL
2799: ;

Line 2817: l_partition_name jtf_fm_partition_x_request.partition_name%TYPE;

2813: PROCEDURE unlock_partition ( x_errbuf OUT NOCOPY VARCHAR2
2814: , x_retcode OUT NOCOPY VARCHAR2
2815: , p_request_id IN NUMBER
2816: ) IS
2817: l_partition_name jtf_fm_partition_x_request.partition_name%TYPE;
2818: BEGIN
2819: UPDATE jtf_fm_partition_x_request
2820: SET request_id = NULL
2821: WHERE request_id = p_request_id

Line 2819: UPDATE jtf_fm_partition_x_request

2815: , p_request_id IN NUMBER
2816: ) IS
2817: l_partition_name jtf_fm_partition_x_request.partition_name%TYPE;
2818: BEGIN
2819: UPDATE jtf_fm_partition_x_request
2820: SET request_id = NULL
2821: WHERE request_id = p_request_id
2822: RETURNING partition_name INTO l_partition_name
2823: ;