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_TCN_PVT dependencies on OKL_TRX_CONTRACTS

Line 10: SELECT OKL_TRX_CONTRACTS_ALL_S.NEXTVAL INTO l_seq FROM DUAL;

6: FUNCTION get_seq_id RETURN NUMBER IS
7: l_seq NUMBER;
8: BEGIN
9: -- Changed by nikshah for SLA project (Bug 5707866) 16-Apr-2007
10: SELECT OKL_TRX_CONTRACTS_ALL_S.NEXTVAL INTO l_seq FROM DUAL;
11: RETURN l_seq;
12: END get_seq_id;
13:
14: ---------------------------------------------------------------------------

Line 39: -- FUNCTION get_rec for: OKL_TRX_CONTRACTS

35: NULL;
36: END api_copy;
37:
38: ---------------------------------------------------------------------------
39: -- FUNCTION get_rec for: OKL_TRX_CONTRACTS
40: ---------------------------------------------------------------------------
41: FUNCTION get_rec (
42: p_tcn_rec IN tcn_rec_type,
43: x_no_data_found OUT NOCOPY BOOLEAN

Line 45: CURSOR okl_trx_contracts_pk_csr (p_id IN NUMBER) IS

41: FUNCTION get_rec (
42: p_tcn_rec IN tcn_rec_type,
43: x_no_data_found OUT NOCOPY BOOLEAN
44: ) RETURN tcn_rec_type IS
45: CURSOR okl_trx_contracts_pk_csr (p_id IN NUMBER) IS
46: SELECT
47: ID,
48: KHR_ID_NEW,
49: PVN_ID,

Line 157: FROM OKL_TRX_CONTRACTS

153: primary_rep_trx_id,
154: REPRESENTATION_TYPE,
155: -- Added by sosharma for Income Account recon-report 01-Nov-2008
156: TRANSACTION_REVERSAL_DATE
157: FROM OKL_TRX_CONTRACTS
158: WHERE OKL_TRX_CONTRACTS.id = p_id;
159: l_okl_trx_contracts_pk okl_trx_contracts_pk_csr%ROWTYPE;
160: l_tcn_rec tcn_rec_type;
161: BEGIN

Line 158: WHERE OKL_TRX_CONTRACTS.id = p_id;

154: REPRESENTATION_TYPE,
155: -- Added by sosharma for Income Account recon-report 01-Nov-2008
156: TRANSACTION_REVERSAL_DATE
157: FROM OKL_TRX_CONTRACTS
158: WHERE OKL_TRX_CONTRACTS.id = p_id;
159: l_okl_trx_contracts_pk okl_trx_contracts_pk_csr%ROWTYPE;
160: l_tcn_rec tcn_rec_type;
161: BEGIN
162: x_no_data_found := TRUE;

Line 159: l_okl_trx_contracts_pk okl_trx_contracts_pk_csr%ROWTYPE;

155: -- Added by sosharma for Income Account recon-report 01-Nov-2008
156: TRANSACTION_REVERSAL_DATE
157: FROM OKL_TRX_CONTRACTS
158: WHERE OKL_TRX_CONTRACTS.id = p_id;
159: l_okl_trx_contracts_pk okl_trx_contracts_pk_csr%ROWTYPE;
160: l_tcn_rec tcn_rec_type;
161: BEGIN
162: x_no_data_found := TRUE;
163: -- Get current database values

Line 164: OPEN okl_trx_contracts_pk_csr (p_tcn_rec.id);

160: l_tcn_rec tcn_rec_type;
161: BEGIN
162: x_no_data_found := TRUE;
163: -- Get current database values
164: OPEN okl_trx_contracts_pk_csr (p_tcn_rec.id);
165: FETCH okl_trx_contracts_pk_csr INTO
166: l_tcn_rec.ID,
167: l_tcn_rec.KHR_ID_NEW,
168: l_tcn_rec.PVN_ID,

Line 165: FETCH okl_trx_contracts_pk_csr INTO

161: BEGIN
162: x_no_data_found := TRUE;
163: -- Get current database values
164: OPEN okl_trx_contracts_pk_csr (p_tcn_rec.id);
165: FETCH okl_trx_contracts_pk_csr INTO
166: l_tcn_rec.ID,
167: l_tcn_rec.KHR_ID_NEW,
168: l_tcn_rec.PVN_ID,
169: l_tcn_rec.PDT_ID,

Line 277: x_no_data_found := okl_trx_contracts_pk_csr%NOTFOUND;

273: l_tcn_rec.REPRESENTATION_TYPE,
274: -- Added by sosharma for Income Account recon- report 01-Nov-2008
275: l_tcn_rec.TRANSACTION_REVERSAL_DATE;
276:
277: x_no_data_found := okl_trx_contracts_pk_csr%NOTFOUND;
278: CLOSE okl_trx_contracts_pk_csr;
279: RETURN(l_tcn_rec);
280: END get_rec;
281:

Line 278: CLOSE okl_trx_contracts_pk_csr;

274: -- Added by sosharma for Income Account recon- report 01-Nov-2008
275: l_tcn_rec.TRANSACTION_REVERSAL_DATE;
276:
277: x_no_data_found := okl_trx_contracts_pk_csr%NOTFOUND;
278: CLOSE okl_trx_contracts_pk_csr;
279: RETURN(l_tcn_rec);
280: END get_rec;
281:
282: FUNCTION get_rec (

Line 290: -- FUNCTION get_rec for: OKL_TRX_CONTRACTS_V

286: BEGIN
287: RETURN(get_rec(p_tcn_rec, l_row_notfound));
288: END get_rec;
289: ---------------------------------------------------------------------------
290: -- FUNCTION get_rec for: OKL_TRX_CONTRACTS_V
291: ---------------------------------------------------------------------------
292: FUNCTION get_rec (
293: p_tcnv_rec IN tcnv_rec_type,
294: x_no_data_found OUT NOCOPY BOOLEAN

Line 408: FROM OKL_TRX_CONTRACTS

404: primary_rep_trx_id,
405: REPRESENTATION_TYPE,
406: -- Added by sosharma for Income Account recon- report 01-Nov-2008
407: TRANSACTION_REVERSAL_DATE
408: FROM OKL_TRX_CONTRACTS
409: WHERE OKL_TRX_CONTRACTS.id = p_id;
410: l_okl_tcnv_pk okl_tcnv_pk_csr%ROWTYPE;
411: l_tcnv_rec tcnv_rec_type;
412: BEGIN

Line 409: WHERE OKL_TRX_CONTRACTS.id = p_id;

405: REPRESENTATION_TYPE,
406: -- Added by sosharma for Income Account recon- report 01-Nov-2008
407: TRANSACTION_REVERSAL_DATE
408: FROM OKL_TRX_CONTRACTS
409: WHERE OKL_TRX_CONTRACTS.id = p_id;
410: l_okl_tcnv_pk okl_tcnv_pk_csr%ROWTYPE;
411: l_tcnv_rec tcnv_rec_type;
412: BEGIN
413: x_no_data_found := TRUE;

Line 540: -- FUNCTION null_out_defaults for: OKL_TRX_CONTRACTS_V --

536: RETURN(get_rec(p_tcnv_rec, l_row_notfound));
537: END get_rec;
538:
539: ---------------------------------------------------------
540: -- FUNCTION null_out_defaults for: OKL_TRX_CONTRACTS_V --
541: ---------------------------------------------------------
542: FUNCTION null_out_defaults (
543: p_tcnv_rec IN tcnv_rec_type
544: ) RETURN tcnv_rec_type IS

Line 877: -- Validate_Attributes for:OKL_TRX_CONTRACTS_V --

873: ---------------------------------------------------------------------------
874: -- PROCEDURE Validate_Attributes
875: ---------------------------------------------------------------------------
876: -------------------------------------------------
877: -- Validate_Attributes for:OKL_TRX_CONTRACTS_V --
878: -------------------------------------------------
879: FUNCTION Validate_Attributes (
880: p_tcnv_rec IN tcnv_rec_type
881: ) RETURN VARCHAR2 IS

Line 907: -- Validate_Record for:OKL_TRX_CONTRACTS_V --

903: ---------------------------------------------------------------------------
904: -- PROCEDURE Validate_Record
905: ---------------------------------------------------------------------------
906: ---------------------------------------------
907: -- Validate_Record for:OKL_TRX_CONTRACTS_V --
908: ---------------------------------------------
909: FUNCTION Validate_Record (
910: p_tcnv_rec IN tcnv_rec_type
911: ) RETURN VARCHAR2 IS

Line 2606: l_trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE;

2602: PROCEDURE Validate_Trx_number (p_tcnv_rec IN tcnv_rec_type
2603: ,x_return_status OUT NOCOPY VARCHAR2)
2604: IS
2605: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2606: l_trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE;
2607:
2608: CURSOR tcn_csr(v_trx_number VARCHAR2,
2609: v_id NUMBER, v_rep_code VARCHAR2) IS
2610: SELECT trx_number

Line 2611: FROM OKL_TRX_CONTRACTS

2607:
2608: CURSOR tcn_csr(v_trx_number VARCHAR2,
2609: v_id NUMBER, v_rep_code VARCHAR2) IS
2610: SELECT trx_number
2611: FROM OKL_TRX_CONTRACTS
2612: WHERE trx_number = v_trx_number
2613: and representation_code = v_rep_code
2614: AND id <> v_id;
2615:

Line 3093: FROM okl_trx_contracts otc

3089:
3090:
3091: CURSOR okl_tcn_csr (p_source_id IN NUMBER) IS
3092: SELECT '1'
3093: FROM okl_trx_contracts otc
3094: WHERE otc.id = p_source_id;
3095:
3096: CURSOR okl_tas_csr (p_source_id IN NUMBER) IS
3097: SELECT '1'

Line 3405: FROM okl_trx_contracts

3401: item_not_found_error EXCEPTION;
3402:
3403: CURSOR okl_tcn_id_csr (p_id IN NUMBER, p_chr_id IN NUMBER) IS
3404: SELECT '1'
3405: FROM okl_trx_contracts
3406: WHERE okl_trx_contracts.id = p_id
3407: AND okl_trx_contracts.primary_rep_trx_id is null
3408: and okl_trx_contracts.khr_id = p_chr_id;
3409:

Line 3406: WHERE okl_trx_contracts.id = p_id

3402:
3403: CURSOR okl_tcn_id_csr (p_id IN NUMBER, p_chr_id IN NUMBER) IS
3404: SELECT '1'
3405: FROM okl_trx_contracts
3406: WHERE okl_trx_contracts.id = p_id
3407: AND okl_trx_contracts.primary_rep_trx_id is null
3408: and okl_trx_contracts.khr_id = p_chr_id;
3409:
3410: BEGIN

Line 3407: AND okl_trx_contracts.primary_rep_trx_id is null

3403: CURSOR okl_tcn_id_csr (p_id IN NUMBER, p_chr_id IN NUMBER) IS
3404: SELECT '1'
3405: FROM okl_trx_contracts
3406: WHERE okl_trx_contracts.id = p_id
3407: AND okl_trx_contracts.primary_rep_trx_id is null
3408: and okl_trx_contracts.khr_id = p_chr_id;
3409:
3410: BEGIN
3411:

Line 3408: and okl_trx_contracts.khr_id = p_chr_id;

3404: SELECT '1'
3405: FROM okl_trx_contracts
3406: WHERE okl_trx_contracts.id = p_id
3407: AND okl_trx_contracts.primary_rep_trx_id is null
3408: and okl_trx_contracts.khr_id = p_chr_id;
3409:
3410: BEGIN
3411:
3412: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

Line 4422: -- validate_row for:OKL_TRX_CONTRACTS_V --

4418: ---------------------------------------------------------------------------
4419: -- PROCEDURE validate_row
4420: ---------------------------------------------------------------------------
4421: ------------------------------------------
4422: -- validate_row for:OKL_TRX_CONTRACTS_V --
4423: ------------------------------------------
4424: PROCEDURE validate_row(
4425: p_api_version IN NUMBER,
4426: p_init_msg_list IN VARCHAR2,

Line 4579: -- insert_row for:OKL_TRX_CONTRACTS --

4575: ---------------------------------------------------------------------------
4576: -- PROCEDURE insert_row
4577: ---------------------------------------------------------------------------
4578: --------------------------------------
4579: -- insert_row for:OKL_TRX_CONTRACTS --
4580: --------------------------------------
4581: PROCEDURE insert_row(
4582: p_init_msg_list IN VARCHAR2,
4583: x_return_status OUT NOCOPY VARCHAR2,

Line 4595: -- Set_Attributes for:OKL_TRX_CONTRACTS --

4591: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
4592: l_tcn_rec tcn_rec_type := p_tcn_rec;
4593: l_def_tcn_rec tcn_rec_type;
4594: ------------------------------------------
4595: -- Set_Attributes for:OKL_TRX_CONTRACTS --
4596: ------------------------------------------
4597: FUNCTION Set_Attributes (
4598: p_tcn_rec IN tcn_rec_type,
4599: x_tcn_rec OUT NOCOPY tcn_rec_type

Line 4626: INSERT INTO OKL_TRX_CONTRACTS(

4622: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
4623: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
4624: RAISE Okc_Api.G_EXCEPTION_ERROR;
4625: END IF;
4626: INSERT INTO OKL_TRX_CONTRACTS(
4627: id,
4628: khr_id_new,
4629: pvn_id,
4630: pdt_id,

Line 4887: -- insert_row for:OKL_TRX_CONTRACTS_V --

4883: '_PVT'
4884: );
4885: END insert_row;
4886: ----------------------------------------
4887: -- insert_row for:OKL_TRX_CONTRACTS_V --
4888: ----------------------------------------
4889: PROCEDURE insert_row(
4890: p_api_version IN NUMBER,
4891: p_init_msg_list IN VARCHAR2,

Line 4927: -- Set_Attributes for:OKL_TRX_CONTRACTS_V --

4923:
4924: RETURN(l_tcnv_rec);
4925: END fill_who_columns;
4926: --------------------------------------------
4927: -- Set_Attributes for:OKL_TRX_CONTRACTS_V --
4928: --------------------------------------------
4929: FUNCTION Set_Attributes (
4930: p_tcnv_rec IN tcnv_rec_type,
4931: x_tcnv_rec OUT NOCOPY tcnv_rec_type

Line 4954: -- The derivation for the column is moved to OKL_TRX_CONTRACTS_PVT which in turn is

4950: ,x_tcnv_rec.PROGRAM_ID
4951: ,x_tcnv_rec.PROGRAM_UPDATE_DATE
4952: FROM DUAL;
4953: -- Commented by zrehman for SLA project (Bug 5707866) 21-Feb-2007
4954: -- The derivation for the column is moved to OKL_TRX_CONTRACTS_PVT which in turn is
4955: -- used to derive representation_name and representation_code
4956: -- start
4957: -- x_tcnv_rec.set_of_books_id := okl_accounting_util.get_set_of_books_id;
4958: -- end

Line 5161: -- lock_row for:OKL_TRX_CONTRACTS --

5157: ---------------------------------------------------------------------------
5158: -- PROCEDURE lock_row
5159: ---------------------------------------------------------------------------
5160: ------------------------------------
5161: -- lock_row for:OKL_TRX_CONTRACTS --
5162: ------------------------------------
5163: PROCEDURE lock_row(
5164: p_init_msg_list IN VARCHAR2,
5165: x_return_status OUT NOCOPY VARCHAR2,

Line 5174: FROM OKL_TRX_CONTRACTS

5170: E_Resource_Busy EXCEPTION;
5171: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
5172: CURSOR lock_csr (p_tcn_rec IN tcn_rec_type) IS
5173: SELECT OBJECT_VERSION_NUMBER
5174: FROM OKL_TRX_CONTRACTS
5175: WHERE ID = p_tcn_rec.id
5176: AND OBJECT_VERSION_NUMBER = p_tcn_rec.object_version_number
5177: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
5178:

Line 5181: FROM OKL_TRX_CONTRACTS

5177: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
5178:
5179: CURSOR lchk_csr (p_tcn_rec IN tcn_rec_type) IS
5180: SELECT OBJECT_VERSION_NUMBER
5181: FROM OKL_TRX_CONTRACTS
5182: WHERE ID = p_tcn_rec.id;
5183: l_api_version CONSTANT NUMBER := 1;
5184: l_api_name CONSTANT VARCHAR2(30) := 'CONTRACTS_lock_row';
5185: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 5186: l_object_version_number OKL_TRX_CONTRACTS.OBJECT_VERSION_NUMBER%TYPE;

5182: WHERE ID = p_tcn_rec.id;
5183: l_api_version CONSTANT NUMBER := 1;
5184: l_api_name CONSTANT VARCHAR2(30) := 'CONTRACTS_lock_row';
5185: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
5186: l_object_version_number OKL_TRX_CONTRACTS.OBJECT_VERSION_NUMBER%TYPE;
5187: lc_object_version_number OKL_TRX_CONTRACTS.OBJECT_VERSION_NUMBER%TYPE;
5188: l_row_notfound BOOLEAN := FALSE;
5189: lc_row_notfound BOOLEAN := FALSE;
5190: BEGIN

Line 5187: lc_object_version_number OKL_TRX_CONTRACTS.OBJECT_VERSION_NUMBER%TYPE;

5183: l_api_version CONSTANT NUMBER := 1;
5184: l_api_name CONSTANT VARCHAR2(30) := 'CONTRACTS_lock_row';
5185: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
5186: l_object_version_number OKL_TRX_CONTRACTS.OBJECT_VERSION_NUMBER%TYPE;
5187: lc_object_version_number OKL_TRX_CONTRACTS.OBJECT_VERSION_NUMBER%TYPE;
5188: l_row_notfound BOOLEAN := FALSE;
5189: lc_row_notfound BOOLEAN := FALSE;
5190: BEGIN
5191: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

Line 5267: -- lock_row for:OKL_TRX_CONTRACTS_V --

5263: '_PVT'
5264: );
5265: END lock_row;
5266: --------------------------------------
5267: -- lock_row for:OKL_TRX_CONTRACTS_V --
5268: --------------------------------------
5269: PROCEDURE lock_row(
5270: p_api_version IN NUMBER,
5271: p_init_msg_list IN VARCHAR2,

Line 5428: -- update_row for:OKL_TRX_CONTRACTS --

5424: ---------------------------------------------------------------------------
5425: -- PROCEDURE update_row
5426: ---------------------------------------------------------------------------
5427: --------------------------------------
5428: -- update_row for:OKL_TRX_CONTRACTS --
5429: --------------------------------------
5430: PROCEDURE update_row(
5431: p_init_msg_list IN VARCHAR2,
5432: x_return_status OUT NOCOPY VARCHAR2,

Line 5880: -- Set_Attributes for:OKL_TRX_CONTRACTS --

5876: RETURN(l_return_status);
5877:
5878: END populate_new_record;
5879: ------------------------------------------
5880: -- Set_Attributes for:OKL_TRX_CONTRACTS --
5881: ------------------------------------------
5882: FUNCTION Set_Attributes (
5883: p_tcn_rec IN tcn_rec_type,
5884: x_tcn_rec OUT NOCOPY tcn_rec_type

Line 5918: UPDATE OKL_TRX_CONTRACTS

5914: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
5915: RAISE Okc_Api.G_EXCEPTION_ERROR;
5916: END IF;
5917:
5918: UPDATE OKL_TRX_CONTRACTS
5919: SET KHR_ID_NEW = l_def_tcn_rec.khr_id_new,
5920: PVN_ID = l_def_tcn_rec.pvn_id,
5921: PDT_ID = l_def_tcn_rec.pdt_id,
5922: RBR_CODE = l_def_tcn_rec.rbr_code,

Line 6065: -- update_row for:OKL_TRX_CONTRACTS_V --

6061: '_PVT'
6062: );
6063: END update_row;
6064: ----------------------------------------
6065: -- update_row for:OKL_TRX_CONTRACTS_V --
6066: ----------------------------------------
6067: PROCEDURE update_row(
6068: p_api_version IN NUMBER,
6069: p_init_msg_list IN VARCHAR2,

Line 6507: -- Set_Attributes for:OKL_TRX_CONTRACTS_V --

6503:
6504: RETURN(l_return_status);
6505: END populate_new_record;
6506: --------------------------------------------
6507: -- Set_Attributes for:OKL_TRX_CONTRACTS_V --
6508: --------------------------------------------
6509: FUNCTION Set_Attributes (
6510: p_tcnv_rec IN tcnv_rec_type,
6511: x_tcnv_rec OUT NOCOPY tcnv_rec_type

Line 6718: -- delete_row for:OKL_TRX_CONTRACTS --

6714: ---------------------------------------------------------------------------
6715: -- PROCEDURE delete_row
6716: ---------------------------------------------------------------------------
6717: --------------------------------------
6718: -- delete_row for:OKL_TRX_CONTRACTS --
6719: --------------------------------------
6720: PROCEDURE delete_row(
6721: p_init_msg_list IN VARCHAR2,
6722: x_return_status OUT NOCOPY VARCHAR2,

Line 6742: DELETE FROM OKL_TRX_CONTRACTS

6738: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
6739: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
6740: RAISE Okc_Api.G_EXCEPTION_ERROR;
6741: END IF;
6742: DELETE FROM OKL_TRX_CONTRACTS
6743: WHERE ID = l_tcn_rec.id;
6744:
6745: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
6746: EXCEPTION

Line 6779: -- delete_row for:OKL_TRX_CONTRACTS_V --

6775: '_PVT'
6776: );
6777: END delete_row;
6778: ----------------------------------------
6779: -- delete_row for:OKL_TRX_CONTRACTS_V --
6780: ----------------------------------------
6781: PROCEDURE delete_row(
6782: p_api_version IN NUMBER,
6783: p_init_msg_list IN VARCHAR2,