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_JRNL_MST

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 481: , x_ic_jrnl_mst_row OUT NOCOPY ic_jrnl_mst%ROWTYPE

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
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

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 1530: x_ic_jrnl_mst_row.journal_id := NULL;

1526:
1527: /* If we've reached this far then all is OK. Create the journalling */
1528: /* rows ready to pass back to the calling API. */
1529:
1530: x_ic_jrnl_mst_row.journal_id := NULL;
1531: x_ic_jrnl_mst_row.journal_no := NULL;
1532: --BEGIN BUG#1962677 K.RajaSekhar
1533: x_ic_jrnl_mst_row.journal_comment := NULL;
1534: x_ic_jrnl_mst_row.journal_comment := l_qty_rec.journal_comment;

Line 1531: x_ic_jrnl_mst_row.journal_no := NULL;

1527: /* If we've reached this far then all is OK. Create the journalling */
1528: /* rows ready to pass back to the calling API. */
1529:
1530: x_ic_jrnl_mst_row.journal_id := NULL;
1531: x_ic_jrnl_mst_row.journal_no := NULL;
1532: --BEGIN BUG#1962677 K.RajaSekhar
1533: x_ic_jrnl_mst_row.journal_comment := NULL;
1534: x_ic_jrnl_mst_row.journal_comment := l_qty_rec.journal_comment;
1535: --END BUG#1962677

Line 1533: x_ic_jrnl_mst_row.journal_comment := NULL;

1529:
1530: x_ic_jrnl_mst_row.journal_id := NULL;
1531: x_ic_jrnl_mst_row.journal_no := NULL;
1532: --BEGIN BUG#1962677 K.RajaSekhar
1533: x_ic_jrnl_mst_row.journal_comment := NULL;
1534: x_ic_jrnl_mst_row.journal_comment := l_qty_rec.journal_comment;
1535: --END BUG#1962677
1536: x_ic_jrnl_mst_row.posting_id := 0;
1537: x_ic_jrnl_mst_row.print_cnt := 0;

Line 1534: x_ic_jrnl_mst_row.journal_comment := l_qty_rec.journal_comment;

1530: x_ic_jrnl_mst_row.journal_id := NULL;
1531: x_ic_jrnl_mst_row.journal_no := NULL;
1532: --BEGIN BUG#1962677 K.RajaSekhar
1533: x_ic_jrnl_mst_row.journal_comment := NULL;
1534: x_ic_jrnl_mst_row.journal_comment := l_qty_rec.journal_comment;
1535: --END BUG#1962677
1536: x_ic_jrnl_mst_row.posting_id := 0;
1537: x_ic_jrnl_mst_row.print_cnt := 0;
1538: --Jalaj Srivastava Bug 2483656

Line 1536: x_ic_jrnl_mst_row.posting_id := 0;

1532: --BEGIN BUG#1962677 K.RajaSekhar
1533: x_ic_jrnl_mst_row.journal_comment := NULL;
1534: x_ic_jrnl_mst_row.journal_comment := l_qty_rec.journal_comment;
1535: --END BUG#1962677
1536: x_ic_jrnl_mst_row.posting_id := 0;
1537: x_ic_jrnl_mst_row.print_cnt := 0;
1538: --Jalaj Srivastava Bug 2483656
1539: IF (l_qty_rec.journal_ind = 'N') THEN --Immediate txn
1540: x_ic_jrnl_mst_row.posted_ind := 1;

Line 1537: x_ic_jrnl_mst_row.print_cnt := 0;

1533: x_ic_jrnl_mst_row.journal_comment := NULL;
1534: x_ic_jrnl_mst_row.journal_comment := l_qty_rec.journal_comment;
1535: --END BUG#1962677
1536: x_ic_jrnl_mst_row.posting_id := 0;
1537: x_ic_jrnl_mst_row.print_cnt := 0;
1538: --Jalaj Srivastava Bug 2483656
1539: IF (l_qty_rec.journal_ind = 'N') THEN --Immediate txn
1540: x_ic_jrnl_mst_row.posted_ind := 1;
1541: ELSE

Line 1540: x_ic_jrnl_mst_row.posted_ind := 1;

1536: x_ic_jrnl_mst_row.posting_id := 0;
1537: x_ic_jrnl_mst_row.print_cnt := 0;
1538: --Jalaj Srivastava Bug 2483656
1539: IF (l_qty_rec.journal_ind = 'N') THEN --Immediate txn
1540: x_ic_jrnl_mst_row.posted_ind := 1;
1541: ELSE
1542: x_ic_jrnl_mst_row.posted_ind := 0;
1543: END IF;
1544: x_ic_jrnl_mst_row.orgn_code := l_qty_rec.orgn_code;

Line 1542: x_ic_jrnl_mst_row.posted_ind := 0;

1538: --Jalaj Srivastava Bug 2483656
1539: IF (l_qty_rec.journal_ind = 'N') THEN --Immediate txn
1540: x_ic_jrnl_mst_row.posted_ind := 1;
1541: ELSE
1542: x_ic_jrnl_mst_row.posted_ind := 0;
1543: END IF;
1544: x_ic_jrnl_mst_row.orgn_code := l_qty_rec.orgn_code;
1545: x_ic_jrnl_mst_row.creation_date := SYSDATE;
1546: x_ic_jrnl_mst_row.last_update_date := SYSDATE;

Line 1544: x_ic_jrnl_mst_row.orgn_code := l_qty_rec.orgn_code;

1540: x_ic_jrnl_mst_row.posted_ind := 1;
1541: ELSE
1542: x_ic_jrnl_mst_row.posted_ind := 0;
1543: END IF;
1544: x_ic_jrnl_mst_row.orgn_code := l_qty_rec.orgn_code;
1545: x_ic_jrnl_mst_row.creation_date := SYSDATE;
1546: x_ic_jrnl_mst_row.last_update_date := SYSDATE;
1547: -- Bug 1735824
1548: -- Use the user name passed to the API instead of

Line 1545: x_ic_jrnl_mst_row.creation_date := SYSDATE;

1541: ELSE
1542: x_ic_jrnl_mst_row.posted_ind := 0;
1543: END IF;
1544: x_ic_jrnl_mst_row.orgn_code := l_qty_rec.orgn_code;
1545: x_ic_jrnl_mst_row.creation_date := SYSDATE;
1546: x_ic_jrnl_mst_row.last_update_date := SYSDATE;
1547: -- Bug 1735824
1548: -- Use the user name passed to the API instead of
1549: -- defaulting to the setup user name.

Line 1546: x_ic_jrnl_mst_row.last_update_date := SYSDATE;

1542: x_ic_jrnl_mst_row.posted_ind := 0;
1543: END IF;
1544: x_ic_jrnl_mst_row.orgn_code := l_qty_rec.orgn_code;
1545: x_ic_jrnl_mst_row.creation_date := SYSDATE;
1546: x_ic_jrnl_mst_row.last_update_date := SYSDATE;
1547: -- Bug 1735824
1548: -- Use the user name passed to the API instead of
1549: -- defaulting to the setup user name.
1550: x_ic_jrnl_mst_row.created_by := l_user_id;

Line 1550: x_ic_jrnl_mst_row.created_by := l_user_id;

1546: x_ic_jrnl_mst_row.last_update_date := SYSDATE;
1547: -- Bug 1735824
1548: -- Use the user name passed to the API instead of
1549: -- defaulting to the setup user name.
1550: x_ic_jrnl_mst_row.created_by := l_user_id;
1551: x_ic_jrnl_mst_row.last_updated_by := l_user_id;
1552:
1553: x_ic_jrnl_mst_row.delete_mark := 0;
1554: x_ic_jrnl_mst_row.text_code := NULL;

Line 1551: x_ic_jrnl_mst_row.last_updated_by := l_user_id;

1547: -- Bug 1735824
1548: -- Use the user name passed to the API instead of
1549: -- defaulting to the setup user name.
1550: x_ic_jrnl_mst_row.created_by := l_user_id;
1551: x_ic_jrnl_mst_row.last_updated_by := l_user_id;
1552:
1553: x_ic_jrnl_mst_row.delete_mark := 0;
1554: x_ic_jrnl_mst_row.text_code := NULL;
1555: x_ic_jrnl_mst_row.in_use := 0;

Line 1553: x_ic_jrnl_mst_row.delete_mark := 0;

1549: -- defaulting to the setup user name.
1550: x_ic_jrnl_mst_row.created_by := l_user_id;
1551: x_ic_jrnl_mst_row.last_updated_by := l_user_id;
1552:
1553: x_ic_jrnl_mst_row.delete_mark := 0;
1554: x_ic_jrnl_mst_row.text_code := NULL;
1555: x_ic_jrnl_mst_row.in_use := 0;
1556: x_ic_jrnl_mst_row.last_update_login := NULL;
1557: x_ic_jrnl_mst_row.program_application_id := NULL;

Line 1554: x_ic_jrnl_mst_row.text_code := NULL;

1550: x_ic_jrnl_mst_row.created_by := l_user_id;
1551: x_ic_jrnl_mst_row.last_updated_by := l_user_id;
1552:
1553: x_ic_jrnl_mst_row.delete_mark := 0;
1554: x_ic_jrnl_mst_row.text_code := NULL;
1555: x_ic_jrnl_mst_row.in_use := 0;
1556: x_ic_jrnl_mst_row.last_update_login := NULL;
1557: x_ic_jrnl_mst_row.program_application_id := NULL;
1558: x_ic_jrnl_mst_row.program_id := NULL;

Line 1555: x_ic_jrnl_mst_row.in_use := 0;

1551: x_ic_jrnl_mst_row.last_updated_by := l_user_id;
1552:
1553: x_ic_jrnl_mst_row.delete_mark := 0;
1554: x_ic_jrnl_mst_row.text_code := NULL;
1555: x_ic_jrnl_mst_row.in_use := 0;
1556: x_ic_jrnl_mst_row.last_update_login := NULL;
1557: x_ic_jrnl_mst_row.program_application_id := NULL;
1558: x_ic_jrnl_mst_row.program_id := NULL;
1559: x_ic_jrnl_mst_row.program_update_date := NULL;

Line 1556: x_ic_jrnl_mst_row.last_update_login := NULL;

1552:
1553: x_ic_jrnl_mst_row.delete_mark := 0;
1554: x_ic_jrnl_mst_row.text_code := NULL;
1555: x_ic_jrnl_mst_row.in_use := 0;
1556: x_ic_jrnl_mst_row.last_update_login := NULL;
1557: x_ic_jrnl_mst_row.program_application_id := NULL;
1558: x_ic_jrnl_mst_row.program_id := NULL;
1559: x_ic_jrnl_mst_row.program_update_date := NULL;
1560: x_ic_jrnl_mst_row.request_id := NULL;

Line 1557: x_ic_jrnl_mst_row.program_application_id := NULL;

1553: x_ic_jrnl_mst_row.delete_mark := 0;
1554: x_ic_jrnl_mst_row.text_code := NULL;
1555: x_ic_jrnl_mst_row.in_use := 0;
1556: x_ic_jrnl_mst_row.last_update_login := NULL;
1557: x_ic_jrnl_mst_row.program_application_id := NULL;
1558: x_ic_jrnl_mst_row.program_id := NULL;
1559: x_ic_jrnl_mst_row.program_update_date := NULL;
1560: x_ic_jrnl_mst_row.request_id := NULL;
1561: x_ic_jrnl_mst_row.attribute1 := UPPER(l_qty_rec.attribute1);

Line 1558: x_ic_jrnl_mst_row.program_id := NULL;

1554: x_ic_jrnl_mst_row.text_code := NULL;
1555: x_ic_jrnl_mst_row.in_use := 0;
1556: x_ic_jrnl_mst_row.last_update_login := NULL;
1557: x_ic_jrnl_mst_row.program_application_id := NULL;
1558: x_ic_jrnl_mst_row.program_id := NULL;
1559: x_ic_jrnl_mst_row.program_update_date := NULL;
1560: x_ic_jrnl_mst_row.request_id := NULL;
1561: x_ic_jrnl_mst_row.attribute1 := UPPER(l_qty_rec.attribute1);
1562: x_ic_jrnl_mst_row.attribute2 := UPPER(l_qty_rec.attribute2);

Line 1559: x_ic_jrnl_mst_row.program_update_date := NULL;

1555: x_ic_jrnl_mst_row.in_use := 0;
1556: x_ic_jrnl_mst_row.last_update_login := NULL;
1557: x_ic_jrnl_mst_row.program_application_id := NULL;
1558: x_ic_jrnl_mst_row.program_id := NULL;
1559: x_ic_jrnl_mst_row.program_update_date := NULL;
1560: x_ic_jrnl_mst_row.request_id := NULL;
1561: x_ic_jrnl_mst_row.attribute1 := UPPER(l_qty_rec.attribute1);
1562: x_ic_jrnl_mst_row.attribute2 := UPPER(l_qty_rec.attribute2);
1563: x_ic_jrnl_mst_row.attribute3 := UPPER(l_qty_rec.attribute3);

Line 1560: x_ic_jrnl_mst_row.request_id := NULL;

1556: x_ic_jrnl_mst_row.last_update_login := NULL;
1557: x_ic_jrnl_mst_row.program_application_id := NULL;
1558: x_ic_jrnl_mst_row.program_id := NULL;
1559: x_ic_jrnl_mst_row.program_update_date := NULL;
1560: x_ic_jrnl_mst_row.request_id := NULL;
1561: x_ic_jrnl_mst_row.attribute1 := UPPER(l_qty_rec.attribute1);
1562: x_ic_jrnl_mst_row.attribute2 := UPPER(l_qty_rec.attribute2);
1563: x_ic_jrnl_mst_row.attribute3 := UPPER(l_qty_rec.attribute3);
1564: x_ic_jrnl_mst_row.attribute4 := UPPER(l_qty_rec.attribute4);

Line 1561: x_ic_jrnl_mst_row.attribute1 := UPPER(l_qty_rec.attribute1);

1557: x_ic_jrnl_mst_row.program_application_id := NULL;
1558: x_ic_jrnl_mst_row.program_id := NULL;
1559: x_ic_jrnl_mst_row.program_update_date := NULL;
1560: x_ic_jrnl_mst_row.request_id := NULL;
1561: x_ic_jrnl_mst_row.attribute1 := UPPER(l_qty_rec.attribute1);
1562: x_ic_jrnl_mst_row.attribute2 := UPPER(l_qty_rec.attribute2);
1563: x_ic_jrnl_mst_row.attribute3 := UPPER(l_qty_rec.attribute3);
1564: x_ic_jrnl_mst_row.attribute4 := UPPER(l_qty_rec.attribute4);
1565: x_ic_jrnl_mst_row.attribute5 := UPPER(l_qty_rec.attribute5);

Line 1562: x_ic_jrnl_mst_row.attribute2 := UPPER(l_qty_rec.attribute2);

1558: x_ic_jrnl_mst_row.program_id := NULL;
1559: x_ic_jrnl_mst_row.program_update_date := NULL;
1560: x_ic_jrnl_mst_row.request_id := NULL;
1561: x_ic_jrnl_mst_row.attribute1 := UPPER(l_qty_rec.attribute1);
1562: x_ic_jrnl_mst_row.attribute2 := UPPER(l_qty_rec.attribute2);
1563: x_ic_jrnl_mst_row.attribute3 := UPPER(l_qty_rec.attribute3);
1564: x_ic_jrnl_mst_row.attribute4 := UPPER(l_qty_rec.attribute4);
1565: x_ic_jrnl_mst_row.attribute5 := UPPER(l_qty_rec.attribute5);
1566: x_ic_jrnl_mst_row.attribute6 := UPPER(l_qty_rec.attribute6);

Line 1563: x_ic_jrnl_mst_row.attribute3 := UPPER(l_qty_rec.attribute3);

1559: x_ic_jrnl_mst_row.program_update_date := NULL;
1560: x_ic_jrnl_mst_row.request_id := NULL;
1561: x_ic_jrnl_mst_row.attribute1 := UPPER(l_qty_rec.attribute1);
1562: x_ic_jrnl_mst_row.attribute2 := UPPER(l_qty_rec.attribute2);
1563: x_ic_jrnl_mst_row.attribute3 := UPPER(l_qty_rec.attribute3);
1564: x_ic_jrnl_mst_row.attribute4 := UPPER(l_qty_rec.attribute4);
1565: x_ic_jrnl_mst_row.attribute5 := UPPER(l_qty_rec.attribute5);
1566: x_ic_jrnl_mst_row.attribute6 := UPPER(l_qty_rec.attribute6);
1567: x_ic_jrnl_mst_row.attribute7 := UPPER(l_qty_rec.attribute7);

