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 804: iex_strategy_pvt.create_strategy(

800: END IF;
801:
802: Begin
803:
804: iex_strategy_pvt.create_strategy(
805: P_Api_Version_Number=>2.0,
806: p_commit => FND_API.G_FALSE,
807: P_Init_Msg_List =>FND_API.G_FALSE,
808: p_strategy_rec => l_strategy_rec,

Line 1219: l_strategy_rec IEX_STRATEGY_PVT.STRATEGY_REC_TYPE;

1215: Cursor c_delinquency_status(p_delinquency_id number) is
1216: select status from iex_delinquencies
1217: where delinquency_id = p_delinquency_id;
1218:
1219: l_strategy_rec IEX_STRATEGY_PVT.STRATEGY_REC_TYPE;
1220:
1221: l_Init_Msg_List VARCHAR2(10) ;
1222: l_Commit VARCHAR2(10) ;
1223: l_validation_level NUMBER ;

Line 1347: iex_strategy_pvt.update_strategy(

1343: l_strategy_rec.status_code := p_status;
1344:
1345: Begin
1346:
1347: iex_strategy_pvt.update_strategy(
1348: P_Api_Version_Number=>2.0,
1349: p_commit => FND_API.G_FALSE,
1350: P_Init_Msg_List =>FND_API.G_FALSE,
1351: p_strategy_rec => l_strategy_rec,

Line 1513: l_strategy_rec IEX_STRATEGY_PVT.STRATEGY_REC_TYPE;

1509: and w.work_item_template_id = t.work_item_temp_id(+)
1510: order by s.creation_date desc;
1511: --End bug 6723540 gnramasa 02 Jan 08
1512:
1513: l_strategy_rec IEX_STRATEGY_PVT.STRATEGY_REC_TYPE;
1514:
1515: begin
1516: -- initialize variables
1517: l_api_name := 'GetStrategyCurrentWorkItem';

Line 1679: l_strategy_rec IEX_STRATEGY_PVT.STRATEGY_REC_TYPE;

1675: Cursor c_strategy_exists(p_delinquency_id number, p_object_id number, p_object_type varchar2) is
1676: select strategy_id, status_code, object_version_number from iex_strategies where ((delinquency_id = p_delinquency_id and
1677: object_id = p_object_id and object_type = p_object_type)) and (checklist_yn IS NULL or checkList_YN = 'N');
1678: */
1679: l_strategy_rec IEX_STRATEGY_PVT.STRATEGY_REC_TYPE;
1680:
1681: l_Init_Msg_List VARCHAR2(10) ;
1682: l_Commit VARCHAR2(10) ;
1683: l_validation_level NUMBER ;

Line 1790: iex_strategy_pvt.update_strategy(

1786: l_strategy_rec.status_code := 'CLOSED';
1787:
1788: Begin
1789:
1790: iex_strategy_pvt.update_strategy(
1791: P_Api_Version_Number=>2.0,
1792: p_commit => FND_API.G_FALSE,
1793: P_Init_Msg_List =>FND_API.G_FALSE,
1794: p_strategy_rec => l_strategy_rec,