DBA Data[Home] [Help]

APPS.JAI_PO_TAX_PKG dependencies on JAI_PO_COPYDOC_T

Line 6693: Update JAI_PO_COPYDOC_T

6689: Otherwise it is not defaulting properly
6690: -------------------------------------------------------------------------------------------------------------------------*/
6691:
6692: IF p_type = 'L' THEN
6693: Update JAI_PO_COPYDOC_T
6694: Set po_header_id = p_po_hdr_id
6695: Where po_line_id = p_po_line_id;
6696: IF SQL%NOTFOUND
6697: THEN

Line 6701: Update JAI_PO_COPYDOC_T

6697: THEN
6698: RETURN;
6699: END IF;
6700: ELSE
6701: Update JAI_PO_COPYDOC_T
6702: Set po_header_id = p_po_hdr_id
6703: Where line_location_id = p_po_line_loc_id;
6704: IF SQL%NOTFOUND
6705: THEN

Line 6837: Delete From JAI_PO_COPYDOC_T

6833: END IF;
6834: END IF;
6835:
6836: IF p_type = 'L' THEN
6837: Delete From JAI_PO_COPYDOC_T
6838: Where po_line_id = p_po_line_id
6839: AND line_location_id is null;
6840: ELSE
6841: Delete From JAI_PO_COPYDOC_T

Line 6841: Delete From JAI_PO_COPYDOC_T

6837: Delete From JAI_PO_COPYDOC_T
6838: Where po_line_id = p_po_line_id
6839: AND line_location_id is null;
6840: ELSE
6841: Delete From JAI_PO_COPYDOC_T
6842: Where line_location_id = p_po_line_loc_id;
6843: END IF;
6844: EXCEPTION
6845: WHEN OTHERS THEN