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.OKL_TEH_PVT dependencies on OKL_TRX_EXTENSION_B

Line 66: CURSOR c_pk_csr IS SELECT okl_trx_extension_b_s.NEXTVAL FROM DUAL;

62: -- FUNCTION get_seq_id
63: ---------------------------------------------------------------------------
64: FUNCTION get_seq_id RETURN NUMBER IS
65: l_pk_value NUMBER;
66: CURSOR c_pk_csr IS SELECT okl_trx_extension_b_s.NEXTVAL FROM DUAL;
67: BEGIN
68: /* Fetch the pk value from the sequence */
69: OPEN c_pk_csr;
70: FETCH c_pk_csr INTO l_pk_value;

Line 107: FROM OKL_TRX_EXTENSION_B B

103: BEGIN
104: DELETE FROM OKL_TRX_EXTENSION_TL T
105: WHERE NOT EXISTS (
106: SELECT NULL
107: FROM OKL_TRX_EXTENSION_B B
108: WHERE B.HEADER_EXTENSION_ID =T.HEADER_EXTENSION_ID
109: );
110:
111: UPDATE OKL_TRX_EXTENSION_TL T SET(

Line 372: -- FUNCTION get_rec for: OKL_TRX_EXTENSION_B

368: BEGIN
369: RETURN(get_rec(p_tehv_rec, l_row_not_found));
370: END get_rec;
371: ---------------------------------------------------------------------------
372: -- FUNCTION get_rec for: OKL_TRX_EXTENSION_B
373: ---------------------------------------------------------------------------
374: FUNCTION get_rec (
375: p_teh_rec IN teh_rec_type,
376: x_no_data_found OUT NOCOPY BOOLEAN

Line 378: CURSOR okl_trx_extension_b_pk_csr (p_header_extension_id IN NUMBER) IS

374: FUNCTION get_rec (
375: p_teh_rec IN teh_rec_type,
376: x_no_data_found OUT NOCOPY BOOLEAN
377: ) RETURN teh_rec_type IS
378: CURSOR okl_trx_extension_b_pk_csr (p_header_extension_id IN NUMBER) IS
379: SELECT
380: HEADER_EXTENSION_ID,
381: SOURCE_ID,
382: SOURCE_TABLE,

Line 445: FROM Okl_Trx_Extension_B

441: CHR_OPERATING_UNIT_CODE,
442: PARTY_ID ,
443: CUST_ACCOUNT_ID,
444: CUST_SITE_USE_ID
445: FROM Okl_Trx_Extension_B
446: WHERE okl_trx_extension_b.header_extension_id = p_header_extension_id;
447: l_okl_trx_extension_b_pk okl_trx_extension_b_pk_csr%ROWTYPE;
448: l_teh_rec teh_rec_type;
449: BEGIN

Line 446: WHERE okl_trx_extension_b.header_extension_id = p_header_extension_id;

442: PARTY_ID ,
443: CUST_ACCOUNT_ID,
444: CUST_SITE_USE_ID
445: FROM Okl_Trx_Extension_B
446: WHERE okl_trx_extension_b.header_extension_id = p_header_extension_id;
447: l_okl_trx_extension_b_pk okl_trx_extension_b_pk_csr%ROWTYPE;
448: l_teh_rec teh_rec_type;
449: BEGIN
450: x_no_data_found := TRUE;

Line 447: l_okl_trx_extension_b_pk okl_trx_extension_b_pk_csr%ROWTYPE;

443: CUST_ACCOUNT_ID,
444: CUST_SITE_USE_ID
445: FROM Okl_Trx_Extension_B
446: WHERE okl_trx_extension_b.header_extension_id = p_header_extension_id;
447: l_okl_trx_extension_b_pk okl_trx_extension_b_pk_csr%ROWTYPE;
448: l_teh_rec teh_rec_type;
449: BEGIN
450: x_no_data_found := TRUE;
451: -- Get current database values

Line 452: OPEN okl_trx_extension_b_pk_csr (p_teh_rec.header_extension_id);

448: l_teh_rec teh_rec_type;
449: BEGIN
450: x_no_data_found := TRUE;
451: -- Get current database values
452: OPEN okl_trx_extension_b_pk_csr (p_teh_rec.header_extension_id);
453: FETCH okl_trx_extension_b_pk_csr INTO
454: l_teh_rec.header_extension_id,
455: l_teh_rec.source_id,
456: l_teh_rec.source_table,

Line 453: FETCH okl_trx_extension_b_pk_csr INTO

449: BEGIN
450: x_no_data_found := TRUE;
451: -- Get current database values
452: OPEN okl_trx_extension_b_pk_csr (p_teh_rec.header_extension_id);
453: FETCH okl_trx_extension_b_pk_csr INTO
454: l_teh_rec.header_extension_id,
455: l_teh_rec.source_id,
456: l_teh_rec.source_table,
457: l_teh_rec.object_version_number,

Line 519: x_no_data_found := okl_trx_extension_b_pk_csr%NOTFOUND;

515: l_teh_rec.chr_operating_unit_code,
516: l_teh_rec.party_id ,
517: l_teh_rec.cust_account_id,
518: l_teh_rec.cust_site_use_id;
519: x_no_data_found := okl_trx_extension_b_pk_csr%NOTFOUND;
520: CLOSE okl_trx_extension_b_pk_csr;
521: RETURN(l_teh_rec);
522: END get_rec;
523:

Line 520: CLOSE okl_trx_extension_b_pk_csr;

516: l_teh_rec.party_id ,
517: l_teh_rec.cust_account_id,
518: l_teh_rec.cust_site_use_id;
519: x_no_data_found := okl_trx_extension_b_pk_csr%NOTFOUND;
520: CLOSE okl_trx_extension_b_pk_csr;
521: RETURN(l_teh_rec);
522: END get_rec;
523:
524: ------------------------------------------------------------------

Line 1611: -- insert_row for:OKL_TRX_EXTENSION_B --

1607: ---------------------------------------------------------------------------
1608: -- PROCEDURE insert_row
1609: ---------------------------------------------------------------------------
1610: ----------------------------------------
1611: -- insert_row for:OKL_TRX_EXTENSION_B --
1612: ----------------------------------------
1613: PROCEDURE insert_row(
1614: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1615: x_return_status OUT NOCOPY VARCHAR2,

Line 1627: -- Set_Attributes for:OKL_TRX_EXTENSION_B --

1623: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1624: l_teh_rec teh_rec_type := p_teh_rec;
1625: l_def_teh_rec teh_rec_type;
1626: --------------------------------------------
1627: -- Set_Attributes for:OKL_TRX_EXTENSION_B --
1628: --------------------------------------------
1629: FUNCTION Set_Attributes (
1630: p_teh_rec IN teh_rec_type,
1631: x_teh_rec OUT NOCOPY teh_rec_type

Line 1658: INSERT INTO OKL_TRX_EXTENSION_B(

1654: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1655: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1656: RAISE OKL_API.G_EXCEPTION_ERROR;
1657: END IF;
1658: INSERT INTO OKL_TRX_EXTENSION_B(
1659: header_extension_id,
1660: source_id,
1661: source_table,
1662: object_version_number,

Line 1949: -- insert_row for :OKL_TRX_EXTENSION_B --

1945: '_PVT'
1946: );
1947: END insert_row;
1948: -----------------------------------------
1949: -- insert_row for :OKL_TRX_EXTENSION_B --
1950: -----------------------------------------
1951: PROCEDURE insert_row(
1952: p_api_version IN NUMBER,
1953: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1985: -- Set_Attributes for:OKL_TRX_EXTENSION_B --

1981: l_tehv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1982: RETURN(l_tehv_rec);
1983: END fill_who_columns;
1984: --------------------------------------------
1985: -- Set_Attributes for:OKL_TRX_EXTENSION_B --
1986: --------------------------------------------
1987: FUNCTION Set_Attributes (
1988: p_tehv_rec IN tehv_rec_type,
1989: x_tehv_rec OUT NOCOPY tehv_rec_type

Line 2276: -- lock_row for:OKL_TRX_EXTENSION_B --

2272: ---------------------------------------------------------------------------
2273: -- PROCEDURE lock_row
2274: ---------------------------------------------------------------------------
2275: --------------------------------------
2276: -- lock_row for:OKL_TRX_EXTENSION_B --
2277: --------------------------------------
2278: PROCEDURE lock_row(
2279: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2280: x_return_status OUT NOCOPY VARCHAR2,

Line 2289: FROM OKL_TRX_EXTENSION_B

2285: E_Resource_Busy EXCEPTION;
2286: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2287: CURSOR lock_csr (p_teh_rec IN teh_rec_type) IS
2288: SELECT OBJECT_VERSION_NUMBER
2289: FROM OKL_TRX_EXTENSION_B
2290: WHERE HEADER_EXTENSION_ID = p_teh_rec.header_extension_id
2291: AND OBJECT_VERSION_NUMBER = p_teh_rec.object_version_number
2292: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2293:

Line 2296: FROM OKL_TRX_EXTENSION_B

2292: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2293:
2294: CURSOR lchk_csr (p_teh_rec IN teh_rec_type) IS
2295: SELECT OBJECT_VERSION_NUMBER
2296: FROM OKL_TRX_EXTENSION_B
2297: WHERE HEADER_EXTENSION_ID = p_teh_rec.header_extension_id;
2298: l_api_version CONSTANT NUMBER := 1;
2299: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2300: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 2301: l_object_version_number OKL_TRX_EXTENSION_B.OBJECT_VERSION_NUMBER%TYPE;

2297: WHERE HEADER_EXTENSION_ID = p_teh_rec.header_extension_id;
2298: l_api_version CONSTANT NUMBER := 1;
2299: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2300: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2301: l_object_version_number OKL_TRX_EXTENSION_B.OBJECT_VERSION_NUMBER%TYPE;
2302: lc_object_version_number OKL_TRX_EXTENSION_B.OBJECT_VERSION_NUMBER%TYPE;
2303: l_row_notfound BOOLEAN := FALSE;
2304: lc_row_notfound BOOLEAN := FALSE;
2305: BEGIN

Line 2302: lc_object_version_number OKL_TRX_EXTENSION_B.OBJECT_VERSION_NUMBER%TYPE;

2298: l_api_version CONSTANT NUMBER := 1;
2299: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2300: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2301: l_object_version_number OKL_TRX_EXTENSION_B.OBJECT_VERSION_NUMBER%TYPE;
2302: lc_object_version_number OKL_TRX_EXTENSION_B.OBJECT_VERSION_NUMBER%TYPE;
2303: l_row_notfound BOOLEAN := FALSE;
2304: lc_row_notfound BOOLEAN := FALSE;
2305: BEGIN
2306: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 2723: -- update_row for:OKL_TRX_EXTENSION_B --

2719: ---------------------------------------------------------------------------
2720: -- PROCEDURE update_row
2721: ---------------------------------------------------------------------------
2722: ----------------------------------------
2723: -- update_row for:OKL_TRX_EXTENSION_B --
2724: ----------------------------------------
2725: PROCEDURE update_row(
2726: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2727: x_return_status OUT NOCOPY VARCHAR2,

Line 2953: -- Set_Attributes for:OKL_TRX_EXTENSION_B --

2949: END IF;
2950: RETURN(l_return_status);
2951: END populate_new_record;
2952: --------------------------------------------
2953: -- Set_Attributes for:OKL_TRX_EXTENSION_B --
2954: --------------------------------------------
2955: FUNCTION Set_Attributes (
2956: p_teh_rec IN teh_rec_type,
2957: x_teh_rec OUT NOCOPY teh_rec_type

Line 2991: UPDATE OKL_TRX_EXTENSION_B

2987: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2988: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2989: RAISE OKL_API.G_EXCEPTION_ERROR;
2990: END IF;
2991: UPDATE OKL_TRX_EXTENSION_B
2992: SET SOURCE_ID = l_def_teh_rec.source_id,
2993: SOURCE_TABLE = l_def_teh_rec.source_table,
2994: OBJECT_VERSION_NUMBER = l_def_teh_rec.object_version_number,
2995: CONTRACT_NUMBER = l_def_teh_rec.contract_number,

Line 3830: -- delete_row for:OKL_TRX_EXTENSION_B --

3826: ---------------------------------------------------------------------------
3827: -- PROCEDURE delete_row
3828: ---------------------------------------------------------------------------
3829: ----------------------------------------
3830: -- delete_row for:OKL_TRX_EXTENSION_B --
3831: ----------------------------------------
3832: PROCEDURE delete_row(
3833: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3834: x_return_status OUT NOCOPY VARCHAR2,

Line 3855: DELETE FROM OKL_TRX_EXTENSION_B

3851: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3852: RAISE OKL_API.G_EXCEPTION_ERROR;
3853: END IF;
3854:
3855: DELETE FROM OKL_TRX_EXTENSION_B
3856: WHERE HEADER_EXTENSION_ID = p_teh_rec.header_extension_id;
3857:
3858: x_return_status := l_return_status;
3859: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 4214: -- insert_row for:OKL_TRX_EXTENSION_B/OKL_TRX_EXTENSION_TL ----------------

4210: -- PROCEDURE insert_row
4211: ---------------------------------------------------------------------------
4212: -- Added : PRASJAIN : Bug# 6268782
4213: ---------------------------------------------------------------------------
4214: -- insert_row for:OKL_TRX_EXTENSION_B/OKL_TRX_EXTENSION_TL ----------------
4215: ---------------------------------------------------------------------------
4216: PROCEDURE insert_row(
4217: p_api_version IN NUMBER,
4218: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 4255: -- Set_Attributes for:OKL_TRX_EXTENSION_B --

4251: l_teh_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
4252: RETURN(l_teh_rec);
4253: END fill_who_columns;
4254: --------------------------------------------
4255: -- Set_Attributes for:OKL_TRX_EXTENSION_B --
4256: --------------------------------------------
4257: FUNCTION Set_Attributes (
4258: p_teh_rec IN teh_rec_type,
4259: x_teh_rec OUT NOCOPY teh_rec_type