DBA Data[Home] [Help]

APPS.PAY_GB_MULTI_PAYROLL_RUN SQL Statements

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

Line: 10

Procedure to update master and child record in series, ijn response to submit a process
like Pre-payments, BACS, Payslip generation, Retro

*/
PROCEDURE UPDATE_MASTER_CHILD(
  P_CONCURRENT_REQUEST_ID IN NUMBER
 ,P_PAYROLL_GROUP_ID IN NUMBER
 ,P_PROCESS_NAME IN VARCHAR2
 ,P_REQUEST_PARAMETERS IN VARCHAR2
 ,P_REQUEST_SUBMISSION_DATE IN DATE
 ,P_CHILD_REQ PAY_GB_MULTI_PAYROLL_RUN.CHILD_REQ)
IS

BEGIN


 PAY_GB_MULTI_DML_AND_VAL.ADD_MASTER_CON_DETAILS(
	  P_CONCURRENT_REQUEST_ID=>P_CONCURRENT_REQUEST_ID
	 ,P_PAYROLL_GROUP_ID=>P_PAYROLL_GROUP_ID
	 ,P_PROCESS_NAME=>P_PROCESS_NAME
	 ,P_REQUEST_PARAMETERS=>P_REQUEST_PARAMETERS
	 ,P_REQUEST_SUBMISSION_DATE=>SYSDATE
	);
Line: 42

END UPDATE_MASTER_CHILD;
Line: 52

	SELECT PTP.TIME_PERIOD_ID INTO
			V_TIME_PERIOD_ID
			FROM PER_TIME_PERIODS PTP
			WHERE PTP.PERIOD_NAME=P_TIME_PERIOD_NAME
			AND   PTP.PAYROLL_ID=P_PAYROLL_ID;
Line: 155

Call to update the master and child record
*/

  PAY_GB_MULTI_PAYROLL_RUN.UPDATE_MASTER_CHILD(
 		 P_CONCURRENT_REQUEST_ID=>PAR_REQ_ID
	  ,P_PAYROLL_GROUP_ID =>P_PAYROLL_GROUP_ID
	  ,P_PROCESS_NAME =>'Payroll Run UK Multiple'
	  ,P_REQUEST_PARAMETERS =>PAR_REQ_PARAMS
	  ,P_REQUEST_SUBMISSION_DATE =>SYSDATE
    ,P_CHILD_REQ =>T_CHILD_REQ);
Line: 166

hr_utility.trace('after inserting into master and child records:');
Line: 201

SELECT DISTINCT POPMF.ORG_PAYMENT_METHOD_NAME
FROM
PAY_ALL_PAYROLLS_F PAPF,
PAY_ORG_PAYMENT_METHODS_F POPMF
WHERE PAPF.DEFAULT_PAYMENT_METHOD_ID=POPMF.ORG_PAYMENT_METHOD_ID
AND   PAPF.BUSINESS_GROUP_ID=POPMF.BUSINESS_GROUP_ID
AND   PAPF.PAYROLL_ID=P_PAYROLL_ID;
Line: 213

SELECT CONSOLIDATION_SET_ID
FROM PAY_ALL_PAYROLLS_F
WHERE PAYROLL_ID=P_PAYROLL_ID;
Line: 284

  PAY_GB_MULTI_PAYROLL_RUN.UPDATE_MASTER_CHILD(
 		 P_CONCURRENT_REQUEST_ID=>PAR_REQ_ID
	  ,P_PAYROLL_GROUP_ID =>P_PAYROLL_GROUP_ID
	  ,P_PROCESS_NAME =>'Pre-payments'
	  ,P_REQUEST_PARAMETERS =>PAR_REQ_PARAMS
	  ,P_REQUEST_SUBMISSION_DATE =>SYSDATE
    ,P_CHILD_REQ =>T_CHILD_REQ);
Line: 293

hr_utility.trace('Child records also updated successfully');
Line: 333

