eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMIVQTY dependencies on IC_ADJS_JNL

Line 116: ic_adjs_jnl a, ic_jrnl_mst j

112: CURSOR ic_journal IS
113: SELECT
114: count(*)
115: FROM
116: ic_adjs_jnl a, ic_jrnl_mst j
117: WHERE
118: a.item_id = p_item_id AND
119: a.lot_id = p_lot_id AND
120: a.whse_code = p_whse_code AND

Line 194: ic_adjs_jnl a, ic_jrnl_mst j

190: CURSOR ic_journal IS
191: SELECT
192: count(*)
193: FROM
194: ic_adjs_jnl a, ic_jrnl_mst j
195: WHERE
196: a.item_id = p_item_id AND
197: a.lot_id = p_lot_id AND
198: a.journal_id = j.journal_id AND

Line 482: , x_ic_adjs_jnl_row1 OUT NOCOPY ic_adjs_jnl%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
481: , x_ic_jrnl_mst_row OUT NOCOPY ic_jrnl_mst%ROWTYPE
482: , x_ic_adjs_jnl_row1 OUT NOCOPY ic_adjs_jnl%ROWTYPE
483: , x_ic_adjs_jnl_row2 OUT NOCOPY ic_adjs_jnl%ROWTYPE
484: , x_return_status OUT NOCOPY VARCHAR2
485: , x_msg_count OUT NOCOPY NUMBER
486: , x_msg_data OUT NOCOPY VARCHAR2

Line 483: , x_ic_adjs_jnl_row2 OUT NOCOPY ic_adjs_jnl%ROWTYPE

479: , p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE
480: , p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE
481: , x_ic_jrnl_mst_row OUT NOCOPY ic_jrnl_mst%ROWTYPE
482: , x_ic_adjs_jnl_row1 OUT NOCOPY ic_adjs_jnl%ROWTYPE
483: , x_ic_adjs_jnl_row2 OUT NOCOPY ic_adjs_jnl%ROWTYPE
484: , x_return_status OUT NOCOPY VARCHAR2
485: , x_msg_count OUT NOCOPY NUMBER
486: , x_msg_data OUT NOCOPY VARCHAR2
487: )

Line 1424: FROM ic_jrnl_mst j, ic_adjs_jnl a

1420: ) THEN
1421:
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

Line 1473: x_ic_adjs_jnl_row1.acctg_unit_id := NULL;

1469: FND_MSG_PUB.Add;
1470: RAISE FND_API.G_EXC_ERROR;
1471: END IF;
1472: IF (l_qty_rec.txn_type IN ('GRD','STS','TRN')) THEN
1473: x_ic_adjs_jnl_row1.acctg_unit_id := NULL;
1474: x_ic_adjs_jnl_row1.acct_id := NULL;
1475: x_ic_adjs_jnl_row2.acctg_unit_id := NULL;
1476: x_ic_adjs_jnl_row2.acct_id := NULL;
1477: END IF;

Line 1474: x_ic_adjs_jnl_row1.acct_id := NULL;

