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_ORDERS dependencies on GR_SELECTION

Line 312: FROM gr_selection sd

308: /*
309: ** Clear any existing rows from the detail table
310: */
311: DELETE
312: FROM gr_selection sd
313: WHERE sd.batch_no = p_batch_number;
314: /*
315: ** Determine whether to process orders or shipments
316: */

Line 610: UPDATE gr_selection_header

606: END IF; /* order_from is NULL */
607: /*
608: ** Update the header status to Selected
609: */
610: UPDATE gr_selection_header
611: SET status = 2
612: WHERE batch_no = p_batch_number;
613:
614: IF FND_API.To_Boolean(p_commit) THEN

Line 730: ** stored in the gr_selection table and generates the cover

726: --utl_file.fclose(pg_fp);
727: END Build_OPM_Selections;
728: /*
729: ** This procedure takes the selections for the batch that are
730: ** stored in the gr_selection table and generates the cover
731: ** letters and documents for the items in the selection.
732: */
733: PROCEDURE Process_Selections
734: (errbuf OUT NOCOPY VARCHAR2,

Line 761: L_HEADER_STATUS GR_SELECTION_HEADER.status%TYPE;

757: L_LANGUAGE_CODE FND_LANGUAGES.language_code%TYPE;
758: L_API_NAME CONSTANT VARCHAR2(30) := 'Process Selections';
759: pg_fp utl_file.file_type;
760: /* Numeric Variables */
761: L_HEADER_STATUS GR_SELECTION_HEADER.status%TYPE;
762: L_ORACLE_ERROR NUMBER;
763: L_USER_ID NUMBER;
764:
765: L_API_VERSION CONSTANT NUMBER := 1.0;

Line 793: FROM gr_selection sd

789: sd.order_line_number,
790: /* 22-Aug-2003 Mercy Thomas BUG 2932007 - Added the column shipment_no to the cursor */
791: sd.shipment_no
792: /* 22-Aug-2003 Mercy Thomas BUG 2932007 - End of the code change */
793: FROM gr_selection sd
794: WHERE sd.batch_no = g_batch_number
795: AND sd.print_flag = 'Y'
796: AND sd.line_status <> 0
797: AND sd.line_status <> 8;

Line 806: FROM gr_selection sd

802: */
803: CURSOR c_get_line_message
804: IS
805: SELECT SUBSTR(message, 1, 100) message, order_no, order_line_number
806: FROM gr_selection sd
807: WHERE sd.batch_no = g_batch_number;
808: LocalLineRecord c_get_line_message%ROWTYPE;
809:
810: CURSOR c_get_order_dtl

Line 926: UPDATE gr_selection_header

922: */
923: l_header_status := GlobalBatchHeader.status;
924: /*utl_file.put_line(pg_fp, 'GlobalBatchHeader.status' ||GlobalBatchHeader.status);*/
925:
926: UPDATE gr_selection_header
927: SET status = 3
928: WHERE batch_no = p_batch_number;
929: /*
930: ** Now process the detail lines

Line 973: UPDATE gr_selection

969: SAVEPOINT Process_Document_Selection;
970: /*
971: ** Set the line status to printing in process
972: */
973: UPDATE gr_selection
974: SET line_status = 3
975: WHERE ROWID = LocalDetailRecord.ROWID;
976: /*
977: ** If a change of recipient code, get the new details or

Line 1568: UPDATE gr_selection

1564: END IF;
1565: /*
1566: ** Set the line status to printing completed
1567: */
1568: UPDATE gr_selection
1569: SET line_status = 6,
1570: document_code = NVL(document_code, g_default_document)
1571: WHERE ROWID = LocalDetailRecord.ROWID;
1572: /*

Line 1631: UPDATE gr_selection_header

1627: CLOSE c_get_line_details;
1628: /*
1629: ** Update the header status to Print Completed
1630: */
1631: UPDATE gr_selection_header
1632: SET status = 6
1633: WHERE batch_no = p_batch_number;
1634:
1635: IF FND_API.To_Boolean(p_commit) THEN

Line 1827: FROM gr_selection sd

1823: sd.recipient_code,
1824: sd.date_msds_sent,
1825: sd.user_id,
1826: sd.user_override
1827: FROM gr_selection sd
1828: WHERE sd.batch_no = p_batch_number;
1829: BatchDetails c_get_batch_details%ROWTYPE;
1830: /*
1831: ** Check the recipient exists

Line 1865: FROM gr_selection

1861: IS
1862: SELECT recipient_code,
1863: item_code,
1864: line_status
1865: FROM gr_selection
1866: WHERE batch_no = p_batch_number;
1867: LocalStatRecord c_get_status%ROWTYPE;
1868: /*
1869: ** Bug 2342375 Mercy Thomas 08/15/2002 End the code changes

Line 1954: UPDATE gr_selection_header

1950: */
1951:
1952: CLOSE g_get_batch_status;
1953: l_code_block := 'Update the batch header';
1954: UPDATE gr_selection_header
1955: SET status = 7
1956: WHERE batch_no = p_batch_number;
1957:
1958: FND_FILE.PUT(FND_FILE.LOG, l_code_block);

Line 2193: UPDATE gr_selection sd

2189: END IF; /* BatchDetails.document_code IS NOT NULL */
2190: /*
2191: ** Update the line status
2192: */
2193: UPDATE gr_selection sd
2194: SET sd.line_status = 8
2195: WHERE sd.batch_no = BatchDetails.batch_no
2196: AND sd.order_no = BatchDetails.order_no
2197: AND sd.order_line_number = BatchDetails.order_line_number;

Line 2207: UPDATE gr_selection_header

2203: END LOOP;
2204: /*
2205: ** Update the header status to Updated
2206: */
2207: UPDATE gr_selection_header
2208: SET status = 8
2209: WHERE batch_no = p_batch_number;
2210:
2211: /*

Line 3779: L_SELECTION_MESSAGE GR_SELECTION.message%TYPE;

3775:
3776: /*
3777: **Alpha Variables
3778: */
3779: L_SELECTION_MESSAGE GR_SELECTION.message%TYPE;
3780:
3781: /*
3782: ** Numeric Variables
3783: */

Line 3784: L_LINE_STATUS GR_SELECTION.line_status%TYPE;

3780:
3781: /*
3782: ** Numeric Variables
3783: */
3784: L_LINE_STATUS GR_SELECTION.line_status%TYPE;
3785: L_USER_ID GR_SELECTION.user_id%TYPE;
3786: L_LINES_WRITTEN NUMBER;
3787: /*
3788: ** Cursors

Line 3785: L_USER_ID GR_SELECTION.user_id%TYPE;

3781: /*
3782: ** Numeric Variables
3783: */
3784: L_LINE_STATUS GR_SELECTION.line_status%TYPE;
3785: L_USER_ID GR_SELECTION.user_id%TYPE;
3786: L_LINES_WRITTEN NUMBER;
3787: /*
3788: ** Cursors
3789: **

Line 3795: FROM gr_selection sd

3791: */
3792: CURSOR c_count_lines
3793: IS
3794: SELECT COUNT(*)
3795: FROM gr_selection sd
3796: WHERE sd.batch_no = g_batch_number
3797: AND sd.order_no = p_order_id
3798: AND sd.order_line_number = p_order_line_number;
3799:

Line 3846: INSERT INTO gr_selection

3842: ** Get the user id.
3843: */
3844: l_user_id := FND_GLOBAL.USER_ID;
3845:
3846: INSERT INTO gr_selection
3847: (batch_no,
3848: order_no,
3849: order_line_number,
3850: line_status,

Line 3929: FROM gr_selection_header sh,

3925: */
3926: CURSOR c_check_selections
3927: IS
3928: SELECT sd.batch_no
3929: FROM gr_selection_header sh,
3930: gr_selection sd
3931: WHERE ( (sd.order_no = g_order_number /* Same order and line number */
3932: AND sd.order_line_number = g_order_line)
3933: OR ( (NOT EXISTS (SELECT 1

Line 3930: gr_selection sd

3926: CURSOR c_check_selections
3927: IS
3928: SELECT sd.batch_no
3929: FROM gr_selection_header sh,
3930: gr_selection sd
3931: WHERE ( (sd.order_no = g_order_number /* Same order and line number */
3932: AND sd.order_line_number = g_order_line)
3933: OR ( (NOT EXISTS (SELECT 1
3934: FROM gr_recipient_info