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_STEP

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 251: IGS_TR_STEP.s_tracking_step_type%TYPE := 'RES_TEX_PR';

247: DECLARE
248: cst_s_tracking_type CONSTANT
249: IGS_TR_TYPE.s_tracking_type%TYPE := 'RES_TEX';
250: cst_stst_principal CONSTANT
251: IGS_TR_STEP.s_tracking_step_type%TYPE := 'RES_TEX_PR';
252: cst_stst_student CONSTANT
253: IGS_TR_STEP.s_tracking_step_type%TYPE := 'RES_TEX_ST';
254: cst_stst_originator CONSTANT
255: IGS_TR_STEP.s_tracking_step_type%TYPE := 'RES_TEX_OR';

Line 253: IGS_TR_STEP.s_tracking_step_type%TYPE := 'RES_TEX_ST';

249: IGS_TR_TYPE.s_tracking_type%TYPE := 'RES_TEX';
250: cst_stst_principal CONSTANT
251: IGS_TR_STEP.s_tracking_step_type%TYPE := 'RES_TEX_PR';
252: cst_stst_student CONSTANT
253: IGS_TR_STEP.s_tracking_step_type%TYPE := 'RES_TEX_ST';
254: cst_stst_originator CONSTANT
255: IGS_TR_STEP.s_tracking_step_type%TYPE := 'RES_TEX_OR';
256: cst_stst_chair CONSTANT
257: IGS_TR_STEP.s_tracking_step_type%TYPE := 'RES_TEX_CH';

Line 255: IGS_TR_STEP.s_tracking_step_type%TYPE := 'RES_TEX_OR';

251: IGS_TR_STEP.s_tracking_step_type%TYPE := 'RES_TEX_PR';
252: cst_stst_student CONSTANT
253: IGS_TR_STEP.s_tracking_step_type%TYPE := 'RES_TEX_ST';
254: cst_stst_originator CONSTANT
255: IGS_TR_STEP.s_tracking_step_type%TYPE := 'RES_TEX_OR';
256: cst_stst_chair CONSTANT
257: IGS_TR_STEP.s_tracking_step_type%TYPE := 'RES_TEX_CH';
258: cst_active CONSTANT IGS_TR_STATUS.s_tracking_status%TYPE := 'ACTIVE';
259: v_message_name VARCHAR2(30);

Line 257: IGS_TR_STEP.s_tracking_step_type%TYPE := 'RES_TEX_CH';

253: IGS_TR_STEP.s_tracking_step_type%TYPE := 'RES_TEX_ST';
254: cst_stst_originator CONSTANT
255: IGS_TR_STEP.s_tracking_step_type%TYPE := 'RES_TEX_OR';
256: cst_stst_chair CONSTANT
257: IGS_TR_STEP.s_tracking_step_type%TYPE := 'RES_TEX_CH';
258: cst_active CONSTANT IGS_TR_STATUS.s_tracking_status%TYPE := 'ACTIVE';
259: v_message_name VARCHAR2(30);
260: v_originator_id IGS_RE_THS_PNL_MBR.person_id%TYPE;
261: v_recipient_id IGS_TR_STEP.recipient_id%TYPE;

Line 261: v_recipient_id IGS_TR_STEP.recipient_id%TYPE;

257: IGS_TR_STEP.s_tracking_step_type%TYPE := 'RES_TEX_CH';
258: cst_active CONSTANT IGS_TR_STATUS.s_tracking_status%TYPE := 'ACTIVE';
259: v_message_name VARCHAR2(30);
260: v_originator_id IGS_RE_THS_PNL_MBR.person_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;

Line 272: v_action_dt IGS_TR_STEP_V.action_dt%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
276: SELECT PERSON_PARTY_ID

Line 308: FROM IGS_TR_STEP_V tsdv

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 (
311: cp_tracking_id IGS_TR_ITEM.tracking_id%TYPE) IS
312: SELECT trs.tracking_step_id,

Line 314: FROM IGS_TR_STEP trs

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;
316: CURSOR c_tts (
317: cp_tracking_type IGS_TR_TYPE_STEP.tracking_type%TYPE,
318: cp_tracking_type_step_id IGS_TR_TYPE_STEP.tracking_type_step_id%TYPE) IS