Line 1564: x_ic_jrnl_mst_row.attribute4 := UPPER(l_qty_rec.attribute4);

1560: x_ic_jrnl_mst_row.request_id := NULL;
1561: x_ic_jrnl_mst_row.attribute1 := UPPER(l_qty_rec.attribute1);
1562: x_ic_jrnl_mst_row.attribute2 := UPPER(l_qty_rec.attribute2);
1563: x_ic_jrnl_mst_row.attribute3 := UPPER(l_qty_rec.attribute3);
1564: x_ic_jrnl_mst_row.attribute4 := UPPER(l_qty_rec.attribute4);
1565: x_ic_jrnl_mst_row.attribute5 := UPPER(l_qty_rec.attribute5);
1566: x_ic_jrnl_mst_row.attribute6 := UPPER(l_qty_rec.attribute6);
1567: x_ic_jrnl_mst_row.attribute7 := UPPER(l_qty_rec.attribute7);
1568: x_ic_jrnl_mst_row.attribute8 := UPPER(l_qty_rec.attribute8);

Line 1565: x_ic_jrnl_mst_row.attribute5 := UPPER(l_qty_rec.attribute5);

1561: x_ic_jrnl_mst_row.attribute1 := UPPER(l_qty_rec.attribute1);
1562: x_ic_jrnl_mst_row.attribute2 := UPPER(l_qty_rec.attribute2);
1563: x_ic_jrnl_mst_row.attribute3 := UPPER(l_qty_rec.attribute3);
1564: x_ic_jrnl_mst_row.attribute4 := UPPER(l_qty_rec.attribute4);
1565: x_ic_jrnl_mst_row.attribute5 := UPPER(l_qty_rec.attribute5);
1566: x_ic_jrnl_mst_row.attribute6 := UPPER(l_qty_rec.attribute6);
1567: x_ic_jrnl_mst_row.attribute7 := UPPER(l_qty_rec.attribute7);
1568: x_ic_jrnl_mst_row.attribute8 := UPPER(l_qty_rec.attribute8);
1569: x_ic_jrnl_mst_row.attribute9 := UPPER(l_qty_rec.attribute9);

Line 1566: x_ic_jrnl_mst_row.attribute6 := UPPER(l_qty_rec.attribute6);

1562: x_ic_jrnl_mst_row.attribute2 := UPPER(l_qty_rec.attribute2);
1563: x_ic_jrnl_mst_row.attribute3 := UPPER(l_qty_rec.attribute3);
1564: x_ic_jrnl_mst_row.attribute4 := UPPER(l_qty_rec.attribute4);
1565: x_ic_jrnl_mst_row.attribute5 := UPPER(l_qty_rec.attribute5);
1566: x_ic_jrnl_mst_row.attribute6 := UPPER(l_qty_rec.attribute6);
1567: x_ic_jrnl_mst_row.attribute7 := UPPER(l_qty_rec.attribute7);
1568: x_ic_jrnl_mst_row.attribute8 := UPPER(l_qty_rec.attribute8);
1569: x_ic_jrnl_mst_row.attribute9 := UPPER(l_qty_rec.attribute9);
1570: x_ic_jrnl_mst_row.attribute10 := UPPER(l_qty_rec.attribute10);

Line 1567: x_ic_jrnl_mst_row.attribute7 := UPPER(l_qty_rec.attribute7);

1563: x_ic_jrnl_mst_row.attribute3 := UPPER(l_qty_rec.attribute3);
1564: x_ic_jrnl_mst_row.attribute4 := UPPER(l_qty_rec.attribute4);
1565: x_ic_jrnl_mst_row.attribute5 := UPPER(l_qty_rec.attribute5);
1566: x_ic_jrnl_mst_row.attribute6 := UPPER(l_qty_rec.attribute6);
1567: x_ic_jrnl_mst_row.attribute7 := UPPER(l_qty_rec.attribute7);
1568: x_ic_jrnl_mst_row.attribute8 := UPPER(l_qty_rec.attribute8);
1569: x_ic_jrnl_mst_row.attribute9 := UPPER(l_qty_rec.attribute9);
1570: x_ic_jrnl_mst_row.attribute10 := UPPER(l_qty_rec.attribute10);
1571: x_ic_jrnl_mst_row.attribute11 := UPPER(l_qty_rec.attribute11);

Line 1568: x_ic_jrnl_mst_row.attribute8 := UPPER(l_qty_rec.attribute8);

1564: x_ic_jrnl_mst_row.attribute4 := UPPER(l_qty_rec.attribute4);
1565: x_ic_jrnl_mst_row.attribute5 := UPPER(l_qty_rec.attribute5);
1566: x_ic_jrnl_mst_row.attribute6 := UPPER(l_qty_rec.attribute6);
1567: x_ic_jrnl_mst_row.attribute7 := UPPER(l_qty_rec.attribute7);
1568: x_ic_jrnl_mst_row.attribute8 := UPPER(l_qty_rec.attribute8);
1569: x_ic_jrnl_mst_row.attribute9 := UPPER(l_qty_rec.attribute9);
1570: x_ic_jrnl_mst_row.attribute10 := UPPER(l_qty_rec.attribute10);
1571: x_ic_jrnl_mst_row.attribute11 := UPPER(l_qty_rec.attribute11);
1572: x_ic_jrnl_mst_row.attribute12 := UPPER(l_qty_rec.attribute12);

Line 1569: x_ic_jrnl_mst_row.attribute9 := UPPER(l_qty_rec.attribute9);

1565: x_ic_jrnl_mst_row.attribute5 := UPPER(l_qty_rec.attribute5);
1566: x_ic_jrnl_mst_row.attribute6 := UPPER(l_qty_rec.attribute6);
1567: x_ic_jrnl_mst_row.attribute7 := UPPER(l_qty_rec.attribute7);
1568: x_ic_jrnl_mst_row.attribute8 := UPPER(l_qty_rec.attribute8);
1569: x_ic_jrnl_mst_row.attribute9 := UPPER(l_qty_rec.attribute9);
1570: x_ic_jrnl_mst_row.attribute10 := UPPER(l_qty_rec.attribute10);
1571: x_ic_jrnl_mst_row.attribute11 := UPPER(l_qty_rec.attribute11);
1572: x_ic_jrnl_mst_row.attribute12 := UPPER(l_qty_rec.attribute12);
1573: x_ic_jrnl_mst_row.attribute13 := UPPER(l_qty_rec.attribute13);

Line 1570: x_ic_jrnl_mst_row.attribute10 := UPPER(l_qty_rec.attribute10);

1566: x_ic_jrnl_mst_row.attribute6 := UPPER(l_qty_rec.attribute6);
1567: x_ic_jrnl_mst_row.attribute7 := UPPER(l_qty_rec.attribute7);
1568: x_ic_jrnl_mst_row.attribute8 := UPPER(l_qty_rec.attribute8);
1569: x_ic_jrnl_mst_row.attribute9 := UPPER(l_qty_rec.attribute9);
1570: x_ic_jrnl_mst_row.attribute10 := UPPER(l_qty_rec.attribute10);
1571: x_ic_jrnl_mst_row.attribute11 := UPPER(l_qty_rec.attribute11);
1572: x_ic_jrnl_mst_row.attribute12 := UPPER(l_qty_rec.attribute12);
1573: x_ic_jrnl_mst_row.attribute13 := UPPER(l_qty_rec.attribute13);
1574: x_ic_jrnl_mst_row.attribute14 := UPPER(l_qty_rec.attribute14);

Line 1571: x_ic_jrnl_mst_row.attribute11 := UPPER(l_qty_rec.attribute11);

1567: x_ic_jrnl_mst_row.attribute7 := UPPER(l_qty_rec.attribute7);
1568: x_ic_jrnl_mst_row.attribute8 := UPPER(l_qty_rec.attribute8);
1569: x_ic_jrnl_mst_row.attribute9 := UPPER(l_qty_rec.attribute9);
1570: x_ic_jrnl_mst_row.attribute10 := UPPER(l_qty_rec.attribute10);
1571: x_ic_jrnl_mst_row.attribute11 := UPPER(l_qty_rec.attribute11);
1572: x_ic_jrnl_mst_row.attribute12 := UPPER(l_qty_rec.attribute12);
1573: x_ic_jrnl_mst_row.attribute13 := UPPER(l_qty_rec.attribute13);
1574: x_ic_jrnl_mst_row.attribute14 := UPPER(l_qty_rec.attribute14);
1575: x_ic_jrnl_mst_row.attribute15 := UPPER(l_qty_rec.attribute15);

Line 1572: x_ic_jrnl_mst_row.attribute12 := UPPER(l_qty_rec.attribute12);

1568: x_ic_jrnl_mst_row.attribute8 := UPPER(l_qty_rec.attribute8);
1569: x_ic_jrnl_mst_row.attribute9 := UPPER(l_qty_rec.attribute9);
1570: x_ic_jrnl_mst_row.attribute10 := UPPER(l_qty_rec.attribute10);
1571: x_ic_jrnl_mst_row.attribute11 := UPPER(l_qty_rec.attribute11);
1572: x_ic_jrnl_mst_row.attribute12 := UPPER(l_qty_rec.attribute12);
1573: x_ic_jrnl_mst_row.attribute13 := UPPER(l_qty_rec.attribute13);
1574: x_ic_jrnl_mst_row.attribute14 := UPPER(l_qty_rec.attribute14);
1575: x_ic_jrnl_mst_row.attribute15 := UPPER(l_qty_rec.attribute15);
1576: x_ic_jrnl_mst_row.attribute16 := UPPER(l_qty_rec.attribute16);

Line 1573: x_ic_jrnl_mst_row.attribute13 := UPPER(l_qty_rec.attribute13);

1569: x_ic_jrnl_mst_row.attribute9 := UPPER(l_qty_rec.attribute9);
1570: x_ic_jrnl_mst_row.attribute10 := UPPER(l_qty_rec.attribute10);
1571: x_ic_jrnl_mst_row.attribute11 := UPPER(l_qty_rec.attribute11);
1572: x_ic_jrnl_mst_row.attribute12 := UPPER(l_qty_rec.attribute12);
1573: x_ic_jrnl_mst_row.attribute13 := UPPER(l_qty_rec.attribute13);
1574: x_ic_jrnl_mst_row.attribute14 := UPPER(l_qty_rec.attribute14);
1575: x_ic_jrnl_mst_row.attribute15 := UPPER(l_qty_rec.attribute15);
1576: x_ic_jrnl_mst_row.attribute16 := UPPER(l_qty_rec.attribute16);
1577: x_ic_jrnl_mst_row.attribute17 := UPPER(l_qty_rec.attribute17);

Line 1574: x_ic_jrnl_mst_row.attribute14 := UPPER(l_qty_rec.attribute14);

