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.PA_TRX_IMPORT dependencies on PA_BC_PACKETS_S

Line 13045: SELECT Pa_Bc_Packets_s.NextVal

13041:
13042: PRAGMA AUTONOMOUS_TRANSACTION;
13043:
13044: CURSOR c_gen_raw_bc_pkt IS
13045: SELECT Pa_Bc_Packets_s.NextVal
13046: FROM dual;
13047:
13048: CURSOR c_get_po_dist_id IS
13049: SELECT po_distribution_id

Line 13466: SET bc_packet_id = Pa_Bc_Packets_s.NextVal

13462: END IF;
13463:
13464: -- Update burden records with new bc_packet_id abd parent_bc_packet_id
13465: UPDATE Pa_Bc_Packets
13466: SET bc_packet_id = Pa_Bc_Packets_s.NextVal
13467: ,parent_bc_packet_id = l_Raw_Bc_Packet_Id
13468: WHERE packet_id = p_packet_id
13469: AND parent_bc_packet_id = c_cur.bc_packet_id;
13470:

Line 13536: ,Pa_Bc_Packets_s.NextVal

13532: ,txn_interface_id --REL12
13533: ,vendor_id
13534: )
13535: Select p_Packet_Id
13536: ,Pa_Bc_Packets_s.NextVal
13537: ,-1
13538: ,g_sob_Id_tbl(i)
13539: ,G_FC_Gl_Date
13540: ,G_FC_Period_Name

Line 13677: ,Pa_Bc_Packets_s.NextVal

13673: ,txn_interface_id --REL12
13674: ,vendor_id
13675: )
13676: Select p_Packet_Id
13677: ,Pa_Bc_Packets_s.NextVal
13678: ,-1
13679: ,g_sobid
13680: ,G_FC_Gl_Date
13681: ,G_FC_Period_Name

Line 13958: SELECT Pa_Bc_Packets_s.NextVal

13954:
13955: PRAGMA AUTONOMOUS_TRANSACTION;
13956:
13957: CURSOR c_gen_raw_bc_pkt IS
13958: SELECT Pa_Bc_Packets_s.NextVal
13959: FROM dual;
13960:
13961: CURSOR c_get_po_dist_id IS
13962: SELECT po_distribution_id

Line 14260: ,decode(bcc.Parent_Bc_Packet_Id,NULL,l_Raw_Bc_Packet_id,Pa_Bc_Packets_s.NextVal)

14256: ,document_header_id_2
14257: ,document_distribution_type
14258: )
14259: Select p_packet_id
14260: ,decode(bcc.Parent_Bc_Packet_Id,NULL,l_Raw_Bc_Packet_id,Pa_Bc_Packets_s.NextVal)
14261: ,decode(bcc.Parent_Bc_Packet_Id,NULL,NULL,l_Raw_Bc_Packet_id)
14262: ,bcc.Set_Of_Books_Id
14263: ,G_FC_Gl_Date
14264: ,G_FC_Period_Name

Line 14377: ,decode(bcc.Parent_Bc_Packet_Id,NULL,l_Raw_Bc_Packet_id,Pa_Bc_Packets_s.NextVal)

14373: ,document_header_id_2
14374: ,document_distribution_type
14375: )
14376: Select p_packet_id
14377: ,decode(bcc.Parent_Bc_Packet_Id,NULL,l_Raw_Bc_Packet_id,Pa_Bc_Packets_s.NextVal)
14378: ,decode(bcc.Parent_Bc_Packet_Id,NULL,NULL,l_Raw_Bc_Packet_id)
14379: ,bcc.Set_Of_Books_Id
14380: ,G_FC_Gl_Date
14381: ,G_FC_Period_Name

Line 14496: ,Pa_Bc_Packets_s.NextVal

14492: ,txn_interface_id --REL12
14493: ,vendor_id
14494: )
14495: Select p_Packet_Id
14496: ,Pa_Bc_Packets_s.NextVal
14497: ,-1
14498: ,g_sob_Id_tbl(i)
14499: ,G_FC_Gl_Date
14500: ,G_FC_Period_Name

Line 14624: ,Pa_Bc_Packets_s.NextVal

14620: ,txn_interface_id --REL12
14621: ,vendor_id
14622: )
14623: Select p_Packet_Id
14624: ,Pa_Bc_Packets_s.NextVal
14625: ,-1
14626: ,g_sobid
14627: ,G_FC_Gl_Date
14628: ,G_FC_Period_Name

Line 14881: SELECT Pa_Bc_Packets_s.NextVal

14877: p_comm_fc_req IN VARCHAR2,
14878: p_act_fc_req IN VARCHAR2,
14879: p_adj_act_fc_req IN VARCHAR2) IS
14880: CURSOR c_gen_raw_bc_pkt IS
14881: SELECT Pa_Bc_Packets_s.NextVal
14882: FROM dual;
14883:
14884: CURSOR c_get_po_LINE_id (p_po_dist_id NUMBER) IS
14885: SELECT po_line_id

Line 15178: ,decode(bcc.Parent_Bc_Packet_Id,NULL,l_Raw_Bc_Packet_id,Pa_Bc_Packets_s.NextVal)

15174: ,document_header_id_2
15175: ,document_distribution_type
15176: )
15177: Select p_packet_id
15178: ,decode(bcc.Parent_Bc_Packet_Id,NULL,l_Raw_Bc_Packet_id,Pa_Bc_Packets_s.NextVal)
15179: ,decode(bcc.Parent_Bc_Packet_Id,NULL,NULL,l_Raw_Bc_Packet_id)
15180: ,bcc.Set_Of_Books_Id
15181: ,G_FC_Gl_Date
15182: ,G_FC_Period_Name

Line 15308: ,decode(bcc.Parent_Bc_Packet_Id,NULL,l_Raw_Bc_Packet_id,Pa_Bc_Packets_s.NextVal)

15304: ,document_header_id_2
15305: ,document_distribution_type
15306: )
15307: Select p_packet_id
15308: ,decode(bcc.Parent_Bc_Packet_Id,NULL,l_Raw_Bc_Packet_id,Pa_Bc_Packets_s.NextVal)
15309: ,decode(bcc.Parent_Bc_Packet_Id,NULL,NULL,l_Raw_Bc_Packet_id)
15310: ,bcc.Set_Of_Books_Id
15311: ,G_FC_Gl_Date
15312: ,G_FC_Period_Name

Line 15439: ,Pa_Bc_Packets_s.NextVal

15435: ,txn_interface_id --REL12
15436: ,vendor_id
15437: )
15438: Select p_Packet_Id
15439: ,Pa_Bc_Packets_s.NextVal
15440: ,-1
15441: ,g_sob_Id_tbl(i)
15442: ,G_FC_Gl_Date
15443: ,G_FC_Period_Name

Line 15561: ,Pa_Bc_Packets_s.NextVal

15557: ,txn_interface_id --REL12
15558: ,vendor_id
15559: )
15560: Select p_Packet_Id
15561: ,Pa_Bc_Packets_s.NextVal
15562: ,-1
15563: ,g_sobid
15564: ,G_FC_Gl_Date
15565: ,G_FC_Period_Name