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_EXT_BILLING_CHARGES_PVT dependencies on OKC_P_UTIL

Line 1164: l_header_id := Okc_P_Util.raw_to_number(sys_guid());

1160: tai_tbl(indx).LAST_UPDATE_DATE := SYSDATE;
1161: tai_tbl(indx).LAST_UPDATED_BY := l_last_updated_by;
1162: tai_tbl(indx).LAST_UPDATE_LOGIN := l_last_update_login;
1163: tai_tbl(indx).OBJECT_VERSION_NUMBER := 1;
1164: l_header_id := Okc_P_Util.raw_to_number(sys_guid());
1165: tai_tbl(indx).ID := l_header_id;
1166: tai_tbl(indx).trx_number := SUBSTR(TO_CHAR(l_header_id),-6);
1167: tai_tbl(indx).request_id := l_request_id;
1168: tai_tbl(indx).program_application_id := l_program_application_id;

Line 1234: l_line_id := Okc_P_Util.raw_to_number(sys_guid());

1230: til_tbl(indx).tai_id := l_header_id;
1231: til_tbl(indx).sty_id := ext_bill_tbl(indx).sty_id;
1232: til_tbl(indx).inv_receiv_line_code := 'LINE';
1233: til_tbl(indx).amount := ext_bill_tbl(indx).amount;
1234: l_line_id := Okc_P_Util.raw_to_number(sys_guid());
1235: til_tbl(indx).ID := l_line_id;
1236: til_tbl(indx).OBJECT_VERSION_NUMBER := 1;
1237: til_tbl(indx).CREATION_DATE := SYSDATE;
1238: til_tbl(indx).CREATED_BY := l_last_updated_by;

Line 1397: ptc_tbl(indx).id := Okc_P_Util.raw_to_number(sys_guid());

1393: LOOP
1394: -- save rowid for later update
1395: upd_rowid_tbl(indx) := ext_bill_tbl(indx).ext_rowid;
1396:
1397: ptc_tbl(indx).id := Okc_P_Util.raw_to_number(sys_guid());
1398: ptc_tbl(indx).asset_id := ext_bill_tbl(indx).ASSET_ID;
1399: ptc_tbl(indx).asset_number := ext_bill_tbl(indx).ASSET_NUMBER;
1400: ptc_tbl(indx).khr_id := ext_bill_tbl(indx).contract_id;
1401: ptc_tbl(indx).contract_number := ext_bill_tbl(indx).CONTRACT_NUMBER;

Line 1475: stm_tbl(l_stmtbl_cnt).id := Okc_P_Util.raw_to_number(sys_guid());

1471: stm_tbl(l_stmtbl_cnt).date_current := sysdate;
1472: stm_tbl(l_stmtbl_cnt).comments := 'ACTUAL PROPERTY TAX';
1473:
1474: -- other mandatory columns
1475: stm_tbl(l_stmtbl_cnt).id := Okc_P_Util.raw_to_number(sys_guid());
1476: stm_tbl(l_stmtbl_cnt).OBJECT_VERSION_NUMBER := 1;
1477: stm_tbl(l_stmtbl_cnt).PROGRAM_ID := l_program_id;
1478: stm_tbl(l_stmtbl_cnt).REQUEST_ID := l_request_id;
1479: stm_tbl(l_stmtbl_cnt).PROGRAM_APPLICATION_ID := l_program_application_id;

Line 1538: sel_tbl(indx).id := Okc_P_Util.raw_to_number(sys_guid());

1534: sel_tbl(indx).COMMENTS := 'ACTUAL PROPERTY TAX';
1535: sel_tbl(indx).SOURCE_ID := ptc_tbl(indx).id;
1536: sel_tbl(indx).SOURCE_TABLE := 'OKL_PROPERTY_TAX_V';
1537: -- Other columns
1538: sel_tbl(indx).id := Okc_P_Util.raw_to_number(sys_guid());
1539: -- save sel_id for update
1540: upd_sel_tbl(indx) := sel_tbl(indx).id;
1541:
1542: sel_tbl(indx).OBJECT_VERSION_NUMBER := 1;