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_IMPORT_CONTRACTS_WORKER dependencies on OKS_HEADERS_INTERFACE

Line 131: FROM OKS_INT_ERROR_STG_TEMP OIES, OKS_HEADERS_INTERFACE OHI

127: OIES.INTERFACE_SOURCE_TABLE,
128: OHI.HEADER_INTERFACE_ID,
129: OIES.INTERFACE_ID,
130: OIES.ERROR_MSG
131: FROM OKS_INT_ERROR_STG_TEMP OIES, OKS_HEADERS_INTERFACE OHI
132: WHERE OIES.HEADER_INTERFACE_ROWID = OHI.ROWID;
133:
134: l_stmt_num := 20;
135:

Line 136: UPDATE OKS_HEADERS_INTERFACE ohi

132: WHERE OIES.HEADER_INTERFACE_ROWID = OHI.ROWID;
133:
134: l_stmt_num := 20;
135:
136: UPDATE OKS_HEADERS_INTERFACE ohi
137: SET ohi.INTERFACE_STATUS = (CASE WHEN EXISTS (SELECT 'X' FROM OKS_INT_ERROR_STG_TEMP WHERE ohi.ROWID = HEADER_INTERFACE_ROWID)
138: THEN 'E'
139: WHEN P_mode = 'I' THEN 'S'
140: ELSE NULL

Line 297: nvl(SUM(decode(INVALID_Q.INTERFACE_SOURCE_TABLE, 'OKS_HEADERS_INTERFACE', INVALID_Q.INVALID_COUNT, 0)), 0) HEADERS_INVALID,

293: SELECT P_batch_id BATCH_ID,
294: P_parent_request_id PARENT_REQUEST_ID,
295: G_WORKER_REQ_ID REQUEST_ID,
296: 2 STATISTIC_TYPE_ID,
297: nvl(SUM(decode(INVALID_Q.INTERFACE_SOURCE_TABLE, 'OKS_HEADERS_INTERFACE', INVALID_Q.INVALID_COUNT, 0)), 0) HEADERS_INVALID,
298: nvl(SUM(decode(INVALID_Q.INTERFACE_SOURCE_TABLE, 'OKS_LINES_INTERFACE', INVALID_Q.INVALID_COUNT, 0)), 0) LINES_INVALID,
299: nvl(SUM(decode(INVALID_Q.INTERFACE_SOURCE_TABLE, 'OKS_COVERED_LEVELS_INTERFACE', INVALID_Q.INVALID_COUNT, 0)), 0) COVERED_LEVELS_INVALID,
300: nvl(SUM(decode(INVALID_Q.INTERFACE_SOURCE_TABLE, 'OKS_USAGE_COUNTERS_INTERFACE', INVALID_Q.INVALID_COUNT, 0)), 0) USAGE_COUNTERS_INVALID,
301: nvl(SUM(decode(INVALID_Q.INTERFACE_SOURCE_TABLE, 'OKS_SALES_CREDITS_INTERFACE', INVALID_Q.INVALID_COUNT, 0)), 0) SALES_CREDITS_INVALID,

Line 398: l_table_name varchar2(30) := 'OKS_HEADERS_INTERFACE';

394: IS
395: l_stmt_num NUMBER := 0;
396: l_routine CONSTANT VARCHAR2(30) := 'Worker_process';
397: l_product varchar2(30) := 'OKS';
398: l_table_name varchar2(30) := 'OKS_HEADERS_INTERFACE';
399: l_update_name varchar2(30);
400: l_status varchar2(30);
401: l_industry varchar2(30);
402: l_retstatus boolean;

Line 419: FROM OKS_HEADERS_INTERFACE OHI

415: ,'SERVICE',DECODE(OLI.line_interface_id, NULL,-1
416: ,DECODE (UPPER(OLI.LINE_TYPE),'USAGE',NVL(OUCI.LINE_INTERFACE_ID,-3)
417: ,NVL(OCLI.LINE_INTERFACE_ID,-2)))
418: ,'SUBSCRIPTION',NVL(OLI.line_interface_id,-1) ) line_flow
419: FROM OKS_HEADERS_INTERFACE OHI
420: ,OKS_LINES_INTERFACE OLI
421: ,OKS_COVERED_LEVELS_INTERFACE OCLI
422: ,OKS_USAGE_COUNTERS_INTERFACE OUCI
423: ,OKS_SALES_CREDITS_INTERFACE OSCI