SELECT CONSOLIDATION_SET_ID
FROM PAY_ALL_PAYROLLS_F
WHERE PAYROLL_ID=P_PAYROLL_ID;
Line: 359

  V_AUDIT_SAMPLE_HID:='TRANSFER_SELECT_COUNT='||lpad(nvl(P_AUDIT_SAM_FREQ,'0'),4,'0');
Line: 410

  PAY_GB_MULTI_PAYROLL_RUN.UPDATE_MASTER_CHILD(
 		 P_CONCURRENT_REQUEST_ID=>PAR_REQ_ID
	  ,P_PAYROLL_GROUP_ID =>P_PAYROLL_GROUP_ID
	  ,P_PROCESS_NAME =>'Magnetic transfer'
	  ,P_REQUEST_PARAMETERS =>PAR_REQ_PARAMS
	  ,P_REQUEST_SUBMISSION_DATE =>SYSDATE
    ,P_CHILD_REQ =>T_CHILD_REQ);
Line: 455

SELECT COUNT(*)
FROM
PAY_PRE_PAYMENTS PPP
,PAY_ASSIGNMENT_ACTIONS PAA
,PER_ALL_ASSIGNMENTS_F PAAF
,PAY_ORG_PAYMENT_METHODS_F POPMF
,PER_TIME_PERIODS PTP
WHERE PPP.ASSIGNMENT_ACTION_ID=PAA.ASSIGNMENT_ACTION_ID
AND   PAA.ASSIGNMENT_ID=PAAF.ASSIGNMENT_ID
AND   PAAF.PAYROLL_ID=PTP.PAYROLL_ID
AND   PAAF.PAYROLL_ID=P_PAYROLL_ID
AND   PTP.START_DATE>=FND_DATE.CANONICAL_TO_DATE(P_START_DATE)
AND   PTP.END_DATE<=FND_DATE.CANONICAL_TO_DATE(P_END_DATE)
AND   POPMF.ORG_PAYMENT_METHOD_NAME='Cheque'
AND   PPP.ORG_PAYMENT_METHOD_ID=POPMF.ORG_PAYMENT_METHOD_ID;
Line: 474

SELECT CONSOLIDATION_SET_ID
FROM PAY_ALL_PAYROLLS_F
WHERE PAYROLL_ID=P_PAYROLL_ID;
Line: 539

  PAY_GB_MULTI_PAYROLL_RUN.UPDATE_MASTER_CHILD(
 		 P_CONCURRENT_REQUEST_ID=>PAR_REQ_ID
	  ,P_PAYROLL_GROUP_ID =>P_PAYROLL_GROUP_ID
	  ,P_PROCESS_NAME =>'Cheque writer'
	  ,P_REQUEST_PARAMETERS =>PAR_REQ_PARAMS
	  ,P_REQUEST_SUBMISSION_DATE =>SYSDATE
    ,P_CHILD_REQ =>T_CHILD_REQ);
Line: 591

SELECT PCS.CONSOLIDATION_SET_ID FROM
PAY_ALL_PAYROLLS_F PAPF,
PAY_CONSOLIDATION_SETS PCS
WHERE PAPF.CONSOLIDATION_SET_ID=PCS.CONSOLIDATION_SET_ID
AND   PAPF.PAYROLL_ID=P_PAYROLL_ID;
Line: 667

  PAY_GB_MULTI_PAYROLL_RUN.UPDATE_MASTER_CHILD(
 		 P_CONCURRENT_REQUEST_ID=>PAR_REQ_ID
	  ,P_PAYROLL_GROUP_ID =>P_PAYROLL_GROUP_ID
	  ,P_PROCESS_NAME =>'Magnetic report'
	  ,P_REQUEST_PARAMETERS =>PAR_REQ_PARAMS
	  ,P_REQUEST_SUBMISSION_DATE =>SYSDATE
    ,P_CHILD_REQ =>T_CHILD_REQ);
Line: 743

  PAY_GB_MULTI_PAYROLL_RUN.UPDATE_MASTER_CHILD(
 		 P_CONCURRENT_REQUEST_ID=>PAR_REQ_ID
	  ,P_PAYROLL_GROUP_ID =>P_PAYROLL_GROUP_ID
	  ,P_PROCESS_NAME =>'Retropay by Element'
	  ,P_REQUEST_PARAMETERS =>PAR_REQ_PARAMS
	  ,P_REQUEST_SUBMISSION_DATE =>SYSDATE
    ,P_CHILD_REQ =>T_CHILD_REQ);
Line: 775

SELECT CONSOLIDATION_SET_ID
FROM PAY_ALL_PAYROLLS_F
WHERE PAYROLL_ID=P_PAYROLL_ID;
Line: 949

SELECT PCMCRD.CHILD_CONCURRENT_REQUEST_ID CON_ID
FROM
PAY_GB_MP_CHILD_REQUEST_DET PCMCRD
WHERE PCMCRD.PARENT_CONCURRENT_REQUEST_ID=P_PARENT_REQ_ID;
Line: 956

   SELECT PPA.PAYROLL_ACTION_ID
    FROM PAY_PAYROLL_ACTIONS PPA WHERE PPA.REQUEST_ID=PROCESS_NAME;
Line: 1011

PAY_GB_MULTI_DML_AND_VAL.UPDATE_MASTER_ROLLBACK_DETAILS
(
 P_MASTER_REQUEST_ID=>P_PARENT_REQ_ID
,P_PAYROLL_GROUP_ID=>P_PAYROLL_GROUP_ID
,P_ROLLBACK_REQUEST_ID=>PAR_REQ_ID
);
Line: 1022

 PAY_GB_MULTI_DML_AND_VAL.UPDATE_CHILD_ROLLBACK_DETAILS
(
 P_MASTER_REQUEST_ID=>P_PARENT_REQ_ID
,P_PAYROLL_GROUP_ID=>P_PAYROLL_GROUP_ID
,P_ROLLBACK_REQUEST_ID=>T_ROLLBACK_REQ(P)
,P_CHILD_REQUEST_ID=>T_CHILD_REQ(P)
);
Line: 1033

       PAY_GB_MULTI_DML_AND_VAL.UPDATE_ALREADY_ROLLEDBACK(P_REQUEST_ID=>T_CHILD_REQ_AL(P));
Line: 1071

SELECT PCMCRD.CHILD_CONCURRENT_REQUEST_ID CON_ID
FROM
PAY_GB_MP_CHILD_REQUEST_DET PCMCRD
WHERE PCMCRD.PARENT_CONCURRENT_REQUEST_ID=P_PARENT_REQ_ID;
Line: 1079

   SELECT PPA.PAYROLL_ACTION_ID
    FROM PAY_PAYROLL_ACTIONS PPA WHERE PPA.REQUEST_ID=PROCESS_NAME;
Line: 1148

hr_utility.trace('bEFORE MASTER UPDATE');
Line: 1150

PAY_GB_MULTI_DML_AND_VAL.UPDATE_MASTER_ROLLBACK_DETAILS
(
 P_MASTER_REQUEST_ID=>P_PROCESS_NAME
,P_PAYROLL_GROUP_ID=>P_PAYROLL_GROUP_ID
,P_ROLLBACK_REQUEST_ID=>PAR_REQ_ID
);
Line: 1161

hr_utility.trace('BEFORE CHILD UPDATE');
Line: 1165

 PAY_GB_MULTI_DML_AND_VAL.UPDATE_CHILD_ROLLBACK_DETAILS
(
 P_MASTER_REQUEST_ID=>P_PROCESS_NAME
,P_PAYROLL_GROUP_ID=>P_PAYROLL_GROUP_ID
,P_ROLLBACK_REQUEST_ID=>T_CHILD_REQ_NO_AL(P)
,P_CHILD_REQUEST_ID=>T_CHILD_REQ(P)
);
Line: 1176

UPDATE FOR ALREADY ROLLEDBACK REQUESTS
*/
FOR P IN 0..V_AL_COUNT
LOOP
       PAY_GB_MULTI_DML_AND_VAL.UPDATE_ALREADY_ROLLEDBACK(P_REQUEST_ID=>T_CHILD_REQ_AL(P));