APPS.GR_DOCUMENT_PRINT_PKG dependencies on GR_DOCUMENT_PRINT

Line 1: PACKAGE BODY GR_DOCUMENT_PRINT_PKG AS

1: PACKAGE BODY GR_DOCUMENT_PRINT_PKG AS
2: /*$Header: GRHIDPB.pls 115.8 2002/10/28 23:04:00 mgrosser ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 151: INSERT INTO gr_document_print

147:
148: FND_FILE.PUT(FND_FILE.LOG,' Record does not exist:' || TO_CHAR(p_document_text_id));
149: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
150:
151: INSERT INTO gr_document_print
152: (document_text_id,
153: document_code,
154: language,
155: item_code,

Line 460: UPDATE gr_document_print

456:
457: IF l_return_status <> 'S' THEN
458: RAISE Foreign_Key_Error;
459: ELSE
460: UPDATE gr_document_print
461: SET document_text_id = p_document_text_id,
462: document_code = p_document_code,
463: language = p_language,
464: item_code = p_item_code,

Line 642: FROM gr_document_print

638:
639: CURSOR c_lock_document_print
640: IS
641: SELECT *
642: FROM gr_document_print
643: WHERE rowid = p_rowid
644: FOR UPDATE NOWAIT;
645: LockDocumentRcd c_lock_document_print%ROWTYPE;
646:

Line 850: DELETE FROM gr_document_print

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

Line 955: DELETE FROM gr_document_print

951: RAISE Null_Delete_Option_Error;
952: ELSE
953: l_msg_token := p_document_code;
954:
955: DELETE FROM gr_document_print
956: WHERE document_code = p_document_code;
957: END IF;
958: ELSIF p_delete_option = 'I' THEN
959: IF p_item_code IS NULL THEN

Line 965: DELETE FROM gr_document_print

961: RAISE Null_Delete_Option_Error;
962: ELSE
963: l_msg_token := p_item_code;
964:
965: DELETE FROM gr_document_print
966: WHERE item_code = p_item_code;
967: END IF;
968: ELSIF p_delete_option = 'C' THEN
969: IF p_disclosure_code_country IS NULL THEN

Line 975: DELETE FROM gr_document_print

971: RAISE Null_Delete_Option_Error;
972: ELSE
973: l_msg_token := p_disclosure_code_country;
974:
975: DELETE FROM gr_document_print
976: WHERE disclosure_code_country = p_disclosure_code_country;
977: END IF;
978: ELSIF p_delete_option = 'R' THEN
979: IF p_disclosure_code_recipient IS NULL THEN

Line 985: DELETE FROM gr_document_print

981: RAISE Null_Delete_Option_Error;
982: ELSE
983: l_msg_token := p_disclosure_code_recipient;
984:
985: DELETE FROM gr_document_print
986: WHERE disclosure_code_recipient = p_disclosure_code_recipient;
987: END IF;
988: ELSIF p_delete_option = 'B' THEN
989: IF p_document_code IS NULL OR

Line 996: DELETE FROM gr_document_print

992: RAISE Null_Delete_Option_Error;
993: ELSE
994: l_msg_token := p_document_code || ' ' || p_item_code;
995:
996: DELETE FROM gr_document_print
997: WHERE document_code = p_document_code
998: AND item_code = p_item_code;
999: END IF;
1000: END IF;

Line 1413: FROM gr_document_print dp

1409:
1410: CURSOR c_get_print_rowid
1411: IS
1412: SELECT dp.rowid
1413: FROM gr_document_print dp
1414: WHERE document_text_id = p_document_text_id;
1415: PrintRecord c_get_print_rowid%ROWTYPE;
1416:
1417: BEGIN

Line 1446: END GR_DOCUMENT_PRINT_PKG;

1442: END IF;
1443:
1444: END Check_Primary_Key;
1445:
1446: END GR_DOCUMENT_PRINT_PKG;