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_COPY_CONTRACT_PVT dependencies on OKC_K_HEADERS_B

Line 2558: l_chr_id OKC_K_HEADERS_B.ID%TYPE;

2554: AND cle.dnz_chr_id = p_copied_chr_id;
2555:
2556: l_cle_id OKC_K_LINES_B.ID%TYPE;
2557: l_source_cle_id OKC_K_LINES_B.ID%TYPE;
2558: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
2559:
2560: Begin
2561: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2562: l_chr_id := p_chr_id;

Line 2656: l_chr_id OKC_K_HEADERS_B.ID%TYPE;

2652: AND cle.dnz_chr_id = p_copied_chr_id;
2653:
2654: l_cle_id OKC_K_LINES_B.ID%TYPE;
2655: l_source_cle_id OKC_K_LINES_B.ID%TYPE;
2656: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
2657:
2658: Begin
2659: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2660: l_chr_id := p_chr_id;

Line 3415: l_new_chr_id okc_k_headers_b.id%type;

3411:
3412: -- end furong 4350255
3413:
3414: --Bug# 4899328
3415: l_new_chr_id okc_k_headers_b.id%type;
3416: Begin
3417: ------
3418: -- call START_ACTIVITY to create savepoint, check compatibility
3419: -- and initialize message list

Line 5225: l_serv_contract_id okc_k_headers_b.id%TYPE;

5221: l_message VARCHAR2(30) ;
5222: l_new_mapping_id NUMBER;
5223: l_hstv_rec okc_k_history_pvt.hstv_rec_type;
5224: x_hstv_rec okc_k_history_pvt.hstv_rec_type;
5225: l_serv_contract_id okc_k_headers_b.id%TYPE;
5226: l_service_top_line_id okc_k_lines_b.id%TYPE;
5227: l_deal_type okl_k_headers.deal_type%TYPE;
5228: l_queried BOOLEAN := FALSE;
5229: l_line_style okc_k_lines_b.lse_id%TYPE;

Line 5240: l_contract_number okc_k_headers_b.contract_number%TYPE;

5236: l_event_name wf_events.name%TYPE := NULL;
5237: l_raise_business_event VARCHAR2(1) := OKL_API.G_FALSE;
5238: l_business_event_name wf_events.name%TYPE := NULL;
5239:
5240: l_contract_number okc_k_headers_b.contract_number%TYPE;
5241: l_copied_id NUMBER;
5242: l_gov_id NUMBER;
5243: l_capital_amount NUMBER;
5244: l_contract_currency okc_k_headers_b.currency_code%TYPE;

Line 5244: l_contract_currency okc_k_headers_b.currency_code%TYPE;

5240: l_contract_number okc_k_headers_b.contract_number%TYPE;
5241: l_copied_id NUMBER;
5242: l_gov_id NUMBER;
5243: l_capital_amount NUMBER;
5244: l_contract_currency okc_k_headers_b.currency_code%TYPE;
5245: l_contract_start_date okc_k_headers_b.start_date%TYPE;
5246: l_conversion_type okc_k_headers_b.CONVERSION_TYPE%TYPE;
5247: l_conversion_rate okc_k_headers_b.CONVERSION_RATE%TYPE;
5248: l_conversion_rate_date okc_k_headers_b.CONVERSION_RATE_DATE%TYPE;

Line 5245: l_contract_start_date okc_k_headers_b.start_date%TYPE;

5241: l_copied_id NUMBER;
5242: l_gov_id NUMBER;
5243: l_capital_amount NUMBER;
5244: l_contract_currency okc_k_headers_b.currency_code%TYPE;
5245: l_contract_start_date okc_k_headers_b.start_date%TYPE;
5246: l_conversion_type okc_k_headers_b.CONVERSION_TYPE%TYPE;
5247: l_conversion_rate okc_k_headers_b.CONVERSION_RATE%TYPE;
5248: l_conversion_rate_date okc_k_headers_b.CONVERSION_RATE_DATE%TYPE;
5249: l_template_yn okc_k_headers_b.TEMPLATE_YN%TYPE;

Line 5246: l_conversion_type okc_k_headers_b.CONVERSION_TYPE%TYPE;

5242: l_gov_id NUMBER;
5243: l_capital_amount NUMBER;
5244: l_contract_currency okc_k_headers_b.currency_code%TYPE;
5245: l_contract_start_date okc_k_headers_b.start_date%TYPE;
5246: l_conversion_type okc_k_headers_b.CONVERSION_TYPE%TYPE;
5247: l_conversion_rate okc_k_headers_b.CONVERSION_RATE%TYPE;
5248: l_conversion_rate_date okc_k_headers_b.CONVERSION_RATE_DATE%TYPE;
5249: l_template_yn okc_k_headers_b.TEMPLATE_YN%TYPE;
5250: l_trx_assets_counter4 NUMBER := 1;

