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.GR_PROCESS_DOCUMENTS_INSERTS dependencies on GR_WORK_WORKSHEETS

Line 10: -- and to insert data into gr_work_worksheets.

6: -- Worksheet_Insert_Row
7: --
8: -- DESCRIPTION:
9: -- This PL/SQL procedure is used to identify missing data in the worksheet
10: -- and to insert data into gr_work_worksheets.
11: --
12: -- PARAMETERS:
13: -- p_line_number IN OUT NOCOPY NUMBER - Line number of inserted record
14: -- p_output_type IN VARCHAR2 - 'PDF','XML','HTML', etc

Line 49: L_TEXT_LINE GR_WORK_WORKSHEETS.text_line%TYPE;

45: x_return_status OUT NOCOPY VARCHAR2)
46: IS
47:
48: /* ------------- LOCAL VARIABLES ------------------- */
49: L_TEXT_LINE GR_WORK_WORKSHEETS.text_line%TYPE;
50: L_LABEL_CODE GR_LABELS_B.label_code%TYPE;
51: L_ADDR_LINE SY_ADDR_MST.addr1%TYPE;
52: L_DEFAULT_ORGN SY_ORGN_MST.orgn_code%TYPE;
53: L_TELEPHONE_NUMBER VARCHAR2(78);

Line 168: Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,

164: l_label_len := 31;
165: END IF;
166:
167: /* Created new procedure to avoid redundant code */
168: Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
169: p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
170:
171: IF LocalLabelRecord.data_position_indicator = 'N' THEN
172: l_text_line := LocalOrgnRecord.orgn_name;

Line 176: Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,

172: l_text_line := LocalOrgnRecord.orgn_name;
173: l_label_len := 0;
174:
175: /* Created new procedure to avoid redundant code */
176: Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
177: p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
178: END IF;
179:
180: IF LocalOrgnRecord.addr1 IS NOT NULL THEN

Line 187: Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,

183: l_text_line := LPAD(l_addr_line,l_line_len,' ');
184:
185:
186: /* Created new procedure to avoid redundant code */
187: Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
188: p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
189: END IF;
190:
191: IF LocalOrgnRecord.addr2 IS NOT NULL THEN

Line 198: Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,

194: l_text_line := LPAD(l_addr_line,l_line_len,' ');
195:
196:
197: /* Created new procedure to avoid redundant code */
198: Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
199: p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
200: END IF;
201:
202: IF LocalOrgnRecord.addr3 IS NOT NULL THEN

Line 208: Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,

204: l_line_len := l_label_len + LENGTH(l_addr_line);
205: l_text_line := LPAD(l_addr_line,l_line_len,' ');
206:
207: /* Created new procedure to avoid redundant code */
208: Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
209: p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
210: END IF;
211:
212: IF (LocalOrgnRecord.addr4 IS NOT NULL) OR

Line 233: Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,

229: l_line_len := l_label_len + LENGTH(l_addr_line);
230: l_text_line := LPAD(l_addr_line,l_line_len,' ');
231:
232: /* Created new procedure to avoid redundant code */
233: Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
234: p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
235: END IF;
236:
237: IF LocalOrgnRecord.country_code IS NOT NULL THEN

Line 251: Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,

247: l_line_len := l_label_len + LENGTH(l_addr_line);
248: l_text_line := LPAD(l_addr_line,l_line_len,' ');
249:
250: /* Created new procedure to avoid redundant code */
251: Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
252: p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
253: END IF;
254:
255: END IF;

Line 290: Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,

286: ** Label info and print data on the next line
287: */
288: ELSE
289: /* Created new procedure to avoid redundant code */
290: Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
291: p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
292: l_text_line := LocalOrgnRecord.daytime_contact_name;
293: END IF;
294: END IF;

Line 336: Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,

332: ** Label info and print data on the next line
333: */
334: ELSE
335: /* Created new procedure to avoid redundant code */
336: Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
337: p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
338: l_text_line := l_telephone_number;
339: END IF;
340: END IF;

Line 374: Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,

370: ** Label info and print data on the next line
371: */
372: ELSE
373: /* Created new procedure to avoid redundant code */
374: Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
375: p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
376: l_text_line := LocalOrgnRecord.evening_contact_name;
377: END IF;
378: END IF;

Line 420: Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,

