DBA Data[Home] [Help]

APPS.IEX_STRATEGY_PUB dependencies on IEX_STRATEGY_PVT

Line 77: l_strategy_rec IEX_STRATEGY_PVT.STRATEGY_REC_TYPE;

73: --End bug 6723540 gnramasa 02 Jan 08
74:
75: l_stry_cnt_rec IEX_STRATEGY_TYPE_PUB.STRY_CNT_REC_TYPE ;
76:
77: l_strategy_rec IEX_STRATEGY_PVT.STRATEGY_REC_TYPE;
78:
79: Cursor c_score_exists( p_object_id number, p_object_type varchar2) is
80: select score_value
81: from iex_score_histories

Line 845: iex_strategy_pvt.create_strategy(

841: END IF;
842:
843: Begin
844:
845: iex_strategy_pvt.create_strategy(
846: P_Api_Version_Number=>2.0,
847: p_commit => FND_API.G_FALSE,
848: P_Init_Msg_List =>FND_API.G_FALSE,
849: p_strategy_rec => l_strategy_rec,

Line 1289: l_strategy_rec IEX_STRATEGY_PVT.STRATEGY_REC_TYPE;

1285: Cursor C_Strategy_Status(fStrategyID number) is
1286: select work_item_id from iex_strategy_work_items where strategy_id=fStrategyID and status_code in ('OPEN');
1287: -- End for bug#7416344
1288:
1289: l_strategy_rec IEX_STRATEGY_PVT.STRATEGY_REC_TYPE;
1290:
1291: l_Init_Msg_List VARCHAR2(10) ;
1292: l_Commit VARCHAR2(10) ;
1293: l_validation_level NUMBER ;

Line 1441: iex_strategy_pvt.update_strategy(

1437: l_strategy_rec.status_code := p_status;
1438:
1439: Begin
1440:
1441: iex_strategy_pvt.update_strategy(
1442: P_Api_Version_Number=>2.0,
1443: p_commit => FND_API.G_FALSE,
1444: P_Init_Msg_List =>FND_API.G_FALSE,
1445: p_strategy_rec => l_strategy_rec,

Line 1613: l_strategy_rec IEX_STRATEGY_PVT.STRATEGY_REC_TYPE;

1609: and w.work_item_template_id = t.work_item_temp_id(+)
1610: order by s.creation_date desc;
1611: --End bug 6723540 gnramasa 02 Jan 08
1612:
1613: l_strategy_rec IEX_STRATEGY_PVT.STRATEGY_REC_TYPE;
1614:
1615: begin
1616: -- initialize variables
1617: l_api_name := 'GetStrategyCurrentWorkItem';

Line 1779: l_strategy_rec IEX_STRATEGY_PVT.STRATEGY_REC_TYPE;

1775: Cursor c_strategy_exists(p_delinquency_id number, p_object_id number, p_object_type varchar2) is
1776: select strategy_id, status_code, object_version_number from iex_strategies where ((delinquency_id = p_delinquency_id and
1777: object_id = p_object_id and object_type = p_object_type)) and (checklist_yn IS NULL or checkList_YN = 'N');
1778: */
1779: l_strategy_rec IEX_STRATEGY_PVT.STRATEGY_REC_TYPE;
1780:
1781: l_Init_Msg_List VARCHAR2(10) ;
1782: l_Commit VARCHAR2(10) ;
1783: l_validation_level NUMBER ;

Line 1908: iex_strategy_pvt.update_strategy(

1904: l_strategy_rec.status_code := 'CLOSED';
1905:
1906: Begin
1907:
1908: iex_strategy_pvt.update_strategy(
1909: P_Api_Version_Number=>2.0,
1910: p_commit => FND_API.G_FALSE,
1911: P_Init_Msg_List =>FND_API.G_FALSE,
1912: p_strategy_rec => l_strategy_rec,