Line 5247: l_conversion_rate okc_k_headers_b.CONVERSION_RATE%TYPE;

5243: l_capital_amount NUMBER;
5244: l_contract_currency okc_k_headers_b.currency_code%TYPE;
5245: l_contract_start_date okc_k_headers_b.start_date%TYPE;
5246: l_conversion_type okc_k_headers_b.CONVERSION_TYPE%TYPE;
5247: l_conversion_rate okc_k_headers_b.CONVERSION_RATE%TYPE;
5248: l_conversion_rate_date okc_k_headers_b.CONVERSION_RATE_DATE%TYPE;
5249: l_template_yn okc_k_headers_b.TEMPLATE_YN%TYPE;
5250: l_trx_assets_counter4 NUMBER := 1;
5251: l_tal_to_kle_counter NUMBER := 1;

Line 5248: l_conversion_rate_date okc_k_headers_b.CONVERSION_RATE_DATE%TYPE;

5244: l_contract_currency okc_k_headers_b.currency_code%TYPE;
5245: l_contract_start_date okc_k_headers_b.start_date%TYPE;
5246: l_conversion_type okc_k_headers_b.CONVERSION_TYPE%TYPE;
5247: l_conversion_rate okc_k_headers_b.CONVERSION_RATE%TYPE;
5248: l_conversion_rate_date okc_k_headers_b.CONVERSION_RATE_DATE%TYPE;
5249: l_template_yn okc_k_headers_b.TEMPLATE_YN%TYPE;
5250: l_trx_assets_counter4 NUMBER := 1;
5251: l_tal_to_kle_counter NUMBER := 1;
5252: l_trx_assets_counter6 NUMBER := 1;

Line 5249: l_template_yn okc_k_headers_b.TEMPLATE_YN%TYPE;

5245: l_contract_start_date okc_k_headers_b.start_date%TYPE;
5246: l_conversion_type okc_k_headers_b.CONVERSION_TYPE%TYPE;
5247: l_conversion_rate okc_k_headers_b.CONVERSION_RATE%TYPE;
5248: l_conversion_rate_date okc_k_headers_b.CONVERSION_RATE_DATE%TYPE;
5249: l_template_yn okc_k_headers_b.TEMPLATE_YN%TYPE;
5250: l_trx_assets_counter4 NUMBER := 1;
5251: l_tal_to_kle_counter NUMBER := 1;
5252: l_trx_assets_counter6 NUMBER := 1;
5253: l_okl_k_lines_counter NUMBER := 1;

Line 5256: SELECT * FROM okc_k_headers_b

5252: l_trx_assets_counter6 NUMBER := 1;
5253: l_okl_k_lines_counter NUMBER := 1;
5254: l_try_id NUMBER;
5255: CURSOR c1(p_chr_id NUMBER) IS
5256: SELECT * FROM okc_k_headers_b
5257: WHERE id=p_chr_id;
5258:
5259: CURSOR c2(p_chr_id NUMBER) IS
5260: SELECT * FROM okc_governances

Line 5321: FROM OKC_K_HEADERS_B

5317:
5318: -- Bug 4738057
5319: CURSOR contract_exists_csr(p_contract_number IN VARCHAR2) IS
5320: SELECT ID
5321: FROM OKC_K_HEADERS_B
5322: WHERE CONTRACT_NUMBER = p_contract_number;
5323:
5324: TYPE l_subsidy_id_type IS TABLE OF okl_k_lines.subsidy_id%TYPE INDEX BY BINARY_INTEGER;
5325:

Line 7223: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;

