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_EXHIBITS_PVT dependencies on PO_TBL_VARCHAR1

Line 94: -- p_assigned_num_array PO_TBL_VARCHAR100 Set of line numbers for the given exhibit

90: --Function:
91: --This fucntion will return the next eligible elin (exhibit line number) for the give exhibit of that document.
92: --Parameters:
93: --IN:
94: -- p_assigned_num_array PO_TBL_VARCHAR100 Set of line numbers for the given exhibit
95: -- p_header_id Document Identifier
96: -- p_exhibit_name Exhibit name
97:
98: --IN OUT:

Line 103: FUNCTION NEXT_ELIN_NUM (p_assigned_num_array PO_TBL_VARCHAR100, p_header_id NUMBER, p_exhibit_name IN VARCHAR2)

99: --OUT:
100: --Notes:
101: --End of Comments
102: --------------------------------------------------------------------------------
103: FUNCTION NEXT_ELIN_NUM (p_assigned_num_array PO_TBL_VARCHAR100, p_header_id NUMBER, p_exhibit_name IN VARCHAR2)
104: RETURN VARCHAR2
105:
106: IS
107:

Line 112: l_oth_line_num_arr PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();

108: linNumDisplay VARCHAR2(3);
109: lineNumber NUMBER;
110: exhibit_len NUMBER;
111: lines_tbl_name VARCHAR2(50);
112: l_oth_line_num_arr PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();
113: l_merged_line_num_arr PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();
114: d_api_name CONSTANT VARCHAR2(30) := 'NEXT_ELIN_NUM';
115: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
116: d_position NUMBER;

Line 113: l_merged_line_num_arr PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();

109: lineNumber NUMBER;
110: exhibit_len NUMBER;
111: lines_tbl_name VARCHAR2(50);
112: l_oth_line_num_arr PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();
113: l_merged_line_num_arr PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();
114: d_api_name CONSTANT VARCHAR2(30) := 'NEXT_ELIN_NUM';
115: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
116: d_position NUMBER;
117:

Line 359: p_delete_flag_tbl IN PO_TBL_VARCHAR1,

355: ------------------------------------------------------------------------
356: PROCEDURE sync_draft_from_txn
357: ( p_po_exhibit_details_id_tbl IN PO_TBL_NUMBER,
358: p_draft_id_tbl IN PO_TBL_NUMBER,
359: p_delete_flag_tbl IN PO_TBL_VARCHAR1,
360: x_record_already_exist_tbl OUT NOCOPY PO_TBL_VARCHAR1
361: ) IS
362:
363: d_api_name CONSTANT VARCHAR2(30) := 'sync_draft_from_txn';

Line 360: x_record_already_exist_tbl OUT NOCOPY PO_TBL_VARCHAR1

356: PROCEDURE sync_draft_from_txn
357: ( p_po_exhibit_details_id_tbl IN PO_TBL_NUMBER,
358: p_draft_id_tbl IN PO_TBL_NUMBER,
359: p_delete_flag_tbl IN PO_TBL_VARCHAR1,
360: x_record_already_exist_tbl OUT NOCOPY PO_TBL_VARCHAR1
361: ) IS
362:
363: d_api_name CONSTANT VARCHAR2(30) := 'sync_draft_from_txn';
364: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';

Line 368: l_duplicate_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

364: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
365: d_position NUMBER;
366:
367: l_distinct_id_list DBMS_SQL.NUMBER_TABLE;
368: l_duplicate_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
369:
370: BEGIN
371: d_position := 0;
372: IF (PO_LOG.d_proc) THEN

Line 526: l_record_already_exist_tbl PO_TBL_VARCHAR1;

522: d_api_name CONSTANT VARCHAR2(30) := 'sync_draft_from_txn';
523: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
524: d_position NUMBER;
525:
526: l_record_already_exist_tbl PO_TBL_VARCHAR1;
527:
528: BEGIN
529: d_position := 0;
530: IF (PO_LOG.d_proc) THEN

Line 538: p_delete_flag_tbl => PO_TBL_VARCHAR1(p_delete_flag),

534:
535: sync_draft_from_txn
536: ( p_po_exhibit_details_id_tbl => PO_TBL_NUMBER(p_po_exhibit_details_id),
537: p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),
538: p_delete_flag_tbl => PO_TBL_VARCHAR1(p_delete_flag),
539: x_record_already_exist_tbl => l_record_already_exist_tbl
540: );
541:
542: x_record_already_exist := l_record_already_exist_tbl(1);

Line 594: ) RETURN PO_TBL_VARCHAR1

590: ------------------------------------------------------------------------
591: FUNCTION draft_changes_exist
592: ( p_draft_id_tbl IN PO_TBL_NUMBER,
593: p_po_exhibit_details_id_tbl IN PO_TBL_NUMBER
594: ) RETURN PO_TBL_VARCHAR1
595: IS
596: d_api_name CONSTANT VARCHAR2(30) := 'draft_changes_exist';
597: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
598: d_position NUMBER;

Line 602: l_dft_exists_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

598: d_position NUMBER;
599:
600: l_key NUMBER;
601: l_index_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
602: l_dft_exists_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
603: l_dft_exists_index_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
604:
605: BEGIN
606: d_position := 0;

Line 706: l_exists_tbl PO_TBL_VARCHAR1;

702: d_api_name CONSTANT VARCHAR2(30) := 'draft_changes_exist';
703: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
704: d_position NUMBER;
705:
706: l_exists_tbl PO_TBL_VARCHAR1;
707: BEGIN
708: d_position := 0;
709: IF (PO_LOG.d_proc) THEN
710: PO_LOG.proc_begin(d_module);

Line 1001: -- p_is_cdrl_tbl IN PO_TBL_VARCHAR1;

997: -- p_document_type_tbl IN PO_TBL_VARCHAR30;
998: -- p_document_id_tbl IN PO_TBL_NUMBER;
999: -- p_exhibit_name_tbl IN PO_TBL_VARCHAR30;
1000: -- p_exhibit_description_tbl IN PO_TBL_VARCHAR240;
1001: -- p_is_cdrl_tbl IN PO_TBL_VARCHAR1;
1002: --IN OUT:
1003: --OUT:
1004: --Returns:
1005: --Notes:

Line 1015: p_is_cdrl_tbl IN PO_TBL_VARCHAR1,

1011: p_document_type_tbl IN PO_TBL_VARCHAR30,
1012: p_document_id_tbl IN PO_TBL_NUMBER,
1013: p_exhibit_name_tbl IN PO_TBL_VARCHAR30,
1014: p_exhibit_description_tbl IN PO_TBL_VARCHAR240,
1015: p_is_cdrl_tbl IN PO_TBL_VARCHAR1,
1016: p_revision_num_tbl IN PO_TBL_NUMBER,
1017: x_return_status OUT NOCOPY VARCHAR2,
1018: x_return_msg OUT NOCOPY VARCHAR2
1019: ) IS

Line 1192: -- p_is_cdrl_tbl IN PO_TBL_VARCHAR1;

1188: --IN:
1189: -- p_document_type_tbl IN PO_TBL_VARCHAR30;
1190: -- p_document_id_tbl IN PO_TBL_NUMBER;
1191: -- p_exhibit_name_tbl IN PO_TBL_VARCHAR30;
1192: -- p_is_cdrl_tbl IN PO_TBL_VARCHAR1;
1193: --IN OUT:
1194: --OUT:
1195: --Returns:
1196: --Notes:

Line 1205: p_is_cdrl_tbl IN PO_TBL_VARCHAR1,

1201: (
1202: p_document_type_tbl IN PO_TBL_VARCHAR30,
1203: p_document_id_tbl IN PO_TBL_NUMBER,
1204: p_exhibit_name_tbl IN PO_TBL_VARCHAR30,
1205: p_is_cdrl_tbl IN PO_TBL_VARCHAR1,
1206: x_return_status OUT NOCOPY VARCHAR2,
1207: x_return_msg OUT NOCOPY VARCHAR2
1208: ) IS
1209:

Line 1280: -- p_is_cdrl_tbl IN PO_TBL_VARCHAR1;

1276: -- p_document_type_tbl IN PO_TBL_VARCHAR30;
1277: -- p_document_id_tbl IN PO_TBL_NUMBER;
1278: -- p_exhibit_name_tbl IN PO_TBL_VARCHAR30;
1279: -- p_doc_sub_type IN VARCHAR2
1280: -- p_is_cdrl_tbl IN PO_TBL_VARCHAR1;
1281:
1282: --IN OUT:
1283: --OUT:
1284: --Returns:

Line 1482: -- p_is_cdrl_tbl IN PO_TBL_VARCHAR1;

1478: -- p_document_type_tbl IN PO_TBL_VARCHAR30;
1479: -- p_document_id_tbl IN PO_TBL_NUMBER;
1480: -- p_exhibit_name_tbl IN PO_TBL_VARCHAR30;
1481: -- p_doc_sub_type IN VARCHAR2
1482: -- p_is_cdrl_tbl IN PO_TBL_VARCHAR1;
1483:
1484: --IN OUT:
1485: --OUT:
1486: --Returns: