DBA Data[Home] [Help]

APPS.ECE_POO_TRANSACTION dependencies on PO_HEADERS_ARCHIVE

Line 3389: UPDATE po_headers_archive

3385: END IF;
3386:
3387: -- Perform the same update for the Archive Table.
3388: xProgress := 'POOB-30-1022';
3389: UPDATE po_headers_archive
3390: SET last_update_date = SYSDATE,
3391: printed_date = SYSDATE,
3392: print_count = NVL(print_count,0) + 1,
3393: edi_processed_flag = 'Y'

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

3394: WHERE po_header_id = l_header_id AND
3395: latest_external_flag = 'Y';
3396:
3397: IF SQL%NOTFOUND THEN
3398: ec_debug.pl(0,'EC','ECE_NO_ROW_UPDATED','PROGRESS_LEVEL',xProgress,'INFO','EDI PROCESSED','TABLE_NAME','PO_HEADERS_ARCHIVE');
3399: END IF;
3400:
3401: ELSE
3402: -- Get the po_release_id, as it is needed here for the update and