7219: l_party_counter NUMBER := 1;
7220: l_prid_tab l_prid_type;
7221: l_probject1_id1_tab l_probject1_id1_type;
7222:
7223: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;
7224: l_sts_code okc_k_headers_b.sts_code%TYPE;
7225: l_sts_code_orig okc_k_headers_b.sts_code%TYPE;
7226:
7227: PROCEDURE validate_currency_code(

Line 7224: l_sts_code okc_k_headers_b.sts_code%TYPE;

7220: l_prid_tab l_prid_type;
7221: l_probject1_id1_tab l_probject1_id1_type;
7222:
7223: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;
7224: l_sts_code okc_k_headers_b.sts_code%TYPE;
7225: l_sts_code_orig okc_k_headers_b.sts_code%TYPE;
7226:
7227: PROCEDURE validate_currency_code(
7228: x_return_status OUT NOCOPY VARCHAR2,

Line 7225: l_sts_code_orig okc_k_headers_b.sts_code%TYPE;

7221: l_probject1_id1_tab l_probject1_id1_type;
7222:
7223: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;
7224: l_sts_code okc_k_headers_b.sts_code%TYPE;
7225: l_sts_code_orig okc_k_headers_b.sts_code%TYPE;
7226:
7227: PROCEDURE validate_currency_code(
7228: x_return_status OUT NOCOPY VARCHAR2,
7229: p_ccy_code IN okc_k_headers_b.currency_code%TYPE) IS

Line 7229: p_ccy_code IN okc_k_headers_b.currency_code%TYPE) IS

7225: l_sts_code_orig okc_k_headers_b.sts_code%TYPE;
7226:
7227: PROCEDURE validate_currency_code(
7228: x_return_status OUT NOCOPY VARCHAR2,
7229: p_ccy_code IN okc_k_headers_b.currency_code%TYPE) IS
7230:
7231: l_dummy_var VARCHAR2(1) := '?';
7232: CURSOR l_fndv_csr IS
7233: SELECT 'x'

Line 7308: p_orig_system_source_code IN okc_k_headers_b.orig_system_source_code%TYPE

7304: END validate_currency_code;
7305:
7306: PROCEDURE validate_orig_sys_code
7307: (x_return_status OUT NOCOPY VARCHAR2,
7308: p_orig_system_source_code IN okc_k_headers_b.orig_system_source_code%TYPE
7309: ) IS
7310: BEGIN
7311:
7312:

Line 7355: p_currency_conversion_type IN okc_k_headers_b.conversion_type%TYPE) IS

7351: END validate_orig_sys_code;
7352:
7353: PROCEDURE validate_currency_conv_type
7354: (x_return_status OUT NOCOPY VARCHAR2,
7355: p_currency_conversion_type IN okc_k_headers_b.conversion_type%TYPE) IS
7356:
7357: --cursor to chk currency type fk
7358: CURSOR curr_conv_type_csr (p_curr_cotyp IN VARCHAR2) IS
7359: SELECT '!'

Line 12790: PROCEDURE insert_okc_k_party_roles(p_old_id IN okc_k_headers_b.id%TYPE,

12786: RAISE OKC_API.G_EXCEPTION_ERROR;
12787:
12788: END; /* sort_vid_mapping_tab */
12789:
12790: PROCEDURE insert_okc_k_party_roles(p_old_id IN okc_k_headers_b.id%TYPE,
12791: p_new_id IN okc_k_headers_b.id%TYPE) IS
12792: CURSOR c9(p_id okc_k_party_roles_b.dnz_chr_id%TYPE) IS
12793: SELECT
12794: id, chr_id, cle_id,

Line 12791: p_new_id IN okc_k_headers_b.id%TYPE) IS

12787:
12788: END; /* sort_vid_mapping_tab */
12789:
12790: PROCEDURE insert_okc_k_party_roles(p_old_id IN okc_k_headers_b.id%TYPE,
12791: p_new_id IN okc_k_headers_b.id%TYPE) IS
12792: CURSOR c9(p_id okc_k_party_roles_b.dnz_chr_id%TYPE) IS
12793: SELECT
12794: id, chr_id, cle_id,
12795: dnz_chr_id, rle_code, object1_id1,

Line 14416: PROCEDURE insert_okc_rule_groups (p_old_id IN okc_k_headers_b.id%TYPE,

14412: RAISE OKC_API.G_EXCEPTION_ERROR;
14413:
14414: END; /* sort_tid_mapping_tab */
14415:
14416: PROCEDURE insert_okc_rule_groups (p_old_id IN okc_k_headers_b.id%TYPE,
14417: p_new_id IN okc_k_headers_b.id%TYPE) IS
14418: CURSOR c12(p_id NUMBER) IS
14419: SELECT
14420: id, rgd_code, chr_id,

Line 14417: p_new_id IN okc_k_headers_b.id%TYPE) IS

14413:
14414: END; /* sort_tid_mapping_tab */
14415:
14416: PROCEDURE insert_okc_rule_groups (p_old_id IN okc_k_headers_b.id%TYPE,
14417: p_new_id IN okc_k_headers_b.id%TYPE) IS
14418: CURSOR c12(p_id NUMBER) IS
14419: SELECT
14420: id, rgd_code, chr_id,
14421: cle_id, dnz_chr_id, parent_rgp_id,

