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.

[Home] [Help]

APPS.OKL_TBC_PVT dependencies on OKL_TAX_ATTR_DEFINITIONS

Line 67: select okl_tax_attr_definitions_s.NEXTVAL into l_id from dual;

63: ---------------------------------------------------------------------------
64: FUNCTION get_seq_id RETURN NUMBER IS
65: l_id NUMBER;
66: BEGIN
67: select okl_tax_attr_definitions_s.NEXTVAL into l_id from dual;
68: RETURN l_id;
69: END get_seq_id;
70:
71: ---------------------------------------------------------------------------

Line 96: -- FUNCTION get_rec for: OKL_TAX_ATTR_DEFINITIONS

92: null;
93: END api_copy;
94:
95: ---------------------------------------------------------------------------
96: -- FUNCTION get_rec for: OKL_TAX_ATTR_DEFINITIONS
97: ---------------------------------------------------------------------------
98: FUNCTION get_rec (
99: p_tbcv_rec IN tbcv_rec_type,
100: x_no_data_found OUT NOCOPY BOOLEAN

Line 152: FROM OKL_TAX_ATTR_DEFINITIONS

148: TERM_QUOTE_TYPE_CODE,
149: TERM_QUOTE_REASON_CODE,
150: EXPIRE_FLAG
151: -- modified by dcshanmu for eBTax project - modification end
152: FROM OKL_TAX_ATTR_DEFINITIONS
153: -- WHERE OKL_TAX_ATTR_DEFINITIONS.id = p_id;
154: WHERE OKL_TAX_ATTR_DEFINITIONS.TAX_ATTRIBUTE_DEF_ID = p_TAX_ATTRIBUTE_DEF_ID;
155: l_okl_tbcv_pk okl_tbcv_pk_csr%ROWTYPE;
156: l_tbcv_rec tbcv_rec_type;

Line 153: -- WHERE OKL_TAX_ATTR_DEFINITIONS.id = p_id;

149: TERM_QUOTE_REASON_CODE,
150: EXPIRE_FLAG
151: -- modified by dcshanmu for eBTax project - modification end
152: FROM OKL_TAX_ATTR_DEFINITIONS
153: -- WHERE OKL_TAX_ATTR_DEFINITIONS.id = p_id;
154: WHERE OKL_TAX_ATTR_DEFINITIONS.TAX_ATTRIBUTE_DEF_ID = p_TAX_ATTRIBUTE_DEF_ID;
155: l_okl_tbcv_pk okl_tbcv_pk_csr%ROWTYPE;
156: l_tbcv_rec tbcv_rec_type;
157: BEGIN

Line 154: WHERE OKL_TAX_ATTR_DEFINITIONS.TAX_ATTRIBUTE_DEF_ID = p_TAX_ATTRIBUTE_DEF_ID;

150: EXPIRE_FLAG
151: -- modified by dcshanmu for eBTax project - modification end
152: FROM OKL_TAX_ATTR_DEFINITIONS
153: -- WHERE OKL_TAX_ATTR_DEFINITIONS.id = p_id;
154: WHERE OKL_TAX_ATTR_DEFINITIONS.TAX_ATTRIBUTE_DEF_ID = p_TAX_ATTRIBUTE_DEF_ID;
155: l_okl_tbcv_pk okl_tbcv_pk_csr%ROWTYPE;
156: l_tbcv_rec tbcv_rec_type;
157: BEGIN
158: x_no_data_found := TRUE;

Line 245: -- FUNCTION get_rec for: OKL_TAX_ATTR_DEFINITIONS

241: BEGIN
242: RETURN(get_rec(p_tbcv_rec, l_row_not_found));
243: END get_rec;
244: ---------------------------------------------------------------------------
245: -- FUNCTION get_rec for: OKL_TAX_ATTR_DEFINITIONS
246: ---------------------------------------------------------------------------
247: FUNCTION get_rec (
248: p_tbc_rec IN tbc_rec_type,
249: x_no_data_found OUT NOCOPY BOOLEAN

Line 301: FROM OKL_TAX_ATTR_DEFINITIONS

297: TERM_QUOTE_TYPE_CODE,
298: TERM_QUOTE_REASON_CODE,
299: EXPIRE_FLAG
300: -- modified by dcshanmu for eBTax project - modification end
301: FROM OKL_TAX_ATTR_DEFINITIONS
302: -- WHERE OKL_TAX_ATTR_DEFINITIONS.id = p_id;
303: WHERE OKL_TAX_ATTR_DEFINITIONS.TAX_ATTRIBUTE_DEF_ID = p_TAX_ATTRIBUTE_DEF_ID;
304: l_okl_tbc_defs_pk okl_tbc_defs_pk_csr%ROWTYPE;
305: l_tbc_rec tbc_rec_type;

Line 302: -- WHERE OKL_TAX_ATTR_DEFINITIONS.id = p_id;

298: TERM_QUOTE_REASON_CODE,
299: EXPIRE_FLAG
300: -- modified by dcshanmu for eBTax project - modification end
301: FROM OKL_TAX_ATTR_DEFINITIONS
302: -- WHERE OKL_TAX_ATTR_DEFINITIONS.id = p_id;
303: WHERE OKL_TAX_ATTR_DEFINITIONS.TAX_ATTRIBUTE_DEF_ID = p_TAX_ATTRIBUTE_DEF_ID;
304: l_okl_tbc_defs_pk okl_tbc_defs_pk_csr%ROWTYPE;
305: l_tbc_rec tbc_rec_type;
306: BEGIN

Line 303: WHERE OKL_TAX_ATTR_DEFINITIONS.TAX_ATTRIBUTE_DEF_ID = p_TAX_ATTRIBUTE_DEF_ID;

299: EXPIRE_FLAG
300: -- modified by dcshanmu for eBTax project - modification end
301: FROM OKL_TAX_ATTR_DEFINITIONS
302: -- WHERE OKL_TAX_ATTR_DEFINITIONS.id = p_id;
303: WHERE OKL_TAX_ATTR_DEFINITIONS.TAX_ATTRIBUTE_DEF_ID = p_TAX_ATTRIBUTE_DEF_ID;
304: l_okl_tbc_defs_pk okl_tbc_defs_pk_csr%ROWTYPE;
305: l_tbc_rec tbc_rec_type;
306: BEGIN
307: x_no_data_found := TRUE;

Line 393: -- FUNCTION null_out_defaults for: OKL_TAX_ATTR_DEFINITIONS

389: BEGIN
390: RETURN(get_rec(p_tbc_rec, l_row_not_found));
391: END get_rec;
392: ---------------------------------------------------------------------------
393: -- FUNCTION null_out_defaults for: OKL_TAX_ATTR_DEFINITIONS
394: ---------------------------------------------------------------------------
395: FUNCTION null_out_defaults (
396: p_tbcv_rec IN tbcv_rec_type
397: ) RETURN tbcv_rec_type IS

Line 627: 'OKL_TAX_ATTR_DEFINITIONS',

623: g_no_parent_record,
624: g_col_name_token,
625: 'result_code',
626: g_child_table_token ,
627: 'OKL_TAX_ATTR_DEFINITIONS',
628: g_parent_table_token ,
629: 'ZX_FC_BUSINESS_CATEGORIES_V');
630: l_return_status := OKC_API.G_RET_STS_ERROR;
631:

Line 647: 'OKL_TAX_ATTR_DEFINITIONS',

643: g_no_parent_record,
644: g_col_name_token,
645: 'result_code',
646: g_child_table_token ,
647: 'OKL_TAX_ATTR_DEFINITIONS',
648: g_parent_table_token ,
649: 'ZX_FC_PRODUCT_CATEGORIES_V');
650: l_return_status := OKC_API.G_RET_STS_ERROR;
651:

