APPS.ECE_POO_TRANSACTION dependencies on PO_RELEASES

Line 1515: v_entity_name := 'PO_RELEASES';

1511: IF v_header_att_enabled = 'Y' THEN
1512: xProgress := 'POOB-10-1502';
1513: IF l_document_type = 'NR' THEN -- If this is a Release PO.
1514: xProgress := 'POOB-10-1503';
1515: v_entity_name := 'PO_RELEASES';
1516: v_pk1_value := l_header_tbl(nRelease_id_pos).value;
1517: if ec_debug.G_debug_level = 3 then
1518: ec_debug.pl(3,'release_id: ',l_header_tbl(nRelease_id_pos).value);
1519: end if;

Line 2918: v_entity_name := 'PO_RELEASES';

2914: null);
2915:
2916: IF l_document_type = 'NR' THEN -- If this is a Release PO.
2917: xProgress := 'POOB-20-1481';
2918: v_entity_name := 'PO_RELEASES';
2919: v_pk1_value := nRelease_ID;
2920: if ec_debug.G_debug_level = 3 then
2921: ec_debug.pl(3,'release_id: ',nRelease_ID);
2922: end if;

Line 3440: FROM po_releases

3436: -- later for the archive call
3437: xProgress := 'POOB-30-1024';
3438: BEGIN
3439: SELECT po_release_id INTO l_release_id
3440: FROM po_releases
3441: WHERE release_num = release_number AND
3442: po_header_id = l_header_id;
3443:
3444: EXCEPTION

Line 3446: ec_debug.pl(0,'EC','ECE_NO_ROW_SELECTED','PROGRESS_LEVEL',xProgress,'INFO','PO RELEASE ID','TABLE_NAME','PO_RELEASES');

3442: po_header_id = l_header_id;
3443:
3444: EXCEPTION
3445: WHEN NO_DATA_FOUND THEN
3446: ec_debug.pl(0,'EC','ECE_NO_ROW_SELECTED','PROGRESS_LEVEL',xProgress,'INFO','PO RELEASE ID','TABLE_NAME','PO_RELEASES');
3447:
3448: END;
3449: if ec_debug.G_debug_level = 3 then
3450: ec_debug.pl(3, 'l_release_id: ',l_release_id);

Line 3455: UPDATE po_releases

3451: end if;
3452:
3453: -- Perform this update if this is a Release PO
3454: xProgress := 'POOB-30-1030';
3455: UPDATE po_releases
3456: SET last_update_date = SYSDATE,
3457: printed_date = SYSDATE,
3458: print_count = NVL(print_count,0) + 1,
3459: edi_processed_flag = 'Y'

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

3459: edi_processed_flag = 'Y'
3460: WHERE po_release_id = l_release_id;
3461:
3462: IF SQL%NOTFOUND THEN
3463: ec_debug.pl(0,'EC','ECE_NO_ROW_UPDATED','PROGRESS_LEVEL',xProgress,'INFO','EDI PROCESSED','TABLE_NAME','PO_RELEASES');
3464: END IF;
3465:
3466: -- Perform the same update for the Archive Table.
3467: xProgress := 'POOB-30-1040';

Line 3468: UPDATE po_releases_archive

3464: END IF;
3465:
3466: -- Perform the same update for the Archive Table.
3467: xProgress := 'POOB-30-1040';
3468: UPDATE po_releases_archive
3469: SET last_update_date = SYSDATE,
3470: printed_date = SYSDATE,
3471: print_count = NVL(print_count,0) + 1,
3472: edi_processed_flag = 'Y'

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

3473: WHERE po_release_id = l_release_id AND
3474: latest_external_flag = 'Y';
3475:
3476: IF SQL%NOTFOUND THEN
3477: ec_debug.pl(0,'EC','ECE_NO_ROW_UPDATED','PROGRESS_LEVEL',xProgress,'INFO','EDI PROCESSED','TABLE_NAME','PO_RELEASES_ARCHIVE');
3478: END IF;
3479: END IF;
3480:
3481: -- Perform archiving by calling the archive proceedure.