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 387: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES

383: BEGIN
384: IF(vLogicLine IS NOT NULL)THEN
385: IF(LENGTHB(vLogicText) + LENGTHB(vLogicLine)>2000)THEN
386:
387: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES
388: (nStructureHeaderId, nSequenceNbr, vLogicText);
389: vLogicText := NULL;
390: nSequenceNbr := nSequenceNbr + 1;
391:

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

411: BEGIN
412: IF(vLogicLine IS NOT NULL)THEN
413: IF(LENGTHB(vLogicText) + LENGTHB(vLogicLine)>2000)THEN
414:
415: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES
416: (nStructureHeaderId, nSequenceNbr, vLogicText);
417: vLogicText := NULL;
418: nSequenceNbr := nSequenceNbr + 1;
419:

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

847: BEGIN
848: IF(vLogicLine IS NOT NULL)THEN
849: IF(LENGTHB(vLogicText) + LENGTHB(vLogicLine)>2000)THEN
850:
851: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES
852: (nHeaderId, v_tSequenceNbr(nHeaderId), vLogicText);
853: vLogicText := NULL;
854: v_tSequenceNbr(nHeaderId) := v_tSequenceNbr(nHeaderId) + 1;
855:

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

2140:
2141: --Flush off the buffer because we are about to write to another file
2142:
2143: IF(vLogicText IS NOT NULL)THEN
2144: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES
2145: (nHeaderId, v_tSequenceNbr(nHeaderId), vLogicText);
2146: vLogicText := NULL;
2147: v_tSequenceNbr(nHeaderId) := v_tSequenceNbr(nHeaderId) + 1;
2148: END IF;

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

2193:
2194: vLogicText := vLogicText || 'OBJECT ' || v_accuname || NewLine ||
2195: 'NOTTRUE ' || v_nodename || ' ' || v_accuname || ' ... ' || TO_CHAR(nReasonId) || NewLine;
2196:
2197: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES
2198: (v_HeaderId, vSeqNbrByHeader(v_HeaderId), vLogicText);
2199: vLogicText := NULL;
2200: vSeqNbrByHeader(v_HeaderId) := vSeqNbrByHeader(v_HeaderId) + 1;
2201:

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

3565:
3566: --Flush off the buffer because we are about to write to another file
3567:
3568: IF(vLogicText IS NOT NULL)THEN
3569: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES
3570: (nHeaderId, v_tSequenceNbr(nHeaderId), vLogicText);
3571: vLogicText := NULL;
3572: v_tSequenceNbr(nHeaderId) := v_tSequenceNbr(nHeaderId) + 1;
3573: END IF;

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

3619: vLogicText := vLogicText || 'TOTAL ' || v_accuname || NewLine ||
3620: 'INC ' || v_accuname || ' ' || v_nodename ||
3621: OperatorLiterals(OPERATOR_ROUND) || '... ' || TO_CHAR(nReasonId) || NewLine;
3622:
3623: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES
3624: (v_HeaderId, vSeqNbrByHeader(v_HeaderId), vLogicText);
3625: vLogicText := NULL;
3626: vSeqNbrByHeader(v_HeaderId) := vSeqNbrByHeader(v_HeaderId) + 1;
3627:

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

3815:
3816: --Flush off the buffer because we are about to write to another file.
3817:
3818: IF(vLogicText IS NOT NULL)THEN
3819: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES
3820: (nHeaderId, v_tSequenceNbr(nHeaderId), vLogicText);
3821: vLogicText := NULL;
3822: v_tSequenceNbr(nHeaderId) := v_tSequenceNbr(nHeaderId) + 1;
3823: END IF;

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

3871: vLogicText := vLogicText || 'TOTAL ' || v_accuname || NewLine ||
3872: 'CONTRIBUTE 1 ' || v_accuname || ' ' || v_nodename ||
3873: ' ... ' || TO_CHAR(nReasonId) || NewLine;
3874:
3875: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES
3876: (v_HeaderId, vSeqNbrByHeader(v_HeaderId), vLogicText);
3877:
3878: vLogicText := NULL;
3879: vSeqNbrByHeader(v_HeaderId) := vSeqNbrByHeader(v_HeaderId) + 1;

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

8009: 'EFF , , ' || NewLine || NewLine ||
8010: 'INC 1 ' || PATH_DELIMITER || 'parent' || PATH_DELIMITER || 'P_' ||
8011: localString || '_ACTUALCOUNT round' || NewLine;
8012:
8013: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES (nHeaderId, 1, vLogicLine);
8014:
8015: v_tIsHeaderGenerated(v_NodeId(i)) := nHeaderId;
8016: v_tSequenceNbr(nHeaderId) := 2;
8017: v_tLogicNetType(nHeaderId) := LOGIC_NET_TYPE_MANDATORY;

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

9146:
9147: IF(nHeaderId <> nPreviousHeaderId)THEN
9148:
9149: IF(vLogicText IS NOT NULL)THEN
9150: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES
9151: (nPreviousHeaderId, v_tSequenceNbr(nPreviousHeaderId), vLogicText);
9152: vLogicText := NULL;
9153: v_tSequenceNbr(nPreviousHeaderId) := v_tSequenceNbr(nPreviousHeaderId) + 1;
9154: END IF;

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

9720:
9721: IF(nHeaderId <> nPreviousHeaderId)THEN
9722:
9723: IF(vLogicText IS NOT NULL)THEN
9724: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES
9725: (nPreviousHeaderId, v_tSequenceNbr(nPreviousHeaderId), vLogicText);
9726: vLogicText := NULL;
9727: v_tSequenceNbr(nPreviousHeaderId) := v_tSequenceNbr(nPreviousHeaderId) + 1;
9728: END IF;

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

9764:
9765: --Flush off the buffer after rules generation
9766:
9767: IF(vLogicText IS NOT NULL)THEN
9768: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES
9769: (nHeaderId, v_tSequenceNbr(nHeaderId), vLogicText);
9770: vLogicText := NULL;
9771: v_tSequenceNbr(nHeaderId) := v_tSequenceNbr(nHeaderId) + 1;
9772: END IF;

Line 9962: FROM cz_lce_headers head, cz_lce_texts text

9958:
9959: nDebug := 1110003;
9960:
9961: SELECT head.lce_header_id, max(text.seq_nbr) INTO nStructureHeaderId, nSequenceNbr
9962: FROM cz_lce_headers head, cz_lce_texts text
9963: WHERE head.deleted_flag = FLAG_NOT_DELETED
9964: AND head.net_type = LOGIC_NET_TYPE_STRUCTURE
9965: AND head.component_id = inComponentId
9966: AND head.lce_header_id = text.lce_header_id

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

11037:
11038: --Flush the buffer
11039:
11040: IF(vLogicText IS NOT NULL)THEN
11041: INSERT INTO cz_lce_texts (lce_header_id, seq_nbr, lce_text) VALUES
11042: (nStructureHeaderId, nSequenceNbr, vLogicText);
11043: vLogicText := NULL;
11044: END IF;
11045:

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

11211: --Database settings processing section
11212:
11213: BEGIN
11214:
11215: --Get the commit block size - the number of records inserted into cz_lce_texts
11216: --after which the transaction is commited, if commit is not disabled at all by
11217: --TwoPhaseCommit parameter set to 1.
11218:
11219: SELECT TO_NUMBER(value) INTO CommitBlockSize