DBA Data[Home] [Help]

APPS.OKL_TXS_PVT dependencies on OKL_TAX_SOURCES_V

Line 94: -- FUNCTION get_rec for: OKL_TAX_SOURCES_V

90: null;
91: END api_copy;
92:
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKL_TAX_SOURCES_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_txsv_rec IN txsv_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN

Line 190: FROM Okl_Tax_Sources_V

186: -- modified by eBTax by dcshanmu - modification end
187: ,ALC_SERIALIZED_YN
188: ,ALC_SERIALIZED_TOTAL_TAX
189: ,ALC_SERIALIZED_TOTAL_LINE_AMT
190: FROM Okl_Tax_Sources_V
191: WHERE okl_tax_sources_v.id = p_id;
192: l_okl_txsv_pk okl_txsv_pk_csr%ROWTYPE;
193: l_txsv_rec txsv_rec_type;
194: BEGIN

Line 191: WHERE okl_tax_sources_v.id = p_id;

187: ,ALC_SERIALIZED_YN
188: ,ALC_SERIALIZED_TOTAL_TAX
189: ,ALC_SERIALIZED_TOTAL_LINE_AMT
190: FROM Okl_Tax_Sources_V
191: WHERE okl_tax_sources_v.id = p_id;
192: l_okl_txsv_pk okl_txsv_pk_csr%ROWTYPE;
193: l_txsv_rec txsv_rec_type;
194: BEGIN
195: x_no_data_found := TRUE;

Line 550: -- FUNCTION null_out_defaults for: OKL_TAX_SOURCES_V

546: BEGIN
547: RETURN(get_rec(p_txs_rec, l_row_not_found));
548: END get_rec;
549: ---------------------------------------------------------------------------
550: -- FUNCTION null_out_defaults for: OKL_TAX_SOURCES_V
551: ---------------------------------------------------------------------------
552: FUNCTION null_out_defaults (
553: p_txsv_rec IN txsv_rec_type
554: ) RETURN txsv_rec_type IS

Line 877: 'OKL_TAX_SOURCES_V',

873: g_no_parent_record,
874: g_col_name_token,
875: 'khr_id',
876: g_child_table_token ,
877: 'OKL_TAX_SOURCES_V',
878: g_parent_table_token ,
879: 'OKC_K_HEADERS_B');
880: l_return_status := OKC_API.G_RET_STS_ERROR;
881:

Line 927: 'OKL_TAX_SOURCES_V',

923: g_no_parent_record,
924: g_col_name_token,
925: 'kle_id',
926: g_child_table_token ,
927: 'OKL_TAX_SOURCES_V',
928: g_parent_table_token ,
929: 'OKC_K_LINES_B');
930: l_return_status := OKC_API.G_RET_STS_ERROR;
931:

Line 1034: 'OKL_TAX_SOURCES_V',

1030: g_no_parent_record,
1031: g_col_name_token,
1032: 'tax_call_type_code',
1033: g_child_table_token ,
1034: 'OKL_TAX_SOURCES_V',
1035: g_parent_table_token ,
1036: 'FND_LOOKUP_VALUES');
1037: l_return_status := OKC_API.G_RET_STS_ERROR;
1038:

Line 1084: 'OKL_TAX_SOURCES_V',

1080: g_no_parent_record,
1081: g_col_name_token,
1082: 'sty_id',
1083: g_child_table_token ,
1084: 'OKL_TAX_SOURCES_V',
1085: g_parent_table_token ,
1086: 'okl_strm_type_b');
1087: l_return_status := OKC_API.G_RET_STS_ERROR;
1088:

Line 1142: 'OKL_TAX_SOURCES_V',

1138: g_no_parent_record,
1139: g_col_name_token,
1140: 'trx_business_category',
1141: g_child_table_token ,
1142: 'OKL_TAX_SOURCES_V',
1143: g_parent_table_token ,
1144: 'ZX_FC_BUSINESS_CATEGORIES_V');
1145: l_return_status := OKC_API.G_RET_STS_ERROR;
1146:

Line 1198: 'OKL_TAX_SOURCES_V',

1194: g_no_parent_record,
1195: g_col_name_token,
1196: 'tax_line_status_code',
1197: g_child_table_token ,
1198: 'OKL_TAX_SOURCES_V',
1199: g_parent_table_token ,
1200: 'FND_LOOKUP_VALUES');
1201: l_return_status := OKC_API.G_RET_STS_ERROR;
1202:

Line 1248: 'OKL_TAX_SOURCES_V',