Line 667: 'OKL_TAX_ATTR_DEFINITIONS',

663: g_no_parent_record,
664: g_col_name_token,
665: 'result_code',
666: g_child_table_token ,
667: 'OKL_TAX_ATTR_DEFINITIONS',
668: g_parent_table_token ,
669: 'ZX_FC_USER_DEFINED_V');
670: l_return_status := OKC_API.G_RET_STS_ERROR;
671:

Line 726: 'OKL_TAX_ATTR_DEFINITIONS',

722: g_no_parent_record,
723: g_col_name_token,
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:

Line 779: 'OKL_TAX_ATTR_DEFINITIONS',

775: g_no_parent_record,
776: g_col_name_token,
777: 'pdt_id',
778: g_child_table_token ,
779: 'OKL_TAX_ATTR_DEFINITIONS',
780: g_parent_table_token ,
781: 'OKL_PRODUCTS');
782: l_return_status := OKC_API.G_RET_STS_ERROR;
783:

Line 832: 'OKL_TAX_ATTR_DEFINITIONS',

828: g_no_parent_record,
829: g_col_name_token,
830: 'try_id',
831: g_child_table_token ,
832: 'OKL_TAX_ATTR_DEFINITIONS',
833: g_parent_table_token ,
834: 'OKL_TRX_TYPES_B');
835: l_return_status := OKC_API.G_RET_STS_ERROR;
836:

Line 884: 'OKL_TAX_ATTR_DEFINITIONS',

880: g_no_parent_record,
881: g_col_name_token,
882: 'sty_id',
883: g_child_table_token ,
884: 'OKL_TAX_ATTR_DEFINITIONS',
885: g_parent_table_token ,
886: 'OKL_STRM_TYPE_B');
887: l_return_status := OKC_API.G_RET_STS_ERROR;
888:

Line 936: 'OKL_TAX_ATTR_DEFINITIONS',

932: g_no_parent_record,
933: g_col_name_token,
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:

Line 985: 'OKL_TAX_ATTR_DEFINITIONS',

981: g_no_parent_record,
982: g_col_name_token,
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:

Line 1037: 'OKL_TAX_ATTR_DEFINITIONS',

1033: g_no_parent_record,
1034: g_col_name_token,
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;

Line 1088: 'OKL_TAX_ATTR_DEFINITIONS',

1084: g_no_parent_record,
1085: g_col_name_token,
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;

Line 1140: 'OKL_TAX_ATTR_DEFINITIONS',

1136: g_no_parent_record,
1137: g_col_name_token,
1138: 'equip_usage_code',
1139: g_child_table_token ,
1140: 'OKL_TAX_ATTR_DEFINITIONS',
1141: g_parent_table_token ,
1142: 'ZX_FC_INTENDED_USE_V');
1143: l_return_status := OKC_API.G_RET_STS_ERROR;
1144: END IF;

Line 1190: 'OKL_TAX_ATTR_DEFINITIONS',

1186: g_no_parent_record,
1187: g_col_name_token,
1188: 'vendor_site_id',
1189: g_child_table_token ,
1190: 'OKL_TAX_ATTR_DEFINITIONS',
1191: g_parent_table_token ,
1192: 'Po_vendor_sites_all');
1193: l_return_status := OKC_API.G_RET_STS_ERROR;
1194:

Line 1335: 'OKL_TAX_ATTR_DEFINITIONS',

1331: g_no_parent_record,
1332: g_col_name_token,
1333: 'result_type_code',
1334: g_child_table_token ,
1335: 'OKL_TAX_ATTR_DEFINITIONS',
1336: g_parent_table_token ,
1337: 'FND_LOOKUPS');
1338: l_return_status := OKC_API.G_RET_STS_ERROR;
1339:

Line 1383: 'OKL_TAX_ATTR_DEFINITIONS',

1379: g_no_parent_record,
1380: g_col_name_token,
1381: 'book_class_code',
1382: g_child_table_token ,
1383: 'OKL_TAX_ATTR_DEFINITIONS',
1384: g_parent_table_token ,
1385: 'FND_LOOKUPS');
1386: l_return_status := OKC_API.G_RET_STS_ERROR;
1387:

Line 1468: 'OKL_TAX_ATTR_DEFINITIONS',

1464: g_no_parent_record,
1465: g_col_name_token,
1466: 'tax_country_code',
1467: g_child_table_token ,
1468: 'OKL_TAX_ATTR_DEFINITIONS',
1469: g_parent_table_token ,
1470: 'FND_TERRITORIES_TL');
1471: l_return_status := OKC_API.G_RET_STS_ERROR;
1472:

Line 1517: 'OKL_TAX_ATTR_DEFINITIONS',

