DBA Data[Home] [Help]

APPS.ECE_POO_TRANSACTION dependencies on STANDARD

Line 1346: 'STANDARD' ,'NS',

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

Line 2843: 'STANDARD' ,'NS',

2839: /* Bug 2396394 Added the document type CONTRACT in SQL below */
2840:
2841: SELECT DECODE(l_header_tbl(nDocument_type_pos).value,
2842: 'BLANKET' ,'NB',
2843: 'STANDARD' ,'NS',
2844: 'PLANNED' ,'NP',
2845: 'RELEASE' ,'NR',
2846: 'BLANKET RELEASE' ,'NR',
2847: 'CONTRACT' ,'NC',

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

3368: if ec_debug.G_debug_level = 3 then
3369: ec_debug.pl(3,'l_header_id: ',l_header_id);
3370: end if;
3371:
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