eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_DOCUMENT_CHECKS_GRP dependencies on PO_TBL_NUMBER

Line 116: l_document_id_tbl po_tbl_number;

112: l_api_version CONSTANT NUMBER := 1.1;
113: l_progress VARCHAR2(3);
114:
115: l_document_id NUMBER;
116: l_document_id_tbl po_tbl_number;
117:
118: l_doc_id NUMBER;
119:
120: l_consigned_flag PO_HEADERS_ALL.CONSIGNED_CONSUMPTION_FLAG%TYPE;

Line 147: , p_doc_level_id_tbl => po_tbl_number( p_document_level_id )

143:
144: PO_CORE_S.get_document_ids(
145: p_doc_type => p_document_type
146: , p_doc_level => p_document_level
147: , p_doc_level_id_tbl => po_tbl_number( p_document_level_id )
148: , x_doc_id_tbl => l_document_id_tbl
149: );
150:
151: l_document_id := l_document_id_tbl(1);

Line 937: p_header_id IN OUT NOCOPY PO_TBL_NUMBER,

933: --End of Comments
934: -------------------------------------------------------------------------------
935: PROCEDURE validate_status_check_inputs (
936: p_api_version IN NUMBER,
937: p_header_id IN OUT NOCOPY PO_TBL_NUMBER,
938: p_release_id IN OUT NOCOPY PO_TBL_NUMBER,
939: p_document_type IN OUT NOCOPY PO_TBL_VARCHAR30,
940: p_document_subtype IN OUT NOCOPY PO_TBL_VARCHAR30,
941: p_document_num IN OUT NOCOPY PO_TBL_VARCHAR30,

Line 938: p_release_id IN OUT NOCOPY PO_TBL_NUMBER,

934: -------------------------------------------------------------------------------
935: PROCEDURE validate_status_check_inputs (
936: p_api_version IN NUMBER,
937: p_header_id IN OUT NOCOPY PO_TBL_NUMBER,
938: p_release_id IN OUT NOCOPY PO_TBL_NUMBER,
939: p_document_type IN OUT NOCOPY PO_TBL_VARCHAR30,
940: p_document_subtype IN OUT NOCOPY PO_TBL_VARCHAR30,
941: p_document_num IN OUT NOCOPY PO_TBL_VARCHAR30,
942: p_vendor_order_num IN OUT NOCOPY PO_TBL_VARCHAR30,

Line 943: p_line_id IN OUT NOCOPY PO_TBL_NUMBER,

939: p_document_type IN OUT NOCOPY PO_TBL_VARCHAR30,
940: p_document_subtype IN OUT NOCOPY PO_TBL_VARCHAR30,
941: p_document_num IN OUT NOCOPY PO_TBL_VARCHAR30,
942: p_vendor_order_num IN OUT NOCOPY PO_TBL_VARCHAR30,
943: p_line_id IN OUT NOCOPY PO_TBL_NUMBER,
944: p_line_location_id IN OUT NOCOPY PO_TBL_NUMBER,
945: p_distribution_id IN OUT NOCOPY PO_TBL_NUMBER,
946: p_mode IN VARCHAR2,
947: p_lock_flag IN VARCHAR2 := 'N',

Line 944: p_line_location_id IN OUT NOCOPY PO_TBL_NUMBER,

940: p_document_subtype IN OUT NOCOPY PO_TBL_VARCHAR30,
941: p_document_num IN OUT NOCOPY PO_TBL_VARCHAR30,
942: p_vendor_order_num IN OUT NOCOPY PO_TBL_VARCHAR30,
943: p_line_id IN OUT NOCOPY PO_TBL_NUMBER,
944: p_line_location_id IN OUT NOCOPY PO_TBL_NUMBER,
945: p_distribution_id IN OUT NOCOPY PO_TBL_NUMBER,
946: p_mode IN VARCHAR2,
947: p_lock_flag IN VARCHAR2 := 'N',
948: x_po_status_rec OUT NOCOPY PO_STATUS_REC_TYPE,

Line 945: p_distribution_id IN OUT NOCOPY PO_TBL_NUMBER,

941: p_document_num IN OUT NOCOPY PO_TBL_VARCHAR30,
942: p_vendor_order_num IN OUT NOCOPY PO_TBL_VARCHAR30,
943: p_line_id IN OUT NOCOPY PO_TBL_NUMBER,
944: p_line_location_id IN OUT NOCOPY PO_TBL_NUMBER,
945: p_distribution_id IN OUT NOCOPY PO_TBL_NUMBER,
946: p_mode IN VARCHAR2,
947: p_lock_flag IN VARCHAR2 := 'N',
948: x_po_status_rec OUT NOCOPY PO_STATUS_REC_TYPE,
949: x_return_status OUT NOCOPY VARCHAR2

Line 955: l_dummy_table_number po_tbl_number := po_tbl_number();

951:
952: l_api_name CONSTANT VARCHAR(30) := 'VALIDATE_STATUS_CHECK_INPUTS';
953: l_progress VARCHAR2(3) := '000';
954: l_count NUMBER;
955: l_dummy_table_number po_tbl_number := po_tbl_number();
956: l_dummy_table_varchar30 po_tbl_varchar30 := po_tbl_varchar30();
957:
958: BEGIN
959:

Line 1077: p_header_id IN PO_TBL_NUMBER,

1073: --End of Comments
1074: -------------------------------------------------------------------------------
1075: PROCEDURE po_status_check (
1076: p_api_version IN NUMBER,
1077: p_header_id IN PO_TBL_NUMBER,
1078: p_release_id IN PO_TBL_NUMBER,
1079: p_document_type IN PO_TBL_VARCHAR30,
1080: p_document_subtype IN PO_TBL_VARCHAR30,
1081: p_document_num IN PO_TBL_VARCHAR30,

Line 1078: p_release_id IN PO_TBL_NUMBER,

1074: -------------------------------------------------------------------------------
1075: PROCEDURE po_status_check (
1076: p_api_version IN NUMBER,
1077: p_header_id IN PO_TBL_NUMBER,
1078: p_release_id IN PO_TBL_NUMBER,
1079: p_document_type IN PO_TBL_VARCHAR30,
1080: p_document_subtype IN PO_TBL_VARCHAR30,
1081: p_document_num IN PO_TBL_VARCHAR30,
1082: p_vendor_order_num IN PO_TBL_VARCHAR30,

Line 1083: p_line_id IN PO_TBL_NUMBER,

1079: p_document_type IN PO_TBL_VARCHAR30,
1080: p_document_subtype IN PO_TBL_VARCHAR30,
1081: p_document_num IN PO_TBL_VARCHAR30,
1082: p_vendor_order_num IN PO_TBL_VARCHAR30,
1083: p_line_id IN PO_TBL_NUMBER,
1084: p_line_location_id IN PO_TBL_NUMBER,
1085: p_distribution_id IN PO_TBL_NUMBER,
1086: p_mode IN VARCHAR2,
1087: p_lock_flag IN VARCHAR2 := 'N',

Line 1084: p_line_location_id IN PO_TBL_NUMBER,

1080: p_document_subtype IN PO_TBL_VARCHAR30,
1081: p_document_num IN PO_TBL_VARCHAR30,
1082: p_vendor_order_num IN PO_TBL_VARCHAR30,
1083: p_line_id IN PO_TBL_NUMBER,
1084: p_line_location_id IN PO_TBL_NUMBER,
1085: p_distribution_id IN PO_TBL_NUMBER,
1086: p_mode IN VARCHAR2,
1087: p_lock_flag IN VARCHAR2 := 'N',
1088: p_calling_module IN VARCHAR2 := NULL, -- PDOI Rewrite R12

Line 1085: p_distribution_id IN PO_TBL_NUMBER,

1081: p_document_num IN PO_TBL_VARCHAR30,
1082: p_vendor_order_num IN PO_TBL_VARCHAR30,
1083: p_line_id IN PO_TBL_NUMBER,
1084: p_line_location_id IN PO_TBL_NUMBER,
1085: p_distribution_id IN PO_TBL_NUMBER,
1086: p_mode IN VARCHAR2,
1087: p_lock_flag IN VARCHAR2 := 'N',
1088: p_calling_module IN VARCHAR2 := NULL, -- PDOI Rewrite R12
1089: p_role IN VARCHAR2 := NULL, -- PDOI Rewrite R12

Line 1095: l_header_id PO_TBL_NUMBER := p_header_id;

1091: x_po_status_rec OUT NOCOPY PO_STATUS_REC_TYPE,
1092: x_return_status OUT NOCOPY VARCHAR2
1093: ) IS
1094:
1095: l_header_id PO_TBL_NUMBER := p_header_id;
1096: l_release_id PO_TBL_NUMBER := p_release_id;
1097: l_document_type PO_TBL_VARCHAR30 := p_document_type;
1098: l_document_subtype PO_TBL_VARCHAR30 := p_document_subtype;
1099: l_document_num PO_TBL_VARCHAR30 := p_document_num;

Line 1096: l_release_id PO_TBL_NUMBER := p_release_id;

1092: x_return_status OUT NOCOPY VARCHAR2
1093: ) IS
1094:
1095: l_header_id PO_TBL_NUMBER := p_header_id;
1096: l_release_id PO_TBL_NUMBER := p_release_id;
1097: l_document_type PO_TBL_VARCHAR30 := p_document_type;
1098: l_document_subtype PO_TBL_VARCHAR30 := p_document_subtype;
1099: l_document_num PO_TBL_VARCHAR30 := p_document_num;
1100: l_vendor_order_num PO_TBL_VARCHAR30 := p_vendor_order_num;

Line 1101: l_line_id PO_TBL_NUMBER := p_line_id;

1097: l_document_type PO_TBL_VARCHAR30 := p_document_type;
1098: l_document_subtype PO_TBL_VARCHAR30 := p_document_subtype;
1099: l_document_num PO_TBL_VARCHAR30 := p_document_num;
1100: l_vendor_order_num PO_TBL_VARCHAR30 := p_vendor_order_num;
1101: l_line_id PO_TBL_NUMBER := p_line_id;
1102: l_line_location_id PO_TBL_NUMBER := p_line_location_id;
1103: l_distribution_id PO_TBL_NUMBER := p_distribution_id;
1104:
1105: l_api_name CONSTANT VARCHAR(30) := 'PO_STATUS_CHECK';

Line 1102: l_line_location_id PO_TBL_NUMBER := p_line_location_id;

1098: l_document_subtype PO_TBL_VARCHAR30 := p_document_subtype;
1099: l_document_num PO_TBL_VARCHAR30 := p_document_num;
1100: l_vendor_order_num PO_TBL_VARCHAR30 := p_vendor_order_num;
1101: l_line_id PO_TBL_NUMBER := p_line_id;
1102: l_line_location_id PO_TBL_NUMBER := p_line_location_id;
1103: l_distribution_id PO_TBL_NUMBER := p_distribution_id;
1104:
1105: l_api_name CONSTANT VARCHAR(30) := 'PO_STATUS_CHECK';
1106: l_api_version CONSTANT NUMBER := 1.0;

Line 1103: l_distribution_id PO_TBL_NUMBER := p_distribution_id;

1099: l_document_num PO_TBL_VARCHAR30 := p_document_num;
1100: l_vendor_order_num PO_TBL_VARCHAR30 := p_vendor_order_num;
1101: l_line_id PO_TBL_NUMBER := p_line_id;
1102: l_line_location_id PO_TBL_NUMBER := p_line_location_id;
1103: l_distribution_id PO_TBL_NUMBER := p_distribution_id;
1104:
1105: l_api_name CONSTANT VARCHAR(30) := 'PO_STATUS_CHECK';
1106: l_api_version CONSTANT NUMBER := 1.0;
1107: l_progress VARCHAR2(3) := '000';

Line 1225: p_header_id => PO_TBL_NUMBER(p_header_id),

1221: -- creating size=1 Tables of IDs 1 with value of the scalar input IDs
1222: l_progress := '010';
1223: PO_DOCUMENT_CHECKS_GRP.po_status_check(
1224: p_api_version => p_api_version,
1225: p_header_id => PO_TBL_NUMBER(p_header_id),
1226: p_release_id => PO_TBL_NUMBER(p_release_id),
1227: p_document_type => PO_TBL_VARCHAR30(p_document_type),
1228: p_document_subtype => PO_TBL_VARCHAR30(p_document_subtype),
1229: p_document_num => PO_TBL_VARCHAR30(p_document_num),

Line 1226: p_release_id => PO_TBL_NUMBER(p_release_id),

1222: l_progress := '010';
1223: PO_DOCUMENT_CHECKS_GRP.po_status_check(
1224: p_api_version => p_api_version,
1225: p_header_id => PO_TBL_NUMBER(p_header_id),
1226: p_release_id => PO_TBL_NUMBER(p_release_id),
1227: p_document_type => PO_TBL_VARCHAR30(p_document_type),
1228: p_document_subtype => PO_TBL_VARCHAR30(p_document_subtype),
1229: p_document_num => PO_TBL_VARCHAR30(p_document_num),
1230: p_vendor_order_num => PO_TBL_VARCHAR30(p_vendor_order_num),

Line 1231: p_line_id => PO_TBL_NUMBER(p_line_id),

1227: p_document_type => PO_TBL_VARCHAR30(p_document_type),
1228: p_document_subtype => PO_TBL_VARCHAR30(p_document_subtype),
1229: p_document_num => PO_TBL_VARCHAR30(p_document_num),
1230: p_vendor_order_num => PO_TBL_VARCHAR30(p_vendor_order_num),
1231: p_line_id => PO_TBL_NUMBER(p_line_id),
1232: p_line_location_id => PO_TBL_NUMBER(p_line_location_id),
1233: p_distribution_id => PO_TBL_NUMBER(p_distribution_id),
1234: p_mode => p_mode,
1235: p_lock_flag => p_lock_flag,

Line 1232: p_line_location_id => PO_TBL_NUMBER(p_line_location_id),

1228: p_document_subtype => PO_TBL_VARCHAR30(p_document_subtype),
1229: p_document_num => PO_TBL_VARCHAR30(p_document_num),
1230: p_vendor_order_num => PO_TBL_VARCHAR30(p_vendor_order_num),
1231: p_line_id => PO_TBL_NUMBER(p_line_id),
1232: p_line_location_id => PO_TBL_NUMBER(p_line_location_id),
1233: p_distribution_id => PO_TBL_NUMBER(p_distribution_id),
1234: p_mode => p_mode,
1235: p_lock_flag => p_lock_flag,
1236: p_calling_module => p_calling_module, -- PDOI Rewrite R12

Line 1233: p_distribution_id => PO_TBL_NUMBER(p_distribution_id),

1229: p_document_num => PO_TBL_VARCHAR30(p_document_num),
1230: p_vendor_order_num => PO_TBL_VARCHAR30(p_vendor_order_num),
1231: p_line_id => PO_TBL_NUMBER(p_line_id),
1232: p_line_location_id => PO_TBL_NUMBER(p_line_location_id),
1233: p_distribution_id => PO_TBL_NUMBER(p_distribution_id),
1234: p_mode => p_mode,
1235: p_lock_flag => p_lock_flag,
1236: p_calling_module => p_calling_module, -- PDOI Rewrite R12
1237: p_role => p_role, -- PDOI Rewrite R12

Line 1826: l_id2_seq_list PO_TBL_NUMBER; -- list for all sequence numbers of report 2

1822: d_module VARCHAR2(70) :=
1823: 'po.plsql.PO_DOCUMENT_CHECKS_GRP.merge_online_report_id';
1824: d_progress NUMBER;
1825: l_id1_max_seq NUMBER; -- max sequence number value for the first online report
1826: l_id2_seq_list PO_TBL_NUMBER; -- list for all sequence numbers of report 2
1827:
1828: BEGIN
1829: d_progress := 0;
1830: IF (PO_LOG.d_proc) THEN