APPS.AHL_VWP_VISITS_STAGES_PVT dependencies on AHL_VWP_STAGES_PKG

Line 716: Ahl_VWP_Stages_Pkg.Insert_Row (

712: END IF;
713:
714: l_stages_tbl(i).STAGE_STATUS_CODE:= 'PLANNING'; -- STAGE INITIAL STATUS :: prakkum :: 15/03/2011 :: VWPE :: ER 12424063
715:
716: Ahl_VWP_Stages_Pkg.Insert_Row (
717: X_ROWID => l_rowid,
718: X_VISIT_ID => P_VISIT_ID,
719: X_STAGE_ID => l_stages_tbl(i).STAGE_ID,
720: X_STAGE_NUM => l_stages_tbl(i).Stage_Num,

Line 1107: Ahl_VWP_stages_Pkg.Update_Row (

1103: if l_validate_status = Fnd_Api.G_RET_STS_SUCCESS
1104: then
1105: -- Invoke the table handler to update the record
1106: --
1107: Ahl_VWP_stages_Pkg.Update_Row (
1108: X_VISIT_ID => P_VISIT_ID,
1109: X_STAGE_ID => p_x_stages_tbl(i).STAGE_ID,
1110: X_STAGE_NUM => p_x_stages_tbl(i).STAGE_NUM,
1111: X_STAGE_NAME => p_x_stages_tbl(i).STAGE_NAME,

Line 1596: Ahl_VWP_stages_Pkg.DELETE_ROW ( X_STAGE_ID => p_x_stages_tbl(i).STAGE_ID);

1592: END IF;
1593:
1594: -- VWPE 12730539:: PRAKKUM :: 20-JUL-2011 :: end
1595:
1596: Ahl_VWP_stages_Pkg.DELETE_ROW ( X_STAGE_ID => p_x_stages_tbl(i).STAGE_ID);
1597:
1598: -- Remove all stage assciations on tasks
1599: IF (l_log_statement >= l_log_current_level) THEN
1600: fnd_log.string(l_log_statement,L_DEBUG,p_x_stages_tbl(i).STAGE_ID||' stage id updated');

Line 2972: Ahl_VWP_Stages_Pkg.INSERT_ASSOC_ROW (

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,
2975: X_STAGE_ID => p_stage_type_assoc_tbl(i).STAGE_ID,
2976: X_STAGE_TYPE_CODE => p_stage_type_assoc_tbl(i).STAGE_TYPE_CODE,

Line 3255: Ahl_VWP_Stages_Pkg.Insert_Row (

3251: 'Before calling table handler for inserting a record. stage ID is '||l_stage_id|| ' previous stage number is: '||l_prev_stage_num);
3252: END IF;
3253:
3254: -- Invoke the table handler to create a record
3255: Ahl_VWP_Stages_Pkg.Insert_Row (
3256: X_ROWID => l_rowid,
3257: X_VISIT_ID => P_VISIT_ID,
3258: X_STAGE_ID => l_stage_id,
3259: X_STAGE_NUM => l_stages_rec.stage_number,