APPS.XLA_TRANSFER_PKG dependencies on GL_BC_PACKET_ARRIVAL_ORDER

Line 388: SELECT gl_bc_packet_arrival_order_s.nextval

384: RETURN NUMBER IS
385:
386:
387: CURSOR c_get_arrival_seq IS
388: SELECT gl_bc_packet_arrival_order_s.nextval
389: FROM dual;
390:
391:
392: CURSOR c_get_packet_id IS

Line 585: --Insert data into gl_bc_packet_arrival_order

581: p_level => C_LEVEL_EVENT);
582: END IF;
583:
584:
585: --Insert data into gl_bc_packet_arrival_order
586:
587: IF (NVL(l_bc_count,0) > 0) THEN
588: insert into gl_bc_packet_arrival_order
589: (

Line 588: insert into gl_bc_packet_arrival_order

584:
585: --Insert data into gl_bc_packet_arrival_order
586:
587: IF (NVL(l_bc_count,0) > 0) THEN
588: insert into gl_bc_packet_arrival_order
589: (
590: packet_id,
591: ledger_id,
592: arrival_seq,

Line 608: trace(p_msg => 'Num of rows inserted into gl_bc_packet_arrival_order table: '|| SQL%ROWCOUNT,

604: g_user_id
605: )
606: ;
607: IF (C_LEVEL_EVENT >= g_log_level) THEN
608: trace(p_msg => 'Num of rows inserted into gl_bc_packet_arrival_order table: '|| SQL%ROWCOUNT,
609: p_module => l_log_module,
610: p_level => C_LEVEL_EVENT);
611: END IF;
612: end if;

Line 1540: DELETE gl_bc_packet_arrival_order

1536: END IF;
1537:
1538:
1539: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST
1540: DELETE gl_bc_packet_arrival_order
1541: where packet_id in
1542: (select packet_id from gl_bc_packets
1543: WHERE group_id = g_group_id_tab(i)
1544: and status_code = 'C')

Line 1548: trace(SQL%ROWCOUNT || 'Rows deleted from the gl_bc_packet_arrival_order in recover_batch',C_LEVEL_STATEMENT,l_log_module);

1544: and status_code = 'C')
1545: ;
1546:
1547: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1548: trace(SQL%ROWCOUNT || 'Rows deleted from the gl_bc_packet_arrival_order in recover_batch',C_LEVEL_STATEMENT,l_log_module);
1549: END IF;
1550:
1551: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST
1552: DELETE gl_bc_packets