DBA Data[Home] [Help]

APPS.ECE_POO_TRANSACTION dependencies on PO_HEADERS_ARCHIVE

Line 3422: UPDATE po_headers_archive

3418: END IF;
3419:
3420: -- Perform the same update for the Archive Table.
3421: xProgress := 'POOB-30-1022';
3422: UPDATE po_headers_archive
3423: SET last_update_date = SYSDATE,
3424: printed_date = SYSDATE,
3425: print_count = NVL(print_count,0) + 1,
3426: edi_processed_flag = 'Y'

Line 3431: ec_debug.pl(0,'EC','ECE_NO_ROW_UPDATED','PROGRESS_LEVEL',xProgress,'INFO','EDI PROCESSED','TABLE_NAME','PO_HEADERS_ARCHIVE');

3427: WHERE po_header_id = l_header_id AND
3428: latest_external_flag = 'Y';
3429:
3430: IF SQL%NOTFOUND THEN
3431: ec_debug.pl(0,'EC','ECE_NO_ROW_UPDATED','PROGRESS_LEVEL',xProgress,'INFO','EDI PROCESSED','TABLE_NAME','PO_HEADERS_ARCHIVE');
3432: END IF;
3433:
3434: ELSE
3435: -- Get the po_release_id, as it is needed here for the update and