1470: RAISE FND_API.G_EXC_ERROR;
1471: END IF;
1472: IF (l_qty_rec.txn_type IN ('GRD','STS','TRN')) THEN
1473: x_ic_adjs_jnl_row1.acctg_unit_id := NULL;
1474: x_ic_adjs_jnl_row1.acct_id := NULL;
1475: x_ic_adjs_jnl_row2.acctg_unit_id := NULL;
1476: x_ic_adjs_jnl_row2.acct_id := NULL;
1477: END IF;
1478: /* *********************************************************

Line 1475: x_ic_adjs_jnl_row2.acctg_unit_id := NULL;

1471: END IF;
1472: IF (l_qty_rec.txn_type IN ('GRD','STS','TRN')) THEN
1473: x_ic_adjs_jnl_row1.acctg_unit_id := NULL;
1474: x_ic_adjs_jnl_row1.acct_id := NULL;
1475: x_ic_adjs_jnl_row2.acctg_unit_id := NULL;
1476: x_ic_adjs_jnl_row2.acct_id := NULL;
1477: END IF;
1478: /* *********************************************************
1479: Jalaj Srivastava Bug 2483656

Line 1476: x_ic_adjs_jnl_row2.acct_id := NULL;

1472: IF (l_qty_rec.txn_type IN ('GRD','STS','TRN')) THEN
1473: x_ic_adjs_jnl_row1.acctg_unit_id := NULL;
1474: x_ic_adjs_jnl_row1.acct_id := NULL;
1475: x_ic_adjs_jnl_row2.acctg_unit_id := NULL;
1476: x_ic_adjs_jnl_row2.acct_id := NULL;
1477: END IF;
1478: /* *********************************************************
1479: Jalaj Srivastava Bug 2483656
1480: Charge accounts are only available from 11i family pack

Line 1489: x_ic_adjs_jnl_row1.acctg_unit_id := NULL;

1485: ) THEN
1486: IF ( (l_qty_rec.acctg_unit_no IS NULL)
1487: AND (l_qty_rec.acct_no IS NULL)
1488: ) THEN
1489: x_ic_adjs_jnl_row1.acctg_unit_id := NULL;
1490: x_ic_adjs_jnl_row1.acct_id := NULL;
1491: ELSIF ( (l_qty_rec.acctg_unit_no IS NULL)
1492: OR (l_qty_rec.acct_no IS NULL)
1493: ) THEN

Line 1490: x_ic_adjs_jnl_row1.acct_id := NULL;

1486: IF ( (l_qty_rec.acctg_unit_no IS NULL)
1487: AND (l_qty_rec.acct_no IS NULL)
1488: ) THEN
1489: x_ic_adjs_jnl_row1.acctg_unit_id := NULL;
1490: x_ic_adjs_jnl_row1.acct_id := NULL;
1491: ELSIF ( (l_qty_rec.acctg_unit_no IS NULL)
1492: OR (l_qty_rec.acct_no IS NULL)
1493: ) THEN
1494: FND_MESSAGE.SET_NAME('GMI','GMI_API_CHARGE_ACCT');

Line 1512: ,x_acctg_unit_id => x_ic_adjs_jnl_row1.acctg_unit_id

1508: ( p_co_code => l_from_whse_co_code
1509: ,p_acctg_unit_no => l_qty_rec.acctg_unit_no
1510: ,p_acct_no => l_qty_rec.acct_no
1511: ,p_create_acct => 'Y'
1512: ,x_acctg_unit_id => x_ic_adjs_jnl_row1.acctg_unit_id
1513: ,x_acct_id => x_ic_adjs_jnl_row1.acct_id
1514: ,x_ccid => l_ccid
1515: ,x_status => l_return_status
1516: ,x_errmsg => l_errmsg

Line 1513: ,x_acct_id => x_ic_adjs_jnl_row1.acct_id

1509: ,p_acctg_unit_no => l_qty_rec.acctg_unit_no
1510: ,p_acct_no => l_qty_rec.acct_no
1511: ,p_create_acct => 'Y'
1512: ,x_acctg_unit_id => x_ic_adjs_jnl_row1.acctg_unit_id
1513: ,x_acct_id => x_ic_adjs_jnl_row1.acct_id
1514: ,x_ccid => l_ccid
1515: ,x_status => l_return_status
1516: ,x_errmsg => l_errmsg
1517: );

Line 1518: IF (x_ic_adjs_jnl_row1.acctg_unit_id = -1) THEN

1514: ,x_ccid => l_ccid
1515: ,x_status => l_return_status
1516: ,x_errmsg => l_errmsg
1517: );
1518: IF (x_ic_adjs_jnl_row1.acctg_unit_id = -1) THEN
1519: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,substrb(l_errmsg,1,240));
1520: FND_MSG_PUB.Add;
1521: RAISE FND_API.G_EXC_ERROR;
1522: END IF;

Line 1593: x_ic_adjs_jnl_row1.trans_type := l_trans_code;

1589: x_ic_jrnl_mst_row.attribute29 := UPPER(l_qty_rec.attribute29);
1590: x_ic_jrnl_mst_row.attribute30 := UPPER(l_qty_rec.attribute30);
1591: x_ic_jrnl_mst_row.attribute_category := UPPER(l_qty_rec.attribute_category);
1592:
1593: x_ic_adjs_jnl_row1.trans_type := l_trans_code;
1594: x_ic_adjs_jnl_row1.trans_flag := 0;
1595: x_ic_adjs_jnl_row1.doc_id := NULL;
1596: x_ic_adjs_jnl_row1.journal_id := NULL;
1597: IF (l_qty_rec.journal_ind = 'N') THEN --Immediate txn

Line 1594: x_ic_adjs_jnl_row1.trans_flag := 0;

1590: x_ic_jrnl_mst_row.attribute30 := UPPER(l_qty_rec.attribute30);
1591: x_ic_jrnl_mst_row.attribute_category := UPPER(l_qty_rec.attribute_category);
1592:
1593: x_ic_adjs_jnl_row1.trans_type := l_trans_code;
1594: x_ic_adjs_jnl_row1.trans_flag := 0;
1595: x_ic_adjs_jnl_row1.doc_id := NULL;
1596: x_ic_adjs_jnl_row1.journal_id := NULL;
1597: IF (l_qty_rec.journal_ind = 'N') THEN --Immediate txn
1598: x_ic_adjs_jnl_row1.completed_ind := 1;

Line 1595: x_ic_adjs_jnl_row1.doc_id := NULL;

1591: x_ic_jrnl_mst_row.attribute_category := UPPER(l_qty_rec.attribute_category);
1592:
1593: x_ic_adjs_jnl_row1.trans_type := l_trans_code;
1594: x_ic_adjs_jnl_row1.trans_flag := 0;
1595: x_ic_adjs_jnl_row1.doc_id := NULL;
1596: x_ic_adjs_jnl_row1.journal_id := NULL;
1597: IF (l_qty_rec.journal_ind = 'N') THEN --Immediate txn
1598: x_ic_adjs_jnl_row1.completed_ind := 1;
1599: ELSE

Line 1596: x_ic_adjs_jnl_row1.journal_id := NULL;

1592:
1593: x_ic_adjs_jnl_row1.trans_type := l_trans_code;
1594: x_ic_adjs_jnl_row1.trans_flag := 0;
1595: x_ic_adjs_jnl_row1.doc_id := NULL;
1596: x_ic_adjs_jnl_row1.journal_id := NULL;
1597: IF (l_qty_rec.journal_ind = 'N') THEN --Immediate txn
1598: x_ic_adjs_jnl_row1.completed_ind := 1;
1599: ELSE
1600: x_ic_adjs_jnl_row1.completed_ind := 0;

Line 1598: x_ic_adjs_jnl_row1.completed_ind := 1;

1594: x_ic_adjs_jnl_row1.trans_flag := 0;
1595: x_ic_adjs_jnl_row1.doc_id := NULL;
1596: x_ic_adjs_jnl_row1.journal_id := NULL;
1597: IF (l_qty_rec.journal_ind = 'N') THEN --Immediate txn
1598: x_ic_adjs_jnl_row1.completed_ind := 1;
1599: ELSE
1600: x_ic_adjs_jnl_row1.completed_ind := 0;
1601: END IF;
1602: x_ic_adjs_jnl_row1.whse_code := l_qty_rec.from_whse_code;

Line 1600: x_ic_adjs_jnl_row1.completed_ind := 0;

1596: x_ic_adjs_jnl_row1.journal_id := NULL;
1597: IF (l_qty_rec.journal_ind = 'N') THEN --Immediate txn
1598: x_ic_adjs_jnl_row1.completed_ind := 1;
1599: ELSE
1600: x_ic_adjs_jnl_row1.completed_ind := 0;
1601: END IF;
1602: x_ic_adjs_jnl_row1.whse_code := l_qty_rec.from_whse_code;
1603: x_ic_adjs_jnl_row1.reason_code := l_qty_rec.reason_code;
1604: x_ic_adjs_jnl_row1.doc_date := l_qty_rec.trans_date;

Line 1602: x_ic_adjs_jnl_row1.whse_code := l_qty_rec.from_whse_code;

1598: x_ic_adjs_jnl_row1.completed_ind := 1;
1599: ELSE
1600: x_ic_adjs_jnl_row1.completed_ind := 0;
1601: END IF;
1602: x_ic_adjs_jnl_row1.whse_code := l_qty_rec.from_whse_code;
1603: x_ic_adjs_jnl_row1.reason_code := l_qty_rec.reason_code;
1604: x_ic_adjs_jnl_row1.doc_date := l_qty_rec.trans_date;
1605: x_ic_adjs_jnl_row1.item_id := p_ic_item_mst_row.item_id;
1606: x_ic_adjs_jnl_row1.item_um := l_qty_rec.item_um;

Line 1603: x_ic_adjs_jnl_row1.reason_code := l_qty_rec.reason_code;

1599: ELSE
1600: x_ic_adjs_jnl_row1.completed_ind := 0;
1601: END IF;
1602: x_ic_adjs_jnl_row1.whse_code := l_qty_rec.from_whse_code;
1603: x_ic_adjs_jnl_row1.reason_code := l_qty_rec.reason_code;
1604: x_ic_adjs_jnl_row1.doc_date := l_qty_rec.trans_date;
1605: x_ic_adjs_jnl_row1.item_id := p_ic_item_mst_row.item_id;
1606: x_ic_adjs_jnl_row1.item_um := l_qty_rec.item_um;
1607: x_ic_adjs_jnl_row1.item_um2 := l_qty_rec.item_um2;

Line 1604: x_ic_adjs_jnl_row1.doc_date := l_qty_rec.trans_date;

1600: x_ic_adjs_jnl_row1.completed_ind := 0;
1601: END IF;
1602: x_ic_adjs_jnl_row1.whse_code := l_qty_rec.from_whse_code;
1603: x_ic_adjs_jnl_row1.reason_code := l_qty_rec.reason_code;
1604: x_ic_adjs_jnl_row1.doc_date := l_qty_rec.trans_date;
1605: x_ic_adjs_jnl_row1.item_id := p_ic_item_mst_row.item_id;
1606: x_ic_adjs_jnl_row1.item_um := l_qty_rec.item_um;
1607: x_ic_adjs_jnl_row1.item_um2 := l_qty_rec.item_um2;
1608: x_ic_adjs_jnl_row1.lot_id := p_ic_lots_mst_row.lot_id;

Line 1605: x_ic_adjs_jnl_row1.item_id := p_ic_item_mst_row.item_id;

1601: END IF;
1602: x_ic_adjs_jnl_row1.whse_code := l_qty_rec.from_whse_code;
1603: x_ic_adjs_jnl_row1.reason_code := l_qty_rec.reason_code;
1604: x_ic_adjs_jnl_row1.doc_date := l_qty_rec.trans_date;
1605: x_ic_adjs_jnl_row1.item_id := p_ic_item_mst_row.item_id;
1606: x_ic_adjs_jnl_row1.item_um := l_qty_rec.item_um;
1607: x_ic_adjs_jnl_row1.item_um2 := l_qty_rec.item_um2;
1608: x_ic_adjs_jnl_row1.lot_id := p_ic_lots_mst_row.lot_id;
1609: x_ic_adjs_jnl_row1.location := l_qty_rec.from_location;

Line 1606: x_ic_adjs_jnl_row1.item_um := l_qty_rec.item_um;

1602: x_ic_adjs_jnl_row1.whse_code := l_qty_rec.from_whse_code;
1603: x_ic_adjs_jnl_row1.reason_code := l_qty_rec.reason_code;
1604: x_ic_adjs_jnl_row1.doc_date := l_qty_rec.trans_date;
1605: x_ic_adjs_jnl_row1.item_id := p_ic_item_mst_row.item_id;
1606: x_ic_adjs_jnl_row1.item_um := l_qty_rec.item_um;
1607: x_ic_adjs_jnl_row1.item_um2 := l_qty_rec.item_um2;
1608: x_ic_adjs_jnl_row1.lot_id := p_ic_lots_mst_row.lot_id;
1609: x_ic_adjs_jnl_row1.location := l_qty_rec.from_location;
1610: IF l_qty_rec.txn_type IN ('CRE','ADJ') OR l_trans_code IN ('STSR','GRDR')

Line 1607: x_ic_adjs_jnl_row1.item_um2 := l_qty_rec.item_um2;

1603: x_ic_adjs_jnl_row1.reason_code := l_qty_rec.reason_code;
1604: x_ic_adjs_jnl_row1.doc_date := l_qty_rec.trans_date;
1605: x_ic_adjs_jnl_row1.item_id := p_ic_item_mst_row.item_id;
1606: x_ic_adjs_jnl_row1.item_um := l_qty_rec.item_um;
1607: x_ic_adjs_jnl_row1.item_um2 := l_qty_rec.item_um2;
1608: x_ic_adjs_jnl_row1.lot_id := p_ic_lots_mst_row.lot_id;
1609: x_ic_adjs_jnl_row1.location := l_qty_rec.from_location;
1610: IF l_qty_rec.txn_type IN ('CRE','ADJ') OR l_trans_code IN ('STSR','GRDR')
1611: THEN

Line 1608: x_ic_adjs_jnl_row1.lot_id := p_ic_lots_mst_row.lot_id;

1604: x_ic_adjs_jnl_row1.doc_date := l_qty_rec.trans_date;
1605: x_ic_adjs_jnl_row1.item_id := p_ic_item_mst_row.item_id;
1606: x_ic_adjs_jnl_row1.item_um := l_qty_rec.item_um;
1607: x_ic_adjs_jnl_row1.item_um2 := l_qty_rec.item_um2;
1608: x_ic_adjs_jnl_row1.lot_id := p_ic_lots_mst_row.lot_id;
1609: x_ic_adjs_jnl_row1.location := l_qty_rec.from_location;
1610: IF l_qty_rec.txn_type IN ('CRE','ADJ') OR l_trans_code IN ('STSR','GRDR')
1611: THEN
1612: x_ic_adjs_jnl_row1.qty := NVL(l_qty_rec.trans_qty,0);

Line 1609: x_ic_adjs_jnl_row1.location := l_qty_rec.from_location;

1605: x_ic_adjs_jnl_row1.item_id := p_ic_item_mst_row.item_id;
1606: x_ic_adjs_jnl_row1.item_um := l_qty_rec.item_um;
1607: x_ic_adjs_jnl_row1.item_um2 := l_qty_rec.item_um2;
1608: x_ic_adjs_jnl_row1.lot_id := p_ic_lots_mst_row.lot_id;
1609: x_ic_adjs_jnl_row1.location := l_qty_rec.from_location;
1610: IF l_qty_rec.txn_type IN ('CRE','ADJ') OR l_trans_code IN ('STSR','GRDR')
1611: THEN
1612: x_ic_adjs_jnl_row1.qty := NVL(l_qty_rec.trans_qty,0);
1613: x_ic_adjs_jnl_row1.qty2 := l_qty_rec.trans_qty2;

Line 1612: x_ic_adjs_jnl_row1.qty := NVL(l_qty_rec.trans_qty,0);

1608: x_ic_adjs_jnl_row1.lot_id := p_ic_lots_mst_row.lot_id;
1609: x_ic_adjs_jnl_row1.location := l_qty_rec.from_location;
1610: IF l_qty_rec.txn_type IN ('CRE','ADJ') OR l_trans_code IN ('STSR','GRDR')
1611: THEN
1612: x_ic_adjs_jnl_row1.qty := NVL(l_qty_rec.trans_qty,0);
1613: x_ic_adjs_jnl_row1.qty2 := l_qty_rec.trans_qty2;
1614: ELSIF l_qty_rec.txn_type = 'TRN' THEN
1615: x_ic_adjs_jnl_row1.qty := NVL(-l_qty_rec.trans_qty,0);
1616: x_ic_adjs_jnl_row1.qty2 := -l_qty_rec.trans_qty2;

Line 1613: x_ic_adjs_jnl_row1.qty2 := l_qty_rec.trans_qty2;

1609: x_ic_adjs_jnl_row1.location := l_qty_rec.from_location;
1610: IF l_qty_rec.txn_type IN ('CRE','ADJ') OR l_trans_code IN ('STSR','GRDR')
1611: THEN
1612: x_ic_adjs_jnl_row1.qty := NVL(l_qty_rec.trans_qty,0);
1613: x_ic_adjs_jnl_row1.qty2 := l_qty_rec.trans_qty2;
1614: ELSIF l_qty_rec.txn_type = 'TRN' THEN
1615: x_ic_adjs_jnl_row1.qty := NVL(-l_qty_rec.trans_qty,0);
1616: x_ic_adjs_jnl_row1.qty2 := -l_qty_rec.trans_qty2;
1617: /* *************************************************************

Line 1615: x_ic_adjs_jnl_row1.qty := NVL(-l_qty_rec.trans_qty,0);

1611: THEN
1612: x_ic_adjs_jnl_row1.qty := NVL(l_qty_rec.trans_qty,0);
1613: x_ic_adjs_jnl_row1.qty2 := l_qty_rec.trans_qty2;
1614: ELSIF l_qty_rec.txn_type = 'TRN' THEN
1615: x_ic_adjs_jnl_row1.qty := NVL(-l_qty_rec.trans_qty,0);
1616: x_ic_adjs_jnl_row1.qty2 := -l_qty_rec.trans_qty2;
1617: /* *************************************************************
1618: Jalaj Srivastava Bug 2635964
1619: For grade transactions, there is no warehouse and location.

Line 1616: x_ic_adjs_jnl_row1.qty2 := -l_qty_rec.trans_qty2;

1612: x_ic_adjs_jnl_row1.qty := NVL(l_qty_rec.trans_qty,0);
1613: x_ic_adjs_jnl_row1.qty2 := l_qty_rec.trans_qty2;
1614: ELSIF l_qty_rec.txn_type = 'TRN' THEN
1615: x_ic_adjs_jnl_row1.qty := NVL(-l_qty_rec.trans_qty,0);
1616: x_ic_adjs_jnl_row1.qty2 := -l_qty_rec.trans_qty2;
1617: /* *************************************************************
1618: Jalaj Srivastava Bug 2635964
1619: For grade transactions, there is no warehouse and location.
1620: The grade change affects the lot at all warehouse/location.

Line 1625: x_ic_adjs_jnl_row1.qty := -l_onhand;

1621: To get onhand we need to sum up the onhands at all the
1622: warehouse/locations where the lot exists.
1623: ************************************************************* */
1624: ELSIF l_trans_code IN ('STSI','GRDI') THEN
1625: x_ic_adjs_jnl_row1.qty := -l_onhand;
1626: x_ic_adjs_jnl_row1.qty2 := -l_onhand2;
1627: END IF;
1628: x_ic_adjs_jnl_row1.line_id := NULL;
1629: x_ic_adjs_jnl_row1.co_code := l_qty_rec.co_code;

Line 1626: x_ic_adjs_jnl_row1.qty2 := -l_onhand2;

1622: warehouse/locations where the lot exists.
1623: ************************************************************* */
1624: ELSIF l_trans_code IN ('STSI','GRDI') THEN
1625: x_ic_adjs_jnl_row1.qty := -l_onhand;
1626: x_ic_adjs_jnl_row1.qty2 := -l_onhand2;
1627: END IF;
1628: x_ic_adjs_jnl_row1.line_id := NULL;
1629: x_ic_adjs_jnl_row1.co_code := l_qty_rec.co_code;
1630: x_ic_adjs_jnl_row1.orgn_code := l_qty_rec.orgn_code;

Line 1628: x_ic_adjs_jnl_row1.line_id := NULL;

1624: ELSIF l_trans_code IN ('STSI','GRDI') THEN
1625: x_ic_adjs_jnl_row1.qty := -l_onhand;
1626: x_ic_adjs_jnl_row1.qty2 := -l_onhand2;
1627: END IF;
1628: x_ic_adjs_jnl_row1.line_id := NULL;
1629: x_ic_adjs_jnl_row1.co_code := l_qty_rec.co_code;
1630: x_ic_adjs_jnl_row1.orgn_code := l_qty_rec.orgn_code;
1631: x_ic_adjs_jnl_row1.no_inv := 0; /* NOT NULL on database */
1632: x_ic_adjs_jnl_row1.no_trans := NULL;

