eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKE_IMPORT_CONTRACT_PUB dependencies on STANDARD

Line 3671: -- 6. Delete associated party roles. Articles/Standard Notes/User Defined attributes etc

3667: END IF;
3668:
3669:
3670:
3671: -- 6. Delete associated party roles. Articles/Standard Notes/User Defined attributes etc
3672: -- and then delete actual line from oke and okc table.
3673:
3674: -- Delete User Defined Attributes.
3675: delete from oke_k_user_attributes where k_line_id = p_contract_line_id;

Line 3677: -- Delete Standard Notes.

3673:
3674: -- Delete User Defined Attributes.
3675: delete from oke_k_user_attributes where k_line_id = p_contract_line_id;
3676:
3677: -- Delete Standard Notes.
3678: delete from oke_k_standard_notes_tl
3679: where standard_notes_id in
3680: (select standard_notes_id from oke_k_standard_notes_b
3681: where k_line_id = p_contract_line_id);

Line 3678: delete from oke_k_standard_notes_tl

3674: -- Delete User Defined Attributes.
3675: delete from oke_k_user_attributes where k_line_id = p_contract_line_id;
3676:
3677: -- Delete Standard Notes.
3678: delete from oke_k_standard_notes_tl
3679: where standard_notes_id in
3680: (select standard_notes_id from oke_k_standard_notes_b
3681: where k_line_id = p_contract_line_id);
3682:

Line 3679: where standard_notes_id in

3675: delete from oke_k_user_attributes where k_line_id = p_contract_line_id;
3676:
3677: -- Delete Standard Notes.
3678: delete from oke_k_standard_notes_tl
3679: where standard_notes_id in
3680: (select standard_notes_id from oke_k_standard_notes_b
3681: where k_line_id = p_contract_line_id);
3682:
3683: delete from oke_k_standard_notes_b where k_line_id = p_contract_line_id;

Line 3680: (select standard_notes_id from oke_k_standard_notes_b

3676:
3677: -- Delete Standard Notes.
3678: delete from oke_k_standard_notes_tl
3679: where standard_notes_id in
3680: (select standard_notes_id from oke_k_standard_notes_b
3681: where k_line_id = p_contract_line_id);
3682:
3683: delete from oke_k_standard_notes_b where k_line_id = p_contract_line_id;
3684:

Line 3683: delete from oke_k_standard_notes_b where k_line_id = p_contract_line_id;

3679: where standard_notes_id in
3680: (select standard_notes_id from oke_k_standard_notes_b
3681: where k_line_id = p_contract_line_id);
3682:
3683: delete from oke_k_standard_notes_b where k_line_id = p_contract_line_id;
3684:
3685: -- Delete Print Forms
3686: delete from oke_k_print_forms where k_line_id = p_contract_line_id;
3687:

Line 6601: SELECT STANDARD_NOTES_ID FROM OKE_K_STANDARD_NOTES_B

6597:
6598: l_del_tbl_in oke_deliverable_pvt.del_tbl_type;
6599:
6600: CURSOR c4 IS
6601: SELECT STANDARD_NOTES_ID FROM OKE_K_STANDARD_NOTES_B
6602: WHERE DELIVERABLE_ID = p_deliverable_id;
6603:
6604:
6605: BEGIN

Line 6653: -- delete standard notes

6649: -- delete dependency
6650: delete from oke_dependencies
6651: where deliverable_id = p_deliverable_id;
6652:
6653: -- delete standard notes
6654: for cinfo in c4 loop
6655: delete from oke_k_standard_notes_b
6656: where standard_notes_id = cinfo.standard_notes_id;
6657:

Line 6655: delete from oke_k_standard_notes_b

6651: where deliverable_id = p_deliverable_id;
6652:
6653: -- delete standard notes
6654: for cinfo in c4 loop
6655: delete from oke_k_standard_notes_b
6656: where standard_notes_id = cinfo.standard_notes_id;
6657:
6658: delete from oke_k_standard_notes_tl
6659: where standard_notes_id = cinfo.standard_notes_id;

Line 6656: where standard_notes_id = cinfo.standard_notes_id;

6652:
6653: -- delete standard notes
6654: for cinfo in c4 loop
6655: delete from oke_k_standard_notes_b
6656: where standard_notes_id = cinfo.standard_notes_id;
6657:
6658: delete from oke_k_standard_notes_tl
6659: where standard_notes_id = cinfo.standard_notes_id;
6660: end loop;

Line 6658: delete from oke_k_standard_notes_tl

6654: for cinfo in c4 loop
6655: delete from oke_k_standard_notes_b
6656: where standard_notes_id = cinfo.standard_notes_id;
6657:
6658: delete from oke_k_standard_notes_tl
6659: where standard_notes_id = cinfo.standard_notes_id;
6660: end loop;
6661:
6662: l_del_tbl_in(1).DELIVERABLE_ID := p_deliverable_id ;

Line 6659: where standard_notes_id = cinfo.standard_notes_id;

6655: delete from oke_k_standard_notes_b
6656: where standard_notes_id = cinfo.standard_notes_id;
6657:
6658: delete from oke_k_standard_notes_tl
6659: where standard_notes_id = cinfo.standard_notes_id;
6660: end loop;
6661:
6662: l_del_tbl_in(1).DELIVERABLE_ID := p_deliverable_id ;
6663: