[Home] [Help]
1366:
1367: Cursor c_stage_links(x_id IN NUMBER) IS
1368: SELECT distinct STG_LK.STAGE_LINK_ID, STG_LK.OBJECT_ID, STG_LK.SUBJECT_ID, STG_LK.RELATION_TYPE
1369: FROM
1370: AHL_STAGE_LINKS STG_LK
1371: WHERE ( STG_LK.OBJECT_ID = x_id OR STG_LK.SUBJECT_ID = x_id );
1372:
1373: l_stagelinks_rec c_stage_links%ROWTYPE;
1374:
3430: LAST_UPDATE_LOGIN
3431: )
3432: values
3433: (
3434: AHL_STAGE_LINKS_S.nextval,
3435: l_stage_rules_rec.object_id,
3436: l_stage_rules_rec.subject_id,
3437: l_stage_rules_rec.relation_type,
3438: 1,
3618: Cursor c_parallel_stages_dets(vst_id IN NUMBER) IS
3619: SELECT distinct STAGE_LINK_ID,subject_ID,object_ID FROM
3620: ahl_stage_links ,AHL_VWP_STAGES_B
3621: WHERE RELATION_TYPE='PARALLEL'
3622: AND ( ahl_stage_links.subject_id=AHL_VWP_STAGES_B.stage_id OR ahl_stage_links.object_id=AHL_VWP_STAGES_B.stage_id)
3623: AND VISIT_ID =vst_id;
3624:
3625: l_parallel_stg_dets c_parallel_stages_dets%RowType;
3626:
3844: Cursor c_parallel_stages_dets(vst_id IN NUMBER) IS
3845: SELECT distinct STAGE_LINK_ID,subject_ID,object_ID FROM
3846: ahl_stage_links ,AHL_VWP_STAGES_B
3847: WHERE RELATION_TYPE='PARALLEL'
3848: AND ( ahl_stage_links.subject_id=AHL_VWP_STAGES_B.stage_id OR ahl_stage_links.object_id=AHL_VWP_STAGES_B.stage_id)
3849: AND VISIT_ID =vst_id;
3850:
3851: l_parallel_stg_dets c_parallel_stages_dets%RowType;
3852:
4112: Cursor c_parallel_stages_dets(vst_id IN NUMBER) IS
4113: SELECT distinct STAGE_LINK_ID,subject_ID,object_ID FROM
4114: ahl_stage_links ,AHL_VWP_STAGES_B
4115: WHERE RELATION_TYPE='PARALLEL'
4116: AND ( ahl_stage_links.subject_id=AHL_VWP_STAGES_B.stage_id OR ahl_stage_links.object_id=AHL_VWP_STAGES_B.stage_id)
4117: AND VISIT_ID =vst_id;
4118:
4119: l_parallel_stg_dets c_parallel_stages_dets%RowType;
4120:
4681: cursor c_stage_rules_count (p_visit_id IN NUMBER)
4682: IS
4683: SELECT count(1) as cnt
4684: FROM
4685: AHL_STAGE_LINKS STG_LK,AHL_VWP_STAGES_B STG
4686: WHERE ( STG.STAGE_ID = STG_LK.subject_ID OR STG.STAGE_ID = STG_LK.object_ID )
4687: AND STG.VISIT_ID = p_visit_id;
4688: /*
4689: --cursor to find stages whose earliest start date not wintinh stage planned start date and end dates
4848:
4849: SELECT distinct STG_LK.subject_ID, STG_LK.object_ID, STG_LK.RELATION_TYPE
4850: BULK COLLECT INTO l_stages_links
4851: FROM
4852: AHL_STAGE_LINKS STG_LK,AHL_VWP_STAGES_B STG
4853: WHERE ( STG.STAGE_ID = STG_LK.subject_ID OR STG.STAGE_ID = STG_LK.object_ID )
4854: AND STG.VISIT_ID = p_visit_id;
4855:
4856: IF (l_log_statement >= l_log_current_level) THEN
5718: Cursor c_parallel_stages_dets(vst_id IN NUMBER) IS
5719: SELECT distinct STAGE_LINK_ID,subject_ID,object_ID FROM
5720: ahl_stage_links ,AHL_VWP_STAGES_B
5721: WHERE RELATION_TYPE='PARALLEL'
5722: AND ( ahl_stage_links.subject_id=AHL_VWP_STAGES_B.stage_id OR ahl_stage_links.object_id=AHL_VWP_STAGES_B.stage_id)
5723: AND VISIT_ID =vst_id;
5724:
5725: l_parallel_stg_dets c_parallel_stages_dets%RowType;
5726: