APPS.IGS_TR_GEN_002 dependencies on IGS_TR_TYPE_STEP_V

Line 2366: PROCEDURE sync_trk_type_grplmt ( p_tracking_type IGS_TR_TYPE_STEP_V.tracking_type%TYPE, p_execute VARCHAR2 ) IS

2362: app_exception.raise_exception;
2363:
2364: END trkp_upd_trst;
2365:
2366: PROCEDURE sync_trk_type_grplmt ( p_tracking_type IGS_TR_TYPE_STEP_V.tracking_type%TYPE, p_execute VARCHAR2 ) IS
2367:
2368: /***********************************************************************************************************
2369:
2370: Created By: pradhakr

Line 2373: of IGS_TR_TYPE_STEP_V.

2369:
2370: Created By: pradhakr
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

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 2421: CURSOR c_type_step (p_tracking_type igs_tr_type_step_v.tracking_type%TYPE) IS

2417: AND step_group_id = p_step_group_id;
2418:
2419: --ssawhney view reference changed to table
2420: -- Cursor to get the count of step group id from tracking type step
2421: CURSOR c_type_step (p_tracking_type igs_tr_type_step_v.tracking_type%TYPE) IS
2422: SELECT step_group_id, COUNT(*) step_group_count
2423: FROM igs_tr_type_step
2424: WHERE tracking_type = p_tracking_type
2425: GROUP BY step_group_id;

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 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 (