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.IGS_TR_GEN_002 dependencies on IGS_TR_TSTP_GRP_LMT

Line 574: FROM igs_tr_tstp_grp_lmt

570: -- Cursor to fetch group limit
571: CURSOR c_tracking_type_step_grplmt (cp_tracking_type igs_tr_type.tracking_type%TYPE) IS
572: SELECT step_group_id,
573: step_group_limit
574: FROM igs_tr_tstp_grp_lmt
575: WHERE tracking_type = cp_tracking_type;
576:
577:
578: -- This procedure insert a IGS_TR_STEP record

Line 2375: kind for a particular tracking id, the step group id will be deleted from IGS_TR_TSTP_GRP_LMT

2371: Date Created By: 11-Feb-2002
2372: Purpose: This procedure will synchronise the content of the table IGS_TR_STEP_GRP_LMT with the content
2373: of IGS_TR_TYPE_STEP_V.
2374: 1. If that step group being deleted in form IGSTR001 ( block tracking step) is the last one of its
2375: kind for a particular tracking id, the step group id will be deleted from IGS_TR_TSTP_GRP_LMT
2376: else Step Group Limit will be decremented by 1.
2377: 2. Any new Step Group ID being created in the form IGSTR001 ( block tracking step) will also be created
2378: in the table IGS_TR_TSTP_GRP_LMT and the Step Group Limit would be defaulted to 1.
2379:

Line 2378: in the table IGS_TR_TSTP_GRP_LMT and the Step Group Limit would be defaulted to 1.

2374: 1. If that step group being deleted in form IGSTR001 ( block tracking step) is the last one of its
2375: kind for a particular tracking id, the step group id will be deleted from IGS_TR_TSTP_GRP_LMT
2376: else Step Group Limit will be decremented by 1.
2377: 2. Any new Step Group ID being created in the form IGSTR001 ( block tracking step) will also be created
2378: in the table IGS_TR_TSTP_GRP_LMT and the Step Group Limit would be defaulted to 1.
2379:
2380: Known limitations,enhancements,remarks:
2381: Change History
2382: Who When What

Line 2389: FROM igs_tr_tstp_grp_lmt

2385: --ssawhney view reference changed to table
2386: -- Decrements a step group limit
2387: CURSOR c_decrement_step_grp_lmt IS
2388: SELECT step_group_id
2389: FROM igs_tr_tstp_grp_lmt
2390: WHERE tracking_type = p_tracking_type
2391: MINUS
2392: SELECT step_group_id
2393: FROM igs_tr_type_step tts

Line 2408: FROM igs_tr_tstp_grp_lmt

2404: AND tts.step_group_id IS NOT NULL
2405: GROUP BY tts.step_group_id
2406: MINUS
2407: SELECT step_group_id
2408: FROM igs_tr_tstp_grp_lmt
2409: WHERE tracking_type = p_tracking_type;
2410:
2411:
2412: -- Cursor to fetch the Rowid

Line 2413: CURSOR c_rowid (p_tracking_type IGS_TR_TYPE_STEP_V.tracking_type%TYPE, p_step_group_id igs_tr_tstp_grp_lmt.step_group_id%TYPE) IS

2409: WHERE tracking_type = p_tracking_type;
2410:
2411:
2412: -- Cursor to fetch the Rowid
2413: CURSOR c_rowid (p_tracking_type IGS_TR_TYPE_STEP_V.tracking_type%TYPE, p_step_group_id igs_tr_tstp_grp_lmt.step_group_id%TYPE) IS
2414: SELECT ROWID
2415: FROM igs_tr_tstp_grp_lmt
2416: WHERE tracking_type = p_tracking_type
2417: AND step_group_id = p_step_group_id;

Line 2415: FROM igs_tr_tstp_grp_lmt

