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_TYPE_STEP

Line 558: FROM igs_tr_type_step

554: WHERE tracking_id = cp_tracking_id;
555:
556: CURSOR c_tracking_type_step ( cp_tracking_type igs_tr_type.tracking_type%TYPE) IS
557: SELECT *
558: FROM igs_tr_type_step
559: WHERE tracking_type = cp_tracking_type;
560:
561: CURSOR c_tracking_type_step_note (
562: cp_tracking_type igs_tr_type.tracking_type%TYPE,

Line 563: cp_tracking_type_step_id igs_tr_type_step.tracking_type_step_id%TYPE

559: WHERE tracking_type = cp_tracking_type;
560:
561: CURSOR c_tracking_type_step_note (
562: cp_tracking_type igs_tr_type.tracking_type%TYPE,
563: cp_tracking_type_step_id igs_tr_type_step.tracking_type_step_id%TYPE
564: ) IS
565: SELECT reference_number, trk_note_type
566: FROM igs_tr_typ_step_note
567: WHERE tracking_type = cp_tracking_type

Line 589: p_s_tracking_step_type igs_tr_type_step.s_tracking_step_type%TYPE,

585: p_action_days igs_tr_step.action_days%TYPE,
586: p_step_completion_ind igs_tr_step.step_completion_ind%TYPE,
587: p_by_pass_ind igs_tr_step.by_pass_ind%TYPE,
588: p_recipient_id igs_tr_step.recipient_id%TYPE,
589: p_s_tracking_step_type igs_tr_type_step.s_tracking_step_type%TYPE,
590: p_step_catalog_cd igs_tr_type_step.step_catalog_cd%TYPE,
591: p_step_group_id igs_tr_type_step.step_group_id%TYPE,
592: p_publish_ind igs_tr_type_step.publish_ind%TYPE)
593:

Line 590: p_step_catalog_cd igs_tr_type_step.step_catalog_cd%TYPE,

586: p_step_completion_ind igs_tr_step.step_completion_ind%TYPE,
587: p_by_pass_ind igs_tr_step.by_pass_ind%TYPE,
588: p_recipient_id igs_tr_step.recipient_id%TYPE,
589: p_s_tracking_step_type igs_tr_type_step.s_tracking_step_type%TYPE,
590: p_step_catalog_cd igs_tr_type_step.step_catalog_cd%TYPE,
591: p_step_group_id igs_tr_type_step.step_group_id%TYPE,
592: p_publish_ind igs_tr_type_step.publish_ind%TYPE)
593:
594: AS

Line 591: p_step_group_id igs_tr_type_step.step_group_id%TYPE,

587: p_by_pass_ind igs_tr_step.by_pass_ind%TYPE,
588: p_recipient_id igs_tr_step.recipient_id%TYPE,
589: p_s_tracking_step_type igs_tr_type_step.s_tracking_step_type%TYPE,
590: p_step_catalog_cd igs_tr_type_step.step_catalog_cd%TYPE,
591: p_step_group_id igs_tr_type_step.step_group_id%TYPE,
592: p_publish_ind igs_tr_type_step.publish_ind%TYPE)
593:
594: AS
595:

Line 592: p_publish_ind igs_tr_type_step.publish_ind%TYPE)

588: p_recipient_id igs_tr_step.recipient_id%TYPE,
589: p_s_tracking_step_type igs_tr_type_step.s_tracking_step_type%TYPE,
590: p_step_catalog_cd igs_tr_type_step.step_catalog_cd%TYPE,
591: p_step_group_id igs_tr_type_step.step_group_id%TYPE,
592: p_publish_ind igs_tr_type_step.publish_ind%TYPE)
593:
594: AS
595:
596: lv_param_values VARCHAR2(1080);

Line 801: -- Select all IGS_TR_TYPE_STEP records

797: END IF;
798:
799: CLOSE c_tracking_item;
800:
801: -- Select all IGS_TR_TYPE_STEP records
802:
803: FOR v_tts_rec IN c_tracking_type_step( v_tracking_type) LOOP
804:
805: IF (v_tts_rec.recipient_id IS NULL) THEN

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 2393: FROM igs_tr_type_step tts

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
2394: WHERE tracking_type = p_tracking_type
2395: AND tts.step_group_id IS NOT NULL
2396: GROUP BY tts.step_group_id;
2397:

Line 2402: FROM igs_tr_type_step tts

2398: --ssawhney view reference changed to table
2399: -- Insert a step group limit
2400: CURSOR c_insert_step_grp_lmt IS
2401: SELECT step_group_id
2402: FROM igs_tr_type_step tts
2403: WHERE tracking_type = p_tracking_type
2404: AND tts.step_group_id IS NOT NULL
2405: GROUP BY tts.step_group_id
2406: MINUS

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 2423: FROM igs_tr_type_step

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;
2426:
2427: -- Cursor to get the step group limit from igs_tr_tstp_grp_lmt table

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 (