DBA Data[Home] [Help]

APPS.ECE_POO_TRANSACTION dependencies on PO_RELEASES_ARCHIVE

Line 3435: UPDATE po_releases_archive

3431: END IF;
3432:
3433: -- Perform the same update for the Archive Table.
3434: xProgress := 'POOB-30-1040';
3435: UPDATE po_releases_archive
3436: SET last_update_date = SYSDATE,
3437: printed_date = SYSDATE,
3438: print_count = NVL(print_count,0) + 1,
3439: edi_processed_flag = 'Y'

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

3440: WHERE po_release_id = l_release_id AND
3441: latest_external_flag = 'Y';
3442:
3443: IF SQL%NOTFOUND THEN
3444: ec_debug.pl(0,'EC','ECE_NO_ROW_UPDATED','PROGRESS_LEVEL',xProgress,'INFO','EDI PROCESSED','TABLE_NAME','PO_RELEASES_ARCHIVE');
3445: END IF;
3446: END IF;
3447:
3448: -- Perform archiving by calling the archive proceedure.