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_NUMBER

Line 357: ( p_po_exhibit_details_id_tbl IN PO_TBL_NUMBER,

353: --Testing:
354: --End of Comments
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

Line 358: p_draft_id_tbl IN PO_TBL_NUMBER,

354: --End of Comments
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:

Line 536: ( p_po_exhibit_details_id_tbl => PO_TBL_NUMBER(p_po_exhibit_details_id),

532: PO_LOG.proc_begin(d_module, 'p_po_exhibit_details_id', p_po_exhibit_details_id);
533: END IF;
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: );

Line 537: p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),

533: END IF;
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:

Line 592: ( p_draft_id_tbl IN PO_TBL_NUMBER,

588: --Testing:
589: --End of Comments
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';

Line 593: p_po_exhibit_details_id_tbl IN PO_TBL_NUMBER

589: --End of Comments
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 || '.';

Line 601: l_index_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

597: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
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

Line 603: l_dft_exists_index_tbl PO_TBL_NUMBER := PO_TBL_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;
607: IF (PO_LOG.d_proc) THEN

Line 715: ( p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),

711: END IF;
712:
713: l_exists_tbl :=
714: draft_changes_exist
715: ( p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),
716: p_po_exhibit_details_id_tbl => PO_TBL_NUMBER(p_po_exhibit_details_id)
717: );
718:
719: IF (PO_LOG.d_stmt) THEN

Line 716: p_po_exhibit_details_id_tbl => PO_TBL_NUMBER(p_po_exhibit_details_id)

712:
713: l_exists_tbl :=
714: draft_changes_exist
715: ( p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),
716: p_po_exhibit_details_id_tbl => PO_TBL_NUMBER(p_po_exhibit_details_id)
717: );
718:
719: IF (PO_LOG.d_stmt) THEN
720: PO_LOG.stmt(d_module, d_position, 'exists', l_exists_tbl(1));

Line 964: po_exhibit_details_ids_tbl PO_TBL_NUMBER;

960:
961: d_api_name CONSTANT VARCHAR2(30) := 'delete_rows';
962: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
963: d_position NUMBER;
964: po_exhibit_details_ids_tbl PO_TBL_NUMBER;
965:
966: BEGIN
967: d_position := 0;
968: IF (PO_LOG.d_proc) THEN

Line 998: -- p_document_id_tbl IN PO_TBL_NUMBER;

994: -- Inserts the given exhibits for the given document if it does not exists for that document
995: --Parameters:
996: --IN:
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:

Line 1012: p_document_id_tbl IN PO_TBL_NUMBER,

1008: ------------------------------------------------------------------------
1009: PROCEDURE insert_exhibits
1010: (
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,

Line 1016: p_revision_num_tbl IN PO_TBL_NUMBER,

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
1020:

Line 1190: -- p_document_id_tbl IN PO_TBL_NUMBER;

1186: -- Inserts the given exhibits for the given document if it does not exists for that document
1187: --Parameters:
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:

Line 1203: p_document_id_tbl IN PO_TBL_NUMBER,

1199: ------------------------------------------------------------------------
1200: PROCEDURE delete_exhibits
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

Line 1277: -- p_document_id_tbl IN PO_TBL_NUMBER;

1273: -- Copy the deliverables and exhibit for the given CDRL exhibit
1274: --Parameters:
1275: --IN:
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:

Line 1479: -- p_document_id_tbl IN PO_TBL_NUMBER;

1475: -- Delete the deliverables for the given CDRL exhibit
1476: --Parameters:
1477: --IN:
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: