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.XNP_NUMBER_SPLITS$NUMBER_SPLIT dependencies on XNP_NUMBER_RANGES

Line 104: (L_NRE_OBJECT_REFERENCE XNP_NUMBER_RANGES.OBJECT_REFERENCE%TYPE

100: );
101: FORM_VAL FORM_REC;
102:
103: TYPE NBT_REC IS RECORD
104: (L_NRE_OBJECT_REFERENCE XNP_NUMBER_RANGES.OBJECT_REFERENCE%TYPE
105: ,L_NRE2_OBJECT_REFERENCE XNP_NUMBER_RANGES.OBJECT_REFERENCE%TYPE
106: ,L_NRE_STARTING_NUMBER XNP_NUMBER_RANGES.STARTING_NUMBER%TYPE
107: ,L_NRE_ENDING_NUMBER XNP_NUMBER_RANGES.ENDING_NUMBER%TYPE
108: ,L_NRE2_STARTING_NUMBER XNP_NUMBER_RANGES.STARTING_NUMBER%TYPE

Line 105: ,L_NRE2_OBJECT_REFERENCE XNP_NUMBER_RANGES.OBJECT_REFERENCE%TYPE

101: FORM_VAL FORM_REC;
102:
103: TYPE NBT_REC IS RECORD
104: (L_NRE_OBJECT_REFERENCE XNP_NUMBER_RANGES.OBJECT_REFERENCE%TYPE
105: ,L_NRE2_OBJECT_REFERENCE XNP_NUMBER_RANGES.OBJECT_REFERENCE%TYPE
106: ,L_NRE_STARTING_NUMBER XNP_NUMBER_RANGES.STARTING_NUMBER%TYPE
107: ,L_NRE_ENDING_NUMBER XNP_NUMBER_RANGES.ENDING_NUMBER%TYPE
108: ,L_NRE2_STARTING_NUMBER XNP_NUMBER_RANGES.STARTING_NUMBER%TYPE
109: ,L_NRE2_ENDING_NUMBER XNP_NUMBER_RANGES.ENDING_NUMBER%TYPE

Line 106: ,L_NRE_STARTING_NUMBER XNP_NUMBER_RANGES.STARTING_NUMBER%TYPE

102:
103: TYPE NBT_REC IS RECORD
104: (L_NRE_OBJECT_REFERENCE XNP_NUMBER_RANGES.OBJECT_REFERENCE%TYPE
105: ,L_NRE2_OBJECT_REFERENCE XNP_NUMBER_RANGES.OBJECT_REFERENCE%TYPE
106: ,L_NRE_STARTING_NUMBER XNP_NUMBER_RANGES.STARTING_NUMBER%TYPE
107: ,L_NRE_ENDING_NUMBER XNP_NUMBER_RANGES.ENDING_NUMBER%TYPE
108: ,L_NRE2_STARTING_NUMBER XNP_NUMBER_RANGES.STARTING_NUMBER%TYPE
109: ,L_NRE2_ENDING_NUMBER XNP_NUMBER_RANGES.ENDING_NUMBER%TYPE
110: );

Line 107: ,L_NRE_ENDING_NUMBER XNP_NUMBER_RANGES.ENDING_NUMBER%TYPE

103: TYPE NBT_REC IS RECORD
104: (L_NRE_OBJECT_REFERENCE XNP_NUMBER_RANGES.OBJECT_REFERENCE%TYPE
105: ,L_NRE2_OBJECT_REFERENCE XNP_NUMBER_RANGES.OBJECT_REFERENCE%TYPE
106: ,L_NRE_STARTING_NUMBER XNP_NUMBER_RANGES.STARTING_NUMBER%TYPE
107: ,L_NRE_ENDING_NUMBER XNP_NUMBER_RANGES.ENDING_NUMBER%TYPE
108: ,L_NRE2_STARTING_NUMBER XNP_NUMBER_RANGES.STARTING_NUMBER%TYPE
109: ,L_NRE2_ENDING_NUMBER XNP_NUMBER_RANGES.ENDING_NUMBER%TYPE
110: );
111: NBT_VAL NBT_REC;

Line 108: ,L_NRE2_STARTING_NUMBER XNP_NUMBER_RANGES.STARTING_NUMBER%TYPE

104: (L_NRE_OBJECT_REFERENCE XNP_NUMBER_RANGES.OBJECT_REFERENCE%TYPE
105: ,L_NRE2_OBJECT_REFERENCE XNP_NUMBER_RANGES.OBJECT_REFERENCE%TYPE
106: ,L_NRE_STARTING_NUMBER XNP_NUMBER_RANGES.STARTING_NUMBER%TYPE
107: ,L_NRE_ENDING_NUMBER XNP_NUMBER_RANGES.ENDING_NUMBER%TYPE
108: ,L_NRE2_STARTING_NUMBER XNP_NUMBER_RANGES.STARTING_NUMBER%TYPE
109: ,L_NRE2_ENDING_NUMBER XNP_NUMBER_RANGES.ENDING_NUMBER%TYPE
110: );
111: NBT_VAL NBT_REC;
112:

Line 109: ,L_NRE2_ENDING_NUMBER XNP_NUMBER_RANGES.ENDING_NUMBER%TYPE

105: ,L_NRE2_OBJECT_REFERENCE XNP_NUMBER_RANGES.OBJECT_REFERENCE%TYPE
106: ,L_NRE_STARTING_NUMBER XNP_NUMBER_RANGES.STARTING_NUMBER%TYPE
107: ,L_NRE_ENDING_NUMBER XNP_NUMBER_RANGES.ENDING_NUMBER%TYPE
108: ,L_NRE2_STARTING_NUMBER XNP_NUMBER_RANGES.STARTING_NUMBER%TYPE
109: ,L_NRE2_ENDING_NUMBER XNP_NUMBER_RANGES.ENDING_NUMBER%TYPE
110: );
111: NBT_VAL NBT_REC;
112:
113: ZONE_SQL VARCHAR2(3300) := null;

Line 131: from XNP_NUMBER_RANGES L_NRE2

127: Z_MODE in varchar2) return boolean is
128: begin
129: select L_NRE2.NUMBER_RANGE_ID
130: into CURR_VAL.NEW_NUMBER_RANGE_ID
131: from XNP_NUMBER_RANGES L_NRE2
132: where rownum = 1
133: and ( L_NRE2.OBJECT_REFERENCE = P_L_NRE2_OBJECT_REFERENCE )
134: and ( L_NRE2.STARTING_NUMBER = P_L_NRE2_STARTING_NUMBER )
135: and ( L_NRE2.ENDING_NUMBER = P_L_NRE2_ENDING_NUMBER );