1570: x_ic_jrnl_mst_row.attribute10 := UPPER(l_qty_rec.attribute10);
1571: x_ic_jrnl_mst_row.attribute11 := UPPER(l_qty_rec.attribute11);
1572: x_ic_jrnl_mst_row.attribute12 := UPPER(l_qty_rec.attribute12);
1573: x_ic_jrnl_mst_row.attribute13 := UPPER(l_qty_rec.attribute13);
1574: x_ic_jrnl_mst_row.attribute14 := UPPER(l_qty_rec.attribute14);
1575: x_ic_jrnl_mst_row.attribute15 := UPPER(l_qty_rec.attribute15);
1576: x_ic_jrnl_mst_row.attribute16 := UPPER(l_qty_rec.attribute16);
1577: x_ic_jrnl_mst_row.attribute17 := UPPER(l_qty_rec.attribute17);
1578: x_ic_jrnl_mst_row.attribute18 := UPPER(l_qty_rec.attribute18);

Line 1575: x_ic_jrnl_mst_row.attribute15 := UPPER(l_qty_rec.attribute15);

1571: x_ic_jrnl_mst_row.attribute11 := UPPER(l_qty_rec.attribute11);
1572: x_ic_jrnl_mst_row.attribute12 := UPPER(l_qty_rec.attribute12);
1573: x_ic_jrnl_mst_row.attribute13 := UPPER(l_qty_rec.attribute13);
1574: x_ic_jrnl_mst_row.attribute14 := UPPER(l_qty_rec.attribute14);
1575: x_ic_jrnl_mst_row.attribute15 := UPPER(l_qty_rec.attribute15);
1576: x_ic_jrnl_mst_row.attribute16 := UPPER(l_qty_rec.attribute16);
1577: x_ic_jrnl_mst_row.attribute17 := UPPER(l_qty_rec.attribute17);
1578: x_ic_jrnl_mst_row.attribute18 := UPPER(l_qty_rec.attribute18);
1579: x_ic_jrnl_mst_row.attribute19 := UPPER(l_qty_rec.attribute19);

Line 1576: x_ic_jrnl_mst_row.attribute16 := UPPER(l_qty_rec.attribute16);

1572: x_ic_jrnl_mst_row.attribute12 := UPPER(l_qty_rec.attribute12);
1573: x_ic_jrnl_mst_row.attribute13 := UPPER(l_qty_rec.attribute13);
1574: x_ic_jrnl_mst_row.attribute14 := UPPER(l_qty_rec.attribute14);
1575: x_ic_jrnl_mst_row.attribute15 := UPPER(l_qty_rec.attribute15);
1576: x_ic_jrnl_mst_row.attribute16 := UPPER(l_qty_rec.attribute16);
1577: x_ic_jrnl_mst_row.attribute17 := UPPER(l_qty_rec.attribute17);
1578: x_ic_jrnl_mst_row.attribute18 := UPPER(l_qty_rec.attribute18);
1579: x_ic_jrnl_mst_row.attribute19 := UPPER(l_qty_rec.attribute19);
1580: x_ic_jrnl_mst_row.attribute20 := UPPER(l_qty_rec.attribute20);

Line 1577: x_ic_jrnl_mst_row.attribute17 := UPPER(l_qty_rec.attribute17);

1573: x_ic_jrnl_mst_row.attribute13 := UPPER(l_qty_rec.attribute13);
1574: x_ic_jrnl_mst_row.attribute14 := UPPER(l_qty_rec.attribute14);
1575: x_ic_jrnl_mst_row.attribute15 := UPPER(l_qty_rec.attribute15);
1576: x_ic_jrnl_mst_row.attribute16 := UPPER(l_qty_rec.attribute16);
1577: x_ic_jrnl_mst_row.attribute17 := UPPER(l_qty_rec.attribute17);
1578: x_ic_jrnl_mst_row.attribute18 := UPPER(l_qty_rec.attribute18);
1579: x_ic_jrnl_mst_row.attribute19 := UPPER(l_qty_rec.attribute19);
1580: x_ic_jrnl_mst_row.attribute20 := UPPER(l_qty_rec.attribute20);
1581: x_ic_jrnl_mst_row.attribute21 := UPPER(l_qty_rec.attribute21);

Line 1578: x_ic_jrnl_mst_row.attribute18 := UPPER(l_qty_rec.attribute18);

1574: x_ic_jrnl_mst_row.attribute14 := UPPER(l_qty_rec.attribute14);
1575: x_ic_jrnl_mst_row.attribute15 := UPPER(l_qty_rec.attribute15);
1576: x_ic_jrnl_mst_row.attribute16 := UPPER(l_qty_rec.attribute16);
1577: x_ic_jrnl_mst_row.attribute17 := UPPER(l_qty_rec.attribute17);
1578: x_ic_jrnl_mst_row.attribute18 := UPPER(l_qty_rec.attribute18);
1579: x_ic_jrnl_mst_row.attribute19 := UPPER(l_qty_rec.attribute19);
1580: x_ic_jrnl_mst_row.attribute20 := UPPER(l_qty_rec.attribute20);
1581: x_ic_jrnl_mst_row.attribute21 := UPPER(l_qty_rec.attribute21);
1582: x_ic_jrnl_mst_row.attribute22 := UPPER(l_qty_rec.attribute22);

Line 1579: x_ic_jrnl_mst_row.attribute19 := UPPER(l_qty_rec.attribute19);

1575: x_ic_jrnl_mst_row.attribute15 := UPPER(l_qty_rec.attribute15);
1576: x_ic_jrnl_mst_row.attribute16 := UPPER(l_qty_rec.attribute16);
1577: x_ic_jrnl_mst_row.attribute17 := UPPER(l_qty_rec.attribute17);
1578: x_ic_jrnl_mst_row.attribute18 := UPPER(l_qty_rec.attribute18);
1579: x_ic_jrnl_mst_row.attribute19 := UPPER(l_qty_rec.attribute19);
1580: x_ic_jrnl_mst_row.attribute20 := UPPER(l_qty_rec.attribute20);
1581: x_ic_jrnl_mst_row.attribute21 := UPPER(l_qty_rec.attribute21);
1582: x_ic_jrnl_mst_row.attribute22 := UPPER(l_qty_rec.attribute22);
1583: x_ic_jrnl_mst_row.attribute23 := UPPER(l_qty_rec.attribute23);

Line 1580: x_ic_jrnl_mst_row.attribute20 := UPPER(l_qty_rec.attribute20);

1576: x_ic_jrnl_mst_row.attribute16 := UPPER(l_qty_rec.attribute16);
1577: x_ic_jrnl_mst_row.attribute17 := UPPER(l_qty_rec.attribute17);
1578: x_ic_jrnl_mst_row.attribute18 := UPPER(l_qty_rec.attribute18);
1579: x_ic_jrnl_mst_row.attribute19 := UPPER(l_qty_rec.attribute19);
1580: x_ic_jrnl_mst_row.attribute20 := UPPER(l_qty_rec.attribute20);
1581: x_ic_jrnl_mst_row.attribute21 := UPPER(l_qty_rec.attribute21);
1582: x_ic_jrnl_mst_row.attribute22 := UPPER(l_qty_rec.attribute22);
1583: x_ic_jrnl_mst_row.attribute23 := UPPER(l_qty_rec.attribute23);
1584: x_ic_jrnl_mst_row.attribute24 := UPPER(l_qty_rec.attribute24);

Line 1581: x_ic_jrnl_mst_row.attribute21 := UPPER(l_qty_rec.attribute21);

1577: x_ic_jrnl_mst_row.attribute17 := UPPER(l_qty_rec.attribute17);
1578: x_ic_jrnl_mst_row.attribute18 := UPPER(l_qty_rec.attribute18);
1579: x_ic_jrnl_mst_row.attribute19 := UPPER(l_qty_rec.attribute19);
1580: x_ic_jrnl_mst_row.attribute20 := UPPER(l_qty_rec.attribute20);
1581: x_ic_jrnl_mst_row.attribute21 := UPPER(l_qty_rec.attribute21);
1582: x_ic_jrnl_mst_row.attribute22 := UPPER(l_qty_rec.attribute22);
1583: x_ic_jrnl_mst_row.attribute23 := UPPER(l_qty_rec.attribute23);
1584: x_ic_jrnl_mst_row.attribute24 := UPPER(l_qty_rec.attribute24);
1585: x_ic_jrnl_mst_row.attribute25 := UPPER(l_qty_rec.attribute25);

Line 1582: x_ic_jrnl_mst_row.attribute22 := UPPER(l_qty_rec.attribute22);

1578: x_ic_jrnl_mst_row.attribute18 := UPPER(l_qty_rec.attribute18);
1579: x_ic_jrnl_mst_row.attribute19 := UPPER(l_qty_rec.attribute19);
1580: x_ic_jrnl_mst_row.attribute20 := UPPER(l_qty_rec.attribute20);
1581: x_ic_jrnl_mst_row.attribute21 := UPPER(l_qty_rec.attribute21);
1582: x_ic_jrnl_mst_row.attribute22 := UPPER(l_qty_rec.attribute22);
1583: x_ic_jrnl_mst_row.attribute23 := UPPER(l_qty_rec.attribute23);
1584: x_ic_jrnl_mst_row.attribute24 := UPPER(l_qty_rec.attribute24);
1585: x_ic_jrnl_mst_row.attribute25 := UPPER(l_qty_rec.attribute25);
1586: x_ic_jrnl_mst_row.attribute26 := UPPER(l_qty_rec.attribute26);

Line 1583: x_ic_jrnl_mst_row.attribute23 := UPPER(l_qty_rec.attribute23);

1579: x_ic_jrnl_mst_row.attribute19 := UPPER(l_qty_rec.attribute19);
1580: x_ic_jrnl_mst_row.attribute20 := UPPER(l_qty_rec.attribute20);
1581: x_ic_jrnl_mst_row.attribute21 := UPPER(l_qty_rec.attribute21);
1582: x_ic_jrnl_mst_row.attribute22 := UPPER(l_qty_rec.attribute22);
1583: x_ic_jrnl_mst_row.attribute23 := UPPER(l_qty_rec.attribute23);
1584: x_ic_jrnl_mst_row.attribute24 := UPPER(l_qty_rec.attribute24);
1585: x_ic_jrnl_mst_row.attribute25 := UPPER(l_qty_rec.attribute25);
1586: x_ic_jrnl_mst_row.attribute26 := UPPER(l_qty_rec.attribute26);
1587: x_ic_jrnl_mst_row.attribute27 := UPPER(l_qty_rec.attribute27);

Line 1584: x_ic_jrnl_mst_row.attribute24 := UPPER(l_qty_rec.attribute24);

1580: x_ic_jrnl_mst_row.attribute20 := UPPER(l_qty_rec.attribute20);
1581: x_ic_jrnl_mst_row.attribute21 := UPPER(l_qty_rec.attribute21);
1582: x_ic_jrnl_mst_row.attribute22 := UPPER(l_qty_rec.attribute22);
1583: x_ic_jrnl_mst_row.attribute23 := UPPER(l_qty_rec.attribute23);
1584: x_ic_jrnl_mst_row.attribute24 := UPPER(l_qty_rec.attribute24);
1585: x_ic_jrnl_mst_row.attribute25 := UPPER(l_qty_rec.attribute25);
1586: x_ic_jrnl_mst_row.attribute26 := UPPER(l_qty_rec.attribute26);
1587: x_ic_jrnl_mst_row.attribute27 := UPPER(l_qty_rec.attribute27);
1588: x_ic_jrnl_mst_row.attribute28 := UPPER(l_qty_rec.attribute28);

Line 1585: x_ic_jrnl_mst_row.attribute25 := UPPER(l_qty_rec.attribute25);

1581: x_ic_jrnl_mst_row.attribute21 := UPPER(l_qty_rec.attribute21);
1582: x_ic_jrnl_mst_row.attribute22 := UPPER(l_qty_rec.attribute22);
1583: x_ic_jrnl_mst_row.attribute23 := UPPER(l_qty_rec.attribute23);
1584: x_ic_jrnl_mst_row.attribute24 := UPPER(l_qty_rec.attribute24);
1585: x_ic_jrnl_mst_row.attribute25 := UPPER(l_qty_rec.attribute25);
1586: x_ic_jrnl_mst_row.attribute26 := UPPER(l_qty_rec.attribute26);
1587: x_ic_jrnl_mst_row.attribute27 := UPPER(l_qty_rec.attribute27);
1588: x_ic_jrnl_mst_row.attribute28 := UPPER(l_qty_rec.attribute28);
1589: x_ic_jrnl_mst_row.attribute29 := UPPER(l_qty_rec.attribute29);

Line 1586: x_ic_jrnl_mst_row.attribute26 := UPPER(l_qty_rec.attribute26);

1582: x_ic_jrnl_mst_row.attribute22 := UPPER(l_qty_rec.attribute22);
1583: x_ic_jrnl_mst_row.attribute23 := UPPER(l_qty_rec.attribute23);
1584: x_ic_jrnl_mst_row.attribute24 := UPPER(l_qty_rec.attribute24);
1585: x_ic_jrnl_mst_row.attribute25 := UPPER(l_qty_rec.attribute25);
1586: x_ic_jrnl_mst_row.attribute26 := UPPER(l_qty_rec.attribute26);
1587: x_ic_jrnl_mst_row.attribute27 := UPPER(l_qty_rec.attribute27);
1588: x_ic_jrnl_mst_row.attribute28 := UPPER(l_qty_rec.attribute28);
1589: x_ic_jrnl_mst_row.attribute29 := UPPER(l_qty_rec.attribute29);
1590: x_ic_jrnl_mst_row.attribute30 := UPPER(l_qty_rec.attribute30);

Line 1587: x_ic_jrnl_mst_row.attribute27 := UPPER(l_qty_rec.attribute27);

1583: x_ic_jrnl_mst_row.attribute23 := UPPER(l_qty_rec.attribute23);
1584: x_ic_jrnl_mst_row.attribute24 := UPPER(l_qty_rec.attribute24);
1585: x_ic_jrnl_mst_row.attribute25 := UPPER(l_qty_rec.attribute25);
1586: x_ic_jrnl_mst_row.attribute26 := UPPER(l_qty_rec.attribute26);
1587: x_ic_jrnl_mst_row.attribute27 := UPPER(l_qty_rec.attribute27);
1588: x_ic_jrnl_mst_row.attribute28 := UPPER(l_qty_rec.attribute28);
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);

Line 1588: x_ic_jrnl_mst_row.attribute28 := UPPER(l_qty_rec.attribute28);

1584: x_ic_jrnl_mst_row.attribute24 := UPPER(l_qty_rec.attribute24);
1585: x_ic_jrnl_mst_row.attribute25 := UPPER(l_qty_rec.attribute25);
1586: x_ic_jrnl_mst_row.attribute26 := UPPER(l_qty_rec.attribute26);
1587: x_ic_jrnl_mst_row.attribute27 := UPPER(l_qty_rec.attribute27);
1588: x_ic_jrnl_mst_row.attribute28 := UPPER(l_qty_rec.attribute28);
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:

Line 1589: x_ic_jrnl_mst_row.attribute29 := UPPER(l_qty_rec.attribute29);

1585: x_ic_jrnl_mst_row.attribute25 := UPPER(l_qty_rec.attribute25);
1586: x_ic_jrnl_mst_row.attribute26 := UPPER(l_qty_rec.attribute26);
1587: x_ic_jrnl_mst_row.attribute27 := UPPER(l_qty_rec.attribute27);
1588: x_ic_jrnl_mst_row.attribute28 := UPPER(l_qty_rec.attribute28);
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;

Line 1590: x_ic_jrnl_mst_row.attribute30 := UPPER(l_qty_rec.attribute30);

1586: x_ic_jrnl_mst_row.attribute26 := UPPER(l_qty_rec.attribute26);
1587: x_ic_jrnl_mst_row.attribute27 := UPPER(l_qty_rec.attribute27);
1588: x_ic_jrnl_mst_row.attribute28 := UPPER(l_qty_rec.attribute28);
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;

Line 1591: x_ic_jrnl_mst_row.attribute_category := UPPER(l_qty_rec.attribute_category);

1587: x_ic_jrnl_mst_row.attribute27 := UPPER(l_qty_rec.attribute27);
1588: x_ic_jrnl_mst_row.attribute28 := UPPER(l_qty_rec.attribute28);
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;