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 1109: FUNCTION get_pvs_row_from_id( p_vendor_site_id IN po_vendor_sites_all.vendor_site_id%TYPE )

1105:
1106: RETURN g_fsp_row;
1107: END get_fsp_row;
1108:
1109: FUNCTION get_pvs_row_from_id( p_vendor_site_id IN po_vendor_sites_all.vendor_site_id%TYPE )
1110: RETURN po_vendor_sites_all%ROWTYPE IS
1111: BEGIN
1112: IF p_vendor_site_id IS NULL THEN
1113: RETURN NULL;

Line 1110: RETURN po_vendor_sites_all%ROWTYPE IS

1106: RETURN g_fsp_row;
1107: END get_fsp_row;
1108:
1109: FUNCTION get_pvs_row_from_id( p_vendor_site_id IN po_vendor_sites_all.vendor_site_id%TYPE )
1110: RETURN po_vendor_sites_all%ROWTYPE IS
1111: BEGIN
1112: IF p_vendor_site_id IS NULL THEN
1113: RETURN NULL;
1114: END IF;

Line 1131: FROM po_vendor_sites_all

1127: --END IF;
1128:
1129: SELECT *
1130: INTO g_pvs_row
1131: FROM po_vendor_sites_all
1132: WHERE vendor_site_id = p_vendor_site_id;
1133:
1134: RETURN g_pvs_row;
1135: END get_pvs_row_from_id;