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.OKS_COVERAGES_PVT dependencies on OKC_CONTRACT_PUB

Line 124: PROCEDURE Init_Clev(P_Clev_Tbl_In_Out IN OUT NOCOPY OKC_Contract_Pub.Clev_Tbl_type) IS

120: -- notify caller of an UNEXPECTED error
121: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
122: END Validate_tmp_cle_id;
123:
124: PROCEDURE Init_Clev(P_Clev_Tbl_In_Out IN OUT NOCOPY OKC_Contract_Pub.Clev_Tbl_type) IS
125:
126: BEGIN
127: IF NOT P_Clev_Tbl_In_Out.COUNT=0
128: THEN

Line 769: l_clev_rec okc_contract_pub.clev_rec_type;

765:
766:
767: g_start_date DATE;
768: g_End_date DATE;
769: l_clev_rec okc_contract_pub.clev_rec_type;
770: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
771: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
772: l_lsl_id NUMBER;
773: c_cle_id NUMBER;

Line 770: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

766:
767: g_start_date DATE;
768: g_End_date DATE;
769: l_clev_rec okc_contract_pub.clev_rec_type;
770: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
771: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
772: l_lsl_id NUMBER;
773: c_cle_id NUMBER;
774: txg_cle_id NUMBER;

Line 771: l_clev_tbl_out okc_contract_pub.clev_tbl_type;

767: g_start_date DATE;
768: g_End_date DATE;
769: l_clev_rec okc_contract_pub.clev_rec_type;
770: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
771: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
772: l_lsl_id NUMBER;
773: c_cle_id NUMBER;
774: txg_cle_id NUMBER;
775: crt_cle_id NUMBER;

