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 12144: SELECT Pa_Bc_Packets_s.NextVal

12140:
12141: PRAGMA AUTONOMOUS_TRANSACTION;
12142:
12143: CURSOR c_gen_raw_bc_pkt IS
12144: SELECT Pa_Bc_Packets_s.NextVal
12145: FROM dual;
12146:
12147: CURSOR c_get_po_dist_id IS
12148: SELECT po_distribution_id

Line 12543: SET bc_packet_id = Pa_Bc_Packets_s.NextVal

12539: END IF;
12540:
12541: -- Update burden records with new bc_packet_id abd parent_bc_packet_id
12542: UPDATE Pa_Bc_Packets
12543: SET bc_packet_id = Pa_Bc_Packets_s.NextVal
12544: ,parent_bc_packet_id = l_Raw_Bc_Packet_Id
12545: WHERE packet_id = p_packet_id
12546: AND parent_bc_packet_id = c_cur.bc_packet_id;
12547:

Line 12612: ,Pa_Bc_Packets_s.NextVal

12608: ,reference3
12609: ,txn_interface_id --REL12
12610: )
12611: Select p_Packet_Id
12612: ,Pa_Bc_Packets_s.NextVal
12613: ,-1
12614: ,g_sob_Id_tbl(i)
12615: ,G_FC_Gl_Date
12616: ,G_FC_Period_Name

Line 12751: ,Pa_Bc_Packets_s.NextVal

12747: ,reference3
12748: ,txn_interface_id --REL12
12749: )
12750: Select p_Packet_Id
12751: ,Pa_Bc_Packets_s.NextVal
12752: ,-1
12753: ,g_sobid
12754: ,G_FC_Gl_Date
12755: ,G_FC_Period_Name

Line 13028: SELECT Pa_Bc_Packets_s.NextVal

13024:
13025: PRAGMA AUTONOMOUS_TRANSACTION;
13026:
13027: CURSOR c_gen_raw_bc_pkt IS
13028: SELECT Pa_Bc_Packets_s.NextVal
13029: FROM dual;
13030:
13031: CURSOR c_get_po_dist_id IS
13032: SELECT po_distribution_id

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

13302: ,document_header_id_2
13303: ,document_distribution_type
13304: )
13305: Select p_packet_id
13306: ,decode(bcc.Parent_Bc_Packet_Id,NULL,l_Raw_Bc_Packet_id,Pa_Bc_Packets_s.NextVal)
13307: ,decode(bcc.Parent_Bc_Packet_Id,NULL,NULL,l_Raw_Bc_Packet_id)
13308: ,bcc.Set_Of_Books_Id
13309: ,G_FC_Gl_Date
13310: ,G_FC_Period_Name

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

13419: ,document_header_id_2
13420: ,document_distribution_type
13421: )
13422: Select p_packet_id
13423: ,decode(bcc.Parent_Bc_Packet_Id,NULL,l_Raw_Bc_Packet_id,Pa_Bc_Packets_s.NextVal)
13424: ,decode(bcc.Parent_Bc_Packet_Id,NULL,NULL,l_Raw_Bc_Packet_id)
13425: ,bcc.Set_Of_Books_Id
13426: ,G_FC_Gl_Date
13427: ,G_FC_Period_Name

Line 13541: ,Pa_Bc_Packets_s.NextVal

13537: ,reference3
13538: ,txn_interface_id --REL12
13539: )
13540: Select p_Packet_Id
13541: ,Pa_Bc_Packets_s.NextVal
13542: ,-1
13543: ,g_sob_Id_tbl(i)
13544: ,G_FC_Gl_Date
13545: ,G_FC_Period_Name

Line 13667: ,Pa_Bc_Packets_s.NextVal

13663: ,reference3
13664: ,txn_interface_id --REL12
13665: )
13666: Select p_Packet_Id
13667: ,Pa_Bc_Packets_s.NextVal
13668: ,-1
13669: ,g_sobid
13670: ,G_FC_Gl_Date
13671: ,G_FC_Period_Name

Line 13921: SELECT Pa_Bc_Packets_s.NextVal

13917: p_comm_fc_req IN VARCHAR2,
13918: p_act_fc_req IN VARCHAR2,
13919: p_adj_act_fc_req IN VARCHAR2) IS
13920: CURSOR c_gen_raw_bc_pkt IS
13921: SELECT Pa_Bc_Packets_s.NextVal
13922: FROM dual;
13923:
13924: CURSOR c_get_po_LINE_id (p_po_dist_id NUMBER) IS
13925: SELECT po_line_id

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

14197: ,document_header_id_2
14198: ,document_distribution_type
14199: )
14200: Select p_packet_id
14201: ,decode(bcc.Parent_Bc_Packet_Id,NULL,l_Raw_Bc_Packet_id,Pa_Bc_Packets_s.NextVal)
14202: ,decode(bcc.Parent_Bc_Packet_Id,NULL,NULL,l_Raw_Bc_Packet_id)
14203: ,bcc.Set_Of_Books_Id
14204: ,G_FC_Gl_Date
14205: ,G_FC_Period_Name

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

14326: ,document_header_id_2
14327: ,document_distribution_type
14328: )
14329: Select p_packet_id
14330: ,decode(bcc.Parent_Bc_Packet_Id,NULL,l_Raw_Bc_Packet_id,Pa_Bc_Packets_s.NextVal)
14331: ,decode(bcc.Parent_Bc_Packet_Id,NULL,NULL,l_Raw_Bc_Packet_id)
14332: ,bcc.Set_Of_Books_Id
14333: ,G_FC_Gl_Date
14334: ,G_FC_Period_Name

Line 14458: ,Pa_Bc_Packets_s.NextVal

14454: ,reference3
14455: ,txn_interface_id --REL12
14456: )
14457: Select p_Packet_Id
14458: ,Pa_Bc_Packets_s.NextVal
14459: ,-1
14460: ,g_sob_Id_tbl(i)
14461: ,G_FC_Gl_Date
14462: ,G_FC_Period_Name

Line 14576: ,Pa_Bc_Packets_s.NextVal

14572: ,reference3
14573: ,txn_interface_id --REL12
14574: )
14575: Select p_Packet_Id
14576: ,Pa_Bc_Packets_s.NextVal
14577: ,-1
14578: ,g_sobid
14579: ,G_FC_Gl_Date
14580: ,G_FC_Period_Name