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 OKE_DELIVERABLE_PVT

Line 792: p_del_rec IN OKE_DELIVERABLE_PVT.del_rec_type,

788: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
789: x_return_status OUT NOCOPY VARCHAR2,
790: x_msg_count OUT NOCOPY NUMBER,
791: x_msg_data OUT NOCOPY VARCHAR2,
792: p_del_rec IN OKE_DELIVERABLE_PVT.del_rec_type,
793: x_del_rec OUT NOCOPY OKE_DELIVERABLE_PVT.del_rec_type) IS
794:
795: l_del_rec OKE_DELIVERABLE_PVT.del_rec_type := p_del_rec;
796: BEGIN

Line 793: x_del_rec OUT NOCOPY OKE_DELIVERABLE_PVT.del_rec_type) IS

789: x_return_status OUT NOCOPY VARCHAR2,
790: x_msg_count OUT NOCOPY NUMBER,
791: x_msg_data OUT NOCOPY VARCHAR2,
792: p_del_rec IN OKE_DELIVERABLE_PVT.del_rec_type,
793: x_del_rec OUT NOCOPY OKE_DELIVERABLE_PVT.del_rec_type) IS
794:
795: l_del_rec OKE_DELIVERABLE_PVT.del_rec_type := p_del_rec;
796: BEGIN
797: -- initialize return status

Line 795: l_del_rec OKE_DELIVERABLE_PVT.del_rec_type := p_del_rec;

791: x_msg_data OUT NOCOPY VARCHAR2,
792: p_del_rec IN OKE_DELIVERABLE_PVT.del_rec_type,
793: x_del_rec OUT NOCOPY OKE_DELIVERABLE_PVT.del_rec_type) IS
794:
795: l_del_rec OKE_DELIVERABLE_PVT.del_rec_type := p_del_rec;
796: BEGIN
797: -- initialize return status
798: x_return_status := OKE_API.G_RET_STS_SUCCESS;
799:

Line 802: OKE_DELIVERABLE_PVT.Insert_Row(

798: x_return_status := OKE_API.G_RET_STS_SUCCESS;
799:
800:
801:
802: OKE_DELIVERABLE_PVT.Insert_Row(
803: p_api_version => p_api_version,
804: p_init_msg_list => p_init_msg_list,
805: x_return_status => x_return_status,
806: x_msg_count => x_msg_count,

Line 829: p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type,

825: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
826: x_return_status OUT NOCOPY VARCHAR2,
827: x_msg_count OUT NOCOPY NUMBER,
828: x_msg_data OUT NOCOPY VARCHAR2,
829: p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type,
830: x_del_tbl OUT NOCOPY OKE_DELIVERABLE_PVT.del_tbl_type) IS
831:
832: BEGIN
833:

Line 830: x_del_tbl OUT NOCOPY OKE_DELIVERABLE_PVT.del_tbl_type) IS

826: x_return_status OUT NOCOPY VARCHAR2,
827: x_msg_count OUT NOCOPY NUMBER,
828: x_msg_data OUT NOCOPY VARCHAR2,
829: p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type,
830: x_del_tbl OUT NOCOPY OKE_DELIVERABLE_PVT.del_tbl_type) IS
831:
832: BEGIN
833:
834: OKE_DELIVERABLE_PVT.Insert_Row(

Line 834: OKE_DELIVERABLE_PVT.Insert_Row(

830: x_del_tbl OUT NOCOPY OKE_DELIVERABLE_PVT.del_tbl_type) IS
831:
832: BEGIN
833:
834: OKE_DELIVERABLE_PVT.Insert_Row(
835:
836: p_api_version => p_api_version,
837: p_init_msg_list => p_init_msg_list,
838: x_return_status => x_return_status,

Line 852: p_del_rec IN OKE_DELIVERABLE_PVT.del_rec_type,

848: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
849: x_return_status OUT NOCOPY VARCHAR2,
850: x_msg_count OUT NOCOPY NUMBER,
851: x_msg_data OUT NOCOPY VARCHAR2,
852: p_del_rec IN OKE_DELIVERABLE_PVT.del_rec_type,
853: x_del_rec OUT NOCOPY OKE_DELIVERABLE_PVT.del_rec_type) IS
854:
855: BEGIN
856:

Line 853: x_del_rec OUT NOCOPY OKE_DELIVERABLE_PVT.del_rec_type) IS

849: x_return_status OUT NOCOPY VARCHAR2,
850: x_msg_count OUT NOCOPY NUMBER,
851: x_msg_data OUT NOCOPY VARCHAR2,
852: p_del_rec IN OKE_DELIVERABLE_PVT.del_rec_type,
853: x_del_rec OUT NOCOPY OKE_DELIVERABLE_PVT.del_rec_type) IS
854:
855: BEGIN
856:
857:

Line 859: OKE_DELIVERABLE_PVT.Update_Row(

855: BEGIN
856:
857:
858:
859: OKE_DELIVERABLE_PVT.Update_Row(
860: p_api_version => p_api_version,
861: p_init_msg_list => p_init_msg_list,
862: x_return_status => x_return_status,
863: x_msg_count => x_msg_count,

Line 889: p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type,

885: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
886: x_return_status OUT NOCOPY VARCHAR2,
887: x_msg_count OUT NOCOPY NUMBER,
888: x_msg_data OUT NOCOPY VARCHAR2,
889: p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type,
890: x_del_tbl OUT NOCOPY OKE_DELIVERABLE_PVT.del_tbl_type) IS
891:
892: BEGIN
893: OKE_DELIVERABLE_PVT.Update_Row(

Line 890: x_del_tbl OUT NOCOPY OKE_DELIVERABLE_PVT.del_tbl_type) IS

886: x_return_status OUT NOCOPY VARCHAR2,
887: x_msg_count OUT NOCOPY NUMBER,
888: x_msg_data OUT NOCOPY VARCHAR2,
889: p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type,
890: x_del_tbl OUT NOCOPY OKE_DELIVERABLE_PVT.del_tbl_type) IS
891:
892: BEGIN
893: OKE_DELIVERABLE_PVT.Update_Row(
894: p_api_version => p_api_version,

Line 893: OKE_DELIVERABLE_PVT.Update_Row(

889: p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type,
890: x_del_tbl OUT NOCOPY OKE_DELIVERABLE_PVT.del_tbl_type) IS
891:
892: BEGIN
893: OKE_DELIVERABLE_PVT.Update_Row(
894: p_api_version => p_api_version,
895: p_init_msg_list => p_init_msg_list,
896: x_return_status => x_return_status,
897: x_msg_count => x_msg_count,

Line 909: p_del_rec IN OKE_DELIVERABLE_PVT.del_rec_type) IS

905: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
906: x_return_status OUT NOCOPY VARCHAR2,
907: x_msg_count OUT NOCOPY NUMBER,
908: x_msg_data OUT NOCOPY VARCHAR2,
909: p_del_rec IN OKE_DELIVERABLE_PVT.del_rec_type) IS
910:
911: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
912: l_chr_id NUMBER;
913: l_dummy_val NUMBER;

Line 927: OKE_DELIVERABLE_PVT.delete_row(

923:
924: -- delete only if there are no detail records
925: IF (l_dummy_val = 0) THEN
926:
927: OKE_DELIVERABLE_PVT.delete_row(
928: p_api_version => p_api_version,
929: p_init_msg_list => p_init_msg_list,
930: x_return_status => x_return_status,
931: x_msg_count => x_msg_count,

Line 967: p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type) IS

963: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
964: x_return_status OUT NOCOPY VARCHAR2,
965: x_msg_count OUT NOCOPY NUMBER,
966: x_msg_data OUT NOCOPY VARCHAR2,
967: p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type) IS
968:
969: BEGIN
970: OKE_DELIVERABLE_PVT.Delete_Row(
971: p_api_version => p_api_version,

Line 970: OKE_DELIVERABLE_PVT.Delete_Row(

966: x_msg_data OUT NOCOPY VARCHAR2,
967: p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type) IS
968:
969: BEGIN
970: OKE_DELIVERABLE_PVT.Delete_Row(
971: p_api_version => p_api_version,
972: p_init_msg_list => p_init_msg_list,
973: x_return_status => x_return_status,
974: x_msg_count => x_msg_count,

Line 1017: l_del_tbl_in OKE_DELIVERABLE_PVT.del_tbl_type;

1013: FROM oke_k_deliverables_b
1014: WHERE parent_deliverable_id=P_Parent_Id;
1015:
1016: n NUMBER:=0;
1017: l_del_tbl_in OKE_DELIVERABLE_PVT.del_tbl_type;
1018: l_del_tbl_tmp OKE_DELIVERABLE_PVT.del_tbl_type;
1019:
1020: l_api_version CONSTANT NUMBER := 1.0;
1021: l_init_msg_list CONSTANT VARCHAR2(1) := 'T';

Line 1018: l_del_tbl_tmp OKE_DELIVERABLE_PVT.del_tbl_type;

1014: WHERE parent_deliverable_id=P_Parent_Id;
1015:
1016: n NUMBER:=0;
1017: l_del_tbl_in OKE_DELIVERABLE_PVT.del_tbl_type;
1018: l_del_tbl_tmp OKE_DELIVERABLE_PVT.del_tbl_type;
1019:
1020: l_api_version CONSTANT NUMBER := 1.0;
1021: l_init_msg_list CONSTANT VARCHAR2(1) := 'T';
1022: l_return_status VARCHAR2(1);

Line 1216: p_del_rec IN OKE_DELIVERABLE_PVT.del_rec_type) IS

1212: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
1213: x_return_status OUT NOCOPY VARCHAR2,
1214: x_msg_count OUT NOCOPY NUMBER,
1215: x_msg_data OUT NOCOPY VARCHAR2,
1216: p_del_rec IN OKE_DELIVERABLE_PVT.del_rec_type) IS
1217:
1218: BEGIN
1219: OKE_DELIVERABLE_PVT.Validate_Row(
1220: p_api_version => p_api_version,

Line 1219: OKE_DELIVERABLE_PVT.Validate_Row(

1215: x_msg_data OUT NOCOPY VARCHAR2,
1216: p_del_rec IN OKE_DELIVERABLE_PVT.del_rec_type) IS
1217:
1218: BEGIN
1219: OKE_DELIVERABLE_PVT.Validate_Row(
1220: p_api_version => p_api_version,
1221: p_init_msg_list => p_init_msg_list,
1222: x_return_status => x_return_status,
1223: x_msg_count => x_msg_count,

Line 1234: p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type) IS

1230: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
1231: x_return_status OUT NOCOPY VARCHAR2,
1232: x_msg_count OUT NOCOPY NUMBER,
1233: x_msg_data OUT NOCOPY VARCHAR2,
1234: p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type) IS
1235:
1236: BEGIN
1237: OKE_DELIVERABLE_PVT.Validate_Row(
1238: p_api_version => p_api_version,

Line 1237: OKE_DELIVERABLE_PVT.Validate_Row(

1233: x_msg_data OUT NOCOPY VARCHAR2,
1234: p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type) IS
1235:
1236: BEGIN
1237: OKE_DELIVERABLE_PVT.Validate_Row(
1238: p_api_version => p_api_version,
1239: p_init_msg_list => p_init_msg_list,
1240: x_return_status => x_return_status,
1241: x_msg_count => x_msg_count,

Line 1252: p_del_rec IN OKE_DELIVERABLE_PVT.del_rec_type) IS

1248: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
1249: x_return_status OUT NOCOPY VARCHAR2,
1250: x_msg_count OUT NOCOPY NUMBER,
1251: x_msg_data OUT NOCOPY VARCHAR2,
1252: p_del_rec IN OKE_DELIVERABLE_PVT.del_rec_type) IS
1253:
1254: BEGIN
1255: OKE_DELIVERABLE_PVT.Lock_Row(
1256: p_api_version => p_api_version,

Line 1255: OKE_DELIVERABLE_PVT.Lock_Row(

1251: x_msg_data OUT NOCOPY VARCHAR2,
1252: p_del_rec IN OKE_DELIVERABLE_PVT.del_rec_type) IS
1253:
1254: BEGIN
1255: OKE_DELIVERABLE_PVT.Lock_Row(
1256: p_api_version => p_api_version,
1257: p_init_msg_list => p_init_msg_list,
1258: x_return_status => x_return_status,
1259: x_msg_count => x_msg_count,

Line 1270: p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type) IS

1266: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
1267: x_return_status OUT NOCOPY VARCHAR2,
1268: x_msg_count OUT NOCOPY NUMBER,
1269: x_msg_data OUT NOCOPY VARCHAR2,
1270: p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type) IS
1271:
1272: BEGIN
1273: OKE_DELIVERABLE_PVT.Lock_Row(
1274: p_api_version => p_api_version,

Line 1273: OKE_DELIVERABLE_PVT.Lock_Row(

1269: x_msg_data OUT NOCOPY VARCHAR2,
1270: p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type) IS
1271:
1272: BEGIN
1273: OKE_DELIVERABLE_PVT.Lock_Row(
1274: p_api_version => p_api_version,
1275: p_init_msg_list => p_init_msg_list,
1276: x_return_status => x_return_status,
1277: x_msg_count => x_msg_count,