APPS.AS_ATA_TOTAL_PUB SQL Statements

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

Line: 84

      DELETE_CHANGED_ENTITY(p_entity        => 'ACCOUNT',
	                    x_errbuf        => l_errbuf,
		            x_retcode       => l_retcode,
	                    x_return_status => l_return_status);

Line: 105

       INSERT /*+ append parallel(AS_TERR_RESOURCES_TMP) */
          INTO AS_TERR_RESOURCES_TMP
        (RESOURCE_ID,
         RESOURCE_TYPE,
         PARTY_ID,
         TERR_ID)
        ( SELECT DISTINCT USERS.EMPLOYEE_ID,
                          VAL.PROFILE_OPTION_VALUE,-1,-1
          FROM  FND_PROFILE_OPTION_VALUES VAL,
                FND_PROFILE_OPTIONS OPTIONS,
                FND_USER USERS
          WHERE VAL.LEVEL_ID = 10004
          AND USERS.EMPLOYEE_ID is not null
          AND VAL.PROFILE_OPTION_VALUE is not null
          AND USERS.USER_ID = VAL.LEVEL_VALUE
          AND VAL.PROFILE_OPTION_VALUE is not null
          AND OPTIONS.PROFILE_OPTION_ID = VAL.PROFILE_OPTION_ID
          AND OPTIONS.APPLICATION_ID = VAL.APPLICATION_ID
          AND OPTIONS.PROFILE_OPTION_NAME = 'AS_DEF_CUST_ST_ROLE'
         );

Line: 168

      DELETE_CHANGED_ENTITY(p_entity        => 'LEAD',
       	                    x_errbuf        => l_errbuf,
		            x_retcode       => l_retcode,
	                    x_return_status => l_return_status);

Line: 232

      DELETE_CHANGED_ENTITY(p_entity        => 'OPPTY',
      	                    x_errbuf        => l_errbuf,
		            x_retcode       => l_retcode,
	                    x_return_status => l_return_status);

Line: 297

	DELETE_CHANGED_ENTITY(p_entity        => 'QUOTE',
	                      x_errbuf        => l_errbuf,
		              x_retcode       => l_retcode,
	                      x_return_status => l_return_status);

Line: 364

	DELETE_CHANGED_ENTITY(p_entity        => 'PROPOSAL',
       			      x_errbuf        => l_errbuf,
		              x_retcode       => l_retcode,
	                      x_return_status => l_return_status);

Line: 509

PROCEDURE DELETE_CHANGED_ENTITY(p_entity IN VARCHAR2,
			        x_errbuf  OUT NOCOPY VARCHAR2,
				x_retcode OUT NOCOPY VARCHAR2,
				x_return_status OUT NOCOPY VARCHAR2)IS

	TYPE entity_id_list    is TABLE of NUMBER INDEX BY BINARY_INTEGER;

Line: 518

	   SELECT  distinct customer_id
	   FROM AS_CHANGED_ACCOUNTS_ALL
	   WHERE lead_id IS NULL
	   AND sales_lead_id IS NULL;

Line: 524

	   SELECT  distinct sales_lead_id
	   FROM AS_CHANGED_ACCOUNTS_ALL
	   WHERE lead_id IS NULL
	   AND sales_lead_id IS NOT NULL;

Line: 530

	   SELECT  distinct lead_id
	   FROM AS_CHANGED_ACCOUNTS_ALL
	   WHERE lead_id IS NOT NULL
	   AND sales_lead_id IS NULL;

Line: 536

	   SELECT  distinct proposal_id
	   FROM PRP_CHANGED_PROPOSALS;

Line: 540

	   SELECT  distinct quote_number
	   FROM ASO_CHANGED_QUOTES;

Line: 565

			AS_GAR.LOG(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity || ': LOOPCOUNT :- ' ||l_loop_count);

Line: 599

				AS_GAR.LOG(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity || AS_GAR.G_N_ROWS_PROCESSED ||
								 l_entity_id.FIRST || '-' ||
								 l_entity_id.LAST);

Line: 610

									DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC
									WHERE ACC.customer_id=l_entity_id(i)
									AND ACC.lead_id IS NULL
									AND ACC.sales_lead_id IS NULL;

Line: 617

									DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC
									WHERE ACC.sales_lead_id=l_entity_id(i)
									AND ACC.lead_id IS NULL;

Line: 623

									DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC
									WHERE ACC.lead_id=l_entity_id(i)
									AND ACC.change_type = 'OPPORTUNITY';

Line: 630

									DELETE FROM ASO_CHANGED_QUOTES ACC
									WHERE ACC.quote_number=l_entity_id(i);

Line: 635

									DELETE FROM PRP_CHANGED_PROPOSALS ACC
									WHERE ACC.proposal_id=l_entity_id(i);

Line: 647

									AS_GAR.LOG('processing Individual Delete');

Line: 652

													DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC
													WHERE ACC.customer_id=l_entity_id(i)
													AND ACC.lead_id IS NULL
													AND ACC.sales_lead_id IS NULL;

Line: 657

													DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC
													WHERE ACC.sales_lead_id=l_entity_id(i)
													AND ACC.lead_id IS NULL;

Line: 661

													DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC
													WHERE ACC.lead_id=l_entity_id(i)
													AND ACC.change_type = 'OPPORTUNITY';

Line: 667

													DELETE FROM ASO_CHANGED_QUOTES ACC
													WHERE ACC.quote_number=l_entity_id(i);

Line: 670

													DELETE FROM PRP_CHANGED_PROPOSALS ACC
													WHERE ACC.proposal_id=l_entity_id(i);

Line: 676

													AS_GAR.LOG(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity || AS_GAR.G_IND_DEL || AS_GAR.G_GENERAL_EXCEPTION);

Line: 685

								AS_GAR.LOG_EXCEPTION(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));

Line: 697

						AS_GAR.LOG(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity || AS_GAR.G_N_ROWS_PROCESSED || l_first || '-' || l_last);

Line: 706

			AS_GAR.LOG(G_ENTITY ||'DELETE FROM CHANGED ENTITY::' || AS_GAR.G_END);

Line: 710

				AS_GAR.LOG_EXCEPTION(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));

Line: 729

      AS_GAR.LOG_EXCEPTION(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity , SQLERRM, TO_CHAR(SQLCODE));