2411:
2412: -- Cursor to fetch the Rowid
2413: CURSOR c_rowid (p_tracking_type IGS_TR_TYPE_STEP_V.tracking_type%TYPE, p_step_group_id igs_tr_tstp_grp_lmt.step_group_id%TYPE) IS
2414: SELECT ROWID
2415: FROM igs_tr_tstp_grp_lmt
2416: WHERE tracking_type = p_tracking_type
2417: AND step_group_id = p_step_group_id;
2418:
2419: --ssawhney view reference changed to table

Line 2427: -- Cursor to get the step group limit from igs_tr_tstp_grp_lmt table

2423: FROM igs_tr_type_step
2424: WHERE tracking_type = p_tracking_type
2425: GROUP BY step_group_id;
2426:
2427: -- Cursor to get the step group limit from igs_tr_tstp_grp_lmt table
2428: CURSOR c_grp_lmt (p_tracking_type igs_tr_tstp_grp_lmt.tracking_type%TYPE, p_step_group_id igs_tr_tstp_grp_lmt.step_group_id%TYPE) IS
2429: SELECT step_group_limit
2430: FROM igs_tr_tstp_grp_lmt
2431: WHERE tracking_type = p_tracking_type

Line 2428: CURSOR c_grp_lmt (p_tracking_type igs_tr_tstp_grp_lmt.tracking_type%TYPE, p_step_group_id igs_tr_tstp_grp_lmt.step_group_id%TYPE) IS

2424: WHERE tracking_type = p_tracking_type
2425: GROUP BY step_group_id;
2426:
2427: -- Cursor to get the step group limit from igs_tr_tstp_grp_lmt table
2428: CURSOR c_grp_lmt (p_tracking_type igs_tr_tstp_grp_lmt.tracking_type%TYPE, p_step_group_id igs_tr_tstp_grp_lmt.step_group_id%TYPE) IS
2429: SELECT step_group_limit
2430: FROM igs_tr_tstp_grp_lmt
2431: WHERE tracking_type = p_tracking_type
2432: AND step_group_id = p_step_group_id;

Line 2430: FROM igs_tr_tstp_grp_lmt

2426:
2427: -- Cursor to get the step group limit from igs_tr_tstp_grp_lmt table
2428: CURSOR c_grp_lmt (p_tracking_type igs_tr_tstp_grp_lmt.tracking_type%TYPE, p_step_group_id igs_tr_tstp_grp_lmt.step_group_id%TYPE) IS
2429: SELECT step_group_limit
2430: FROM igs_tr_tstp_grp_lmt
2431: WHERE tracking_type = p_tracking_type
2432: AND step_group_id = p_step_group_id;
2433:
2434: lv_rowid VARCHAR2(25);

Line 2436: l_step_group_limit igs_tr_tstp_grp_lmt.step_group_limit%TYPE;

2432: AND step_group_id = p_step_group_id;
2433:
2434: lv_rowid VARCHAR2(25);
2435: l_rowid VARCHAR2(25);
2436: l_step_group_limit igs_tr_tstp_grp_lmt.step_group_limit%TYPE;
2437: l_grp_lmt igs_tr_tstp_grp_lmt.step_group_limit%TYPE;
2438:
2439: BEGIN
2440:

Line 2437: l_grp_lmt igs_tr_tstp_grp_lmt.step_group_limit%TYPE;

2433:
2434: lv_rowid VARCHAR2(25);
2435: l_rowid VARCHAR2(25);
2436: l_step_group_limit igs_tr_tstp_grp_lmt.step_group_limit%TYPE;
2437: l_grp_lmt igs_tr_tstp_grp_lmt.step_group_limit%TYPE;
2438:
2439: BEGIN
2440:
2441: -- Do not execute the code if the records are being updated in group limit block

Line 2447: -- Delete records from IGS_TR_TSTP_GRP_LMT table when a tracking_type and step_group_id combination exists in

2443: IF p_execute = 'N' THEN
2444: RETURN;
2445: END IF;
2446:
2447: -- Delete records from IGS_TR_TSTP_GRP_LMT table when a tracking_type and step_group_id combination exists in
2448: -- IGS_TR_TSTP_GRP_LMT but does not exist in view IGS_TR_TYPE_STEP_V
2449:
2450: FOR rec_decrement_step_grp_lmt IN c_decrement_step_grp_lmt LOOP
2451:

