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.PO_ATTRIBUTE_VALUES_PVT dependencies on PON_ATTRIBUTES_INTERFACE

Line 177: TYPE pon_attributes_typ IS TABLE OF pon_attributes_interface%ROWTYPE INDEX BY PLS_INTEGER;

173: TYPE attr_value_typ IS TABLE OF attr_values_csr%ROWTYPE INDEX BY PLS_INTEGER;
174: TYPE attr_value_tlp_typ IS TABLE OF attr_values_tlp_csr%ROWTYPE INDEX BY PLS_INTEGER;
175: TYPE descriptors_typ IS TABLE OF descriptors_csr%ROWTYPE INDEX BY PLS_INTEGER;
176: TYPE descriptors_tlp_typ IS TABLE OF descriptors_tlp_csr%ROWTYPE INDEX BY PLS_INTEGER;
177: TYPE pon_attributes_typ IS TABLE OF pon_attributes_interface%ROWTYPE INDEX BY PLS_INTEGER;
178:
179: PROCEDURE set_attribute_values
180: (
181: x_pon_attributes IN OUT NOCOPY pon_attributes_interface%ROWTYPE,

Line 181: x_pon_attributes IN OUT NOCOPY pon_attributes_interface%ROWTYPE,

177: TYPE pon_attributes_typ IS TABLE OF pon_attributes_interface%ROWTYPE INDEX BY PLS_INTEGER;
178:
179: PROCEDURE set_attribute_values
180: (
181: x_pon_attributes IN OUT NOCOPY pon_attributes_interface%ROWTYPE,
182: x_attr_values IN OUT NOCOPY attr_values_csr%ROWTYPE,
183: x_descriptors IN OUT NOCOPY descriptors_csr%ROWTYPE
184: );
185:

Line 188: x_pon_attributes IN OUT NOCOPY pon_attributes_interface%ROWTYPE,

184: );
185:
186: PROCEDURE set_attribute_values_tlp
187: (
188: x_pon_attributes IN OUT NOCOPY pon_attributes_interface%ROWTYPE,
189: x_attr_values_tlp IN OUT NOCOPY attr_values_tlp_csr%ROWTYPE,
190: x_descriptors_tlp IN OUT NOCOPY descriptors_tlp_csr%ROWTYPE
191: );
192:

Line 425: --insert data into pon_attributes_interface

421:
422: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'After set_attribute_values_tlp in loop'); END IF;
423:
424: l_progress := '280';
425: --insert data into pon_attributes_interface
426: FORALL i IN 1..l_pon_attributes.COUNT
427: INSERT INTO PON_ATTRIBUTES_INTERFACE VALUES l_pon_attributes(i);
428:
429: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in PON_ATTRIBUTES_INTERFACE='||SQL%rowcount); END IF;

Line 427: INSERT INTO PON_ATTRIBUTES_INTERFACE VALUES l_pon_attributes(i);

423:
424: l_progress := '280';
425: --insert data into pon_attributes_interface
426: FORALL i IN 1..l_pon_attributes.COUNT
427: INSERT INTO PON_ATTRIBUTES_INTERFACE VALUES l_pon_attributes(i);
428:
429: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in PON_ATTRIBUTES_INTERFACE='||SQL%rowcount); END IF;
430:
431: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;

Line 429: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in PON_ATTRIBUTES_INTERFACE='||SQL%rowcount); END IF;

425: --insert data into pon_attributes_interface
426: FORALL i IN 1..l_pon_attributes.COUNT
427: INSERT INTO PON_ATTRIBUTES_INTERFACE VALUES l_pon_attributes(i);
428:
429: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in PON_ATTRIBUTES_INTERFACE='||SQL%rowcount); END IF;
430:
431: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
432: EXCEPTION
433: WHEN OTHERS THEN

Line 454: -- A rows of PON_ATTRIBUTES_INTERFACE table carrying the attribute values

450: --
451: --Parameters:
452: --IN/OUT:
453: --x_pon_attributes
454: -- A rows of PON_ATTRIBUTES_INTERFACE table carrying the attribute values
455: --x_attr_values
456: -- Attribute values cursor row type.
457: --x_descriptors
458: -- descriptors_csr row type

Line 465: x_pon_attributes IN OUT NOCOPY pon_attributes_interface%ROWTYPE

