489:
490: -- We need to update the workflow status only if the
491: -- status is in CREATE_SUPPLY_ORDER_ELIGIBLE
492:
493: CTO_WORKFLOW_API_PK.query_wf_activity_status( 'OEOL' ,
494: line_id_arr(i) ,
495: 'CREATE_SUPPLY_ORDER_ELIGIBLE',
496: 'CREATE_SUPPLY_ORDER_ELIGIBLE',
497: l_active_activity );
498:
499: IF l_active_activity = 'NOTIFIED' THEN
500:
501: l_stmt_num := 60;
502: l_res := cto_workflow_api_pk.complete_activity(
503: p_itemtype=>'OEOL',
504: p_itemkey =>line_id_arr(i),
505: p_activity_name=>'CREATE_SUPPLY_ORDER_ELIGIBLE',
506: p_result_code=>'COMPLETE');
515:
516: -- We need to update the workflow status only if the
517: -- status is in PURCHASE RELEASE ELIGIBLE
518:
519: CTO_WORKFLOW_API_PK.query_wf_activity_status( 'OEOL' ,
520: line_id_arr(i) ,
521: 'PURCHASE RELEASE ELIGIBLE',
522: 'PURCHASE RELEASE ELIGIBLE',
523: l_active_activity );
522: 'PURCHASE RELEASE ELIGIBLE',
523: l_active_activity );
524: IF l_active_activity = 'NOTIFIED' THEN
525:
526: l_res := cto_workflow_api_pk.complete_activity(
527: p_itemtype=>'OEOL',
528: p_itemkey =>line_id_arr(i),
529: p_activity_name=>'PURCHASE RELEASE ELIGIBLE',
530: p_result_code=>'COMPLETE');