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.GMIVDBL dependencies on IC_ADJS_JNL

Line 1391: FUNCTION ic_adjs_jnl_insert

1387: GMIGUTL.DB_ERRMSG:= SQLERRM;
1388: RETURN FALSE;
1389: END ic_jrnl_mst_select;
1390:
1391: FUNCTION ic_adjs_jnl_insert
1392: (p_ic_adjs_jnl_row IN ic_adjs_jnl%ROWTYPE, x_ic_adjs_jnl_row IN OUT NOCOPY ic_adjs_jnl%ROWTYPE)
1393: RETURN BOOLEAN
1394: IS
1395: BEGIN

Line 1392: (p_ic_adjs_jnl_row IN ic_adjs_jnl%ROWTYPE, x_ic_adjs_jnl_row IN OUT NOCOPY ic_adjs_jnl%ROWTYPE)

1388: RETURN FALSE;
1389: END ic_jrnl_mst_select;
1390:
1391: FUNCTION ic_adjs_jnl_insert
1392: (p_ic_adjs_jnl_row IN ic_adjs_jnl%ROWTYPE, x_ic_adjs_jnl_row IN OUT NOCOPY ic_adjs_jnl%ROWTYPE)
1393: RETURN BOOLEAN
1394: IS
1395: BEGIN
1396: /* Copy input to output */

Line 1398: x_ic_adjs_jnl_row := p_ic_adjs_jnl_row;

1394: IS
1395: BEGIN
1396: /* Copy input to output */
1397:
1398: x_ic_adjs_jnl_row := p_ic_adjs_jnl_row;
1399:
1400: IF x_ic_adjs_jnl_row.doc_id IS NULL
1401: THEN
1402: SELECT gem5_doc_id_s.nextval INTO x_ic_adjs_jnl_row.doc_id FROM dual;

Line 1400: IF x_ic_adjs_jnl_row.doc_id IS NULL

1396: /* Copy input to output */
1397:
1398: x_ic_adjs_jnl_row := p_ic_adjs_jnl_row;
1399:
1400: IF x_ic_adjs_jnl_row.doc_id IS NULL
1401: THEN
1402: SELECT gem5_doc_id_s.nextval INTO x_ic_adjs_jnl_row.doc_id FROM dual;
1403: END IF;
1404:

Line 1402: SELECT gem5_doc_id_s.nextval INTO x_ic_adjs_jnl_row.doc_id FROM dual;

1398: x_ic_adjs_jnl_row := p_ic_adjs_jnl_row;
1399:
1400: IF x_ic_adjs_jnl_row.doc_id IS NULL
1401: THEN
1402: SELECT gem5_doc_id_s.nextval INTO x_ic_adjs_jnl_row.doc_id FROM dual;
1403: END IF;
1404:
1405: IF x_ic_adjs_jnl_row.line_id IS NULL
1406: THEN

Line 1405: IF x_ic_adjs_jnl_row.line_id IS NULL

1401: THEN
1402: SELECT gem5_doc_id_s.nextval INTO x_ic_adjs_jnl_row.doc_id FROM dual;
1403: END IF;
1404:
1405: IF x_ic_adjs_jnl_row.line_id IS NULL
1406: THEN
1407: SELECT gem5_line_id_s.nextval INTO x_ic_adjs_jnl_row.line_id FROM dual;
1408: END IF;
1409:

Line 1407: SELECT gem5_line_id_s.nextval INTO x_ic_adjs_jnl_row.line_id FROM dual;

1403: END IF;
1404:
1405: IF x_ic_adjs_jnl_row.line_id IS NULL
1406: THEN
1407: SELECT gem5_line_id_s.nextval INTO x_ic_adjs_jnl_row.line_id FROM dual;
1408: END IF;
1409:
1410: INSERT INTO ic_adjs_jnl
1411: ( trans_type

Line 1410: INSERT INTO ic_adjs_jnl

1406: THEN
1407: SELECT gem5_line_id_s.nextval INTO x_ic_adjs_jnl_row.line_id FROM dual;
1408: END IF;
1409:
1410: INSERT INTO ic_adjs_jnl
1411: ( trans_type
1412: , trans_flag
1413: , doc_id
1414: , doc_line

Line 1444: ( x_ic_adjs_jnl_row.trans_type

1440: , acctg_unit_id
1441: , acct_id
1442: )
1443: VALUES
1444: ( x_ic_adjs_jnl_row.trans_type
1445: , x_ic_adjs_jnl_row.trans_flag
1446: , x_ic_adjs_jnl_row.doc_id
1447: , x_ic_adjs_jnl_row.doc_line
1448: , x_ic_adjs_jnl_row.journal_id

Line 1445: , x_ic_adjs_jnl_row.trans_flag

1441: , acct_id
1442: )
1443: VALUES
1444: ( x_ic_adjs_jnl_row.trans_type
1445: , x_ic_adjs_jnl_row.trans_flag
1446: , x_ic_adjs_jnl_row.doc_id
1447: , x_ic_adjs_jnl_row.doc_line
1448: , x_ic_adjs_jnl_row.journal_id
1449: , x_ic_adjs_jnl_row.completed_ind

Line 1446: , x_ic_adjs_jnl_row.doc_id

1442: )
1443: VALUES
1444: ( x_ic_adjs_jnl_row.trans_type
1445: , x_ic_adjs_jnl_row.trans_flag
1446: , x_ic_adjs_jnl_row.doc_id
1447: , x_ic_adjs_jnl_row.doc_line
1448: , x_ic_adjs_jnl_row.journal_id
1449: , x_ic_adjs_jnl_row.completed_ind
1450: , x_ic_adjs_jnl_row.whse_code

Line 1447: , x_ic_adjs_jnl_row.doc_line

1443: VALUES
1444: ( x_ic_adjs_jnl_row.trans_type
1445: , x_ic_adjs_jnl_row.trans_flag
1446: , x_ic_adjs_jnl_row.doc_id
1447: , x_ic_adjs_jnl_row.doc_line
1448: , x_ic_adjs_jnl_row.journal_id
1449: , x_ic_adjs_jnl_row.completed_ind
1450: , x_ic_adjs_jnl_row.whse_code
1451: , x_ic_adjs_jnl_row.reason_code

Line 1448: , x_ic_adjs_jnl_row.journal_id

1444: ( x_ic_adjs_jnl_row.trans_type
1445: , x_ic_adjs_jnl_row.trans_flag
1446: , x_ic_adjs_jnl_row.doc_id
1447: , x_ic_adjs_jnl_row.doc_line
1448: , x_ic_adjs_jnl_row.journal_id
1449: , x_ic_adjs_jnl_row.completed_ind
1450: , x_ic_adjs_jnl_row.whse_code
1451: , x_ic_adjs_jnl_row.reason_code
1452: , x_ic_adjs_jnl_row.doc_date

Line 1449: , x_ic_adjs_jnl_row.completed_ind

1445: , x_ic_adjs_jnl_row.trans_flag
1446: , x_ic_adjs_jnl_row.doc_id
1447: , x_ic_adjs_jnl_row.doc_line
1448: , x_ic_adjs_jnl_row.journal_id
1449: , x_ic_adjs_jnl_row.completed_ind
1450: , x_ic_adjs_jnl_row.whse_code
1451: , x_ic_adjs_jnl_row.reason_code
1452: , x_ic_adjs_jnl_row.doc_date
1453: , x_ic_adjs_jnl_row.item_id

Line 1450: , x_ic_adjs_jnl_row.whse_code

1446: , x_ic_adjs_jnl_row.doc_id
1447: , x_ic_adjs_jnl_row.doc_line
1448: , x_ic_adjs_jnl_row.journal_id
1449: , x_ic_adjs_jnl_row.completed_ind
1450: , x_ic_adjs_jnl_row.whse_code
1451: , x_ic_adjs_jnl_row.reason_code
1452: , x_ic_adjs_jnl_row.doc_date
1453: , x_ic_adjs_jnl_row.item_id
1454: , x_ic_adjs_jnl_row.item_um

Line 1451: , x_ic_adjs_jnl_row.reason_code

1447: , x_ic_adjs_jnl_row.doc_line
1448: , x_ic_adjs_jnl_row.journal_id
1449: , x_ic_adjs_jnl_row.completed_ind
1450: , x_ic_adjs_jnl_row.whse_code
1451: , x_ic_adjs_jnl_row.reason_code
1452: , x_ic_adjs_jnl_row.doc_date
1453: , x_ic_adjs_jnl_row.item_id
1454: , x_ic_adjs_jnl_row.item_um
1455: , x_ic_adjs_jnl_row.item_um2

Line 1452: , x_ic_adjs_jnl_row.doc_date

1448: , x_ic_adjs_jnl_row.journal_id
1449: , x_ic_adjs_jnl_row.completed_ind
1450: , x_ic_adjs_jnl_row.whse_code
1451: , x_ic_adjs_jnl_row.reason_code
1452: , x_ic_adjs_jnl_row.doc_date
1453: , x_ic_adjs_jnl_row.item_id
1454: , x_ic_adjs_jnl_row.item_um
1455: , x_ic_adjs_jnl_row.item_um2
1456: , x_ic_adjs_jnl_row.lot_id

Line 1453: , x_ic_adjs_jnl_row.item_id

1449: , x_ic_adjs_jnl_row.completed_ind
1450: , x_ic_adjs_jnl_row.whse_code
1451: , x_ic_adjs_jnl_row.reason_code
1452: , x_ic_adjs_jnl_row.doc_date
1453: , x_ic_adjs_jnl_row.item_id
1454: , x_ic_adjs_jnl_row.item_um
1455: , x_ic_adjs_jnl_row.item_um2
1456: , x_ic_adjs_jnl_row.lot_id
1457: , x_ic_adjs_jnl_row.location

Line 1454: , x_ic_adjs_jnl_row.item_um

1450: , x_ic_adjs_jnl_row.whse_code
1451: , x_ic_adjs_jnl_row.reason_code
1452: , x_ic_adjs_jnl_row.doc_date
1453: , x_ic_adjs_jnl_row.item_id
1454: , x_ic_adjs_jnl_row.item_um
1455: , x_ic_adjs_jnl_row.item_um2
1456: , x_ic_adjs_jnl_row.lot_id
1457: , x_ic_adjs_jnl_row.location
1458: , x_ic_adjs_jnl_row.qty

Line 1455: , x_ic_adjs_jnl_row.item_um2

1451: , x_ic_adjs_jnl_row.reason_code
1452: , x_ic_adjs_jnl_row.doc_date
1453: , x_ic_adjs_jnl_row.item_id
1454: , x_ic_adjs_jnl_row.item_um
1455: , x_ic_adjs_jnl_row.item_um2
1456: , x_ic_adjs_jnl_row.lot_id
1457: , x_ic_adjs_jnl_row.location
1458: , x_ic_adjs_jnl_row.qty
1459: , x_ic_adjs_jnl_row.qty2

Line 1456: , x_ic_adjs_jnl_row.lot_id

1452: , x_ic_adjs_jnl_row.doc_date
1453: , x_ic_adjs_jnl_row.item_id
1454: , x_ic_adjs_jnl_row.item_um
1455: , x_ic_adjs_jnl_row.item_um2
1456: , x_ic_adjs_jnl_row.lot_id
1457: , x_ic_adjs_jnl_row.location
1458: , x_ic_adjs_jnl_row.qty
1459: , x_ic_adjs_jnl_row.qty2
1460: , x_ic_adjs_jnl_row.qc_grade

Line 1457: , x_ic_adjs_jnl_row.location

1453: , x_ic_adjs_jnl_row.item_id
1454: , x_ic_adjs_jnl_row.item_um
1455: , x_ic_adjs_jnl_row.item_um2
1456: , x_ic_adjs_jnl_row.lot_id
1457: , x_ic_adjs_jnl_row.location
1458: , x_ic_adjs_jnl_row.qty
1459: , x_ic_adjs_jnl_row.qty2
1460: , x_ic_adjs_jnl_row.qc_grade
1461: , x_ic_adjs_jnl_row.lot_status

Line 1458: , x_ic_adjs_jnl_row.qty

1454: , x_ic_adjs_jnl_row.item_um
1455: , x_ic_adjs_jnl_row.item_um2
1456: , x_ic_adjs_jnl_row.lot_id
1457: , x_ic_adjs_jnl_row.location
1458: , x_ic_adjs_jnl_row.qty
1459: , x_ic_adjs_jnl_row.qty2
1460: , x_ic_adjs_jnl_row.qc_grade
1461: , x_ic_adjs_jnl_row.lot_status
1462: , x_ic_adjs_jnl_row.line_type

Line 1459: , x_ic_adjs_jnl_row.qty2

1455: , x_ic_adjs_jnl_row.item_um2
1456: , x_ic_adjs_jnl_row.lot_id
1457: , x_ic_adjs_jnl_row.location
1458: , x_ic_adjs_jnl_row.qty
1459: , x_ic_adjs_jnl_row.qty2
1460: , x_ic_adjs_jnl_row.qc_grade
1461: , x_ic_adjs_jnl_row.lot_status
1462: , x_ic_adjs_jnl_row.line_type
1463: , x_ic_adjs_jnl_row.line_id

Line 1460: , x_ic_adjs_jnl_row.qc_grade

1456: , x_ic_adjs_jnl_row.lot_id
1457: , x_ic_adjs_jnl_row.location
1458: , x_ic_adjs_jnl_row.qty
1459: , x_ic_adjs_jnl_row.qty2
1460: , x_ic_adjs_jnl_row.qc_grade
1461: , x_ic_adjs_jnl_row.lot_status
1462: , x_ic_adjs_jnl_row.line_type
1463: , x_ic_adjs_jnl_row.line_id
1464: , x_ic_adjs_jnl_row.co_code

Line 1461: , x_ic_adjs_jnl_row.lot_status

1457: , x_ic_adjs_jnl_row.location
1458: , x_ic_adjs_jnl_row.qty
1459: , x_ic_adjs_jnl_row.qty2
1460: , x_ic_adjs_jnl_row.qc_grade
1461: , x_ic_adjs_jnl_row.lot_status
1462: , x_ic_adjs_jnl_row.line_type
1463: , x_ic_adjs_jnl_row.line_id
1464: , x_ic_adjs_jnl_row.co_code
1465: , x_ic_adjs_jnl_row.orgn_code

Line 1462: , x_ic_adjs_jnl_row.line_type

1458: , x_ic_adjs_jnl_row.qty
1459: , x_ic_adjs_jnl_row.qty2
1460: , x_ic_adjs_jnl_row.qc_grade
1461: , x_ic_adjs_jnl_row.lot_status
1462: , x_ic_adjs_jnl_row.line_type
1463: , x_ic_adjs_jnl_row.line_id
1464: , x_ic_adjs_jnl_row.co_code
1465: , x_ic_adjs_jnl_row.orgn_code
1466: , x_ic_adjs_jnl_row.no_inv

Line 1463: , x_ic_adjs_jnl_row.line_id

1459: , x_ic_adjs_jnl_row.qty2
1460: , x_ic_adjs_jnl_row.qc_grade
1461: , x_ic_adjs_jnl_row.lot_status
1462: , x_ic_adjs_jnl_row.line_type
1463: , x_ic_adjs_jnl_row.line_id
1464: , x_ic_adjs_jnl_row.co_code
1465: , x_ic_adjs_jnl_row.orgn_code
1466: , x_ic_adjs_jnl_row.no_inv
1467: , x_ic_adjs_jnl_row.no_trans

Line 1464: , x_ic_adjs_jnl_row.co_code

1460: , x_ic_adjs_jnl_row.qc_grade
1461: , x_ic_adjs_jnl_row.lot_status
1462: , x_ic_adjs_jnl_row.line_type
1463: , x_ic_adjs_jnl_row.line_id
1464: , x_ic_adjs_jnl_row.co_code
1465: , x_ic_adjs_jnl_row.orgn_code
1466: , x_ic_adjs_jnl_row.no_inv
1467: , x_ic_adjs_jnl_row.no_trans
1468: , x_ic_adjs_jnl_row.creation_date

Line 1465: , x_ic_adjs_jnl_row.orgn_code

1461: , x_ic_adjs_jnl_row.lot_status
1462: , x_ic_adjs_jnl_row.line_type
1463: , x_ic_adjs_jnl_row.line_id
1464: , x_ic_adjs_jnl_row.co_code
1465: , x_ic_adjs_jnl_row.orgn_code
1466: , x_ic_adjs_jnl_row.no_inv
1467: , x_ic_adjs_jnl_row.no_trans
1468: , x_ic_adjs_jnl_row.creation_date
1469: , x_ic_adjs_jnl_row.created_by

Line 1466: , x_ic_adjs_jnl_row.no_inv

1462: , x_ic_adjs_jnl_row.line_type
1463: , x_ic_adjs_jnl_row.line_id
1464: , x_ic_adjs_jnl_row.co_code
1465: , x_ic_adjs_jnl_row.orgn_code
1466: , x_ic_adjs_jnl_row.no_inv
1467: , x_ic_adjs_jnl_row.no_trans
1468: , x_ic_adjs_jnl_row.creation_date
1469: , x_ic_adjs_jnl_row.created_by
1470: , x_ic_adjs_jnl_row.last_update_date

Line 1467: , x_ic_adjs_jnl_row.no_trans

1463: , x_ic_adjs_jnl_row.line_id
1464: , x_ic_adjs_jnl_row.co_code
1465: , x_ic_adjs_jnl_row.orgn_code
1466: , x_ic_adjs_jnl_row.no_inv
1467: , x_ic_adjs_jnl_row.no_trans
1468: , x_ic_adjs_jnl_row.creation_date
1469: , x_ic_adjs_jnl_row.created_by
1470: , x_ic_adjs_jnl_row.last_update_date
1471: , x_ic_adjs_jnl_row.trans_cnt

Line 1468: , x_ic_adjs_jnl_row.creation_date

1464: , x_ic_adjs_jnl_row.co_code
1465: , x_ic_adjs_jnl_row.orgn_code
1466: , x_ic_adjs_jnl_row.no_inv
1467: , x_ic_adjs_jnl_row.no_trans
1468: , x_ic_adjs_jnl_row.creation_date
1469: , x_ic_adjs_jnl_row.created_by
1470: , x_ic_adjs_jnl_row.last_update_date
1471: , x_ic_adjs_jnl_row.trans_cnt
1472: , x_ic_adjs_jnl_row.last_updated_by

Line 1469: , x_ic_adjs_jnl_row.created_by

1465: , x_ic_adjs_jnl_row.orgn_code
1466: , x_ic_adjs_jnl_row.no_inv
1467: , x_ic_adjs_jnl_row.no_trans
1468: , x_ic_adjs_jnl_row.creation_date
1469: , x_ic_adjs_jnl_row.created_by
1470: , x_ic_adjs_jnl_row.last_update_date
1471: , x_ic_adjs_jnl_row.trans_cnt
1472: , x_ic_adjs_jnl_row.last_updated_by
1473: , x_ic_adjs_jnl_row.acctg_unit_id

Line 1470: , x_ic_adjs_jnl_row.last_update_date

1466: , x_ic_adjs_jnl_row.no_inv
1467: , x_ic_adjs_jnl_row.no_trans
1468: , x_ic_adjs_jnl_row.creation_date
1469: , x_ic_adjs_jnl_row.created_by
1470: , x_ic_adjs_jnl_row.last_update_date
1471: , x_ic_adjs_jnl_row.trans_cnt
1472: , x_ic_adjs_jnl_row.last_updated_by
1473: , x_ic_adjs_jnl_row.acctg_unit_id
1474: , x_ic_adjs_jnl_row.acct_id

Line 1471: , x_ic_adjs_jnl_row.trans_cnt

1467: , x_ic_adjs_jnl_row.no_trans
1468: , x_ic_adjs_jnl_row.creation_date
1469: , x_ic_adjs_jnl_row.created_by
1470: , x_ic_adjs_jnl_row.last_update_date
1471: , x_ic_adjs_jnl_row.trans_cnt
1472: , x_ic_adjs_jnl_row.last_updated_by
1473: , x_ic_adjs_jnl_row.acctg_unit_id
1474: , x_ic_adjs_jnl_row.acct_id
1475: );

Line 1472: , x_ic_adjs_jnl_row.last_updated_by

1468: , x_ic_adjs_jnl_row.creation_date
1469: , x_ic_adjs_jnl_row.created_by
1470: , x_ic_adjs_jnl_row.last_update_date
1471: , x_ic_adjs_jnl_row.trans_cnt
1472: , x_ic_adjs_jnl_row.last_updated_by
1473: , x_ic_adjs_jnl_row.acctg_unit_id
1474: , x_ic_adjs_jnl_row.acct_id
1475: );
1476:

Line 1473: , x_ic_adjs_jnl_row.acctg_unit_id

1469: , x_ic_adjs_jnl_row.created_by
1470: , x_ic_adjs_jnl_row.last_update_date
1471: , x_ic_adjs_jnl_row.trans_cnt
1472: , x_ic_adjs_jnl_row.last_updated_by
1473: , x_ic_adjs_jnl_row.acctg_unit_id
1474: , x_ic_adjs_jnl_row.acct_id
1475: );
1476:
1477: GMIGUTL.DB_ERRNUM := NULL;

Line 1474: , x_ic_adjs_jnl_row.acct_id

1470: , x_ic_adjs_jnl_row.last_update_date
1471: , x_ic_adjs_jnl_row.trans_cnt
1472: , x_ic_adjs_jnl_row.last_updated_by
1473: , x_ic_adjs_jnl_row.acctg_unit_id
1474: , x_ic_adjs_jnl_row.acct_id
1475: );
1476:
1477: GMIGUTL.DB_ERRNUM := NULL;
1478: RETURN TRUE;

Line 1491: END ic_adjs_jnl_insert;

1487:
1488: GMIGUTL.DB_ERRNUM := SQLCODE;
1489: GMIGUTL.DB_ERRMSG:= SQLERRM;
1490: RETURN FALSE;
1491: END ic_adjs_jnl_insert;
1492:
1493: FUNCTION sy_reas_cds_select
1494: (p_sy_reas_cds_row IN sy_reas_cds%ROWTYPE, x_sy_reas_cds_row IN OUT NOCOPY sy_reas_cds%ROWTYPE)
1495: RETURN BOOLEAN