Line 338: CURSOR CUR_IGS_TR_STEP ( cp_tracking_id IGS_TR_STEP.tracking_id%TYPE,

334: tpm.creation_dt = cp_creation_dt AND
335: tpm.confirmed_dt IS NOT NULL AND
336: tpmt.panel_member_type = tpm.panel_member_type AND
337: tpmt.panel_chair_ind = 'Y';
338: CURSOR CUR_IGS_TR_STEP ( cp_tracking_id IGS_TR_STEP.tracking_id%TYPE,
339: cp_tracking_STEP_id IGS_TR_STEP.tracking_STEP_id%TYPE) IS
340: SELECT rowid , IGS_TR_STEP.*
341: FROM IGS_TR_STEP
342: WHERE tracking_id = CP_tracking_id AND

Line 339: cp_tracking_STEP_id IGS_TR_STEP.tracking_STEP_id%TYPE) IS

335: tpm.confirmed_dt IS NOT NULL AND
336: tpmt.panel_member_type = tpm.panel_member_type AND
337: tpmt.panel_chair_ind = 'Y';
338: CURSOR CUR_IGS_TR_STEP ( cp_tracking_id IGS_TR_STEP.tracking_id%TYPE,
339: cp_tracking_STEP_id IGS_TR_STEP.tracking_STEP_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;

Line 340: SELECT rowid , IGS_TR_STEP.*

336: tpmt.panel_member_type = tpm.panel_member_type AND
337: tpmt.panel_chair_ind = 'Y';
338: CURSOR CUR_IGS_TR_STEP ( cp_tracking_id IGS_TR_STEP.tracking_id%TYPE,
339: cp_tracking_STEP_id IGS_TR_STEP.tracking_STEP_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

Line 341: FROM IGS_TR_STEP

337: tpmt.panel_chair_ind = 'Y';
338: CURSOR CUR_IGS_TR_STEP ( cp_tracking_id IGS_TR_STEP.tracking_id%TYPE,
339: cp_tracking_STEP_id IGS_TR_STEP.tracking_STEP_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.*

Line 470: FOR IGS_TR_STEP_REC IN CUR_IGS_TR_STEP(V_TRACKING_ID, v_trs_rec.tracking_step_id)

466: ELSE
467: -- Clear the recipient ID (IGS_GE_NOTE: no locking check as the record has been
468: -- created by this routine.
469: BEGIN
470: FOR IGS_TR_STEP_REC IN CUR_IGS_TR_STEP(V_TRACKING_ID, v_trs_rec.tracking_step_id)
471: LOOP
472: IGS_TR_STEP_PKG.UPDATE_ROW(
473: X_ROWID => IGS_TR_STEP_REC.ROWID,
474: X_TRACKING_ID => IGS_TR_STEP_REC.TRACKING_ID,

Line 472: IGS_TR_STEP_PKG.UPDATE_ROW(

468: -- created by this routine.
469: BEGIN
470: FOR IGS_TR_STEP_REC IN CUR_IGS_TR_STEP(V_TRACKING_ID, v_trs_rec.tracking_step_id)
471: LOOP
472: IGS_TR_STEP_PKG.UPDATE_ROW(
473: X_ROWID => IGS_TR_STEP_REC.ROWID,
474: X_TRACKING_ID => IGS_TR_STEP_REC.TRACKING_ID,
475: X_TRACKING_STEP_ID => IGS_TR_STEP_REC.TRACKING_STEP_ID,
476: X_TRACKING_STEP_NUMBER => IGS_TR_STEP_REC.TRACKING_STEP_NUMBER,

Line 473: X_ROWID => IGS_TR_STEP_REC.ROWID,

469: BEGIN
470: FOR IGS_TR_STEP_REC IN CUR_IGS_TR_STEP(V_TRACKING_ID, v_trs_rec.tracking_step_id)
471: LOOP
472: IGS_TR_STEP_PKG.UPDATE_ROW(
473: X_ROWID => IGS_TR_STEP_REC.ROWID,
474: X_TRACKING_ID => IGS_TR_STEP_REC.TRACKING_ID,
475: X_TRACKING_STEP_ID => IGS_TR_STEP_REC.TRACKING_STEP_ID,
476: X_TRACKING_STEP_NUMBER => IGS_TR_STEP_REC.TRACKING_STEP_NUMBER,
477: X_DESCRIPTION => IGS_TR_STEP_REC.DESCRIPTION,

Line 474: X_TRACKING_ID => IGS_TR_STEP_REC.TRACKING_ID,

470: FOR IGS_TR_STEP_REC IN CUR_IGS_TR_STEP(V_TRACKING_ID, v_trs_rec.tracking_step_id)
471: LOOP
472: IGS_TR_STEP_PKG.UPDATE_ROW(
473: X_ROWID => IGS_TR_STEP_REC.ROWID,
474: X_TRACKING_ID => IGS_TR_STEP_REC.TRACKING_ID,
475: X_TRACKING_STEP_ID => IGS_TR_STEP_REC.TRACKING_STEP_ID,
476: X_TRACKING_STEP_NUMBER => IGS_TR_STEP_REC.TRACKING_STEP_NUMBER,
477: X_DESCRIPTION => IGS_TR_STEP_REC.DESCRIPTION,
478: X_S_TRACKING_STEP_TYPE => IGS_TR_STEP_REC.S_TRACKING_STEP_TYPE ,

Line 475: X_TRACKING_STEP_ID => IGS_TR_STEP_REC.TRACKING_STEP_ID,

471: LOOP
472: IGS_TR_STEP_PKG.UPDATE_ROW(
473: X_ROWID => IGS_TR_STEP_REC.ROWID,
474: X_TRACKING_ID => IGS_TR_STEP_REC.TRACKING_ID,
475: X_TRACKING_STEP_ID => IGS_TR_STEP_REC.TRACKING_STEP_ID,
476: X_TRACKING_STEP_NUMBER => IGS_TR_STEP_REC.TRACKING_STEP_NUMBER,
477: X_DESCRIPTION => IGS_TR_STEP_REC.DESCRIPTION,
478: X_S_TRACKING_STEP_TYPE => IGS_TR_STEP_REC.S_TRACKING_STEP_TYPE ,
479: X_COMPLETION_DT => IGS_TR_STEP_REC.COMPLETION_DT,

Line 476: X_TRACKING_STEP_NUMBER => IGS_TR_STEP_REC.TRACKING_STEP_NUMBER,

472: IGS_TR_STEP_PKG.UPDATE_ROW(
473: X_ROWID => IGS_TR_STEP_REC.ROWID,
474: X_TRACKING_ID => IGS_TR_STEP_REC.TRACKING_ID,
475: X_TRACKING_STEP_ID => IGS_TR_STEP_REC.TRACKING_STEP_ID,
476: X_TRACKING_STEP_NUMBER => IGS_TR_STEP_REC.TRACKING_STEP_NUMBER,
477: X_DESCRIPTION => IGS_TR_STEP_REC.DESCRIPTION,
478: X_S_TRACKING_STEP_TYPE => IGS_TR_STEP_REC.S_TRACKING_STEP_TYPE ,
479: X_COMPLETION_DT => IGS_TR_STEP_REC.COMPLETION_DT,
480: X_ACTION_DAYS => IGS_TR_STEP_REC.ACTION_DAYS,

Line 477: X_DESCRIPTION => IGS_TR_STEP_REC.DESCRIPTION,

473: X_ROWID => IGS_TR_STEP_REC.ROWID,
474: X_TRACKING_ID => IGS_TR_STEP_REC.TRACKING_ID,
475: X_TRACKING_STEP_ID => IGS_TR_STEP_REC.TRACKING_STEP_ID,
476: X_TRACKING_STEP_NUMBER => IGS_TR_STEP_REC.TRACKING_STEP_NUMBER,
477: X_DESCRIPTION => IGS_TR_STEP_REC.DESCRIPTION,
478: X_S_TRACKING_STEP_TYPE => IGS_TR_STEP_REC.S_TRACKING_STEP_TYPE ,
479: X_COMPLETION_DT => IGS_TR_STEP_REC.COMPLETION_DT,
480: X_ACTION_DAYS => IGS_TR_STEP_REC.ACTION_DAYS,
481: X_STEP_COMPLETION_IND => IGS_TR_STEP_REC.STEP_COMPLETION_IND ,

Line 478: X_S_TRACKING_STEP_TYPE => IGS_TR_STEP_REC.S_TRACKING_STEP_TYPE ,

474: X_TRACKING_ID => IGS_TR_STEP_REC.TRACKING_ID,
475: X_TRACKING_STEP_ID => IGS_TR_STEP_REC.TRACKING_STEP_ID,
476: X_TRACKING_STEP_NUMBER => IGS_TR_STEP_REC.TRACKING_STEP_NUMBER,
477: X_DESCRIPTION => IGS_TR_STEP_REC.DESCRIPTION,
478: X_S_TRACKING_STEP_TYPE => IGS_TR_STEP_REC.S_TRACKING_STEP_TYPE ,
479: X_COMPLETION_DT => IGS_TR_STEP_REC.COMPLETION_DT,
480: X_ACTION_DAYS => IGS_TR_STEP_REC.ACTION_DAYS,
481: X_STEP_COMPLETION_IND => IGS_TR_STEP_REC.STEP_COMPLETION_IND ,
482: X_BY_PASS_IND => IGS_TR_STEP_REC.BY_PASS_IND ,

Line 479: X_COMPLETION_DT => IGS_TR_STEP_REC.COMPLETION_DT,

475: X_TRACKING_STEP_ID => IGS_TR_STEP_REC.TRACKING_STEP_ID,
476: X_TRACKING_STEP_NUMBER => IGS_TR_STEP_REC.TRACKING_STEP_NUMBER,
477: X_DESCRIPTION => IGS_TR_STEP_REC.DESCRIPTION,
478: X_S_TRACKING_STEP_TYPE => IGS_TR_STEP_REC.S_TRACKING_STEP_TYPE ,
479: X_COMPLETION_DT => IGS_TR_STEP_REC.COMPLETION_DT,
480: X_ACTION_DAYS => IGS_TR_STEP_REC.ACTION_DAYS,
481: X_STEP_COMPLETION_IND => IGS_TR_STEP_REC.STEP_COMPLETION_IND ,
482: X_BY_PASS_IND => IGS_TR_STEP_REC.BY_PASS_IND ,
483: X_RECIPIENT_ID => NULL,

Line 480: X_ACTION_DAYS => IGS_TR_STEP_REC.ACTION_DAYS,

476: X_TRACKING_STEP_NUMBER => IGS_TR_STEP_REC.TRACKING_STEP_NUMBER,
477: X_DESCRIPTION => IGS_TR_STEP_REC.DESCRIPTION,
478: X_S_TRACKING_STEP_TYPE => IGS_TR_STEP_REC.S_TRACKING_STEP_TYPE ,
479: X_COMPLETION_DT => IGS_TR_STEP_REC.COMPLETION_DT,
480: X_ACTION_DAYS => IGS_TR_STEP_REC.ACTION_DAYS,
481: X_STEP_COMPLETION_IND => IGS_TR_STEP_REC.STEP_COMPLETION_IND ,
482: X_BY_PASS_IND => IGS_TR_STEP_REC.BY_PASS_IND ,
483: X_RECIPIENT_ID => NULL,
484: --add 3 new fields in the tbh call

Line 481: X_STEP_COMPLETION_IND => IGS_TR_STEP_REC.STEP_COMPLETION_IND ,

477: X_DESCRIPTION => IGS_TR_STEP_REC.DESCRIPTION,
478: X_S_TRACKING_STEP_TYPE => IGS_TR_STEP_REC.S_TRACKING_STEP_TYPE ,
479: X_COMPLETION_DT => IGS_TR_STEP_REC.COMPLETION_DT,
480: X_ACTION_DAYS => IGS_TR_STEP_REC.ACTION_DAYS,
481: X_STEP_COMPLETION_IND => IGS_TR_STEP_REC.STEP_COMPLETION_IND ,
482: X_BY_PASS_IND => IGS_TR_STEP_REC.BY_PASS_IND ,
483: X_RECIPIENT_ID => NULL,
484: --add 3 new fields in the tbh call
485: -- for tracking dld nov 2001 release bug#1837257

Line 482: X_BY_PASS_IND => IGS_TR_STEP_REC.BY_PASS_IND ,

478: X_S_TRACKING_STEP_TYPE => IGS_TR_STEP_REC.S_TRACKING_STEP_TYPE ,
479: X_COMPLETION_DT => IGS_TR_STEP_REC.COMPLETION_DT,
480: X_ACTION_DAYS => IGS_TR_STEP_REC.ACTION_DAYS,
481: X_STEP_COMPLETION_IND => IGS_TR_STEP_REC.STEP_COMPLETION_IND ,
482: X_BY_PASS_IND => IGS_TR_STEP_REC.BY_PASS_IND ,
483: X_RECIPIENT_ID => NULL,
484: --add 3 new fields in the tbh call
485: -- for tracking dld nov 2001 release bug#1837257
486: X_STEP_GROUP_ID => IGS_TR_STEP_REC.STEP_GROUP_ID,

Line 486: X_STEP_GROUP_ID => IGS_TR_STEP_REC.STEP_GROUP_ID,

482: X_BY_PASS_IND => IGS_TR_STEP_REC.BY_PASS_IND ,
483: X_RECIPIENT_ID => NULL,
484: --add 3 new fields in the tbh call
485: -- for tracking dld nov 2001 release bug#1837257
486: X_STEP_GROUP_ID => IGS_TR_STEP_REC.STEP_GROUP_ID,
487: X_PUBLISH_IND => IGS_TR_STEP_REC.PUBLISH_IND,
488: X_STEP_CATALOG_CD => IGS_TR_STEP_REC.STEP_CATALOG_CD,
489: X_MODE => 'R');
490: END LOOP;

Line 487: X_PUBLISH_IND => IGS_TR_STEP_REC.PUBLISH_IND,

483: X_RECIPIENT_ID => NULL,
484: --add 3 new fields in the tbh call
485: -- for tracking dld nov 2001 release bug#1837257
486: X_STEP_GROUP_ID => IGS_TR_STEP_REC.STEP_GROUP_ID,
487: X_PUBLISH_IND => IGS_TR_STEP_REC.PUBLISH_IND,
488: X_STEP_CATALOG_CD => IGS_TR_STEP_REC.STEP_CATALOG_CD,
489: X_MODE => 'R');
490: END LOOP;
491: END;

Line 488: X_STEP_CATALOG_CD => IGS_TR_STEP_REC.STEP_CATALOG_CD,

484: --add 3 new fields in the tbh call
485: -- for tracking dld nov 2001 release bug#1837257
486: X_STEP_GROUP_ID => IGS_TR_STEP_REC.STEP_GROUP_ID,
487: X_PUBLISH_IND => IGS_TR_STEP_REC.PUBLISH_IND,
488: X_STEP_CATALOG_CD => IGS_TR_STEP_REC.STEP_CATALOG_CD,
489: X_MODE => 'R');
490: END LOOP;
491: END;
492: END IF;

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 886: v_recipient_id IGS_TR_STEP.recipient_id%TYPE;

882: cst_stst_originator CONSTANT VARCHAR2(10) := 'RES_TPM_OR';
883: v_message_name VARCHAR2(30);
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;

Line 895: v_action_dt IGS_TR_STEP_V.action_dt%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
899: WHERE user_id = fnd_global.user_id;

Line 929: FROM IGS_TR_STEP_V tsdv

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 (
932: cp_tracking_id IGS_TR_ITEM.tracking_id%TYPE) IS
933: SELECT trs.tracking_step_id,

Line 935: FROM IGS_TR_STEP trs

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;
937: CURSOR c_tts (
938: cp_tracking_type IGS_TR_TYPE_STEP.tracking_type%TYPE,
939: cp_tracking_type_step_id IGS_TR_TYPE_STEP.tracking_type_step_id%TYPE) IS

Line 944: CURSOR CUR_IGS_TR_STEP ( cp_tracking_id IGS_TR_STEP.tracking_id%TYPE,

940: SELECT tts.recipient_id
941: FROM IGS_TR_TYPE_STEP tts
942: WHERE tracking_type = cp_tracking_type AND
943: tracking_type_step_id = cp_tracking_type_step_id;
944: CURSOR CUR_IGS_TR_STEP ( cp_tracking_id IGS_TR_STEP.tracking_id%TYPE,
945: cp_tracking_STEP_id IGS_TR_STEP.tracking_STEP_id%TYPE) IS
946: SELECT rowid , IGS_TR_STEP.*
947: FROM IGS_TR_STEP
948: WHERE tracking_id = CP_tracking_id AND

Line 945: cp_tracking_STEP_id IGS_TR_STEP.tracking_STEP_id%TYPE) IS

941: FROM IGS_TR_TYPE_STEP tts
942: WHERE tracking_type = cp_tracking_type AND
943: tracking_type_step_id = cp_tracking_type_step_id;
944: CURSOR CUR_IGS_TR_STEP ( cp_tracking_id IGS_TR_STEP.tracking_id%TYPE,
945: cp_tracking_STEP_id IGS_TR_STEP.tracking_STEP_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;

Line 946: SELECT rowid , IGS_TR_STEP.*

942: WHERE tracking_type = cp_tracking_type AND
943: tracking_type_step_id = cp_tracking_type_step_id;
944: CURSOR CUR_IGS_TR_STEP ( cp_tracking_id IGS_TR_STEP.tracking_id%TYPE,
945: cp_tracking_STEP_id IGS_TR_STEP.tracking_STEP_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

Line 947: FROM IGS_TR_STEP

943: tracking_type_step_id = cp_tracking_type_step_id;
944: CURSOR CUR_IGS_TR_STEP ( cp_tracking_id IGS_TR_STEP.tracking_id%TYPE,
945: cp_tracking_STEP_id IGS_TR_STEP.tracking_STEP_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.*

Line 1058: FOR IGS_TR_STEP_REC IN CUR_IGS_TR_STEP (v_tracking_id, v_trs_rec.tracking_step_id)

1054: END IF;
1055: ELSE
1056: -- Clear the recipient ID.
1057: BEGIN
1058: FOR IGS_TR_STEP_REC IN CUR_IGS_TR_STEP (v_tracking_id, v_trs_rec.tracking_step_id)
1059: LOOP
1060:
1061: IGS_TR_STEP_PKG.UPDATE_ROW(
1062: X_ROWID => IGS_TR_STEP_REC.ROWID,

Line 1061: IGS_TR_STEP_PKG.UPDATE_ROW(

1057: BEGIN
1058: FOR IGS_TR_STEP_REC IN CUR_IGS_TR_STEP (v_tracking_id, v_trs_rec.tracking_step_id)
1059: LOOP
1060:
1061: IGS_TR_STEP_PKG.UPDATE_ROW(
1062: X_ROWID => IGS_TR_STEP_REC.ROWID,
1063: X_TRACKING_ID => IGS_TR_STEP_REC.TRACKING_ID,
1064: X_TRACKING_STEP_ID => IGS_TR_STEP_REC.TRACKING_STEP_ID,
1065: X_TRACKING_STEP_NUMBER => IGS_TR_STEP_REC.TRACKING_STEP_NUMBER,

Line 1062: X_ROWID => IGS_TR_STEP_REC.ROWID,

1058: FOR IGS_TR_STEP_REC IN CUR_IGS_TR_STEP (v_tracking_id, v_trs_rec.tracking_step_id)
1059: LOOP
1060:
1061: IGS_TR_STEP_PKG.UPDATE_ROW(
1062: X_ROWID => IGS_TR_STEP_REC.ROWID,
1063: X_TRACKING_ID => IGS_TR_STEP_REC.TRACKING_ID,
1064: X_TRACKING_STEP_ID => IGS_TR_STEP_REC.TRACKING_STEP_ID,
1065: X_TRACKING_STEP_NUMBER => IGS_TR_STEP_REC.TRACKING_STEP_NUMBER,
1066: X_DESCRIPTION => IGS_TR_STEP_REC.DESCRIPTION,

Line 1063: X_TRACKING_ID => IGS_TR_STEP_REC.TRACKING_ID,

1059: LOOP
1060:
1061: IGS_TR_STEP_PKG.UPDATE_ROW(
1062: X_ROWID => IGS_TR_STEP_REC.ROWID,
1063: X_TRACKING_ID => IGS_TR_STEP_REC.TRACKING_ID,
1064: X_TRACKING_STEP_ID => IGS_TR_STEP_REC.TRACKING_STEP_ID,
1065: X_TRACKING_STEP_NUMBER => IGS_TR_STEP_REC.TRACKING_STEP_NUMBER,
1066: X_DESCRIPTION => IGS_TR_STEP_REC.DESCRIPTION,
1067: X_S_TRACKING_STEP_TYPE => IGS_TR_STEP_REC.S_TRACKING_STEP_TYPE ,

Line 1064: X_TRACKING_STEP_ID => IGS_TR_STEP_REC.TRACKING_STEP_ID,

1060:
1061: IGS_TR_STEP_PKG.UPDATE_ROW(
1062: X_ROWID => IGS_TR_STEP_REC.ROWID,
1063: X_TRACKING_ID => IGS_TR_STEP_REC.TRACKING_ID,
1064: X_TRACKING_STEP_ID => IGS_TR_STEP_REC.TRACKING_STEP_ID,
1065: X_TRACKING_STEP_NUMBER => IGS_TR_STEP_REC.TRACKING_STEP_NUMBER,
1066: X_DESCRIPTION => IGS_TR_STEP_REC.DESCRIPTION,
1067: X_S_TRACKING_STEP_TYPE => IGS_TR_STEP_REC.S_TRACKING_STEP_TYPE ,
1068: X_COMPLETION_DT => IGS_TR_STEP_REC.COMPLETION_DT ,

Line 1065: X_TRACKING_STEP_NUMBER => IGS_TR_STEP_REC.TRACKING_STEP_NUMBER,

1061: IGS_TR_STEP_PKG.UPDATE_ROW(
1062: X_ROWID => IGS_TR_STEP_REC.ROWID,
1063: X_TRACKING_ID => IGS_TR_STEP_REC.TRACKING_ID,
1064: X_TRACKING_STEP_ID => IGS_TR_STEP_REC.TRACKING_STEP_ID,
1065: X_TRACKING_STEP_NUMBER => IGS_TR_STEP_REC.TRACKING_STEP_NUMBER,
1066: X_DESCRIPTION => IGS_TR_STEP_REC.DESCRIPTION,
1067: X_S_TRACKING_STEP_TYPE => IGS_TR_STEP_REC.S_TRACKING_STEP_TYPE ,
1068: X_COMPLETION_DT => IGS_TR_STEP_REC.COMPLETION_DT ,
1069: X_ACTION_DAYS => IGS_TR_STEP_REC.ACTION_DAYS,

Line 1066: X_DESCRIPTION => IGS_TR_STEP_REC.DESCRIPTION,

1062: X_ROWID => IGS_TR_STEP_REC.ROWID,
1063: X_TRACKING_ID => IGS_TR_STEP_REC.TRACKING_ID,
1064: X_TRACKING_STEP_ID => IGS_TR_STEP_REC.TRACKING_STEP_ID,
1065: X_TRACKING_STEP_NUMBER => IGS_TR_STEP_REC.TRACKING_STEP_NUMBER,
1066: X_DESCRIPTION => IGS_TR_STEP_REC.DESCRIPTION,
1067: X_S_TRACKING_STEP_TYPE => IGS_TR_STEP_REC.S_TRACKING_STEP_TYPE ,
1068: X_COMPLETION_DT => IGS_TR_STEP_REC.COMPLETION_DT ,
1069: X_ACTION_DAYS => IGS_TR_STEP_REC.ACTION_DAYS,
1070: X_STEP_COMPLETION_IND => IGS_TR_STEP_REC.STEP_COMPLETION_IND ,

Line 1067: X_S_TRACKING_STEP_TYPE => IGS_TR_STEP_REC.S_TRACKING_STEP_TYPE ,

1063: X_TRACKING_ID => IGS_TR_STEP_REC.TRACKING_ID,
1064: X_TRACKING_STEP_ID => IGS_TR_STEP_REC.TRACKING_STEP_ID,
1065: X_TRACKING_STEP_NUMBER => IGS_TR_STEP_REC.TRACKING_STEP_NUMBER,
1066: X_DESCRIPTION => IGS_TR_STEP_REC.DESCRIPTION,
1067: X_S_TRACKING_STEP_TYPE => IGS_TR_STEP_REC.S_TRACKING_STEP_TYPE ,
1068: X_COMPLETION_DT => IGS_TR_STEP_REC.COMPLETION_DT ,
1069: X_ACTION_DAYS => IGS_TR_STEP_REC.ACTION_DAYS,
1070: X_STEP_COMPLETION_IND => IGS_TR_STEP_REC.STEP_COMPLETION_IND ,
1071: X_BY_PASS_IND => IGS_TR_STEP_REC.BY_PASS_IND ,

Line 1068: X_COMPLETION_DT => IGS_TR_STEP_REC.COMPLETION_DT ,

1064: X_TRACKING_STEP_ID => IGS_TR_STEP_REC.TRACKING_STEP_ID,
1065: X_TRACKING_STEP_NUMBER => IGS_TR_STEP_REC.TRACKING_STEP_NUMBER,
1066: X_DESCRIPTION => IGS_TR_STEP_REC.DESCRIPTION,
1067: X_S_TRACKING_STEP_TYPE => IGS_TR_STEP_REC.S_TRACKING_STEP_TYPE ,
1068: X_COMPLETION_DT => IGS_TR_STEP_REC.COMPLETION_DT ,
1069: X_ACTION_DAYS => IGS_TR_STEP_REC.ACTION_DAYS,
1070: X_STEP_COMPLETION_IND => IGS_TR_STEP_REC.STEP_COMPLETION_IND ,
1071: X_BY_PASS_IND => IGS_TR_STEP_REC.BY_PASS_IND ,
1072: X_RECIPIENT_ID => NULL,

Line 1069: X_ACTION_DAYS => IGS_TR_STEP_REC.ACTION_DAYS,

1065: X_TRACKING_STEP_NUMBER => IGS_TR_STEP_REC.TRACKING_STEP_NUMBER,
1066: X_DESCRIPTION => IGS_TR_STEP_REC.DESCRIPTION,
1067: X_S_TRACKING_STEP_TYPE => IGS_TR_STEP_REC.S_TRACKING_STEP_TYPE ,
1068: X_COMPLETION_DT => IGS_TR_STEP_REC.COMPLETION_DT ,
1069: X_ACTION_DAYS => IGS_TR_STEP_REC.ACTION_DAYS,
1070: X_STEP_COMPLETION_IND => IGS_TR_STEP_REC.STEP_COMPLETION_IND ,
1071: X_BY_PASS_IND => IGS_TR_STEP_REC.BY_PASS_IND ,
1072: X_RECIPIENT_ID => NULL,
1073: --add 3 new fields in the tbh call

Line 1070: X_STEP_COMPLETION_IND => IGS_TR_STEP_REC.STEP_COMPLETION_IND ,

1066: X_DESCRIPTION => IGS_TR_STEP_REC.DESCRIPTION,
1067: X_S_TRACKING_STEP_TYPE => IGS_TR_STEP_REC.S_TRACKING_STEP_TYPE ,
1068: X_COMPLETION_DT => IGS_TR_STEP_REC.COMPLETION_DT ,
1069: X_ACTION_DAYS => IGS_TR_STEP_REC.ACTION_DAYS,
1070: X_STEP_COMPLETION_IND => IGS_TR_STEP_REC.STEP_COMPLETION_IND ,
1071: X_BY_PASS_IND => IGS_TR_STEP_REC.BY_PASS_IND ,
1072: X_RECIPIENT_ID => NULL,
1073: --add 3 new fields in the tbh call
1074: -- for tracking dld nov 2001 release bug#1837257

Line 1071: X_BY_PASS_IND => IGS_TR_STEP_REC.BY_PASS_IND ,

1067: X_S_TRACKING_STEP_TYPE => IGS_TR_STEP_REC.S_TRACKING_STEP_TYPE ,
1068: X_COMPLETION_DT => IGS_TR_STEP_REC.COMPLETION_DT ,
1069: X_ACTION_DAYS => IGS_TR_STEP_REC.ACTION_DAYS,
1070: X_STEP_COMPLETION_IND => IGS_TR_STEP_REC.STEP_COMPLETION_IND ,
1071: X_BY_PASS_IND => IGS_TR_STEP_REC.BY_PASS_IND ,
1072: X_RECIPIENT_ID => NULL,
1073: --add 3 new fields in the tbh call
1074: -- for tracking dld nov 2001 release bug#1837257
1075: X_STEP_GROUP_ID => IGS_TR_STEP_REC.STEP_GROUP_ID,

Line 1075: X_STEP_GROUP_ID => IGS_TR_STEP_REC.STEP_GROUP_ID,

1071: X_BY_PASS_IND => IGS_TR_STEP_REC.BY_PASS_IND ,
1072: X_RECIPIENT_ID => NULL,
1073: --add 3 new fields in the tbh call
1074: -- for tracking dld nov 2001 release bug#1837257
1075: X_STEP_GROUP_ID => IGS_TR_STEP_REC.STEP_GROUP_ID,
1076: X_PUBLISH_IND => IGS_TR_STEP_REC.PUBLISH_IND,
1077: X_STEP_CATALOG_CD => IGS_TR_STEP_REC.STEP_CATALOG_CD,
1078: X_MODE => 'R');
1079: END LOOP;

Line 1076: X_PUBLISH_IND => IGS_TR_STEP_REC.PUBLISH_IND,

1072: X_RECIPIENT_ID => NULL,
1073: --add 3 new fields in the tbh call
1074: -- for tracking dld nov 2001 release bug#1837257
1075: X_STEP_GROUP_ID => IGS_TR_STEP_REC.STEP_GROUP_ID,
1076: X_PUBLISH_IND => IGS_TR_STEP_REC.PUBLISH_IND,
1077: X_STEP_CATALOG_CD => IGS_TR_STEP_REC.STEP_CATALOG_CD,
1078: X_MODE => 'R');
1079: END LOOP;
1080: END;

Line 1077: X_STEP_CATALOG_CD => IGS_TR_STEP_REC.STEP_CATALOG_CD,

1073: --add 3 new fields in the tbh call
1074: -- for tracking dld nov 2001 release bug#1837257
1075: X_STEP_GROUP_ID => IGS_TR_STEP_REC.STEP_GROUP_ID,
1076: X_PUBLISH_IND => IGS_TR_STEP_REC.PUBLISH_IND,
1077: X_STEP_CATALOG_CD => IGS_TR_STEP_REC.STEP_CATALOG_CD,
1078: X_MODE => 'R');
1079: END LOOP;
1080: END;
1081: END IF;