DBA Data[Home] [Help]

APPS.OKC_OPER_INST_PVT dependencies on OKC_MRD_PVT

Line 339: l_mrdv_tbl OKC_MRD_PVT.mrdv_tbl_type;

335: x_msg_data OUT NOCOPY VARCHAR2,
336: p_oiev_rec IN OKC_OIE_PVT.oiev_rec_type) IS
337:
338: l_olev_tbl OKC_OPER_INST_PUB.olev_tbl_type;
339: l_mrdv_tbl OKC_MRD_PVT.mrdv_tbl_type;
340: i NUMBER := 0;
341: j NUMBER := 0;
342:
343: Cursor ole_csr Is

Line 609: l_mrdv_tbl OKC_MRD_PVT.mrdv_tbl_type;

605: x_msg_count OUT NOCOPY NUMBER,
606: x_msg_data OUT NOCOPY VARCHAR2,
607: p_olev_rec IN OKC_OLE_PVT.olev_rec_type) IS
608:
609: l_mrdv_tbl OKC_MRD_PVT.mrdv_tbl_type;
610: j NUMBER := 0;
611:
612: Cursor ole_csr Is
613: SELECT object_chr_id, subject_chr_id, object_cle_id, subject_cle_id

Line 785: p_mrdv_rec IN OKC_MRD_PVT.mrdv_rec_type,

781: p_init_msg_list IN VARCHAR2 ,
782: x_return_status OUT NOCOPY VARCHAR2,
783: x_msg_count OUT NOCOPY NUMBER,
784: x_msg_data OUT NOCOPY VARCHAR2,
785: p_mrdv_rec IN OKC_MRD_PVT.mrdv_rec_type,
786: x_mrdv_rec OUT NOCOPY OKC_MRD_PVT.mrdv_rec_type) IS
787:
788: l_mrdv_rec OKC_MRD_PVT.mrdv_rec_type := p_mrdv_rec;
789: BEGIN

Line 786: x_mrdv_rec OUT NOCOPY OKC_MRD_PVT.mrdv_rec_type) IS

782: x_return_status OUT NOCOPY VARCHAR2,
783: x_msg_count OUT NOCOPY NUMBER,
784: x_msg_data OUT NOCOPY VARCHAR2,
785: p_mrdv_rec IN OKC_MRD_PVT.mrdv_rec_type,
786: x_mrdv_rec OUT NOCOPY OKC_MRD_PVT.mrdv_rec_type) IS
787:
788: l_mrdv_rec OKC_MRD_PVT.mrdv_rec_type := p_mrdv_rec;
789: BEGIN
790: -- initialize return status

Line 788: l_mrdv_rec OKC_MRD_PVT.mrdv_rec_type := p_mrdv_rec;

784: x_msg_data OUT NOCOPY VARCHAR2,
785: p_mrdv_rec IN OKC_MRD_PVT.mrdv_rec_type,
786: x_mrdv_rec OUT NOCOPY OKC_MRD_PVT.mrdv_rec_type) IS
787:
788: l_mrdv_rec OKC_MRD_PVT.mrdv_rec_type := p_mrdv_rec;
789: BEGIN
790: -- initialize return status
791: x_return_status := OKC_API.G_RET_STS_SUCCESS;
792:

Line 793: OKC_MRD_PVT.Insert_Row(

789: BEGIN
790: -- initialize return status
791: x_return_status := OKC_API.G_RET_STS_SUCCESS;
792:
793: OKC_MRD_PVT.Insert_Row(
794: p_api_version => p_api_version,
795: p_init_msg_list => p_init_msg_list,
796: x_return_status => x_return_status,
797: x_msg_count => x_msg_count,

Line 810: p_mrdv_tbl IN OKC_MRD_PVT.mrdv_tbl_type,

806: p_init_msg_list IN VARCHAR2 ,
807: x_return_status OUT NOCOPY VARCHAR2,
808: x_msg_count OUT NOCOPY NUMBER,
809: x_msg_data OUT NOCOPY VARCHAR2,
810: p_mrdv_tbl IN OKC_MRD_PVT.mrdv_tbl_type,
811: x_mrdv_tbl OUT NOCOPY OKC_MRD_PVT.mrdv_tbl_type) IS
812:
813: BEGIN
814:

Line 811: x_mrdv_tbl OUT NOCOPY OKC_MRD_PVT.mrdv_tbl_type) IS

807: x_return_status OUT NOCOPY VARCHAR2,
808: x_msg_count OUT NOCOPY NUMBER,
809: x_msg_data OUT NOCOPY VARCHAR2,
810: p_mrdv_tbl IN OKC_MRD_PVT.mrdv_tbl_type,
811: x_mrdv_tbl OUT NOCOPY OKC_MRD_PVT.mrdv_tbl_type) IS
812:
813: BEGIN
814:
815: OKC_MRD_PVT.Insert_Row(

Line 815: OKC_MRD_PVT.Insert_Row(

811: x_mrdv_tbl OUT NOCOPY OKC_MRD_PVT.mrdv_tbl_type) IS
812:
813: BEGIN
814:
815: OKC_MRD_PVT.Insert_Row(
816: p_api_version => p_api_version,
817: p_init_msg_list => p_init_msg_list,
818: x_return_status => x_return_status,
819: x_msg_count => x_msg_count,

Line 832: p_mrdv_rec IN OKC_MRD_PVT.mrdv_rec_type,

828: p_init_msg_list IN VARCHAR2 ,
829: x_return_status OUT NOCOPY VARCHAR2,
830: x_msg_count OUT NOCOPY NUMBER,
831: x_msg_data OUT NOCOPY VARCHAR2,
832: p_mrdv_rec IN OKC_MRD_PVT.mrdv_rec_type,
833: x_mrdv_rec OUT NOCOPY OKC_MRD_PVT.mrdv_rec_type) IS
834:
835: BEGIN
836:

Line 833: x_mrdv_rec OUT NOCOPY OKC_MRD_PVT.mrdv_rec_type) IS

829: x_return_status OUT NOCOPY VARCHAR2,
830: x_msg_count OUT NOCOPY NUMBER,
831: x_msg_data OUT NOCOPY VARCHAR2,
832: p_mrdv_rec IN OKC_MRD_PVT.mrdv_rec_type,
833: x_mrdv_rec OUT NOCOPY OKC_MRD_PVT.mrdv_rec_type) IS
834:
835: BEGIN
836:
837: OKC_MRD_PVT.Update_Row(

Line 837: OKC_MRD_PVT.Update_Row(

833: x_mrdv_rec OUT NOCOPY OKC_MRD_PVT.mrdv_rec_type) IS
834:
835: BEGIN
836:
837: OKC_MRD_PVT.Update_Row(
838: p_api_version => p_api_version,
839: p_init_msg_list => p_init_msg_list,
840: x_return_status => x_return_status,
841: x_msg_count => x_msg_count,

Line 854: p_mrdv_tbl IN OKC_MRD_PVT.mrdv_tbl_type,

850: p_init_msg_list IN VARCHAR2 ,
851: x_return_status OUT NOCOPY VARCHAR2,
852: x_msg_count OUT NOCOPY NUMBER,
853: x_msg_data OUT NOCOPY VARCHAR2,
854: p_mrdv_tbl IN OKC_MRD_PVT.mrdv_tbl_type,
855: x_mrdv_tbl OUT NOCOPY OKC_MRD_PVT.mrdv_tbl_type) IS
856:
857: BEGIN
858:

Line 855: x_mrdv_tbl OUT NOCOPY OKC_MRD_PVT.mrdv_tbl_type) IS

851: x_return_status OUT NOCOPY VARCHAR2,
852: x_msg_count OUT NOCOPY NUMBER,
853: x_msg_data OUT NOCOPY VARCHAR2,
854: p_mrdv_tbl IN OKC_MRD_PVT.mrdv_tbl_type,
855: x_mrdv_tbl OUT NOCOPY OKC_MRD_PVT.mrdv_tbl_type) IS
856:
857: BEGIN
858:
859: OKC_MRD_PVT.Update_Row(

Line 859: OKC_MRD_PVT.Update_Row(

855: x_mrdv_tbl OUT NOCOPY OKC_MRD_PVT.mrdv_tbl_type) IS
856:
857: BEGIN
858:
859: OKC_MRD_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 876: p_mrdv_rec IN OKC_MRD_PVT.mrdv_rec_type) IS

872: p_init_msg_list IN VARCHAR2 ,
873: x_return_status OUT NOCOPY VARCHAR2,
874: x_msg_count OUT NOCOPY NUMBER,
875: x_msg_data OUT NOCOPY VARCHAR2,
876: p_mrdv_rec IN OKC_MRD_PVT.mrdv_rec_type) IS
877:
878: BEGIN
879: OKC_MRD_PVT.Delete_Row(
880: p_api_version => p_api_version,

Line 879: OKC_MRD_PVT.Delete_Row(

875: x_msg_data OUT NOCOPY VARCHAR2,
876: p_mrdv_rec IN OKC_MRD_PVT.mrdv_rec_type) IS
877:
878: BEGIN
879: OKC_MRD_PVT.Delete_Row(
880: p_api_version => p_api_version,
881: p_init_msg_list => p_init_msg_list,
882: x_return_status => x_return_status,
883: x_msg_count => x_msg_count,

Line 895: p_mrdv_tbl IN OKC_MRD_PVT.mrdv_tbl_type) IS

891: p_init_msg_list IN VARCHAR2 ,
892: x_return_status OUT NOCOPY VARCHAR2,
893: x_msg_count OUT NOCOPY NUMBER,
894: x_msg_data OUT NOCOPY VARCHAR2,
895: p_mrdv_tbl IN OKC_MRD_PVT.mrdv_tbl_type) IS
896:
897: BEGIN
898:
899: OKC_MRD_PVT.Delete_Row(

Line 899: OKC_MRD_PVT.Delete_Row(

895: p_mrdv_tbl IN OKC_MRD_PVT.mrdv_tbl_type) IS
896:
897: BEGIN
898:
899: OKC_MRD_PVT.Delete_Row(
900: p_api_version => p_api_version,
901: p_init_msg_list => p_init_msg_list,
902: x_return_status => x_return_status,
903: x_msg_count => x_msg_count,

Line 915: p_mrdv_rec IN OKC_MRD_PVT.mrdv_rec_type) IS

911: p_init_msg_list IN VARCHAR2 ,
912: x_return_status OUT NOCOPY VARCHAR2,
913: x_msg_count OUT NOCOPY NUMBER,
914: x_msg_data OUT NOCOPY VARCHAR2,
915: p_mrdv_rec IN OKC_MRD_PVT.mrdv_rec_type) IS
916:
917: BEGIN
918:
919: OKC_MRD_PVT.Lock_Row(

Line 919: OKC_MRD_PVT.Lock_Row(

915: p_mrdv_rec IN OKC_MRD_PVT.mrdv_rec_type) IS
916:
917: BEGIN
918:
919: OKC_MRD_PVT.Lock_Row(
920: p_api_version => p_api_version,
921: p_init_msg_list => p_init_msg_list,
922: x_return_status => x_return_status,
923: x_msg_count => x_msg_count,

Line 935: p_mrdv_tbl IN OKC_MRD_PVT.mrdv_tbl_type) IS

931: p_init_msg_list IN VARCHAR2 ,
932: x_return_status OUT NOCOPY VARCHAR2,
933: x_msg_count OUT NOCOPY NUMBER,
934: x_msg_data OUT NOCOPY VARCHAR2,
935: p_mrdv_tbl IN OKC_MRD_PVT.mrdv_tbl_type) IS
936:
937: BEGIN
938:
939: OKC_MRD_PVT.Lock_Row(

Line 939: OKC_MRD_PVT.Lock_Row(

935: p_mrdv_tbl IN OKC_MRD_PVT.mrdv_tbl_type) IS
936:
937: BEGIN
938:
939: OKC_MRD_PVT.Lock_Row(
940: p_api_version => p_api_version,
941: p_init_msg_list => p_init_msg_list,
942: x_return_status => x_return_status,
943: x_msg_count => x_msg_count,

Line 955: p_mrdv_rec IN OKC_MRD_PVT.mrdv_rec_type) IS

951: p_init_msg_list IN VARCHAR2 ,
952: x_return_status OUT NOCOPY VARCHAR2,
953: x_msg_count OUT NOCOPY NUMBER,
954: x_msg_data OUT NOCOPY VARCHAR2,
955: p_mrdv_rec IN OKC_MRD_PVT.mrdv_rec_type) IS
956:
957: BEGIN
958:
959: OKC_MRD_PVT.Validate_Row(

Line 959: OKC_MRD_PVT.Validate_Row(

955: p_mrdv_rec IN OKC_MRD_PVT.mrdv_rec_type) IS
956:
957: BEGIN
958:
959: OKC_MRD_PVT.Validate_Row(
960: p_api_version => p_api_version,
961: p_init_msg_list => p_init_msg_list,
962: x_return_status => x_return_status,
963: x_msg_count => x_msg_count,

Line 975: p_mrdv_tbl IN OKC_MRD_PVT.mrdv_tbl_type) IS

971: p_init_msg_list IN VARCHAR2 ,
972: x_return_status OUT NOCOPY VARCHAR2,
973: x_msg_count OUT NOCOPY NUMBER,
974: x_msg_data OUT NOCOPY VARCHAR2,
975: p_mrdv_tbl IN OKC_MRD_PVT.mrdv_tbl_type) IS
976:
977: BEGIN
978:
979: OKC_MRD_PVT.Validate_Row(

Line 979: OKC_MRD_PVT.Validate_Row(

975: p_mrdv_tbl IN OKC_MRD_PVT.mrdv_tbl_type) IS
976:
977: BEGIN
978:
979: OKC_MRD_PVT.Validate_Row(
980: p_api_version => p_api_version,
981: p_init_msg_list => p_init_msg_list,
982: x_return_status => x_return_status,
983: x_msg_count => x_msg_count,