DBA Data[Home] [Help]

APPS.RCV_TABLE_FUNCTIONS dependencies on PO_VENDOR_SITES_ALL

Line 25: g_pvs_row po_vendor_sites_all%ROWTYPE;

21: g_fc_row fnd_currencies%ROWTYPE;
22: g_sob_row gl_sets_of_books%ROWTYPE;
23: g_fsp_row financials_system_parameters%ROWTYPE;
24: g_fspa_row financials_system_params_all%ROWTYPE;
25: g_pvs_row po_vendor_sites_all%ROWTYPE;
26: g_muom_row mtl_units_of_measure%ROWTYPE;
27:
28: g_po_lookups lookup_table_type;
29:

Line 1082: FUNCTION get_pvs_row_from_id( p_vendor_site_id IN po_vendor_sites_all.vendor_site_id%TYPE )

1078:
1079: RETURN g_fsp_row;
1080: END get_fsp_row;
1081:
1082: FUNCTION get_pvs_row_from_id( p_vendor_site_id IN po_vendor_sites_all.vendor_site_id%TYPE )
1083: RETURN po_vendor_sites_all%ROWTYPE IS
1084: BEGIN
1085: IF p_vendor_site_id IS NULL THEN
1086: RETURN NULL;

Line 1083: RETURN po_vendor_sites_all%ROWTYPE IS

1079: RETURN g_fsp_row;
1080: END get_fsp_row;
1081:
1082: FUNCTION get_pvs_row_from_id( p_vendor_site_id IN po_vendor_sites_all.vendor_site_id%TYPE )
1083: RETURN po_vendor_sites_all%ROWTYPE IS
1084: BEGIN
1085: IF p_vendor_site_id IS NULL THEN
1086: RETURN NULL;
1087: END IF;

Line 1095: FROM po_vendor_sites_all

1091: END IF;
1092:
1093: SELECT *
1094: INTO g_pvs_row
1095: FROM po_vendor_sites_all
1096: WHERE vendor_site_id = p_vendor_site_id;
1097:
1098: RETURN g_pvs_row;
1099: END get_pvs_row_from_id;