APPS.ZPB_AC_OPS dependencies on ZPB_RELATIONSHIP_ID_SEQ

Line 1350: SELECT zpb_relationship_id_seq.NEXTVAL INTO relationship_id FROM DUAL;

1346:
1347: BEGIN
1348: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;
1349: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO current_inst_id FROM DUAL;
1350: SELECT zpb_relationship_id_seq.NEXTVAL INTO relationship_id FROM DUAL;
1351:
1352: if lower(is_comments_copied) = 'false' then comments := false; end if;
1353: if lower(is_analy_excep_copied) = 'false' then analy_excep := false; end if;
1354:

Line 1458: SELECT zpb_relationship_id_seq.NEXTVAL INTO relationship_id FROM DUAL;

1454: ac_rec zpb_analysis_cycles%ROWTYPE;
1455: BEGIN
1456: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;
1457: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO current_inst_id FROM DUAL;
1458: SELECT zpb_relationship_id_seq.NEXTVAL INTO relationship_id FROM DUAL;
1459:
1460: ac_rec.analysis_cycle_id := new_ac_id;
1461: ac_rec.name := ac_name_in;
1462: ac_rec.validate_status := 'INVALID';

Line 2727: SELECT zpb_relationship_id_seq.NEXTVAL INTO relationship_id FROM DUAL;

2723: -- Initialize API return status to success
2724: x_return_status := FND_API.G_RET_STS_SUCCESS;
2725: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;
2726: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO current_inst_id FROM DUAL;
2727: SELECT zpb_relationship_id_seq.NEXTVAL INTO relationship_id FROM DUAL;
2728:
2729: ac_rec.analysis_cycle_id := new_ac_id;
2730: ac_rec.name := p_cycle_name;
2731: ac_rec.description := p_description;