Line 15042: PROCEDURE insert_okc_k_items (p_old_id IN okc_k_headers_b.id%TYPE,

15038: END; /* sort_okc_k_items_rec */
15039:
15040:
15041:
15042: PROCEDURE insert_okc_k_items (p_old_id IN okc_k_headers_b.id%TYPE,
15043: p_new_id IN okc_k_headers_b.id%TYPE) IS
15044: CURSOR c16(p_id NUMBER) IS
15045: SELECT
15046: a.id, a.cle_id, a.chr_id,

Line 15043: p_new_id IN okc_k_headers_b.id%TYPE) IS

15039:
15040:
15041:
15042: PROCEDURE insert_okc_k_items (p_old_id IN okc_k_headers_b.id%TYPE,
15043: p_new_id IN okc_k_headers_b.id%TYPE) IS
15044: CURSOR c16(p_id NUMBER) IS
15045: SELECT
15046: a.id, a.cle_id, a.chr_id,
15047: a.cle_id_for, a.dnz_chr_id, a.object1_id1,

Line 15877: PROCEDURE insert_okl_txd_assets_tl(p_old_id IN okc_k_headers_b.id%TYPE,

15873: RAISE OKC_API.G_EXCEPTION_ERROR;
15874:
15875: END; /* insert_okl_txl_assets_tl */
15876:
15877: PROCEDURE insert_okl_txd_assets_tl(p_old_id IN okc_k_headers_b.id%TYPE,
15878: p_new_id IN okc_k_headers_b.id%TYPE,
15879: p_flush IN VARCHAR2) IS
15880: CURSOR c21(p_id NUMBER) IS
15881: SELECT

Line 15878: p_new_id IN okc_k_headers_b.id%TYPE,

15874:
15875: END; /* insert_okl_txl_assets_tl */
15876:
15877: PROCEDURE insert_okl_txd_assets_tl(p_old_id IN okc_k_headers_b.id%TYPE,
15878: p_new_id IN okc_k_headers_b.id%TYPE,
15879: p_flush IN VARCHAR2) IS
15880: CURSOR c21(p_id NUMBER) IS
15881: SELECT
15882: id, LANGUAGE, source_lang,

Line 15989: PROCEDURE insert_okl_txd_assets_b(p_old_id IN okc_k_headers_b.id%TYPE,

15985: RAISE OKC_API.G_EXCEPTION_ERROR;
15986:
15987: END; /* insert_okl_txd_assets_tl */
15988:
15989: PROCEDURE insert_okl_txd_assets_b(p_old_id IN okc_k_headers_b.id%TYPE,
15990: p_new_id IN okc_k_headers_b.id%TYPE) IS
15991: CURSOR c20(p_id NUMBER) IS
15992: SELECT
15993: id, object_version_number, tal_id,

Line 15990: p_new_id IN okc_k_headers_b.id%TYPE) IS

15986:
15987: END; /* insert_okl_txd_assets_tl */
15988:
15989: PROCEDURE insert_okl_txd_assets_b(p_old_id IN okc_k_headers_b.id%TYPE,
15990: p_new_id IN okc_k_headers_b.id%TYPE) IS
15991: CURSOR c20(p_id NUMBER) IS
15992: SELECT
15993: id, object_version_number, tal_id,
15994: target_kle_id, line_detail_number, asset_number,

Line 16426: PROCEDURE insert_okl_txl_assets_b(p_old_id IN okc_k_headers_b.id%TYPE,

16422: RAISE OKC_API.G_EXCEPTION_ERROR;
16423:
16424: END; /* sort_dbid_mapping_tab */
16425:
16426: PROCEDURE insert_okl_txl_assets_b(p_old_id IN okc_k_headers_b.id%TYPE,
16427: p_new_id IN okc_k_headers_b.id%TYPE) IS
16428: CURSOR c18(p_id NUMBER) IS
16429: SELECT
16430: a.id, a.object_version_number, a.tas_id,

Line 16427: p_new_id IN okc_k_headers_b.id%TYPE) IS

16423:
16424: END; /* sort_dbid_mapping_tab */
16425:
16426: PROCEDURE insert_okl_txl_assets_b(p_old_id IN okc_k_headers_b.id%TYPE,
16427: p_new_id IN okc_k_headers_b.id%TYPE) IS
16428: CURSOR c18(p_id NUMBER) IS
16429: SELECT
16430: a.id, a.object_version_number, a.tas_id,
16431: a.ilo_id, a.ilo_id_old, a.iay_id,

Line 16896: PROCEDURE insert_okl_trx_assets(p_old_id IN okc_k_headers_b.id%TYPE,

16892: RAISE OKC_API.G_EXCEPTION_ERROR;
16893:
16894: END; /* insert_okl_txl_assets_b */
16895:
16896: PROCEDURE insert_okl_trx_assets(p_old_id IN okc_k_headers_b.id%TYPE,
16897: p_new_id IN okc_k_headers_b.id%TYPE) IS
16898: CURSOR c17(p_id NUMBER) IS
16899: SELECT
16900: id, ica_id, tas_type,

Line 16897: p_new_id IN okc_k_headers_b.id%TYPE) IS

16893:
16894: END; /* insert_okl_txl_assets_b */
16895:
16896: PROCEDURE insert_okl_trx_assets(p_old_id IN okc_k_headers_b.id%TYPE,
16897: p_new_id IN okc_k_headers_b.id%TYPE) IS
16898: CURSOR c17(p_id NUMBER) IS
16899: SELECT
16900: id, ica_id, tas_type,
16901: object_version_number, attribute_category, attribute1,

Line 17118: PROCEDURE insert_okl_trx_assets_2(p_old_id IN okc_k_headers_b.id%TYPE,

17114: RAISE OKC_API.G_EXCEPTION_ERROR;
17115:
17116: END; /* insert_okl_trx_assets */
17117:
17118: PROCEDURE insert_okl_trx_assets_2(p_old_id IN okc_k_headers_b.id%TYPE,
17119: p_new_id IN okc_k_headers_b.id%TYPE) IS
17120: CURSOR c17_2(p_id NUMBER) IS
17121: SELECT
17122: id, ica_id, tas_type,

Line 17119: p_new_id IN okc_k_headers_b.id%TYPE) IS

17115:
17116: END; /* insert_okl_trx_assets */
17117:
17118: PROCEDURE insert_okl_trx_assets_2(p_old_id IN okc_k_headers_b.id%TYPE,
17119: p_new_id IN okc_k_headers_b.id%TYPE) IS
17120: CURSOR c17_2(p_id NUMBER) IS
17121: SELECT
17122: id, ica_id, tas_type,
17123: object_version_number, attribute_category, attribute1,

Line 17380: PROCEDURE insert_okl_txl_itm_insts(p_old_id IN okc_k_headers_b.id%TYPE,

17376: p_token2_value => SQLERRM);
17377: RETURN x_return_status;
17378: END generate_instance_number_ib;
17379:
17380: PROCEDURE insert_okl_txl_itm_insts(p_old_id IN okc_k_headers_b.id%TYPE,
17381: p_new_id IN okc_k_headers_b.id%TYPE) IS
17382: CURSOR c22(p_id NUMBER) IS
17383: SELECT
17384: p.id, p.object_version_number, p.tas_id,

Line 17381: p_new_id IN okc_k_headers_b.id%TYPE) IS

