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.CZ_LOGIC_GEN dependencies on CZ_LCE_TEXTS

Line 398: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES

394: BEGIN
395: IF(vLogicLine IS NOT NULL)THEN
396: IF(LENGTHB(vLogicText) + LENGTHB(vLogicLine)>2000)THEN
397:
398: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES
399: (nStructureHeaderId, nSequenceNbr, vLogicText);
400: vLogicText := NULL;
401: nSequenceNbr := nSequenceNbr + 1;
402:

Line 426: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES

422: BEGIN
423: IF(vLogicLine IS NOT NULL)THEN
424: IF(LENGTHB(vLogicText) + LENGTHB(vLogicLine)>2000)THEN
425:
426: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES
427: (nStructureHeaderId, nSequenceNbr, vLogicText);
428: vLogicText := NULL;
429: nSequenceNbr := nSequenceNbr + 1;
430:

Line 862: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES

858: BEGIN
859: IF(vLogicLine IS NOT NULL)THEN
860: IF(LENGTHB(vLogicText) + LENGTHB(vLogicLine)>2000)THEN
861:
862: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES
863: (nHeaderId, v_tSequenceNbr(nHeaderId), vLogicText);
864: vLogicText := NULL;
865: v_tSequenceNbr(nHeaderId) := v_tSequenceNbr(nHeaderId) + 1;
866:

Line 2155: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES

2151:
2152: --Flush off the buffer because we are about to write to another file
2153:
2154: IF(vLogicText IS NOT NULL)THEN
2155: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES
2156: (nHeaderId, v_tSequenceNbr(nHeaderId), vLogicText);
2157: vLogicText := NULL;
2158: v_tSequenceNbr(nHeaderId) := v_tSequenceNbr(nHeaderId) + 1;
2159: END IF;

Line 2208: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES

2204:
2205: vLogicText := vLogicText || 'OBJECT ' || v_accuname || NewLine ||
2206: 'NOTTRUE ' || v_nodename || ' ' || v_accuname || ' ... ' || TO_CHAR(nReasonId) || NewLine;
2207:
2208: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES
2209: (v_HeaderId, vSeqNbrByHeader(v_HeaderId), vLogicText);
2210: vLogicText := NULL;
2211: vSeqNbrByHeader(v_HeaderId) := vSeqNbrByHeader(v_HeaderId) + 1;
2212:

Line 3580: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES

3576:
3577: --Flush off the buffer because we are about to write to another file
3578:
3579: IF(vLogicText IS NOT NULL)THEN
3580: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES
3581: (nHeaderId, v_tSequenceNbr(nHeaderId), vLogicText);
3582: vLogicText := NULL;
3583: v_tSequenceNbr(nHeaderId) := v_tSequenceNbr(nHeaderId) + 1;
3584: END IF;

Line 3634: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES

3630: vLogicText := vLogicText || 'TOTAL ' || v_accuname || NewLine ||
3631: 'INC ' || v_accuname || ' ' || v_nodename ||
3632: OperatorLiterals(OPERATOR_ROUND) || '... ' || TO_CHAR(nReasonId) || NewLine;
3633:
3634: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES
3635: (v_HeaderId, vSeqNbrByHeader(v_HeaderId), vLogicText);
3636: vLogicText := NULL;
3637: vSeqNbrByHeader(v_HeaderId) := vSeqNbrByHeader(v_HeaderId) + 1;
3638:

Line 3830: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES

3826:
3827: --Flush off the buffer because we are about to write to another file.
3828:
3829: IF(vLogicText IS NOT NULL)THEN
3830: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES
3831: (nHeaderId, v_tSequenceNbr(nHeaderId), vLogicText);
3832: vLogicText := NULL;
3833: v_tSequenceNbr(nHeaderId) := v_tSequenceNbr(nHeaderId) + 1;
3834: END IF;

Line 3886: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES

3882: vLogicText := vLogicText || 'TOTAL ' || v_accuname || NewLine ||
3883: 'CONTRIBUTE 1 ' || v_accuname || ' ' || v_nodename ||
3884: ' ... ' || TO_CHAR(nReasonId) || NewLine;
3885:
3886: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES
3887: (v_HeaderId, vSeqNbrByHeader(v_HeaderId), vLogicText);
3888:
3889: vLogicText := NULL;
3890: vSeqNbrByHeader(v_HeaderId) := vSeqNbrByHeader(v_HeaderId) + 1;

Line 8028: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES (nHeaderId, 1, vLogicLine);

8024: 'EFF , , ' || NewLine || NewLine ||
8025: 'INC 1 ' || PATH_DELIMITER || 'parent' || PATH_DELIMITER || 'P_' ||
8026: localString || '_ACTUALCOUNT round' || NewLine;
8027:
8028: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES (nHeaderId, 1, vLogicLine);
8029:
8030: v_tIsHeaderGenerated(v_NodeId(i)) := nHeaderId;
8031: v_tSequenceNbr(nHeaderId) := 2;
8032: v_tLogicNetType(nHeaderId) := LOGIC_NET_TYPE_MANDATORY;

Line 9178: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES

9174:
9175: IF(nHeaderId <> nPreviousHeaderId)THEN
9176:
9177: IF(vLogicText IS NOT NULL)THEN
9178: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES
9179: (nPreviousHeaderId, v_tSequenceNbr(nPreviousHeaderId), vLogicText);
9180: vLogicText := NULL;
9181: v_tSequenceNbr(nPreviousHeaderId) := v_tSequenceNbr(nPreviousHeaderId) + 1;
9182: END IF;

Line 9756: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES

9752:
9753: IF(nHeaderId <> nPreviousHeaderId)THEN
9754:
9755: IF(vLogicText IS NOT NULL)THEN
9756: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES
9757: (nPreviousHeaderId, v_tSequenceNbr(nPreviousHeaderId), vLogicText);
9758: vLogicText := NULL;
9759: v_tSequenceNbr(nPreviousHeaderId) := v_tSequenceNbr(nPreviousHeaderId) + 1;
9760: END IF;

Line 9800: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES

9796:
9797: --Flush off the buffer after rules generation
9798:
9799: IF(vLogicText IS NOT NULL)THEN
9800: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES
9801: (nHeaderId, v_tSequenceNbr(nHeaderId), vLogicText);
9802: vLogicText := NULL;
9803: v_tSequenceNbr(nHeaderId) := v_tSequenceNbr(nHeaderId) + 1;
9804: END IF;

Line 9994: FROM cz_lce_headers head, cz_lce_texts text

9990:
9991: nDebug := 1110003;
9992:
9993: SELECT head.lce_header_id, max(text.seq_nbr) INTO nStructureHeaderId, nSequenceNbr
9994: FROM cz_lce_headers head, cz_lce_texts text
9995: WHERE head.deleted_flag = FLAG_NOT_DELETED
9996: AND head.net_type = LOGIC_NET_TYPE_STRUCTURE
9997: AND head.component_id = inComponentId
9998: AND head.lce_header_id = text.lce_header_id

Line 11073: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES

11069:
11070: --Flush the buffer
11071:
11072: IF(vLogicText IS NOT NULL)THEN
11073: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES
11074: (nStructureHeaderId, nSequenceNbr, vLogicText);
11075: vLogicText := NULL;
11076: END IF;
11077:

Line 11290: --Get the commit block size - the number of records inserted into cz_lce_texts

11286: --Database settings processing section
11287:
11288: BEGIN
11289:
11290: --Get the commit block size - the number of records inserted into cz_lce_texts
11291: --after which the transaction is commited, if commit is not disabled at all by
11292: --TwoPhaseCommit parameter set to 1.
11293:
11294: SELECT TO_NUMBER(value) INTO CommitBlockSize