DBA Data[Home] [Help]

APPS.FV_SLA_UTL_PROCESSING_PKG dependencies on PO_BC_DISTRIBUTIONS

Line 1574: l_po_bc_rec po_bc_distributions%ROWTYPE;

1570: p_error_desc OUT NOCOPY VARCHAR2
1571: )
1572: IS
1573: l_procedure_name VARCHAR2(100) :='.po_pya_processor';
1574: l_po_bc_rec po_bc_distributions%ROWTYPE;
1575: BEGIN
1576: l_procedure_name := g_path_name || l_procedure_name;
1577: p_error_code := c_SUCCESS;
1578: p_error_desc := NULL;

Line 1583: FROM po_bc_distributions pbd

1579: trace(C_STATE_LEVEL, l_procedure_name, 'BEGIN');
1580:
1581: SELECT *
1582: INTO l_po_bc_rec
1583: FROM po_bc_distributions pbd
1584: WHERE pbd.ae_event_id = p_extract_rec.event_id
1585: AND pbd.line_number = p_extract_rec.line_number;
1586:
1587: trace(C_STATE_LEVEL, l_procedure_name, 'event_type_code='||p_event_rec.event_type_code);

Line 1651: l_po_bc_rec po_bc_distributions%ROWTYPE;

1647: p_error_desc OUT NOCOPY VARCHAR2
1648: )
1649: IS
1650: l_procedure_name VARCHAR2(100) :='.ap_pya_processor';
1651: l_po_bc_rec po_bc_distributions%ROWTYPE;
1652: BEGIN
1653: l_procedure_name := g_path_name || l_procedure_name;
1654: p_error_code := c_SUCCESS;
1655: p_error_desc := NULL;