Line 432: -- Worker processing for OKS_HEADERS_INTERFACE table

428: AND OHI.HEADER_INTERFACE_ID = OSCI.HEADER_INTERFACE_ID(+);
429:
430: BEGIN
431: --
432: -- Worker processing for OKS_HEADERS_INTERFACE table
433: --
434: IF G_PROCEDURE_LOG THEN
435: fnd_log.string(fnd_log.level_procedure,
436: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,

Line 493: SELECT count(1) INTO l_row_count FROM OKS_HEADERS_INTERFACE

489:
490: WHILE (l_any_rows_to_process = TRUE)
491: LOOP
492: l_stmt_num := 40;
493: SELECT count(1) INTO l_row_count FROM OKS_HEADERS_INTERFACE
494: WHERE ROWID BETWEEN l_start_rowid AND l_end_rowid
495: AND BATCH_ID = P_batch_id
496: AND (INTERFACE_STATUS IS NULL OR INTERFACE_STATUS = 'R')
497: AND rownum = 1;

Line 504: UPDATE oks_headers_interface

500: FOR process_rec IN process(p_batch_id)
501: LOOP
502: IF(process_rec.sales_credits = -1)THEN
503:
504: UPDATE oks_headers_interface
505: SET interface_status ='E'
506: WHERE header_interface_id =process_rec.HEADER_INTERFACE_ID;
507:
508: INSERT INTO OKS_IMP_ERRORS

Line 518: 'OKS_HEADERS_INTERFACE',

514: ERROR_MESSAGE)
515: VALUES
516: (G_WORKER_REQ_ID,
517: P_parent_request_id,
518: 'OKS_HEADERS_INTERFACE',
519: process_rec.HEADER_INTERFACE_ID,
520: process_rec.HEADER_INTERFACE_ID,
521: 'OKS_IMP_HDR_SAL_CREDIT' );
522: END IF;

Line 524: UPDATE oks_headers_interface

520: process_rec.HEADER_INTERFACE_ID,
521: 'OKS_IMP_HDR_SAL_CREDIT' );
522: END IF;
523: IF(process_rec.line_flow = -1)THEN
524: UPDATE oks_headers_interface
525: SET interface_status ='E'
526: WHERE header_interface_id =process_rec.HEADER_INTERFACE_ID;
527:
528: INSERT INTO OKS_IMP_ERRORS

Line 538: 'OKS_HEADERS_INTERFACE',

534: ERROR_MESSAGE)
535: VALUES
536: (G_WORKER_REQ_ID,
537: P_parent_request_id,
538: 'OKS_HEADERS_INTERFACE',
539: process_rec.HEADER_INTERFACE_ID,
540: process_rec.HEADER_INTERFACE_ID,
541: 'OKS_IMP_HDR_INVALID_LINE' );
542: END IF;

Line 544: UPDATE oks_headers_interface

540: process_rec.HEADER_INTERFACE_ID,
541: 'OKS_IMP_HDR_INVALID_LINE' );
542: END IF;
543: IF(process_rec.line_flow =-2)THEN
544: UPDATE oks_headers_interface
545: SET interface_status ='E'
546: WHERE header_interface_id =process_rec.HEADER_INTERFACE_ID;
547:
548: INSERT INTO OKS_IMP_ERRORS

Line 564: UPDATE oks_headers_interface

560: process_rec.LINE_INTERFACE_ID,
561: 'OKS_IMP_LINE_INVALID_COVL' );
562: END IF;
563: IF(process_rec.line_flow =-3)THEN
564: UPDATE oks_headers_interface
565: SET interface_status ='E'
566: WHERE header_interface_id =process_rec.HEADER_INTERFACE_ID;
567: INSERT INTO OKS_IMP_ERRORS
568: (REQUEST_ID,