APPS.JTF_IH_WRAP_UPS_SEED_PUB dependencies on JTF_IH_WRAP_UPS

Line 1: PACKAGE BODY JTF_IH_WRAP_UPS_SEED_PUB AS

1: PACKAGE BODY JTF_IH_WRAP_UPS_SEED_PUB AS
2: /* $Header: JTFIHWPB.pls 120.3 2006/04/27 07:41:57 rdday ship $ */
3:
4:
5: PROCEDURE insert_row(

Line 31: FROM jtf_ih_wrap_ups

27: , x_wrap_up_level VARCHAR2
28: ) IS
29: CURSOR l_insert IS
30: SELECT ROWID
31: FROM jtf_ih_wrap_ups
32: WHERE wrap_id = x_wrap_id;
33: BEGIN
34: INSERT INTO jtf_ih_wrap_ups (
35: wrap_id

Line 34: INSERT INTO jtf_ih_wrap_ups (

30: SELECT ROWID
31: FROM jtf_ih_wrap_ups
32: WHERE wrap_id = x_wrap_id;
33: BEGIN
34: INSERT INTO jtf_ih_wrap_ups (
35: wrap_id
36: , object_version_number
37: , created_by
38: , creation_date

Line 92: DELETE FROM jtf_ih_wrap_ups

88: PROCEDURE delete_row(
89: x_wrap_id NUMBER
90: ) IS
91: BEGIN
92: DELETE FROM jtf_ih_wrap_ups
93: WHERE wrap_id = x_wrap_id;
94: IF (SQL%NOTFOUND) THEN
95: RAISE NO_DATA_FOUND;
96: END IF;

Line 122: CURSOR cWrapUps IS SELECT * FROM JTF_IH_WRAP_UPS WHERE WRAP_ID = x_wrap_id;

118: , x_start_date DATE
119: , x_end_date DATE
120: , x_wrap_up_level VARCHAR2
121: ) IS
122: CURSOR cWrapUps IS SELECT * FROM JTF_IH_WRAP_UPS WHERE WRAP_ID = x_wrap_id;
123: rWrapUPS cWrapUps%ROWTYPE;
124: l_wrap_id NUMBER;
125: l_object_version_number NUMBER;
126: l_created_by NUMBER;

Line 237: UPDATE jtf_ih_wrap_ups

233: IF(l_wrap_up_level IS NULL) THEN
234: l_wrap_up_level := rWrapUPS.wrap_up_level;
235: END IF;
236:
237: UPDATE jtf_ih_wrap_ups
238: SET
239: object_version_number=l_object_version_number
240: , last_updated_by =l_last_updated_by
241: , last_update_date = l_last_update_date

Line 288: FROM jtf_ih_wrap_ups

284: ) IS
285: -- bug# 2500341
286: CURSOR l_lock IS
287: SELECT *
288: FROM jtf_ih_wrap_ups
289: WHERE wrap_id = x_wrap_id
290: FOR UPDATE OF wrap_id NOWAIT;
291: l_table_rec l_lock%ROWTYPE;
292: BEGIN

Line 442: l_Sql := 'SELECT Wrap_Id FROM jtf_ih_wrap_ups WHERE Outcome_ID = :outcome_id ';

438: l_wrap_up_level := x_wrap_up_level;
439:
440: -- Check Wrap_Up on duplicate values.
441: --
442: l_Sql := 'SELECT Wrap_Id FROM jtf_ih_wrap_ups WHERE Outcome_ID = :outcome_id ';
443: n_CntParams := 1;
444: v_Params(n_CntParams).name := ':outcome_id';
445: v_Params(n_CntParams).value := l_outcome_id;
446: IF l_result_id IS NOT NULL THEN

Line 508: UPDATE jtf_ih_wrap_ups SET wrap_id = l_wrap_id WHERE wrap_id = n_Wrap_Id;

504: BEGIN
505: IF ((n_Wrap_Id IS NOT NULL) AND (l_wrap_id <> n_Wrap_Id)) THEN
506: IF ((n_Wrap_Id > l_wrap_id) AND (l_wrap_id < 10000)) THEN
507: -- dbms_output.put_line('Update JTF_IH_ACTION_ACTION_ITEMS');
508: UPDATE jtf_ih_wrap_ups SET wrap_id = l_wrap_id WHERE wrap_id = n_Wrap_Id;
509: UPDATE jtf_ih_action_action_items SET default_wrap_id = l_wrap_id
510: WHERE default_wrap_id = n_Wrap_Id;
511: ELSE
512: l_wrap_id := n_Wrap_Id;

Line 592: JTF_IH_WRAP_UPS_SEED_PUB.LOAD_ROW(

588: , x_wrap_up_level VARCHAR2
589: , x_upload_mode VARCHAR2
590: )AS
591: BEGIN
592: JTF_IH_WRAP_UPS_SEED_PUB.LOAD_ROW(
593: x_wrap_id
594: , x_object_version_number
595: , x_outcome_required
596: , x_result_required

Line 612: END JTF_IH_WRAP_UPS_SEED_PUB;

608: , x_owner
609: , x_wrap_up_level);
610: end LOAD_SEED_ROW;
611:
612: END JTF_IH_WRAP_UPS_SEED_PUB;