DBA Data[Home] [Help]

APPS.OKL_TAS_PVT dependencies on OKL_API

Line 393: (p_tasv_rec.legal_entity_id <> Okl_Api.G_MISS_NUM) THEN

389:
390: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
391:
392: IF (p_tasv_rec.legal_entity_id IS NOT NULL) AND
393: (p_tasv_rec.legal_entity_id <> Okl_Api.G_MISS_NUM) THEN
394: l_exists := OKL_LEGAL_ENTITY_UTIL.check_le_id_exists(p_tasv_rec.legal_entity_id) ;
395: IF (l_exists<>1) THEN
396: Okc_Api.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'LEGAL_ENTITY_ID');
397: RAISE item_not_found_error;

Line 767: IF (l_tasv_rec.LEGAL_ENTITY_ID = OKL_API.G_MISS_NUM) THEN

763: IF (l_tasv_rec.org_id = OKC_API.G_MISS_NUM) THEN
764: l_tasv_rec.org_id := NULL;
765: END IF;
766: --Added by dpsingh for LE uptake
767: IF (l_tasv_rec.LEGAL_ENTITY_ID = OKL_API.G_MISS_NUM) THEN
768: l_tasv_rec.LEGAL_ENTITY_ID := NULL;
769: END IF;
770: IF (l_tasv_rec.TRANSACTION_DATE = OKL_API.G_MISS_DATE) THEN
771: l_tasv_rec.TRANSACTION_DATE := NULL;

Line 770: IF (l_tasv_rec.TRANSACTION_DATE = OKL_API.G_MISS_DATE) THEN

766: --Added by dpsingh for LE uptake
767: IF (l_tasv_rec.LEGAL_ENTITY_ID = OKL_API.G_MISS_NUM) THEN
768: l_tasv_rec.LEGAL_ENTITY_ID := NULL;
769: END IF;
770: IF (l_tasv_rec.TRANSACTION_DATE = OKL_API.G_MISS_DATE) THEN
771: l_tasv_rec.TRANSACTION_DATE := NULL;
772: END IF;
773: RETURN(l_tasv_rec);
774: END null_out_defaults;

Line 991: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

987: -- validate_row for:OKL_TRX_ASSETS_V --
988: ---------------------------------------
989: PROCEDURE validate_row(
990: p_api_version IN NUMBER,
991: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
992: x_return_status OUT NOCOPY VARCHAR2,
993: x_msg_count OUT NOCOPY NUMBER,
994: x_msg_data OUT NOCOPY VARCHAR2,
995: p_tasv_rec IN tasv_rec_type) IS

Line 1067: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1063: -- PL/SQL TBL validate_row for:TASV_TBL --
1064: ------------------------------------------
1065: PROCEDURE validate_row(
1066: p_api_version IN NUMBER,
1067: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1068: x_return_status OUT NOCOPY VARCHAR2,
1069: x_msg_count OUT NOCOPY NUMBER,
1070: x_msg_data OUT NOCOPY VARCHAR2,
1071: p_tasv_tbl IN tasv_tbl_type) IS

Line 1294: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1290: -- insert_row for:OKL_TRX_ASSETS_V --
1291: -------------------------------------
1292: PROCEDURE insert_row(
1293: p_api_version IN NUMBER,
1294: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1295: x_return_status OUT NOCOPY VARCHAR2,
1296: x_msg_count OUT NOCOPY NUMBER,
1297: x_msg_data OUT NOCOPY VARCHAR2,
1298: p_tasv_rec IN tasv_rec_type,

Line 1341: p_tasv_rec.trans_number = OKL_API.G_MISS_NUM) THEN

1337: x_tasv_rec := p_tasv_rec;
1338: x_tasv_rec.OBJECT_VERSION_NUMBER := 1;
1339: -- Bug no 2627151 change start
1340: IF (p_tasv_rec.trans_number IS NULL OR
1341: p_tasv_rec.trans_number = OKL_API.G_MISS_NUM) THEN
1342: OPEN c_get_trans_number;
1343: FETCH c_get_trans_number INTO x_tasv_rec.trans_number;
1344: CLOSE c_get_trans_number;
1345: END IF;

Line 1451: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1447: -- PL/SQL TBL insert_row for:TASV_TBL --
1448: ----------------------------------------
1449: PROCEDURE insert_row(
1450: p_api_version IN NUMBER,
1451: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1452: x_return_status OUT NOCOPY VARCHAR2,
1453: x_msg_count OUT NOCOPY NUMBER,
1454: x_msg_data OUT NOCOPY VARCHAR2,
1455: p_tasv_tbl IN tasv_tbl_type,

Line 1520: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1516: ---------------------------------
1517: -- lock_row for:OKL_TRX_ASSETS --
1518: ---------------------------------
1519: PROCEDURE lock_row(
1520: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1521: x_return_status OUT NOCOPY VARCHAR2,
1522: x_msg_count OUT NOCOPY NUMBER,
1523: x_msg_data OUT NOCOPY VARCHAR2,
1524: p_tas_rec IN tas_rec_type) IS

Line 1627: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1623: -- lock_row for:OKL_TRX_ASSETS_V --
1624: -----------------------------------
1625: PROCEDURE lock_row(
1626: p_api_version IN NUMBER,
1627: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1628: x_return_status OUT NOCOPY VARCHAR2,
1629: x_msg_count OUT NOCOPY NUMBER,
1630: x_msg_data OUT NOCOPY VARCHAR2,
1631: p_tasv_rec IN tasv_rec_type) IS

Line 1707: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1703: -- PL/SQL TBL lock_row for:TASV_TBL --
1704: --------------------------------------
1705: PROCEDURE lock_row(
1706: p_api_version IN NUMBER,
1707: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1708: x_return_status OUT NOCOPY VARCHAR2,
1709: x_msg_count OUT NOCOPY NUMBER,
1710: x_msg_data OUT NOCOPY VARCHAR2,
1711: p_tasv_tbl IN tasv_tbl_type) IS

Line 1938: IF (x_tas_rec.legal_entity_id = OKL_API.G_MISS_NUM)

1934: THEN
1935: x_tas_rec.org_id := l_tas_rec.org_id;
1936: END IF;
1937: -- Added by dpsingh for LE uptake
1938: IF (x_tas_rec.legal_entity_id = OKL_API.G_MISS_NUM)
1939: THEN
1940: x_tas_rec.legal_entity_id := l_tas_rec.legal_entity_id;
1941: END IF;
1942: IF (x_tas_rec.transaction_date = OKL_API.G_MISS_DATE)

Line 1942: IF (x_tas_rec.transaction_date = OKL_API.G_MISS_DATE)

1938: IF (x_tas_rec.legal_entity_id = OKL_API.G_MISS_NUM)
1939: THEN
1940: x_tas_rec.legal_entity_id := l_tas_rec.legal_entity_id;
1941: END IF;
1942: IF (x_tas_rec.transaction_date = OKL_API.G_MISS_DATE)
1943: THEN
1944: x_tas_rec.transaction_date := SYSDATE;
1945: END IF;
1946: RETURN(l_return_status);

Line 2064: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2060: -- update_row for:OKL_TRX_ASSETS_V --
2061: -------------------------------------
2062: PROCEDURE update_row(
2063: p_api_version IN NUMBER,
2064: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2065: x_return_status OUT NOCOPY VARCHAR2,
2066: x_msg_count OUT NOCOPY NUMBER,
2067: x_msg_data OUT NOCOPY VARCHAR2,
2068: p_tasv_rec IN tasv_rec_type,

Line 2242: IF (x_tasv_rec.legal_entity_id = OKL_API.G_MISS_NUM)

2238: THEN
2239: x_tasv_rec.org_id := l_tasv_rec.org_id;
2240: END IF;
2241: --Added by dpsingh for LE uptake
2242: IF (x_tasv_rec.legal_entity_id = OKL_API.G_MISS_NUM)
2243: THEN
2244: x_tasv_rec.legal_entity_id := l_tasv_rec.legal_entity_id;
2245: END IF;
2246: IF (x_tasv_rec.transaction_date = OKL_API.G_MISS_DATE)

Line 2246: IF (x_tasv_rec.transaction_date = OKL_API.G_MISS_DATE)

2242: IF (x_tasv_rec.legal_entity_id = OKL_API.G_MISS_NUM)
2243: THEN
2244: x_tasv_rec.legal_entity_id := l_tasv_rec.legal_entity_id;
2245: END IF;
2246: IF (x_tasv_rec.transaction_date = OKL_API.G_MISS_DATE)
2247: THEN
2248: x_tasv_rec.transaction_date := l_tasv_rec.transaction_date;
2249: END IF;
2250: RETURN(l_return_status);

Line 2370: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2366: -- PL/SQL TBL update_row for:TASV_TBL --
2367: ----------------------------------------
2368: PROCEDURE update_row(
2369: p_api_version IN NUMBER,
2370: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2371: x_return_status OUT NOCOPY VARCHAR2,
2372: x_msg_count OUT NOCOPY NUMBER,
2373: x_msg_data OUT NOCOPY VARCHAR2,
2374: p_tasv_tbl IN tasv_tbl_type,

Line 2501: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2497: -- delete_row for:OKL_TRX_ASSETS_V --
2498: -------------------------------------
2499: PROCEDURE delete_row(
2500: p_api_version IN NUMBER,
2501: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2502: x_return_status OUT NOCOPY VARCHAR2,
2503: x_msg_count OUT NOCOPY NUMBER,
2504: x_msg_data OUT NOCOPY VARCHAR2,
2505: p_tasv_rec IN tasv_rec_type) IS

Line 2582: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2578: -- PL/SQL TBL delete_row for:TASV_TBL --
2579: ----------------------------------------
2580: PROCEDURE delete_row(
2581: p_api_version IN NUMBER,
2582: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2583: x_return_status OUT NOCOPY VARCHAR2,
2584: x_msg_count OUT NOCOPY NUMBER,
2585: x_msg_data OUT NOCOPY VARCHAR2,
2586: p_tasv_tbl IN tasv_tbl_type) IS