1513: g_no_parent_record,
1514: g_col_name_token,
1515: 'term_quote_type_code',
1516: g_child_table_token ,
1517: 'OKL_TAX_ATTR_DEFINITIONS',
1518: g_parent_table_token ,
1519: 'FND_LOOKUPS');
1520: l_return_status := OKC_API.G_RET_STS_ERROR;
1521:

Line 1566: 'OKL_TAX_ATTR_DEFINITIONS',

1562: g_no_parent_record,
1563: g_col_name_token,
1564: 'term_quote_reason_code',
1565: g_child_table_token ,
1566: 'OKL_TAX_ATTR_DEFINITIONS',
1567: g_parent_table_token ,
1568: 'FND_LOOKUPS');
1569: l_return_status := OKC_API.G_RET_STS_ERROR;
1570:

Line 1591: -- Validate_Attributes for:OKL_TAX_ATTR_DEFINITIONS --

1587: ---------------------------------------------------------------------------
1588: -- FUNCTION Validate_Attributes
1589: ---------------------------------------------------------------------------
1590: ---------------------------------------------------
1591: -- Validate_Attributes for:OKL_TAX_ATTR_DEFINITIONS --
1592: ---------------------------------------------------
1593: FUNCTION Validate_Attributes (
1594: p_tbcv_rec IN tbcv_rec_type
1595: ) RETURN VARCHAR2 IS

Line 1899: -- Validate Record for:OKL_TAX_ATTR_DEFINITIONS --

1895: ---------------------------------------------------------------------------
1896: -- PROCEDURE Validate_Record
1897: ---------------------------------------------------------------------------
1898: -----------------------------------------------
1899: -- Validate Record for:OKL_TAX_ATTR_DEFINITIONS --
1900: -----------------------------------------------
1901: /* Not needed as foreign key validations ar eincluded in individual validate procedures
1902: FUNCTION Validate_Record (
1903: p_tbcv_rec IN tbcv_rec_type,

Line 2079: FROM OKL_TAX_ATTR_DEFINITIONS

2075: -- modified the method to add just the necessary conditions for duplication for
2076: -- TBC_CODE, PC_CODE and UFC_CODE categories
2077: CURSOR l_checkduplicate_tbc_csr(cp_tax_attribute_def_id IN VARCHAR2) IS
2078: SELECT result_code
2079: FROM OKL_TAX_ATTR_DEFINITIONS
2080: WHERE result_type_code = 'TBC_CODE'
2081: -- AND nvl(PURCHASE_OPTION_CODE,'XXXXX') = nvl(p_tbcv_rec.PURCHASE_OPTION_CODE,'XXXXX')
2082: -- AND nvl(PDT_ID, -99999) = nvl(p_tbcv_rec.PDT_ID,-99999)
2083: AND nvl(TRY_ID, -99999) = nvl(p_tbcv_rec.TRY_ID,-99999)

Line 2146: FROM OKL_TAX_ATTR_DEFINITIONS

2142: )*/ ;
2143:
2144: CURSOR l_checkduplicate_pc_csr(cp_tax_attribute_def_id IN VARCHAR2) IS
2145: SELECT result_code
2146: FROM OKL_TAX_ATTR_DEFINITIONS
2147: WHERE result_type_code = 'PC_CODE'
2148: AND nvl(PURCHASE_OPTION_CODE,'XXXXX') = nvl(p_tbcv_rec.PURCHASE_OPTION_CODE,'XXXXX')
2149: AND nvl(STY_ID, -99999) = nvl(p_tbcv_rec.STY_ID,-99999)
2150: AND nvl(INT_DISCLOSED_CODE,'N') = nvl(p_tbcv_rec.INT_DISCLOSED_CODE,'N')

Line 2160: FROM OKL_TAX_ATTR_DEFINITIONS

2156: AND nvl(EXPIRE_FLAG,'N')<> 'Y' ;
2157:
2158: CURSOR l_checkduplicate_ufc_csr(cp_tax_attribute_def_id IN VARCHAR2) IS
2159: SELECT result_code
2160: FROM OKL_TAX_ATTR_DEFINITIONS
2161: WHERE /*result_code <> cp_tbc_code
2162: AND */result_type_code = 'UFC_CODE'
2163: AND nvl(PURCHASE_OPTION_CODE,'XXXXX') = nvl(p_tbcv_rec.PURCHASE_OPTION_CODE,'XXXXX')
2164: AND nvl(PDT_ID, -99999) = nvl(p_tbcv_rec.PDT_ID,-99999)

