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 455: AND NVL(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)

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

Line 456: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED

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

Line 532: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;

528: x_attr_values_tlp.attribute_values_tlp_id_tbl,
529:
530: -- initial value for error_flag
531: x_attr_values_tlp.error_flag_tbl
532: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
533:
534: IF (PO_LOG.d_proc) THEN
535: PO_LOG.proc_end (d_module);
536: END IF;

Line 862: AND intf_lines.action = PO_PDOI_CONSTANTS.g_ACTION_ADD

858: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
859: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
860: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
861: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
862: AND intf_lines.action = PO_PDOI_CONSTANTS.g_ACTION_ADD
863: AND intf_lines.po_line_id = draft_lines.po_line_id
864: AND intf_headers.draft_id = draft_lines.draft_id
865: AND draft_lines.po_header_id = draft_headers.po_header_id(+)
866: AND draft_lines.draft_id = draft_headers.draft_id(+)