APPS.ECE_POO_TRANSACTION dependencies on PO_RELEASES

Line 1511: v_entity_name := 'PO_RELEASES';

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

Line 2885: v_entity_name := 'PO_RELEASES';

2881: null);
2882:
2883: IF l_document_type = 'NR' THEN -- If this is a Release PO.
2884: xProgress := 'POOB-20-1481';
2885: v_entity_name := 'PO_RELEASES';
2886: v_pk1_value := nRelease_ID;
2887: if ec_debug.G_debug_level = 3 then
2888: ec_debug.pl(3,'release_id: ',nRelease_ID);
2889: end if;

Line 3407: FROM po_releases

3403: -- later for the archive call
3404: xProgress := 'POOB-30-1024';
3405: BEGIN
3406: SELECT po_release_id INTO l_release_id
3407: FROM po_releases
3408: WHERE release_num = release_number AND
3409: po_header_id = l_header_id;
3410:
3411: EXCEPTION

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

3409: po_header_id = l_header_id;
3410:
3411: EXCEPTION
3412: WHEN NO_DATA_FOUND THEN
3413: ec_debug.pl(0,'EC','ECE_NO_ROW_SELECTED','PROGRESS_LEVEL',xProgress,'INFO','PO RELEASE ID','TABLE_NAME','PO_RELEASES');
3414:
3415: END;
3416: if ec_debug.G_debug_level = 3 then
3417: ec_debug.pl(3, 'l_release_id: ',l_release_id);

Line 3422: UPDATE po_releases

3418: end if;
3419:
3420: -- Perform this update if this is a Release PO
3421: xProgress := 'POOB-30-1030';
3422: UPDATE po_releases
3423: SET last_update_date = SYSDATE,
3424: printed_date = SYSDATE,
3425: print_count = NVL(print_count,0) + 1,
3426: edi_processed_flag = 'Y'

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

3426: edi_processed_flag = 'Y'
3427: WHERE po_release_id = l_release_id;
3428:
3429: IF SQL%NOTFOUND THEN
3430: ec_debug.pl(0,'EC','ECE_NO_ROW_UPDATED','PROGRESS_LEVEL',xProgress,'INFO','EDI PROCESSED','TABLE_NAME','PO_RELEASES');
3431: END IF;
3432:
3433: -- Perform the same update for the Archive Table.
3434: xProgress := 'POOB-30-1040';

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.