APPS.ECE_POO_TRANSACTION dependencies on PO_HEADERS

Line 1518: v_entity_name := 'PO_HEADERS';

1514: ec_debug.pl(3,'release_id: ',l_header_tbl(nRelease_id_pos).value);
1515: end if;
1516: ELSE -- If this is a non-Release PO.
1517: xProgress := 'POOB-10-1504';
1518: v_entity_name := 'PO_HEADERS';
1519: v_pk1_value := l_header_tbl(nHeader_key_pos).value;
1520: if ec_debug.G_debug_level = 3 then
1521: ec_debug.pl(3,'po_header_id: ',l_header_tbl(nHeader_key_pos).value);
1522: end if;

Line 2892: v_entity_name := 'PO_HEADERS';

2888: ec_debug.pl(3,'release_id: ',nRelease_ID);
2889: end if;
2890: ELSE -- If this is a non-Release PO.
2891: xProgress := 'POOB-20-1482';
2892: v_entity_name := 'PO_HEADERS';
2893: v_pk1_value := n_po_header_id;
2894: if ec_debug.G_debug_level = 3 then
2895: ec_debug.pl(3,'po_header_id: ',n_po_header_id);
2896: end if;

Line 3359: FROM po_headers

3355: xProgress := 'POOB-30-1000';
3356: BEGIN
3357: SELECT po_header_id
3358: INTO l_header_id
3359: FROM po_headers
3360: WHERE segment1 = po_number AND
3361: type_lookup_code = po_type;
3362:
3363: EXCEPTION

Line 3365: ec_debug.pl(0,'EC','ECE_NO_ROW_SELECTED','PROGRESS_LEVEL',xProgress,'INFO','PO HEADER ID','TABLE_NAME','PO_HEADERS');

3361: type_lookup_code = po_type;
3362:
3363: EXCEPTION
3364: WHEN NO_DATA_FOUND THEN
3365: ec_debug.pl(0,'EC','ECE_NO_ROW_SELECTED','PROGRESS_LEVEL',xProgress,'INFO','PO HEADER ID','TABLE_NAME','PO_HEADERS');
3366:
3367: END;
3368: if ec_debug.G_debug_level = 3 then
3369: ec_debug.pl(3,'l_header_id: ',l_header_id);

Line 3376: UPDATE po_headers

3372: -- Perform the first update if this is a Standard or Blanket PO
3373: xProgress := 'POOB-30-1010';
3374: IF document_type NOT IN('NR','CR') THEN
3375: xProgress := 'POOB-30-1020';
3376: UPDATE po_headers
3377: SET last_update_date = SYSDATE,
3378: printed_date = SYSDATE,
3379: print_count = NVL(print_count,0) + 1,
3380: edi_processed_flag = 'Y'

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

3380: edi_processed_flag = 'Y'
3381: WHERE po_header_id = l_header_id;
3382:
3383: IF SQL%NOTFOUND THEN
3384: ec_debug.pl(0,'EC','ECE_NO_ROW_UPDATED','PROGRESS_LEVEL',xProgress,'INFO','EDI PROCESSED','TABLE_NAME','PO_HEADERS');
3385: END IF;
3386:
3387: -- Perform the same update for the Archive Table.
3388: xProgress := 'POOB-30-1022';

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