Line 1629: x_ic_adjs_jnl_row1.co_code := l_qty_rec.co_code;

1625: x_ic_adjs_jnl_row1.qty := -l_onhand;
1626: x_ic_adjs_jnl_row1.qty2 := -l_onhand2;
1627: END IF;
1628: x_ic_adjs_jnl_row1.line_id := NULL;
1629: x_ic_adjs_jnl_row1.co_code := l_qty_rec.co_code;
1630: x_ic_adjs_jnl_row1.orgn_code := l_qty_rec.orgn_code;
1631: x_ic_adjs_jnl_row1.no_inv := 0; /* NOT NULL on database */
1632: x_ic_adjs_jnl_row1.no_trans := NULL;
1633: x_ic_adjs_jnl_row1.creation_date := SYSDATE;

Line 1630: x_ic_adjs_jnl_row1.orgn_code := l_qty_rec.orgn_code;

1626: x_ic_adjs_jnl_row1.qty2 := -l_onhand2;
1627: END IF;
1628: x_ic_adjs_jnl_row1.line_id := NULL;
1629: x_ic_adjs_jnl_row1.co_code := l_qty_rec.co_code;
1630: x_ic_adjs_jnl_row1.orgn_code := l_qty_rec.orgn_code;
1631: x_ic_adjs_jnl_row1.no_inv := 0; /* NOT NULL on database */
1632: x_ic_adjs_jnl_row1.no_trans := NULL;
1633: x_ic_adjs_jnl_row1.creation_date := SYSDATE;
1634: x_ic_adjs_jnl_row1.last_update_date := SYSDATE;

Line 1631: x_ic_adjs_jnl_row1.no_inv := 0; /* NOT NULL on database */

1627: END IF;
1628: x_ic_adjs_jnl_row1.line_id := NULL;
1629: x_ic_adjs_jnl_row1.co_code := l_qty_rec.co_code;
1630: x_ic_adjs_jnl_row1.orgn_code := l_qty_rec.orgn_code;
1631: x_ic_adjs_jnl_row1.no_inv := 0; /* NOT NULL on database */
1632: x_ic_adjs_jnl_row1.no_trans := NULL;
1633: x_ic_adjs_jnl_row1.creation_date := SYSDATE;
1634: x_ic_adjs_jnl_row1.last_update_date := SYSDATE;
1635: -- Bug 1735824

Line 1632: x_ic_adjs_jnl_row1.no_trans := NULL;

1628: x_ic_adjs_jnl_row1.line_id := NULL;
1629: x_ic_adjs_jnl_row1.co_code := l_qty_rec.co_code;
1630: x_ic_adjs_jnl_row1.orgn_code := l_qty_rec.orgn_code;
1631: x_ic_adjs_jnl_row1.no_inv := 0; /* NOT NULL on database */
1632: x_ic_adjs_jnl_row1.no_trans := NULL;
1633: x_ic_adjs_jnl_row1.creation_date := SYSDATE;
1634: x_ic_adjs_jnl_row1.last_update_date := SYSDATE;
1635: -- Bug 1735824
1636: -- Use the user name passed to the API instead of

Line 1633: x_ic_adjs_jnl_row1.creation_date := SYSDATE;

1629: x_ic_adjs_jnl_row1.co_code := l_qty_rec.co_code;
1630: x_ic_adjs_jnl_row1.orgn_code := l_qty_rec.orgn_code;
1631: x_ic_adjs_jnl_row1.no_inv := 0; /* NOT NULL on database */
1632: x_ic_adjs_jnl_row1.no_trans := NULL;
1633: x_ic_adjs_jnl_row1.creation_date := SYSDATE;
1634: x_ic_adjs_jnl_row1.last_update_date := SYSDATE;
1635: -- Bug 1735824
1636: -- Use the user name passed to the API instead of
1637: -- defaulting to the setup user name.

Line 1634: x_ic_adjs_jnl_row1.last_update_date := SYSDATE;

1630: x_ic_adjs_jnl_row1.orgn_code := l_qty_rec.orgn_code;
1631: x_ic_adjs_jnl_row1.no_inv := 0; /* NOT NULL on database */
1632: x_ic_adjs_jnl_row1.no_trans := NULL;
1633: x_ic_adjs_jnl_row1.creation_date := SYSDATE;
1634: x_ic_adjs_jnl_row1.last_update_date := SYSDATE;
1635: -- Bug 1735824
1636: -- Use the user name passed to the API instead of
1637: -- defaulting to the setup user name.
1638: x_ic_adjs_jnl_row1.created_by := l_user_id;

Line 1638: x_ic_adjs_jnl_row1.created_by := l_user_id;

1634: x_ic_adjs_jnl_row1.last_update_date := SYSDATE;
1635: -- Bug 1735824
1636: -- Use the user name passed to the API instead of
1637: -- defaulting to the setup user name.
1638: x_ic_adjs_jnl_row1.created_by := l_user_id;
1639: x_ic_adjs_jnl_row1.last_updated_by := l_user_id;
1640: x_ic_adjs_jnl_row1.trans_cnt := 1;
1641: x_ic_adjs_jnl_row1.last_update_login := NULL;
1642: x_ic_adjs_jnl_row1.program_application_id := NULL;

Line 1639: x_ic_adjs_jnl_row1.last_updated_by := l_user_id;

1635: -- Bug 1735824
1636: -- Use the user name passed to the API instead of
1637: -- defaulting to the setup user name.
1638: x_ic_adjs_jnl_row1.created_by := l_user_id;
1639: x_ic_adjs_jnl_row1.last_updated_by := l_user_id;
1640: x_ic_adjs_jnl_row1.trans_cnt := 1;
1641: x_ic_adjs_jnl_row1.last_update_login := NULL;
1642: x_ic_adjs_jnl_row1.program_application_id := NULL;
1643: x_ic_adjs_jnl_row1.program_id := NULL;

Line 1640: x_ic_adjs_jnl_row1.trans_cnt := 1;

1636: -- Use the user name passed to the API instead of
1637: -- defaulting to the setup user name.
1638: x_ic_adjs_jnl_row1.created_by := l_user_id;
1639: x_ic_adjs_jnl_row1.last_updated_by := l_user_id;
1640: x_ic_adjs_jnl_row1.trans_cnt := 1;
1641: x_ic_adjs_jnl_row1.last_update_login := NULL;
1642: x_ic_adjs_jnl_row1.program_application_id := NULL;
1643: x_ic_adjs_jnl_row1.program_id := NULL;
1644: x_ic_adjs_jnl_row1.program_update_date := NULL;

Line 1641: x_ic_adjs_jnl_row1.last_update_login := NULL;

1637: -- defaulting to the setup user name.
1638: x_ic_adjs_jnl_row1.created_by := l_user_id;
1639: x_ic_adjs_jnl_row1.last_updated_by := l_user_id;
1640: x_ic_adjs_jnl_row1.trans_cnt := 1;
1641: x_ic_adjs_jnl_row1.last_update_login := NULL;
1642: x_ic_adjs_jnl_row1.program_application_id := NULL;
1643: x_ic_adjs_jnl_row1.program_id := NULL;
1644: x_ic_adjs_jnl_row1.program_update_date := NULL;
1645: x_ic_adjs_jnl_row1.request_id := NULL;

Line 1642: x_ic_adjs_jnl_row1.program_application_id := NULL;

1638: x_ic_adjs_jnl_row1.created_by := l_user_id;
1639: x_ic_adjs_jnl_row1.last_updated_by := l_user_id;
1640: x_ic_adjs_jnl_row1.trans_cnt := 1;
1641: x_ic_adjs_jnl_row1.last_update_login := NULL;
1642: x_ic_adjs_jnl_row1.program_application_id := NULL;
1643: x_ic_adjs_jnl_row1.program_id := NULL;
1644: x_ic_adjs_jnl_row1.program_update_date := NULL;
1645: x_ic_adjs_jnl_row1.request_id := NULL;
1646: IF l_qty_rec.txn_type IN ('TRN','STS','GRD')

Line 1643: x_ic_adjs_jnl_row1.program_id := NULL;

1639: x_ic_adjs_jnl_row1.last_updated_by := l_user_id;
1640: x_ic_adjs_jnl_row1.trans_cnt := 1;
1641: x_ic_adjs_jnl_row1.last_update_login := NULL;
1642: x_ic_adjs_jnl_row1.program_application_id := NULL;
1643: x_ic_adjs_jnl_row1.program_id := NULL;
1644: x_ic_adjs_jnl_row1.program_update_date := NULL;
1645: x_ic_adjs_jnl_row1.request_id := NULL;
1646: IF l_qty_rec.txn_type IN ('TRN','STS','GRD')
1647: THEN

Line 1644: x_ic_adjs_jnl_row1.program_update_date := NULL;

1640: x_ic_adjs_jnl_row1.trans_cnt := 1;
1641: x_ic_adjs_jnl_row1.last_update_login := NULL;
1642: x_ic_adjs_jnl_row1.program_application_id := NULL;
1643: x_ic_adjs_jnl_row1.program_id := NULL;
1644: x_ic_adjs_jnl_row1.program_update_date := NULL;
1645: x_ic_adjs_jnl_row1.request_id := NULL;
1646: IF l_qty_rec.txn_type IN ('TRN','STS','GRD')
1647: THEN
1648: x_ic_adjs_jnl_row1.qc_grade := l_original_qc_grade;

Line 1645: x_ic_adjs_jnl_row1.request_id := NULL;

1641: x_ic_adjs_jnl_row1.last_update_login := NULL;
1642: x_ic_adjs_jnl_row1.program_application_id := NULL;
1643: x_ic_adjs_jnl_row1.program_id := NULL;
1644: x_ic_adjs_jnl_row1.program_update_date := NULL;
1645: x_ic_adjs_jnl_row1.request_id := NULL;
1646: IF l_qty_rec.txn_type IN ('TRN','STS','GRD')
1647: THEN
1648: x_ic_adjs_jnl_row1.qc_grade := l_original_qc_grade;
1649: x_ic_adjs_jnl_row1.lot_status := l_original_lot_status;

Line 1648: x_ic_adjs_jnl_row1.qc_grade := l_original_qc_grade;

1644: x_ic_adjs_jnl_row1.program_update_date := NULL;
1645: x_ic_adjs_jnl_row1.request_id := NULL;
1646: IF l_qty_rec.txn_type IN ('TRN','STS','GRD')
1647: THEN
1648: x_ic_adjs_jnl_row1.qc_grade := l_original_qc_grade;
1649: x_ic_adjs_jnl_row1.lot_status := l_original_lot_status;
1650: x_ic_adjs_jnl_row1.line_type := -1;
1651: x_ic_adjs_jnl_row2 := x_ic_adjs_jnl_row1;
1652: x_ic_adjs_jnl_row2.qc_grade := l_qty_rec.qc_grade;

Line 1649: x_ic_adjs_jnl_row1.lot_status := l_original_lot_status;

1645: x_ic_adjs_jnl_row1.request_id := NULL;
1646: IF l_qty_rec.txn_type IN ('TRN','STS','GRD')
1647: THEN
1648: x_ic_adjs_jnl_row1.qc_grade := l_original_qc_grade;
1649: x_ic_adjs_jnl_row1.lot_status := l_original_lot_status;
1650: x_ic_adjs_jnl_row1.line_type := -1;
1651: x_ic_adjs_jnl_row2 := x_ic_adjs_jnl_row1;
1652: x_ic_adjs_jnl_row2.qc_grade := l_qty_rec.qc_grade;
1653: x_ic_adjs_jnl_row2.lot_status := l_qty_rec.lot_status;

Line 1650: x_ic_adjs_jnl_row1.line_type := -1;

1646: IF l_qty_rec.txn_type IN ('TRN','STS','GRD')
1647: THEN
1648: x_ic_adjs_jnl_row1.qc_grade := l_original_qc_grade;
1649: x_ic_adjs_jnl_row1.lot_status := l_original_lot_status;
1650: x_ic_adjs_jnl_row1.line_type := -1;
1651: x_ic_adjs_jnl_row2 := x_ic_adjs_jnl_row1;
1652: x_ic_adjs_jnl_row2.qc_grade := l_qty_rec.qc_grade;
1653: x_ic_adjs_jnl_row2.lot_status := l_qty_rec.lot_status;
1654: x_ic_adjs_jnl_row2.line_type := 1;

Line 1651: x_ic_adjs_jnl_row2 := x_ic_adjs_jnl_row1;

1647: THEN
1648: x_ic_adjs_jnl_row1.qc_grade := l_original_qc_grade;
1649: x_ic_adjs_jnl_row1.lot_status := l_original_lot_status;
1650: x_ic_adjs_jnl_row1.line_type := -1;
1651: x_ic_adjs_jnl_row2 := x_ic_adjs_jnl_row1;
1652: x_ic_adjs_jnl_row2.qc_grade := l_qty_rec.qc_grade;
1653: x_ic_adjs_jnl_row2.lot_status := l_qty_rec.lot_status;
1654: x_ic_adjs_jnl_row2.line_type := 1;
1655: x_ic_adjs_jnl_row2.location := l_qty_rec.to_location;

Line 1652: x_ic_adjs_jnl_row2.qc_grade := l_qty_rec.qc_grade;

