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 616: AND CTO_WORKFLOW.config_line_exists(pLineid) <> TRUE

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

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

1181: if lqty_change or l_warehouse_change or
1182: (l_unschedule_action and lato_item_flag = 'Y' and
1183: x_source_type in (1, 3))
1184: then
1185: return_value := CTO_WORKFLOW_API_PK.display_wf_status(Lconfig_line_id);
1186: IF PG_DEBUG <> 0 THEN
1187: oe_debug_pub.add('Change_Notify: ' || ' Return value from display_wf_status = '|| return_value,3);
1188: END IF;
1189: end if;

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

1243: END IF;
1244: -- Check if flow schedule exists . If not check some inv/work order Reservation
1245: -- exists. If both of them does'nt exists then return false. Other wise return true.
1246:
1247: IF CTO_WORKFLOW.flow_sch_exists(pconfigLineId) <> TRUE THEN
1248:
1249: IF PG_DEBUG <> 0 THEN
1250: oe_debug_pub.add('Reservation_Exists: ' || 'flow Reservation not exists..',5);
1251:

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

2409: IF PG_DEBUG <> 0 THEN
2410: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Ato_line_id = '||l_ato_line_id||' Is already processed...',5);
2411: END IF;
2412:
2413: ELSIF CTO_WORKFLOW.config_line_exists(l_ato_line_id) = TRUE THEN
2414:
2415: IF PG_DEBUG <> 0 THEN
2416: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Ato line_id = '||l_ato_line_id||' is having config item..',5);
2417: