DBA Data[Home] [Help]

APPS.GMIVDBL dependencies on IC_WHSE_MST

Line 1705: FUNCTION ic_whse_mst_select

1701:
1702:
1703:
1704:
1705: FUNCTION ic_whse_mst_select
1706: (p_ic_whse_mst_row IN ic_whse_mst%ROWTYPE, x_ic_whse_mst_row IN OUT NOCOPY ic_whse_mst%ROWTYPE)
1707: RETURN BOOLEAN
1708: IS
1709: BEGIN

Line 1706: (p_ic_whse_mst_row IN ic_whse_mst%ROWTYPE, x_ic_whse_mst_row IN OUT NOCOPY ic_whse_mst%ROWTYPE)

1702:
1703:
1704:
1705: FUNCTION ic_whse_mst_select
1706: (p_ic_whse_mst_row IN ic_whse_mst%ROWTYPE, x_ic_whse_mst_row IN OUT NOCOPY ic_whse_mst%ROWTYPE)
1707: RETURN BOOLEAN
1708: IS
1709: BEGIN
1710: SELECT * INTO x_ic_whse_mst_row FROM ic_whse_mst

Line 1710: SELECT * INTO x_ic_whse_mst_row FROM ic_whse_mst

1706: (p_ic_whse_mst_row IN ic_whse_mst%ROWTYPE, x_ic_whse_mst_row IN OUT NOCOPY ic_whse_mst%ROWTYPE)
1707: RETURN BOOLEAN
1708: IS
1709: BEGIN
1710: SELECT * INTO x_ic_whse_mst_row FROM ic_whse_mst
1711: WHERE whse_code = p_ic_whse_mst_row.whse_code AND delete_mark=0;
1712:
1713: GMIGUTL.DB_ERRNUM := NULL;
1714: RETURN TRUE;

Line 1711: WHERE whse_code = p_ic_whse_mst_row.whse_code AND delete_mark=0;

1707: RETURN BOOLEAN
1708: IS
1709: BEGIN
1710: SELECT * INTO x_ic_whse_mst_row FROM ic_whse_mst
1711: WHERE whse_code = p_ic_whse_mst_row.whse_code AND delete_mark=0;
1712:
1713: GMIGUTL.DB_ERRNUM := NULL;
1714: RETURN TRUE;
1715:

Line 1736: END ic_whse_mst_select;

1732:
1733: GMIGUTL.DB_ERRNUM := SQLCODE;
1734: GMIGUTL.DB_ERRMSG:= SQLERRM;
1735: RETURN FALSE;
1736: END ic_whse_mst_select;
1737:
1738: FUNCTION ic_loct_inv_select
1739: (p_ic_loct_inv_row IN ic_loct_inv%ROWTYPE, x_ic_loct_inv_row IN OUT NOCOPY ic_loct_inv%ROWTYPE)
1740: RETURN BOOLEAN