699: l_dummy_var VARCHAR2(1) := '?' ;
700:
701: CURSOR okl_tbcv_prch_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
702: SELECT 'x'
703: FROM Fnd_Lookup_Values
704: WHERE fnd_lookup_values.lookup_code = p_lookup_code
705: AND fnd_lookup_values.lookup_type = p_lookup_type;
706:
707: BEGIN
700:
701: CURSOR okl_tbcv_prch_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
702: SELECT 'x'
703: FROM Fnd_Lookup_Values
704: WHERE fnd_lookup_values.lookup_code = p_lookup_code
705: AND fnd_lookup_values.lookup_type = p_lookup_type;
706:
707: BEGIN
708:
701: CURSOR okl_tbcv_prch_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
702: SELECT 'x'
703: FROM Fnd_Lookup_Values
704: WHERE fnd_lookup_values.lookup_code = p_lookup_code
705: AND fnd_lookup_values.lookup_type = p_lookup_type;
706:
707: BEGIN
708:
709: IF (p_tbcv_rec.purchase_option_code <> OKL_API.G_MISS_CHAR AND p_tbcv_rec.purchase_option_code IS NOT NULL)
724: 'purchase_option_code',
725: g_child_table_token ,
726: 'OKL_TAX_ATTR_DEFINITIONS',
727: g_parent_table_token ,
728: 'FND_LOOKUP_VALUES');
729: l_return_status := OKC_API.G_RET_STS_ERROR;
730:
731: END IF;
732: END IF;
911: l_dummy_var VARCHAR2(1) := '?' ;
912:
913: CURSOR okl_tbcv_int_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
914: SELECT 'x'
915: FROM Fnd_Lookup_Values
916: WHERE fnd_lookup_values.lookup_code = p_lookup_code
917: AND fnd_lookup_values.lookup_type = p_lookup_type;
918: BEGIN
919:
912:
913: CURSOR okl_tbcv_int_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
914: SELECT 'x'
915: FROM Fnd_Lookup_Values
916: WHERE fnd_lookup_values.lookup_code = p_lookup_code
917: AND fnd_lookup_values.lookup_type = p_lookup_type;
918: BEGIN
919:
920: IF (p_tbcv_rec.int_disclosed_code <> OKL_API.G_MISS_CHAR AND p_tbcv_rec.int_disclosed_code IS NOT NULL)
913: CURSOR okl_tbcv_int_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
914: SELECT 'x'
915: FROM Fnd_Lookup_Values
916: WHERE fnd_lookup_values.lookup_code = p_lookup_code
917: AND fnd_lookup_values.lookup_type = p_lookup_type;
918: BEGIN
919:
920: IF (p_tbcv_rec.int_disclosed_code <> OKL_API.G_MISS_CHAR AND p_tbcv_rec.int_disclosed_code IS NOT NULL)
921: THEN
934: 'int_disclosed_code',
935: g_child_table_token ,
936: 'OKL_TAX_ATTR_DEFINITIONS',
937: g_parent_table_token ,
938: 'FND_LOOKUP_VALUES');
939: l_return_status := OKC_API.G_RET_STS_ERROR;
940:
941: END IF;
942: END IF;
964: l_dummy_var VARCHAR2(1) := '?' ;
965:
966: CURSOR okl_tbcv_title_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
967: SELECT 'x'
968: FROM Fnd_Lookup_Values
969: WHERE fnd_lookup_values.lookup_code = p_lookup_code
970: AND fnd_lookup_values.lookup_type = p_lookup_type;
971: BEGIN
972:
965:
966: CURSOR okl_tbcv_title_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
967: SELECT 'x'
968: FROM Fnd_Lookup_Values
969: WHERE fnd_lookup_values.lookup_code = p_lookup_code
970: AND fnd_lookup_values.lookup_type = p_lookup_type;
971: BEGIN
972:
973: IF (p_tbcv_rec.title_trnsfr_code <> OKL_API.G_MISS_CHAR AND p_tbcv_rec.title_trnsfr_code IS NOT NULL)
966: CURSOR okl_tbcv_title_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
967: SELECT 'x'
968: FROM Fnd_Lookup_Values
969: WHERE fnd_lookup_values.lookup_code = p_lookup_code
970: AND fnd_lookup_values.lookup_type = p_lookup_type;
971: BEGIN
972:
973: IF (p_tbcv_rec.title_trnsfr_code <> OKL_API.G_MISS_CHAR AND p_tbcv_rec.title_trnsfr_code IS NOT NULL)
974: THEN
983: 'title_trnsfr_code',
984: g_child_table_token ,
985: 'OKL_TAX_ATTR_DEFINITIONS',
986: g_parent_table_token ,
987: 'FND_LOOKUP_VALUES');
988: l_return_status := OKC_API.G_RET_STS_ERROR;
989:
990: END IF;
991: END IF;
1012: l_dummy_var VARCHAR2(1) := '?' ;
1013:
1014: CURSOR okl_tbcv_salelease_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
1015: SELECT 'x'
1016: FROM Fnd_Lookup_Values
1017: WHERE fnd_lookup_values.lookup_code = p_lookup_code
1018: AND fnd_lookup_values.lookup_type = p_lookup_type;
1019: BEGIN
1020:
1013:
1014: CURSOR okl_tbcv_salelease_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
1015: SELECT 'x'
1016: FROM Fnd_Lookup_Values
1017: WHERE fnd_lookup_values.lookup_code = p_lookup_code
1018: AND fnd_lookup_values.lookup_type = p_lookup_type;
1019: BEGIN
1020:
1021: IF (p_tbcv_rec.sale_lease_back_code <> OKL_API.G_MISS_CHAR AND p_tbcv_rec.sale_lease_back_code IS NOT NULL)
1014: CURSOR okl_tbcv_salelease_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
1015: SELECT 'x'
1016: FROM Fnd_Lookup_Values
1017: WHERE fnd_lookup_values.lookup_code = p_lookup_code
1018: AND fnd_lookup_values.lookup_type = p_lookup_type;
1019: BEGIN
1020:
1021: IF (p_tbcv_rec.sale_lease_back_code <> OKL_API.G_MISS_CHAR AND p_tbcv_rec.sale_lease_back_code IS NOT NULL)
1022: THEN
1035: 'sale_lease_back_code',
1036: g_child_table_token ,
1037: 'OKL_TAX_ATTR_DEFINITIONS',
1038: g_parent_table_token ,
1039: 'FND_LOOKUP_VALUES');
1040: l_return_status := OKC_API.G_RET_STS_ERROR;
1041: END IF;
1042: END IF;
1043: x_return_status := l_return_status;
1063: l_dummy_var VARCHAR2(1) := '?' ;
1064:
1065: CURSOR okl_tbcv_saleprch_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
1066: SELECT 'x'
1067: FROM Fnd_Lookup_Values
1068: WHERE fnd_lookup_values.lookup_code = p_lookup_code
1069: AND fnd_lookup_values.lookup_type = p_lookup_type;
1070: BEGIN
1071:
1064:
1065: CURSOR okl_tbcv_saleprch_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
1066: SELECT 'x'
1067: FROM Fnd_Lookup_Values
1068: WHERE fnd_lookup_values.lookup_code = p_lookup_code
1069: AND fnd_lookup_values.lookup_type = p_lookup_type;
1070: BEGIN
1071:
1072: IF (p_tbcv_rec.lease_purchased_code <> OKL_API.G_MISS_CHAR AND p_tbcv_rec.lease_purchased_code IS NOT NULL)
1065: CURSOR okl_tbcv_saleprch_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
1066: SELECT 'x'
1067: FROM Fnd_Lookup_Values
1068: WHERE fnd_lookup_values.lookup_code = p_lookup_code
1069: AND fnd_lookup_values.lookup_type = p_lookup_type;
1070: BEGIN
1071:
1072: IF (p_tbcv_rec.lease_purchased_code <> OKL_API.G_MISS_CHAR AND p_tbcv_rec.lease_purchased_code IS NOT NULL)
1073: THEN
1086: 'lease_purchased_code',
1087: g_child_table_token ,
1088: 'OKL_TAX_ATTR_DEFINITIONS',
1089: g_parent_table_token ,
1090: 'FND_LOOKUP_VALUES');
1091: l_return_status := OKC_API.G_RET_STS_ERROR;
1092: END IF;
1093: END IF;
1094: x_return_status := l_return_status;