17377: RETURN x_return_status;
17378: END generate_instance_number_ib;
17379:
17380: PROCEDURE insert_okl_txl_itm_insts(p_old_id IN okc_k_headers_b.id%TYPE,
17381: p_new_id IN okc_k_headers_b.id%TYPE) IS
17382: CURSOR c22(p_id NUMBER) IS
17383: SELECT
17384: p.id, p.object_version_number, p.tas_id,
17385: p.tal_id, p.kle_id, p.tal_type,

Line 17862: PROCEDURE insert_okl_trx_assets_3(p_old_id IN okc_k_headers_b.id%TYPE,

17858: END IF;
17859:
17860: END; /* get_salvage_value */
17861:
17862: PROCEDURE insert_okl_trx_assets_3(p_old_id IN okc_k_headers_b.id%TYPE,
17863: p_new_id IN okc_k_headers_b.id%TYPE) IS
17864: CURSOR c27(p_id NUMBER) IS
17865: SELECT
17866: fa.asset_id ID1,

Line 17863: p_new_id IN okc_k_headers_b.id%TYPE) IS

17859:
17860: END; /* get_salvage_value */
17861:
17862: PROCEDURE insert_okl_trx_assets_3(p_old_id IN okc_k_headers_b.id%TYPE,
17863: p_new_id IN okc_k_headers_b.id%TYPE) IS
17864: CURSOR c27(p_id NUMBER) IS
17865: SELECT
17866: fa.asset_id ID1,
17867: '#' ID2,

