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.IGS_RE_GEN_003 dependencies on IGS_TR_ITEM

Line 4: --add 3 new fields in the tbh calls to IGS_TR_ITEM and IGS_TR_STEP

1: PACKAGE BODY IGS_RE_GEN_003 AS
2: /* $Header: IGSRE03B.pls 120.0 2005/06/01 21:35:49 appldev noship $ */
3: -- modified procedures resp_ins_tex_tri and resp_ins_tpm_tri to
4: --add 3 new fields in the tbh calls to IGS_TR_ITEM and IGS_TR_STEP
5: -- for tracking dld nov 2001 release bug#1837257
6:
7: PROCEDURE RESP_INS_MIL_HIST(
8: p_person_id IN NUMBER ,

Line 234: --add 3 new fields in the tbh calls to IGS_TR_ITEM and IGS_TR_STEP

230: p_the_sequence_number IN NUMBER ,
231: p_creation_dt IN DATE ,
232: p_thesis_panel_type IN VARCHAR2 ,
233: p_message_name OUT NOCOPY VARCHAR2 )
234: --add 3 new fields in the tbh calls to IGS_TR_ITEM and IGS_TR_STEP
235: --for tracking dld nov 2001 release bug#1837257
236: /*-----------------------------------------------------------------------
237: who when what
238: svanukur 07-sep-2004 modified cursor c_pe for performance bug 3866423

Line 265: v_tracking_id IGS_TR_ITEM.tracking_id%TYPE;

261: v_recipient_id IGS_TR_STEP.recipient_id%TYPE;
262: v_tts_recipient_id IGS_TR_TYPE_STEP.recipient_id%TYPE;
263: v_principal_id IGS_PE_PERSON.person_id%TYPE;
264: v_chair_id IGS_PE_PERSON.person_id%TYPE;
265: v_tracking_id IGS_TR_ITEM.tracking_id%TYPE;
266: v_target_days NUMBER;
267: v_tracking_type IGS_TR_TYPE.tracking_type%TYPE;
268: v_tracking_status IGS_TR_STATUS.tracking_status%TYPE;
269: v_person_id IGS_RE_SPRVSR.person_id%TYPE;

Line 270: v_start_dt IGS_TR_ITEM.start_dt%TYPE;

266: v_target_days NUMBER;
267: v_tracking_type IGS_TR_TYPE.tracking_type%TYPE;
268: v_tracking_status IGS_TR_STATUS.tracking_status%TYPE;
269: v_person_id IGS_RE_SPRVSR.person_id%TYPE;
270: v_start_dt IGS_TR_ITEM.start_dt%TYPE;
271: v_business_days_ind IGS_TR_ITEM.business_days_ind%TYPE;
272: v_action_dt IGS_TR_STEP_V.action_dt%TYPE;
273: v_current_person_id IGS_PE_PERSON.person_id%TYPE;
274:

Line 271: v_business_days_ind IGS_TR_ITEM.business_days_ind%TYPE;

267: v_tracking_type IGS_TR_TYPE.tracking_type%TYPE;
268: v_tracking_status IGS_TR_STATUS.tracking_status%TYPE;
269: v_person_id IGS_RE_SPRVSR.person_id%TYPE;
270: v_start_dt IGS_TR_ITEM.start_dt%TYPE;
271: v_business_days_ind IGS_TR_ITEM.business_days_ind%TYPE;
272: v_action_dt IGS_TR_STEP_V.action_dt%TYPE;
273: v_current_person_id IGS_PE_PERSON.person_id%TYPE;
274:
275: CURSOR c_pe IS

Line 300: cp_tracking_id IGS_TR_ITEM.tracking_id%TYPE) IS

296: WHERE ts.s_tracking_status = cst_active AND
297: ts.closed_ind = 'N'
298: ORDER BY ts.tracking_status ASC;
299: CURSOR c_tri (
300: cp_tracking_id IGS_TR_ITEM.tracking_id%TYPE) IS
301: SELECT tri.start_dt,
302: tri.business_days_ind
303: FROM IGS_TR_ITEM tri
304: WHERE tri.tracking_id = cp_tracking_id;

Line 303: FROM IGS_TR_ITEM tri

299: CURSOR c_tri (
300: cp_tracking_id IGS_TR_ITEM.tracking_id%TYPE) IS
301: SELECT tri.start_dt,
302: tri.business_days_ind
303: FROM IGS_TR_ITEM tri
304: WHERE tri.tracking_id = cp_tracking_id;
305: CURSOR c_tsdv (
306: cp_tracking_id IGS_TR_ITEM.tracking_id%TYPE) IS
307: SELECT MAX(tsdv.action_dt)

Line 306: cp_tracking_id IGS_TR_ITEM.tracking_id%TYPE) IS

302: tri.business_days_ind
303: FROM IGS_TR_ITEM tri
304: WHERE tri.tracking_id = cp_tracking_id;
305: CURSOR c_tsdv (
306: cp_tracking_id IGS_TR_ITEM.tracking_id%TYPE) IS
307: SELECT MAX(tsdv.action_dt)
308: FROM IGS_TR_STEP_V tsdv
309: WHERE tsdv.tracking_id = cp_tracking_id;
310: CURSOR c_trs (

Line 311: cp_tracking_id IGS_TR_ITEM.tracking_id%TYPE) IS

307: SELECT MAX(tsdv.action_dt)
308: FROM IGS_TR_STEP_V tsdv
309: WHERE tsdv.tracking_id = cp_tracking_id;
310: CURSOR c_trs (
311: cp_tracking_id IGS_TR_ITEM.tracking_id%TYPE) IS
312: SELECT trs.tracking_step_id,
313: trs.s_tracking_step_type
314: FROM IGS_TR_STEP trs
315: WHERE trs.tracking_id = cp_tracking_id;

Line 344: CURSOR CUR_IGS_TR_ITEM ( cp_tracking_id IGS_TR_ITEM.tracking_id%TYPE)IS

340: SELECT rowid , IGS_TR_STEP.*
341: FROM IGS_TR_STEP
342: WHERE tracking_id = CP_tracking_id AND
343: tracking_step_id = CP_tracking_step_id;
344: CURSOR CUR_IGS_TR_ITEM ( cp_tracking_id IGS_TR_ITEM.tracking_id%TYPE)IS
345: SELECT rowid , IGS_TR_ITEM.*
346: FROM IGS_TR_ITEM
347: WHERE tracking_id = CP_tracking_id;
348:

Line 345: SELECT rowid , IGS_TR_ITEM.*

341: FROM IGS_TR_STEP
342: WHERE tracking_id = CP_tracking_id AND
343: tracking_step_id = CP_tracking_step_id;
344: CURSOR CUR_IGS_TR_ITEM ( cp_tracking_id IGS_TR_ITEM.tracking_id%TYPE)IS
345: SELECT rowid , IGS_TR_ITEM.*
346: FROM IGS_TR_ITEM
347: WHERE tracking_id = CP_tracking_id;
348:
349: BEGIN

Line 346: FROM IGS_TR_ITEM

342: WHERE tracking_id = CP_tracking_id AND
343: tracking_step_id = CP_tracking_step_id;
344: CURSOR CUR_IGS_TR_ITEM ( cp_tracking_id IGS_TR_ITEM.tracking_id%TYPE)IS
345: SELECT rowid , IGS_TR_ITEM.*
346: FROM IGS_TR_ITEM
347: WHERE tracking_id = CP_tracking_id;
348:
349: BEGIN
350: -- Set the default message number and issue a savepoint

Line 511: FOR IGS_TR_ITEM_REC IN CUR_IGS_TR_ITEM (V_TRACKING_ID)

507: v_start_dt,
508: v_action_dt,
509: v_business_days_ind);
510: BEGIN
511: FOR IGS_TR_ITEM_REC IN CUR_IGS_TR_ITEM (V_TRACKING_ID)
512: LOOP
513: IGS_TR_ITEM_REC.TARGET_DAYS := v_target_days;
514: IGS_TR_ITEM_PKG.UPDATE_ROW(
515: X_ROWID => IGS_TR_ITEM_REC.ROWID,

Line 513: IGS_TR_ITEM_REC.TARGET_DAYS := v_target_days;

509: v_business_days_ind);
510: BEGIN
511: FOR IGS_TR_ITEM_REC IN CUR_IGS_TR_ITEM (V_TRACKING_ID)
512: LOOP
513: IGS_TR_ITEM_REC.TARGET_DAYS := v_target_days;
514: IGS_TR_ITEM_PKG.UPDATE_ROW(
515: X_ROWID => IGS_TR_ITEM_REC.ROWID,
516: X_TRACKING_ID => IGS_TR_ITEM_REC.TRACKING_ID,
517: X_TRACKING_STATUS => IGS_TR_ITEM_REC.TRACKING_STATUS,

Line 514: IGS_TR_ITEM_PKG.UPDATE_ROW(

510: BEGIN
511: FOR IGS_TR_ITEM_REC IN CUR_IGS_TR_ITEM (V_TRACKING_ID)
512: LOOP
513: IGS_TR_ITEM_REC.TARGET_DAYS := v_target_days;
514: IGS_TR_ITEM_PKG.UPDATE_ROW(
515: X_ROWID => IGS_TR_ITEM_REC.ROWID,
516: X_TRACKING_ID => IGS_TR_ITEM_REC.TRACKING_ID,
517: X_TRACKING_STATUS => IGS_TR_ITEM_REC.TRACKING_STATUS,
518: X_TRACKING_TYPE => IGS_TR_ITEM_REC.TRACKING_TYPE,

Line 515: X_ROWID => IGS_TR_ITEM_REC.ROWID,

511: FOR IGS_TR_ITEM_REC IN CUR_IGS_TR_ITEM (V_TRACKING_ID)
512: LOOP
513: IGS_TR_ITEM_REC.TARGET_DAYS := v_target_days;
514: IGS_TR_ITEM_PKG.UPDATE_ROW(
515: X_ROWID => IGS_TR_ITEM_REC.ROWID,
516: X_TRACKING_ID => IGS_TR_ITEM_REC.TRACKING_ID,
517: X_TRACKING_STATUS => IGS_TR_ITEM_REC.TRACKING_STATUS,
518: X_TRACKING_TYPE => IGS_TR_ITEM_REC.TRACKING_TYPE,
519: X_SOURCE_PERSON_ID => IGS_TR_ITEM_REC.SOURCE_PERSON_ID,

Line 516: X_TRACKING_ID => IGS_TR_ITEM_REC.TRACKING_ID,

512: LOOP
513: IGS_TR_ITEM_REC.TARGET_DAYS := v_target_days;
514: IGS_TR_ITEM_PKG.UPDATE_ROW(
515: X_ROWID => IGS_TR_ITEM_REC.ROWID,
516: X_TRACKING_ID => IGS_TR_ITEM_REC.TRACKING_ID,
517: X_TRACKING_STATUS => IGS_TR_ITEM_REC.TRACKING_STATUS,
518: X_TRACKING_TYPE => IGS_TR_ITEM_REC.TRACKING_TYPE,
519: X_SOURCE_PERSON_ID => IGS_TR_ITEM_REC.SOURCE_PERSON_ID,
520: X_START_DT => IGS_TR_ITEM_REC.START_DT,

Line 517: X_TRACKING_STATUS => IGS_TR_ITEM_REC.TRACKING_STATUS,

513: IGS_TR_ITEM_REC.TARGET_DAYS := v_target_days;
514: IGS_TR_ITEM_PKG.UPDATE_ROW(
515: X_ROWID => IGS_TR_ITEM_REC.ROWID,
516: X_TRACKING_ID => IGS_TR_ITEM_REC.TRACKING_ID,
517: X_TRACKING_STATUS => IGS_TR_ITEM_REC.TRACKING_STATUS,
518: X_TRACKING_TYPE => IGS_TR_ITEM_REC.TRACKING_TYPE,
519: X_SOURCE_PERSON_ID => IGS_TR_ITEM_REC.SOURCE_PERSON_ID,
520: X_START_DT => IGS_TR_ITEM_REC.START_DT,
521: X_TARGET_DAYS => IGS_TR_ITEM_REC.TARGET_DAYS,

Line 518: X_TRACKING_TYPE => IGS_TR_ITEM_REC.TRACKING_TYPE,

514: IGS_TR_ITEM_PKG.UPDATE_ROW(
515: X_ROWID => IGS_TR_ITEM_REC.ROWID,
516: X_TRACKING_ID => IGS_TR_ITEM_REC.TRACKING_ID,
517: X_TRACKING_STATUS => IGS_TR_ITEM_REC.TRACKING_STATUS,
518: X_TRACKING_TYPE => IGS_TR_ITEM_REC.TRACKING_TYPE,
519: X_SOURCE_PERSON_ID => IGS_TR_ITEM_REC.SOURCE_PERSON_ID,
520: X_START_DT => IGS_TR_ITEM_REC.START_DT,
521: X_TARGET_DAYS => IGS_TR_ITEM_REC.TARGET_DAYS,
522: X_SEQUENCE_IND => IGS_TR_ITEM_REC.SEQUENCE_IND,

Line 519: X_SOURCE_PERSON_ID => IGS_TR_ITEM_REC.SOURCE_PERSON_ID,

515: X_ROWID => IGS_TR_ITEM_REC.ROWID,
516: X_TRACKING_ID => IGS_TR_ITEM_REC.TRACKING_ID,
517: X_TRACKING_STATUS => IGS_TR_ITEM_REC.TRACKING_STATUS,
518: X_TRACKING_TYPE => IGS_TR_ITEM_REC.TRACKING_TYPE,
519: X_SOURCE_PERSON_ID => IGS_TR_ITEM_REC.SOURCE_PERSON_ID,
520: X_START_DT => IGS_TR_ITEM_REC.START_DT,
521: X_TARGET_DAYS => IGS_TR_ITEM_REC.TARGET_DAYS,
522: X_SEQUENCE_IND => IGS_TR_ITEM_REC.SEQUENCE_IND,
523: X_BUSINESS_DAYS_IND => IGS_TR_ITEM_REC.BUSINESS_DAYS_IND,

Line 520: X_START_DT => IGS_TR_ITEM_REC.START_DT,

516: X_TRACKING_ID => IGS_TR_ITEM_REC.TRACKING_ID,
517: X_TRACKING_STATUS => IGS_TR_ITEM_REC.TRACKING_STATUS,
518: X_TRACKING_TYPE => IGS_TR_ITEM_REC.TRACKING_TYPE,
519: X_SOURCE_PERSON_ID => IGS_TR_ITEM_REC.SOURCE_PERSON_ID,
520: X_START_DT => IGS_TR_ITEM_REC.START_DT,
521: X_TARGET_DAYS => IGS_TR_ITEM_REC.TARGET_DAYS,
522: X_SEQUENCE_IND => IGS_TR_ITEM_REC.SEQUENCE_IND,
523: X_BUSINESS_DAYS_IND => IGS_TR_ITEM_REC.BUSINESS_DAYS_IND,
524: X_ORIGINATOR_PERSON_ID =>IGS_TR_ITEM_REC.ORIGINATOR_PERSON_ID ,

Line 521: X_TARGET_DAYS => IGS_TR_ITEM_REC.TARGET_DAYS,

517: X_TRACKING_STATUS => IGS_TR_ITEM_REC.TRACKING_STATUS,
518: X_TRACKING_TYPE => IGS_TR_ITEM_REC.TRACKING_TYPE,
519: X_SOURCE_PERSON_ID => IGS_TR_ITEM_REC.SOURCE_PERSON_ID,
520: X_START_DT => IGS_TR_ITEM_REC.START_DT,
521: X_TARGET_DAYS => IGS_TR_ITEM_REC.TARGET_DAYS,
522: X_SEQUENCE_IND => IGS_TR_ITEM_REC.SEQUENCE_IND,
523: X_BUSINESS_DAYS_IND => IGS_TR_ITEM_REC.BUSINESS_DAYS_IND,
524: X_ORIGINATOR_PERSON_ID =>IGS_TR_ITEM_REC.ORIGINATOR_PERSON_ID ,
525: X_S_CREATED_IND => IGS_TR_ITEM_REC.S_CREATED_IND,

Line 522: X_SEQUENCE_IND => IGS_TR_ITEM_REC.SEQUENCE_IND,

518: X_TRACKING_TYPE => IGS_TR_ITEM_REC.TRACKING_TYPE,
519: X_SOURCE_PERSON_ID => IGS_TR_ITEM_REC.SOURCE_PERSON_ID,
520: X_START_DT => IGS_TR_ITEM_REC.START_DT,
521: X_TARGET_DAYS => IGS_TR_ITEM_REC.TARGET_DAYS,
522: X_SEQUENCE_IND => IGS_TR_ITEM_REC.SEQUENCE_IND,
523: X_BUSINESS_DAYS_IND => IGS_TR_ITEM_REC.BUSINESS_DAYS_IND,
524: X_ORIGINATOR_PERSON_ID =>IGS_TR_ITEM_REC.ORIGINATOR_PERSON_ID ,
525: X_S_CREATED_IND => IGS_TR_ITEM_REC.S_CREATED_IND,
526: --add 3 new fields in the tbh call

Line 523: X_BUSINESS_DAYS_IND => IGS_TR_ITEM_REC.BUSINESS_DAYS_IND,

519: X_SOURCE_PERSON_ID => IGS_TR_ITEM_REC.SOURCE_PERSON_ID,
520: X_START_DT => IGS_TR_ITEM_REC.START_DT,
521: X_TARGET_DAYS => IGS_TR_ITEM_REC.TARGET_DAYS,
522: X_SEQUENCE_IND => IGS_TR_ITEM_REC.SEQUENCE_IND,
523: X_BUSINESS_DAYS_IND => IGS_TR_ITEM_REC.BUSINESS_DAYS_IND,
524: X_ORIGINATOR_PERSON_ID =>IGS_TR_ITEM_REC.ORIGINATOR_PERSON_ID ,
525: X_S_CREATED_IND => IGS_TR_ITEM_REC.S_CREATED_IND,
526: --add 3 new fields in the tbh call
527: -- for tracking dld nov 2001 release bug#1837257

Line 524: X_ORIGINATOR_PERSON_ID =>IGS_TR_ITEM_REC.ORIGINATOR_PERSON_ID ,

520: X_START_DT => IGS_TR_ITEM_REC.START_DT,
521: X_TARGET_DAYS => IGS_TR_ITEM_REC.TARGET_DAYS,
522: X_SEQUENCE_IND => IGS_TR_ITEM_REC.SEQUENCE_IND,
523: X_BUSINESS_DAYS_IND => IGS_TR_ITEM_REC.BUSINESS_DAYS_IND,
524: X_ORIGINATOR_PERSON_ID =>IGS_TR_ITEM_REC.ORIGINATOR_PERSON_ID ,
525: X_S_CREATED_IND => IGS_TR_ITEM_REC.S_CREATED_IND,
526: --add 3 new fields in the tbh call
527: -- for tracking dld nov 2001 release bug#1837257
528: X_COMPLETION_DUE_DT => IGS_TR_ITEM_REC.COMPLETION_DUE_DT,

Line 525: X_S_CREATED_IND => IGS_TR_ITEM_REC.S_CREATED_IND,

521: X_TARGET_DAYS => IGS_TR_ITEM_REC.TARGET_DAYS,
522: X_SEQUENCE_IND => IGS_TR_ITEM_REC.SEQUENCE_IND,
523: X_BUSINESS_DAYS_IND => IGS_TR_ITEM_REC.BUSINESS_DAYS_IND,
524: X_ORIGINATOR_PERSON_ID =>IGS_TR_ITEM_REC.ORIGINATOR_PERSON_ID ,
525: X_S_CREATED_IND => IGS_TR_ITEM_REC.S_CREATED_IND,
526: --add 3 new fields in the tbh call
527: -- for tracking dld nov 2001 release bug#1837257
528: X_COMPLETION_DUE_DT => IGS_TR_ITEM_REC.COMPLETION_DUE_DT,
529: X_OVERRIDE_OFFSET_CLC_IND => IGS_TR_ITEM_REC.OVERRIDE_OFFSET_CLC_IND ,

Line 528: X_COMPLETION_DUE_DT => IGS_TR_ITEM_REC.COMPLETION_DUE_DT,

524: X_ORIGINATOR_PERSON_ID =>IGS_TR_ITEM_REC.ORIGINATOR_PERSON_ID ,
525: X_S_CREATED_IND => IGS_TR_ITEM_REC.S_CREATED_IND,
526: --add 3 new fields in the tbh call
527: -- for tracking dld nov 2001 release bug#1837257
528: X_COMPLETION_DUE_DT => IGS_TR_ITEM_REC.COMPLETION_DUE_DT,
529: X_OVERRIDE_OFFSET_CLC_IND => IGS_TR_ITEM_REC.OVERRIDE_OFFSET_CLC_IND ,
530: X_PUBLISH_IND => IGS_TR_ITEM_REC.PUBLISH_IND,
531: X_MODE => 'R');
532: END LOOP;

Line 529: X_OVERRIDE_OFFSET_CLC_IND => IGS_TR_ITEM_REC.OVERRIDE_OFFSET_CLC_IND ,

525: X_S_CREATED_IND => IGS_TR_ITEM_REC.S_CREATED_IND,
526: --add 3 new fields in the tbh call
527: -- for tracking dld nov 2001 release bug#1837257
528: X_COMPLETION_DUE_DT => IGS_TR_ITEM_REC.COMPLETION_DUE_DT,
529: X_OVERRIDE_OFFSET_CLC_IND => IGS_TR_ITEM_REC.OVERRIDE_OFFSET_CLC_IND ,
530: X_PUBLISH_IND => IGS_TR_ITEM_REC.PUBLISH_IND,
531: X_MODE => 'R');
532: END LOOP;
533: END;

Line 530: X_PUBLISH_IND => IGS_TR_ITEM_REC.PUBLISH_IND,

526: --add 3 new fields in the tbh call
527: -- for tracking dld nov 2001 release bug#1837257
528: X_COMPLETION_DUE_DT => IGS_TR_ITEM_REC.COMPLETION_DUE_DT,
529: X_OVERRIDE_OFFSET_CLC_IND => IGS_TR_ITEM_REC.OVERRIDE_OFFSET_CLC_IND ,
530: X_PUBLISH_IND => IGS_TR_ITEM_REC.PUBLISH_IND,
531: X_MODE => 'R');
532: END LOOP;
533: END;
534: RETURN v_tracking_id;

Line 866: --add 3 new fields in the tbh calls to IGS_TR_ITEM and IGS_TR_STEP

862: p_ca_sequence_number IN NUMBER ,
863: p_person_id IN NUMBER ,
864: p_panel_member_type IN VARCHAR2 ,
865: p_message_name OUT NOCOPY VARCHAR2 )
866: --add 3 new fields in the tbh calls to IGS_TR_ITEM and IGS_TR_STEP
867: -- for tracking dld nov 2001 release bug#1837257
868: /*-----------------------------------------------------------------------
869: who when what
870: svanukur 07-sep-2004 modified cursor c_pe for performance bug 3866423

Line 888: v_tracking_id IGS_TR_ITEM.tracking_id%TYPE;

884: v_current_person_id IGS_PE_PERSON.person_id%TYPE;
885: v_originator_id IGS_RE_THS_PNL_MBR.person_id%TYPE;
886: v_recipient_id IGS_TR_STEP.recipient_id%TYPE;
887: v_tts_recipient_id IGS_TR_TYPE_STEP.recipient_id%TYPE;
888: v_tracking_id IGS_TR_ITEM.tracking_id%TYPE;
889: v_target_days NUMBER;
890: v_tracking_type IGS_TR_TYPE.tracking_type%TYPE;
891: v_tracking_status IGS_TR_STATUS.tracking_status%TYPE;
892: v_person_id IGS_RE_SPRVSR.person_id%TYPE;

Line 893: v_start_dt IGS_TR_ITEM.start_dt%TYPE;

889: v_target_days NUMBER;
890: v_tracking_type IGS_TR_TYPE.tracking_type%TYPE;
891: v_tracking_status IGS_TR_STATUS.tracking_status%TYPE;
892: v_person_id IGS_RE_SPRVSR.person_id%TYPE;
893: v_start_dt IGS_TR_ITEM.start_dt%TYPE;
894: v_business_days_ind IGS_TR_ITEM.business_days_ind%TYPE;
895: v_action_dt IGS_TR_STEP_V.action_dt%TYPE;
896: CURSOR c_pe IS
897: SELECT PERSON_PARTY_ID

Line 894: v_business_days_ind IGS_TR_ITEM.business_days_ind%TYPE;

890: v_tracking_type IGS_TR_TYPE.tracking_type%TYPE;
891: v_tracking_status IGS_TR_STATUS.tracking_status%TYPE;
892: v_person_id IGS_RE_SPRVSR.person_id%TYPE;
893: v_start_dt IGS_TR_ITEM.start_dt%TYPE;
894: v_business_days_ind IGS_TR_ITEM.business_days_ind%TYPE;
895: v_action_dt IGS_TR_STEP_V.action_dt%TYPE;
896: CURSOR c_pe IS
897: SELECT PERSON_PARTY_ID
898: FROM fnd_user

Line 921: cp_tracking_id IGS_TR_ITEM.tracking_id%TYPE) IS

917: WHERE ts.s_tracking_status = 'ACTIVE' AND
918: ts.closed_ind = 'N'
919: ORDER BY ts.tracking_status ASC;
920: CURSOR c_tri (
921: cp_tracking_id IGS_TR_ITEM.tracking_id%TYPE) IS
922: SELECT tri.start_dt,
923: tri.business_days_ind
924: FROM IGS_TR_ITEM tri
925: WHERE tri.tracking_id = cp_tracking_id;

Line 924: FROM IGS_TR_ITEM tri

920: CURSOR c_tri (
921: cp_tracking_id IGS_TR_ITEM.tracking_id%TYPE) IS
922: SELECT tri.start_dt,
923: tri.business_days_ind
924: FROM IGS_TR_ITEM tri
925: WHERE tri.tracking_id = cp_tracking_id;
926: CURSOR c_tsdv (
927: cp_tracking_id IGS_TR_ITEM.tracking_id%TYPE) IS
928: SELECT MAX(tsdv.action_dt)

Line 927: cp_tracking_id IGS_TR_ITEM.tracking_id%TYPE) IS

923: tri.business_days_ind
924: FROM IGS_TR_ITEM tri
925: WHERE tri.tracking_id = cp_tracking_id;
926: CURSOR c_tsdv (
927: cp_tracking_id IGS_TR_ITEM.tracking_id%TYPE) IS
928: SELECT MAX(tsdv.action_dt)
929: FROM IGS_TR_STEP_V tsdv
930: WHERE tsdv.tracking_id = cp_tracking_id;
931: CURSOR c_trs (

Line 932: cp_tracking_id IGS_TR_ITEM.tracking_id%TYPE) IS

928: SELECT MAX(tsdv.action_dt)
929: FROM IGS_TR_STEP_V tsdv
930: WHERE tsdv.tracking_id = cp_tracking_id;
931: CURSOR c_trs (
932: cp_tracking_id IGS_TR_ITEM.tracking_id%TYPE) IS
933: SELECT trs.tracking_step_id,
934: trs.s_tracking_step_type
935: FROM IGS_TR_STEP trs
936: WHERE trs.tracking_id = cp_tracking_id;

Line 950: CURSOR CUR_IGS_TR_ITEM ( cp_tracking_id IGS_TR_ITEM.tracking_id%TYPE)IS

946: SELECT rowid , IGS_TR_STEP.*
947: FROM IGS_TR_STEP
948: WHERE tracking_id = CP_tracking_id AND
949: tracking_step_id = CP_tracking_step_id;
950: CURSOR CUR_IGS_TR_ITEM ( cp_tracking_id IGS_TR_ITEM.tracking_id%TYPE)IS
951: SELECT rowid , IGS_TR_ITEM.*
952: FROM IGS_TR_ITEM
953: WHERE tracking_id = CP_tracking_id;
954:

Line 951: SELECT rowid , IGS_TR_ITEM.*

947: FROM IGS_TR_STEP
948: WHERE tracking_id = CP_tracking_id AND
949: tracking_step_id = CP_tracking_step_id;
950: CURSOR CUR_IGS_TR_ITEM ( cp_tracking_id IGS_TR_ITEM.tracking_id%TYPE)IS
951: SELECT rowid , IGS_TR_ITEM.*
952: FROM IGS_TR_ITEM
953: WHERE tracking_id = CP_tracking_id;
954:
955:

Line 952: FROM IGS_TR_ITEM

948: WHERE tracking_id = CP_tracking_id AND
949: tracking_step_id = CP_tracking_step_id;
950: CURSOR CUR_IGS_TR_ITEM ( cp_tracking_id IGS_TR_ITEM.tracking_id%TYPE)IS
951: SELECT rowid , IGS_TR_ITEM.*
952: FROM IGS_TR_ITEM
953: WHERE tracking_id = CP_tracking_id;
954:
955:
956:

Line 1100: FOR IGS_TR_ITEM_REC IN CUR_IGS_TR_ITEM (V_TRACKING_ID)

1096: v_start_dt,
1097: v_action_dt,
1098: v_business_days_ind);
1099: BEGIN
1100: FOR IGS_TR_ITEM_REC IN CUR_IGS_TR_ITEM (V_TRACKING_ID)
1101: LOOP
1102: IGS_TR_ITEM_REC.TARGET_DAYS := v_target_days;
1103: IGS_TR_ITEM_PKG.UPDATE_ROW(
1104: X_ROWID => IGS_TR_ITEM_REC.ROWID,

Line 1102: IGS_TR_ITEM_REC.TARGET_DAYS := v_target_days;

1098: v_business_days_ind);
1099: BEGIN
1100: FOR IGS_TR_ITEM_REC IN CUR_IGS_TR_ITEM (V_TRACKING_ID)
1101: LOOP
1102: IGS_TR_ITEM_REC.TARGET_DAYS := v_target_days;
1103: IGS_TR_ITEM_PKG.UPDATE_ROW(
1104: X_ROWID => IGS_TR_ITEM_REC.ROWID,
1105: X_TRACKING_ID => IGS_TR_ITEM_REC.TRACKING_ID,
1106: X_TRACKING_STATUS => IGS_TR_ITEM_REC.TRACKING_STATUS,

Line 1103: IGS_TR_ITEM_PKG.UPDATE_ROW(

1099: BEGIN
1100: FOR IGS_TR_ITEM_REC IN CUR_IGS_TR_ITEM (V_TRACKING_ID)
1101: LOOP
1102: IGS_TR_ITEM_REC.TARGET_DAYS := v_target_days;
1103: IGS_TR_ITEM_PKG.UPDATE_ROW(
1104: X_ROWID => IGS_TR_ITEM_REC.ROWID,
1105: X_TRACKING_ID => IGS_TR_ITEM_REC.TRACKING_ID,
1106: X_TRACKING_STATUS => IGS_TR_ITEM_REC.TRACKING_STATUS,
1107: X_TRACKING_TYPE => IGS_TR_ITEM_REC.TRACKING_TYPE,

Line 1104: X_ROWID => IGS_TR_ITEM_REC.ROWID,

1100: FOR IGS_TR_ITEM_REC IN CUR_IGS_TR_ITEM (V_TRACKING_ID)
1101: LOOP
1102: IGS_TR_ITEM_REC.TARGET_DAYS := v_target_days;
1103: IGS_TR_ITEM_PKG.UPDATE_ROW(
1104: X_ROWID => IGS_TR_ITEM_REC.ROWID,
1105: X_TRACKING_ID => IGS_TR_ITEM_REC.TRACKING_ID,
1106: X_TRACKING_STATUS => IGS_TR_ITEM_REC.TRACKING_STATUS,
1107: X_TRACKING_TYPE => IGS_TR_ITEM_REC.TRACKING_TYPE,
1108: X_SOURCE_PERSON_ID => IGS_TR_ITEM_REC.SOURCE_PERSON_ID,

Line 1105: X_TRACKING_ID => IGS_TR_ITEM_REC.TRACKING_ID,

1101: LOOP
1102: IGS_TR_ITEM_REC.TARGET_DAYS := v_target_days;
1103: IGS_TR_ITEM_PKG.UPDATE_ROW(
1104: X_ROWID => IGS_TR_ITEM_REC.ROWID,
1105: X_TRACKING_ID => IGS_TR_ITEM_REC.TRACKING_ID,
1106: X_TRACKING_STATUS => IGS_TR_ITEM_REC.TRACKING_STATUS,
1107: X_TRACKING_TYPE => IGS_TR_ITEM_REC.TRACKING_TYPE,
1108: X_SOURCE_PERSON_ID => IGS_TR_ITEM_REC.SOURCE_PERSON_ID,
1109: X_START_DT => IGS_TR_ITEM_REC.START_DT,

Line 1106: X_TRACKING_STATUS => IGS_TR_ITEM_REC.TRACKING_STATUS,

1102: IGS_TR_ITEM_REC.TARGET_DAYS := v_target_days;
1103: IGS_TR_ITEM_PKG.UPDATE_ROW(
1104: X_ROWID => IGS_TR_ITEM_REC.ROWID,
1105: X_TRACKING_ID => IGS_TR_ITEM_REC.TRACKING_ID,
1106: X_TRACKING_STATUS => IGS_TR_ITEM_REC.TRACKING_STATUS,
1107: X_TRACKING_TYPE => IGS_TR_ITEM_REC.TRACKING_TYPE,
1108: X_SOURCE_PERSON_ID => IGS_TR_ITEM_REC.SOURCE_PERSON_ID,
1109: X_START_DT => IGS_TR_ITEM_REC.START_DT,
1110: X_TARGET_DAYS => IGS_TR_ITEM_REC.TARGET_DAYS,

Line 1107: X_TRACKING_TYPE => IGS_TR_ITEM_REC.TRACKING_TYPE,

1103: IGS_TR_ITEM_PKG.UPDATE_ROW(
1104: X_ROWID => IGS_TR_ITEM_REC.ROWID,
1105: X_TRACKING_ID => IGS_TR_ITEM_REC.TRACKING_ID,
1106: X_TRACKING_STATUS => IGS_TR_ITEM_REC.TRACKING_STATUS,
1107: X_TRACKING_TYPE => IGS_TR_ITEM_REC.TRACKING_TYPE,
1108: X_SOURCE_PERSON_ID => IGS_TR_ITEM_REC.SOURCE_PERSON_ID,
1109: X_START_DT => IGS_TR_ITEM_REC.START_DT,
1110: X_TARGET_DAYS => IGS_TR_ITEM_REC.TARGET_DAYS,
1111: X_SEQUENCE_IND => IGS_TR_ITEM_REC.SEQUENCE_IND,

Line 1108: X_SOURCE_PERSON_ID => IGS_TR_ITEM_REC.SOURCE_PERSON_ID,

1104: X_ROWID => IGS_TR_ITEM_REC.ROWID,
1105: X_TRACKING_ID => IGS_TR_ITEM_REC.TRACKING_ID,
1106: X_TRACKING_STATUS => IGS_TR_ITEM_REC.TRACKING_STATUS,
1107: X_TRACKING_TYPE => IGS_TR_ITEM_REC.TRACKING_TYPE,
1108: X_SOURCE_PERSON_ID => IGS_TR_ITEM_REC.SOURCE_PERSON_ID,
1109: X_START_DT => IGS_TR_ITEM_REC.START_DT,
1110: X_TARGET_DAYS => IGS_TR_ITEM_REC.TARGET_DAYS,
1111: X_SEQUENCE_IND => IGS_TR_ITEM_REC.SEQUENCE_IND,
1112: X_BUSINESS_DAYS_IND => IGS_TR_ITEM_REC.BUSINESS_DAYS_IND,

Line 1109: X_START_DT => IGS_TR_ITEM_REC.START_DT,

1105: X_TRACKING_ID => IGS_TR_ITEM_REC.TRACKING_ID,
1106: X_TRACKING_STATUS => IGS_TR_ITEM_REC.TRACKING_STATUS,
1107: X_TRACKING_TYPE => IGS_TR_ITEM_REC.TRACKING_TYPE,
1108: X_SOURCE_PERSON_ID => IGS_TR_ITEM_REC.SOURCE_PERSON_ID,
1109: X_START_DT => IGS_TR_ITEM_REC.START_DT,
1110: X_TARGET_DAYS => IGS_TR_ITEM_REC.TARGET_DAYS,
1111: X_SEQUENCE_IND => IGS_TR_ITEM_REC.SEQUENCE_IND,
1112: X_BUSINESS_DAYS_IND => IGS_TR_ITEM_REC.BUSINESS_DAYS_IND,
1113: X_ORIGINATOR_PERSON_ID =>IGS_TR_ITEM_REC.ORIGINATOR_PERSON_ID ,

Line 1110: X_TARGET_DAYS => IGS_TR_ITEM_REC.TARGET_DAYS,

1106: X_TRACKING_STATUS => IGS_TR_ITEM_REC.TRACKING_STATUS,
1107: X_TRACKING_TYPE => IGS_TR_ITEM_REC.TRACKING_TYPE,
1108: X_SOURCE_PERSON_ID => IGS_TR_ITEM_REC.SOURCE_PERSON_ID,
1109: X_START_DT => IGS_TR_ITEM_REC.START_DT,
1110: X_TARGET_DAYS => IGS_TR_ITEM_REC.TARGET_DAYS,
1111: X_SEQUENCE_IND => IGS_TR_ITEM_REC.SEQUENCE_IND,
1112: X_BUSINESS_DAYS_IND => IGS_TR_ITEM_REC.BUSINESS_DAYS_IND,
1113: X_ORIGINATOR_PERSON_ID =>IGS_TR_ITEM_REC.ORIGINATOR_PERSON_ID ,
1114: X_S_CREATED_IND => IGS_TR_ITEM_REC.S_CREATED_IND,

Line 1111: X_SEQUENCE_IND => IGS_TR_ITEM_REC.SEQUENCE_IND,

1107: X_TRACKING_TYPE => IGS_TR_ITEM_REC.TRACKING_TYPE,
1108: X_SOURCE_PERSON_ID => IGS_TR_ITEM_REC.SOURCE_PERSON_ID,
1109: X_START_DT => IGS_TR_ITEM_REC.START_DT,
1110: X_TARGET_DAYS => IGS_TR_ITEM_REC.TARGET_DAYS,
1111: X_SEQUENCE_IND => IGS_TR_ITEM_REC.SEQUENCE_IND,
1112: X_BUSINESS_DAYS_IND => IGS_TR_ITEM_REC.BUSINESS_DAYS_IND,
1113: X_ORIGINATOR_PERSON_ID =>IGS_TR_ITEM_REC.ORIGINATOR_PERSON_ID ,
1114: X_S_CREATED_IND => IGS_TR_ITEM_REC.S_CREATED_IND,
1115: --add 3 new fields in the tbh call

Line 1112: X_BUSINESS_DAYS_IND => IGS_TR_ITEM_REC.BUSINESS_DAYS_IND,

1108: X_SOURCE_PERSON_ID => IGS_TR_ITEM_REC.SOURCE_PERSON_ID,
1109: X_START_DT => IGS_TR_ITEM_REC.START_DT,
1110: X_TARGET_DAYS => IGS_TR_ITEM_REC.TARGET_DAYS,
1111: X_SEQUENCE_IND => IGS_TR_ITEM_REC.SEQUENCE_IND,
1112: X_BUSINESS_DAYS_IND => IGS_TR_ITEM_REC.BUSINESS_DAYS_IND,
1113: X_ORIGINATOR_PERSON_ID =>IGS_TR_ITEM_REC.ORIGINATOR_PERSON_ID ,
1114: X_S_CREATED_IND => IGS_TR_ITEM_REC.S_CREATED_IND,
1115: --add 3 new fields in the tbh call
1116: -- for tracking dld nov 2001 release bug#1837257

Line 1113: X_ORIGINATOR_PERSON_ID =>IGS_TR_ITEM_REC.ORIGINATOR_PERSON_ID ,

1109: X_START_DT => IGS_TR_ITEM_REC.START_DT,
1110: X_TARGET_DAYS => IGS_TR_ITEM_REC.TARGET_DAYS,
1111: X_SEQUENCE_IND => IGS_TR_ITEM_REC.SEQUENCE_IND,
1112: X_BUSINESS_DAYS_IND => IGS_TR_ITEM_REC.BUSINESS_DAYS_IND,
1113: X_ORIGINATOR_PERSON_ID =>IGS_TR_ITEM_REC.ORIGINATOR_PERSON_ID ,
1114: X_S_CREATED_IND => IGS_TR_ITEM_REC.S_CREATED_IND,
1115: --add 3 new fields in the tbh call
1116: -- for tracking dld nov 2001 release bug#1837257
1117: X_COMPLETION_DUE_DT => IGS_TR_ITEM_REC.COMPLETION_DUE_DT,

Line 1114: X_S_CREATED_IND => IGS_TR_ITEM_REC.S_CREATED_IND,

1110: X_TARGET_DAYS => IGS_TR_ITEM_REC.TARGET_DAYS,
1111: X_SEQUENCE_IND => IGS_TR_ITEM_REC.SEQUENCE_IND,
1112: X_BUSINESS_DAYS_IND => IGS_TR_ITEM_REC.BUSINESS_DAYS_IND,
1113: X_ORIGINATOR_PERSON_ID =>IGS_TR_ITEM_REC.ORIGINATOR_PERSON_ID ,
1114: X_S_CREATED_IND => IGS_TR_ITEM_REC.S_CREATED_IND,
1115: --add 3 new fields in the tbh call
1116: -- for tracking dld nov 2001 release bug#1837257
1117: X_COMPLETION_DUE_DT => IGS_TR_ITEM_REC.COMPLETION_DUE_DT,
1118: X_OVERRIDE_OFFSET_CLC_IND => IGS_TR_ITEM_REC.OVERRIDE_OFFSET_CLC_IND ,

Line 1117: X_COMPLETION_DUE_DT => IGS_TR_ITEM_REC.COMPLETION_DUE_DT,

1113: X_ORIGINATOR_PERSON_ID =>IGS_TR_ITEM_REC.ORIGINATOR_PERSON_ID ,
1114: X_S_CREATED_IND => IGS_TR_ITEM_REC.S_CREATED_IND,
1115: --add 3 new fields in the tbh call
1116: -- for tracking dld nov 2001 release bug#1837257
1117: X_COMPLETION_DUE_DT => IGS_TR_ITEM_REC.COMPLETION_DUE_DT,
1118: X_OVERRIDE_OFFSET_CLC_IND => IGS_TR_ITEM_REC.OVERRIDE_OFFSET_CLC_IND ,
1119: X_PUBLISH_IND => IGS_TR_ITEM_REC.PUBLISH_IND,
1120: X_MODE => 'R');
1121: END LOOP;

Line 1118: X_OVERRIDE_OFFSET_CLC_IND => IGS_TR_ITEM_REC.OVERRIDE_OFFSET_CLC_IND ,

1114: X_S_CREATED_IND => IGS_TR_ITEM_REC.S_CREATED_IND,
1115: --add 3 new fields in the tbh call
1116: -- for tracking dld nov 2001 release bug#1837257
1117: X_COMPLETION_DUE_DT => IGS_TR_ITEM_REC.COMPLETION_DUE_DT,
1118: X_OVERRIDE_OFFSET_CLC_IND => IGS_TR_ITEM_REC.OVERRIDE_OFFSET_CLC_IND ,
1119: X_PUBLISH_IND => IGS_TR_ITEM_REC.PUBLISH_IND,
1120: X_MODE => 'R');
1121: END LOOP;
1122: END;

Line 1119: X_PUBLISH_IND => IGS_TR_ITEM_REC.PUBLISH_IND,

1115: --add 3 new fields in the tbh call
1116: -- for tracking dld nov 2001 release bug#1837257
1117: X_COMPLETION_DUE_DT => IGS_TR_ITEM_REC.COMPLETION_DUE_DT,
1118: X_OVERRIDE_OFFSET_CLC_IND => IGS_TR_ITEM_REC.OVERRIDE_OFFSET_CLC_IND ,
1119: X_PUBLISH_IND => IGS_TR_ITEM_REC.PUBLISH_IND,
1120: X_MODE => 'R');
1121: END LOOP;
1122: END;
1123: RETURN v_tracking_id;