The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Worksheet_Insert_Row
(p_line_number IN OUT NOCOPY NUMBER,
p_output_type IN VARCHAR2,
p_user_id IN NUMBER,
p_current_date IN DATE,
p_language_code IN VARCHAR2,
p_session_id IN NUMBER,
p_item_code IN VARCHAR2,
p_print_font IN VARCHAR2,
p_print_size IN NUMBER,
p_text_line IN VARCHAR2,
p_line_type IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2)
IS
/* ------------- LOCAL VARIABLES ------------------- */
L_TEXT_LINE GR_WORK_WORKSHEETS.text_line%TYPE;
SELECT om.orgn_name,
oa.addr1,
oa.addr2,
oa.addr3,
oa.addr4,
oa.postal_code,
oa.state_code,
oa.country_code,
oc.daytime_contact_name,
oc.daytime_telephone,
oc.daytime_extension,
oc.daytime_area_code,
oc.evening_contact_name,
oc.evening_telephone,
oc.evening_extension,
oc.evening_area_code,
oc.daytime_fax_no,
oc.daytime_email,
oc.evening_fax_no,
oc.evening_email
FROM gr_organization_contacts oc,
sy_addr_mst oa,
sy_orgn_mst om
WHERE om.orgn_code = l_default_orgn
AND om.addr_id = oa.addr_id
AND oc.orgn_code = om.orgn_code;
SELECT lab.data_position_indicator,
lat.label_description
FROM gr_labels_tl lat,
gr_labels_b lab
WHERE lab.label_code = l_label_code
AND lat.label_code = lab.label_code
AND lat.language = l_language_code;
SELECT geog_desc
FROM sy_geog_mst
WHERE geog_type = 1
AND geog_code = V_country_code;
/* M. Grosser 27-Feb-2003 BUG 2718956 - Put an IF statment around the selection of
organization data and the error message associated with it.
It is only applicable to organization data.
*/
IF l_text_line in ('01100','01101','01102','01103','01104','01105','01106','01107','01008') THEN
OPEN c_get_orgn_info;
Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
INSERT INTO gr_work_worksheets
(session_id,
text_line_number,
item_code,
print_font,
print_size,
text_line,
line_type)
VALUES
(p_session_id,
p_line_number,
p_item_code,
p_print_font,
p_print_size,
l_text_line,
p_line_type);
FND_FILE.PUT(FND_FILE.LOG,' WORKSHEET INSERT: '||sqlerrm);
END Worksheet_Insert_Row;
PROCEDURE Document_Insert_Row
(p_line_number IN OUT NOCOPY NUMBER,
p_output_type IN VARCHAR2,
p_document_text_id IN NUMBER,
p_user_id IN NUMBER,
p_current_date IN DATE,
p_session_id IN NUMBER,
p_item_code IN VARCHAR2,
p_print_font IN VARCHAR2,
p_print_size IN NUMBER,
p_text_line IN VARCHAR2,
p_line_type IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_data OUT NOCOPY VARCHAR2)
IS
/* ------------- LOCAL VARIABLES ------------------- */
/* Alpha Variables */
L_COMMIT VARCHAR2(1) := 'F';
GR_DOCUMENT_DETAILS_PKG.Insert_Row
(l_commit,
l_called_by_form,
p_line_number,
p_document_text_id,
p_print_font,
p_print_size,
p_text_line,
p_line_type,
p_user_id,
p_current_date,
p_user_id,
p_current_date,
p_user_id,
l_rowid,
l_return_status,
l_oracle_error,
l_msg_data);
END Document_Insert_Row;
PROCEDURE Insert_Work_Row
(p_session_id IN NUMBER,
p_document_code IN VARCHAR2,
p_main_heading_code IN VARCHAR2,
p_main_display_order IN NUMBER,
p_sub_heading_code IN VARCHAR2,
p_sub_display_order IN NUMBER,
p_record_type IN VARCHAR2,
p_label_or_phrase_code IN VARCHAR2,
p_concentration_percent IN NUMBER,
p_label_class IN VARCHAR2,
p_phrase_hierarchy IN NUMBER,
p_phrase_type IN VARCHAR2,
p_print_flag IN VARCHAR2,
p_source_itemcode IN VARCHAR2,
p_structure_display_order IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_data OUT NOCOPY VARCHAR2)
IS
/* ------------- LOCAL VARIABLES ------------------- */
/* Alpha Variables */
L_CODE_BLOCK VARCHAR2(2000);
L_UPDATE_OK VARCHAR2(2);
SELECT wbd.print_flag
FROM gr_work_build_docs wbd
WHERE wbd.document_code = p_document_code
AND wbd.main_heading_code = p_main_heading_code
AND wbd.sub_heading_code = p_sub_heading_code
AND wbd.record_type = p_label_or_phrase_code
AND wbd.label_or_phrase_code = p_label_or_phrase_code;
SAVEPOINT Insert_Work_Row;
l_update_ok := 'YS';
l_update_ok := 'YS';
l_update_ok := 'NO';
IF l_update_ok = 'YS' THEN
INSERT INTO gr_work_build_docs
(session_id,
sequence_number,
document_code,
main_heading_code,
main_display_order,
sub_heading_code,
sub_display_order,
record_type,
label_or_phrase_code,
concentration_percent,
label_class,
phrase_hierarchy,
phrase_type,
print_flag,
source_itemcode,
structure_display_order)
VALUES
(p_session_id,
gr_work_build_docs_s.nextval,
p_document_code,
p_main_heading_code,
p_main_display_order,
p_sub_heading_code,
p_sub_display_order,
p_record_type,
p_label_or_phrase_code,
p_concentration_percent,
p_label_class,
p_phrase_hierarchy,
p_phrase_type,
p_print_flag,
p_source_itemcode,
p_structure_display_order);
ROLLBACK TO SAVEPOINT Insert_Work_Row;
END Insert_Work_Row;
PROCEDURE Insert_Data_Record
(p_line_number IN OUT NOCOPY NUMBER,
p_line_type IN VARCHAR2,
p_output_type IN VARCHAR2,
p_user_id IN NUMBER,
p_current_date IN DATE,
p_language_code IN VARCHAR2,
p_document_text_id IN NUMBER,
p_session_id IN NUMBER,
p_document_item IN VARCHAR2,
p_print_font IN VARCHAR2,
p_print_size IN NUMBER,
p_text_line_1 IN VARCHAR2,
p_text_line_2 IN VARCHAR2,
p_source_action IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2)
IS
/* ------------- LOCAL VARIABLES ------------------- */
L_RETURN_STATUS VARCHAR2(1);
WORKSHEET_INSERT_ERROR EXCEPTION;
DOCUMENT_INSERT_ERROR EXCEPTION;
Worksheet_Insert_Row
(p_line_number,
p_output_type,
p_user_id,
p_current_date,
p_language_code,
p_session_id,
p_document_item,
p_print_font,
p_print_size,
p_text_line_1,
l_line_type,
l_return_status);
RAISE Worksheet_Insert_Error;
Worksheet_Insert_Row
(p_line_number,
p_output_type,
p_user_id,
p_current_date,
p_language_code,
p_session_id,
p_document_item,
p_print_font,
p_print_size,
p_text_line_2,
l_line_type,
l_return_status);
RAISE Worksheet_Insert_Error;
Document_Insert_Row
(p_line_number,
p_output_type,
p_document_text_id,
p_user_id,
p_current_date,
p_session_id,
p_document_item,
p_print_font,
p_print_size,
p_text_line_1,
l_line_type,
l_return_status,
l_msg_data);
RAISE Worksheet_Insert_Error;
Document_Insert_Row
(p_line_number,
p_output_type,
p_document_text_id,
p_user_id,
p_current_date,
p_session_id,
p_document_item,
p_print_font,
p_print_size,
p_text_line_2,
l_line_type,
l_return_status,
l_msg_data);
RAISE Worksheet_Insert_Error;
WHEN Document_Insert_Error THEN
x_return_status := FND_API.G_RET_STS_ERROR;
WHEN Worksheet_Insert_Error THEN
x_return_status := FND_API.G_RET_STS_ERROR;
END Insert_Data_Record;
PROCEDURE Insert_Gr_Work_Worksheets
(p_output_type IN VARCHAR2,
p_line_number IN OUT NOCOPY NUMBER,
p_session_id IN NUMBER,
p_item_code IN VARCHAR2,
p_print_font IN VARCHAR2,
p_print_size IN NUMBER,
p_text_line IN VARCHAR2,
p_line_type IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2)
IS
BEGIN
x_return_status := 'S';
INSERT INTO gr_work_worksheets
(session_id,
text_line_number,
item_code,
print_font,
print_size,
text_line,
line_type)
VALUES
(p_session_id,
p_line_number,
p_item_code,
p_print_font,
p_print_size,
p_text_line,
p_line_type);
FND_FILE.PUT(FND_FILE.LOG,' PROCEDURE WORKSHEET INSERT: '||sqlerrm);
END Insert_Gr_Work_Worksheets;
PROCEDURE Insert_XML_Data
(p_line_number IN OUT NOCOPY NUMBER,
p_output_type IN VARCHAR2,
p_user_id IN NUMBER,
p_current_date IN DATE,
p_language_code IN VARCHAR2,
p_document_text_id IN NUMBER,
p_session_id IN NUMBER,
p_document_item IN VARCHAR2,
p_print_font IN VARCHAR2,
p_print_size IN NUMBER,
p_value IN VARCHAR2,
p_line_type IN VARCHAR2,
p_source IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2)
IS
/* ------------- LOCAL VARIABLES ------------------- */
L_RETURN_STATUS VARCHAR2(4);
WORKSHEET_INSERT_ERROR EXCEPTION;
Insert_Data_Record
(p_line_number,
p_line_type,
p_output_type,
p_user_id,
p_current_date,
p_language_code,
p_document_text_id,
p_session_id,
p_document_item,
p_print_font,
p_print_size,
p_value,
NULL,
p_source,
l_return_status);
RAISE Worksheet_Insert_Error;
WHEN Worksheet_Insert_Error THEN
x_return_status := FND_API.G_RET_STS_ERROR;
END Insert_XML_Data;
END GR_PROCESS_DOCUMENTS_INSERTS;