Line 18178: FROM OKC_K_HEADERS_B

18174:
18175: --Added by dpsingh for LE Uptake
18176: CURSOR contract_num_csr (p_ctr_id1 NUMBER) IS
18177: SELECT contract_number
18178: FROM OKC_K_HEADERS_B
18179: WHERE id = p_ctr_id1;
18180:
18181: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
18182: l_legal_entity_id NUMBER;

Line 18181: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

18177: SELECT contract_number
18178: FROM OKC_K_HEADERS_B
18179: WHERE id = p_ctr_id1;
18180:
18181: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
18182: l_legal_entity_id NUMBER;
18183:
18184: BEGIN
18185: OPEN c_try_id;

Line 18939: PROCEDURE insert_okc_rg_party_roles(p_old_id IN okc_k_headers_b.id%TYPE,

18935:
18936: RAISE OKC_API.G_EXCEPTION_ERROR;
18937: END; /* insert okl_trx_assets_3 */
18938:
18939: PROCEDURE insert_okc_rg_party_roles(p_old_id IN okc_k_headers_b.id%TYPE,
18940: p_new_id IN okc_k_headers_b.id%TYPE) IS
18941: CURSOR c25(p_id NUMBER) IS
18942: SELECT
18943: a.id, a.rgp_id, a.rrd_id,

Line 18940: p_new_id IN okc_k_headers_b.id%TYPE) IS

18936: RAISE OKC_API.G_EXCEPTION_ERROR;
18937: END; /* insert okl_trx_assets_3 */
18938:
18939: PROCEDURE insert_okc_rg_party_roles(p_old_id IN okc_k_headers_b.id%TYPE,
18940: p_new_id IN okc_k_headers_b.id%TYPE) IS
18941: CURSOR c25(p_id NUMBER) IS
18942: SELECT
18943: a.id, a.rgp_id, a.rrd_id,
18944: a.cpl_id, a.dnz_chr_id, a.object_version_number,

Line 19079: PROCEDURE insert_okl_supp_invoice_dtls(p_old_id IN okc_k_headers_b.id%TYPE)

19075: RAISE OKC_API.G_EXCEPTION_ERROR;
19076:
19077: END; /* insert_okc_rg_party_roles */
19078:
19079: PROCEDURE insert_okl_supp_invoice_dtls(p_old_id IN okc_k_headers_b.id%TYPE)
19080: IS
19081: CURSOR c26(p_id NUMBER) IS
19082: SELECT
19083: a.id, a.object_version_number, a.cle_id,

Line 19473: PROCEDURE insert_okl_txl_itm_insts2(p_old_id IN okc_k_headers_b.id%TYPE,

19469: END IF;
19470:
19471: END; /* get_object1_id1 */
19472:
19473: PROCEDURE insert_okl_txl_itm_insts2(p_old_id IN okc_k_headers_b.id%TYPE,
19474: p_new_id IN okc_k_headers_b.id%TYPE) IS
19475: CURSOR c28(p_id NUMBER) IS
19476: SELECT csi.inventory_item_id,
19477: csi.inv_master_organization_id,

Line 19474: p_new_id IN okc_k_headers_b.id%TYPE) IS

19470:
19471: END; /* get_object1_id1 */
19472:
19473: PROCEDURE insert_okl_txl_itm_insts2(p_old_id IN okc_k_headers_b.id%TYPE,
19474: p_new_id IN okc_k_headers_b.id%TYPE) IS
19475: CURSOR c28(p_id NUMBER) IS
19476: SELECT csi.inventory_item_id,
19477: csi.inv_master_organization_id,
19478: csi.instance_number,

Line 20003: l_chr_id okc_k_headers_b.id%TYPE;

19999: p_event_name IN wf_events.name%TYPE,
20000: p_parameter_list IN wf_parameter_list_t,
20001: p_contract_process IN VARCHAR2) IS
20002:
20003: l_chr_id okc_k_headers_b.id%TYPE;
20004: --l_contract_process VARCHAR2(30);
20005: l_parameter_list WF_PARAMETER_LIST_T := p_parameter_list;
20006:
20007: BEGIN

Line 20035: p_chr_id IN okc_k_headers_b.id%TYPE,

20031: END raise_business_event;
20032:
20033: PROCEDURE raise_business_event_subsidy(p_api_version IN NUMBER,
20034: p_init_msg_list IN VARCHAR2,
20035: p_chr_id IN okc_k_headers_b.id%TYPE,
20036: p_asset_id IN okc_k_lines_b.id%TYPE,
20037: p_subsidy_id IN okl_subsidies_b.id%TYPE,
20038: p_event_name IN VARCHAR2,
20039: p_contract_process IN VARCHAR2,

Line 20080: --p_chr_id okc_k_headers_b.id%TYPE;

20076: ,p_event_param_list IN WF_PARAMETER_LIST_T
20077: ,p_contract_process IN VARCHAR2
20078: )IS
20079: --l_process VARCHAR2(20);
20080: --p_chr_id okc_k_headers_b.id%TYPE;
20081: l_parameter_list WF_PARAMETER_LIST_T := p_event_param_list;
20082: BEGIN
20083: --p_chr_id := wf_event.GetValueForParameter(G_WF_ITM_CONTRACT_ID,p_event_param_list);
20084: --l_process := Okl_Lla_Util_Pvt.get_contract_process(p_chr_id);

Line 20102: p_chr_id IN okc_k_headers_b.id%TYPE,

20098: END raise_business_event_itm;
20099:
20100: PROCEDURE raise_business_event_dep(p_api_version IN NUMBER,
20101: p_init_msg_list IN VARCHAR2,
20102: p_chr_id IN okc_k_headers_b.id%TYPE,
20103: p_asset_id IN okc_k_lines_b.id%TYPE,
20104: p_book_code IN okl_txl_assets_b.corporate_book%TYPE,
20105: p_event_name IN VARCHAR2,
20106: p_contract_process IN VARCHAR2,

Line 20139: p_chr_id IN okc_k_headers_b.id%TYPE,

20135:
20136:
20137: PROCEDURE raise_business_event_txd(p_api_version IN NUMBER,
20138: p_init_msg_list IN VARCHAR2,
20139: p_chr_id IN okc_k_headers_b.id%TYPE,
20140: p_asset_id IN okc_k_lines_b.id%TYPE,
20141: p_event_name IN VARCHAR2,
20142: p_contract_process IN VARCHAR2,
20143: x_return_status OUT NOCOPY VARCHAR2,

Line 20175: p_chr_id IN okc_k_headers_b.id%TYPE,

20171:
20172: PROCEDURE raise_business_event_itm
20173: (p_api_version IN NUMBER,
20174: p_init_msg_list IN VARCHAR2,
20175: p_chr_id IN okc_k_headers_b.id%TYPE,
20176: p_asset_id IN okc_k_lines_b.id%TYPE,
20177: p_ser_num IN okl_txl_itm_insts.serial_number%TYPE,
20178: p_event_name IN VARCHAR2,
20179: p_contract_process IN VARCHAR2,

Line 20209: p_chr_id IN okc_k_headers_b.id%TYPE,

20205:
20206: PROCEDURE raise_business_event_supp
20207: (p_api_version IN NUMBER,
20208: p_init_msg_list IN VARCHAR2,
20209: p_chr_id IN okc_k_headers_b.id%TYPE,
20210: p_asset_id IN okc_k_lines_b.id%TYPE,
20211: p_vendor_id IN po_vendors.vendor_id%TYPE,
20212: p_event_name IN VARCHAR2,
20213: p_contract_process IN VARCHAR2,

Line 20495: SELECT okc_k_headers_b_s.NEXTVAL INTO l_copied_id FROM dual;

20491: l_sts_code_orig := c1rec.sts_code;
20492:
20493: l_curr_pos := 'okl_copy_lease_contract:4';
20494: -- kmotepal populating contract id from sys guid instead of using OKC sequence which fixes the bug 4436545 (Reverted back for OKL.H)
20495: SELECT okc_k_headers_b_s.NEXTVAL INTO l_copied_id FROM dual;
20496: --l_copied_id := okc_p_util.raw_to_number(sys_guid());
20497:
20498: l_contract_currency := c1rec.currency_code;
20499: l_contract_start_date := c1rec.start_date;

Line 20581: INSERT INTO okc_k_headers_b (

20577: END IF;
20578:
20579: BEGIN
20580: l_curr_pos := 'okl_copy_lease_contract:10';
20581: INSERT INTO okc_k_headers_b (
20582: ID, CONTRACT_NUMBER, AUTHORING_ORG_ID,
20583: CONTRACT_NUMBER_MODIFIER, CHR_ID_RESPONSE, CHR_ID_AWARD,
20584: CHR_ID_RENEWED, INV_ORGANIZATION_ID, STS_CODE,
20585: QCL_ID, SCS_CODE, TRN_CODE,

Line 20658: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'ERROR during insert into okc_k_headers_b...');

20654:
20655: EXCEPTION WHEN OTHERS THEN
20656: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
20657: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'sqlcode=' || SQLCODE || ':sqlerrm=' || SQLERRM);
20658: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'ERROR during insert into okc_k_headers_b...');
20659: END IF;
20660: OKL_API.set_message(p_app_name => 'OKL',
20661: p_msg_name => l_message,
20662: p_token1 => 'CONTRACT_NUMBER',

Line 22119: From okc_k_headers_b chr

22115: Cursor l_date_sig_csr(p_chr_id IN NUMBER,
22116: p_chr_number IN VARCHAR2,
22117: p_chr_modifier IN VARCHAR2) is
22118: Select chr.date_signed
22119: From okc_k_headers_b chr
22120: where
22121: ( (chr.id = p_chr_id and p_chr_id is not null)
22122: or (p_chr_id is null and p_chr_modifier is null and p_chr_number is not null and chr.contract_number = p_chr_number )
22123: or (p_chr_id is null and p_chr_modifier is not null and p_chr_number is not null and chr.contract_number_modifier = p_chr_modifier and chr.contract_number = p_chr_number)

Line 22149: From okc_k_headers_b

22145: --Bug #2555692
22146: Cursor l_scs_csr (p_chr_id IN NUMBER) is
22147: Select scs_code,
22148: orig_system_id1
22149: From okc_k_headers_b
22150: where id = p_chr_id;
22151:
22152: l_scs_code okc_k_headers_b.SCS_CODE%TYPE;
22153: l_orig_chr_id okc_k_headers_b.ORIG_SYSTEM_ID1%TYPE;

Line 22152: l_scs_code okc_k_headers_b.SCS_CODE%TYPE;

22148: orig_system_id1
22149: From okc_k_headers_b
22150: where id = p_chr_id;
22151:
22152: l_scs_code okc_k_headers_b.SCS_CODE%TYPE;
22153: l_orig_chr_id okc_k_headers_b.ORIG_SYSTEM_ID1%TYPE;
22154:
22155: --Bug # 2792330 S and O
22156: --get the status of source contract

Line 22153: l_orig_chr_id okc_k_headers_b.ORIG_SYSTEM_ID1%TYPE;

22149: From okc_k_headers_b
22150: where id = p_chr_id;
22151:
22152: l_scs_code okc_k_headers_b.SCS_CODE%TYPE;
22153: l_orig_chr_id okc_k_headers_b.ORIG_SYSTEM_ID1%TYPE;
22154:
22155: --Bug # 2792330 S and O
22156: --get the status of source contract
22157: Cursor l_sts_csr (pchrid in number) is

Line 22159: From OKC_K_HEADERS_B

22155: --Bug # 2792330 S and O
22156: --get the status of source contract
22157: Cursor l_sts_csr (pchrid in number) is
22158: Select sts_code
22159: From OKC_K_HEADERS_B
22160: Where id = pchrid;
22161:
22162: l_sts_code okc_k_headers_b.STS_CODE%TYPE;
22163: l_quote_chr_id okc_k_headers_b.ID%TYPE;

Line 22162: l_sts_code okc_k_headers_b.STS_CODE%TYPE;

22158: Select sts_code
22159: From OKC_K_HEADERS_B
22160: Where id = pchrid;
22161:
22162: l_sts_code okc_k_headers_b.STS_CODE%TYPE;
22163: l_quote_chr_id okc_k_headers_b.ID%TYPE;
22164:
22165: --Bug# 3621663
22166: --cursor to get multi-gaap reporting book transaction

Line 22163: l_quote_chr_id okc_k_headers_b.ID%TYPE;

22159: From OKC_K_HEADERS_B
22160: Where id = pchrid;
22161:
22162: l_sts_code okc_k_headers_b.STS_CODE%TYPE;
22163: l_quote_chr_id okc_k_headers_b.ID%TYPE;
22164:
22165: --Bug# 3621663
22166: --cursor to get multi-gaap reporting book transaction
22167: cursor l_txd_csr (p_book_type_code in varchar2,

Line 22193: okc_k_headers_b parent_chrb

22189: cursor l_parent_sts_csr (p_chr_id in number) is
22190: select stsb.ste_code,
22191: parent_chrb.scs_code
22192: from okc_statuses_b stsb,
22193: okc_k_headers_b parent_chrb
22194: where stsb.code = parent_chrb.sts_code
22195: and parent_chrb.id = p_chr_id;
22196:
22197: l_parent_sts_rec l_parent_sts_csr%ROWTYPE;