DBA Data[Home] [Help]

APPS.ECE_POO_TRANSACTION dependencies on STANDARD

Line 1350: 'STANDARD' ,'NS',

1346: BEGIN
1347: /* Bug 2396394 Added the document type CONTRACT in SQL below */
1348: SELECT DECODE(l_header_tbl(nDocument_type_pos).value,
1349: 'BLANKET' ,'NB',
1350: 'STANDARD' ,'NS',
1351: 'PLANNED' ,'NP',
1352: 'RELEASE' ,'NR',
1353: 'BLANKET RELEASE' ,'NR',
1354: 'CONTRACT' ,'NC',

Line 2876: 'STANDARD' ,'NS',

2872: /* Bug 2396394 Added the document type CONTRACT in SQL below */
2873:
2874: SELECT DECODE(l_header_tbl(nDocument_type_pos).value,
2875: 'BLANKET' ,'NB',
2876: 'STANDARD' ,'NS',
2877: 'PLANNED' ,'NP',
2878: 'RELEASE' ,'NR',
2879: 'BLANKET RELEASE' ,'NR',
2880: 'CONTRACT' ,'NC',

Line 3405: -- Perform the first update if this is a Standard or Blanket PO

3401: if ec_debug.G_debug_level = 3 then
3402: ec_debug.pl(3,'l_header_id: ',l_header_id);
3403: end if;
3404:
3405: -- Perform the first update if this is a Standard or Blanket PO
3406: xProgress := 'POOB-30-1010';
3407: IF document_type NOT IN('NR','CR') THEN
3408: xProgress := 'POOB-30-1020';
3409: UPDATE po_headers