APPS.JTF_IH_WRAP_UPS_SEED_PUB dependencies on JTF_IH_ACTION_ACTION_ITEMS

Line 507: -- dbms_output.put_line('Update JTF_IH_ACTION_ACTION_ITEMS');

503: -- Bug#3362889
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

Line 509: UPDATE jtf_ih_action_action_items SET default_wrap_id = l_wrap_id

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;
513: END IF;