Line 2448: -- IGS_TR_TSTP_GRP_LMT but does not exist in view IGS_TR_TYPE_STEP_V

2444: RETURN;
2445: END IF;
2446:
2447: -- Delete records from IGS_TR_TSTP_GRP_LMT table when a tracking_type and step_group_id combination exists in
2448: -- IGS_TR_TSTP_GRP_LMT but does not exist in view IGS_TR_TYPE_STEP_V
2449:
2450: FOR rec_decrement_step_grp_lmt IN c_decrement_step_grp_lmt LOOP
2451:
2452: OPEN c_rowid(p_tracking_type, rec_decrement_step_grp_lmt.step_group_id );

Line 2456: igs_tr_tstp_grp_lmt_pkg.delete_row ( X_ROWID => l_rowid );

2452: OPEN c_rowid(p_tracking_type, rec_decrement_step_grp_lmt.step_group_id );
2453: FETCH c_rowid INTO l_rowid;
2454: CLOSE c_rowid;
2455:
2456: igs_tr_tstp_grp_lmt_pkg.delete_row ( X_ROWID => l_rowid );
2457:
2458: END LOOP;
2459:
2460:

Line 2461: -- Insert records into IGS_TR_TSTP_GRP_LMT when tracking_type and step_group_id combination

2457:
2458: END LOOP;
2459:
2460:
2461: -- Insert records into IGS_TR_TSTP_GRP_LMT when tracking_type and step_group_id combination
2462: -- exists in IGS_TR_TYPE_STEP_V but not in IGS_TR_TSTP_GRP_LMT.
2463: -- Default the value of Step_group_limit to 1.
2464:
2465: FOR rec_insert_step_grp_lmt IN c_insert_step_grp_lmt LOOP

Line 2462: -- exists in IGS_TR_TYPE_STEP_V but not in IGS_TR_TSTP_GRP_LMT.

2458: END LOOP;
2459:
2460:
2461: -- Insert records into IGS_TR_TSTP_GRP_LMT when tracking_type and step_group_id combination
2462: -- exists in IGS_TR_TYPE_STEP_V but not in IGS_TR_TSTP_GRP_LMT.
2463: -- Default the value of Step_group_limit to 1.
2464:
2465: FOR rec_insert_step_grp_lmt IN c_insert_step_grp_lmt LOOP
2466: igs_tr_tstp_grp_lmt_pkg.insert_row (

Line 2466: igs_tr_tstp_grp_lmt_pkg.insert_row (

2462: -- exists in IGS_TR_TYPE_STEP_V but not in IGS_TR_TSTP_GRP_LMT.
2463: -- Default the value of Step_group_limit to 1.
2464:
2465: FOR rec_insert_step_grp_lmt IN c_insert_step_grp_lmt LOOP
2466: igs_tr_tstp_grp_lmt_pkg.insert_row (
2467: X_ROWID => lv_rowid ,
2468: X_TRACKING_TYPE => p_tracking_type ,
2469: X_STEP_GROUP_ID => rec_insert_step_grp_lmt.step_group_id ,
2470: X_STEP_GROUP_LIMIT => 1 ,

Line 2487: igs_tr_tstp_grp_lmt_pkg.update_row (

2483: CLOSE c_rowid;
2484:
2485: -- Checking whether Group limit is greater than the count of Tracking step types for a group id
2486: IF l_grp_lmt > rec_type_step.step_group_count THEN
2487: igs_tr_tstp_grp_lmt_pkg.update_row (
2488: X_ROWID => l_rowid ,
2489: X_TRACKING_TYPE => p_tracking_type ,
2490: X_STEP_GROUP_ID => rec_type_step.step_group_id ,
2491: X_STEP_GROUP_LIMIT => rec_type_step.step_group_count ,