DBA Data[Home] [Help]

APPS.GMIVQTY dependencies on GMIGAPI

Line 232: FUNCTION co_orgn_valid (p_qty_rec IN GMIGAPI.qty_rec_typ)

228:
229: END Check_unposted_jnl_qc_grade;
230:
231:
232: FUNCTION co_orgn_valid (p_qty_rec IN GMIGAPI.qty_rec_typ)
233: RETURN BOOLEAN
234: IS
235: l_count NUMBER;
236: BEGIN

Line 257: ( p_qty_rec IN GMIGAPI.qty_rec_typ

253: END;
254:
255:
256: FUNCTION co_orgn_whse_valid
257: ( p_qty_rec IN GMIGAPI.qty_rec_typ
258: , x_from_loct_ctl OUT NOCOPY NUMBER
259: , x_to_loct_ctl OUT NOCOPY NUMBER
260: )
261: RETURN BOOLEAN

Line 304: (p_qty_rec IN GMIGAPI.qty_rec_typ)

300: END;
301:
302:
303: FUNCTION whse_locations_valid
304: (p_qty_rec IN GMIGAPI.qty_rec_typ)
305: RETURN BOOLEAN
306: IS
307: l_from_whse ic_whse_mst.whse_code%TYPE;
308: l_to_whse ic_whse_mst.whse_code%TYPE;

Line 476: , p_qty_rec IN GMIGAPI.qty_rec_typ

472: */
473: PROCEDURE Validate_Inventory_Posting
474: ( p_api_version IN NUMBER
475: , p_validation_level IN NUMBER
476: , p_qty_rec IN GMIGAPI.qty_rec_typ
477: , p_ic_item_mst_row IN ic_item_mst%ROWTYPE
478: , p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE
479: , p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE
480: , p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE

Line 489: l_qty_rec GMIGAPI.qty_rec_typ;

485: , x_msg_count OUT NOCOPY NUMBER
486: , x_msg_data OUT NOCOPY VARCHAR2
487: )
488: IS
489: l_qty_rec GMIGAPI.qty_rec_typ;
490: l_ic_whse_mst_rec ic_whse_mst%ROWTYPE;
491: l_ic_loct_inv_row_from ic_loct_inv%ROWTYPE;
492: l_ic_loct_inv_row_to ic_loct_inv%ROWTYPE;
493: l_sy_reas_cds_row sy_reas_cds%ROWTYPE;

Line 1417: AND (l_qty_rec.orgn_code = GMIGAPI.prev_orgn_code)

1413: ****************************************************** */
1414: IF ( (l_trans_type IN (7,8))
1415: AND ( (l_qty_rec.journal_no IS NOT NULL)
1416: OR ( (upper(l_qty_rec.journal_no) = 'PREVIOUS')
1417: AND (l_qty_rec.orgn_code = GMIGAPI.prev_orgn_code)
1418: )
1419: )
1420: ) THEN
1421:

Line 1426: AND j.journal_no = nvl(l_qty_rec.journal_no,GMIGAPI.prev_journal_no)

1422: SELECT nvl(sum(a.qty),0)
1423: INTO l_other_lines_qty
1424: FROM ic_jrnl_mst j, ic_adjs_jnl a
1425: WHERE j.orgn_code = l_qty_rec.orgn_code
1426: AND j.journal_no = nvl(l_qty_rec.journal_no,GMIGAPI.prev_journal_no)
1427: AND a.journal_id = j.journal_id
1428: AND a.line_type <> -1
1429: AND a.item_id = p_ic_item_mst_row.item_id
1430: AND a.lot_id = nvl(p_ic_lots_mst_row.lot_id,0)