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_PDOI_ATTR_PROCESS_PVT dependencies on PO_TBL_NUMBER

Line 212: x_sync_attr_id_tbl OUT NOCOPY PO_TBL_NUMBER,

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:
216: d_api_name CONSTANT VARCHAR2(30) := 'check_attr_actions';

Line 213: x_sync_draft_id_tbl OUT NOCOPY PO_TBL_NUMBER

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:
216: d_api_name CONSTANT VARCHAR2(30) := 'check_attr_actions';
217: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 224: l_index_tbl PO_TBL_NUMBER;

220: -- ket value used to identify records in po_session_gt table
221: l_key PO_SESSION_GT.key%TYPE;
222:
223: -- variables to save result read from po_session_gt
224: l_index_tbl PO_TBL_NUMBER;
225: l_result_tbl PO_TBL_NUMBER;
226: l_source_tbl PO_TBL_VARCHAR5; -- values can be 'draft' or 'txn'
227:
228: l_index NUMBER;

Line 225: l_result_tbl PO_TBL_NUMBER;

221: l_key PO_SESSION_GT.key%TYPE;
222:
223: -- variables to save result read from po_session_gt
224: l_index_tbl PO_TBL_NUMBER;
225: l_result_tbl PO_TBL_NUMBER;
226: l_source_tbl PO_TBL_VARCHAR5; -- values can be 'draft' or 'txn'
227:
228: l_index NUMBER;
229: l_counter NUMBER;

Line 247: x_sync_attr_id_tbl := PO_TBL_NUMBER();

243: l_index := x_processing_row_tbl.NEXT(l_index);
244: END LOOP;
245: END IF;
246:
247: x_sync_attr_id_tbl := PO_TBL_NUMBER();
248: x_sync_draft_id_tbl := PO_TBL_NUMBER();
249:
250: l_key := PO_CORE_S.get_session_gt_nextval;
251:

Line 248: x_sync_draft_id_tbl := PO_TBL_NUMBER();

244: END LOOP;
245: END IF;
246:
247: x_sync_attr_id_tbl := PO_TBL_NUMBER();
248: x_sync_draft_id_tbl := PO_TBL_NUMBER();
249:
250: l_key := PO_CORE_S.get_session_gt_nextval;
251:
252: -- first check whether record exists in draft table

Line 583: x_sync_attr_tlp_id_tbl OUT NOCOPY PO_TBL_NUMBER,

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:
587: d_api_name CONSTANT VARCHAR2(30) := 'check_attr_tlp_actions';

Line 584: x_sync_draft_id_tbl OUT NOCOPY PO_TBL_NUMBER

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:
587: d_api_name CONSTANT VARCHAR2(30) := 'check_attr_tlp_actions';
588: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 595: l_index_tbl PO_TBL_NUMBER;

591: -- ket value used to identify records in po_session_gt table
592: l_key PO_SESSION_GT.key%TYPE;
593:
594: -- variables to save result read from po_session_gt
595: l_index_tbl PO_TBL_NUMBER;
596: l_result_tbl PO_TBL_NUMBER;
597: l_source_tbl PO_TBL_VARCHAR5; -- values can be 'draft' or 'txn'
598:
599: l_index NUMBER;

Line 596: l_result_tbl PO_TBL_NUMBER;

592: l_key PO_SESSION_GT.key%TYPE;
593:
594: -- variables to save result read from po_session_gt
595: l_index_tbl PO_TBL_NUMBER;
596: l_result_tbl PO_TBL_NUMBER;
597: l_source_tbl PO_TBL_VARCHAR5; -- values can be 'draft' or 'txn'
598:
599: l_index NUMBER;
600: l_counter NUMBER;

Line 622: x_sync_attr_tlp_id_tbl := PO_TBL_NUMBER();

618: l_index := x_processing_row_tbl.NEXT(l_index);
619: END LOOP;
620: END IF;
621:
622: x_sync_attr_tlp_id_tbl := PO_TBL_NUMBER();
623: x_sync_draft_id_tbl := PO_TBL_NUMBER();
624:
625: l_key := PO_CORE_S.get_session_gt_nextval;
626:

Line 623: x_sync_draft_id_tbl := PO_TBL_NUMBER();

619: END LOOP;
620: END IF;
621:
622: x_sync_attr_tlp_id_tbl := PO_TBL_NUMBER();
623: x_sync_draft_id_tbl := PO_TBL_NUMBER();
624:
625: l_key := PO_CORE_S.get_session_gt_nextval;
626:
627: -- first check whether record exists in draft table

Line 790: l_draft_id_tbl PO_TBL_NUMBER;

786: d_api_name CONSTANT VARCHAR2(30) := 'add_default_attrs';
787: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
788: d_position NUMBER;
789:
790: l_draft_id_tbl PO_TBL_NUMBER;
791: l_po_line_id_tbl PO_TBL_NUMBER;
792: l_item_id_tbl PO_TBL_NUMBER;
793: l_ip_category_id_tbl PO_TBL_NUMBER;
794: l_item_desc_tbl PO_TBL_VARCHAR2000;

Line 791: l_po_line_id_tbl PO_TBL_NUMBER;

787: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
788: d_position NUMBER;
789:
790: l_draft_id_tbl PO_TBL_NUMBER;
791: l_po_line_id_tbl PO_TBL_NUMBER;
792: l_item_id_tbl PO_TBL_NUMBER;
793: l_ip_category_id_tbl PO_TBL_NUMBER;
794: l_item_desc_tbl PO_TBL_VARCHAR2000;
795: l_created_lang_tbl PO_TBL_VARCHAR5;

Line 792: l_item_id_tbl PO_TBL_NUMBER;

788: d_position NUMBER;
789:
790: l_draft_id_tbl PO_TBL_NUMBER;
791: l_po_line_id_tbl PO_TBL_NUMBER;
792: l_item_id_tbl PO_TBL_NUMBER;
793: l_ip_category_id_tbl PO_TBL_NUMBER;
794: l_item_desc_tbl PO_TBL_VARCHAR2000;
795: l_created_lang_tbl PO_TBL_VARCHAR5;
796:

Line 793: l_ip_category_id_tbl PO_TBL_NUMBER;

789:
790: l_draft_id_tbl PO_TBL_NUMBER;
791: l_po_line_id_tbl PO_TBL_NUMBER;
792: l_item_id_tbl PO_TBL_NUMBER;
793: l_ip_category_id_tbl PO_TBL_NUMBER;
794: l_item_desc_tbl PO_TBL_VARCHAR2000;
795: l_created_lang_tbl PO_TBL_VARCHAR5;
796:
797: -- Bug7039409: Declared new variables

Line 800: l_item_id_tbl2 PO_TBL_NUMBER; -- Different from l_item_id_tbl

796:
797: -- Bug7039409: Declared new variables
798: l_master_org_id PO_ATTRIBUTE_VALUES.org_id%TYPE;
799: l_inv_org_id PO_ATTRIBUTE_VALUES.org_id%TYPE;
800: l_item_id_tbl2 PO_TBL_NUMBER; -- Different from l_item_id_tbl
801: l_lead_time_tbl PO_TBL_NUMBER;
802: l_mfg_part_num_tbl PO_TBL_VARCHAR2000;
803: l_mfg_name_tbl PO_TBL_VARCHAR2000;
804: BEGIN

Line 801: l_lead_time_tbl PO_TBL_NUMBER;

797: -- Bug7039409: Declared new variables
798: l_master_org_id PO_ATTRIBUTE_VALUES.org_id%TYPE;
799: l_inv_org_id PO_ATTRIBUTE_VALUES.org_id%TYPE;
800: l_item_id_tbl2 PO_TBL_NUMBER; -- Different from l_item_id_tbl
801: l_lead_time_tbl PO_TBL_NUMBER;
802: l_mfg_part_num_tbl PO_TBL_VARCHAR2000;
803: l_mfg_name_tbl PO_TBL_VARCHAR2000;
804: BEGIN
805: d_position := 0;