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_CONTRACT_PVT dependencies on STANDARD

Line 694: cursor l_standard_notes_csr (p_id NUMBER) is

690: x_return_status OUT NOCOPY VARCHAR2) IS
691:
692:
693:
694: cursor l_standard_notes_csr (p_id NUMBER) is
695: select b.type_code,
696: b.attribute_category,
697: b.attribute1,
698: b.attribute2,

Line 716: from oke_k_standard_notes_b b, oke_k_standard_notes_tl t

712: t.sfwt_flag,
713: t.description,
714: t.name,
715: t.text
716: from oke_k_standard_notes_b b, oke_k_standard_notes_tl t
717: where k_line_id = p_id;
718: l_standard_notes l_standard_notes_csr%ROWTYPE;
719:
720:

Line 718: l_standard_notes l_standard_notes_csr%ROWTYPE;

714: t.name,
715: t.text
716: from oke_k_standard_notes_b b, oke_k_standard_notes_tl t
717: where k_line_id = p_id;
718: l_standard_notes l_standard_notes_csr%ROWTYPE;
719:
720:
721: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
722: l_id NUMBER;

Line 725: for l_standard_notes in l_standard_notes_csr(p_line_id)

721: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
722: l_id NUMBER;
723: BEGIN
724:
725: for l_standard_notes in l_standard_notes_csr(p_line_id)
726: loop
727: select oke_k_standard_notes_s.nextval into l_id from dual;
728: insert into oke_k_standard_notes_b
729: (standard_notes_id,

Line 727: select oke_k_standard_notes_s.nextval into l_id from dual;

723: BEGIN
724:
725: for l_standard_notes in l_standard_notes_csr(p_line_id)
726: loop
727: select oke_k_standard_notes_s.nextval into l_id from dual;
728: insert into oke_k_standard_notes_b
729: (standard_notes_id,
730: creation_date,
731: created_by,

Line 728: insert into oke_k_standard_notes_b

724:
725: for l_standard_notes in l_standard_notes_csr(p_line_id)
726: loop
727: select oke_k_standard_notes_s.nextval into l_id from dual;
728: insert into oke_k_standard_notes_b
729: (standard_notes_id,
730: creation_date,
731: created_by,
732: last_update_date,

Line 729: (standard_notes_id,

725: for l_standard_notes in l_standard_notes_csr(p_line_id)
726: loop
727: select oke_k_standard_notes_s.nextval into l_id from dual;
728: insert into oke_k_standard_notes_b
729: (standard_notes_id,
730: creation_date,
731: created_by,
732: last_update_date,
733: last_update_login,

Line 765: l_standard_notes.type_code,

761: fnd_global.user_id,
762: null,
763: null,
764: p_deliverable_id,
765: l_standard_notes.type_code,
766: l_standard_notes.attribute_category,
767: l_standard_notes.attribute1,
768: l_standard_notes.attribute2,
769: l_standard_notes.attribute3,

Line 766: l_standard_notes.attribute_category,

762: null,
763: null,
764: p_deliverable_id,
765: l_standard_notes.type_code,
766: l_standard_notes.attribute_category,
767: l_standard_notes.attribute1,
768: l_standard_notes.attribute2,
769: l_standard_notes.attribute3,
770: l_standard_notes.attribute4,

Line 767: l_standard_notes.attribute1,

763: null,
764: p_deliverable_id,
765: l_standard_notes.type_code,
766: l_standard_notes.attribute_category,
767: l_standard_notes.attribute1,
768: l_standard_notes.attribute2,
769: l_standard_notes.attribute3,
770: l_standard_notes.attribute4,
771: l_standard_notes.attribute5,

Line 768: l_standard_notes.attribute2,

764: p_deliverable_id,
765: l_standard_notes.type_code,
766: l_standard_notes.attribute_category,
767: l_standard_notes.attribute1,
768: l_standard_notes.attribute2,
769: l_standard_notes.attribute3,
770: l_standard_notes.attribute4,
771: l_standard_notes.attribute5,
772: l_standard_notes.attribute6,

Line 769: l_standard_notes.attribute3,

765: l_standard_notes.type_code,
766: l_standard_notes.attribute_category,
767: l_standard_notes.attribute1,
768: l_standard_notes.attribute2,
769: l_standard_notes.attribute3,
770: l_standard_notes.attribute4,
771: l_standard_notes.attribute5,
772: l_standard_notes.attribute6,
773: l_standard_notes.attribute7,

Line 770: l_standard_notes.attribute4,

766: l_standard_notes.attribute_category,
767: l_standard_notes.attribute1,
768: l_standard_notes.attribute2,
769: l_standard_notes.attribute3,
770: l_standard_notes.attribute4,
771: l_standard_notes.attribute5,
772: l_standard_notes.attribute6,
773: l_standard_notes.attribute7,
774: l_standard_notes.attribute8,

Line 771: l_standard_notes.attribute5,

767: l_standard_notes.attribute1,
768: l_standard_notes.attribute2,
769: l_standard_notes.attribute3,
770: l_standard_notes.attribute4,
771: l_standard_notes.attribute5,
772: l_standard_notes.attribute6,
773: l_standard_notes.attribute7,
774: l_standard_notes.attribute8,
775: l_standard_notes.attribute9,

Line 772: l_standard_notes.attribute6,

768: l_standard_notes.attribute2,
769: l_standard_notes.attribute3,
770: l_standard_notes.attribute4,
771: l_standard_notes.attribute5,
772: l_standard_notes.attribute6,
773: l_standard_notes.attribute7,
774: l_standard_notes.attribute8,
775: l_standard_notes.attribute9,
776: l_standard_notes.attribute10,

Line 773: l_standard_notes.attribute7,

769: l_standard_notes.attribute3,
770: l_standard_notes.attribute4,
771: l_standard_notes.attribute5,
772: l_standard_notes.attribute6,
773: l_standard_notes.attribute7,
774: l_standard_notes.attribute8,
775: l_standard_notes.attribute9,
776: l_standard_notes.attribute10,
777: l_standard_notes.attribute11,

Line 774: l_standard_notes.attribute8,

770: l_standard_notes.attribute4,
771: l_standard_notes.attribute5,
772: l_standard_notes.attribute6,
773: l_standard_notes.attribute7,
774: l_standard_notes.attribute8,
775: l_standard_notes.attribute9,
776: l_standard_notes.attribute10,
777: l_standard_notes.attribute11,
778: l_standard_notes.attribute12,

Line 775: l_standard_notes.attribute9,

771: l_standard_notes.attribute5,
772: l_standard_notes.attribute6,
773: l_standard_notes.attribute7,
774: l_standard_notes.attribute8,
775: l_standard_notes.attribute9,
776: l_standard_notes.attribute10,
777: l_standard_notes.attribute11,
778: l_standard_notes.attribute12,
779: l_standard_notes.attribute13,

Line 776: l_standard_notes.attribute10,

772: l_standard_notes.attribute6,
773: l_standard_notes.attribute7,
774: l_standard_notes.attribute8,
775: l_standard_notes.attribute9,
776: l_standard_notes.attribute10,
777: l_standard_notes.attribute11,
778: l_standard_notes.attribute12,
779: l_standard_notes.attribute13,
780: l_standard_notes.attribute14,

Line 777: l_standard_notes.attribute11,

773: l_standard_notes.attribute7,
774: l_standard_notes.attribute8,
775: l_standard_notes.attribute9,
776: l_standard_notes.attribute10,
777: l_standard_notes.attribute11,
778: l_standard_notes.attribute12,
779: l_standard_notes.attribute13,
780: l_standard_notes.attribute14,
781: l_standard_notes.attribute15);

Line 778: l_standard_notes.attribute12,

774: l_standard_notes.attribute8,
775: l_standard_notes.attribute9,
776: l_standard_notes.attribute10,
777: l_standard_notes.attribute11,
778: l_standard_notes.attribute12,
779: l_standard_notes.attribute13,
780: l_standard_notes.attribute14,
781: l_standard_notes.attribute15);
782: end loop;

Line 779: l_standard_notes.attribute13,

775: l_standard_notes.attribute9,
776: l_standard_notes.attribute10,
777: l_standard_notes.attribute11,
778: l_standard_notes.attribute12,
779: l_standard_notes.attribute13,
780: l_standard_notes.attribute14,
781: l_standard_notes.attribute15);
782: end loop;
783:

Line 780: l_standard_notes.attribute14,

776: l_standard_notes.attribute10,
777: l_standard_notes.attribute11,
778: l_standard_notes.attribute12,
779: l_standard_notes.attribute13,
780: l_standard_notes.attribute14,
781: l_standard_notes.attribute15);
782: end loop;
783:
784: end;

Line 781: l_standard_notes.attribute15);

777: l_standard_notes.attribute11,
778: l_standard_notes.attribute12,
779: l_standard_notes.attribute13,
780: l_standard_notes.attribute14,
781: l_standard_notes.attribute15);
782: end loop;
783:
784: end;
785:

Line 1416: delete from OKE_K_STANDARD_NOTES_TLH

1412:
1413: delete from OKE_K_BILLING_METHODS_H
1414: where k_header_id = p_header_id;
1415:
1416: delete from OKE_K_STANDARD_NOTES_TLH
1417: where standard_notes_id in(
1418: select standard_notes_id
1419: from oke_k_standard_notes_bh
1420: where k_header_id = p_header_id);

Line 1417: where standard_notes_id in(

1413: delete from OKE_K_BILLING_METHODS_H
1414: where k_header_id = p_header_id;
1415:
1416: delete from OKE_K_STANDARD_NOTES_TLH
1417: where standard_notes_id in(
1418: select standard_notes_id
1419: from oke_k_standard_notes_bh
1420: where k_header_id = p_header_id);
1421:

Line 1418: select standard_notes_id

1414: where k_header_id = p_header_id;
1415:
1416: delete from OKE_K_STANDARD_NOTES_TLH
1417: where standard_notes_id in(
1418: select standard_notes_id
1419: from oke_k_standard_notes_bh
1420: where k_header_id = p_header_id);
1421:
1422: delete from OKE_K_STANDARD_NOTES_BH

Line 1419: from oke_k_standard_notes_bh

1415:
1416: delete from OKE_K_STANDARD_NOTES_TLH
1417: where standard_notes_id in(
1418: select standard_notes_id
1419: from oke_k_standard_notes_bh
1420: where k_header_id = p_header_id);
1421:
1422: delete from OKE_K_STANDARD_NOTES_BH
1423: where k_header_id = p_header_id;

Line 1422: delete from OKE_K_STANDARD_NOTES_BH

1418: select standard_notes_id
1419: from oke_k_standard_notes_bh
1420: where k_header_id = p_header_id);
1421:
1422: delete from OKE_K_STANDARD_NOTES_BH
1423: where k_header_id = p_header_id;
1424:
1425:
1426: