APPS.GR_ITEM_TOXIC_PKG dependencies on GR_ITEM_TOXIC

Line 1: PACKAGE BODY GR_ITEM_TOXIC_PKG AS

1: PACKAGE BODY GR_ITEM_TOXIC_PKG AS
2: /*$Header: GRHIITB.pls 115.4 2002/10/25 21:17:01 methomas ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 158: INSERT INTO gr_item_toxic

154: IF FND_API.To_Boolean(l_key_exists) THEN
155: RAISE Item_Exists_Error;
156: END IF;
157:
158: INSERT INTO gr_item_toxic
159: (toxic_exposure_code,
160: label_code,
161: item_code,
162: toxic_route_code,

Line 476: UPDATE gr_item_toxic

472:
473: IF l_return_status <> 'S' THEN
474: RAISE Foreign_Key_Error;
475: ELSE
476: UPDATE gr_item_toxic
477: SET toxic_exposure_code = p_toxic_exposure_code,
478: label_code = p_label_code,
479: item_code = p_item_code,
480: toxic_route_code = p_toxic_route_code,

Line 661: FROM gr_item_toxic

657:
658: CURSOR c_lock_item_toxic
659: IS
660: SELECT *
661: FROM gr_item_toxic
662: WHERE rowid = p_rowid
663: FOR UPDATE NOWAIT;
664: LockItemToxRcd c_lock_item_toxic%ROWTYPE;
665:

Line 877: DELETE FROM gr_item_toxic

873: IF l_return_status <> 'S' THEN
874: RAISE Check_Integrity_Error;
875: END IF;
876:
877: DELETE FROM gr_item_toxic
878: WHERE rowid = p_rowid;
879:
880: /* Check the commit flag and if set, then commit the work. */
881:

Line 988: DELETE FROM gr_item_toxic

984: RAISE Null_Delete_Option_Error;
985: ELSE
986: l_msg_token := p_item_code;
987:
988: DELETE FROM gr_item_toxic
989: WHERE item_code = p_item_code;
990: END IF;
991: ELSIF p_delete_option = 'L' THEN
992: IF p_label_code IS NULL THEN

Line 998: DELETE FROM gr_item_toxic

994: RAISE Null_Delete_Option_Error;
995: ELSE
996: l_msg_token := p_label_code;
997:
998: DELETE FROM gr_item_toxic
999: WHERE label_code = p_label_code;
1000: END IF;
1001: ELSIF p_delete_option = 'E' THEN
1002: IF p_toxic_exposure_code IS NULL THEN

Line 1008: DELETE FROM gr_item_toxic

1004: RAISE Null_Delete_Option_Error;
1005: ELSE
1006: l_msg_token := p_toxic_exposure_code;
1007:
1008: DELETE FROM gr_item_toxic
1009: WHERE toxic_exposure_code = p_toxic_exposure_code;
1010: END IF;
1011: ELSIF p_delete_option = 'R' THEN
1012: IF p_toxic_route_code IS NULL THEN

Line 1018: DELETE FROM gr_item_toxic

1014: RAISE Null_Delete_Option_Error;
1015: ELSE
1016: l_msg_token := p_toxic_route_code;
1017:
1018: DELETE FROM gr_item_toxic
1019: WHERE toxic_route_code = p_toxic_route_code;
1020: END IF;
1021: ELSIF p_delete_option = 'S' THEN
1022: IF p_toxic_species_code IS NULL THEN

Line 1028: DELETE FROM gr_item_toxic

1024: RAISE Null_Delete_Option_Error;
1025: ELSE
1026: l_msg_token := p_toxic_species_code;
1027:
1028: DELETE FROM gr_item_toxic
1029: WHERE toxic_species_code = p_toxic_species_code;
1030: END IF;
1031: ELSIF p_delete_option = 'B' THEN
1032: IF p_item_code IS NULL OR

Line 1045: DELETE FROM gr_item_toxic

1041: l_msg_token := l_msg_token || p_toxic_exposure_code || ' ';
1042: l_msg_token := l_msg_token || p_toxic_route_code || ' ';
1043: l_msg_token := l_msg_token || p_toxic_species_code;
1044:
1045: DELETE FROM gr_item_toxic
1046: WHERE item_code = p_item_code
1047: AND label_code = p_label_code
1048: AND toxic_exposure_code = p_toxic_exposure_code
1049: AND toxic_route_code = p_toxic_route_code

Line 1385: FROM gr_item_toxic it

1381:
1382: CURSOR c_get_item_toxic_rowid
1383: IS
1384: SELECT it.rowid
1385: FROM gr_item_toxic it
1386: WHERE it.item_code = p_item_code
1387: AND it.label_code = p_label_code
1388: AND it.toxic_exposure_code = p_toxic_exposure_code
1389: AND it.toxic_route_code = p_toxic_route_code

Line 1426: END GR_ITEM_TOXIC_PKG;

1422: END IF;
1423:
1424: END Check_Primary_Key;
1425:
1426: END GR_ITEM_TOXIC_PKG;