APPS.OPI_EDW_OPM_PRD_PKG dependencies on FND_PROFILE

Line 18: and reason_code = fnd_profile.value('PMI$REASON_CODE');

14: SELECT nvl(max(trans_id),0) from ic_tran_cmp_vw1
15: where item_id = item_id_v
16: and lot_id = lot_id_v
17: and doc_type = 'GRDI'
18: and reason_code = fnd_profile.value('PMI$REASON_CODE');
19: begin
20: if (item_id_vi = PKG_VAR_ITEM_ID_V AND
21: LOT_ID_VI = PKG_VAR_LOT_ID_V) then
22: return PKG_VAR_QC_GRADE_V;

Line 115: and reason_code = fnd_profile.value('PMI$REASON_CODE_BTCH_ADJ');

111: into ADJUST_BATCH_V
112: from ic_tran_cmp_vw1
113: where doc_id = BATCH_ID_VI
114: and doc_type = 'PROD'
115: and reason_code = fnd_profile.value('PMI$REASON_CODE_BTCH_ADJ');
116:
117: PKG_VAR_BATCH_ID_V3 := BATCH_ID_vi;
118: PKG_VAR_ADJUST_BATCH_V := ADJUST_BATCH_v;
119:

Line 286: SCHEDULE_VI := fnd_profile.value('GEMMS_DEFAULT_SCHEDULE');

282: where batch_id = batch_id_vi;
283: /* Assign the Parameters */
284: START_DATE_V:=START_DATE;
285: CMPLT_DATE_V:=CMPLT_DATE;
286: SCHEDULE_VI := fnd_profile.value('GEMMS_DEFAULT_SCHEDULE');
287:
288: select count(*) into count2_v
289: from ps_schd_dtl sd, ps_schd_hdr sh
290: where sd.schedule_id = sh.schedule_id