APPS.GR_PROCESS_ORDERS dependencies on GR_SELECTION_HEADER

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 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 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 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 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 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 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