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_JRNL_MST

Line 19: --| Insert_Ic_Jrnl_Mst |

15: --| DESCRIPTION |
16: --| |
17: --| CONTENTS |
18: --| Validate_Inventory_Posting |
19: --| Insert_Ic_Jrnl_Mst |
20: --| Insert_Ic_Adjs_Mst |
21: --| Check_unposted_jnl_lot_status |
22: --| Check_unposted_jnl_qc_grade |
23: --| |

Line 1178: --| Insert_Ic_Jrnl_Mst |

1174: END Validate_Inventory_Posting;
1175:
1176: --+=========================================================================+
1177: --| FUNCTION NAME |
1178: --| Insert_Ic_Jrnl_Mst |
1179: --| |
1180: --| TYPE |
1181: --| PRIVATE |
1182: --| |

Line 1187: --| This procedure is used to insert a row into IC_JRNL_MST |

1183: --| USAGE |
1184: --| Used to insert inventory journal header |
1185: --| |
1186: --| DESCRIPTION |
1187: --| This procedure is used to insert a row into IC_JRNL_MST |
1188: --| |
1189: --| PARAMETERS |
1190: --| p_ic_jrnl_mst_rec Record datatype containing row to be inserted |
1191: --| |

Line 1190: --| p_ic_jrnl_mst_rec Record datatype containing row to be inserted |

1186: --| DESCRIPTION |
1187: --| This procedure is used to insert a row into IC_JRNL_MST |
1188: --| |
1189: --| PARAMETERS |
1190: --| p_ic_jrnl_mst_rec Record datatype containing row to be inserted |
1191: --| |
1192: --| RETURNS |
1193: --| Boolean |
1194: --| |

Line 1198: FUNCTION Insert_Ic_Jrnl_Mst

1194: --| |
1195: --| HISTORY |
1196: --| 01-OCT-1998 M.Godfrey Created |
1197: --+=========================================================================+
1198: FUNCTION Insert_Ic_Jrnl_Mst
1199: ( p_ic_jrnl_mst_rec IN ic_jrnl_mst%ROWTYPE)
1200: RETURN BOOLEAN
1201: IS
1202: BEGIN

Line 1199: ( p_ic_jrnl_mst_rec IN ic_jrnl_mst%ROWTYPE)

1195: --| HISTORY |
1196: --| 01-OCT-1998 M.Godfrey Created |
1197: --+=========================================================================+
1198: FUNCTION Insert_Ic_Jrnl_Mst
1199: ( p_ic_jrnl_mst_rec IN ic_jrnl_mst%ROWTYPE)
1200: RETURN BOOLEAN
1201: IS
1202: BEGIN
1203:

Line 1204: INSERT INTO ic_jrnl_mst

1200: RETURN BOOLEAN
1201: IS
1202: BEGIN
1203:
1204: INSERT INTO ic_jrnl_mst
1205: ( journal_id
1206: , journal_no
1207: , journal_comment
1208: , posting_id

Line 1221: ( p_ic_jrnl_mst_rec.journal_id

1217: , text_code
1218: , in_use
1219: )
1220: VALUES
1221: ( p_ic_jrnl_mst_rec.journal_id
1222: , p_ic_jrnl_mst_rec.journal_no
1223: , p_ic_jrnl_mst_rec.journal_comment
1224: , p_ic_jrnl_mst_rec.posting_id
1225: , p_ic_jrnl_mst_rec.print_cnt

Line 1222: , p_ic_jrnl_mst_rec.journal_no

1218: , in_use
1219: )
1220: VALUES
1221: ( p_ic_jrnl_mst_rec.journal_id
1222: , p_ic_jrnl_mst_rec.journal_no
1223: , p_ic_jrnl_mst_rec.journal_comment
1224: , p_ic_jrnl_mst_rec.posting_id
1225: , p_ic_jrnl_mst_rec.print_cnt
1226: , p_ic_jrnl_mst_rec.posted_ind

Line 1223: , p_ic_jrnl_mst_rec.journal_comment

1219: )
1220: VALUES
1221: ( p_ic_jrnl_mst_rec.journal_id
1222: , p_ic_jrnl_mst_rec.journal_no
1223: , p_ic_jrnl_mst_rec.journal_comment
1224: , p_ic_jrnl_mst_rec.posting_id
1225: , p_ic_jrnl_mst_rec.print_cnt
1226: , p_ic_jrnl_mst_rec.posted_ind
1227: , p_ic_jrnl_mst_rec.orgn_code

Line 1224: , p_ic_jrnl_mst_rec.posting_id

1220: VALUES
1221: ( p_ic_jrnl_mst_rec.journal_id
1222: , p_ic_jrnl_mst_rec.journal_no
1223: , p_ic_jrnl_mst_rec.journal_comment
1224: , p_ic_jrnl_mst_rec.posting_id
1225: , p_ic_jrnl_mst_rec.print_cnt
1226: , p_ic_jrnl_mst_rec.posted_ind
1227: , p_ic_jrnl_mst_rec.orgn_code
1228: , p_ic_jrnl_mst_rec.creation_date

Line 1225: , p_ic_jrnl_mst_rec.print_cnt

1221: ( p_ic_jrnl_mst_rec.journal_id
1222: , p_ic_jrnl_mst_rec.journal_no
1223: , p_ic_jrnl_mst_rec.journal_comment
1224: , p_ic_jrnl_mst_rec.posting_id
1225: , p_ic_jrnl_mst_rec.print_cnt
1226: , p_ic_jrnl_mst_rec.posted_ind
1227: , p_ic_jrnl_mst_rec.orgn_code
1228: , p_ic_jrnl_mst_rec.creation_date
1229: , p_ic_jrnl_mst_rec.last_update_date

Line 1226: , p_ic_jrnl_mst_rec.posted_ind

1222: , p_ic_jrnl_mst_rec.journal_no
1223: , p_ic_jrnl_mst_rec.journal_comment
1224: , p_ic_jrnl_mst_rec.posting_id
1225: , p_ic_jrnl_mst_rec.print_cnt
1226: , p_ic_jrnl_mst_rec.posted_ind
1227: , p_ic_jrnl_mst_rec.orgn_code
1228: , p_ic_jrnl_mst_rec.creation_date
1229: , p_ic_jrnl_mst_rec.last_update_date
1230: , p_ic_jrnl_mst_rec.created_by

Line 1227: , p_ic_jrnl_mst_rec.orgn_code

1223: , p_ic_jrnl_mst_rec.journal_comment
1224: , p_ic_jrnl_mst_rec.posting_id
1225: , p_ic_jrnl_mst_rec.print_cnt
1226: , p_ic_jrnl_mst_rec.posted_ind
1227: , p_ic_jrnl_mst_rec.orgn_code
1228: , p_ic_jrnl_mst_rec.creation_date
1229: , p_ic_jrnl_mst_rec.last_update_date
1230: , p_ic_jrnl_mst_rec.created_by
1231: , p_ic_jrnl_mst_rec.last_updated_by

Line 1228: , p_ic_jrnl_mst_rec.creation_date

1224: , p_ic_jrnl_mst_rec.posting_id
1225: , p_ic_jrnl_mst_rec.print_cnt
1226: , p_ic_jrnl_mst_rec.posted_ind
1227: , p_ic_jrnl_mst_rec.orgn_code
1228: , p_ic_jrnl_mst_rec.creation_date
1229: , p_ic_jrnl_mst_rec.last_update_date
1230: , p_ic_jrnl_mst_rec.created_by
1231: , p_ic_jrnl_mst_rec.last_updated_by
1232: , p_ic_jrnl_mst_rec.delete_mark

Line 1229: , p_ic_jrnl_mst_rec.last_update_date

1225: , p_ic_jrnl_mst_rec.print_cnt
1226: , p_ic_jrnl_mst_rec.posted_ind
1227: , p_ic_jrnl_mst_rec.orgn_code
1228: , p_ic_jrnl_mst_rec.creation_date
1229: , p_ic_jrnl_mst_rec.last_update_date
1230: , p_ic_jrnl_mst_rec.created_by
1231: , p_ic_jrnl_mst_rec.last_updated_by
1232: , p_ic_jrnl_mst_rec.delete_mark
1233: , p_ic_jrnl_mst_rec.text_code

Line 1230: , p_ic_jrnl_mst_rec.created_by

1226: , p_ic_jrnl_mst_rec.posted_ind
1227: , p_ic_jrnl_mst_rec.orgn_code
1228: , p_ic_jrnl_mst_rec.creation_date
1229: , p_ic_jrnl_mst_rec.last_update_date
1230: , p_ic_jrnl_mst_rec.created_by
1231: , p_ic_jrnl_mst_rec.last_updated_by
1232: , p_ic_jrnl_mst_rec.delete_mark
1233: , p_ic_jrnl_mst_rec.text_code
1234: , p_ic_jrnl_mst_rec.in_use

Line 1231: , p_ic_jrnl_mst_rec.last_updated_by

1227: , p_ic_jrnl_mst_rec.orgn_code
1228: , p_ic_jrnl_mst_rec.creation_date
1229: , p_ic_jrnl_mst_rec.last_update_date
1230: , p_ic_jrnl_mst_rec.created_by
1231: , p_ic_jrnl_mst_rec.last_updated_by
1232: , p_ic_jrnl_mst_rec.delete_mark
1233: , p_ic_jrnl_mst_rec.text_code
1234: , p_ic_jrnl_mst_rec.in_use
1235: );

Line 1232: , p_ic_jrnl_mst_rec.delete_mark

1228: , p_ic_jrnl_mst_rec.creation_date
1229: , p_ic_jrnl_mst_rec.last_update_date
1230: , p_ic_jrnl_mst_rec.created_by
1231: , p_ic_jrnl_mst_rec.last_updated_by
1232: , p_ic_jrnl_mst_rec.delete_mark
1233: , p_ic_jrnl_mst_rec.text_code
1234: , p_ic_jrnl_mst_rec.in_use
1235: );
1236:

Line 1233: , p_ic_jrnl_mst_rec.text_code

1229: , p_ic_jrnl_mst_rec.last_update_date
1230: , p_ic_jrnl_mst_rec.created_by
1231: , p_ic_jrnl_mst_rec.last_updated_by
1232: , p_ic_jrnl_mst_rec.delete_mark
1233: , p_ic_jrnl_mst_rec.text_code
1234: , p_ic_jrnl_mst_rec.in_use
1235: );
1236:
1237: RETURN TRUE;

Line 1234: , p_ic_jrnl_mst_rec.in_use

1230: , p_ic_jrnl_mst_rec.created_by
1231: , p_ic_jrnl_mst_rec.last_updated_by
1232: , p_ic_jrnl_mst_rec.delete_mark
1233: , p_ic_jrnl_mst_rec.text_code
1234: , p_ic_jrnl_mst_rec.in_use
1235: );
1236:
1237: RETURN TRUE;
1238:

Line 1246: , 'Insert_IC_JRNL_MST'

1242: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1243: -- THEN
1244:
1245: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1246: , 'Insert_IC_JRNL_MST'
1247: );
1248: -- END IF;
1249: RETURN FALSE;
1250:

Line 1251: END Insert_Ic_Jrnl_Mst;

1247: );
1248: -- END IF;
1249: RETURN FALSE;
1250:
1251: END Insert_Ic_Jrnl_Mst;
1252:
1253: --+=========================================================================+
1254: --| FUNCTION NAME |
1255: --| Insert_Ic_Adjs_Jnl |

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