APPS.GMO_LABEL_MGMT_GRP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 50

SELECT GMO_LABEL_HISTORY_S.nextval from dual;

Line: 53

SELECT GMO_LABEL_HISTORY_DTL_S.nextval from dual;

Line: 62

L_LAST_UPDATE_DATE             DATE;

Line: 63

L_LAST_UPDATED_BY              NUMBER;

Line: 64

L_LAST_UPDATE_LOGIN            NUMBER;

Line: 80

   /* Insert master row into GMO_LABEL_HISTORY */
      OPEN  C_LABEL_HISTORY_S;

Line: 89

					X_LAST_UPDATE_DATE  =>L_LAST_UPDATE_DATE,
					X_LAST_UPDATED_BY    =>L_LAST_UPDATED_BY,
					X_LAST_UPDATE_LOGIN  =>L_LAST_UPDATE_LOGIN);

Line: 93

      INSERT INTO GMO_LABEL_HISTORY
                  ( LABEL_ID,
 		    ENTITY_NAME,
 		    ENTITY_KEY,
 		    WMS_BUSINESSFLOW_CODE,
 		    WMS_BUSINESSFLOW_TRANS_ID,
                    TRANSACTION_TYPE,
 		    REQUESTER,
 		    REQUESTED_DATE,
 		    ERECORD_ID,
                    STATUS,
 		    CREATED_BY,
 		    CREATION_DATE,
 		    LAST_UPDATED_BY,
 		    LAST_UPDATE_DATE,
 	            LAST_UPDATE_LOGIN)
              VALUES
                    ( L_LABEL_ID,
                      P_ENTITY_NAME,
                      P_ENTITY_KEY,
                      P_WMS_BUSINESS_FLOW_CODE,
                      P_TRANSACTION_ID,
                      P_TRANSACTION_TYPE,
                      P_REQUESTER,
                      SYSDATE,
                      NULL,
                      'NEW',
                      L_CREATED_BY,
 		          L_CREATION_DATE,
 		          L_LAST_UPDATED_BY,
 		          L_LAST_UPDATE_DATE,
 	                L_LAST_UPDATE_LOGIN
                     );

Line: 138

               /* Insert DTL row into GMO_LABEL_HISTORY_TL */
		      OPEN  C_LABEL_HISTORY_DTL_S;

Line: 143

                      INSERT INTO GMO_LABEL_HISTORY_DTL
                  	( 	LABEL_DTL_ID,
                                LABEL_ID,
 		    		LABEL_TYPE,
 		    		WMS_LABEL_ID,
 		    		WMS_PRINT_STATUS,
 		    		CREATED_BY,
 		    		CREATION_DATE,
 		    		LAST_UPDATED_BY,
 		    		LAST_UPDATE_DATE,
 	            		LAST_UPDATE_LOGIN)
              VALUES
                    ( L_LABELDTL_ID,
                      L_LABEL_ID,
                      L_LABELTYPE,
                      NULL,
                      NULL,
                      L_CREATED_BY,
 		      L_CREATION_DATE,
 		      L_LAST_UPDATED_BY,
 		      L_LAST_UPDATE_DATE,
 	              L_LAST_UPDATE_LOGIN
                     );

Line: 170

       /* Insert the Context for display */
           for L_INDEX in 1 .. P_CONTEXT.count
              loop

                      INSERT INTO GMO_LABEL_CONTEXT_T
                  	( 	LABEL_ID,
                                CONTEXT_MESSAGE_TOKEN,
                                CONTEXT_VALUE,
                                APPLICATION_SHORT_NAME,
                                DISPLAY_SEQUENCE,
 		    		CREATED_BY,
 		    		CREATION_DATE,
 		    		LAST_UPDATED_BY,
 		    		LAST_UPDATE_DATE,
 	            		LAST_UPDATE_LOGIN)
              VALUES
                    ( L_LABEL_ID,
                      P_CONTEXT(L_INDEX).name,
                      P_CONTEXT(L_INDEX).value,
                      P_APPLICATION_SHORT_NAME,
                      P_CONTEXT(L_INDEX).display_sequence,
                      L_CREATED_BY,
 		          L_CREATION_DATE,
 		          L_LAST_UPDATED_BY,
 		          L_LAST_UPDATE_DATE,
 	                L_LAST_UPDATE_LOGIN
                     );

Line: 263

L_LAST_UPDATE_DATE             DATE;

Line: 264

L_LAST_UPDATED_BY              NUMBER;

Line: 265

L_LAST_UPDATE_LOGIN            NUMBER;

Line: 272

SELECT WMS_BUSINESSFLOW_CODE,
       WMS_BUSINESSFLOW_TRANS_ID,
       TRANSACTION_TYPE
   from GMO_LABEL_HISTORY
 where LABEL_ID=p_LABEL_ID;

Line: 280

select LABEL_TYPE from GMO_LABEL_HISTORY_DTL
       where label_id=P_LABEL_ID;

Line: 294

					X_LAST_UPDATE_DATE  =>L_LAST_UPDATE_DATE,
					X_LAST_UPDATED_BY    =>L_LAST_UPDATED_BY,
					X_LAST_UPDATE_LOGIN  =>L_LAST_UPDATE_LOGIN);

Line: 331

                     Update GMO_LABEL_HISTORY_DTL
                        set WMS_PRINT_STATUS=decode(X_RETURN_STATUS,'S','SUCCESS','FAILURE'),
                            WMS_LABEL_ID=L_WMS_LABEL_ID
                        where
                            label_id=P_LABEL_ID and
                            Label_type=L_LABEL_TYPE;

Line: 341

          UPDATE GMO_LABEL_HISTORY set
                           ERECORD_ID=P_ERECORD_ID,
                           STATUS='COMPLETE',
                           LAST_UPDATE_DATE=L_LAST_UPDATE_DATE,
                           LAST_UPDATED_BY = L_LAST_UPDATED_BY,
                           LAST_UPDATE_LOGIN=L_LAST_UPDATE_LOGIN
                     where
                          label_id=P_LABEL_ID;

Line: 359

          UPDATE GMO_LABEL_HISTORY set
                           ERECORD_ID=P_ERECORD_ID,
                           STATUS=L_LABEL_STATUS,
                           LAST_UPDATE_DATE=L_LAST_UPDATE_DATE,
                           LAST_UPDATED_BY = L_LAST_UPDATED_BY,
                           LAST_UPDATE_LOGIN=L_LAST_UPDATE_LOGIN
                     where
                          label_id=P_LABEL_ID;

Line: 368

                    Update GMO_LABEL_HISTORY_DTL
                        set WMS_PRINT_STATUS=L_LABEL_STATUS,
                            WMS_LABEL_ID=NULL
                        where
                            label_id=P_LABEL_ID;

Line: 427

L_LAST_UPDATE_DATE             DATE;

Line: 428

L_LAST_UPDATED_BY              NUMBER;

Line: 429

L_LAST_UPDATE_LOGIN            NUMBER;

Line: 444

					X_LAST_UPDATE_DATE  =>L_LAST_UPDATE_DATE,
					X_LAST_UPDATED_BY    =>L_LAST_UPDATED_BY,
					X_LAST_UPDATE_LOGIN  =>L_LAST_UPDATE_LOGIN);

Line: 448

     UPDATE GMO_LABEL_HISTORY set
                           STATUS='CANCEL',
                           LAST_UPDATE_DATE=L_LAST_UPDATE_DATE,
                           LAST_UPDATED_BY = L_LAST_UPDATED_BY,
                           LAST_UPDATE_LOGIN=L_LAST_UPDATE_LOGIN
                     where
                          label_id=P_LABEL_ID;

Line: 456

                    Update GMO_LABEL_HISTORY_DTL
                        set WMS_PRINT_STATUS='CANCEL',
                            WMS_LABEL_ID=NULL
                        where
                            label_id=P_LABEL_ID;

Line: 547

         Select Count(*) into x_print_count
         --Bug 4912228: Start
	 From GMO_LABEL_HISTORY A, GMO_LABEL_HISTORY_DTL B
	 --Bug 4912228: End
         Where A.LABEL_ID=B.LABEL_ID
	 --Bug 5146629: start
         and B.WMS_PRINT_STATUS = 'SUCCESS'
	 and B.WMS_LABEL_ID is not null
         and A.WMS_BUSINESSFLOW_CODE=P_WMS_BUSINESS_FLOW_CODE
	 and (A.TRANSACTION_TYPE=P_TRANSACTION_TYPE or A.TRANSACTION_TYPE is null)
	 --Bug 5146629: end
         and A.WMS_BUSINESSFLOW_TRANS_ID=P_TRANSACTION_ID
         and B.LABEL_TYPE=P_LABEL_TYPE;