APPS.OTA_EVENT_API dependencies on OTA_EVALUATIONS

Line 1006: l_mand_flag ota_evaluations.eval_mandatory_flag%type;

1002: p_activity_version_id in number
1003: ) is
1004:
1005: l_eval_id ota_tests.test_id%type :=null;
1006: l_mand_flag ota_evaluations.eval_mandatory_flag%type;
1007:
1008: Cursor c_dflt_eval is
1009: select dflt_class_eval_id,eval_mandatory_flag
1010: into l_eval_id,l_mand_flag

Line 1011: from ota_evaluations

1007:
1008: Cursor c_dflt_eval is
1009: select dflt_class_eval_id,eval_mandatory_flag
1010: into l_eval_id,l_mand_flag
1011: from ota_evaluations
1012: where object_id = p_activity_version_id
1013: and object_type = 'A';
1014:
1015: l_proc varchar2(72) := g_package ||'add_evaluation';

Line 1022: insert into ota_evaluations (evaluation_id,

1018: open c_dflt_eval;
1019: fetch c_dflt_eval into l_eval_id, l_mand_flag;
1020: close c_dflt_eval;
1021: if l_eval_id is not null then
1022: insert into ota_evaluations (evaluation_id,
1023: eval_mandatory_flag,
1024: object_id,
1025: object_type,
1026: object_version_number) values