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 OKS_BRS_PVT

Line 786: l_bill_rate_tbl_in OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE;

782: g_Chr_Id NUMBER;
783: l_ctiv_tbl_in okc_rule_pub.ctiv_tbl_type;
784: l_ctiv_tbl_out okc_rule_pub.ctiv_tbl_type;
785: l_contact_Id Number;
786: l_bill_rate_tbl_in OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE;
787: x_bill_rate_tbl_out OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE;
788: --
789: l_api_version CONSTANT NUMBER := 1.0;
790: l_init_msg_list CONSTANT VARCHAR2(1):= 'F';

Line 787: x_bill_rate_tbl_out OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE;

783: l_ctiv_tbl_in okc_rule_pub.ctiv_tbl_type;
784: l_ctiv_tbl_out okc_rule_pub.ctiv_tbl_type;
785: l_contact_Id Number;
786: l_bill_rate_tbl_in OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE;
787: x_bill_rate_tbl_out OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE;
788: --
789: l_api_version CONSTANT NUMBER := 1.0;
790: l_init_msg_list CONSTANT VARCHAR2(1):= 'F';
791: l_return_status VARCHAR2(1);

Line 1913: OKS_BRS_PVT.INSERT_ROW(p_api_version => l_api_version,

1909: l_bill_rate_tbl_in(1).last_update_login := NULL;
1910: l_bill_rate_tbl_in(1).security_group_id := brs_rec.security_group_id;
1911: l_bill_rate_tbl_in(1).object_version_number := brs_rec.object_version_number;
1912:
1913: OKS_BRS_PVT.INSERT_ROW(p_api_version => l_api_version,
1914: p_init_msg_list => l_init_msg_list,
1915: x_return_status => l_return_status,
1916: x_msg_count => l_msg_count,
1917: x_msg_data => l_msg_data,

Line 2361: l_brs_tbl_in OKS_BRS_PVT.OksBillrateSchedulesVTblType;

2357: FROM OKS_BILLRATE_SCHEDULES
2358: WHERE CLE_ID = p_id
2359: AND dnz_chr_id =p_dnz_chr_id;
2360:
2361: l_brs_tbl_in OKS_BRS_PVT.OksBillrateSchedulesVTblType;
2362:
2363: l_brs_id NUMBER;
2364: l_line_id NUMBER;
2365:

Line 2389: l_brsv_tbl_in OKS_BRS_PVT.OksBillrateSchedulesVTblType;

2385: l_tzev_tbl_in OKS_CTZ_PVT.OksCoverageTimezonesVTblType;
2386: l_cvtv_tbl_in OKS_CVT_PVT.oks_coverage_times_v_tbl_type;
2387: l_actv_tbl_in OKS_ACT_PVT.OksActionTimeTypesVTblType;
2388: l_acmv_tbl_in OKS_ACM_PVT.oks_action_times_v_tbl_type;
2389: l_brsv_tbl_in OKS_BRS_PVT.OksBillrateSchedulesVTblType;
2390:
2391:
2392: l_api_version CONSTANT NUMBER := 1.0;
2393: l_init_msg_list CONSTANT VARCHAR2(1) := 'T';

Line 2533: OKS_BRS_PVT.delete_row(

2529:
2530:
2531:
2532:
2533: OKS_BRS_PVT.delete_row(
2534: p_api_version => l_api_version,
2535: p_init_msg_list => l_init_msg_list,
2536: x_return_status => l_return_status,
2537: x_msg_count => l_msg_count,

Line 2549: okc_debug.log('After OKS_BRS_PVT delete_row', 2);

2545:
2546: END LOOP ;
2547:
2548: IF (G_DEBUG_ENABLED = 'Y') THEN
2549: okc_debug.log('After OKS_BRS_PVT delete_row', 2);
2550: END IF;
2551:
2552: OPEN Child_Cur(P_line_id);
2553:

Line 2726: OKS_BRS_PVT.delete_row(

2722: -- End of Bug:4535339 by Jvorugan
2723:
2724: IF l_brsv_tbl_in.COUNT > 0 THEN
2725:
2726: OKS_BRS_PVT.delete_row(
2727: p_api_version => l_api_version,
2728: p_init_msg_list => l_init_msg_list,
2729: x_return_status => l_return_status,
2730: x_msg_count => l_msg_count,

Line 5643: PROCEDURE INIT_BILL_RATE_LINE(x_bill_rate_tbl OUT NOCOPY OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE)

5639: END CREATE_ADJUSTED_COVERAGE;
5640:
5641: --=============================================================================
5642:
5643: PROCEDURE INIT_BILL_RATE_LINE(x_bill_rate_tbl OUT NOCOPY OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE)
5644: IS
5645:
5646: BEGIN
5647:

Line 6103: l_bill_rate_tbl_in OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE ;

6099: AND rules.dnz_chr_id = orgb.dnz_chr_id
6100: AND rules.rule_information_category = 'RSL'
6101: AND rules.rule_information9 IS NULL ; -- upgrade_flag
6102:
6103: l_bill_rate_tbl_in OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE ;
6104: x_bill_rate_tbl_out OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE ;
6105:
6106: l_check_Flag VARCHAR2(1) := 'N';
6107: l_api_version CONSTANT NUMBER := 1.0;

Line 6104: x_bill_rate_tbl_out OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE ;

6100: AND rules.rule_information_category = 'RSL'
6101: AND rules.rule_information9 IS NULL ; -- upgrade_flag
6102:
6103: l_bill_rate_tbl_in OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE ;
6104: x_bill_rate_tbl_out OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE ;
6105:
6106: l_check_Flag VARCHAR2(1) := 'N';
6107: l_api_version CONSTANT NUMBER := 1.0;
6108: l_init_msg_list CONSTANT VARCHAR2(1):= 'F';

Line 6159: OKS_BRS_PVT.INSERT_ROW(

6155: l_bill_rate_tbl_in(1).security_group_id := NULL;
6156: l_bill_rate_tbl_in(1).object_version_number := 1; --Added
6157:
6158:
6159: OKS_BRS_PVT.INSERT_ROW(
6160: p_api_version => l_api_version,
6161: p_init_msg_list => l_init_msg_list,
6162: x_return_status => l_return_status,
6163: x_msg_count => l_msg_count,

Line 6261: l_bill_rate_tbl_in OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE ;

6257: l_msg_data VARCHAR2(2000):=null;
6258: l_api_name VARCHAR2(80):= 'OKS_BILLRATE_MAPPING';
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 ;

Line 6262: x_bill_rate_tbl_out OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE ;

6258: l_api_name VARCHAR2(80):= 'OKS_BILLRATE_MAPPING';
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 ;

Line 6423: OKS_BRS_PVT.update_row(

6419: l_bill_rate_tbl_in(1).last_update_login := bill_rate_rec.last_update_login;
6420: l_bill_rate_tbl_in(1).security_group_id := bill_rate_rec.security_group_id;
6421: l_bill_rate_tbl_in(1).object_version_number := bill_rate_rec.object_version_number;--Added
6422:
6423: OKS_BRS_PVT.update_row(
6424: p_api_version => l_api_version,
6425: p_init_msg_list => p_init_msg_list,
6426: x_return_status => l_return_status,
6427: x_msg_count => l_msg_count,

Line 6433: fnd_file.put_line(FND_FILE.LOG, 'AFTER OKS_BRS_PVT.UPDATE_ROW......');

6429: p_oks_billrate_schedules_v_tbl => l_bill_rate_tbl_in,
6430: x_oks_billrate_schedules_v_tbl => x_bill_rate_tbl_out);
6431:
6432: IF fnd_global.conc_request_id <> -1 THEN
6433: fnd_file.put_line(FND_FILE.LOG, 'AFTER OKS_BRS_PVT.UPDATE_ROW......');
6434: fnd_file.put_line(FND_FILE.LOG, 'Return Status from OKS_BRS_PVT.UPDATE_ROW API...'||l_return_status);
6435: END IF;
6436:
6437:

Line 6434: fnd_file.put_line(FND_FILE.LOG, 'Return Status from OKS_BRS_PVT.UPDATE_ROW API...'||l_return_status);

6430: x_oks_billrate_schedules_v_tbl => x_bill_rate_tbl_out);
6431:
6432: IF fnd_global.conc_request_id <> -1 THEN
6433: fnd_file.put_line(FND_FILE.LOG, 'AFTER OKS_BRS_PVT.UPDATE_ROW......');
6434: fnd_file.put_line(FND_FILE.LOG, 'Return Status from OKS_BRS_PVT.UPDATE_ROW API...'||l_return_status);
6435: END IF;
6436:
6437:
6438:

Line 6516: OKS_BRS_PVT.INSERT_ROW(

6512: l_bill_rate_tbl_in(1).security_group_id := bill_rate_rec.security_group_id;
6513: l_bill_rate_tbl_in(1).object_version_number := bill_rate_rec.object_version_number;--Added
6514:
6515:
6516: OKS_BRS_PVT.INSERT_ROW(
6517: p_api_version => l_api_version,
6518: p_init_msg_list => l_init_msg_list,
6519: x_return_status => l_return_status,
6520: x_msg_count => l_msg_count,

Line 6529: fnd_file.put_line(FND_FILE.LOG, 'AFTER OKS_BRS_PVT.INSERT_ROW......');

6525: x_return_status := l_return_status;
6526:
6527:
6528: IF fnd_global.conc_request_id <> -1 THEN
6529: fnd_file.put_line(FND_FILE.LOG, 'AFTER OKS_BRS_PVT.INSERT_ROW......');
6530: fnd_file.put_line(FND_FILE.LOG, 'Return Status from OKS_BRS_PVT.INSERT_ROW API...'||l_return_status);
6531: END IF;
6532:
6533:

Line 6530: fnd_file.put_line(FND_FILE.LOG, 'Return Status from OKS_BRS_PVT.INSERT_ROW API...'||l_return_status);

6526:
6527:
6528: IF fnd_global.conc_request_id <> -1 THEN
6529: fnd_file.put_line(FND_FILE.LOG, 'AFTER OKS_BRS_PVT.INSERT_ROW......');
6530: fnd_file.put_line(FND_FILE.LOG, 'Return Status from OKS_BRS_PVT.INSERT_ROW API...'||l_return_status);
6531: END IF;
6532:
6533:
6534:

Line 6869: l_billrate_sch_tbl_in oks_brs_pvt.OksBillrateSchedulesVTblType;

6865:
6866:
6867: l_klnv_tbl_in oks_kln_pvt.klnv_tbl_type;
6868: l_klnv_tbl_out oks_kln_pvt.klnv_tbl_type;
6869: l_billrate_sch_tbl_in oks_brs_pvt.OksBillrateSchedulesVTblType;
6870: l_billrate_sch_tbl_out oks_brs_pvt.OksBillrateSchedulesVTblType;
6871:
6872: l_timezone_tbl_in oks_ctz_pvt.OksCoverageTimezonesVTblType;
6873: l_timezone_tbl_out oks_ctz_pvt.OksCoverageTimezonesVTblType;

Line 6870: l_billrate_sch_tbl_out oks_brs_pvt.OksBillrateSchedulesVTblType;

6866:
6867: l_klnv_tbl_in oks_kln_pvt.klnv_tbl_type;
6868: l_klnv_tbl_out oks_kln_pvt.klnv_tbl_type;
6869: l_billrate_sch_tbl_in oks_brs_pvt.OksBillrateSchedulesVTblType;
6870: l_billrate_sch_tbl_out oks_brs_pvt.OksBillrateSchedulesVTblType;
6871:
6872: l_timezone_tbl_in oks_ctz_pvt.OksCoverageTimezonesVTblType;
6873: l_timezone_tbl_out oks_ctz_pvt.OksCoverageTimezonesVTblType;
6874:

Line 8091: oks_brs_pvt.insert_row(p_api_version => l_api_version,

8087: END LOOP ;
8088:
8089: IF l_billrate_sch_tbl_in.count > 0 then
8090:
8091: oks_brs_pvt.insert_row(p_api_version => l_api_version,
8092: p_init_msg_list => l_init_msg_list,
8093: x_return_status => l_return_status,
8094: x_msg_count => l_msg_count,
8095: x_msg_data => l_msg_data,

Line 8101: okc_debug.log('After oks_brs_pvt insert_row'||l_return_status, 2);

8097: x_oks_billrate_schedules_v_tbl => l_billrate_sch_tbl_out);
8098:
8099:
8100: IF (G_DEBUG_ENABLED = 'Y') THEN
8101: okc_debug.log('After oks_brs_pvt insert_row'||l_return_status, 2);
8102: END IF;
8103:
8104: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
8105: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 8847: l_return_Status := OKS_BRS_PVT.Create_Version(

8843: IF l_return_Status <> 'S' THEN
8844: RAISE G_EXCEPTION_HALT_VALIDATION;
8845: END IF;
8846:
8847: l_return_Status := OKS_BRS_PVT.Create_Version(
8848: p_id => l_chr_id,
8849: p_major_version =>l_major_version);
8850:
8851: IF l_return_Status <> 'S' THEN

Line 8950: l_return_Status := OKS_BRS_PVT.Restore_Version(

8946:
8947: IF l_return_Status <> 'S' THEN
8948: RAISE G_EXCEPTION_HALT_VALIDATION;
8949: END IF;
8950: l_return_Status := OKS_BRS_PVT.Restore_Version(
8951: p_id => l_chr_id,
8952: p_major_version =>l_major_version);
8953:
8954: IF l_return_Status <> 'S' THEN

Line 9359: l_bill_rate_tbl_in OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE;

9355: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;
9356: -- end Resource --
9357:
9358: -- Bill Rate --
9359: l_bill_rate_tbl_in OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE;
9360: l_bill_rate_tbl_out OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE;
9361:
9362: -- End Bill Rate --
9363:

Line 9360: l_bill_rate_tbl_out OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE;

9356: -- end Resource --
9357:
9358: -- Bill Rate --
9359: l_bill_rate_tbl_in OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE;
9360: l_bill_rate_tbl_out OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE;
9361:
9362: -- End Bill Rate --
9363:
9364: -- Preventive Maintainance --

Line 10002: OKS_BRS_PVT.UPDATE_ROW(p_api_version => l_api_version,

9998: End LOOP; -- Billsch
9999:
10000: If cnt1>0 Then
10001:
10002: OKS_BRS_PVT.UPDATE_ROW(p_api_version => l_api_version,
10003: p_init_msg_list => l_init_msg_list,
10004: x_return_status => l_return_status,
10005: x_msg_count => l_msg_count,
10006: x_msg_data => l_msg_data,