Line 2536: -- validate_row for:OKL_TAX_ATTR_DEFINITIONS --

2532: ---------------------------------------------------------------------------
2533: -- PROCEDURE validate_row
2534: ---------------------------------------------------------------------------
2535: --------------------------------------------
2536: -- validate_row for:OKL_TAX_ATTR_DEFINITIONS --
2537: --------------------------------------------
2538: PROCEDURE validate_row(
2539: p_api_version IN NUMBER,
2540: p_init_msg_list IN VARCHAR2,

Line 2613: -- PL/SQL TBL validate_row for:OKL_TAX_ATTR_DEFINITIONS --

2609: '_PVT'
2610: );
2611: END validate_row;
2612: -------------------------------------------------------
2613: -- PL/SQL TBL validate_row for:OKL_TAX_ATTR_DEFINITIONS --
2614: -------------------------------------------------------
2615: PROCEDURE validate_row(
2616: p_api_version IN NUMBER,
2617: p_init_msg_list IN VARCHAR2,

Line 2709: -- PL/SQL TBL validate_row for:OKL_TAX_ATTR_DEFINITIONS --

2705: );
2706: END validate_row;
2707:
2708: -------------------------------------------------------
2709: -- PL/SQL TBL validate_row for:OKL_TAX_ATTR_DEFINITIONS --
2710: -------------------------------------------------------
2711: PROCEDURE validate_row(
2712: p_api_version IN NUMBER,
2713: p_init_msg_list IN VARCHAR2,

Line 2774: -- insert_row for:OKL_TAX_ATTR_DEFINITIONS --

2770: ---------------------------------------------------------------------------
2771: -- PROCEDURE insert_row
2772: ---------------------------------------------------------------------------
2773: ------------------------------------------
2774: -- insert_row for:OKL_TAX_ATTR_DEFINITIONS --
2775: ------------------------------------------
2776: PROCEDURE insert_row(
2777: p_init_msg_list IN VARCHAR2,
2778: x_return_status OUT NOCOPY VARCHAR2,

Line 2790: -- Set_Attributes for:OKL_TAX_ATTR_DEFINITIONS--

2786: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2787: l_tbc_rec tbc_rec_type := p_tbc_rec;
2788: l_def_tbc_rec tbc_rec_type;
2789: ----------------------------------------------
2790: -- Set_Attributes for:OKL_TAX_ATTR_DEFINITIONS--
2791: ----------------------------------------------
2792: FUNCTION Set_Attributes (
2793: p_tbc_rec IN tbc_rec_type,
2794: x_tbc_rec OUT NOCOPY tbc_rec_type

Line 2823: INSERT INTO OKL_TAX_ATTR_DEFINITIONS(

2819: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2820: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2821: RAISE OKL_API.G_EXCEPTION_ERROR;
2822: END IF;
2823: INSERT INTO OKL_TAX_ATTR_DEFINITIONS(
2824: -- id,
2825: -- org_id,
2826: result_code,
2827: purchase_option_code,

Line 2958: -- insert_row for :OKL_TAX_ATTR_DEFINITIONS --

2954: '_PVT'
2955: );
2956: END insert_row;
2957: -------------------------------------------
2958: -- insert_row for :OKL_TAX_ATTR_DEFINITIONS --
2959: -------------------------------------------
2960: PROCEDURE insert_row(
2961: p_api_version IN NUMBER,
2962: p_init_msg_list IN VARCHAR2,

Line 2992: -- Set_Attributes for:OKL_TAX_ATTR_DEFINITIONS --

2988: l_tbcv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2989: RETURN(l_tbcv_rec);
2990: END fill_who_columns;
2991: ----------------------------------------------
2992: -- Set_Attributes for:OKL_TAX_ATTR_DEFINITIONS --
2993: ----------------------------------------------
2994: FUNCTION Set_Attributes (
2995: p_tbcv_rec IN tbcv_rec_type,
2996: x_tbcv_rec OUT NOCOPY tbcv_rec_type

Line 3272: -- lock_row for:OKL_TAX_ATTR_DEFINITIONS --

3268: ---------------------------------------------------------------------------
3269: -- PROCEDURE lock_row
3270: ---------------------------------------------------------------------------
3271: ----------------------------------------
3272: -- lock_row for:OKL_TAX_ATTR_DEFINITIONS --
3273: ----------------------------------------
3274: PROCEDURE lock_row(
3275: p_init_msg_list IN VARCHAR2,
3276: x_return_status OUT NOCOPY VARCHAR2,

Line 3285: FROM OKL_TAX_ATTR_DEFINITIONS

3281: E_Resource_Busy EXCEPTION;
3282: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3283: CURSOR lock_csr (p_tbc_rec IN tbc_rec_type) IS
3284: SELECT OBJECT_VERSION_NUMBER
3285: FROM OKL_TAX_ATTR_DEFINITIONS
3286: --WHERE ID = p_tbc_rec.id
3287: WHERE RESULT_CODE = p_tbc_rec.result_code
3288: AND OBJECT_VERSION_NUMBER = p_tbc_rec.object_version_number
3289: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line 3293: FROM OKL_TAX_ATTR_DEFINITIONS

3289: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3290:
3291: CURSOR lchk_csr (p_tbc_rec IN tbc_rec_type) IS
3292: SELECT OBJECT_VERSION_NUMBER
3293: FROM OKL_TAX_ATTR_DEFINITIONS
3294: -- WHERE ID = p_tbc_rec.id;
3295: WHERE RESULT_CODE = p_tbc_rec.result_code;
3296: l_api_version CONSTANT NUMBER := 1;
3297: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';

Line 3299: l_object_version_number OKL_TAX_ATTR_DEFINITIONS.OBJECT_VERSION_NUMBER%TYPE;

3295: WHERE RESULT_CODE = p_tbc_rec.result_code;
3296: l_api_version CONSTANT NUMBER := 1;
3297: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3298: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3299: l_object_version_number OKL_TAX_ATTR_DEFINITIONS.OBJECT_VERSION_NUMBER%TYPE;
3300: lc_object_version_number OKL_TAX_ATTR_DEFINITIONS.OBJECT_VERSION_NUMBER%TYPE;
3301: l_row_notfound BOOLEAN := FALSE;
3302: lc_row_notfound BOOLEAN := FALSE;
3303: BEGIN

Line 3300: lc_object_version_number OKL_TAX_ATTR_DEFINITIONS.OBJECT_VERSION_NUMBER%TYPE;

3296: l_api_version CONSTANT NUMBER := 1;
3297: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3298: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3299: l_object_version_number OKL_TAX_ATTR_DEFINITIONS.OBJECT_VERSION_NUMBER%TYPE;
3300: lc_object_version_number OKL_TAX_ATTR_DEFINITIONS.OBJECT_VERSION_NUMBER%TYPE;
3301: l_row_notfound BOOLEAN := FALSE;
3302: lc_row_notfound BOOLEAN := FALSE;
3303: BEGIN
3304: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 3381: -- lock_row for: OKL_TAX_ATTR_DEFINITIONS --

3377: '_PVT'
3378: );
3379: END lock_row;
3380: -----------------------------------------
3381: -- lock_row for: OKL_TAX_ATTR_DEFINITIONS --
3382: -----------------------------------------
3383: PROCEDURE lock_row(
3384: p_api_version IN NUMBER,
3385: p_init_msg_list IN VARCHAR2,

Line 3621: -- update_row for:OKL_TAX_ATTR_DEFINITIONS --

3617: ---------------------------------------------------------------------------
3618: -- PROCEDURE update_row
3619: ---------------------------------------------------------------------------
3620: ------------------------------------------
3621: -- update_row for:OKL_TAX_ATTR_DEFINITIONS --
3622: ------------------------------------------
3623: PROCEDURE update_row(
3624: p_init_msg_list IN VARCHAR2,
3625: x_return_status OUT NOCOPY VARCHAR2,

Line 3854: -- Set_Attributes for:OKL_TAX_ATTR_DEFINITIONS --

3850: END IF;
3851: RETURN(l_return_status);
3852: END populate_new_record;
3853: ----------------------------------------------
3854: -- Set_Attributes for:OKL_TAX_ATTR_DEFINITIONS --
3855: ----------------------------------------------
3856: FUNCTION Set_Attributes (
3857: p_tbc_rec IN tbc_rec_type,
3858: x_tbc_rec OUT NOCOPY tbc_rec_type

Line 3893: UPDATE OKL_TAX_ATTR_DEFINITIONS

3889: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3890: RAISE OKL_API.G_EXCEPTION_ERROR;
3891: END IF;
3892:
3893: UPDATE OKL_TAX_ATTR_DEFINITIONS
3894: SET --ORG_ID = l_def_tbc_rec.org_id,
3895: RESULT_CODE = l_def_tbc_rec.result_code,
3896: PURCHASE_OPTION_CODE = l_def_tbc_rec.purchase_option_code,
3897: PDT_ID = l_def_tbc_rec.pdt_id,

Line 3981: -- update_row for:OKL_TAX_ATTR_DEFINITIONS --

3977: '_PVT'
3978: );
3979: END update_row;
3980: ------------------------------------------
3981: -- update_row for:OKL_TAX_ATTR_DEFINITIONS --
3982: ------------------------------------------
3983: PROCEDURE update_row(
3984: p_api_version IN NUMBER,
3985: p_init_msg_list IN VARCHAR2,

Line 4231: -- Set_Attributes for:OKL_TAX_ATTR_DEFINITIONS --

4227: END IF;
4228: RETURN(l_return_status);
4229: END populate_new_record;
4230: ----------------------------------------------
4231: -- Set_Attributes for:OKL_TAX_ATTR_DEFINITIONS --
4232: ----------------------------------------------
4233: FUNCTION Set_Attributes (
4234: p_tbcv_rec IN tbcv_rec_type,
4235: x_tbcv_rec OUT NOCOPY tbcv_rec_type

Line 4561: -- delete_row for:OKL_TAX_ATTR_DEFINITIONS--

4557: ---------------------------------------------------------------------------
4558: -- PROCEDURE delete_row
4559: ---------------------------------------------------------------------------
4560: ------------------------------------------
4561: -- delete_row for:OKL_TAX_ATTR_DEFINITIONS--
4562: ------------------------------------------
4563: PROCEDURE delete_row(
4564: p_init_msg_list IN VARCHAR2,
4565: x_return_status OUT NOCOPY VARCHAR2,

Line 4586: DELETE FROM OKL_TAX_ATTR_DEFINITIONS

4582: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4583: RAISE OKL_API.G_EXCEPTION_ERROR;
4584: END IF;
4585:
4586: DELETE FROM OKL_TAX_ATTR_DEFINITIONS
4587: -- WHERE ID = p_tbc_rec.id;
4588: WHERE tax_attribute_def_id = p_tbc_rec.tax_attribute_def_id;
4589:
4590: x_return_status := l_return_status;

Line 4625: -- delete_row for:OKL_TAX_ATTR_DEFINITIONS --

4621: '_PVT'
4622: );
4623: END delete_row;
4624: ------------------------------------------
4625: -- delete_row for:OKL_TAX_ATTR_DEFINITIONS --
4626: ------------------------------------------
4627: PROCEDURE delete_row(
4628: p_api_version IN NUMBER,
4629: p_init_msg_list IN VARCHAR2,

Line 4707: -- PL/SQL TBL delete_row for:OKL_TAX_ATTR_DEFINITIONS --

4703: '_PVT'
4704: );
4705: END delete_row;
4706: -----------------------------------------------------
4707: -- PL/SQL TBL delete_row for:OKL_TAX_ATTR_DEFINITIONS --
4708: -----------------------------------------------------
4709: PROCEDURE delete_row(
4710: p_api_version IN NUMBER,
4711: p_init_msg_list IN VARCHAR2,

Line 4803: -- PL/SQL TBL delete_row for:OKL_TAX_ATTR_DEFINITIONS --

4799: );
4800: END delete_row;
4801:
4802: -----------------------------------------------------
4803: -- PL/SQL TBL delete_row for:OKL_TAX_ATTR_DEFINITIONS --
4804: -----------------------------------------------------
4805: PROCEDURE delete_row(
4806: p_api_version IN NUMBER,
4807: p_init_msg_list IN VARCHAR2,