1648: x_ic_adjs_jnl_row1.qc_grade := l_original_qc_grade;
1649: x_ic_adjs_jnl_row1.lot_status := l_original_lot_status;
1650: x_ic_adjs_jnl_row1.line_type := -1;
1651: x_ic_adjs_jnl_row2 := x_ic_adjs_jnl_row1;
1652: x_ic_adjs_jnl_row2.qc_grade := l_qty_rec.qc_grade;
1653: x_ic_adjs_jnl_row2.lot_status := l_qty_rec.lot_status;
1654: x_ic_adjs_jnl_row2.line_type := 1;
1655: x_ic_adjs_jnl_row2.location := l_qty_rec.to_location;
1656: x_ic_adjs_jnl_row2.whse_code := l_qty_rec.to_whse_code;

Line 1653: x_ic_adjs_jnl_row2.lot_status := l_qty_rec.lot_status;

1649: x_ic_adjs_jnl_row1.lot_status := l_original_lot_status;
1650: x_ic_adjs_jnl_row1.line_type := -1;
1651: x_ic_adjs_jnl_row2 := x_ic_adjs_jnl_row1;
1652: x_ic_adjs_jnl_row2.qc_grade := l_qty_rec.qc_grade;
1653: x_ic_adjs_jnl_row2.lot_status := l_qty_rec.lot_status;
1654: x_ic_adjs_jnl_row2.line_type := 1;
1655: x_ic_adjs_jnl_row2.location := l_qty_rec.to_location;
1656: x_ic_adjs_jnl_row2.whse_code := l_qty_rec.to_whse_code;
1657: /* *************************************************************

Line 1654: x_ic_adjs_jnl_row2.line_type := 1;

1650: x_ic_adjs_jnl_row1.line_type := -1;
1651: x_ic_adjs_jnl_row2 := x_ic_adjs_jnl_row1;
1652: x_ic_adjs_jnl_row2.qc_grade := l_qty_rec.qc_grade;
1653: x_ic_adjs_jnl_row2.lot_status := l_qty_rec.lot_status;
1654: x_ic_adjs_jnl_row2.line_type := 1;
1655: x_ic_adjs_jnl_row2.location := l_qty_rec.to_location;
1656: x_ic_adjs_jnl_row2.whse_code := l_qty_rec.to_whse_code;
1657: /* *************************************************************
1658: Jalaj Srivastava Bug 2635964

Line 1655: x_ic_adjs_jnl_row2.location := l_qty_rec.to_location;

1651: x_ic_adjs_jnl_row2 := x_ic_adjs_jnl_row1;
1652: x_ic_adjs_jnl_row2.qc_grade := l_qty_rec.qc_grade;
1653: x_ic_adjs_jnl_row2.lot_status := l_qty_rec.lot_status;
1654: x_ic_adjs_jnl_row2.line_type := 1;
1655: x_ic_adjs_jnl_row2.location := l_qty_rec.to_location;
1656: x_ic_adjs_jnl_row2.whse_code := l_qty_rec.to_whse_code;
1657: /* *************************************************************
1658: Jalaj Srivastava Bug 2635964
1659: For grade transactions, there is no warehouse and location.

Line 1656: x_ic_adjs_jnl_row2.whse_code := l_qty_rec.to_whse_code;

1652: x_ic_adjs_jnl_row2.qc_grade := l_qty_rec.qc_grade;
1653: x_ic_adjs_jnl_row2.lot_status := l_qty_rec.lot_status;
1654: x_ic_adjs_jnl_row2.line_type := 1;
1655: x_ic_adjs_jnl_row2.location := l_qty_rec.to_location;
1656: x_ic_adjs_jnl_row2.whse_code := l_qty_rec.to_whse_code;
1657: /* *************************************************************
1658: Jalaj Srivastava Bug 2635964
1659: For grade transactions, there is no warehouse and location.
1660: The grade change affects the lot at all warehouse/location.

Line 1664: x_ic_adjs_jnl_row2.qty := -x_ic_adjs_jnl_row1.qty;

1660: The grade change affects the lot at all warehouse/location.
1661: To get onhand we need to sum up the onhands at all the
1662: warehouse/locations where the lot exists.
1663: ************************************************************* */
1664: x_ic_adjs_jnl_row2.qty := -x_ic_adjs_jnl_row1.qty;
1665: x_ic_adjs_jnl_row2.qty2 := -x_ic_adjs_jnl_row1.qty2;
1666: ELSE
1667: x_ic_adjs_jnl_row1.qc_grade := l_qty_rec.qc_grade;
1668: x_ic_adjs_jnl_row1.lot_status := l_qty_rec.lot_status;

Line 1665: x_ic_adjs_jnl_row2.qty2 := -x_ic_adjs_jnl_row1.qty2;

1661: To get onhand we need to sum up the onhands at all the
1662: warehouse/locations where the lot exists.
1663: ************************************************************* */
1664: x_ic_adjs_jnl_row2.qty := -x_ic_adjs_jnl_row1.qty;
1665: x_ic_adjs_jnl_row2.qty2 := -x_ic_adjs_jnl_row1.qty2;
1666: ELSE
1667: x_ic_adjs_jnl_row1.qc_grade := l_qty_rec.qc_grade;
1668: x_ic_adjs_jnl_row1.lot_status := l_qty_rec.lot_status;
1669: x_ic_adjs_jnl_row1.line_type := 0;

Line 1667: x_ic_adjs_jnl_row1.qc_grade := l_qty_rec.qc_grade;

1663: ************************************************************* */
1664: x_ic_adjs_jnl_row2.qty := -x_ic_adjs_jnl_row1.qty;
1665: x_ic_adjs_jnl_row2.qty2 := -x_ic_adjs_jnl_row1.qty2;
1666: ELSE
1667: x_ic_adjs_jnl_row1.qc_grade := l_qty_rec.qc_grade;
1668: x_ic_adjs_jnl_row1.lot_status := l_qty_rec.lot_status;
1669: x_ic_adjs_jnl_row1.line_type := 0;
1670: END IF;
1671: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count

Line 1668: x_ic_adjs_jnl_row1.lot_status := l_qty_rec.lot_status;

1664: x_ic_adjs_jnl_row2.qty := -x_ic_adjs_jnl_row1.qty;
1665: x_ic_adjs_jnl_row2.qty2 := -x_ic_adjs_jnl_row1.qty2;
1666: ELSE
1667: x_ic_adjs_jnl_row1.qc_grade := l_qty_rec.qc_grade;
1668: x_ic_adjs_jnl_row1.lot_status := l_qty_rec.lot_status;
1669: x_ic_adjs_jnl_row1.line_type := 0;
1670: END IF;
1671: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
1672: , p_data => x_msg_data

Line 1669: x_ic_adjs_jnl_row1.line_type := 0;

1665: x_ic_adjs_jnl_row2.qty2 := -x_ic_adjs_jnl_row1.qty2;
1666: ELSE
1667: x_ic_adjs_jnl_row1.qc_grade := l_qty_rec.qc_grade;
1668: x_ic_adjs_jnl_row1.lot_status := l_qty_rec.lot_status;
1669: x_ic_adjs_jnl_row1.line_type := 0;
1670: END IF;
1671: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
1672: , p_data => x_msg_data
1673: );

Line 1706: ( p_ic_adjs_jnl_row IN ic_adjs_jnl%ROWTYPE

1702: END Validate_Inventory_Posting;
1703:
1704:
1705: PROCEDURE Construct_Txn_Rec
1706: ( p_ic_adjs_jnl_row IN ic_adjs_jnl%ROWTYPE
1707: ,x_tran_rec OUT NOCOPY GMI_TRANS_ENGINE_PUB.ictran_rec
1708: )
1709: IS
1710: BEGIN

Line 1711: x_tran_rec.item_id := p_ic_adjs_jnl_row.item_id;

1707: ,x_tran_rec OUT NOCOPY GMI_TRANS_ENGINE_PUB.ictran_rec
1708: )
1709: IS
1710: BEGIN
1711: x_tran_rec.item_id := p_ic_adjs_jnl_row.item_id;
1712: x_tran_rec.line_id := p_ic_adjs_jnl_row.line_id;
1713: x_tran_rec.co_code := p_ic_adjs_jnl_row.co_code;
1714: x_tran_rec.orgn_code := p_ic_adjs_jnl_row.orgn_code;
1715: x_tran_rec.whse_code := p_ic_adjs_jnl_row.whse_code;

Line 1712: x_tran_rec.line_id := p_ic_adjs_jnl_row.line_id;

1708: )
1709: IS
1710: BEGIN
1711: x_tran_rec.item_id := p_ic_adjs_jnl_row.item_id;
1712: x_tran_rec.line_id := p_ic_adjs_jnl_row.line_id;
1713: x_tran_rec.co_code := p_ic_adjs_jnl_row.co_code;
1714: x_tran_rec.orgn_code := p_ic_adjs_jnl_row.orgn_code;
1715: x_tran_rec.whse_code := p_ic_adjs_jnl_row.whse_code;
1716: x_tran_rec.lot_id := p_ic_adjs_jnl_row.lot_id;

Line 1713: x_tran_rec.co_code := p_ic_adjs_jnl_row.co_code;

1709: IS
1710: BEGIN
1711: x_tran_rec.item_id := p_ic_adjs_jnl_row.item_id;
1712: x_tran_rec.line_id := p_ic_adjs_jnl_row.line_id;
1713: x_tran_rec.co_code := p_ic_adjs_jnl_row.co_code;
1714: x_tran_rec.orgn_code := p_ic_adjs_jnl_row.orgn_code;
1715: x_tran_rec.whse_code := p_ic_adjs_jnl_row.whse_code;
1716: x_tran_rec.lot_id := p_ic_adjs_jnl_row.lot_id;
1717: x_tran_rec.location := p_ic_adjs_jnl_row.location;

Line 1714: x_tran_rec.orgn_code := p_ic_adjs_jnl_row.orgn_code;

1710: BEGIN
1711: x_tran_rec.item_id := p_ic_adjs_jnl_row.item_id;
1712: x_tran_rec.line_id := p_ic_adjs_jnl_row.line_id;
1713: x_tran_rec.co_code := p_ic_adjs_jnl_row.co_code;
1714: x_tran_rec.orgn_code := p_ic_adjs_jnl_row.orgn_code;
1715: x_tran_rec.whse_code := p_ic_adjs_jnl_row.whse_code;
1716: x_tran_rec.lot_id := p_ic_adjs_jnl_row.lot_id;
1717: x_tran_rec.location := p_ic_adjs_jnl_row.location;
1718: x_tran_rec.doc_id := p_ic_adjs_jnl_row.doc_id;

Line 1715: x_tran_rec.whse_code := p_ic_adjs_jnl_row.whse_code;

1711: x_tran_rec.item_id := p_ic_adjs_jnl_row.item_id;
1712: x_tran_rec.line_id := p_ic_adjs_jnl_row.line_id;
1713: x_tran_rec.co_code := p_ic_adjs_jnl_row.co_code;
1714: x_tran_rec.orgn_code := p_ic_adjs_jnl_row.orgn_code;
1715: x_tran_rec.whse_code := p_ic_adjs_jnl_row.whse_code;
1716: x_tran_rec.lot_id := p_ic_adjs_jnl_row.lot_id;
1717: x_tran_rec.location := p_ic_adjs_jnl_row.location;
1718: x_tran_rec.doc_id := p_ic_adjs_jnl_row.doc_id;
1719: x_tran_rec.doc_type := p_ic_adjs_jnl_row.trans_type;

Line 1716: x_tran_rec.lot_id := p_ic_adjs_jnl_row.lot_id;

1712: x_tran_rec.line_id := p_ic_adjs_jnl_row.line_id;
1713: x_tran_rec.co_code := p_ic_adjs_jnl_row.co_code;
1714: x_tran_rec.orgn_code := p_ic_adjs_jnl_row.orgn_code;
1715: x_tran_rec.whse_code := p_ic_adjs_jnl_row.whse_code;
1716: x_tran_rec.lot_id := p_ic_adjs_jnl_row.lot_id;
1717: x_tran_rec.location := p_ic_adjs_jnl_row.location;
1718: x_tran_rec.doc_id := p_ic_adjs_jnl_row.doc_id;
1719: x_tran_rec.doc_type := p_ic_adjs_jnl_row.trans_type;
1720: x_tran_rec.doc_line := p_ic_adjs_jnl_row.doc_line;

Line 1717: x_tran_rec.location := p_ic_adjs_jnl_row.location;

1713: x_tran_rec.co_code := p_ic_adjs_jnl_row.co_code;
1714: x_tran_rec.orgn_code := p_ic_adjs_jnl_row.orgn_code;
1715: x_tran_rec.whse_code := p_ic_adjs_jnl_row.whse_code;
1716: x_tran_rec.lot_id := p_ic_adjs_jnl_row.lot_id;
1717: x_tran_rec.location := p_ic_adjs_jnl_row.location;
1718: x_tran_rec.doc_id := p_ic_adjs_jnl_row.doc_id;
1719: x_tran_rec.doc_type := p_ic_adjs_jnl_row.trans_type;
1720: x_tran_rec.doc_line := p_ic_adjs_jnl_row.doc_line;
1721: x_tran_rec.line_type := p_ic_adjs_jnl_row.line_type;

Line 1718: x_tran_rec.doc_id := p_ic_adjs_jnl_row.doc_id;

1714: x_tran_rec.orgn_code := p_ic_adjs_jnl_row.orgn_code;
1715: x_tran_rec.whse_code := p_ic_adjs_jnl_row.whse_code;
1716: x_tran_rec.lot_id := p_ic_adjs_jnl_row.lot_id;
1717: x_tran_rec.location := p_ic_adjs_jnl_row.location;
1718: x_tran_rec.doc_id := p_ic_adjs_jnl_row.doc_id;
1719: x_tran_rec.doc_type := p_ic_adjs_jnl_row.trans_type;
1720: x_tran_rec.doc_line := p_ic_adjs_jnl_row.doc_line;
1721: x_tran_rec.line_type := p_ic_adjs_jnl_row.line_type;
1722: x_tran_rec.reason_code := p_ic_adjs_jnl_row.reason_code;

Line 1719: x_tran_rec.doc_type := p_ic_adjs_jnl_row.trans_type;

1715: x_tran_rec.whse_code := p_ic_adjs_jnl_row.whse_code;
1716: x_tran_rec.lot_id := p_ic_adjs_jnl_row.lot_id;
1717: x_tran_rec.location := p_ic_adjs_jnl_row.location;
1718: x_tran_rec.doc_id := p_ic_adjs_jnl_row.doc_id;
1719: x_tran_rec.doc_type := p_ic_adjs_jnl_row.trans_type;
1720: x_tran_rec.doc_line := p_ic_adjs_jnl_row.doc_line;
1721: x_tran_rec.line_type := p_ic_adjs_jnl_row.line_type;
1722: x_tran_rec.reason_code := p_ic_adjs_jnl_row.reason_code;
1723:

Line 1720: x_tran_rec.doc_line := p_ic_adjs_jnl_row.doc_line;