Line 1034: okc_contract_pub.create_contract_line (

1030: l_clev_tbl_in(1).attribute15 := LineDet_Rec.attribute15;
1031:
1032:
1033:
1034: okc_contract_pub.create_contract_line (
1035: p_api_version => l_api_version,
1036: p_init_msg_list => l_init_msg_list,
1037: x_return_status => l_return_status,
1038: x_msg_count => l_msg_count,

Line 1047: okc_debug.log('After okc_contract_pub create_contract_line', 2);

1043: );
1044:
1045:
1046: IF (G_DEBUG_ENABLED = 'Y') THEN
1047: okc_debug.log('After okc_contract_pub create_contract_line', 2);
1048: END IF;
1049:
1050: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1051: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1262: okc_contract_pub.create_contract_line(p_api_version => l_api_version,

1258: l_clev_tbl_in(1).attribute14 := LineDet_Rec1.attribute14;
1259: l_clev_tbl_in(1).attribute15 := LineDet_Rec1.attribute15;
1260: l_clev_tbl_in(1).price_list_id := LineDet_Rec1.price_list_id;
1261:
1262: okc_contract_pub.create_contract_line(p_api_version => l_api_version,
1263: p_init_msg_list => l_init_msg_list,
1264: x_return_status => l_return_status,
1265: x_msg_count => l_msg_count,
1266: x_msg_data => l_msg_data,

Line 1458: okc_contract_pub.create_contract_line (

1454: l_clev_tbl_in(1).attribute13 := LineDet_Rec3.attribute13;
1455: l_clev_tbl_in(1).attribute14 := LineDet_Rec3.attribute14;
1456: l_clev_tbl_in(1).attribute15 := LineDet_Rec3.attribute15;
1457:
1458: okc_contract_pub.create_contract_line (
1459: p_api_version => l_api_version,
1460: p_init_msg_list => l_init_msg_list,
1461: x_return_status => l_return_status,
1462: x_msg_count => l_msg_count,

Line 1731: okc_contract_pub.create_contract_line (

1727: l_clev_tbl_in(1).attribute14 := LineDet_Rec3.attribute14;
1728: l_clev_tbl_in(1).attribute15 := LineDet_Rec3.attribute15;
1729:
1730:
1731: okc_contract_pub.create_contract_line (
1732: p_api_version => l_api_version,
1733: p_init_msg_list => l_init_msg_list,
1734: x_return_status => l_return_status,
1735: x_msg_count => l_msg_count,

Line 1859: okc_contract_pub.create_contract_line (

1855: l_clev_tbl_in(1).attribute14 := tmp_br_Rec.attribute14;
1856: l_clev_tbl_in(1).attribute15 := tmp_br_Rec.attribute15;
1857:
1858:
1859: okc_contract_pub.create_contract_line (
1860: p_api_version => l_api_version,
1861: p_init_msg_list => l_init_msg_list,
1862: x_return_status => l_return_status,
1863: x_msg_count => l_msg_count,

Line 2031: l_chrv_rec okc_contract_pub.chrv_rec_type;

2027: SELECT ID FROM OKC_Governances_v
2028: WHERE dnz_chr_ID=p_chr_Id
2029: And cle_id Is Null;
2030:
2031: l_chrv_rec okc_contract_pub.chrv_rec_type;
2032: l_Line_Id NUMBER;
2033: --
2034: l_api_version CONSTANT NUMBER := 1.0;
2035: l_init_msg_list CONSTANT VARCHAR2(1):= 'T';

Line 2042: l_gvev_tbl_in okc_contract_pub.gvev_tbl_type;

2038: l_msg_data VARCHAR2(2000):=null;
2039: l_msg_index_out Number;
2040: l_api_name CONSTANT VARCHAR2(30) := 'UNDO Header';
2041: --
2042: l_gvev_tbl_in okc_contract_pub.gvev_tbl_type;
2043: e_error Exception;
2044: n NUMBER;
2045: m NUMBER;
2046: v_Index NUMBER;

Line 2074: okc_Contract_pub.delete_governance(

2070: END LOOP;
2071:
2072: IF NOT l_gvev_tbl_In.COUNT=0
2073: THEN
2074: okc_Contract_pub.delete_governance(
2075: p_api_version => l_api_version,
2076: p_init_msg_list => l_init_msg_list,
2077: x_return_status => l_return_status,
2078: x_msg_count => l_msg_count,

Line 2373: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

2369: l_cov_id NUMBER;
2370: line_det_rec line_det_Cur%ROWTYPE;
2371: line_det_rec2 line_det_Cur%ROWTYPE;
2372: l_child_cur_rec Child_cur%rowtype;
2373: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
2374: l_clev_tbl_tmp okc_contract_pub.clev_tbl_type;
2375:
2376: l_cimv_tbl_in okc_Contract_Item_Pub.cimv_tbl_TYPE;
2377: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;

Line 2374: l_clev_tbl_tmp okc_contract_pub.clev_tbl_type;

2370: line_det_rec line_det_Cur%ROWTYPE;
2371: line_det_rec2 line_det_Cur%ROWTYPE;
2372: l_child_cur_rec Child_cur%rowtype;
2373: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
2374: l_clev_tbl_tmp okc_contract_pub.clev_tbl_type;
2375:
2376: l_cimv_tbl_in okc_Contract_Item_Pub.cimv_tbl_TYPE;
2377: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;
2378: l_cplv_tbl_in okc_contract_party_pub.cplv_tbl_type;

Line 3118: okc_contract_pub.delete_contract_line (

3114: END IF;
3115:
3116: IF NOT l_clev_tbl_in.COUNT=0
3117: THEN
3118: okc_contract_pub.delete_contract_line (
3119: p_api_version => l_api_version,
3120: p_init_msg_list => l_init_msg_list,
3121: x_return_status => l_return_status,
3122: x_msg_count => l_msg_count,

Line 3451: l_Clev_Tbl_In OKC_CONTRACT_PUB.clev_tbl_type;

3447: l_api_name CONSTANT VARCHAR2(30) := 'Update_cov_eff';
3448: e_Error EXCEPTION;
3449: NO_COV_ERROR EXCEPTION;
3450: g_chr_Id NUMBER;
3451: l_Clev_Tbl_In OKC_CONTRACT_PUB.clev_tbl_type;
3452: l_Clev_Tbl_Out OKC_CONTRACT_PUB.clev_tbl_type;
3453: l_Cov_Id NUMBER;
3454: l_Bp_Id NUMBER;
3455: l_Id NUMBER;

Line 3452: l_Clev_Tbl_Out OKC_CONTRACT_PUB.clev_tbl_type;

3448: e_Error EXCEPTION;
3449: NO_COV_ERROR EXCEPTION;
3450: g_chr_Id NUMBER;
3451: l_Clev_Tbl_In OKC_CONTRACT_PUB.clev_tbl_type;
3452: l_Clev_Tbl_Out OKC_CONTRACT_PUB.clev_tbl_type;
3453: l_Cov_Id NUMBER;
3454: l_Bp_Id NUMBER;
3455: l_Id NUMBER;
3456: i NUMBER:= 0;

Line 3646: okc_debug.log('Before okc_contract_pub.Update_Contract_Line', 2);

3642:
3643: -- Update Line with all the data for Coverage, Business process, React Times, Bill Types, Bill Rate
3644:
3645: IF (G_DEBUG_ENABLED = 'Y') THEN
3646: okc_debug.log('Before okc_contract_pub.Update_Contract_Line', 2);
3647: END IF;
3648: IF l_clev_tbl_in.COUNT > 0 Then
3649:
3650: okc_contract_pub.Update_Contract_Line(

Line 3650: okc_contract_pub.Update_Contract_Line(

3646: okc_debug.log('Before okc_contract_pub.Update_Contract_Line', 2);
3647: END IF;
3648: IF l_clev_tbl_in.COUNT > 0 Then
3649:
3650: okc_contract_pub.Update_Contract_Line(
3651: p_api_version => l_api_version,
3652: p_init_msg_list => l_init_msg_list,
3653: x_return_status => l_return_status,
3654: x_msg_count => l_msg_count,

Line 3662: okc_debug.log('After okc_contract_pub.Update_Contract_Line'||l_return_status, 2);

3658: x_clev_tbl => l_clev_tbl_out);
3659:
3660:
3661: IF (G_DEBUG_ENABLED = 'Y') THEN
3662: okc_debug.log('After okc_contract_pub.Update_Contract_Line'||l_return_status, 2);
3663: END IF;
3664:
3665: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3666:

Line 3873: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

3869: n NUMBER:=0;
3870:
3871: line_det_rec line_det_Cur%ROWTYPE;
3872: l_child_cur_rec Child_cur%rowtype;
3873: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
3874: l_clev_tbl_tmp okc_contract_pub.clev_tbl_type;
3875: l_rgpv_tbl_in okc_rule_pub.rgpv_tbl_type;
3876: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
3877: l_cimv_tbl_in okc_Contract_Item_Pub.cimv_tbl_TYPE;

Line 3874: l_clev_tbl_tmp okc_contract_pub.clev_tbl_type;

3870:
3871: line_det_rec line_det_Cur%ROWTYPE;
3872: l_child_cur_rec Child_cur%rowtype;
3873: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
3874: l_clev_tbl_tmp okc_contract_pub.clev_tbl_type;
3875: l_rgpv_tbl_in okc_rule_pub.rgpv_tbl_type;
3876: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
3877: l_cimv_tbl_in okc_Contract_Item_Pub.cimv_tbl_TYPE;
3878: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;

Line 4271: okc_contract_pub.delete_contract_line (

4267:
4268: IF NOT l_clev_tbl_in.COUNT=0
4269: THEN
4270: if (p_validate_status = 'Y') then
4271: okc_contract_pub.delete_contract_line (
4272: p_api_version => l_api_version,
4273: p_init_msg_list => l_init_msg_list,
4274: x_return_status => l_return_status,
4275: x_msg_count => l_msg_count,

Line 6005: PROCEDURE INIT_CONTRACT_LINE (x_clev_tbl OUT NOCOPY OKC_CONTRACT_PUB.clev_tbl_type)

6001: END; -- Validate_billrate_schedule;
6002:
6003:
6004: --=======================================================================================
6005: PROCEDURE INIT_CONTRACT_LINE (x_clev_tbl OUT NOCOPY OKC_CONTRACT_PUB.clev_tbl_type)
6006: IS
6007: BEGIN
6008:
6009: x_clev_tbl(1).id := NULL;

Line 6263: l_clev_tbl_in OKC_CONTRACT_PUB.clev_tbl_type ;

6259: G_PKG_NAME VARCHAR2(80):= 'OKS_COVERAGES_PVT' ;
6260:
6261: l_bill_rate_tbl_in OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE ;
6262: x_bill_rate_tbl_out OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE ;
6263: l_clev_tbl_in OKC_CONTRACT_PUB.clev_tbl_type ;
6264: l_clev_tbl_out OKC_CONTRACT_PUB.clev_tbl_type ;
6265: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type ;
6266: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type ;
6267: l_cle_id NUMBER;

Line 6264: l_clev_tbl_out OKC_CONTRACT_PUB.clev_tbl_type ;

6260:
6261: l_bill_rate_tbl_in OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE ;
6262: x_bill_rate_tbl_out OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE ;
6263: l_clev_tbl_in OKC_CONTRACT_PUB.clev_tbl_type ;
6264: l_clev_tbl_out OKC_CONTRACT_PUB.clev_tbl_type ;
6265: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type ;
6266: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type ;
6267: l_cle_id NUMBER;
6268: l_bill_rate_code VARCHAR2(30);

Line 6458: OKC_CONTRACT_PUB.CREATE_CONTRACT_LINE(p_api_version => l_api_version,

6454: l_clev_tbl_in(1).display_sequence:= 1 ;
6455:
6456:
6457:
6458: OKC_CONTRACT_PUB.CREATE_CONTRACT_LINE(p_api_version => l_api_version,
6459: p_init_msg_list => l_init_msg_list,
6460: x_return_status => l_return_status,
6461: x_msg_count => l_msg_count,
6462: x_msg_data => l_msg_data,

Line 6472: fnd_file.put_line(FND_FILE.LOG, 'AFTER OKC_CONTRACT_PUB.CREATE_CONTRACT_LINE......');

6468:
6469:
6470:
6471: IF fnd_global.conc_request_id <> -1 THEN
6472: fnd_file.put_line(FND_FILE.LOG, 'AFTER OKC_CONTRACT_PUB.CREATE_CONTRACT_LINE......');
6473: fnd_file.put_line(FND_FILE.LOG, 'Return Status from OKC_CONTRACT_PUB.CREATE_CONTRACT_LINE API...'||l_return_status);
6474: END IF;
6475:
6476:

Line 6473: fnd_file.put_line(FND_FILE.LOG, 'Return Status from OKC_CONTRACT_PUB.CREATE_CONTRACT_LINE API...'||l_return_status);

6469:
6470:
6471: IF fnd_global.conc_request_id <> -1 THEN
6472: fnd_file.put_line(FND_FILE.LOG, 'AFTER OKC_CONTRACT_PUB.CREATE_CONTRACT_LINE......');
6473: fnd_file.put_line(FND_FILE.LOG, 'Return Status from OKC_CONTRACT_PUB.CREATE_CONTRACT_LINE API...'||l_return_status);
6474: END IF;
6475:
6476:
6477: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

Line 9323: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

9319: (p_coverage_id IN NUMBER ,
9320: p_dnz_chr_id IN NUMBER) IS
9321:
9322: -- coverage --
9323: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
9324: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
9325: -- End --
9326: -- OKC_K_ITEMS
9327: l_cimv_tbl_in okc_contract_item_pub.cimv_tbl_type;

Line 9324: l_clev_tbl_out okc_contract_pub.clev_tbl_type;

9320: p_dnz_chr_id IN NUMBER) IS
9321:
9322: -- coverage --
9323: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
9324: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
9325: -- End --
9326: -- OKC_K_ITEMS
9327: l_cimv_tbl_in okc_contract_item_pub.cimv_tbl_type;
9328: l_cimv_tbl_out okc_contract_item_pub.cimv_tbl_type;

Line 9520: okc_contract_pub.update_contract_line (

9516: -- Coverage --
9517: l_clev_tbl_in(1).id := l_coverage_id;
9518: l_clev_tbl_in(1).dnz_chr_id := p_dnz_chr_id;
9519:
9520: okc_contract_pub.update_contract_line (
9521: p_api_version => l_api_version,
9522: p_init_msg_list => l_init_msg_list,
9523: x_return_status => l_return_status,
9524: x_msg_count => l_msg_count,

Line 9704: okc_contract_pub.update_contract_line (

9700:
9701: End Loop; -- end Loop BP
9702:
9703: If cnt>0 Then
9704: okc_contract_pub.update_contract_line (
9705: p_api_version => l_api_version,
9706: p_init_msg_list => l_init_msg_list,
9707: x_return_status => l_return_status,
9708: x_msg_count => l_msg_count,

Line 9805: okc_contract_pub.update_contract_line (

9801: cnt1:=0;
9802: END LOOP; -- Reaction Time
9803: End LOOP; -- BP
9804: if cnt>0 Then
9805: okc_contract_pub.update_contract_line (
9806: p_api_version => l_api_version,
9807: p_init_msg_list => l_init_msg_list,
9808: x_return_status => l_return_status,
9809: x_msg_count => l_msg_count,

Line 9940: okc_contract_pub.update_contract_line (

9936: end if;
9937: End LOOP;
9938: End LOOP; -- BP --
9939: If cnt>0 then
9940: okc_contract_pub.update_contract_line (
9941: p_api_version => l_api_version,
9942: p_init_msg_list => l_init_msg_list,
9943: x_return_status => l_return_status,
9944: x_msg_count => l_msg_count,

Line 10016: okc_contract_pub.update_contract_line (

10012: End LOOP; -- billrate
10013: End LOOP;
10014: End LOOP; -- BP
10015: If cnt>0 Then
10016: okc_contract_pub.update_contract_line (
10017: p_api_version => l_api_version,
10018: p_init_msg_list => l_init_msg_list,
10019: x_return_status => l_return_status,
10020: x_msg_count => l_msg_count,