[Home] [Help]
3416: l_seq NUMBER;
3417:
3418: cursor c_seq is
3419: select okl_inst_checklist_num_s.nextval
3420: from dual;
3421:
3422: begin
3423: -- Set API savepoint
3424: SAVEPOINT create_checklist_inst_hdr;
4094: -- Procedure Name : chk_eligible_for_approval
4095: -- Description : Check if it's eligible for approval
4096: -- Business Rules :
4097: -- The following scenarios are not eligible for approval
4098: -- 1 Checklist template (either group or individual) status is Active.
4099: -- 2 Group checklist template doesn't have child checklist assocaite with it.
4100: -- 3 Group checklist template does have child checklist associate with it,
4101: -- but child checklist doesn't have items defined.
4102: -- 4 Checklist template does have group checklist assocaite with it (Has parent checklist).
4187:
4188:
4189: /*** Begin API body ****************************************************/
4190: -- The following scenarios are not eligible for approval
4191: -- 1 Checklist template (either group or individual) status is Active.
4192: -- 2 Group checklist template doesn't have child checklist assocaite with it.
4193: -- 3 Group checklist template does have child checklist associate with it,
4194: -- but child checklist doesn't have items defined.
4195: -- 4 Checklist template does have group checklist assocaite with it (Has parent checklist).
4197: -- 6. Checklist item effetcive from date must with the checklist header's date range
4198:
4199: FOR r_this_row IN c_checklists (p_clh_id) LOOP
4200:
4201: -- 1 Checklist template (either group or individual) status is Active.
4202: IF r_this_row.status_code = G_ACTIVE_STS_CODE THEN
4203: OKL_API.Set_Message(p_app_name => G_APP_NAME,
4204: p_msg_name => 'OKL_CHK_STATUS_4_APPROVAL');
4205: