APPS.IGS_TR_GEN_002 dependencies on IGS_TR_STEP_GRP_LMT_PKG

Line 305: igs_tr_step_grp_lmt_pkg.delete_row( x_rowid => rec_del_grp_lmt.rowid);

301:
302: BEGIN
303:
304: FOR rec_del_grp_lmt IN c_del_grp_lmt LOOP
305: igs_tr_step_grp_lmt_pkg.delete_row( x_rowid => rec_del_grp_lmt.rowid);
306: END LOOP;
307:
308: RETURN TRUE;
309: END;

Line 760: IGS_TR_STEP_GRP_LMT_PKG.INSERT_ROW (

756: l_rowid VARCHAR2(25);
757:
758: BEGIN
759:
760: IGS_TR_STEP_GRP_LMT_PKG.INSERT_ROW (
761: X_ROWID => l_rowid,
762: X_TRACKING_ID => p_tracking_id,
763: X_STEP_GROUP_ID => p_step_group_id,
764: X_STEP_GROUP_LIMIT => p_step_group_limit

Line 2658: igs_tr_step_grp_lmt_pkg.delete_row ( X_ROWID => lv_rowid );

2654: FOR rec_decrement_step_grp_lmt IN c_decrement_step_grp_lmt LOOP
2655: OPEN c_rowid(p_tracking_id, rec_decrement_step_grp_lmt.step_group_id );
2656: FETCH c_rowid INTO lv_rowid;
2657: CLOSE c_rowid;
2658: igs_tr_step_grp_lmt_pkg.delete_row ( X_ROWID => lv_rowid );
2659: END LOOP;
2660:
2661:
2662:

Line 2669: igs_tr_step_grp_lmt_pkg.insert_row (

2665: -- but not in IGS_TR_STEP_GRP_LMT.
2666: -- Default the value of Step_group_limit to 1.
2667:
2668: FOR rec_insert_step_grp_lmt IN c_insert_step_grp_lmt LOOP
2669: igs_tr_step_grp_lmt_pkg.insert_row (
2670: X_ROWID => lv_rowid ,
2671: X_TRACKING_ID => p_tracking_id ,
2672: X_STEP_GROUP_ID => rec_insert_step_grp_lmt.step_group_id ,
2673: X_STEP_GROUP_LIMIT => 1 ,

Line 2699: igs_tr_step_grp_lmt_pkg.update_row (

2695: -- Check whether Step Group limit is greater than the count of Tracking item steps for a step group id and tracking_id combination
2696: -- then set the step group limit equal to the count of step group id's in the igs)tr)step_v view for a step group id and tracking_id combination.
2697:
2698: IF ln_grp_lmt > rec_item_step.step_group_count THEN
2699: igs_tr_step_grp_lmt_pkg.update_row (
2700: X_ROWID => lv_rowid ,
2701: X_TRACKING_ID => p_tracking_id ,
2702: X_STEP_GROUP_ID => rec_item_step.step_group_id ,
2703: X_STEP_GROUP_LIMIT => rec_item_step.step_group_count ,