[Home] [Help]
92: where score_object_id = p_object_id
93: and score_object_code = p_object_type
94: order by creation_date desc;
95:
96: l_stry_cnt_rec IEX_STRATEGY_TYPE_PUB.STRY_CNT_REC_TYPE ;
97:
98: -- Begin - Andre - bug#4551569 - Change cursor to find 2 types of objects
99: Cursor c_score_exists_del(p_object_id number, p_object_type varchar2, p_object_id2 number, p_object_type2 varchar2) is
100: select score_value, score_object_id, score_object_code
152:
153: BEGIN
154: -- initialize variable here
155: l_api_name := 'START_WORKFLOW';
156: l_stry_cnt_rec := IEX_STRATEGY_TYPE_PUB.INST_STRY_CNT_REC;
157: l_default_rs_id := NVL(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'), 0);
158: l_resource_id := NVL(fnd_profile.value('IEX_STRY_FULFILMENT_RESOURCE'), 0);
159: b_Skip := 'F';
160: l_gracePeriod := NVL(to_number(FND_PROFILE.VALUE('IEX_STRY_GRACE_PERIOD')), 0);
931: s.object_id, s.object_type, s.strategy_template_id, s.jtf_object_type, s.jtf_object_id
932: from iex_strategies s where s.status_code IN (l_StratStatusOpen, l_StratStatusOnhold) AND
933: checklist_yn = 'N';
934:
935: l_stry_cnt_rec IEX_STRATEGY_TYPE_PUB.STRY_CNT_REC_TYPE ;
936:
937: l_strategy_rec IEX_STRATEGY_PVT.STRATEGY_REC_TYPE;
938:
939: l_itemtype varchar2(30);
942: BEGIN
943:
944: -- initialize variables
945: l_api_name := 'START_WORKFLOW';
946: l_stry_cnt_rec := IEX_STRATEGY_TYPE_PUB.INST_STRY_CNT_REC;
947:
948: -- Initialize API return status to SUCCESS
949: l_return_status := FND_API.G_RET_STS_SUCCESS;
950: -- Standard Start of API savepoint
1323: END PROCESS_ONHOLD_STRATEGIES;
1324: --End Bug#7248296 28-07-2008 barathsr
1325:
1326: PROCEDURE GetStrategyTempID(
1327: p_stry_cnt_rec in IEX_STRATEGY_TYPE_PUB.STRY_CNT_REC_TYPE,
1328: x_return_status out NOCOPY varchar2,
1329: x_strategy_template_id out NOCOPY number) IS
1330: /*
1331: CURSOR c_strategyTemp(pCategoryType varchar2, pDelinquencyID number) IS