DBA Data[Home] [Help]

APPS.CTO_CHANGE_ORDER_PK dependencies on CTO_WORKFLOW

Line 258: CTO_WORKFLOW_API_PK.query_wf_activity_status(

254: oe_debug_pub.add('Adjust_workflow_node: ' || 'p_config_line_id = ' || p_config_line_id, 5);
255: oe_debug_pub.add('Adjust_workflow_node: ' || 'p_can_create_supply = ' || p_can_create_supply, 5);
256: END IF;
257:
258: CTO_WORKFLOW_API_PK.query_wf_activity_status(
259: p_itemtype => 'OEOL',
260: p_itemkey => to_char(p_config_line_id),
261: p_activity_label => 'SHIP_LINE',
262: p_activity_name => 'SHIP_LINE',

Line 267: CTO_WORKFLOW_API_PK.query_wf_activity_status(

263: p_activity_status => l_ship_activity_status);
264:
265: lStmtNumber := 20;
266:
267: CTO_WORKFLOW_API_PK.query_wf_activity_status(
268: p_itemtype => 'OEOL',
269: p_itemkey => to_char(p_config_line_id),
270: p_activity_label => 'CREATE_SUPPLY_ORDER_ELIGIBLE',
271: p_activity_name => 'CREATE_SUPPLY_ORDER_ELIGIBLE',

Line 284: l_return := CTO_WORKFLOW_API_PK.complete_activity(

280:
281: lStmtNumber := 30;
282:
283: -- Move the workflow to ship line
284: l_return := CTO_WORKFLOW_API_PK.complete_activity(
285: p_itemtype => 'OEOL',
286: p_itemkey => to_char(p_config_line_id),
287: p_activity_name => 'CREATE_SUPPLY_ORDER_ELIGIBLE',
288: p_result_code => 'RESERVED');

Line 328: l_return := CTO_WORKFLOW_API_PK.complete_activity(

324: end if; -- bugfix 3076061 Get_Code_Release_Level
325:
326: lStmtNumber := 60;
327:
328: l_return := CTO_WORKFLOW_API_PK.complete_activity(
329: p_itemtype => 'OEOL',
330: p_itemkey => p_config_line_id,
331: p_activity_name => 'SHIP_LINE',
332: p_result_code => 'UNRESERVE');

Line 618: AND CTO_WORKFLOW.config_line_exists(pLineid) <> TRUE

614: -- Quantity changed to zero will be treated as cancelation
615: -- This is as per the discussion with Gayathri Pendse from OM
616: -- bugfix 4293763
617: IF lato_item_flag = 'N'
618: AND CTO_WORKFLOW.config_line_exists(pLineid) <> TRUE
619: THEN
620:
621: IF PG_DEBUG <> 0 THEN
622: oe_debug_pub.add('Change_Notify: ' || 'Config item does not exists , No action needed...',3);

Line 1204: return_value := CTO_WORKFLOW_API_PK.display_wf_status(Lconfig_line_id);

1200: if lqty_change or l_warehouse_change or
1201: (l_unschedule_action and lato_item_flag = 'Y' and
1202: x_source_type in (1, 3))
1203: then
1204: return_value := CTO_WORKFLOW_API_PK.display_wf_status(Lconfig_line_id);
1205: IF PG_DEBUG <> 0 THEN
1206: oe_debug_pub.add('Change_Notify: ' || ' Return value from display_wf_status = '|| return_value,3);
1207: END IF;
1208: end if;

Line 1266: IF CTO_WORKFLOW.flow_sch_exists(pconfigLineId) <> TRUE THEN

1262: END IF;
1263: -- Check if flow schedule exists . If not check some inv/work order Reservation
1264: -- exists. If both of them does'nt exists then return false. Other wise return true.
1265:
1266: IF CTO_WORKFLOW.flow_sch_exists(pconfigLineId) <> TRUE THEN
1267:
1268: IF PG_DEBUG <> 0 THEN
1269: oe_debug_pub.add('Reservation_Exists: ' || 'flow Reservation not exists..',5);
1270:

Line 2653: ELSIF CTO_WORKFLOW.config_line_exists(l_ato_line_id) = TRUE THEN

2649: IF PG_DEBUG <> 0 THEN
2650: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Ato_line_id = '||l_ato_line_id||' Is already processed...',5);
2651: END IF;
2652:
2653: ELSIF CTO_WORKFLOW.config_line_exists(l_ato_line_id) = TRUE THEN
2654:
2655: IF PG_DEBUG <> 0 THEN
2656: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Ato line_id = '||l_ato_line_id||' is having config item..',5);
2657: