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_PDOI_CONSTANTS

Line 82: AND NVL(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)

78: AND intf_attrs.processing_id = PO_PDOI_PARAMS.g_processing_id
79: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
80: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
81: AND intf_attrs.interface_attr_values_id > p_max_intf_attr_values_id
82: AND NVL(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
83: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
84: ORDER BY intf_attrs.interface_attr_values_id;
85:
86: IF (PO_LOG.d_proc) THEN

Line 83: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED

79: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
80: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
81: AND intf_attrs.interface_attr_values_id > p_max_intf_attr_values_id
82: AND NVL(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
83: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
84: ORDER BY intf_attrs.interface_attr_values_id;
85:
86: IF (PO_LOG.d_proc) THEN
87: PO_LOG.proc_end (d_module);

Line 156: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;

152: x_attr_values.attribute_values_id_tbl,
153:
154: -- initial value for error_flag
155: x_attr_values.error_flag_tbl
156: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
157:
158: IF (PO_LOG.d_proc) THEN
159: PO_LOG.proc_end (d_module);
160: END IF;

Line 451: AND NVL(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)

447: AND intf_attrs_tlp.processing_id = PO_PDOI_PARAMS.g_processing_id
448: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
449: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
450: AND intf_attrs_tlp.interface_attr_values_tlp_id > p_max_intf_attr_values_tlp_id
451: AND NVL(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
452: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
453: ORDER BY intf_attrs_tlp.interface_attr_values_tlp_id;
454:
455: IF (PO_LOG.d_proc) THEN

Line 452: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED

448: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
449: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
450: AND intf_attrs_tlp.interface_attr_values_tlp_id > p_max_intf_attr_values_tlp_id
451: AND NVL(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
452: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
453: ORDER BY intf_attrs_tlp.interface_attr_values_tlp_id;
454:
455: IF (PO_LOG.d_proc) THEN
456: PO_LOG.proc_end (d_module);

Line 527: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;

523: x_attr_values_tlp.attribute_values_tlp_id_tbl,
524:
525: -- initial value for error_flag
526: x_attr_values_tlp.error_flag_tbl
527: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
528:
529: IF (PO_LOG.d_proc) THEN
530: PO_LOG.proc_end (d_module);
531: END IF;

Line 854: AND intf_lines.action = PO_PDOI_CONSTANTS.g_ACTION_ADD

850: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
851: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
852: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
853: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
854: AND intf_lines.action = PO_PDOI_CONSTANTS.g_ACTION_ADD
855: AND intf_lines.po_line_id = draft_lines.po_line_id
856: AND intf_headers.draft_id = draft_lines.draft_id
857: AND draft_lines.po_header_id = draft_headers.po_header_id(+)
858: AND draft_lines.draft_id = draft_headers.draft_id(+)