Line 169: from XNP_NUMBER_RANGES L_NRE

165: Z_MODE in varchar2) return boolean is
166: begin
167: select L_NRE.NUMBER_RANGE_ID
168: into CURR_VAL.OLD_NUMBER_RANGE_ID
169: from XNP_NUMBER_RANGES L_NRE
170: where rownum = 1
171: and ( L_NRE.OBJECT_REFERENCE = P_L_NRE_OBJECT_REFERENCE )
172: and ( L_NRE.STARTING_NUMBER = P_L_NRE_STARTING_NUMBER )
173: and ( L_NRE.ENDING_NUMBER = P_L_NRE_ENDING_NUMBER );

Line 312: from XNP_NUMBER_RANGES L_NRE2

308: select L_NRE2.NUMBER_RANGE_ID NEW_NUMBER_RANGE_ID
309: , L_NRE2.OBJECT_REFERENCE L_NRE2_OBJECT_REFERENCE
310: , L_NRE2.STARTING_NUMBER L_NRE2_STARTING_NUMBER
311: , L_NRE2.ENDING_NUMBER L_NRE2_ENDING_NUMBER
312: from XNP_NUMBER_RANGES L_NRE2
313: where L_NRE2.OBJECT_REFERENCE like upper(srch)
314: order by L_NRE2.OBJECT_REFERENCE;
315: begin
316: for c1rec in c1(Z_MODE,L_SEARCH_STRING) loop

Line 468: from XNP_NUMBER_RANGES L_NRE

464: select L_NRE.NUMBER_RANGE_ID OLD_NUMBER_RANGE_ID
465: , L_NRE.OBJECT_REFERENCE L_NRE_OBJECT_REFERENCE
466: , L_NRE.STARTING_NUMBER L_NRE_STARTING_NUMBER
467: , L_NRE.ENDING_NUMBER L_NRE_ENDING_NUMBER
468: from XNP_NUMBER_RANGES L_NRE
469: where L_NRE.OBJECT_REFERENCE like upper(srch)
470: order by L_NRE.OBJECT_REFERENCE;
471: begin
472: for c1rec in c1(Z_MODE,L_SEARCH_STRING) loop

Line 847: XNP_NUMBER_RANGES L_NRE,

843: L_NRE2.OBJECT_REFERENCE,
844: NST.PERMISSIVE_DIAL_START_DATE,
845: NST.PERMISSIVE_DIAL_END_DATE
846: FROM XNP_NUMBER_SPLITS NST,
847: XNP_NUMBER_RANGES L_NRE,
848: XNP_NUMBER_RANGES L_NRE2';
849:
850: ZONE_SQL := ZONE_SQL || I_WHERE;
851: ZONE_SQL := ZONE_SQL || ' ORDER BY NST.OLD_NUMBER_RANGE_ID,

Line 848: XNP_NUMBER_RANGES L_NRE2';

844: NST.PERMISSIVE_DIAL_START_DATE,
845: NST.PERMISSIVE_DIAL_END_DATE
846: FROM XNP_NUMBER_SPLITS NST,
847: XNP_NUMBER_RANGES L_NRE,
848: XNP_NUMBER_RANGES L_NRE2';
849:
850: ZONE_SQL := ZONE_SQL || I_WHERE;
851: ZONE_SQL := ZONE_SQL || ' ORDER BY NST.OLD_NUMBER_RANGE_ID,
852: L_NRE.OBJECT_REFERENCE,

Line 1160: XNP_NUMBER_RANGES L_NRE,

1156: NBT_VAL.L_NRE_ENDING_NUMBER,
1157: NBT_VAL.L_NRE2_STARTING_NUMBER,
1158: NBT_VAL.L_NRE2_ENDING_NUMBER
1159: FROM XNP_NUMBER_SPLITS NST,
1160: XNP_NUMBER_RANGES L_NRE,
1161: XNP_NUMBER_RANGES L_NRE2
1162: WHERE NST.NUMBER_SPLIT_ID = CURR_VAL.NUMBER_SPLIT_ID
1163: AND L_NRE.NUMBER_RANGE_ID = NST.OLD_NUMBER_RANGE_ID
1164: AND L_NRE2.NUMBER_RANGE_ID = NST.NEW_NUMBER_RANGE_ID

Line 1161: XNP_NUMBER_RANGES L_NRE2

1157: NBT_VAL.L_NRE2_STARTING_NUMBER,
1158: NBT_VAL.L_NRE2_ENDING_NUMBER
1159: FROM XNP_NUMBER_SPLITS NST,
1160: XNP_NUMBER_RANGES L_NRE,
1161: XNP_NUMBER_RANGES L_NRE2
1162: WHERE NST.NUMBER_SPLIT_ID = CURR_VAL.NUMBER_SPLIT_ID
1163: AND L_NRE.NUMBER_RANGE_ID = NST.OLD_NUMBER_RANGE_ID
1164: AND L_NRE2.NUMBER_RANGE_ID = NST.NEW_NUMBER_RANGE_ID
1165: ;

Line 1194: XNP_NUMBER_RANGES L_NRE,

1190: NBT_VAL.L_NRE2_STARTING_NUMBER,
1191: NBT_VAL.L_NRE2_ENDING_NUMBER,
1192: CURR_VAL.CONVERSION_PROCEDURE
1193: FROM XNP_NUMBER_SPLITS NST,
1194: XNP_NUMBER_RANGES L_NRE,
1195: XNP_NUMBER_RANGES L_NRE2
1196: WHERE NST.NUMBER_SPLIT_ID = CURR_VAL.NUMBER_SPLIT_ID
1197: AND L_NRE.NUMBER_RANGE_ID = NST.OLD_NUMBER_RANGE_ID
1198: AND L_NRE2.NUMBER_RANGE_ID = NST.NEW_NUMBER_RANGE_ID

Line 1195: XNP_NUMBER_RANGES L_NRE2

1191: NBT_VAL.L_NRE2_ENDING_NUMBER,
1192: CURR_VAL.CONVERSION_PROCEDURE
1193: FROM XNP_NUMBER_SPLITS NST,
1194: XNP_NUMBER_RANGES L_NRE,
1195: XNP_NUMBER_RANGES L_NRE2
1196: WHERE NST.NUMBER_SPLIT_ID = CURR_VAL.NUMBER_SPLIT_ID
1197: AND L_NRE.NUMBER_RANGE_ID = NST.OLD_NUMBER_RANGE_ID
1198: AND L_NRE2.NUMBER_RANGE_ID = NST.NEW_NUMBER_RANGE_ID
1199: ;