APPS.JTF_IH_TOOLS dependencies on JTF_IH_WRAP_UPS

Line 156: 'FROM jtf_ih_wrap_ups WHERE outcome_id = :outcome_id ' ;

152: BEGIN
153: arr_Params.DELETE;
154: l_Params := 0;
155: l_Sql := 'SELECT wrap_id as wrap_id, wrap_up_level as wrap_up_level '||
156: 'FROM jtf_ih_wrap_ups WHERE outcome_id = :outcome_id ' ;
157: l_Params := l_Params + 1;
158: arr_Params(l_Params).NAME := ':outcome_id';
159: arr_Params(l_Params).VALUE := l_outcome_id;
160: IF l_result_id IS NOT NULL THEN

Line 225: INSERT INTO jtf_ih_wrap_ups (

221: b_Add_Wrap := FALSE;
222: END;
223: IF b_Add_Wrap THEN
224: --dbms_output.put_line('Add!!! '||l_outcome_id||' '||l_result_id||' '||nvl(l_reason_id,-1)||' '||l_source_code_id||' '||l_source_code||' '||l_object_id||' '||l_object_type||' '||p_Wrap_Up_Level);
225: INSERT INTO jtf_ih_wrap_ups (
226: WRAP_ID,
227: OUTCOME_ID,
228: RESULT_ID,
229: REASON_ID,

Line 244: JTF_IH_WRAP_UPS_S1.NEXTVAL,

240: LAST_UPDATE_DATE,
241: LAST_UPDATE_LOGIN
242: )
243: VALUES (
244: JTF_IH_WRAP_UPS_S1.NEXTVAL,
245: l_outcome_id,
246: l_result_id,
247: l_reason_id,
248: l_object_id,

Line 263: l_Sql := 'UPDATE jtf_ih_wrap_ups SET ';

259: fnd_global.login_id
260: );
261: ELSE
262: IF b_end_Date_required OR b_level_change_required THEN
263: l_Sql := 'UPDATE jtf_ih_wrap_ups SET ';
264: IF b_end_Date_required THEN
265: l_Sql := l_Sql || ' END_DATE = :end_date_time ';
266: IF b_level_change_required THEN
267: --dbms_output.put_line('BOTH! for '||l_wrap_id);

Line 306: -- JTF_IH_WRAP_UPS (if same records weren't found there).

302: -- PROCEDURE: MIGRATE_WRAPUPS
303: --
304: -- DESCRIPTION:
305: -- This script checks and populates data from JTF_IH_OUTCOME_RESULTS table to
306: -- JTF_IH_WRAP_UPS (if same records weren't found there).
307: --
308: -- HISTORY:
309: -- 03/14/03 ialeshin - Created sql script
310: -- 08/12/03 mpetrosi - Modified changed script into package procedure

Line 523: --sSql := 'SELECT COUNT(*) FROM jtf_ih_wrap_ups WHERE outcome_id = '||ttWrpUps(i).outcome_Id||' ';

519: end loop; -- end Outcomes Loop
520:
521: iCursor := dbms_sql.open_cursor;
522: for i in 1..ttWrpUps.count loop
523: --sSql := 'SELECT COUNT(*) FROM jtf_ih_wrap_ups WHERE outcome_id = '||ttWrpUps(i).outcome_Id||' ';
524: v_Params.delete;
525: sSql := 'SELECT COUNT(*) FROM jtf_ih_wrap_ups WHERE outcome_id = :outcome_id ';
526: n_CntParams := 1;
527: v_Params(n_CntParams).name := ':outcome_id';

Line 525: sSql := 'SELECT COUNT(*) FROM jtf_ih_wrap_ups WHERE outcome_id = :outcome_id ';

521: iCursor := dbms_sql.open_cursor;
522: for i in 1..ttWrpUps.count loop
523: --sSql := 'SELECT COUNT(*) FROM jtf_ih_wrap_ups WHERE outcome_id = '||ttWrpUps(i).outcome_Id||' ';
524: v_Params.delete;
525: sSql := 'SELECT COUNT(*) FROM jtf_ih_wrap_ups WHERE outcome_id = :outcome_id ';
526: n_CntParams := 1;
527: v_Params(n_CntParams).name := ':outcome_id';
528: v_Params(n_CntParams).value := to_char(ttWrpUps(i).outcome_Id);
529:

Line 578: -- Check a JTF_IH_WRAP_UPS about record that has same

574: v_Params(n_CntParams).name := ':source_code';
575: v_Params(n_CntParams).value := ttWrpUps(i).source_Code;
576: end if;
577:
578: -- Check a JTF_IH_WRAP_UPS about record that has same
579: -- outcome_id, result_id and reason_id
580: --
581: -- dbms_output.put_line(sSql);
582: dbms_sql.parse(iCursor, sSql, dbms_sql.native);

Line 595: -- in the JTF_IH_WRAP_UPS

591: nCount := 0;
592: end if;
593: dbms_sql.column_value(iCursor,1,nCount);
594: -- If nCount is 0 (record not found) then create new one
595: -- in the JTF_IH_WRAP_UPS
596: if nCount = 0 then
597: begin
598: if ttWrpUps(i).result_id is null and
599: ttWrpUps(i).reason_id is not null then

Line 602: INSERT INTO jtf_ih_wrap_ups ( WRAP_ID,

598: if ttWrpUps(i).result_id is null and
599: ttWrpUps(i).reason_id is not null then
600: raise eSkip;
601: else
602: INSERT INTO jtf_ih_wrap_ups ( WRAP_ID,
603: OUTCOME_ID,
604: RESULT_ID,
605: REASON_ID,
606: SOURCE_CODE_ID,

Line 618: jtf_ih_wrap_ups_s1.nextval,

614: LAST_UPDATED_BY,
615: LAST_UPDATE_DATE,
616: LAST_UPDATE_LOGIN
617: ) VALUES (
618: jtf_ih_wrap_ups_s1.nextval,
619: ttWrpUps(i).Outcome_Id,
620: ttWrpUps(i).Result_Id,
621: ttWrpUps(i).Reason_Id,
622: ttWrpUps(i).source_code_id,