APPS.PO_PDOI_ATTR_PROCESS_PVT dependencies on DBMS_SQL

Line 209: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

205: --End of Comments
206: ------------------------------------------------------------------------
207: PROCEDURE check_attr_actions
208: (
209: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
210: x_attr_values IN OUT NOCOPY PO_PDOI_TYPES.attr_values_rec_type,
211: x_merge_row_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
212: x_sync_attr_id_tbl OUT NOCOPY PO_TBL_NUMBER,
213: x_sync_draft_id_tbl OUT NOCOPY PO_TBL_NUMBER

Line 211: x_merge_row_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

207: PROCEDURE check_attr_actions
208: (
209: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
210: x_attr_values IN OUT NOCOPY PO_PDOI_TYPES.attr_values_rec_type,
211: x_merge_row_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
212: x_sync_attr_id_tbl OUT NOCOPY PO_TBL_NUMBER,
213: x_sync_draft_id_tbl OUT NOCOPY PO_TBL_NUMBER
214: ) IS
215:

Line 232: l_attr_ref_tbl DBMS_SQL.NUMBER_TABLE;

228: l_index NUMBER;
229: l_counter NUMBER;
230:
231: -- hash table to track whether same po_line_id exist within batch
232: l_attr_ref_tbl DBMS_SQL.NUMBER_TABLE;
233: BEGIN
234: d_position := 0;
235:
236: IF (PO_LOG.d_proc) THEN

Line 580: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

576: --End of Comments
577: ------------------------------------------------------------------------
578: PROCEDURE check_attr_tlp_actions
579: (
580: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
581: x_attr_values_tlp IN OUT NOCOPY PO_PDOI_TYPES.attr_values_tlp_rec_type,
582: x_merge_row_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
583: x_sync_attr_tlp_id_tbl OUT NOCOPY PO_TBL_NUMBER,
584: x_sync_draft_id_tbl OUT NOCOPY PO_TBL_NUMBER

Line 582: x_merge_row_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

578: PROCEDURE check_attr_tlp_actions
579: (
580: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
581: x_attr_values_tlp IN OUT NOCOPY PO_PDOI_TYPES.attr_values_tlp_rec_type,
582: x_merge_row_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
583: x_sync_attr_tlp_id_tbl OUT NOCOPY PO_TBL_NUMBER,
584: x_sync_draft_id_tbl OUT NOCOPY PO_TBL_NUMBER
585: ) IS
586:

Line 606: TYPE attr_tlp_ref_type IS TABLE OF DBMS_SQL.NUMBER_TABLE INDEX BY VARCHAR2(4);

602: l_po_line_id NUMBER;
603: l_lang VARCHAR2(4);
604:
605: -- hash table to track whether rows with same po_line_id and language exist within batch
606: TYPE attr_tlp_ref_type IS TABLE OF DBMS_SQL.NUMBER_TABLE INDEX BY VARCHAR2(4);
607: l_attr_tlp_ref_tbl attr_tlp_ref_type;
608: BEGIN
609: d_position := 0;
610: