DBA Data[Home] [Help]

APPS.IEX_STRATEGY_WF dependencies on IEX_STRATEGY_WORK_ITEMS_PVT

Line 511: p_strategy_work_item_rec IN IEX_STRATEGY_WORK_ITEMS_PVT.STRATEGY_WORK_ITEM_REC_TYPE,

507: (
508: p_work_item_temp_id IN NUMBER,
509: itemtype IN varchar2,
510: itemkey IN varchar2,
511: p_strategy_work_item_rec IN IEX_STRATEGY_WORK_ITEMS_PVT.STRATEGY_WORK_ITEM_REC_TYPE,
512: x_schedule_start OUT NOCOPY DATE,
513: x_schedule_end OUT NOCOPY DATE
514: ) IS
515:

Line 1009: l_strategy_work_item_rec IEX_STRATEGY_WORK_ITEMS_PVT.STRATEGY_WORK_ITEM_REC_TYPE;

1005: category_type,fulfil_temp_id
1006: from iex_stry_temp_work_items_vl
1007: where work_item_temp_id =p_work_item_temp_id;
1008:
1009: l_strategy_work_item_rec IEX_STRATEGY_WORK_ITEMS_PVT.STRATEGY_WORK_ITEM_REC_TYPE;
1010: l_return_status VARCHAR2(1) ;
1011: l_msg_count NUMBER;
1012: l_msg_data VARCHAR2(32767);
1013: x_work_item_id NUMBER;

Line 1314: iex_strategy_work_items_pvt.create_strategy_work_items

1310: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1311: iex_debug_pub.logmessage ('before calling create_work_pvt.create');
1312: END IF;
1313:
1314: iex_strategy_work_items_pvt.create_strategy_work_items
1315: (P_Api_Version_Number =>2.0,
1316: P_Init_Msg_List =>FND_API.G_TRUE,
1317: P_Commit =>FND_API.G_FALSE,
1318: p_validation_level =>FND_API.G_VALID_LEVEL_FULL,

Line 4698: l_strategy_work_item_rec IEX_strategy_work_items_PVT.strategy_work_item_Rec_Type;

4694: l_party_id NUMBER;
4695: exc EXCEPTION;
4696: l_error VARCHAR2(32767);
4697: l_object_version_number number;
4698: l_strategy_work_item_rec IEX_strategy_work_items_PVT.strategy_work_item_Rec_Type;
4699: l_status_code iex_strategy_work_items.status_code%type;
4700: Cursor c_get_work_items (p_work_item_id NUMBER) is
4701: SELECT status_code, object_version_number
4702: FROM iex_strategy_work_items

Line 4736: IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items(

4732: close c_get_work_items;
4733: l_strategy_work_item_Rec.work_item_id := l_work_item_id;
4734: l_strategy_work_item_Rec.object_version_number :=l_object_version_number;
4735: l_strategy_work_item_Rec.escalated_yn := 'Y';
4736: IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items(
4737: P_Api_Version_Number =>l_api_version_number,
4738: P_strategy_work_item_Rec =>l_strategy_work_item_Rec,
4739: P_Init_Msg_List =>FND_API.G_TRUE,
4740: p_commit =>FND_API.G_TRUE,