DBA Data[Home] [Help]

APPS.IGS_TR_GEN_002 dependencies on IGS_TR_TSTP_GRP_LMT_PKG

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