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

Line 1255: --| Insert_Ic_Adjs_Jnl |

1251: END Insert_Ic_Jrnl_Mst;
1252:
1253: --+=========================================================================+
1254: --| FUNCTION NAME |
1255: --| Insert_Ic_Adjs_Jnl |
1256: --| |
1257: --| TYPE |
1258: --| PRIVATE |
1259: --| |

Line 1264: --| This procedure is used to insert a row into IC_ADJS_JNL |

1260: --| USAGE |
1261: --| Used to insert inventory journal detail |
1262: --| |
1263: --| DESCRIPTION |
1264: --| This procedure is used to insert a row into IC_ADJS_JNL |
1265: --| |
1266: --| PARAMETERS |
1267: --| p_ic_adjs_jnl_rec Record datatype containing row to be inserted |
1268: --| |

Line 1267: --| p_ic_adjs_jnl_rec Record datatype containing row to be inserted |

1263: --| DESCRIPTION |
1264: --| This procedure is used to insert a row into IC_ADJS_JNL |
1265: --| |
1266: --| PARAMETERS |
1267: --| p_ic_adjs_jnl_rec Record datatype containing row to be inserted |
1268: --| |
1269: --| RETURNS |
1270: --| Boolean |
1271: --| |

Line 1275: FUNCTION Insert_Ic_Adjs_Jnl

1271: --| |
1272: --| HISTORY |
1273: --| 01-OCT-1998 M.Godfrey Created |
1274: --+=========================================================================+
1275: FUNCTION Insert_Ic_Adjs_Jnl
1276: ( p_ic_adjs_jnl_rec IN ic_adjs_jnl%ROWTYPE)
1277: RETURN BOOLEAN
1278: IS
1279: BEGIN

Line 1276: ( p_ic_adjs_jnl_rec IN ic_adjs_jnl%ROWTYPE)

1272: --| HISTORY |
1273: --| 01-OCT-1998 M.Godfrey Created |
1274: --+=========================================================================+
1275: FUNCTION Insert_Ic_Adjs_Jnl
1276: ( p_ic_adjs_jnl_rec IN ic_adjs_jnl%ROWTYPE)
1277: RETURN BOOLEAN
1278: IS
1279: BEGIN
1280:

Line 1281: INSERT INTO ic_adjs_jnl

1277: RETURN BOOLEAN
1278: IS
1279: BEGIN
1280:
1281: INSERT INTO ic_adjs_jnl
1282: ( trans_type
1283: , trans_flag
1284: , doc_id
1285: , doc_line

Line 1313: ( p_ic_adjs_jnl_rec.trans_type

1309: , trans_cnt
1310: , last_updated_by
1311: )
1312: VALUES
1313: ( p_ic_adjs_jnl_rec.trans_type
1314: , p_ic_adjs_jnl_rec.trans_flag
1315: , p_ic_adjs_jnl_rec.doc_id
1316: , p_ic_adjs_jnl_rec.doc_line
1317: , p_ic_adjs_jnl_rec.journal_id

Line 1314: , p_ic_adjs_jnl_rec.trans_flag

1310: , last_updated_by
1311: )
1312: VALUES
1313: ( p_ic_adjs_jnl_rec.trans_type
1314: , p_ic_adjs_jnl_rec.trans_flag
1315: , p_ic_adjs_jnl_rec.doc_id
1316: , p_ic_adjs_jnl_rec.doc_line
1317: , p_ic_adjs_jnl_rec.journal_id
1318: , p_ic_adjs_jnl_rec.completed_ind

Line 1315: , p_ic_adjs_jnl_rec.doc_id

1311: )
1312: VALUES
1313: ( p_ic_adjs_jnl_rec.trans_type
1314: , p_ic_adjs_jnl_rec.trans_flag
1315: , p_ic_adjs_jnl_rec.doc_id
1316: , p_ic_adjs_jnl_rec.doc_line
1317: , p_ic_adjs_jnl_rec.journal_id
1318: , p_ic_adjs_jnl_rec.completed_ind
1319: , p_ic_adjs_jnl_rec.whse_code

Line 1316: , p_ic_adjs_jnl_rec.doc_line

1312: VALUES
1313: ( p_ic_adjs_jnl_rec.trans_type
1314: , p_ic_adjs_jnl_rec.trans_flag
1315: , p_ic_adjs_jnl_rec.doc_id
1316: , p_ic_adjs_jnl_rec.doc_line
1317: , p_ic_adjs_jnl_rec.journal_id
1318: , p_ic_adjs_jnl_rec.completed_ind
1319: , p_ic_adjs_jnl_rec.whse_code
1320: , p_ic_adjs_jnl_rec.reason_code

Line 1317: , p_ic_adjs_jnl_rec.journal_id

1313: ( p_ic_adjs_jnl_rec.trans_type
1314: , p_ic_adjs_jnl_rec.trans_flag
1315: , p_ic_adjs_jnl_rec.doc_id
1316: , p_ic_adjs_jnl_rec.doc_line
1317: , p_ic_adjs_jnl_rec.journal_id
1318: , p_ic_adjs_jnl_rec.completed_ind
1319: , p_ic_adjs_jnl_rec.whse_code
1320: , p_ic_adjs_jnl_rec.reason_code
1321: , p_ic_adjs_jnl_rec.doc_date

Line 1318: , p_ic_adjs_jnl_rec.completed_ind

1314: , p_ic_adjs_jnl_rec.trans_flag
1315: , p_ic_adjs_jnl_rec.doc_id
1316: , p_ic_adjs_jnl_rec.doc_line
1317: , p_ic_adjs_jnl_rec.journal_id
1318: , p_ic_adjs_jnl_rec.completed_ind
1319: , p_ic_adjs_jnl_rec.whse_code
1320: , p_ic_adjs_jnl_rec.reason_code
1321: , p_ic_adjs_jnl_rec.doc_date
1322: , p_ic_adjs_jnl_rec.item_id

Line 1319: , p_ic_adjs_jnl_rec.whse_code

1315: , p_ic_adjs_jnl_rec.doc_id
1316: , p_ic_adjs_jnl_rec.doc_line
1317: , p_ic_adjs_jnl_rec.journal_id
1318: , p_ic_adjs_jnl_rec.completed_ind
1319: , p_ic_adjs_jnl_rec.whse_code
1320: , p_ic_adjs_jnl_rec.reason_code
1321: , p_ic_adjs_jnl_rec.doc_date
1322: , p_ic_adjs_jnl_rec.item_id
1323: , p_ic_adjs_jnl_rec.item_um

Line 1320: , p_ic_adjs_jnl_rec.reason_code

1316: , p_ic_adjs_jnl_rec.doc_line
1317: , p_ic_adjs_jnl_rec.journal_id
1318: , p_ic_adjs_jnl_rec.completed_ind
1319: , p_ic_adjs_jnl_rec.whse_code
1320: , p_ic_adjs_jnl_rec.reason_code
1321: , p_ic_adjs_jnl_rec.doc_date
1322: , p_ic_adjs_jnl_rec.item_id
1323: , p_ic_adjs_jnl_rec.item_um
1324: , p_ic_adjs_jnl_rec.item_um2

Line 1321: , p_ic_adjs_jnl_rec.doc_date

1317: , p_ic_adjs_jnl_rec.journal_id
1318: , p_ic_adjs_jnl_rec.completed_ind
1319: , p_ic_adjs_jnl_rec.whse_code
1320: , p_ic_adjs_jnl_rec.reason_code
1321: , p_ic_adjs_jnl_rec.doc_date
1322: , p_ic_adjs_jnl_rec.item_id
1323: , p_ic_adjs_jnl_rec.item_um
1324: , p_ic_adjs_jnl_rec.item_um2
1325: , p_ic_adjs_jnl_rec.lot_id

Line 1322: , p_ic_adjs_jnl_rec.item_id

1318: , p_ic_adjs_jnl_rec.completed_ind
1319: , p_ic_adjs_jnl_rec.whse_code
1320: , p_ic_adjs_jnl_rec.reason_code
1321: , p_ic_adjs_jnl_rec.doc_date
1322: , p_ic_adjs_jnl_rec.item_id
1323: , p_ic_adjs_jnl_rec.item_um
1324: , p_ic_adjs_jnl_rec.item_um2
1325: , p_ic_adjs_jnl_rec.lot_id
1326: , p_ic_adjs_jnl_rec.location

Line 1323: , p_ic_adjs_jnl_rec.item_um

1319: , p_ic_adjs_jnl_rec.whse_code
1320: , p_ic_adjs_jnl_rec.reason_code
1321: , p_ic_adjs_jnl_rec.doc_date
1322: , p_ic_adjs_jnl_rec.item_id
1323: , p_ic_adjs_jnl_rec.item_um
1324: , p_ic_adjs_jnl_rec.item_um2
1325: , p_ic_adjs_jnl_rec.lot_id
1326: , p_ic_adjs_jnl_rec.location
1327: , p_ic_adjs_jnl_rec.qty

Line 1324: , p_ic_adjs_jnl_rec.item_um2

1320: , p_ic_adjs_jnl_rec.reason_code
1321: , p_ic_adjs_jnl_rec.doc_date
1322: , p_ic_adjs_jnl_rec.item_id
1323: , p_ic_adjs_jnl_rec.item_um
1324: , p_ic_adjs_jnl_rec.item_um2
1325: , p_ic_adjs_jnl_rec.lot_id
1326: , p_ic_adjs_jnl_rec.location
1327: , p_ic_adjs_jnl_rec.qty
1328: , p_ic_adjs_jnl_rec.qty2

Line 1325: , p_ic_adjs_jnl_rec.lot_id

1321: , p_ic_adjs_jnl_rec.doc_date
1322: , p_ic_adjs_jnl_rec.item_id
1323: , p_ic_adjs_jnl_rec.item_um
1324: , p_ic_adjs_jnl_rec.item_um2
1325: , p_ic_adjs_jnl_rec.lot_id
1326: , p_ic_adjs_jnl_rec.location
1327: , p_ic_adjs_jnl_rec.qty
1328: , p_ic_adjs_jnl_rec.qty2
1329: , p_ic_adjs_jnl_rec.qc_grade

Line 1326: , p_ic_adjs_jnl_rec.location

1322: , p_ic_adjs_jnl_rec.item_id
1323: , p_ic_adjs_jnl_rec.item_um
1324: , p_ic_adjs_jnl_rec.item_um2
1325: , p_ic_adjs_jnl_rec.lot_id
1326: , p_ic_adjs_jnl_rec.location
1327: , p_ic_adjs_jnl_rec.qty
1328: , p_ic_adjs_jnl_rec.qty2
1329: , p_ic_adjs_jnl_rec.qc_grade
1330: , p_ic_adjs_jnl_rec.lot_status

Line 1327: , p_ic_adjs_jnl_rec.qty

1323: , p_ic_adjs_jnl_rec.item_um
1324: , p_ic_adjs_jnl_rec.item_um2
1325: , p_ic_adjs_jnl_rec.lot_id
1326: , p_ic_adjs_jnl_rec.location
1327: , p_ic_adjs_jnl_rec.qty
1328: , p_ic_adjs_jnl_rec.qty2
1329: , p_ic_adjs_jnl_rec.qc_grade
1330: , p_ic_adjs_jnl_rec.lot_status
1331: , p_ic_adjs_jnl_rec.line_type

Line 1328: , p_ic_adjs_jnl_rec.qty2

1324: , p_ic_adjs_jnl_rec.item_um2
1325: , p_ic_adjs_jnl_rec.lot_id
1326: , p_ic_adjs_jnl_rec.location
1327: , p_ic_adjs_jnl_rec.qty
1328: , p_ic_adjs_jnl_rec.qty2
1329: , p_ic_adjs_jnl_rec.qc_grade
1330: , p_ic_adjs_jnl_rec.lot_status
1331: , p_ic_adjs_jnl_rec.line_type
1332: , p_ic_adjs_jnl_rec.line_id

Line 1329: , p_ic_adjs_jnl_rec.qc_grade

1325: , p_ic_adjs_jnl_rec.lot_id
1326: , p_ic_adjs_jnl_rec.location
1327: , p_ic_adjs_jnl_rec.qty
1328: , p_ic_adjs_jnl_rec.qty2
1329: , p_ic_adjs_jnl_rec.qc_grade
1330: , p_ic_adjs_jnl_rec.lot_status
1331: , p_ic_adjs_jnl_rec.line_type
1332: , p_ic_adjs_jnl_rec.line_id
1333: , p_ic_adjs_jnl_rec.co_code

Line 1330: , p_ic_adjs_jnl_rec.lot_status

1326: , p_ic_adjs_jnl_rec.location
1327: , p_ic_adjs_jnl_rec.qty
1328: , p_ic_adjs_jnl_rec.qty2
1329: , p_ic_adjs_jnl_rec.qc_grade
1330: , p_ic_adjs_jnl_rec.lot_status
1331: , p_ic_adjs_jnl_rec.line_type
1332: , p_ic_adjs_jnl_rec.line_id
1333: , p_ic_adjs_jnl_rec.co_code
1334: , p_ic_adjs_jnl_rec.orgn_code

Line 1331: , p_ic_adjs_jnl_rec.line_type

1327: , p_ic_adjs_jnl_rec.qty
1328: , p_ic_adjs_jnl_rec.qty2
1329: , p_ic_adjs_jnl_rec.qc_grade
1330: , p_ic_adjs_jnl_rec.lot_status
1331: , p_ic_adjs_jnl_rec.line_type
1332: , p_ic_adjs_jnl_rec.line_id
1333: , p_ic_adjs_jnl_rec.co_code
1334: , p_ic_adjs_jnl_rec.orgn_code
1335: , p_ic_adjs_jnl_rec.no_inv

Line 1332: , p_ic_adjs_jnl_rec.line_id

1328: , p_ic_adjs_jnl_rec.qty2
1329: , p_ic_adjs_jnl_rec.qc_grade
1330: , p_ic_adjs_jnl_rec.lot_status
1331: , p_ic_adjs_jnl_rec.line_type
1332: , p_ic_adjs_jnl_rec.line_id
1333: , p_ic_adjs_jnl_rec.co_code
1334: , p_ic_adjs_jnl_rec.orgn_code
1335: , p_ic_adjs_jnl_rec.no_inv
1336: , p_ic_adjs_jnl_rec.no_trans

Line 1333: , p_ic_adjs_jnl_rec.co_code

1329: , p_ic_adjs_jnl_rec.qc_grade
1330: , p_ic_adjs_jnl_rec.lot_status
1331: , p_ic_adjs_jnl_rec.line_type
1332: , p_ic_adjs_jnl_rec.line_id
1333: , p_ic_adjs_jnl_rec.co_code
1334: , p_ic_adjs_jnl_rec.orgn_code
1335: , p_ic_adjs_jnl_rec.no_inv
1336: , p_ic_adjs_jnl_rec.no_trans
1337: , p_ic_adjs_jnl_rec.creation_date

Line 1334: , p_ic_adjs_jnl_rec.orgn_code

1330: , p_ic_adjs_jnl_rec.lot_status
1331: , p_ic_adjs_jnl_rec.line_type
1332: , p_ic_adjs_jnl_rec.line_id
1333: , p_ic_adjs_jnl_rec.co_code
1334: , p_ic_adjs_jnl_rec.orgn_code
1335: , p_ic_adjs_jnl_rec.no_inv
1336: , p_ic_adjs_jnl_rec.no_trans
1337: , p_ic_adjs_jnl_rec.creation_date
1338: , p_ic_adjs_jnl_rec.created_by

Line 1335: , p_ic_adjs_jnl_rec.no_inv

1331: , p_ic_adjs_jnl_rec.line_type
1332: , p_ic_adjs_jnl_rec.line_id
1333: , p_ic_adjs_jnl_rec.co_code
1334: , p_ic_adjs_jnl_rec.orgn_code
1335: , p_ic_adjs_jnl_rec.no_inv
1336: , p_ic_adjs_jnl_rec.no_trans
1337: , p_ic_adjs_jnl_rec.creation_date
1338: , p_ic_adjs_jnl_rec.created_by
1339: , p_ic_adjs_jnl_rec.last_update_date

Line 1336: , p_ic_adjs_jnl_rec.no_trans

1332: , p_ic_adjs_jnl_rec.line_id
1333: , p_ic_adjs_jnl_rec.co_code
1334: , p_ic_adjs_jnl_rec.orgn_code
1335: , p_ic_adjs_jnl_rec.no_inv
1336: , p_ic_adjs_jnl_rec.no_trans
1337: , p_ic_adjs_jnl_rec.creation_date
1338: , p_ic_adjs_jnl_rec.created_by
1339: , p_ic_adjs_jnl_rec.last_update_date
1340: , p_ic_adjs_jnl_rec.trans_cnt

Line 1337: , p_ic_adjs_jnl_rec.creation_date

1333: , p_ic_adjs_jnl_rec.co_code
1334: , p_ic_adjs_jnl_rec.orgn_code
1335: , p_ic_adjs_jnl_rec.no_inv
1336: , p_ic_adjs_jnl_rec.no_trans
1337: , p_ic_adjs_jnl_rec.creation_date
1338: , p_ic_adjs_jnl_rec.created_by
1339: , p_ic_adjs_jnl_rec.last_update_date
1340: , p_ic_adjs_jnl_rec.trans_cnt
1341: , p_ic_adjs_jnl_rec.last_updated_by

Line 1338: , p_ic_adjs_jnl_rec.created_by

1334: , p_ic_adjs_jnl_rec.orgn_code
1335: , p_ic_adjs_jnl_rec.no_inv
1336: , p_ic_adjs_jnl_rec.no_trans
1337: , p_ic_adjs_jnl_rec.creation_date
1338: , p_ic_adjs_jnl_rec.created_by
1339: , p_ic_adjs_jnl_rec.last_update_date
1340: , p_ic_adjs_jnl_rec.trans_cnt
1341: , p_ic_adjs_jnl_rec.last_updated_by
1342: );

Line 1339: , p_ic_adjs_jnl_rec.last_update_date

1335: , p_ic_adjs_jnl_rec.no_inv
1336: , p_ic_adjs_jnl_rec.no_trans
1337: , p_ic_adjs_jnl_rec.creation_date
1338: , p_ic_adjs_jnl_rec.created_by
1339: , p_ic_adjs_jnl_rec.last_update_date
1340: , p_ic_adjs_jnl_rec.trans_cnt
1341: , p_ic_adjs_jnl_rec.last_updated_by
1342: );
1343:

Line 1340: , p_ic_adjs_jnl_rec.trans_cnt

1336: , p_ic_adjs_jnl_rec.no_trans
1337: , p_ic_adjs_jnl_rec.creation_date
1338: , p_ic_adjs_jnl_rec.created_by
1339: , p_ic_adjs_jnl_rec.last_update_date
1340: , p_ic_adjs_jnl_rec.trans_cnt
1341: , p_ic_adjs_jnl_rec.last_updated_by
1342: );
1343:
1344: RETURN TRUE;

Line 1341: , p_ic_adjs_jnl_rec.last_updated_by

1337: , p_ic_adjs_jnl_rec.creation_date
1338: , p_ic_adjs_jnl_rec.created_by
1339: , p_ic_adjs_jnl_rec.last_update_date
1340: , p_ic_adjs_jnl_rec.trans_cnt
1341: , p_ic_adjs_jnl_rec.last_updated_by
1342: );
1343:
1344: RETURN TRUE;
1345:

Line 1353: , 'Insert_IC_ADJS_JNL'

1349: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1350: -- THEN
1351:
1352: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1353: , 'Insert_IC_ADJS_JNL'
1354: );
1355: -- END IF;
1356: RETURN FALSE;
1357:

Line 1358: END Insert_Ic_Adjs_Jnl;

1354: );
1355: -- END IF;
1356: RETURN FALSE;
1357:
1358: END Insert_Ic_Adjs_Jnl;
1359:
1360: --+=========================================================================+
1361: --| FUNCTION NAME |
1362: --| Check_unposted_jnl_lot_status |

Line 1402: ic_adjs_jnl a, ic_jrnl_mst j

1398: CURSOR ic_journal IS
1399: SELECT
1400: count(*)
1401: FROM
1402: ic_adjs_jnl a, ic_jrnl_mst j
1403: WHERE
1404: a.item_id = p_item_id AND
1405: a.lot_id = p_lot_id AND
1406: a.whse_code = p_whse_code AND

Line 1479: ic_adjs_jnl a, ic_jrnl_mst j

1475: CURSOR ic_journal IS
1476: SELECT
1477: count(*)
1478: FROM
1479: ic_adjs_jnl a, ic_jrnl_mst j
1480: WHERE
1481: a.item_id = p_item_id AND
1482: a.lot_id = p_lot_id AND
1483: a.journal_id = j.journal_id AND