APPS.GMIVDBL dependencies on IC_LOTS_STS

Line 1186: FUNCTION ic_lots_sts_select

1182: GMIGUTL.DB_ERRMSG:= SQLERRM;
1183: RETURN FALSE;
1184: END ic_lots_cpg_select;
1185:
1186: FUNCTION ic_lots_sts_select
1187: (p_ic_lots_sts_row IN ic_lots_sts%ROWTYPE, x_ic_lots_sts_row IN OUT NOCOPY ic_lots_sts%ROWTYPE)
1188: RETURN BOOLEAN
1189: IS BEGIN
1190:

Line 1187: (p_ic_lots_sts_row IN ic_lots_sts%ROWTYPE, x_ic_lots_sts_row IN OUT NOCOPY ic_lots_sts%ROWTYPE)

1183: RETURN FALSE;
1184: END ic_lots_cpg_select;
1185:
1186: FUNCTION ic_lots_sts_select
1187: (p_ic_lots_sts_row IN ic_lots_sts%ROWTYPE, x_ic_lots_sts_row IN OUT NOCOPY ic_lots_sts%ROWTYPE)
1188: RETURN BOOLEAN
1189: IS BEGIN
1190:
1191: SELECT * INTO x_ic_lots_sts_row FROM ic_lots_sts

Line 1191: SELECT * INTO x_ic_lots_sts_row FROM ic_lots_sts

1187: (p_ic_lots_sts_row IN ic_lots_sts%ROWTYPE, x_ic_lots_sts_row IN OUT NOCOPY ic_lots_sts%ROWTYPE)
1188: RETURN BOOLEAN
1189: IS BEGIN
1190:
1191: SELECT * INTO x_ic_lots_sts_row FROM ic_lots_sts
1192: WHERE lot_status= p_ic_lots_sts_row.lot_status;
1193:
1194: GMIGUTL.DB_ERRNUM := NULL;
1195: RETURN TRUE;

Line 1192: WHERE lot_status= p_ic_lots_sts_row.lot_status;

1188: RETURN BOOLEAN
1189: IS BEGIN
1190:
1191: SELECT * INTO x_ic_lots_sts_row FROM ic_lots_sts
1192: WHERE lot_status= p_ic_lots_sts_row.lot_status;
1193:
1194: GMIGUTL.DB_ERRNUM := NULL;
1195: RETURN TRUE;
1196:

Line 1217: END ic_lots_sts_select;

1213:
1214: GMIGUTL.DB_ERRNUM := SQLCODE;
1215: GMIGUTL.DB_ERRMSG:= SQLERRM;
1216: RETURN FALSE;
1217: END ic_lots_sts_select;
1218:
1219: FUNCTION ic_jrnl_mst_insert
1220: (p_ic_jrnl_mst_row IN ic_jrnl_mst%ROWTYPE, x_ic_jrnl_mst_row IN OUT NOCOPY ic_jrnl_mst%ROWTYPE)
1221: RETURN BOOLEAN