DBA Data[Home] [Help]

APPS.JAI_PO_TAX_PKG dependencies on JAI_PO_COPYDOC_T

Line 5304: Update JAI_PO_COPYDOC_T

5300: Otherwise it is not defaulting properly
5301: -------------------------------------------------------------------------------------------------------------------------*/
5302:
5303: IF p_type = 'L' THEN
5304: Update JAI_PO_COPYDOC_T
5305: Set po_header_id = p_po_hdr_id
5306: Where po_line_id = p_po_line_id;
5307: IF SQL%NOTFOUND
5308: THEN

Line 5312: Update JAI_PO_COPYDOC_T

5308: THEN
5309: RETURN;
5310: END IF;
5311: ELSE
5312: Update JAI_PO_COPYDOC_T
5313: Set po_header_id = p_po_hdr_id
5314: Where line_location_id = p_po_line_loc_id;
5315: IF SQL%NOTFOUND
5316: THEN

Line 5448: Delete From JAI_PO_COPYDOC_T

5444: END IF;
5445: END IF;
5446:
5447: IF p_type = 'L' THEN
5448: Delete From JAI_PO_COPYDOC_T
5449: Where po_line_id = p_po_line_id
5450: AND line_location_id is null;
5451: ELSE
5452: Delete From JAI_PO_COPYDOC_T

Line 5452: Delete From JAI_PO_COPYDOC_T

5448: Delete From JAI_PO_COPYDOC_T
5449: Where po_line_id = p_po_line_id
5450: AND line_location_id is null;
5451: ELSE
5452: Delete From JAI_PO_COPYDOC_T
5453: Where line_location_id = p_po_line_loc_id;
5454: END IF;
5455: EXCEPTION
5456: WHEN OTHERS THEN