416: ** Label info and print data on the next line
417: */
418: ELSE
419: /* Created new procedure to avoid redundant code */
420: Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
421: p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
422: l_text_line := l_telephone_number;
423: END IF;
424:

Line 456: Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,

452: ** Label info and print data on the next line
453: */
454: ELSE
455: /* Created new procedure to avoid redundant code */
456: Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
457: p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
458:
459: l_text_line := LocalOrgnRecord.daytime_fax_no;
460: END IF;

Line 493: Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,

489: ** Label info and print data on the next line
490: */
491: ELSE
492: /* Created new procedure to avoid redundant code */
493: Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
494: p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
495: l_text_line := LocalOrgnRecord.daytime_email;
496: END IF;
497:

Line 529: Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,

525: ** Label info and print data on the next line
526: */
527: ELSE
528: /* Created new procedure to avoid redundant code */
529: Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
530: p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
531: l_text_line := LocalOrgnRecord.evening_fax_no;
532: END IF;
533:

Line 565: Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,

561: ** Label info and print data on the next line
562: */
563: ELSE
564: /* Created new procedure to avoid redundant code */
565: Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
566: p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
567: l_text_line := LocalOrgnRecord.evening_email;
568: END IF;
569:

Line 591: INSERT INTO gr_work_worksheets

587: ELSE
588: p_line_number := p_line_number + 1;
589: END IF; /* If XML or HTML */
590:
591: INSERT INTO gr_work_worksheets
592: (session_id,
593: text_line_number,
594: item_code,
595: print_font,

Line 1045: -- Insert_Gr_Work_Worksheets

1041:
1042:
1043: /*===========================================================================
1044: -- PROCEDURE:
1045: -- Insert_Gr_Work_Worksheets
1046: --
1047: -- DESCRIPTION:
1048: -- This PL/SQL procedure is used to set the line number and insert data
1049: -- into gr_work_worksheets. The line numbers will be spaced out differently

Line 1049: -- into gr_work_worksheets. The line numbers will be spaced out differently

1045: -- Insert_Gr_Work_Worksheets
1046: --
1047: -- DESCRIPTION:
1048: -- This PL/SQL procedure is used to set the line number and insert data
1049: -- into gr_work_worksheets. The line numbers will be spaced out differently
1050: -- for XML and HTML in order to correctly associate the data.
1051: --
1052: -- PARAMETERS:
1053: -- p_output_type IN VARCHAR2 - 'PDF','XML','HTML', etc

Line 1064: -- Insert_Gr_Work_Worksheets (g_output_type,g_line_number,g_session_id,l_item_code,

1060: -- p_line_type IN VARCHAR2 - Type of value being inserted
1061: -- x_return_status OUT NOCOPY VARCHAR2 - 'S'uccess, 'E'rror, 'U'nexpected Error
1062: --
1063: -- SYNOPSIS:
1064: -- Insert_Gr_Work_Worksheets (g_output_type,g_line_number,g_session_id,l_item_code,
1065: -- l_print_font,l_print_size,l_text_line,l_line_type,l_return_status);
1066: --
1067: -- HISTORY
1068: --=========================================================================== */

Line 1069: PROCEDURE Insert_Gr_Work_Worksheets

1065: -- l_print_font,l_print_size,l_text_line,l_line_type,l_return_status);
1066: --
1067: -- HISTORY
1068: --=========================================================================== */
1069: PROCEDURE Insert_Gr_Work_Worksheets
1070: (p_output_type IN VARCHAR2,
1071: p_line_number IN OUT NOCOPY NUMBER,
1072: p_session_id IN NUMBER,
1073: p_item_code IN VARCHAR2,

Line 1091: INSERT INTO gr_work_worksheets

1087: ELSE /* Printing pdf */
1088: p_line_number := p_line_number + 1;
1089: END IF;
1090:
1091: INSERT INTO gr_work_worksheets
1092: (session_id,
1093: text_line_number,
1094: item_code,
1095: print_font,

Line 1114: END Insert_Gr_Work_Worksheets;

1110: FND_FILE.PUT(FND_FILE.LOG,' PROCEDURE WORKSHEET INSERT: '||sqlerrm);
1111: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1113:
1114: END Insert_Gr_Work_Worksheets;
1115:
1116:
1117:
1118: