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 1236: l_header_id := Okc_P_Util.raw_to_number(sys_guid());

1232: tai_tbl(indx).LAST_UPDATE_DATE := SYSDATE;
1233: tai_tbl(indx).LAST_UPDATED_BY := l_last_updated_by;
1234: tai_tbl(indx).LAST_UPDATE_LOGIN := l_last_update_login;
1235: tai_tbl(indx).OBJECT_VERSION_NUMBER := 1;
1236: l_header_id := Okc_P_Util.raw_to_number(sys_guid());
1237: tai_tbl(indx).ID := l_header_id;
1238: tai_tbl(indx).trx_number := SUBSTR(TO_CHAR(l_header_id),-6);
1239: tai_tbl(indx).request_id := l_request_id;
1240: tai_tbl(indx).program_application_id := l_program_application_id;

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

1302: til_tbl(indx).tai_id := l_header_id;
1303: til_tbl(indx).sty_id := ext_bill_tbl(indx).sty_id;
1304: til_tbl(indx).inv_receiv_line_code := 'LINE';
1305: til_tbl(indx).amount := ext_bill_tbl(indx).amount;
1306: l_line_id := Okc_P_Util.raw_to_number(sys_guid());
1307: til_tbl(indx).ID := l_line_id;
1308: til_tbl(indx).OBJECT_VERSION_NUMBER := 1;
1309: til_tbl(indx).CREATION_DATE := SYSDATE;
1310: til_tbl(indx).CREATED_BY := l_last_updated_by;

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

1465: LOOP
1466: -- save rowid for later update
1467: upd_rowid_tbl(indx) := ext_bill_tbl(indx).ext_rowid;
1468:
1469: ptc_tbl(indx).id := Okc_P_Util.raw_to_number(sys_guid());
1470: ptc_tbl(indx).asset_id := ext_bill_tbl(indx).ASSET_ID;
1471: ptc_tbl(indx).asset_number := ext_bill_tbl(indx).ASSET_NUMBER;
1472: ptc_tbl(indx).khr_id := ext_bill_tbl(indx).contract_id;
1473: ptc_tbl(indx).contract_number := ext_bill_tbl(indx).CONTRACT_NUMBER;

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

1543: stm_tbl(l_stmtbl_cnt).date_current := sysdate;
1544: stm_tbl(l_stmtbl_cnt).comments := 'ACTUAL PROPERTY TAX';
1545:
1546: -- other mandatory columns
1547: stm_tbl(l_stmtbl_cnt).id := Okc_P_Util.raw_to_number(sys_guid());
1548: stm_tbl(l_stmtbl_cnt).OBJECT_VERSION_NUMBER := 1;
1549: stm_tbl(l_stmtbl_cnt).PROGRAM_ID := l_program_id;
1550: stm_tbl(l_stmtbl_cnt).REQUEST_ID := l_request_id;
1551: stm_tbl(l_stmtbl_cnt).PROGRAM_APPLICATION_ID := l_program_application_id;

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

1606: sel_tbl(indx).COMMENTS := 'ACTUAL PROPERTY TAX';
1607: sel_tbl(indx).SOURCE_ID := ptc_tbl(indx).id;
1608: sel_tbl(indx).SOURCE_TABLE := 'OKL_PROPERTY_TAX_V';
1609: -- Other columns
1610: sel_tbl(indx).id := Okc_P_Util.raw_to_number(sys_guid());
1611: -- save sel_id for update
1612: upd_sel_tbl(indx) := sel_tbl(indx).id;
1613:
1614: sel_tbl(indx).OBJECT_VERSION_NUMBER := 1;