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_PARTY_PUB dependencies on OKC_API

Line 37: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,

33: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
34:
35:
36: procedure create_k_party_role(p_api_version IN NUMBER,
37: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,
41: p_cplv_tbl IN cplv_tbl_type,

Line 75: p_init_msg_list=>OKC_API.G_FALSE,

71: i := p_cplv_tbl.FIRST;
72: LOOP
73: -- call procedure for a record
74: create_k_party_role(p_api_version=>p_api_version,
75: p_init_msg_list=>OKC_API.G_FALSE,
76: x_return_status=>l_return_status,
77: x_msg_count=>x_msg_count,
78: x_msg_data=>x_msg_data,
79: p_cplv_rec=>p_cplv_tbl(i),

Line 232: IF p_cplv_rec.cle_id is NULL OR p_cplv_rec.cle_id=OKC_API.G_MISS_NUM THEN

228: open get_buy_sell_info;
229: FETCH get_buy_sell_info INTO l_BUY_OR_SELL ,l_scs_code;
230: CLOSE get_buy_sell_info;
231:
232: IF p_cplv_rec.cle_id is NULL OR p_cplv_rec.cle_id=OKC_API.G_MISS_NUM THEN
233: --validate rle code for header
234: open get_jtot_object_code_header(l_BUY_OR_SELL,l_scs_code);
235: fetch get_jtot_object_code_header into l_JTOT_OBJECT1_CODE;
236: close get_jtot_object_code_header;

Line 340: IF p_cplv_rec.cle_id IS NOT NULL AND p_cplv_rec.cle_id<>OKC_API.G_MISS_NUM then

336:
337: end if;
338: END IF; --buy_or_Sell
339:
340: IF p_cplv_rec.cle_id IS NOT NULL AND p_cplv_rec.cle_id<>OKC_API.G_MISS_NUM then
341: l_sql_stmt := ADD_WHERE_TO_SQL( l_sql_stmt, ' ID1 in (select object1_id1 from okc_k_party_roles_v'
342: || ' where RLE_CODE= '||''''||p_cplv_rec.RLE_CODE||''''|| ' AND chr_id = '||p_cplv_rec.dnz_chr_id||')');
343:
344: END IF;

Line 671: p_init_msg_list=>OKC_API.G_FALSE,

667: If (p_cplv_tbl.COUNT > 0) Then
668: i := p_cplv_tbl.FIRST;
669: LOOP
670: update_k_party_role(p_api_version=>p_api_version,
671: p_init_msg_list=>OKC_API.G_FALSE,
672: x_return_status=>l_return_status,
673: x_msg_count=>x_msg_count,
674: x_msg_data=>x_msg_data,
675: p_cplv_rec=>p_cplv_tbl(i),

Line 876: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

872: x_cplv_rec OUT NOCOPY cplv_rec_type
873: ) RETURN VARCHAR2 IS
874: l_cplv_rec cplv_rec_type;
875: l_row_notfound BOOLEAN := TRUE;
876: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
877: BEGIN
878:
879:
880: x_cplv_rec := p_cplv_rec;

Line 890: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

886: p_msg_name =>G_REQUIRED_VALUE,
887: p_token1 =>G_COL_NAME_TOKEN,
888: p_token1_value =>'ID');
889:
890: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
891: END IF;
892: IF (x_cplv_rec.id = OKC_API.G_MISS_NUM)
893: THEN
894: x_cplv_rec.id := l_cplv_rec.id;

Line 892: IF (x_cplv_rec.id = OKC_API.G_MISS_NUM)

888: p_token1_value =>'ID');
889:
890: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
891: END IF;
892: IF (x_cplv_rec.id = OKC_API.G_MISS_NUM)
893: THEN
894: x_cplv_rec.id := l_cplv_rec.id;
895: END IF;
896: IF (x_cplv_rec.object_version_number = OKC_API.G_MISS_NUM)

Line 896: IF (x_cplv_rec.object_version_number = OKC_API.G_MISS_NUM)

892: IF (x_cplv_rec.id = OKC_API.G_MISS_NUM)
893: THEN
894: x_cplv_rec.id := l_cplv_rec.id;
895: END IF;
896: IF (x_cplv_rec.object_version_number = OKC_API.G_MISS_NUM)
897: THEN
898: x_cplv_rec.object_version_number := l_cplv_rec.object_version_number;
899: END IF;
900: IF (x_cplv_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

Line 900: IF (x_cplv_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

896: IF (x_cplv_rec.object_version_number = OKC_API.G_MISS_NUM)
897: THEN
898: x_cplv_rec.object_version_number := l_cplv_rec.object_version_number;
899: END IF;
900: IF (x_cplv_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
901: THEN
902: x_cplv_rec.sfwt_flag := l_cplv_rec.sfwt_flag;
903: END IF;
904: IF (x_cplv_rec.cpl_id = OKC_API.G_MISS_NUM)

Line 904: IF (x_cplv_rec.cpl_id = OKC_API.G_MISS_NUM)

900: IF (x_cplv_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
901: THEN
902: x_cplv_rec.sfwt_flag := l_cplv_rec.sfwt_flag;
903: END IF;
904: IF (x_cplv_rec.cpl_id = OKC_API.G_MISS_NUM)
905: THEN
906: x_cplv_rec.cpl_id := l_cplv_rec.cpl_id;
907: END IF;
908: IF (x_cplv_rec.chr_id = OKC_API.G_MISS_NUM)

Line 908: IF (x_cplv_rec.chr_id = OKC_API.G_MISS_NUM)

904: IF (x_cplv_rec.cpl_id = OKC_API.G_MISS_NUM)
905: THEN
906: x_cplv_rec.cpl_id := l_cplv_rec.cpl_id;
907: END IF;
908: IF (x_cplv_rec.chr_id = OKC_API.G_MISS_NUM)
909: THEN
910: x_cplv_rec.chr_id := l_cplv_rec.chr_id;
911: END IF;
912: IF (x_cplv_rec.cle_id = OKC_API.G_MISS_NUM)

Line 912: IF (x_cplv_rec.cle_id = OKC_API.G_MISS_NUM)

908: IF (x_cplv_rec.chr_id = OKC_API.G_MISS_NUM)
909: THEN
910: x_cplv_rec.chr_id := l_cplv_rec.chr_id;
911: END IF;
912: IF (x_cplv_rec.cle_id = OKC_API.G_MISS_NUM)
913: THEN
914: x_cplv_rec.cle_id := l_cplv_rec.cle_id;
915: END IF;
916: IF (x_cplv_rec.rle_code = OKC_API.G_MISS_CHAR)

Line 916: IF (x_cplv_rec.rle_code = OKC_API.G_MISS_CHAR)

912: IF (x_cplv_rec.cle_id = OKC_API.G_MISS_NUM)
913: THEN
914: x_cplv_rec.cle_id := l_cplv_rec.cle_id;
915: END IF;
916: IF (x_cplv_rec.rle_code = OKC_API.G_MISS_CHAR)
917: THEN
918: x_cplv_rec.rle_code := l_cplv_rec.rle_code;
919: END IF;
920: IF (x_cplv_rec.dnz_chr_id = OKC_API.G_MISS_NUM)

Line 920: IF (x_cplv_rec.dnz_chr_id = OKC_API.G_MISS_NUM)

916: IF (x_cplv_rec.rle_code = OKC_API.G_MISS_CHAR)
917: THEN
918: x_cplv_rec.rle_code := l_cplv_rec.rle_code;
919: END IF;
920: IF (x_cplv_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
921: THEN
922: x_cplv_rec.dnz_chr_id := l_cplv_rec.dnz_chr_id;
923: END IF;
924: IF (x_cplv_rec.object1_id1 = OKC_API.G_MISS_CHAR)

Line 924: IF (x_cplv_rec.object1_id1 = OKC_API.G_MISS_CHAR)

920: IF (x_cplv_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
921: THEN
922: x_cplv_rec.dnz_chr_id := l_cplv_rec.dnz_chr_id;
923: END IF;
924: IF (x_cplv_rec.object1_id1 = OKC_API.G_MISS_CHAR)
925: THEN
926: x_cplv_rec.object1_id1 := l_cplv_rec.object1_id1;
927: END IF;
928: IF (x_cplv_rec.object1_id2 = OKC_API.G_MISS_CHAR)

Line 928: IF (x_cplv_rec.object1_id2 = OKC_API.G_MISS_CHAR)

924: IF (x_cplv_rec.object1_id1 = OKC_API.G_MISS_CHAR)
925: THEN
926: x_cplv_rec.object1_id1 := l_cplv_rec.object1_id1;
927: END IF;
928: IF (x_cplv_rec.object1_id2 = OKC_API.G_MISS_CHAR)
929: THEN
930: x_cplv_rec.object1_id2 := l_cplv_rec.object1_id2;
931: END IF;
932: IF (x_cplv_rec.jtot_object1_code = OKC_API.G_MISS_CHAR)

Line 932: IF (x_cplv_rec.jtot_object1_code = OKC_API.G_MISS_CHAR)

928: IF (x_cplv_rec.object1_id2 = OKC_API.G_MISS_CHAR)
929: THEN
930: x_cplv_rec.object1_id2 := l_cplv_rec.object1_id2;
931: END IF;
932: IF (x_cplv_rec.jtot_object1_code = OKC_API.G_MISS_CHAR)
933: THEN
934: x_cplv_rec.JTOT_OBJECT1_CODE := l_cplv_rec.JTOT_OBJECT1_CODE;
935: END IF;
936: IF (x_cplv_rec.cognomen = OKC_API.G_MISS_CHAR)

Line 936: IF (x_cplv_rec.cognomen = OKC_API.G_MISS_CHAR)

932: IF (x_cplv_rec.jtot_object1_code = OKC_API.G_MISS_CHAR)
933: THEN
934: x_cplv_rec.JTOT_OBJECT1_CODE := l_cplv_rec.JTOT_OBJECT1_CODE;
935: END IF;
936: IF (x_cplv_rec.cognomen = OKC_API.G_MISS_CHAR)
937: THEN
938: x_cplv_rec.cognomen := l_cplv_rec.cognomen;
939: END IF;
940: IF (x_cplv_rec.code = OKC_API.G_MISS_CHAR)

Line 940: IF (x_cplv_rec.code = OKC_API.G_MISS_CHAR)

936: IF (x_cplv_rec.cognomen = OKC_API.G_MISS_CHAR)
937: THEN
938: x_cplv_rec.cognomen := l_cplv_rec.cognomen;
939: END IF;
940: IF (x_cplv_rec.code = OKC_API.G_MISS_CHAR)
941: THEN
942: x_cplv_rec.code := l_cplv_rec.code;
943: END IF;
944: IF (x_cplv_rec.facility = OKC_API.G_MISS_CHAR)

Line 944: IF (x_cplv_rec.facility = OKC_API.G_MISS_CHAR)

940: IF (x_cplv_rec.code = OKC_API.G_MISS_CHAR)
941: THEN
942: x_cplv_rec.code := l_cplv_rec.code;
943: END IF;
944: IF (x_cplv_rec.facility = OKC_API.G_MISS_CHAR)
945: THEN
946: x_cplv_rec.facility := l_cplv_rec.facility;
947: END IF;
948: IF (x_cplv_rec.minority_group_lookup_code = OKC_API.G_MISS_CHAR)

Line 948: IF (x_cplv_rec.minority_group_lookup_code = OKC_API.G_MISS_CHAR)

944: IF (x_cplv_rec.facility = OKC_API.G_MISS_CHAR)
945: THEN
946: x_cplv_rec.facility := l_cplv_rec.facility;
947: END IF;
948: IF (x_cplv_rec.minority_group_lookup_code = OKC_API.G_MISS_CHAR)
949: THEN
950: x_cplv_rec.minority_group_lookup_code := l_cplv_rec.minority_group_lookup_code;
951: END IF;
952: IF (x_cplv_rec.small_business_flag = OKC_API.G_MISS_CHAR)

Line 952: IF (x_cplv_rec.small_business_flag = OKC_API.G_MISS_CHAR)

948: IF (x_cplv_rec.minority_group_lookup_code = OKC_API.G_MISS_CHAR)
949: THEN
950: x_cplv_rec.minority_group_lookup_code := l_cplv_rec.minority_group_lookup_code;
951: END IF;
952: IF (x_cplv_rec.small_business_flag = OKC_API.G_MISS_CHAR)
953: THEN
954: x_cplv_rec.small_business_flag := l_cplv_rec.small_business_flag;
955: END IF;
956: IF (x_cplv_rec.women_owned_flag = OKC_API.G_MISS_CHAR)

Line 956: IF (x_cplv_rec.women_owned_flag = OKC_API.G_MISS_CHAR)

952: IF (x_cplv_rec.small_business_flag = OKC_API.G_MISS_CHAR)
953: THEN
954: x_cplv_rec.small_business_flag := l_cplv_rec.small_business_flag;
955: END IF;
956: IF (x_cplv_rec.women_owned_flag = OKC_API.G_MISS_CHAR)
957: THEN
958: x_cplv_rec.women_owned_flag := l_cplv_rec.women_owned_flag;
959: END IF;
960: IF (x_cplv_rec.alias = OKC_API.G_MISS_CHAR)

Line 960: IF (x_cplv_rec.alias = OKC_API.G_MISS_CHAR)

956: IF (x_cplv_rec.women_owned_flag = OKC_API.G_MISS_CHAR)
957: THEN
958: x_cplv_rec.women_owned_flag := l_cplv_rec.women_owned_flag;
959: END IF;
960: IF (x_cplv_rec.alias = OKC_API.G_MISS_CHAR)
961: THEN
962: x_cplv_rec.alias := l_cplv_rec.alias;
963: END IF;
964: IF (x_cplv_rec.primary_yn = OKC_API.G_MISS_CHAR)

Line 964: IF (x_cplv_rec.primary_yn = OKC_API.G_MISS_CHAR)

960: IF (x_cplv_rec.alias = OKC_API.G_MISS_CHAR)
961: THEN
962: x_cplv_rec.alias := l_cplv_rec.alias;
963: END IF;
964: IF (x_cplv_rec.primary_yn = OKC_API.G_MISS_CHAR)
965: THEN
966: x_cplv_rec.primary_yn := l_cplv_rec.primary_yn;
967: END IF;
968: IF (x_cplv_rec.cust_acct_id = OKC_API.G_MISS_NUM)

Line 968: IF (x_cplv_rec.cust_acct_id = OKC_API.G_MISS_NUM)

964: IF (x_cplv_rec.primary_yn = OKC_API.G_MISS_CHAR)
965: THEN
966: x_cplv_rec.primary_yn := l_cplv_rec.primary_yn;
967: END IF;
968: IF (x_cplv_rec.cust_acct_id = OKC_API.G_MISS_NUM)
969: THEN
970: x_cplv_rec.cust_acct_id := l_cplv_rec.cust_acct_id;
971: END IF;
972: IF (x_cplv_rec.bill_to_site_use_id = OKC_API.G_MISS_NUM)

Line 972: IF (x_cplv_rec.bill_to_site_use_id = OKC_API.G_MISS_NUM)

968: IF (x_cplv_rec.cust_acct_id = OKC_API.G_MISS_NUM)
969: THEN
970: x_cplv_rec.cust_acct_id := l_cplv_rec.cust_acct_id;
971: END IF;
972: IF (x_cplv_rec.bill_to_site_use_id = OKC_API.G_MISS_NUM)
973: THEN
974: x_cplv_rec.bill_to_site_use_id := l_cplv_rec.bill_to_site_use_id;
975: END IF;
976: IF (x_cplv_rec.attribute_category = OKC_API.G_MISS_CHAR)

Line 976: IF (x_cplv_rec.attribute_category = OKC_API.G_MISS_CHAR)

972: IF (x_cplv_rec.bill_to_site_use_id = OKC_API.G_MISS_NUM)
973: THEN
974: x_cplv_rec.bill_to_site_use_id := l_cplv_rec.bill_to_site_use_id;
975: END IF;
976: IF (x_cplv_rec.attribute_category = OKC_API.G_MISS_CHAR)
977: THEN
978: x_cplv_rec.attribute_category := l_cplv_rec.attribute_category;
979: END IF;
980: IF (x_cplv_rec.attribute1 = OKC_API.G_MISS_CHAR)

Line 980: IF (x_cplv_rec.attribute1 = OKC_API.G_MISS_CHAR)

976: IF (x_cplv_rec.attribute_category = OKC_API.G_MISS_CHAR)
977: THEN
978: x_cplv_rec.attribute_category := l_cplv_rec.attribute_category;
979: END IF;
980: IF (x_cplv_rec.attribute1 = OKC_API.G_MISS_CHAR)
981: THEN
982: x_cplv_rec.attribute1 := l_cplv_rec.attribute1;
983: END IF;
984: IF (x_cplv_rec.attribute2 = OKC_API.G_MISS_CHAR)

Line 984: IF (x_cplv_rec.attribute2 = OKC_API.G_MISS_CHAR)

980: IF (x_cplv_rec.attribute1 = OKC_API.G_MISS_CHAR)
981: THEN
982: x_cplv_rec.attribute1 := l_cplv_rec.attribute1;
983: END IF;
984: IF (x_cplv_rec.attribute2 = OKC_API.G_MISS_CHAR)
985: THEN
986: x_cplv_rec.attribute2 := l_cplv_rec.attribute2;
987: END IF;
988: IF (x_cplv_rec.attribute3 = OKC_API.G_MISS_CHAR)

Line 988: IF (x_cplv_rec.attribute3 = OKC_API.G_MISS_CHAR)

984: IF (x_cplv_rec.attribute2 = OKC_API.G_MISS_CHAR)
985: THEN
986: x_cplv_rec.attribute2 := l_cplv_rec.attribute2;
987: END IF;
988: IF (x_cplv_rec.attribute3 = OKC_API.G_MISS_CHAR)
989: THEN
990: x_cplv_rec.attribute3 := l_cplv_rec.attribute3;
991: END IF;
992: IF (x_cplv_rec.attribute4 = OKC_API.G_MISS_CHAR)

Line 992: IF (x_cplv_rec.attribute4 = OKC_API.G_MISS_CHAR)

988: IF (x_cplv_rec.attribute3 = OKC_API.G_MISS_CHAR)
989: THEN
990: x_cplv_rec.attribute3 := l_cplv_rec.attribute3;
991: END IF;
992: IF (x_cplv_rec.attribute4 = OKC_API.G_MISS_CHAR)
993: THEN
994: x_cplv_rec.attribute4 := l_cplv_rec.attribute4;
995: END IF;
996: IF (x_cplv_rec.attribute5 = OKC_API.G_MISS_CHAR)

Line 996: IF (x_cplv_rec.attribute5 = OKC_API.G_MISS_CHAR)

992: IF (x_cplv_rec.attribute4 = OKC_API.G_MISS_CHAR)
993: THEN
994: x_cplv_rec.attribute4 := l_cplv_rec.attribute4;
995: END IF;
996: IF (x_cplv_rec.attribute5 = OKC_API.G_MISS_CHAR)
997: THEN
998: x_cplv_rec.attribute5 := l_cplv_rec.attribute5;
999: END IF;
1000: IF (x_cplv_rec.attribute6 = OKC_API.G_MISS_CHAR)

Line 1000: IF (x_cplv_rec.attribute6 = OKC_API.G_MISS_CHAR)

996: IF (x_cplv_rec.attribute5 = OKC_API.G_MISS_CHAR)
997: THEN
998: x_cplv_rec.attribute5 := l_cplv_rec.attribute5;
999: END IF;
1000: IF (x_cplv_rec.attribute6 = OKC_API.G_MISS_CHAR)
1001: THEN
1002: x_cplv_rec.attribute6 := l_cplv_rec.attribute6;
1003: END IF;
1004: IF (x_cplv_rec.attribute7 = OKC_API.G_MISS_CHAR)

Line 1004: IF (x_cplv_rec.attribute7 = OKC_API.G_MISS_CHAR)

1000: IF (x_cplv_rec.attribute6 = OKC_API.G_MISS_CHAR)
1001: THEN
1002: x_cplv_rec.attribute6 := l_cplv_rec.attribute6;
1003: END IF;
1004: IF (x_cplv_rec.attribute7 = OKC_API.G_MISS_CHAR)
1005: THEN
1006: x_cplv_rec.attribute7 := l_cplv_rec.attribute7;
1007: END IF;
1008: IF (x_cplv_rec.attribute8 = OKC_API.G_MISS_CHAR)

Line 1008: IF (x_cplv_rec.attribute8 = OKC_API.G_MISS_CHAR)

1004: IF (x_cplv_rec.attribute7 = OKC_API.G_MISS_CHAR)
1005: THEN
1006: x_cplv_rec.attribute7 := l_cplv_rec.attribute7;
1007: END IF;
1008: IF (x_cplv_rec.attribute8 = OKC_API.G_MISS_CHAR)
1009: THEN
1010: x_cplv_rec.attribute8 := l_cplv_rec.attribute8;
1011: END IF;
1012: IF (x_cplv_rec.attribute9 = OKC_API.G_MISS_CHAR)

Line 1012: IF (x_cplv_rec.attribute9 = OKC_API.G_MISS_CHAR)

1008: IF (x_cplv_rec.attribute8 = OKC_API.G_MISS_CHAR)
1009: THEN
1010: x_cplv_rec.attribute8 := l_cplv_rec.attribute8;
1011: END IF;
1012: IF (x_cplv_rec.attribute9 = OKC_API.G_MISS_CHAR)
1013: THEN
1014: x_cplv_rec.attribute9 := l_cplv_rec.attribute9;
1015: END IF;
1016: IF (x_cplv_rec.attribute10 = OKC_API.G_MISS_CHAR)

Line 1016: IF (x_cplv_rec.attribute10 = OKC_API.G_MISS_CHAR)

1012: IF (x_cplv_rec.attribute9 = OKC_API.G_MISS_CHAR)
1013: THEN
1014: x_cplv_rec.attribute9 := l_cplv_rec.attribute9;
1015: END IF;
1016: IF (x_cplv_rec.attribute10 = OKC_API.G_MISS_CHAR)
1017: THEN
1018: x_cplv_rec.attribute10 := l_cplv_rec.attribute10;
1019: END IF;
1020: IF (x_cplv_rec.attribute11 = OKC_API.G_MISS_CHAR)

Line 1020: IF (x_cplv_rec.attribute11 = OKC_API.G_MISS_CHAR)

1016: IF (x_cplv_rec.attribute10 = OKC_API.G_MISS_CHAR)
1017: THEN
1018: x_cplv_rec.attribute10 := l_cplv_rec.attribute10;
1019: END IF;
1020: IF (x_cplv_rec.attribute11 = OKC_API.G_MISS_CHAR)
1021: THEN
1022: x_cplv_rec.attribute11 := l_cplv_rec.attribute11;
1023: END IF;
1024: IF (x_cplv_rec.attribute12 = OKC_API.G_MISS_CHAR)

Line 1024: IF (x_cplv_rec.attribute12 = OKC_API.G_MISS_CHAR)

1020: IF (x_cplv_rec.attribute11 = OKC_API.G_MISS_CHAR)
1021: THEN
1022: x_cplv_rec.attribute11 := l_cplv_rec.attribute11;
1023: END IF;
1024: IF (x_cplv_rec.attribute12 = OKC_API.G_MISS_CHAR)
1025: THEN
1026: x_cplv_rec.attribute12 := l_cplv_rec.attribute12;
1027: END IF;
1028: IF (x_cplv_rec.attribute13 = OKC_API.G_MISS_CHAR)

Line 1028: IF (x_cplv_rec.attribute13 = OKC_API.G_MISS_CHAR)

1024: IF (x_cplv_rec.attribute12 = OKC_API.G_MISS_CHAR)
1025: THEN
1026: x_cplv_rec.attribute12 := l_cplv_rec.attribute12;
1027: END IF;
1028: IF (x_cplv_rec.attribute13 = OKC_API.G_MISS_CHAR)
1029: THEN
1030: x_cplv_rec.attribute13 := l_cplv_rec.attribute13;
1031: END IF;
1032: IF (x_cplv_rec.attribute14 = OKC_API.G_MISS_CHAR)

Line 1032: IF (x_cplv_rec.attribute14 = OKC_API.G_MISS_CHAR)

1028: IF (x_cplv_rec.attribute13 = OKC_API.G_MISS_CHAR)
1029: THEN
1030: x_cplv_rec.attribute13 := l_cplv_rec.attribute13;
1031: END IF;
1032: IF (x_cplv_rec.attribute14 = OKC_API.G_MISS_CHAR)
1033: THEN
1034: x_cplv_rec.attribute14 := l_cplv_rec.attribute14;
1035: END IF;
1036: IF (x_cplv_rec.attribute15 = OKC_API.G_MISS_CHAR)

Line 1036: IF (x_cplv_rec.attribute15 = OKC_API.G_MISS_CHAR)

1032: IF (x_cplv_rec.attribute14 = OKC_API.G_MISS_CHAR)
1033: THEN
1034: x_cplv_rec.attribute14 := l_cplv_rec.attribute14;
1035: END IF;
1036: IF (x_cplv_rec.attribute15 = OKC_API.G_MISS_CHAR)
1037: THEN
1038: x_cplv_rec.attribute15 := l_cplv_rec.attribute15;
1039: END IF;
1040: IF (x_cplv_rec.created_by = OKC_API.G_MISS_NUM)

Line 1040: IF (x_cplv_rec.created_by = OKC_API.G_MISS_NUM)

1036: IF (x_cplv_rec.attribute15 = OKC_API.G_MISS_CHAR)
1037: THEN
1038: x_cplv_rec.attribute15 := l_cplv_rec.attribute15;
1039: END IF;
1040: IF (x_cplv_rec.created_by = OKC_API.G_MISS_NUM)
1041: THEN
1042: x_cplv_rec.created_by := l_cplv_rec.created_by;
1043: END IF;
1044: IF (x_cplv_rec.creation_date = OKC_API.G_MISS_DATE)

Line 1044: IF (x_cplv_rec.creation_date = OKC_API.G_MISS_DATE)

1040: IF (x_cplv_rec.created_by = OKC_API.G_MISS_NUM)
1041: THEN
1042: x_cplv_rec.created_by := l_cplv_rec.created_by;
1043: END IF;
1044: IF (x_cplv_rec.creation_date = OKC_API.G_MISS_DATE)
1045: THEN
1046: x_cplv_rec.creation_date := l_cplv_rec.creation_date;
1047: END IF;
1048: IF (x_cplv_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 1048: IF (x_cplv_rec.last_updated_by = OKC_API.G_MISS_NUM)

1044: IF (x_cplv_rec.creation_date = OKC_API.G_MISS_DATE)
1045: THEN
1046: x_cplv_rec.creation_date := l_cplv_rec.creation_date;
1047: END IF;
1048: IF (x_cplv_rec.last_updated_by = OKC_API.G_MISS_NUM)
1049: THEN
1050: x_cplv_rec.last_updated_by := l_cplv_rec.last_updated_by;
1051: END IF;
1052: IF (x_cplv_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 1052: IF (x_cplv_rec.last_update_date = OKC_API.G_MISS_DATE)

1048: IF (x_cplv_rec.last_updated_by = OKC_API.G_MISS_NUM)
1049: THEN
1050: x_cplv_rec.last_updated_by := l_cplv_rec.last_updated_by;
1051: END IF;
1052: IF (x_cplv_rec.last_update_date = OKC_API.G_MISS_DATE)
1053: THEN
1054: x_cplv_rec.last_update_date := l_cplv_rec.last_update_date;
1055: END IF;
1056: IF (x_cplv_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 1056: IF (x_cplv_rec.last_update_login = OKC_API.G_MISS_NUM)

1052: IF (x_cplv_rec.last_update_date = OKC_API.G_MISS_DATE)
1053: THEN
1054: x_cplv_rec.last_update_date := l_cplv_rec.last_update_date;
1055: END IF;
1056: IF (x_cplv_rec.last_update_login = OKC_API.G_MISS_NUM)
1057: THEN
1058: x_cplv_rec.last_update_login := l_cplv_rec.last_update_login;
1059: END IF;
1060:

Line 1230: p_init_msg_list=>OKC_API.G_FALSE,

1226: If (p_ctcv_tbl.COUNT > 0) Then
1227: i := p_ctcv_tbl.FIRST;
1228: LOOP
1229: create_k_contact(p_api_version=>p_api_version,
1230: p_init_msg_list=>OKC_API.G_FALSE,
1231: x_return_status=>l_return_status,
1232: x_msg_count=>x_msg_count,
1233: x_msg_data=>x_msg_data,
1234: p_ctcv_rec=>p_ctcv_tbl(i),

Line 1390: IF ( p_ctcv_rec.cpl_id IS NULL OR p_ctcv_rec.cpl_id=OKC_API.G_MISS_NUM) THEN

1386: x_return_status := OKE_API.G_RET_STS_SUCCESS;
1387:
1388:
1389:
1390: IF ( p_ctcv_rec.cpl_id IS NULL OR p_ctcv_rec.cpl_id=OKC_API.G_MISS_NUM) THEN
1391: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
1392: p_msg_name =>G_REQUIRED_VALUE,
1393: p_token1 =>G_COL_NAME_TOKEN,
1394: p_token1_value =>'cpl_id');

Line 1757: p_init_msg_list=>OKC_API.G_FALSE,

1753: i := p_ctcv_tbl.FIRST;
1754: LOOP
1755: -- call procedure for a record
1756: update_k_contact(p_api_version=>p_api_version,
1757: p_init_msg_list=>OKC_API.G_FALSE,
1758: x_return_status=>l_return_status,
1759: x_msg_count=>x_msg_count,
1760: x_msg_data=>x_msg_data,
1761: p_ctcv_rec=>p_ctcv_tbl(i),

Line 1955: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1951: x_ctcv_rec OUT NOCOPY ctcv_rec_type
1952: ) RETURN VARCHAR2 IS
1953: l_ctcv_rec ctcv_rec_type;
1954: l_row_notfound BOOLEAN := TRUE;
1955: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1956: BEGIN
1957:
1958:
1959:

Line 1970: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1966: p_token1 =>G_COL_NAME_TOKEN,
1967: p_token1_value =>'ID');
1968:
1969:
1970: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1971: END IF;
1972: IF (x_ctcv_rec.id = OKC_API.G_MISS_NUM)
1973: THEN
1974: x_ctcv_rec.id := l_ctcv_rec.id;

Line 1972: IF (x_ctcv_rec.id = OKC_API.G_MISS_NUM)

1968:
1969:
1970: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1971: END IF;
1972: IF (x_ctcv_rec.id = OKC_API.G_MISS_NUM)
1973: THEN
1974: x_ctcv_rec.id := l_ctcv_rec.id;
1975: END IF;
1976: IF (x_ctcv_rec.object_version_number = OKC_API.G_MISS_NUM)

Line 1976: IF (x_ctcv_rec.object_version_number = OKC_API.G_MISS_NUM)

1972: IF (x_ctcv_rec.id = OKC_API.G_MISS_NUM)
1973: THEN
1974: x_ctcv_rec.id := l_ctcv_rec.id;
1975: END IF;
1976: IF (x_ctcv_rec.object_version_number = OKC_API.G_MISS_NUM)
1977: THEN
1978: x_ctcv_rec.object_version_number := l_ctcv_rec.object_version_number;
1979: END IF;
1980: IF (x_ctcv_rec.cpl_id = OKC_API.G_MISS_NUM)

Line 1980: IF (x_ctcv_rec.cpl_id = OKC_API.G_MISS_NUM)

1976: IF (x_ctcv_rec.object_version_number = OKC_API.G_MISS_NUM)
1977: THEN
1978: x_ctcv_rec.object_version_number := l_ctcv_rec.object_version_number;
1979: END IF;
1980: IF (x_ctcv_rec.cpl_id = OKC_API.G_MISS_NUM)
1981: THEN
1982: x_ctcv_rec.cpl_id := l_ctcv_rec.cpl_id;
1983: END IF;
1984: IF (x_ctcv_rec.cro_code = OKC_API.G_MISS_CHAR)

Line 1984: IF (x_ctcv_rec.cro_code = OKC_API.G_MISS_CHAR)

1980: IF (x_ctcv_rec.cpl_id = OKC_API.G_MISS_NUM)
1981: THEN
1982: x_ctcv_rec.cpl_id := l_ctcv_rec.cpl_id;
1983: END IF;
1984: IF (x_ctcv_rec.cro_code = OKC_API.G_MISS_CHAR)
1985: THEN
1986: x_ctcv_rec.cro_code := l_ctcv_rec.cro_code;
1987: END IF;
1988: IF (x_ctcv_rec.dnz_chr_id = OKC_API.G_MISS_NUM)

Line 1988: IF (x_ctcv_rec.dnz_chr_id = OKC_API.G_MISS_NUM)

1984: IF (x_ctcv_rec.cro_code = OKC_API.G_MISS_CHAR)
1985: THEN
1986: x_ctcv_rec.cro_code := l_ctcv_rec.cro_code;
1987: END IF;
1988: IF (x_ctcv_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1989: THEN
1990: x_ctcv_rec.dnz_chr_id := l_ctcv_rec.dnz_chr_id;
1991: END IF;
1992: IF (x_ctcv_rec.contact_sequence = OKC_API.G_MISS_NUM)

Line 1992: IF (x_ctcv_rec.contact_sequence = OKC_API.G_MISS_NUM)

1988: IF (x_ctcv_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1989: THEN
1990: x_ctcv_rec.dnz_chr_id := l_ctcv_rec.dnz_chr_id;
1991: END IF;
1992: IF (x_ctcv_rec.contact_sequence = OKC_API.G_MISS_NUM)
1993: THEN
1994: x_ctcv_rec.contact_sequence := l_ctcv_rec.contact_sequence;
1995: END IF;
1996: IF (x_ctcv_rec.object1_id1 = OKC_API.G_MISS_CHAR)

Line 1996: IF (x_ctcv_rec.object1_id1 = OKC_API.G_MISS_CHAR)

1992: IF (x_ctcv_rec.contact_sequence = OKC_API.G_MISS_NUM)
1993: THEN
1994: x_ctcv_rec.contact_sequence := l_ctcv_rec.contact_sequence;
1995: END IF;
1996: IF (x_ctcv_rec.object1_id1 = OKC_API.G_MISS_CHAR)
1997: THEN
1998: x_ctcv_rec.object1_id1 := l_ctcv_rec.object1_id1;
1999: END IF;
2000: IF (x_ctcv_rec.object1_id2 = OKC_API.G_MISS_CHAR)

Line 2000: IF (x_ctcv_rec.object1_id2 = OKC_API.G_MISS_CHAR)

1996: IF (x_ctcv_rec.object1_id1 = OKC_API.G_MISS_CHAR)
1997: THEN
1998: x_ctcv_rec.object1_id1 := l_ctcv_rec.object1_id1;
1999: END IF;
2000: IF (x_ctcv_rec.object1_id2 = OKC_API.G_MISS_CHAR)
2001: THEN
2002: x_ctcv_rec.object1_id2 := l_ctcv_rec.object1_id2;
2003: END IF;
2004: IF (x_ctcv_rec.jtot_object1_code = OKC_API.G_MISS_CHAR)

Line 2004: IF (x_ctcv_rec.jtot_object1_code = OKC_API.G_MISS_CHAR)

2000: IF (x_ctcv_rec.object1_id2 = OKC_API.G_MISS_CHAR)
2001: THEN
2002: x_ctcv_rec.object1_id2 := l_ctcv_rec.object1_id2;
2003: END IF;
2004: IF (x_ctcv_rec.jtot_object1_code = OKC_API.G_MISS_CHAR)
2005: THEN
2006: x_ctcv_rec.JTOT_OBJECT1_CODE := l_ctcv_rec.JTOT_OBJECT1_CODE;
2007: END IF;
2008: IF (x_ctcv_rec.primary_yn = OKC_API.G_MISS_CHAR)

Line 2008: IF (x_ctcv_rec.primary_yn = OKC_API.G_MISS_CHAR)

2004: IF (x_ctcv_rec.jtot_object1_code = OKC_API.G_MISS_CHAR)
2005: THEN
2006: x_ctcv_rec.JTOT_OBJECT1_CODE := l_ctcv_rec.JTOT_OBJECT1_CODE;
2007: END IF;
2008: IF (x_ctcv_rec.primary_yn = OKC_API.G_MISS_CHAR)
2009: THEN
2010: x_ctcv_rec.PRIMARY_YN := l_ctcv_rec.PRIMARY_YN;
2011: END IF;
2012: IF (x_ctcv_rec.RESOURCE_CLASS= OKC_API.G_MISS_CHAR)

Line 2012: IF (x_ctcv_rec.RESOURCE_CLASS= OKC_API.G_MISS_CHAR)

2008: IF (x_ctcv_rec.primary_yn = OKC_API.G_MISS_CHAR)
2009: THEN
2010: x_ctcv_rec.PRIMARY_YN := l_ctcv_rec.PRIMARY_YN;
2011: END IF;
2012: IF (x_ctcv_rec.RESOURCE_CLASS= OKC_API.G_MISS_CHAR)
2013: THEN
2014: x_ctcv_rec.RESOURCE_CLASS := l_ctcv_rec.RESOURCE_CLASS;
2015: END IF;
2016: --

Line 2017: IF (x_ctcv_rec.SALES_GROUP_ID = OKC_API.G_MISS_NUM) THEN

2013: THEN
2014: x_ctcv_rec.RESOURCE_CLASS := l_ctcv_rec.RESOURCE_CLASS;
2015: END IF;
2016: --
2017: IF (x_ctcv_rec.SALES_GROUP_ID = OKC_API.G_MISS_NUM) THEN
2018: x_ctcv_rec.SALES_GROUP_ID := l_ctcv_rec.SALES_GROUP_ID;
2019: END IF;
2020: --
2021: IF (x_ctcv_rec.attribute_category = OKC_API.G_MISS_CHAR)

Line 2021: IF (x_ctcv_rec.attribute_category = OKC_API.G_MISS_CHAR)

2017: IF (x_ctcv_rec.SALES_GROUP_ID = OKC_API.G_MISS_NUM) THEN
2018: x_ctcv_rec.SALES_GROUP_ID := l_ctcv_rec.SALES_GROUP_ID;
2019: END IF;
2020: --
2021: IF (x_ctcv_rec.attribute_category = OKC_API.G_MISS_CHAR)
2022: THEN
2023: x_ctcv_rec.attribute_category := l_ctcv_rec.attribute_category;
2024: END IF;
2025: IF (x_ctcv_rec.attribute1 = OKC_API.G_MISS_CHAR)

Line 2025: IF (x_ctcv_rec.attribute1 = OKC_API.G_MISS_CHAR)

2021: IF (x_ctcv_rec.attribute_category = OKC_API.G_MISS_CHAR)
2022: THEN
2023: x_ctcv_rec.attribute_category := l_ctcv_rec.attribute_category;
2024: END IF;
2025: IF (x_ctcv_rec.attribute1 = OKC_API.G_MISS_CHAR)
2026: THEN
2027: x_ctcv_rec.attribute1 := l_ctcv_rec.attribute1;
2028: END IF;
2029: IF (x_ctcv_rec.attribute2 = OKC_API.G_MISS_CHAR)

Line 2029: IF (x_ctcv_rec.attribute2 = OKC_API.G_MISS_CHAR)

2025: IF (x_ctcv_rec.attribute1 = OKC_API.G_MISS_CHAR)
2026: THEN
2027: x_ctcv_rec.attribute1 := l_ctcv_rec.attribute1;
2028: END IF;
2029: IF (x_ctcv_rec.attribute2 = OKC_API.G_MISS_CHAR)
2030: THEN
2031: x_ctcv_rec.attribute2 := l_ctcv_rec.attribute2;
2032: END IF;
2033: IF (x_ctcv_rec.attribute3 = OKC_API.G_MISS_CHAR)

Line 2033: IF (x_ctcv_rec.attribute3 = OKC_API.G_MISS_CHAR)

2029: IF (x_ctcv_rec.attribute2 = OKC_API.G_MISS_CHAR)
2030: THEN
2031: x_ctcv_rec.attribute2 := l_ctcv_rec.attribute2;
2032: END IF;
2033: IF (x_ctcv_rec.attribute3 = OKC_API.G_MISS_CHAR)
2034: THEN
2035: x_ctcv_rec.attribute3 := l_ctcv_rec.attribute3;
2036: END IF;
2037: IF (x_ctcv_rec.attribute4 = OKC_API.G_MISS_CHAR)

Line 2037: IF (x_ctcv_rec.attribute4 = OKC_API.G_MISS_CHAR)

2033: IF (x_ctcv_rec.attribute3 = OKC_API.G_MISS_CHAR)
2034: THEN
2035: x_ctcv_rec.attribute3 := l_ctcv_rec.attribute3;
2036: END IF;
2037: IF (x_ctcv_rec.attribute4 = OKC_API.G_MISS_CHAR)
2038: THEN
2039: x_ctcv_rec.attribute4 := l_ctcv_rec.attribute4;
2040: END IF;
2041: IF (x_ctcv_rec.attribute5 = OKC_API.G_MISS_CHAR)

Line 2041: IF (x_ctcv_rec.attribute5 = OKC_API.G_MISS_CHAR)

2037: IF (x_ctcv_rec.attribute4 = OKC_API.G_MISS_CHAR)
2038: THEN
2039: x_ctcv_rec.attribute4 := l_ctcv_rec.attribute4;
2040: END IF;
2041: IF (x_ctcv_rec.attribute5 = OKC_API.G_MISS_CHAR)
2042: THEN
2043: x_ctcv_rec.attribute5 := l_ctcv_rec.attribute5;
2044: END IF;
2045: IF (x_ctcv_rec.attribute6 = OKC_API.G_MISS_CHAR)

Line 2045: IF (x_ctcv_rec.attribute6 = OKC_API.G_MISS_CHAR)

2041: IF (x_ctcv_rec.attribute5 = OKC_API.G_MISS_CHAR)
2042: THEN
2043: x_ctcv_rec.attribute5 := l_ctcv_rec.attribute5;
2044: END IF;
2045: IF (x_ctcv_rec.attribute6 = OKC_API.G_MISS_CHAR)
2046: THEN
2047: x_ctcv_rec.attribute6 := l_ctcv_rec.attribute6;
2048: END IF;
2049: IF (x_ctcv_rec.attribute7 = OKC_API.G_MISS_CHAR)

Line 2049: IF (x_ctcv_rec.attribute7 = OKC_API.G_MISS_CHAR)

2045: IF (x_ctcv_rec.attribute6 = OKC_API.G_MISS_CHAR)
2046: THEN
2047: x_ctcv_rec.attribute6 := l_ctcv_rec.attribute6;
2048: END IF;
2049: IF (x_ctcv_rec.attribute7 = OKC_API.G_MISS_CHAR)
2050: THEN
2051: x_ctcv_rec.attribute7 := l_ctcv_rec.attribute7;
2052: END IF;
2053: IF (x_ctcv_rec.attribute8 = OKC_API.G_MISS_CHAR)

Line 2053: IF (x_ctcv_rec.attribute8 = OKC_API.G_MISS_CHAR)

2049: IF (x_ctcv_rec.attribute7 = OKC_API.G_MISS_CHAR)
2050: THEN
2051: x_ctcv_rec.attribute7 := l_ctcv_rec.attribute7;
2052: END IF;
2053: IF (x_ctcv_rec.attribute8 = OKC_API.G_MISS_CHAR)
2054: THEN
2055: x_ctcv_rec.attribute8 := l_ctcv_rec.attribute8;
2056: END IF;
2057: IF (x_ctcv_rec.attribute9 = OKC_API.G_MISS_CHAR)

Line 2057: IF (x_ctcv_rec.attribute9 = OKC_API.G_MISS_CHAR)

2053: IF (x_ctcv_rec.attribute8 = OKC_API.G_MISS_CHAR)
2054: THEN
2055: x_ctcv_rec.attribute8 := l_ctcv_rec.attribute8;
2056: END IF;
2057: IF (x_ctcv_rec.attribute9 = OKC_API.G_MISS_CHAR)
2058: THEN
2059: x_ctcv_rec.attribute9 := l_ctcv_rec.attribute9;
2060: END IF;
2061: IF (x_ctcv_rec.attribute10 = OKC_API.G_MISS_CHAR)

Line 2061: IF (x_ctcv_rec.attribute10 = OKC_API.G_MISS_CHAR)

2057: IF (x_ctcv_rec.attribute9 = OKC_API.G_MISS_CHAR)
2058: THEN
2059: x_ctcv_rec.attribute9 := l_ctcv_rec.attribute9;
2060: END IF;
2061: IF (x_ctcv_rec.attribute10 = OKC_API.G_MISS_CHAR)
2062: THEN
2063: x_ctcv_rec.attribute10 := l_ctcv_rec.attribute10;
2064: END IF;
2065: IF (x_ctcv_rec.attribute11 = OKC_API.G_MISS_CHAR)

Line 2065: IF (x_ctcv_rec.attribute11 = OKC_API.G_MISS_CHAR)

2061: IF (x_ctcv_rec.attribute10 = OKC_API.G_MISS_CHAR)
2062: THEN
2063: x_ctcv_rec.attribute10 := l_ctcv_rec.attribute10;
2064: END IF;
2065: IF (x_ctcv_rec.attribute11 = OKC_API.G_MISS_CHAR)
2066: THEN
2067: x_ctcv_rec.attribute11 := l_ctcv_rec.attribute11;
2068: END IF;
2069: IF (x_ctcv_rec.attribute12 = OKC_API.G_MISS_CHAR)

Line 2069: IF (x_ctcv_rec.attribute12 = OKC_API.G_MISS_CHAR)

2065: IF (x_ctcv_rec.attribute11 = OKC_API.G_MISS_CHAR)
2066: THEN
2067: x_ctcv_rec.attribute11 := l_ctcv_rec.attribute11;
2068: END IF;
2069: IF (x_ctcv_rec.attribute12 = OKC_API.G_MISS_CHAR)
2070: THEN
2071: x_ctcv_rec.attribute12 := l_ctcv_rec.attribute12;
2072: END IF;
2073: IF (x_ctcv_rec.attribute13 = OKC_API.G_MISS_CHAR)

Line 2073: IF (x_ctcv_rec.attribute13 = OKC_API.G_MISS_CHAR)

2069: IF (x_ctcv_rec.attribute12 = OKC_API.G_MISS_CHAR)
2070: THEN
2071: x_ctcv_rec.attribute12 := l_ctcv_rec.attribute12;
2072: END IF;
2073: IF (x_ctcv_rec.attribute13 = OKC_API.G_MISS_CHAR)
2074: THEN
2075: x_ctcv_rec.attribute13 := l_ctcv_rec.attribute13;
2076: END IF;
2077: IF (x_ctcv_rec.attribute14 = OKC_API.G_MISS_CHAR)

Line 2077: IF (x_ctcv_rec.attribute14 = OKC_API.G_MISS_CHAR)

2073: IF (x_ctcv_rec.attribute13 = OKC_API.G_MISS_CHAR)
2074: THEN
2075: x_ctcv_rec.attribute13 := l_ctcv_rec.attribute13;
2076: END IF;
2077: IF (x_ctcv_rec.attribute14 = OKC_API.G_MISS_CHAR)
2078: THEN
2079: x_ctcv_rec.attribute14 := l_ctcv_rec.attribute14;
2080: END IF;
2081: IF (x_ctcv_rec.attribute15 = OKC_API.G_MISS_CHAR)

Line 2081: IF (x_ctcv_rec.attribute15 = OKC_API.G_MISS_CHAR)

2077: IF (x_ctcv_rec.attribute14 = OKC_API.G_MISS_CHAR)
2078: THEN
2079: x_ctcv_rec.attribute14 := l_ctcv_rec.attribute14;
2080: END IF;
2081: IF (x_ctcv_rec.attribute15 = OKC_API.G_MISS_CHAR)
2082: THEN
2083: x_ctcv_rec.attribute15 := l_ctcv_rec.attribute15;
2084: END IF;
2085: IF (x_ctcv_rec.created_by = OKC_API.G_MISS_NUM)

Line 2085: IF (x_ctcv_rec.created_by = OKC_API.G_MISS_NUM)

2081: IF (x_ctcv_rec.attribute15 = OKC_API.G_MISS_CHAR)
2082: THEN
2083: x_ctcv_rec.attribute15 := l_ctcv_rec.attribute15;
2084: END IF;
2085: IF (x_ctcv_rec.created_by = OKC_API.G_MISS_NUM)
2086: THEN
2087: x_ctcv_rec.created_by := l_ctcv_rec.created_by;
2088: END IF;
2089: IF (x_ctcv_rec.creation_date = OKC_API.G_MISS_DATE)

Line 2089: IF (x_ctcv_rec.creation_date = OKC_API.G_MISS_DATE)

2085: IF (x_ctcv_rec.created_by = OKC_API.G_MISS_NUM)
2086: THEN
2087: x_ctcv_rec.created_by := l_ctcv_rec.created_by;
2088: END IF;
2089: IF (x_ctcv_rec.creation_date = OKC_API.G_MISS_DATE)
2090: THEN
2091: x_ctcv_rec.creation_date := l_ctcv_rec.creation_date;
2092: END IF;
2093: IF (x_ctcv_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 2093: IF (x_ctcv_rec.last_updated_by = OKC_API.G_MISS_NUM)

2089: IF (x_ctcv_rec.creation_date = OKC_API.G_MISS_DATE)
2090: THEN
2091: x_ctcv_rec.creation_date := l_ctcv_rec.creation_date;
2092: END IF;
2093: IF (x_ctcv_rec.last_updated_by = OKC_API.G_MISS_NUM)
2094: THEN
2095: x_ctcv_rec.last_updated_by := l_ctcv_rec.last_updated_by;
2096: END IF;
2097: IF (x_ctcv_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 2097: IF (x_ctcv_rec.last_update_date = OKC_API.G_MISS_DATE)

2093: IF (x_ctcv_rec.last_updated_by = OKC_API.G_MISS_NUM)
2094: THEN
2095: x_ctcv_rec.last_updated_by := l_ctcv_rec.last_updated_by;
2096: END IF;
2097: IF (x_ctcv_rec.last_update_date = OKC_API.G_MISS_DATE)
2098: THEN
2099: x_ctcv_rec.last_update_date := l_ctcv_rec.last_update_date;
2100: END IF;
2101: IF (x_ctcv_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 2101: IF (x_ctcv_rec.last_update_login = OKC_API.G_MISS_NUM)

2097: IF (x_ctcv_rec.last_update_date = OKC_API.G_MISS_DATE)
2098: THEN
2099: x_ctcv_rec.last_update_date := l_ctcv_rec.last_update_date;
2100: END IF;
2101: IF (x_ctcv_rec.last_update_login = OKC_API.G_MISS_NUM)
2102: THEN
2103: x_ctcv_rec.last_update_login := l_ctcv_rec.last_update_login;
2104: END IF;
2105: IF (x_ctcv_rec.start_date = OKC_API.G_MISS_DATE)

Line 2105: IF (x_ctcv_rec.start_date = OKC_API.G_MISS_DATE)

2101: IF (x_ctcv_rec.last_update_login = OKC_API.G_MISS_NUM)
2102: THEN
2103: x_ctcv_rec.last_update_login := l_ctcv_rec.last_update_login;
2104: END IF;
2105: IF (x_ctcv_rec.start_date = OKC_API.G_MISS_DATE)
2106: THEN
2107: x_ctcv_rec.start_date := l_ctcv_rec.start_date;
2108: END IF;
2109: IF (x_ctcv_rec.end_date = OKC_API.G_MISS_DATE)

Line 2109: IF (x_ctcv_rec.end_date = OKC_API.G_MISS_DATE)

2105: IF (x_ctcv_rec.start_date = OKC_API.G_MISS_DATE)
2106: THEN
2107: x_ctcv_rec.start_date := l_ctcv_rec.start_date;
2108: END IF;
2109: IF (x_ctcv_rec.end_date = OKC_API.G_MISS_DATE)
2110: THEN
2111: x_ctcv_rec.end_date := l_ctcv_rec.end_date;
2112: END IF;
2113:

Line 2140: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2136: raise OKE_API.G_EXCEPTION_ERROR;
2137: End If;
2138:
2139: l_return_status := populate_new_record(p_ctcv_rec, l_ctcv_rec);
2140: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2141: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2142: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2143: RAISE OKC_API.G_EXCEPTION_ERROR;
2144: END IF;

Line 2141: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2137: End If;
2138:
2139: l_return_status := populate_new_record(p_ctcv_rec, l_ctcv_rec);
2140: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2141: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2142: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2143: RAISE OKC_API.G_EXCEPTION_ERROR;
2144: END IF;
2145:

Line 2142: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

2138:
2139: l_return_status := populate_new_record(p_ctcv_rec, l_ctcv_rec);
2140: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2141: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2142: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2143: RAISE OKC_API.G_EXCEPTION_ERROR;
2144: END IF;
2145:
2146: ---Other validations which are part of OKE and missing in the above procedure

Line 2143: RAISE OKC_API.G_EXCEPTION_ERROR;

2139: l_return_status := populate_new_record(p_ctcv_rec, l_ctcv_rec);
2140: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2141: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2142: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2143: RAISE OKC_API.G_EXCEPTION_ERROR;
2144: END IF;
2145:
2146: ---Other validations which are part of OKE and missing in the above procedure
2147: