[Home] [Help]
13814: LOOP
13815: -- fetch the CHANGE_LIFECYCLE_STATUS_ID from sequence
13816: SELECT ENG_LIFECYCLE_STATUSES_S.NEXTVAL
13817: INTO l_lifecycle_status_id
13818: FROM dual;
13819:
13820: -- Insert the Statuses data
13821: INSERT INTO ENG_LIFECYCLE_STATUSES
13822: ( CHANGE_LIFECYCLE_STATUS_ID
13997:
13998: FOR change_line IN c_change_tasks(p_change_type_id, p_organization_id)
13999: LOOP
14000:
14001: SELECT eng_change_lines_s.nextval INTO l_change_line_unexp_rec.change_line_id FROM SYS.DUAL;
14002: l_change_line_unexp_rec.change_id := p_change_id;
14003: l_change_line_unexp_rec.change_type_id := -1;
14004: l_change_line_rec.sequence_number := change_line.sequence_number;
14005: l_change_line_rec.name := change_line.task_name;
14083: begin
14084:
14085: select ENG_CHANGE_OBJ_RELATIONSHIPS_S.nextval
14086: into l_new_prop_relation
14087: from dual;
14088:
14089: insert into eng_change_obj_relationships (
14090: CHANGE_RELATIONSHIP_ID,
14091: CHANGE_ID,
17221:
17222: FOR C_CHANGES_REC IN C_CHANGES LOOP
17223:
17224: -- Get new ROute Id
17225: SELECT ENG_CHANGE_ROUTES_S.NEXTVAL into l_to_route_id FROM DUAL;
17226:
17227: IF Bom_Globals.Get_Debug = 'Y' THEN
17228: Error_Handler.Write_Debug('Inside Loop Template_id: ' ||
17229: C_CHANGES_REC.CHANGE_WF_ROUTE_TEMPLATE_ID);
17321: IF (l_people_existed_flag = 0) THEN
17322: -- generate new people id
17323: SELECT ENG_CHANGE_ROUTE_PEOPLE_S.NEXTVAL
17324: into l_people_id
17325: FROM DUAL;
17326:
17327: INSERT INTO ENG_CHANGE_ROUTE_PEOPLE
17328: (route_people_id,
17329: step_id,
17403: ELSE
17404: -- generate new people id
17405: SELECT ENG_CHANGE_ROUTE_PEOPLE_S.NEXTVAL
17406: into l_people_id
17407: FROM DUAL;
17408:
17409: --insert an 'Unassigned' assignee record
17410: INSERT INTO ENG_CHANGE_ROUTE_PEOPLE
17411: (route_people_id,
17503: IF (l_people_existed_flag = 0) THEN
17504: -- generate new people id
17505: SELECT ENG_CHANGE_ROUTE_PEOPLE_S.NEXTVAL
17506: into l_people_id
17507: FROM DUAL;
17508:
17509: INSERT INTO ENG_CHANGE_ROUTE_PEOPLE
17510: (route_people_id,
17511: step_id,
17585: ELSE
17586: -- generate new people id
17587: SELECT ENG_CHANGE_ROUTE_PEOPLE_S.NEXTVAL
17588: into l_people_id
17589: FROM DUAL;
17590:
17591: --insert an 'Unassigned' assignee record
17592: INSERT INTO ENG_CHANGE_ROUTE_PEOPLE
17593: (route_people_id,
17684: IF (l_people_existed_flag = 0) THEN
17685: -- generate new people id
17686: SELECT ENG_CHANGE_ROUTE_PEOPLE_S.NEXTVAL
17687: into l_people_id
17688: FROM DUAL;
17689:
17690: INSERT INTO ENG_CHANGE_ROUTE_PEOPLE
17691: (route_people_id,
17692: step_id,
17786: IF (l_people_existed_flag = 0) THEN
17787: -- generate new people id
17788: SELECT ENG_CHANGE_ROUTE_PEOPLE_S.NEXTVAL
17789: into l_people_id
17790: FROM DUAL;
17791:
17792: INSERT INTO ENG_CHANGE_ROUTE_PEOPLE
17793: (route_people_id,
17794: step_id,
17879: IF (l_people_existed_flag = 0) THEN
17880: -- generate new people id
17881: SELECT ENG_CHANGE_ROUTE_PEOPLE_S.NEXTVAL
17882: into l_people_id
17883: FROM DUAL;
17884:
17885: INSERT INTO ENG_CHANGE_ROUTE_PEOPLE
17886: (route_people_id,
17887: step_id,
17982: IF (l_people_existed_flag = 0) THEN
17983: -- generate new people id
17984: SELECT ENG_CHANGE_ROUTE_PEOPLE_S.NEXTVAL
17985: into l_people_id
17986: FROM DUAL;
17987:
17988: INSERT INTO ENG_CHANGE_ROUTE_PEOPLE
17989: (route_people_id,
17990: step_id,
18075: IF (l_people_existed_flag = 0) THEN
18076: -- generate new people id
18077: SELECT ENG_CHANGE_ROUTE_PEOPLE_S.NEXTVAL
18078: into l_people_id
18079: FROM DUAL;
18080:
18081: INSERT INTO ENG_CHANGE_ROUTE_PEOPLE
18082: (route_people_id,
18083: step_id,
18167: IF(l_row_inserted_flag = 0) THEN -- bug 13860012
18168: -- generate new people id
18169: SELECT ENG_CHANGE_ROUTE_PEOPLE_S.NEXTVAL
18170: into l_people_id
18171: FROM DUAL;
18172:
18173: --insert an 'Unassigned' assignee record
18174: INSERT INTO ENG_CHANGE_ROUTE_PEOPLE
18175: (route_people_id,