461: --End of Comments
462: --------------------------------------------------------------------------------
463: PROCEDURE set_attribute_values
464: (
465: x_pon_attributes IN OUT NOCOPY pon_attributes_interface%ROWTYPE
466: , x_attr_values IN OUT NOCOPY attr_values_csr%ROWTYPE
467: , x_descriptors IN OUT NOCOPY descriptors_csr%ROWTYPE
468: )
469: IS

Line 486: x_pon_attributes.interface_line_number := x_attr_values.interface_line_number;

482: PO_LOG.proc_begin(d_mod,'x_descriptors.stored_in_column',x_descriptors.stored_in_column);
483: END IF;
484:
485: --move data from descriptors and attribute values into x_pon_attributes
486: x_pon_attributes.interface_line_number := x_attr_values.interface_line_number;
487: x_pon_attributes.interface_sequence_number := x_descriptors.sequence;
488: x_pon_attributes.attribute_name := x_descriptors.attribute_name;
489: x_pon_attributes.ip_category_id := NVL(x_descriptors.rt_category_id, -2); -- negative 2 means no category
490: x_pon_attributes.ip_descriptor_id := x_descriptors.attribute_id;

Line 487: x_pon_attributes.interface_sequence_number := x_descriptors.sequence;

483: END IF;
484:
485: --move data from descriptors and attribute values into x_pon_attributes
486: x_pon_attributes.interface_line_number := x_attr_values.interface_line_number;
487: x_pon_attributes.interface_sequence_number := x_descriptors.sequence;
488: x_pon_attributes.attribute_name := x_descriptors.attribute_name;
489: x_pon_attributes.ip_category_id := NVL(x_descriptors.rt_category_id, -2); -- negative 2 means no category
490: x_pon_attributes.ip_descriptor_id := x_descriptors.attribute_id;
491:

Line 1182: -- A rows of PON_ATTRIBUTES_INTERFACE table carrying the attribute values

1178: --
1179: --Parameters:
1180: --IN/OUT:
1181: --x_pon_attributes
1182: -- A rows of PON_ATTRIBUTES_INTERFACE table carrying the attribute values
1183: --x_attr_values_tlp
1184: -- Attribute values TLP cursor row type.
1185: --x_descriptors_tlp
1186: -- descriptors_tlp_csr row type

Line 1193: x_pon_attributes IN OUT NOCOPY pon_attributes_interface%ROWTYPE

1189: --End of Comments
1190: --------------------------------------------------------------------------------
1191: PROCEDURE set_attribute_values_tlp
1192: (
1193: x_pon_attributes IN OUT NOCOPY pon_attributes_interface%ROWTYPE
1194: , x_attr_values_tlp IN OUT NOCOPY attr_values_tlp_csr%ROWTYPE
1195: , x_descriptors_tlp IN OUT NOCOPY descriptors_tlp_csr%ROWTYPE
1196: )
1197: IS

Line 1214: x_pon_attributes.interface_line_number := x_attr_values_tlp.interface_line_number;

1210: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.stored_in_column',x_descriptors_tlp.stored_in_column);
1211: END IF;
1212:
1213: --move data from descriptors and attribute values into x_pon_attributes
1214: x_pon_attributes.interface_line_number := x_attr_values_tlp.interface_line_number;
1215: x_pon_attributes.interface_sequence_number := x_descriptors_tlp.sequence;
1216: x_pon_attributes.attribute_name := x_descriptors_tlp.attribute_name;
1217: x_pon_attributes.ip_category_id := NVL(x_descriptors_tlp.rt_category_id, -2); -- negative 2 means no category
1218: x_pon_attributes.ip_descriptor_id := x_descriptors_tlp.attribute_id;

Line 1215: x_pon_attributes.interface_sequence_number := x_descriptors_tlp.sequence;

1211: END IF;
1212:
1213: --move data from descriptors and attribute values into x_pon_attributes
1214: x_pon_attributes.interface_line_number := x_attr_values_tlp.interface_line_number;
1215: x_pon_attributes.interface_sequence_number := x_descriptors_tlp.sequence;
1216: x_pon_attributes.attribute_name := x_descriptors_tlp.attribute_name;
1217: x_pon_attributes.ip_category_id := NVL(x_descriptors_tlp.rt_category_id, -2); -- negative 2 means no category
1218: x_pon_attributes.ip_descriptor_id := x_descriptors_tlp.attribute_id;
1219: