DBA Data[Home] [Help]

APPS.GMIVDBL dependencies on PO_VEND_MST

Line 1840: FUNCTION po_vend_mst_select

1836: GMIGUTL.DB_ERRMSG:= SQLERRM;
1837: RETURN FALSE;
1838: END qc_actn_mst_select;
1839:
1840: FUNCTION po_vend_mst_select
1841: (p_po_vend_mst_row IN po_vend_mst%ROWTYPE, x_po_vend_mst_row IN OUT NOCOPY po_vend_mst%ROWTYPE)
1842: RETURN BOOLEAN
1843: IS
1844: BEGIN

Line 1841: (p_po_vend_mst_row IN po_vend_mst%ROWTYPE, x_po_vend_mst_row IN OUT NOCOPY po_vend_mst%ROWTYPE)

1837: RETURN FALSE;
1838: END qc_actn_mst_select;
1839:
1840: FUNCTION po_vend_mst_select
1841: (p_po_vend_mst_row IN po_vend_mst%ROWTYPE, x_po_vend_mst_row IN OUT NOCOPY po_vend_mst%ROWTYPE)
1842: RETURN BOOLEAN
1843: IS
1844: BEGIN
1845: SELECT * INTO x_po_vend_mst_row FROM po_vend_mst

Line 1845: SELECT * INTO x_po_vend_mst_row FROM po_vend_mst

1841: (p_po_vend_mst_row IN po_vend_mst%ROWTYPE, x_po_vend_mst_row IN OUT NOCOPY po_vend_mst%ROWTYPE)
1842: RETURN BOOLEAN
1843: IS
1844: BEGIN
1845: SELECT * INTO x_po_vend_mst_row FROM po_vend_mst
1846: WHERE vendor_no=p_po_vend_mst_row.vendor_no AND delete_mark=0 AND
1847: rownum=1;
1848:
1849: GMIGUTL.DB_ERRNUM := NULL;

Line 1846: WHERE vendor_no=p_po_vend_mst_row.vendor_no AND delete_mark=0 AND

1842: RETURN BOOLEAN
1843: IS
1844: BEGIN
1845: SELECT * INTO x_po_vend_mst_row FROM po_vend_mst
1846: WHERE vendor_no=p_po_vend_mst_row.vendor_no AND delete_mark=0 AND
1847: rownum=1;
1848:
1849: GMIGUTL.DB_ERRNUM := NULL;
1850: RETURN TRUE;

Line 1872: END po_vend_mst_select;

1868:
1869: GMIGUTL.DB_ERRNUM := SQLCODE;
1870: GMIGUTL.DB_ERRMSG:= SQLERRM;
1871: RETURN FALSE;
1872: END po_vend_mst_select;
1873: /*
1874:
1875: FUNCTION ic_xfer_mst_select
1876: (p_ic_xfer_mst_row IN ic_xfer_mst%ROWTYPE, x_ic_xfer_mst_row IN OUT NOCOPY ic_xfer_mst%ROWTYPE)