DBA Data[Home] [Help]

APPS.AHL_VWP_VISITS_STAGES_PVT dependencies on AHL_VISIT_STAGE_TYP_ASOC

Line 2970: -- Invoke the table handler to create a record in "AHL_VISIT_STAGE_TYP_ASOC"

2966: IF (l_log_statement >= l_log_current_level) THEN
2967: fnd_log.string(l_log_statement,L_DEBUG_KEY,'DML operation for the record is Create');
2968: END IF;
2969: --We need to create an association between the passed stage type and stage id
2970: -- Invoke the table handler to create a record in "AHL_VISIT_STAGE_TYP_ASOC"
2971:
2972: Ahl_VWP_Stages_Pkg.INSERT_ASSOC_ROW (
2973: X_ROWID => l_rowid,
2974: X_STAGE_TYPE_ASSOC_ID => p_stage_type_assoc_tbl(i).STAGE_TYPE_ASSOC_ID,

Line 3335: INSERT INTO AHL_VISIT_STAGE_TYP_ASOC(

3331:
3332: -- Fetch all the stage-stage type associations of a stage and loop through all those records.
3333: FOR l_stagetypes_rec IN get_stage_types(l_stages_rec.visit_type_stage_id)
3334: LOOP
3335: INSERT INTO AHL_VISIT_STAGE_TYP_ASOC(
3336: STAGE_TYPE_ASSOC_ID,
3337: STAGE_ID,
3338: STAGE_TYPE_CODE,
3339: SECURITY_GROUP_ID,

Line 3347: AHL_VISIT_STAGE_TYP_ASOC_S.nextval,

3343: LAST_UPDATED_BY,
3344: LAST_UPDATE_LOGIN)
3345: values
3346: (
3347: AHL_VISIT_STAGE_TYP_ASOC_S.nextval,
3348: l_stage_id,
3349: l_stagetypes_rec.stage_type_code,
3350: null,
3351: SYSDATE,