[Home] [Help]
71: C_Cont_Repossession varchar2(1000) ;
72: C_Cont_Litigation varchar2(1000) ;
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
286: ' , NULL strategy_level, litigation_id jtf_object_id, ''IEX_LITIGATION'' jtf_object_type ' ||
287: ' from iex_litigations where litigation_id = :p_ObjectID ';
288: --End bug 6723540 gnramasa 02 Jan 08
289:
290: l_stry_cnt_rec := IEX_STRATEGY_TYPE_PUB.INST_STRY_CNT_REC;
291:
292: l_default_rs_id := fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE');
293: l_resource_id := fnd_profile.value('IEX_STRY_FULFILMENT_RESOURCE');
294: b_Skip := 'F';
976: END create_strategy;
977:
978:
979: PROCEDURE GetStrategyTempID(
980: p_stry_cnt_rec in IEX_STRATEGY_TYPE_PUB.STRY_CNT_REC_TYPE,
981: x_return_status out NOCOPY varchar2,
982: x_strategy_template_id out NOCOPY number) IS
983: /*
984: CURSOR c_strategyTemp(pCategoryType varchar2, pDelinquencyID number) IS