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_LOTS_CPG

Line 1105: FUNCTION ic_lots_cpg_insert

1101: GMIGUTL.DB_ERRMSG:= SQLERRM;
1102: RETURN FALSE;
1103: END ic_item_cpg_select;
1104:
1105: FUNCTION ic_lots_cpg_insert
1106: (p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE, x_ic_lots_cpg_row IN OUT NOCOPY ic_lots_cpg%ROWTYPE)
1107: RETURN BOOLEAN
1108: IS
1109: BEGIN

Line 1106: (p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE, x_ic_lots_cpg_row IN OUT NOCOPY ic_lots_cpg%ROWTYPE)

1102: RETURN FALSE;
1103: END ic_item_cpg_select;
1104:
1105: FUNCTION ic_lots_cpg_insert
1106: (p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE, x_ic_lots_cpg_row IN OUT NOCOPY ic_lots_cpg%ROWTYPE)
1107: RETURN BOOLEAN
1108: IS
1109: BEGIN
1110: /* Copy input to output */

Line 1112: x_ic_lots_cpg_row := p_ic_lots_cpg_row;

1108: IS
1109: BEGIN
1110: /* Copy input to output */
1111:
1112: x_ic_lots_cpg_row := p_ic_lots_cpg_row;
1113:
1114: INSERT INTO ic_lots_cpg
1115: ( item_id
1116: , lot_id

Line 1114: INSERT INTO ic_lots_cpg

1110: /* Copy input to output */
1111:
1112: x_ic_lots_cpg_row := p_ic_lots_cpg_row;
1113:
1114: INSERT INTO ic_lots_cpg
1115: ( item_id
1116: , lot_id
1117: , ic_matr_date
1118: , ic_hold_date

Line 1126: ( x_ic_lots_cpg_row.item_id

1122: , last_updated_by
1123: , last_update_login
1124: )
1125: VALUES
1126: ( x_ic_lots_cpg_row.item_id
1127: , x_ic_lots_cpg_row.lot_id
1128: , x_ic_lots_cpg_row.ic_matr_date
1129: , x_ic_lots_cpg_row.ic_hold_date
1130: , x_ic_lots_cpg_row.created_by

Line 1127: , x_ic_lots_cpg_row.lot_id

1123: , last_update_login
1124: )
1125: VALUES
1126: ( x_ic_lots_cpg_row.item_id
1127: , x_ic_lots_cpg_row.lot_id
1128: , x_ic_lots_cpg_row.ic_matr_date
1129: , x_ic_lots_cpg_row.ic_hold_date
1130: , x_ic_lots_cpg_row.created_by
1131: , x_ic_lots_cpg_row.creation_date

Line 1128: , x_ic_lots_cpg_row.ic_matr_date

1124: )
1125: VALUES
1126: ( x_ic_lots_cpg_row.item_id
1127: , x_ic_lots_cpg_row.lot_id
1128: , x_ic_lots_cpg_row.ic_matr_date
1129: , x_ic_lots_cpg_row.ic_hold_date
1130: , x_ic_lots_cpg_row.created_by
1131: , x_ic_lots_cpg_row.creation_date
1132: , x_ic_lots_cpg_row.last_update_date

Line 1129: , x_ic_lots_cpg_row.ic_hold_date

1125: VALUES
1126: ( x_ic_lots_cpg_row.item_id
1127: , x_ic_lots_cpg_row.lot_id
1128: , x_ic_lots_cpg_row.ic_matr_date
1129: , x_ic_lots_cpg_row.ic_hold_date
1130: , x_ic_lots_cpg_row.created_by
1131: , x_ic_lots_cpg_row.creation_date
1132: , x_ic_lots_cpg_row.last_update_date
1133: , x_ic_lots_cpg_row.last_updated_by

Line 1130: , x_ic_lots_cpg_row.created_by

1126: ( x_ic_lots_cpg_row.item_id
1127: , x_ic_lots_cpg_row.lot_id
1128: , x_ic_lots_cpg_row.ic_matr_date
1129: , x_ic_lots_cpg_row.ic_hold_date
1130: , x_ic_lots_cpg_row.created_by
1131: , x_ic_lots_cpg_row.creation_date
1132: , x_ic_lots_cpg_row.last_update_date
1133: , x_ic_lots_cpg_row.last_updated_by
1134: , x_ic_lots_cpg_row.last_update_login

Line 1131: , x_ic_lots_cpg_row.creation_date

1127: , x_ic_lots_cpg_row.lot_id
1128: , x_ic_lots_cpg_row.ic_matr_date
1129: , x_ic_lots_cpg_row.ic_hold_date
1130: , x_ic_lots_cpg_row.created_by
1131: , x_ic_lots_cpg_row.creation_date
1132: , x_ic_lots_cpg_row.last_update_date
1133: , x_ic_lots_cpg_row.last_updated_by
1134: , x_ic_lots_cpg_row.last_update_login
1135: );

Line 1132: , x_ic_lots_cpg_row.last_update_date

1128: , x_ic_lots_cpg_row.ic_matr_date
1129: , x_ic_lots_cpg_row.ic_hold_date
1130: , x_ic_lots_cpg_row.created_by
1131: , x_ic_lots_cpg_row.creation_date
1132: , x_ic_lots_cpg_row.last_update_date
1133: , x_ic_lots_cpg_row.last_updated_by
1134: , x_ic_lots_cpg_row.last_update_login
1135: );
1136:

Line 1133: , x_ic_lots_cpg_row.last_updated_by

1129: , x_ic_lots_cpg_row.ic_hold_date
1130: , x_ic_lots_cpg_row.created_by
1131: , x_ic_lots_cpg_row.creation_date
1132: , x_ic_lots_cpg_row.last_update_date
1133: , x_ic_lots_cpg_row.last_updated_by
1134: , x_ic_lots_cpg_row.last_update_login
1135: );
1136:
1137: GMIGUTL.DB_ERRNUM := NULL;

Line 1134: , x_ic_lots_cpg_row.last_update_login

1130: , x_ic_lots_cpg_row.created_by
1131: , x_ic_lots_cpg_row.creation_date
1132: , x_ic_lots_cpg_row.last_update_date
1133: , x_ic_lots_cpg_row.last_updated_by
1134: , x_ic_lots_cpg_row.last_update_login
1135: );
1136:
1137: GMIGUTL.DB_ERRNUM := NULL;
1138: RETURN TRUE;

Line 1151: END ic_lots_cpg_insert;

1147:
1148: GMIGUTL.DB_ERRNUM := SQLCODE;
1149: GMIGUTL.DB_ERRMSG:= SQLERRM;
1150: RETURN FALSE;
1151: END ic_lots_cpg_insert;
1152:
1153: FUNCTION ic_lots_cpg_select
1154: (p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE, x_ic_lots_cpg_row IN OUT NOCOPY ic_lots_cpg%ROWTYPE)
1155: RETURN BOOLEAN

Line 1153: FUNCTION ic_lots_cpg_select

1149: GMIGUTL.DB_ERRMSG:= SQLERRM;
1150: RETURN FALSE;
1151: END ic_lots_cpg_insert;
1152:
1153: FUNCTION ic_lots_cpg_select
1154: (p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE, x_ic_lots_cpg_row IN OUT NOCOPY ic_lots_cpg%ROWTYPE)
1155: RETURN BOOLEAN
1156: IS BEGIN
1157:

Line 1154: (p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE, x_ic_lots_cpg_row IN OUT NOCOPY ic_lots_cpg%ROWTYPE)

1150: RETURN FALSE;
1151: END ic_lots_cpg_insert;
1152:
1153: FUNCTION ic_lots_cpg_select
1154: (p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE, x_ic_lots_cpg_row IN OUT NOCOPY ic_lots_cpg%ROWTYPE)
1155: RETURN BOOLEAN
1156: IS BEGIN
1157:
1158: SELECT * INTO x_ic_lots_cpg_row FROM ic_lots_cpg

Line 1158: SELECT * INTO x_ic_lots_cpg_row FROM ic_lots_cpg

1154: (p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE, x_ic_lots_cpg_row IN OUT NOCOPY ic_lots_cpg%ROWTYPE)
1155: RETURN BOOLEAN
1156: IS BEGIN
1157:
1158: SELECT * INTO x_ic_lots_cpg_row FROM ic_lots_cpg
1159: WHERE item_id = p_ic_lots_cpg_row.item_id AND
1160: lot_id = p_ic_lots_cpg_row.lot_id;
1161: GMIGUTL.DB_ERRNUM := NULL;
1162: RETURN TRUE;

Line 1159: WHERE item_id = p_ic_lots_cpg_row.item_id AND

1155: RETURN BOOLEAN
1156: IS BEGIN
1157:
1158: SELECT * INTO x_ic_lots_cpg_row FROM ic_lots_cpg
1159: WHERE item_id = p_ic_lots_cpg_row.item_id AND
1160: lot_id = p_ic_lots_cpg_row.lot_id;
1161: GMIGUTL.DB_ERRNUM := NULL;
1162: RETURN TRUE;
1163:

Line 1160: lot_id = p_ic_lots_cpg_row.lot_id;

1156: IS BEGIN
1157:
1158: SELECT * INTO x_ic_lots_cpg_row FROM ic_lots_cpg
1159: WHERE item_id = p_ic_lots_cpg_row.item_id AND
1160: lot_id = p_ic_lots_cpg_row.lot_id;
1161: GMIGUTL.DB_ERRNUM := NULL;
1162: RETURN TRUE;
1163:
1164: EXCEPTION

Line 1184: END ic_lots_cpg_select;

1180:
1181: GMIGUTL.DB_ERRNUM := SQLCODE;
1182: GMIGUTL.DB_ERRMSG:= SQLERRM;
1183: RETURN FALSE;
1184: END ic_lots_cpg_select;
1185:
1186: FUNCTION ic_lots_sts_select
1187: (p_ic_lots_sts_row IN ic_lots_sts%ROWTYPE, x_ic_lots_sts_row IN OUT NOCOPY ic_lots_sts%ROWTYPE)
1188: RETURN BOOLEAN