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 588: x_sync_attr_tlp_id_tbl OUT NOCOPY PO_TBL_NUMBER,

584: (
585: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
586: x_attr_values_tlp IN OUT NOCOPY PO_PDOI_TYPES.attr_values_tlp_rec_type,
587: x_merge_row_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
588: x_sync_attr_tlp_id_tbl OUT NOCOPY PO_TBL_NUMBER,
589: x_sync_draft_id_tbl OUT NOCOPY PO_TBL_NUMBER
590: ) IS
591:
592: d_api_name CONSTANT VARCHAR2(30) := 'check_attr_tlp_actions';

Line 589: x_sync_draft_id_tbl OUT NOCOPY PO_TBL_NUMBER

585: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
586: x_attr_values_tlp IN OUT NOCOPY PO_PDOI_TYPES.attr_values_tlp_rec_type,
587: x_merge_row_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
588: x_sync_attr_tlp_id_tbl OUT NOCOPY PO_TBL_NUMBER,
589: x_sync_draft_id_tbl OUT NOCOPY PO_TBL_NUMBER
590: ) IS
591:
592: d_api_name CONSTANT VARCHAR2(30) := 'check_attr_tlp_actions';
593: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 600: l_index_tbl PO_TBL_NUMBER;

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

Line 601: l_result_tbl PO_TBL_NUMBER;

597: l_key PO_SESSION_GT.key%TYPE;
598:
599: -- variables to save result read from po_session_gt
600: l_index_tbl PO_TBL_NUMBER;
601: l_result_tbl PO_TBL_NUMBER;
602: l_source_tbl PO_TBL_VARCHAR5; -- values can be 'draft' or 'txn'
603:
604: l_index NUMBER;
605: l_counter NUMBER;

Line 627: x_sync_attr_tlp_id_tbl := PO_TBL_NUMBER();

623: l_index := x_processing_row_tbl.NEXT(l_index);
624: END LOOP;
625: END IF;
626:
627: x_sync_attr_tlp_id_tbl := PO_TBL_NUMBER();
628: x_sync_draft_id_tbl := PO_TBL_NUMBER();
629:
630: l_key := PO_CORE_S.get_session_gt_nextval;
631:

Line 628: x_sync_draft_id_tbl := PO_TBL_NUMBER();

624: END LOOP;
625: END IF;
626:
627: x_sync_attr_tlp_id_tbl := PO_TBL_NUMBER();
628: x_sync_draft_id_tbl := PO_TBL_NUMBER();
629:
630: l_key := PO_CORE_S.get_session_gt_nextval;
631:
632: -- first check whether record exists in draft table

Line 798: l_draft_id_tbl PO_TBL_NUMBER;

794: d_api_name CONSTANT VARCHAR2(30) := 'add_default_attrs';
795: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
796: d_position NUMBER;
797:
798: l_draft_id_tbl PO_TBL_NUMBER;
799: l_po_line_id_tbl PO_TBL_NUMBER;
800: l_item_id_tbl PO_TBL_NUMBER;
801: l_ip_category_id_tbl PO_TBL_NUMBER;
802: l_item_desc_tbl PO_TBL_VARCHAR2000;

Line 799: l_po_line_id_tbl PO_TBL_NUMBER;

795: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
796: d_position NUMBER;
797:
798: l_draft_id_tbl PO_TBL_NUMBER;
799: l_po_line_id_tbl PO_TBL_NUMBER;
800: l_item_id_tbl PO_TBL_NUMBER;
801: l_ip_category_id_tbl PO_TBL_NUMBER;
802: l_item_desc_tbl PO_TBL_VARCHAR2000;
803: l_created_lang_tbl PO_TBL_VARCHAR5;

Line 800: l_item_id_tbl PO_TBL_NUMBER;

796: d_position NUMBER;
797:
798: l_draft_id_tbl PO_TBL_NUMBER;
799: l_po_line_id_tbl PO_TBL_NUMBER;
800: l_item_id_tbl PO_TBL_NUMBER;
801: l_ip_category_id_tbl PO_TBL_NUMBER;
802: l_item_desc_tbl PO_TBL_VARCHAR2000;
803: l_created_lang_tbl PO_TBL_VARCHAR5;
804:

Line 801: l_ip_category_id_tbl PO_TBL_NUMBER;

797:
798: l_draft_id_tbl PO_TBL_NUMBER;
799: l_po_line_id_tbl PO_TBL_NUMBER;
800: l_item_id_tbl PO_TBL_NUMBER;
801: l_ip_category_id_tbl PO_TBL_NUMBER;
802: l_item_desc_tbl PO_TBL_VARCHAR2000;
803: l_created_lang_tbl PO_TBL_VARCHAR5;
804:
805: -- Bug7039409: Declared new variables

Line 808: l_item_id_tbl2 PO_TBL_NUMBER; -- Different from l_item_id_tbl

804:
805: -- Bug7039409: Declared new variables
806: l_master_org_id PO_ATTRIBUTE_VALUES.org_id%TYPE;
807: l_inv_org_id PO_ATTRIBUTE_VALUES.org_id%TYPE;
808: l_item_id_tbl2 PO_TBL_NUMBER; -- Different from l_item_id_tbl
809: l_lead_time_tbl PO_TBL_NUMBER;
810: l_mfg_part_num_tbl PO_TBL_VARCHAR2000;
811: l_mfg_name_tbl PO_TBL_VARCHAR2000;
812: BEGIN

Line 809: l_lead_time_tbl PO_TBL_NUMBER;

805: -- Bug7039409: Declared new variables
806: l_master_org_id PO_ATTRIBUTE_VALUES.org_id%TYPE;
807: l_inv_org_id PO_ATTRIBUTE_VALUES.org_id%TYPE;
808: l_item_id_tbl2 PO_TBL_NUMBER; -- Different from l_item_id_tbl
809: l_lead_time_tbl PO_TBL_NUMBER;
810: l_mfg_part_num_tbl PO_TBL_VARCHAR2000;
811: l_mfg_name_tbl PO_TBL_VARCHAR2000;
812: BEGIN
813: d_position := 0;