1716: x_tran_rec.lot_id := p_ic_adjs_jnl_row.lot_id;
1717: x_tran_rec.location := p_ic_adjs_jnl_row.location;
1718: x_tran_rec.doc_id := p_ic_adjs_jnl_row.doc_id;
1719: x_tran_rec.doc_type := p_ic_adjs_jnl_row.trans_type;
1720: x_tran_rec.doc_line := p_ic_adjs_jnl_row.doc_line;
1721: x_tran_rec.line_type := p_ic_adjs_jnl_row.line_type;
1722: x_tran_rec.reason_code := p_ic_adjs_jnl_row.reason_code;
1723:
1724: --Jalaj Srivastava Bug 1683162

Line 1721: x_tran_rec.line_type := p_ic_adjs_jnl_row.line_type;

1717: x_tran_rec.location := p_ic_adjs_jnl_row.location;
1718: x_tran_rec.doc_id := p_ic_adjs_jnl_row.doc_id;
1719: x_tran_rec.doc_type := p_ic_adjs_jnl_row.trans_type;
1720: x_tran_rec.doc_line := p_ic_adjs_jnl_row.doc_line;
1721: x_tran_rec.line_type := p_ic_adjs_jnl_row.line_type;
1722: x_tran_rec.reason_code := p_ic_adjs_jnl_row.reason_code;
1723:
1724: --Jalaj Srivastava Bug 1683162
1725: --trans date should be the date entered by the user and not the sysdate

Line 1722: x_tran_rec.reason_code := p_ic_adjs_jnl_row.reason_code;

1718: x_tran_rec.doc_id := p_ic_adjs_jnl_row.doc_id;
1719: x_tran_rec.doc_type := p_ic_adjs_jnl_row.trans_type;
1720: x_tran_rec.doc_line := p_ic_adjs_jnl_row.doc_line;
1721: x_tran_rec.line_type := p_ic_adjs_jnl_row.line_type;
1722: x_tran_rec.reason_code := p_ic_adjs_jnl_row.reason_code;
1723:
1724: --Jalaj Srivastava Bug 1683162
1725: --trans date should be the date entered by the user and not the sysdate
1726:

Line 1727: x_tran_rec.trans_date := p_ic_adjs_jnl_row.doc_date;

1723:
1724: --Jalaj Srivastava Bug 1683162
1725: --trans date should be the date entered by the user and not the sysdate
1726:
1727: x_tran_rec.trans_date := p_ic_adjs_jnl_row.doc_date;
1728: x_tran_rec.trans_qty := p_ic_adjs_jnl_row.qty;
1729: x_tran_rec.trans_qty2 := p_ic_adjs_jnl_row.qty2;
1730: x_tran_rec.qc_grade := p_ic_adjs_jnl_row.qc_grade;
1731: x_tran_rec.lot_no := NULL;

Line 1728: x_tran_rec.trans_qty := p_ic_adjs_jnl_row.qty;

1724: --Jalaj Srivastava Bug 1683162
1725: --trans date should be the date entered by the user and not the sysdate
1726:
1727: x_tran_rec.trans_date := p_ic_adjs_jnl_row.doc_date;
1728: x_tran_rec.trans_qty := p_ic_adjs_jnl_row.qty;
1729: x_tran_rec.trans_qty2 := p_ic_adjs_jnl_row.qty2;
1730: x_tran_rec.qc_grade := p_ic_adjs_jnl_row.qc_grade;
1731: x_tran_rec.lot_no := NULL;
1732: x_tran_rec.sublot_no := NULL;

Line 1729: x_tran_rec.trans_qty2 := p_ic_adjs_jnl_row.qty2;

1725: --trans date should be the date entered by the user and not the sysdate
1726:
1727: x_tran_rec.trans_date := p_ic_adjs_jnl_row.doc_date;
1728: x_tran_rec.trans_qty := p_ic_adjs_jnl_row.qty;
1729: x_tran_rec.trans_qty2 := p_ic_adjs_jnl_row.qty2;
1730: x_tran_rec.qc_grade := p_ic_adjs_jnl_row.qc_grade;
1731: x_tran_rec.lot_no := NULL;
1732: x_tran_rec.sublot_no := NULL;
1733: x_tran_rec.lot_status := p_ic_adjs_jnl_row.lot_status;

Line 1730: x_tran_rec.qc_grade := p_ic_adjs_jnl_row.qc_grade;

1726:
1727: x_tran_rec.trans_date := p_ic_adjs_jnl_row.doc_date;
1728: x_tran_rec.trans_qty := p_ic_adjs_jnl_row.qty;
1729: x_tran_rec.trans_qty2 := p_ic_adjs_jnl_row.qty2;
1730: x_tran_rec.qc_grade := p_ic_adjs_jnl_row.qc_grade;
1731: x_tran_rec.lot_no := NULL;
1732: x_tran_rec.sublot_no := NULL;
1733: x_tran_rec.lot_status := p_ic_adjs_jnl_row.lot_status;
1734: x_tran_rec.trans_stat := NULL;

Line 1733: x_tran_rec.lot_status := p_ic_adjs_jnl_row.lot_status;

1729: x_tran_rec.trans_qty2 := p_ic_adjs_jnl_row.qty2;
1730: x_tran_rec.qc_grade := p_ic_adjs_jnl_row.qc_grade;
1731: x_tran_rec.lot_no := NULL;
1732: x_tran_rec.sublot_no := NULL;
1733: x_tran_rec.lot_status := p_ic_adjs_jnl_row.lot_status;
1734: x_tran_rec.trans_stat := NULL;
1735: x_tran_rec.trans_um := p_ic_adjs_jnl_row.item_um;
1736: x_tran_rec.trans_um2 := p_ic_adjs_jnl_row.item_um2;
1737: x_tran_rec.staged_ind := NULL;

Line 1735: x_tran_rec.trans_um := p_ic_adjs_jnl_row.item_um;

1731: x_tran_rec.lot_no := NULL;
1732: x_tran_rec.sublot_no := NULL;
1733: x_tran_rec.lot_status := p_ic_adjs_jnl_row.lot_status;
1734: x_tran_rec.trans_stat := NULL;
1735: x_tran_rec.trans_um := p_ic_adjs_jnl_row.item_um;
1736: x_tran_rec.trans_um2 := p_ic_adjs_jnl_row.item_um2;
1737: x_tran_rec.staged_ind := NULL;
1738: x_tran_rec.event_id := NULL;
1739: x_tran_rec.text_code := NULL;

Line 1736: x_tran_rec.trans_um2 := p_ic_adjs_jnl_row.item_um2;

1732: x_tran_rec.sublot_no := NULL;
1733: x_tran_rec.lot_status := p_ic_adjs_jnl_row.lot_status;
1734: x_tran_rec.trans_stat := NULL;
1735: x_tran_rec.trans_um := p_ic_adjs_jnl_row.item_um;
1736: x_tran_rec.trans_um2 := p_ic_adjs_jnl_row.item_um2;
1737: x_tran_rec.staged_ind := NULL;
1738: x_tran_rec.event_id := NULL;
1739: x_tran_rec.text_code := NULL;
1740: x_tran_rec.user_id := p_ic_adjs_jnl_row.created_by;

Line 1740: x_tran_rec.user_id := p_ic_adjs_jnl_row.created_by;

1736: x_tran_rec.trans_um2 := p_ic_adjs_jnl_row.item_um2;
1737: x_tran_rec.staged_ind := NULL;
1738: x_tran_rec.event_id := NULL;
1739: x_tran_rec.text_code := NULL;
1740: x_tran_rec.user_id := p_ic_adjs_jnl_row.created_by;
1741: x_tran_rec.create_lot_index := NULL;
1742: x_tran_rec.non_inv := NULL;
1743: END construct_txn_rec;
1744: