APPS.GR_ITEM_EXPOSURE_PKG dependencies on GR_ITEM_EXPOSURE

Line 1: PACKAGE BODY GR_ITEM_EXPOSURE_PKG AS

1: PACKAGE BODY GR_ITEM_EXPOSURE_PKG AS
2: /*$Header: GRHIIEB.pls 115.5 2002/10/25 20:43:35 methomas ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 151: INSERT INTO gr_item_exposure

147: IF FND_API.To_Boolean(l_key_exists) THEN
148: RAISE Item_Exists_Error;
149: END IF;
150:
151: INSERT INTO gr_item_exposure
152: (item_code,
153: label_code,
154: exposure_authority_code,
155: exposure_type_code,

Line 459: UPDATE gr_item_exposure

455:
456: IF l_return_status <> 'S' THEN
457: RAISE Foreign_Key_Error;
458: ELSE
459: UPDATE gr_item_exposure
460: SET item_code = p_item_code,
461: label_code = p_label_code,
462: exposure_authority_code = p_exposure_authority_code,
463: exposure_type_code = p_exposure_type_code,

Line 640: FROM gr_item_exposure

636:
637: CURSOR c_lock_item_exposure
638: IS
639: SELECT *
640: FROM gr_item_exposure
641: WHERE rowid = p_rowid
642: FOR UPDATE NOWAIT;
643: LockItemExpRcd c_lock_item_exposure%ROWTYPE;
644: BEGIN

Line 850: DELETE FROM gr_item_exposure

846: IF l_return_status <> 'S' THEN
847: RAISE Check_Integrity_Error;
848: END IF;
849:
850: DELETE FROM gr_item_exposure
851: WHERE rowid = p_rowid;
852:
853: /* Check the commit flag and if set, then commit the work. */
854:

Line 958: DELETE FROM gr_item_exposure

954: RAISE Null_Delete_Option_Error;
955: ELSE
956: l_msg_token := p_item_code;
957:
958: DELETE FROM gr_item_exposure
959: WHERE item_code = p_item_code;
960: END IF;
961: ELSIF p_delete_option = 'L' THEN
962: IF p_label_code IS NULL THEN

Line 968: DELETE FROM gr_item_exposure

964: RAISE Null_Delete_Option_Error;
965: ELSE
966: l_msg_token := p_label_code;
967:
968: DELETE FROM gr_item_exposure
969: WHERE label_code = p_label_code;
970: END IF;
971: ELSIF p_delete_option = 'A' THEN
972: IF p_exposure_authority_code IS NULL THEN

Line 978: DELETE FROM gr_item_exposure

974: RAISE Null_Delete_Option_Error;
975: ELSE
976: l_msg_token := p_exposure_authority_code;
977:
978: DELETE FROM gr_item_exposure
979: WHERE exposure_authority_code = p_exposure_authority_code;
980: END IF;
981: ELSIF p_delete_option = 'T' THEN
982: IF p_exposure_type_code IS NULL THEN

Line 988: DELETE FROM gr_item_exposure

984: RAISE Null_Delete_Option_Error;
985: ELSE
986: l_msg_token := p_exposure_type_code;
987:
988: DELETE FROM gr_item_exposure
989: WHERE exposure_type_code = p_exposure_type_code;
990: END IF;
991: ELSIF p_delete_option = 'B' THEN
992: IF p_item_code IS NULL OR

Line 1003: DELETE FROM gr_item_exposure

999: l_msg_token := p_item_code ||' ' || p_label_code || ' ';
1000: l_msg_token := l_msg_token || p_exposure_authority_code || ' ';
1001: l_msg_token := l_msg_token || p_exposure_type_code;
1002:
1003: DELETE FROM gr_item_exposure
1004: WHERE item_code = p_item_code
1005: AND label_code = p_label_code
1006: AND exposure_authority_code = p_exposure_authority_code
1007: AND exposure_type_code = p_exposure_type_code;

Line 1321: FROM gr_item_exposure ie

1317:
1318: CURSOR c_get_item_exposure_rowid
1319: IS
1320: SELECT ie.rowid
1321: FROM gr_item_exposure ie
1322: WHERE ie.item_code = p_item_code
1323: AND ie.label_code = p_label_code
1324: AND ie.exposure_authority_code = p_exposure_authority_code
1325: AND ie.exposure_type_code = p_exposure_type_code;

Line 1360: END GR_ITEM_EXPOSURE_PKG;

1356: END IF;
1357:
1358: END Check_Primary_Key;
1359:
1360: END GR_ITEM_EXPOSURE_PKG;