1244: g_no_parent_record,
1245: g_col_name_token,
1246: 'sel_id',
1247: g_child_table_token ,
1248: 'OKL_TAX_SOURCES_V',
1249: g_parent_table_token ,
1250: 'okl_strm_elements');
1251: l_return_status := OKC_API.G_RET_STS_ERROR;
1252:

Line 1324: 'OKL_TAX_SOURCES_V',

1320: g_no_parent_record,
1321: g_col_name_token,
1322: 'default_taxation_country',
1323: g_child_table_token ,
1324: 'OKL_TAX_SOURCES_V',
1325: g_parent_table_token ,
1326: 'fnd_territories_tl');
1327: l_return_status := OKC_API.G_RET_STS_ERROR;
1328:

Line 1372: 'OKL_TAX_SOURCES_V',

1368: g_no_parent_record,
1369: g_col_name_token,
1370: 'product_category',
1371: g_child_table_token ,
1372: 'OKL_TAX_SOURCES_V',
1373: g_parent_table_token ,
1374: 'ZX_FC_PRODUCT_CATEGORIES_V');
1375: l_return_status := OKC_API.G_RET_STS_ERROR;
1376:

Line 1420: 'OKL_TAX_SOURCES_V',

1416: g_no_parent_record,
1417: g_col_name_token,
1418: 'user_defined_fisc_class',
1419: g_child_table_token ,
1420: 'OKL_TAX_SOURCES_V',
1421: g_parent_table_token ,
1422: 'ZX_FC_USER_DEFINED_V');
1423: l_return_status := OKC_API.G_RET_STS_ERROR;
1424:

Line 1468: 'OKL_TAX_SOURCES_V',

1464: g_no_parent_record,
1465: g_col_name_token,
1466: 'line_intended_use',
1467: g_child_table_token ,
1468: 'OKL_TAX_SOURCES_V',
1469: g_parent_table_token ,
1470: 'ZX_FC_INTENDED_USE_V');
1471: l_return_status := OKC_API.G_RET_STS_ERROR;
1472:

Line 1516: 'OKL_TAX_SOURCES_V',

1512: g_no_parent_record,
1513: g_col_name_token,
1514: 'inventory_item_id',
1515: g_child_table_token ,
1516: 'OKL_TAX_SOURCES_V',
1517: g_parent_table_token ,
1518: 'mtl_system_items_b');
1519: l_return_status := OKC_API.G_RET_STS_ERROR;
1520:

Line 1564: 'OKL_TAX_SOURCES_V',

1560: g_no_parent_record,
1561: g_col_name_token,
1562: 'bill_to_cust_acct_id',
1563: g_child_table_token ,
1564: 'OKL_TAX_SOURCES_V',
1565: g_parent_table_token ,
1566: 'hz_cust_accounts');
1567: l_return_status := OKC_API.G_RET_STS_ERROR;
1568:

Line 1612: 'OKL_TAX_SOURCES_V',

1608: g_no_parent_record,
1609: g_col_name_token,
1610: 'org_id',
1611: g_child_table_token ,
1612: 'OKL_TAX_SOURCES_V',
1613: g_parent_table_token ,
1614: 'hr_all_organization_units');
1615: l_return_status := OKC_API.G_RET_STS_ERROR;
1616:

Line 1663: 'OKL_TAX_SOURCES_V',

1659: g_no_parent_record,
1660: g_col_name_token,
1661: 'legal_entity_id',
1662: g_child_table_token ,
1663: 'OKL_TAX_SOURCES_V',
1664: g_parent_table_token ,
1665: 'xle_entity_profiles');
1666: l_return_status := OKC_API.G_RET_STS_ERROR;
1667:

Line 1711: 'OKL_TAX_SOURCES_V',

1707: g_no_parent_record,
1708: g_col_name_token,
1709: 'product_type',
1710: g_child_table_token ,
1711: 'OKL_TAX_SOURCES_V',
1712: g_parent_table_token ,
1713: 'fnd_lookups');
1714: l_return_status := OKC_API.G_RET_STS_ERROR;
1715:

Line 1759: 'OKL_TAX_SOURCES_V',

1755: g_no_parent_record,
1756: g_col_name_token,
1757: 'product_fisc_classification',
1758: g_child_table_token ,
1759: 'OKL_TAX_SOURCES_V',
1760: g_parent_table_token ,
1761: 'zx_fc_codes_b');
1762: l_return_status := OKC_API.G_RET_STS_ERROR;
1763:

Line 1861: 'OKL_TAX_SOURCES_V',

1857: g_no_parent_record,
1858: g_col_name_token,
1859: 'try_id',
1860: g_child_table_token ,
1861: 'OKL_TAX_SOURCES_V',
1862: g_parent_table_token ,
1863: 'okl_trx_types_b');
1864: l_return_status := OKC_API.G_RET_STS_ERROR;
1865:

Line 1911: 'OKL_TAX_SOURCES_V',

1907: g_no_parent_record,
1908: g_col_name_token,
1909: 'ship_to_location_id',
1910: g_child_table_token ,
1911: 'OKL_TAX_SOURCES_V',
1912: g_parent_table_token ,
1913: 'hz_party_sites');
1914: l_return_status := OKC_API.G_RET_STS_ERROR;
1915:

Line 1961: 'OKL_TAX_SOURCES_V',

1957: g_no_parent_record,
1958: g_col_name_token,
1959: 'ship_to_party_site_id',
1960: g_child_table_token ,
1961: 'OKL_TAX_SOURCES_V',
1962: g_parent_table_token ,
1963: 'hz_party_sites');
1964: l_return_status := OKC_API.G_RET_STS_ERROR;
1965:

Line 2011: 'OKL_TAX_SOURCES_V',

2007: g_no_parent_record,
2008: g_col_name_token,
2009: 'ship_to_party_id',
2010: g_child_table_token ,
2011: 'OKL_TAX_SOURCES_V',
2012: g_parent_table_token ,
2013: 'hz_party_sites');
2014: l_return_status := OKC_API.G_RET_STS_ERROR;
2015:

Line 2062: 'OKL_TAX_SOURCES_V',

2058: g_no_parent_record,
2059: g_col_name_token,
2060: 'bill_to_party_site_id',
2061: g_child_table_token ,
2062: 'OKL_TAX_SOURCES_V',
2063: g_parent_table_token ,
2064: 'hz_party_sites');
2065: l_return_status := OKC_API.G_RET_STS_ERROR;
2066:

Line 2113: 'OKL_TAX_SOURCES_V',

2109: g_no_parent_record,
2110: g_col_name_token,
2111: 'bill_to_location_id',
2112: g_child_table_token ,
2113: 'OKL_TAX_SOURCES_V',
2114: g_parent_table_token ,
2115: 'hz_party_sites');
2116: l_return_status := OKC_API.G_RET_STS_ERROR;
2117:

Line 2164: 'OKL_TAX_SOURCES_V',

2160: g_no_parent_record,
2161: g_col_name_token,
2162: 'bill_to_party_id',
2163: g_child_table_token ,
2164: 'OKL_TAX_SOURCES_V',
2165: g_parent_table_token ,
2166: 'hz_party_sites');
2167: l_return_status := OKC_API.G_RET_STS_ERROR;
2168:

Line 2214: 'OKL_TAX_SOURCES_V',

2210: g_no_parent_record,
2211: g_col_name_token,
2212: 'ship_to_cust_acct_site_use_id',
2213: g_child_table_token ,
2214: 'OKL_TAX_SOURCES_V',
2215: g_parent_table_token ,
2216: 'hz_cust_site_uses_all');
2217: l_return_status := OKC_API.G_RET_STS_ERROR;
2218:

Line 2265: 'OKL_TAX_SOURCES_V',

2261: g_no_parent_record,
2262: g_col_name_token,
2263: 'ship_to_cust_acct_site_use_id',
2264: g_child_table_token ,
2265: 'OKL_TAX_SOURCES_V',
2266: g_parent_table_token ,
2267: 'hz_cust_site_uses_all');
2268: l_return_status := OKC_API.G_RET_STS_ERROR;
2269:

Line 2318: -- Validate_Attributes for:OKL_TAX_SOURCES_V --

2314: ---------------------------------------------------------------------------
2315: -- FUNCTION Validate_Attributes
2316: ---------------------------------------------------------------------------
2317: -----------------------------------------------
2318: -- Validate_Attributes for:OKL_TAX_SOURCES_V --
2319: -----------------------------------------------
2320: FUNCTION Validate_Attributes (
2321: p_txsv_rec IN txsv_rec_type
2322: ) RETURN VARCHAR2 IS

Line 2785: -- Validate Record for:OKL_TAX_SOURCES_V --

2781: ---------------------------------------------------------------------------
2782: -- PROCEDURE Validate_Record
2783: ---------------------------------------------------------------------------
2784: /*-------------------------------------------
2785: -- Validate Record for:OKL_TAX_SOURCES_V --
2786: -------------------------------------------
2787: FUNCTION Validate_Record (
2788: p_txsv_rec IN txsv_rec_type,
2789: p_db_txsv_rec IN txsv_rec_type

Line 3011: -- validate_row for:OKL_TAX_SOURCES_V --

3007: ---------------------------------------------------------------------------
3008: -- PROCEDURE validate_row
3009: ---------------------------------------------------------------------------
3010: ----------------------------------------
3011: -- validate_row for:OKL_TAX_SOURCES_V --
3012: ----------------------------------------
3013: PROCEDURE validate_row(
3014: p_api_version IN NUMBER,
3015: p_init_msg_list IN VARCHAR2,

Line 3091: -- PL/SQL TBL validate_row for:OKL_TAX_SOURCES_V --

3087: '_PVT'
3088: );
3089: END validate_row;
3090: ---------------------------------------------------
3091: -- PL/SQL TBL validate_row for:OKL_TAX_SOURCES_V --
3092: ---------------------------------------------------
3093: PROCEDURE validate_row(
3094: p_api_version IN NUMBER,
3095: p_init_msg_list IN VARCHAR2,

Line 3187: -- PL/SQL TBL validate_row for:OKL_TAX_SOURCES_V --

3183: );
3184: END validate_row;
3185:
3186: ---------------------------------------------------
3187: -- PL/SQL TBL validate_row for:OKL_TAX_SOURCES_V --
3188: ---------------------------------------------------
3189: PROCEDURE validate_row(
3190: p_api_version IN NUMBER,
3191: p_init_msg_list IN VARCHAR2,

Line 3516: -- insert_row for :OKL_TAX_SOURCES_V --

3512: '_PVT'
3513: );
3514: END insert_row;
3515: ---------------------------------------
3516: -- insert_row for :OKL_TAX_SOURCES_V --
3517: ---------------------------------------
3518: PROCEDURE insert_row(
3519: p_api_version IN NUMBER,
3520: p_init_msg_list IN VARCHAR2,

Line 3550: -- Set_Attributes for:OKL_TAX_SOURCES_V --

3546: l_txsv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
3547: RETURN(l_txsv_rec);
3548: END fill_who_columns;
3549: ------------------------------------------
3550: -- Set_Attributes for:OKL_TAX_SOURCES_V --
3551: ------------------------------------------
3552: FUNCTION Set_Attributes (
3553: p_txsv_rec IN txsv_rec_type,
3554: x_txsv_rec OUT NOCOPY txsv_rec_type

Line 3937: -- lock_row for: OKL_TAX_SOURCES_V --

3933: '_PVT'
3934: );
3935: END lock_row;
3936: -------------------------------------
3937: -- lock_row for: OKL_TAX_SOURCES_V --
3938: -------------------------------------
3939: PROCEDURE lock_row(
3940: p_api_version IN NUMBER,
3941: p_init_msg_list IN VARCHAR2,

Line 4686: -- update_row for:OKL_TAX_SOURCES_V --

4682: '_PVT'
4683: );
4684: END update_row;
4685: --------------------------------------
4686: -- update_row for:OKL_TAX_SOURCES_V --
4687: --------------------------------------
4688: PROCEDURE update_row(
4689: p_api_version IN NUMBER,
4690: p_init_msg_list IN VARCHAR2,

Line 5055: -- Set_Attributes for:OKL_TAX_SOURCES_V --

5051: RETURN(l_return_status);
5052: END populate_new_record;
5053:
5054: ------------------------------------------
5055: -- Set_Attributes for:OKL_TAX_SOURCES_V --
5056: ------------------------------------------
5057: FUNCTION Set_Attributes (
5058: p_txsv_rec IN txsv_rec_type,
5059: x_txsv_rec OUT NOCOPY txsv_rec_type

Line 5412: -- delete_row for:OKL_TAX_SOURCES_V --

5408: '_PVT'
5409: );
5410: END delete_row;
5411: --------------------------------------
5412: -- delete_row for:OKL_TAX_SOURCES_V --
5413: --------------------------------------
5414: PROCEDURE delete_row(
5415: p_api_version IN NUMBER,
5416: p_init_msg_list IN VARCHAR2,

Line 5494: -- PL/SQL TBL delete_row for:OKL_TAX_SOURCES_V --

5490: '_PVT'
5491: );
5492: END delete_row;
5493: -------------------------------------------------
5494: -- PL/SQL TBL delete_row for:OKL_TAX_SOURCES_V --
5495: -------------------------------------------------
5496: PROCEDURE delete_row(
5497: p_api_version IN NUMBER,
5498: p_init_msg_list IN VARCHAR2,

Line 5590: -- PL/SQL TBL delete_row for:OKL_TAX_SOURCES_V --

5586: );
5587: END delete_row;
5588:
5589: -------------------------------------------------
5590: -- PL/SQL TBL delete_row for:OKL_TAX_SOURCES_V --
5591: -------------------------------------------------
5592: PROCEDURE delete_row(
5593: p_api_version IN NUMBER,
5594: p_init_msg_list IN VARCHAR2,