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_ACCOUNT_HELPER dependencies on PO_ONLINE_REPORT_TEXT_S

Line 11: , P_SEQUENCE_NUM IN OUT NOCOPY po_online_report_text.sequence%TYPE

7: --: forward declare insert_report_autonomous
8: PROCEDURE INSERT_REPORT_AUTONOMOUS(
9: P_MESSAGE_TEXT IN VARCHAR2
10: , P_USER_ID IN NUMBER
11: , P_SEQUENCE_NUM IN OUT NOCOPY po_online_report_text.sequence%TYPE
12: , P_LINE_NUM IN po_online_report_text.line_num%TYPE
13: , p_shipment_num IN po_online_report_text.shipment_num%TYPE
14: , p_distribution_num IN po_online_report_text.distribution_num%TYPE
15: , p_transaction_id IN po_online_report_text.transaction_id%TYPE

Line 13: , p_shipment_num IN po_online_report_text.shipment_num%TYPE

9: P_MESSAGE_TEXT IN VARCHAR2
10: , P_USER_ID IN NUMBER
11: , P_SEQUENCE_NUM IN OUT NOCOPY po_online_report_text.sequence%TYPE
12: , P_LINE_NUM IN po_online_report_text.line_num%TYPE
13: , p_shipment_num IN po_online_report_text.shipment_num%TYPE
14: , p_distribution_num IN po_online_report_text.distribution_num%TYPE
15: , p_transaction_id IN po_online_report_text.transaction_id%TYPE
16: , p_transaction_type IN po_online_report_text.transaction_type%TYPE
17: , p_message_type IN po_online_report_text.message_type%TYPE

Line 19: , p_segment1 IN po_online_report_text.segment1%TYPE

15: , p_transaction_id IN po_online_report_text.transaction_id%TYPE
16: , p_transaction_type IN po_online_report_text.transaction_type%TYPE
17: , p_message_type IN po_online_report_text.message_type%TYPE
18: , p_text_line IN po_online_report_text.text_line%TYPE
19: , p_segment1 IN po_online_report_text.segment1%TYPE
20: , p_online_report_id IN NUMBER
21: , x_return_status IN OUT NOCOPY VARCHAR2
22: );
23:

Line 910: x_sequence po_online_report_text.sequence%TYPE;

906: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
907: d_position NUMBER;
908:
909: l_report_id PO_ONLINE_REPORT_TEXT.online_report_id%TYPE;
910: x_sequence po_online_report_text.sequence%TYPE;
911: l_return_status VARCHAR2(1) := 'S';
912: l_success BOOLEAN;
913:
914: --Variables for getting billable flag.

Line 1115: SELECT PO_ONLINE_REPORT_TEXT_S.nextval

1111: -- establish savepoint to roll back to (general exception)
1112: SAVEPOINT PO_ACCOUNT_HELPER_RB_ACC_SP;
1113: -- START MAIN LOGIC
1114:
1115: SELECT PO_ONLINE_REPORT_TEXT_S.nextval
1116: INTO l_report_id
1117: FROM dual;
1118:
1119: x_online_report_id := l_report_id;

Line 1850: , P_SEQUENCE_NUM IN OUT NOCOPY po_online_report_text.sequence%TYPE

1846: --: added insert_report_autonomous
1847: PROCEDURE INSERT_REPORT_AUTONOMOUS(
1848: P_MESSAGE_TEXT IN VARCHAR2
1849: , P_USER_ID IN NUMBER
1850: , P_SEQUENCE_NUM IN OUT NOCOPY po_online_report_text.sequence%TYPE
1851: , P_LINE_NUM IN po_online_report_text.line_num%TYPE
1852: , p_shipment_num IN po_online_report_text.shipment_num%TYPE
1853: , p_distribution_num IN po_online_report_text.distribution_num%TYPE
1854: , p_transaction_id IN po_online_report_text.transaction_id%TYPE

Line 1852: , p_shipment_num IN po_online_report_text.shipment_num%TYPE

1848: P_MESSAGE_TEXT IN VARCHAR2
1849: , P_USER_ID IN NUMBER
1850: , P_SEQUENCE_NUM IN OUT NOCOPY po_online_report_text.sequence%TYPE
1851: , P_LINE_NUM IN po_online_report_text.line_num%TYPE
1852: , p_shipment_num IN po_online_report_text.shipment_num%TYPE
1853: , p_distribution_num IN po_online_report_text.distribution_num%TYPE
1854: , p_transaction_id IN po_online_report_text.transaction_id%TYPE
1855: , p_transaction_type IN po_online_report_text.transaction_type%TYPE
1856: , p_message_type IN po_online_report_text.message_type%TYPE

Line 1858: , p_segment1 IN po_online_report_text.segment1%TYPE

1854: , p_transaction_id IN po_online_report_text.transaction_id%TYPE
1855: , p_transaction_type IN po_online_report_text.transaction_type%TYPE
1856: , p_message_type IN po_online_report_text.message_type%TYPE
1857: , p_text_line IN po_online_report_text.text_line%TYPE
1858: , p_segment1 IN po_online_report_text.segment1%TYPE
1859: , p_online_report_id IN NUMBER
1860: , x_return_status IN OUT NOCOPY VARCHAR2
1861: ) IS
1862: PRAGMA AUTONOMOUS_TRANSACTION;