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_DRAFTS_PVT dependencies on PO_TBL_NUMBER

Line 599: po_line_ids_tbl PO_TBL_NUMBER; --UCA Changes

595:
596: d_api_name CONSTANT VARCHAR2(30) := 'remove_draft_changes';
597: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
598: d_position NUMBER;
599: po_line_ids_tbl PO_TBL_NUMBER; --UCA Changes
600:
601: BEGIN
602:
603: d_position := 0;

Line 2280: ( p_draft_id_tbl PO_TBL_NUMBER

2276: -- at any entity level for the corrsponding entry in p_draft_id_tbl
2277: --End of Comments
2278: ------------------------------------------------------------------------
2279: FUNCTION changes_exist_for_draft
2280: ( p_draft_id_tbl PO_TBL_NUMBER
2281: ) RETURN PO_TBL_VARCHAR1 IS
2282:
2283: d_api_name CONSTANT VARCHAR2(30) := 'changes_exist_for_draft';
2284: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';

Line 2287: l_null_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

2283: d_api_name CONSTANT VARCHAR2(30) := 'changes_exist_for_draft';
2284: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
2285: d_position NUMBER;
2286:
2287: l_null_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
2288:
2289: l_master_chg_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
2290: l_chg_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
2291: BEGIN

Line 7981: l_entity_id_tbl PO_TBL_NUMBER;

7977: x_return_status OUT NOCOPY VARCHAR2,
7978: x_results OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
7979: )
7980: IS
7981: l_entity_id_tbl PO_TBL_NUMBER;
7982: l_err_entity_tbl PO_TBL_VARCHAR60;
7983: l_err_pk1_tbl PO_TBL_VARCHAR240;
7984: l_lock_by_mod_num_tbl PO_TBL_VARCHAR100;
7985: l_err_msg_name VARCHAR2(60);

Line 8324: po_dest_line_ids_tbl IN PO_TBL_NUMBER,

8320: --End of Comments
8321: --------------------------------------------------------------------------------
8322: PROCEDURE revert_dist_action(
8323: p_po_draft_id IN NUMBER,
8324: po_dest_line_ids_tbl IN PO_TBL_NUMBER,
8325: x_return_status OUT NOCOPY VARCHAR2 )
8326: IS
8327: l_errormessage VARCHAR2(2000);
8328: d_api_name CONSTANT VARCHAR2(30) := 'revert_dist_action';

Line 8331: l_par_dist_tbl PO_TBL_NUMBER;

8327: l_errormessage VARCHAR2(2000);
8328: d_api_name CONSTANT VARCHAR2(30) := 'revert_dist_action';
8329: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
8330: d_position NUMBER;
8331: l_par_dist_tbl PO_TBL_NUMBER;
8332: BEGIN
8333:
8334: IF (PO_LOG.d_proc) THEN
8335: PO_LOG.proc_begin(d_module);

Line 8381: po_ship_ids_tbl IN PO_TBL_NUMBER,

8377: END revert_dist_action;
8378:
8379: PROCEDURE revert_shipment_action(
8380: p_po_draft_id IN NUMBER,
8381: po_ship_ids_tbl IN PO_TBL_NUMBER,
8382: x_return_status OUT NOCOPY VARCHAR2 )
8383: IS
8384: l_errormessage VARCHAR2(2000);
8385: d_api_name CONSTANT VARCHAR2(30) := 'revert_shipment_action';

Line 8388: po_distribution_id_tbl PO_TBL_NUMBER;

8384: l_errormessage VARCHAR2(2000);
8385: d_api_name CONSTANT VARCHAR2(30) := 'revert_shipment_action';
8386: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
8387: d_position NUMBER;
8388: po_distribution_id_tbl PO_TBL_NUMBER;
8389:
8390: --Category CUSTOM5340 corresponds to Modification Specific Exception. The user can use delete option
8391: -- to undo the changes for these attachments. Hence skipping this category in revert
8392: cursor get_to_be_deleted_attachments(p_line_location_id NUMBER,p_draft_id NUMBER, p_entity_name VARCHAR2) is

Line 8482: po_line_ids_tbl IN PO_TBL_NUMBER,

8478: END revert_shipment_action;
8479:
8480: PROCEDURE revert_line_action(
8481: p_po_draft_id IN NUMBER,
8482: po_line_ids_tbl IN PO_TBL_NUMBER,
8483: x_return_status OUT NOCOPY VARCHAR2 )
8484: IS
8485: l_errormessage VARCHAR2(2000);
8486: d_api_name CONSTANT VARCHAR2(30) := 'revert_line_action';

Line 8490: po_line_location_id_tbl PO_TBL_NUMBER;

8486: d_api_name CONSTANT VARCHAR2(30) := 'revert_line_action';
8487: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
8488: d_position NUMBER;
8489: no_of_dist NUMBER;
8490: po_line_location_id_tbl PO_TBL_NUMBER;
8491:
8492: --Category CUSTOM5340 corresponds to Modification Specific Exception. The user can use delete option
8493: -- to undo the changes for these attachments. Hence skipping this category in revert
8494: cursor get_to_be_deleted_attachments(p_line_id NUMBER,p_draft_id NUMBER,p_entity_name VARCHAR2) is

Line 8619: l_line_id_tbl PO_TBL_NUMBER;

8615: */
8616: PROCEDURE delete_marked_lines(
8617: p_draft_id IN NUMBER)
8618: IS
8619: l_line_id_tbl PO_TBL_NUMBER;
8620: d_api_name CONSTANT VARCHAR2(30) := 'delete_marked_lines';
8621: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name || '.';
8622: l_return_status varchar2(1);
8623: l_msg_count number;

Line 8717: l_line_loc_id_tbl PO_TBL_NUMBER;

8713: */
8714: PROCEDURE delete_marked_shipments(
8715: p_draft_id IN NUMBER)
8716: IS
8717: l_line_loc_id_tbl PO_TBL_NUMBER;
8718: l_linked_req_line_id PO_TBL_NUMBER;
8719: l_req_dist_id PO_TBL_NUMBER;
8720:
8721: d_api_name CONSTANT VARCHAR2(30) := 'delete_marked_shipments';

Line 8718: l_linked_req_line_id PO_TBL_NUMBER;

8714: PROCEDURE delete_marked_shipments(
8715: p_draft_id IN NUMBER)
8716: IS
8717: l_line_loc_id_tbl PO_TBL_NUMBER;
8718: l_linked_req_line_id PO_TBL_NUMBER;
8719: l_req_dist_id PO_TBL_NUMBER;
8720:
8721: d_api_name CONSTANT VARCHAR2(30) := 'delete_marked_shipments';
8722: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name || '.';

Line 8719: l_req_dist_id PO_TBL_NUMBER;

8715: p_draft_id IN NUMBER)
8716: IS
8717: l_line_loc_id_tbl PO_TBL_NUMBER;
8718: l_linked_req_line_id PO_TBL_NUMBER;
8719: l_req_dist_id PO_TBL_NUMBER;
8720:
8721: d_api_name CONSTANT VARCHAR2(30) := 'delete_marked_shipments';
8722: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name || '.';
8723:

Line 8780: l_distribution_id_tbl PO_TBL_NUMBER;

8776: */
8777: PROCEDURE delete_marked_distributions(
8778: p_draft_id IN NUMBER)
8779: IS
8780: l_distribution_id_tbl PO_TBL_NUMBER;
8781: d_api_name CONSTANT VARCHAR2(30) := 'delete_marked_distributions';
8782: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name || '.';
8783: BEGIN
8784:

Line 9164: po_header_id_tbl PO_TBL_NUMBER;

9160: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name || '.';
9161: d_position NUMBER :=0;
9162: l_count NUMBER := -1;
9163:
9164: po_header_id_tbl PO_TBL_NUMBER;
9165: po_draft_id_tbl PO_TBL_NUMBER;
9166: clm_exhibit_name_tbl PO_TBL_VARCHAR30;
9167: po_exhibit_details_id_tbl PO_TBL_NUMBER;
9168:

Line 9165: po_draft_id_tbl PO_TBL_NUMBER;

9161: d_position NUMBER :=0;
9162: l_count NUMBER := -1;
9163:
9164: po_header_id_tbl PO_TBL_NUMBER;
9165: po_draft_id_tbl PO_TBL_NUMBER;
9166: clm_exhibit_name_tbl PO_TBL_VARCHAR30;
9167: po_exhibit_details_id_tbl PO_TBL_NUMBER;
9168:
9169:

Line 9167: po_exhibit_details_id_tbl PO_TBL_NUMBER;

9163:
9164: po_header_id_tbl PO_TBL_NUMBER;
9165: po_draft_id_tbl PO_TBL_NUMBER;
9166: clm_exhibit_name_tbl PO_TBL_VARCHAR30;
9167: po_exhibit_details_id_tbl PO_TBL_NUMBER;
9168:
9169:
9170: BEGIN
9171:

Line 9399: po_line_ids_tbl IN PO_TBL_NUMBER)

9395: --Notes:
9396: --End of Comments
9397: --------------------------------------------------------------------------------
9398: PROCEDURE delete_line_ucas(p_po_draft_id IN NUMBER,
9399: po_line_ids_tbl IN PO_TBL_NUMBER)
9400: IS
9401: d_api_name CONSTANT VARCHAR2(30) := 'delete_line_ucas';
9402: d_module CONSTANT VARCHAR2(2000) := d_pkg_name
9403: || d_api_name