APPS.CTO_WORKFLOW dependencies on CTO_WORKFLOW_API_PK

Line 124: | and corrected use of cto_workflow_api_pk.display_wf_status

120: |
121: |
122: | 01/19/04 Sushant Sawant
123: | Fixed Bug 3380730, 3380874 to provide proper status code on config line
124: | and corrected use of cto_workflow_api_pk.display_wf_status
125: |
126: |
127: | 01/23/04 Sushant Sawant
128: | Fixed Bug 3388135 to provide message for match in case of dropship models.

Line 895: CTO_WORKFLOW_API_PK.query_wf_activity_status(

891:
892:
893: l_stmt_num := 155;
894:
895: CTO_WORKFLOW_API_PK.query_wf_activity_status(
896: p_itemtype => 'OEOL' ,
897: p_itemkey => to_char(l_config_line_id ) ,
898: p_activity_label => 'CREATE_CONFIG_BOM_ELIGIBLE',
899: p_activity_name => 'CREATE_CONFIG_BOM_ELIGIBLE',

Line 1261: CTO_WORKFLOW_API_PK.get_activity_status(

1257: oe_debug_pub.add('create_config_item_wf: ' || 'going to get Workflow Status for config line : ' ||
1258: to_char( l_config_line_id ) , 1 );
1259: END IF;
1260:
1261: CTO_WORKFLOW_API_PK.get_activity_status(
1262: itemtype => 'OEOL',
1263: itemkey => to_char(l_config_line_id),
1264: linetype => 'CONFIG',
1265: activity_name => l_active_activity);

Line 1275: CTO_WORKFLOW_API_PK.query_wf_activity_status(

1271:
1272:
1273: l_stmt_num := 178;
1274:
1275: CTO_WORKFLOW_API_PK.query_wf_activity_status(
1276: p_itemtype => 'OEOL' ,
1277: p_itemkey => to_char(l_config_line_id ) ,
1278: p_activity_label => 'SHIP_LINE',
1279: p_activity_name => 'SHIP_LINE',

Line 2286: return_value:= CTO_WORKFLOW_API_PK.display_wf_status(to_number(p_itemkey));

2282: --below code calls display_wf_status to update the correct
2283: --before booking and scheduling if item is reserved
2284: --
2285: l_stmt_num := 100;
2286: return_value:= CTO_WORKFLOW_API_PK.display_wf_status(to_number(p_itemkey));
2287:
2288: if return_value <> 1 then
2289: cto_msg_pub.cto_message('CTO', 'CTO_ERROR_FROM_DISPLAY_STATUS');
2290: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3182: l_ret_stat :=CTO_WORKFLOW_API_PK.display_wf_status

3178: IF PG_DEBUG <> 0 THEN
3179: oe_debug_pub.add('check_supply_type_wf: ' ||'calling display_wf_status with status',1);
3180: END IF;
3181:
3182: l_ret_stat :=CTO_WORKFLOW_API_PK.display_wf_status
3183: (p_order_line_id=>p_itemkey
3184: );
3185:
3186: IF l_ret_stat = 1 THEN

Line 4067: CTO_WORKFLOW_API_PK.query_wf_activity_status(

4063:
4064: if (p_funcmode = 'RUN') then
4065:
4066: l_stmt_num := 10;
4067: CTO_WORKFLOW_API_PK.query_wf_activity_status(
4068: p_itemtype => p_itemtype,
4069: p_itemkey => p_itemkey,
4070: p_activity_label => 'EXECLEADTIME',
4071: p_activity_name => 'EXECLEADTIME',

Line 4084: CTO_WORKFLOW_API_PK.query_wf_activity_status(

4080: IF PG_DEBUG <> 0 THEN
4081: oe_debug_pub.add('submit_and_continue_wf: ' || 'Show message for Lead Time conc program',1);
4082: END IF;
4083: ELSE
4084: CTO_WORKFLOW_API_PK.query_wf_activity_status(
4085: p_itemtype => p_itemtype,
4086: p_itemkey => p_itemkey,
4087: p_activity_label => 'EXECUTECONCPROGAFAS',
4088: p_activity_name => 'EXECUTECONCPROGAFAS',

Line 4760: return_value:= CTO_WORKFLOW_API_PK.display_wf_status(to_number(p_itemkey));

4756:
4757:
4758:
4759: l_stmt_num:=25;
4760: return_value:= CTO_WORKFLOW_API_PK.display_wf_status(to_number(p_itemkey));
4761:
4762:
4763: IF PG_DEBUG <> 0 THEN
4764: oe_debug_pub.add('check_supply_creation_wf: ' || 'return value from display_wf_status'

Line 4837: return_value:= CTO_WORKFLOW_API_PK.display_wf_status(to_number(p_itemkey));

4833: END IF;--l_return_status
4834:
4835:
4836: l_stmt_num:=70;
4837: return_value:= CTO_WORKFLOW_API_PK.display_wf_status(to_number(p_itemkey));
4838:
4839:
4840: IF PG_DEBUG <> 0 THEN
4841: oe_debug_pub.add('check_supply_creation_wf: ' || 'return value from display_wf_status'