APPS.PO_HEADERS_SV9 dependencies on PO_HEADERS_INTERFACE

Line 42: 'PO_HEADERS_INTERFACE',

38: null,
39: X_interface_header_id,
40: X_interface_line_id,
41: 'PO_PDOI_COLUMN_NOT_NULL',
42: 'PO_HEADERS_INTERFACE',
43: 'START_DATE',
44: 'COLUMN_NAME',
45: null,null,null,null,null,
46: 'START_DATE',

Line 60: 'PO_HEADERS_INTERFACE',

56: null,
57: X_interface_header_id,
58: X_interface_line_id,
59: 'PO_PDOI_INVALID_START_DATE',
60: 'PO_HEADERS_INTERFACE',
61: 'START_DATE',
62: 'VALUE',
63: null,null,null,null,null,
64: X_start_date,

Line 153: 'PO_HEADERS_INTERFACE',

149: null,
150: X_interface_header_id,
151: X_interface_line_id,
152: 'PO_PDOI_INVALID_ORIG_CATALOG',
153: 'PO_HEADERS_INTERFACE',
154: 'VENDOR_DOC_NUM',
155: 'DOC_NUMBER',
156: null,null,null,null,null,
157: X_vendor_doc_num ,

Line 170: 'PO_HEADERS_INTERFACE',

166: null,
167: X_interface_header_id,
168: X_interface_line_id,
169: 'PO_PDOI_INVAL_MULT_ORIG_CATG',
170: 'PO_HEADERS_INTERFACE',
171: 'VENDOR_DOC_NUM',
172: 'DOC_NUMBER',
173: null,null,null,null,null,
174: X_vendor_doc_num,

Line 223: x_table_name => 'PO_HEADERS_INTERFACE',

219: x_batch_id => null,
220: x_interface_header_id => X_interface_header_id,
221: x_interface_line_id => null,
222: x_error_message_name => 'PO_PDOI_ST_DATE_GT_REL_DATE',
223: x_table_name => 'PO_HEADERS_INTERFACE',
224: x_column_name => 'EFFECTIVE_DATE',
225: x_tokenname1 => null,
226: x_tokenname2 => null,
227: x_tokenname3 => null,

Line 257: x_table_name => 'PO_HEADERS_INTERFACE',

253: x_batch_id => null,
254: x_interface_header_id => X_interface_header_id,
255: x_interface_line_id => null,
256: x_error_message_name => 'PO_PDOI_GA_ST_DATE_GT_PO_DATE',
257: x_table_name => 'PO_HEADERS_INTERFACE',
258: x_column_name => 'EFFECTIVE_DATE',
259: x_tokenname1 => null,
260: x_tokenname2 => null,
261: x_tokenname3 => null,

Line 326: x_table_name => 'PO_HEADERS_INTERFACE',

322: x_batch_id => null,
323: x_interface_header_id => X_interface_header_id,
324: x_interface_line_id => null,
325: x_error_message_name => 'PO_PDOI_ST_DATE_GT_REL_DATE',
326: x_table_name => 'PO_HEADERS_INTERFACE',
327: x_column_name => 'EFFECTIVE_DATE',
328: x_tokenname1 => null,
329: x_tokenname2 => null,
330: x_tokenname3 => null,

Line 360: x_table_name => 'PO_HEADERS_INTERFACE',

356: x_batch_id => null,
357: x_interface_header_id => X_interface_header_id,
358: x_interface_line_id => null,
359: x_error_message_name => 'PO_PDOI_GA_ST_DATE_GT_PO_DATE',
360: x_table_name => 'PO_HEADERS_INTERFACE',
361: x_column_name => 'EFFECTIVE_DATE',
362: x_tokenname1 => null,
363: x_tokenname2 => null,
364: x_tokenname3 => null,

Line 425: x_tokenvalue po_headers_interface.vendor_doc_num%type; /* Bug3082104 */

421: x_temp2 binary_integer;
422: /* Cto Changes FPH start */
423: x_colname varchar2(20);
424: x_tokenname varchar2(20);
425: x_tokenvalue po_headers_interface.vendor_doc_num%type; /* Bug3082104 */
426: /* Cto Changes FPH end */
427:
428: --
429: -- added the following variables for PDOI enhancement.

Line 599: 'PO_HEADERS_INTERFACE',

595: null,
596: X_interface_header_id,
597: X_interface_line_id,
598: 'PO_PDOI_INVALID_ORIG_CATALOG',
599: 'PO_HEADERS_INTERFACE',
600: x_colname,
601: x_tokenname,
602: null,null,null,null,null,
603: x_tokenvalue ,

Line 617: x_table_name => 'PO_HEADERS_INTERFACE',

613: x_batch_id => null,
614: x_interface_header_id => X_interface_header_id,
615: x_interface_line_id => null,
616: x_error_message_name => 'PO_PDOI_INVALID_ORIG_STD_PO',
617: x_table_name => 'PO_HEADERS_INTERFACE',
618: x_column_name => x_colname,
619: x_tokenname1 => x_tokenname,
620: x_tokenname2 => null,
621: x_tokenname3 => null,

Line 652: 'PO_HEADERS_INTERFACE',

648: null,
649: X_interface_header_id,
650: X_interface_line_id,
651: 'PO_PDOI_INVAL_MULT_ORIG_CATG',
652: 'PO_HEADERS_INTERFACE',
653: x_colname,
654: x_tokenname,
655: null,null,null,null,null,
656: X_vendor_doc_num,

Line 670: x_table_name => 'PO_HEADERS_INTERFACE',

666: x_batch_id => null,
667: x_interface_header_id => X_interface_header_id,
668: x_interface_line_id => null,
669: x_error_message_name => 'PO_PDOI_MULTIPLE_STD_PO',
670: x_table_name => 'PO_HEADERS_INTERFACE',
671: x_column_name => x_colname,
672: x_tokenname1 => x_tokenname,
673: x_tokenname2 => null,
674: x_tokenname3 => null,

Line 776: x_table_name => 'PO_HEADERS_INTERFACE',

772: x_batch_id => null,
773: x_interface_header_id => X_interface_header_id,
774: x_interface_line_id => null,
775: x_error_message_name => 'PO_PDOI_STD_PO_INVALID_STATUS',
776: x_table_name => 'PO_HEADERS_INTERFACE',
777: x_column_name => x_colname,
778: x_tokenname1 => x_tokenname,
779: x_tokenname2 => null,
780: x_tokenname3 => null,

Line 801: update po_headers_interface

797: end if;
798:
799: -- update po_header_id in interface table
800:
801: update po_headers_interface
802: set po_header_id = x_po_header_id
803: where interface_header_id = X_interface_header_id; /* nwang, need this */
804:
805:

Line 894: 'PO_HEADERS_INTERFACE',

890: null,
891: X_interface_header_id,
892: X_interface_line_id,
893: 'PO_PDOI_CATG_ALREADY_EXISTS',
894: 'PO_HEADERS_INTERFACE',
895: 'VENDOR_DOC_NUM',
896: 'DOC_NUMBER',
897: null,null,null,null,null,
898: X_vendor_doc_num,