APPS.IGS_TR_GEN_002 dependencies on IGS_TR_STEP_V

Line 193: of IGS_TR_STEP_V.

189:
190: Date Created By: 13-Feb-2002
191:
192: Purpose: This procedure will synchronise the content of the table IGS_TR_STEP_GRP_LMT with the content
193: of IGS_TR_STEP_V.
194: 1. If that step group being deleted in form IGSTR007 ( block tracking step) is the last one of its
195: kind for a particular tracking id, the step group id will be deleted from IGS_TR_STEP_GRP_LMT
196:
197: 2. Any new Step Group ID being created in the form IGSTR007 ( block tracking step) will also be created

Line 201: combination in IGS_TR_STEP_V view then set it equal to the lower value (i.e count of step_group_id's in the IGS_TR_STEP_V).

197: 2. Any new Step Group ID being created in the form IGSTR007 ( block tracking step) will also be created
198: in the table IGS_TR_STEP_GRP_LMT and the Step Group Limit would be defaulted to 1.
199:
200: 3. In case IGS_TR_STEP_GRP_LMT.STEP_GROUP_LIMIT is greater than the count of step_group_id's for tracking_id and step_group_id
201: combination in IGS_TR_STEP_V view then set it equal to the lower value (i.e count of step_group_id's in the IGS_TR_STEP_V).
202:
203:
204: Known limitations,enhancements,remarks:
205:

Line 211: PROCEDURE sync_trk_item_grplmt ( p_tracking_id IGS_TR_STEP_V.tracking_id %TYPE,

207:
208: Who When What
209: ************************************************************************************************************/
210:
211: PROCEDURE sync_trk_item_grplmt ( p_tracking_id IGS_TR_STEP_V.tracking_id %TYPE,
212: p_execute VARCHAR2 DEFAULT 'N'
213: ) ;
214:
215:

Line 238: FUNCTION validate_completion_status ( p_tracking_id IN IGS_TR_STEP_V.TRACKING_ID%TYPE,

234:
235: Who When What
236: ************************************************************************************************************/
237:
238: FUNCTION validate_completion_status ( p_tracking_id IN IGS_TR_STEP_V.TRACKING_ID%TYPE,
239: p_tracking_status IN IGS_TR_ITEM_V.TRACKING_STATUS%TYPE,
240: p_sequence_ind IN IGS_TR_ITEM_V.SEQUENCE_IND%TYPE,
241: p_message_name OUT NOCOPY VARCHAR2
242: ) RETURN BOOLEAN;