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.IEX_DUNNING_PVT dependencies on IEX_AG_DN_XREF

Line 2187: from iex_AG_DN_XREF

2183: LAST_UPDATED_BY,
2184: CREATION_DATE,
2185: CREATED_BY ,
2186: LAST_UPDATE_LOGIN
2187: from iex_AG_DN_XREF
2188: where AG_DN_XREF_id = in_AG_DN_XREF_id
2189: FOR UPDATE NOWAIT;
2190: --
2191: l_api_name CONSTANT VARCHAR2(30) := 'Update_AG_DN';

Line 2259: FND_MESSAGE.Set_Token ('INFO', 'IEX_AG_DN_XREF', FALSE);

2255: If ( C_Get_AG_DN_XREF_REC%NOTFOUND) Then
2256: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2257: THEN
2258: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
2259: FND_MESSAGE.Set_Token ('INFO', 'IEX_AG_DN_XREF', FALSE);
2260: FND_MSG_PUB.Add;
2261: END IF;
2262: raise FND_API.G_EXC_ERROR;
2263: END IF;

Line 2401: FROM IEX_AG_DN_XREF

2397:
2398: IS
2399: CURSOR C_GET_AG_DN_XREF (IN_AG_DN_XREF_ID NUMBER) IS
2400: SELECT AG_DN_XREF_ID
2401: FROM IEX_AG_DN_XREF
2402: WHERE AG_DN_XREF_ID = IN_AG_DN_XREF_ID;
2403: --
2404: l_AG_DN_XREF_id NUMBER;
2405: l_api_name CONSTANT VARCHAR2(30) := 'Delete_AG_DN';

Line 2450: FND_MESSAGE.Set_Token ('INFO', 'IEX_AG_DN_XREF', FALSE);

2446:
2447: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2448: THEN
2449: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
2450: FND_MESSAGE.Set_Token ('INFO', 'IEX_AG_DN_XREF', FALSE);
2451: FND_MSG_PUB.Add;
2452: END IF;
2453: raise FND_API.G_EXC_ERROR;
2454: END IF;

Line 3022: FROM IEX_AG_DN_XREF x,

3018: x.xdo_template_id,
3019: x.fm_method,
3020: upper(x.callback_flag),
3021: x.callback_days
3022: FROM IEX_AG_DN_XREF x,
3023: ar_aging_buckets ar,
3024: iex_dunning_plans_vl d
3025: WHERE x.aging_bucket_line_ID = l_line_ID
3026: and x.dunning_plan_id = p_dunning_plan_id

Line 3324: * Get Template_ID From iex_ag_dn_xref

3320: END IF;
3321: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - lineid='||l_bucket_line_id);
3322:
3323: /*===========================================
3324: * Get Template_ID From iex_ag_dn_xref
3325: *===========================================*/
3326:
3327: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - GET Template');
3328: Open C_Get_TEMPLATE(l_bucket_line_id, l_score, p_running_level, p_dunning_plan_id);

Line 3767: FROM IEX_AG_DN_XREF x,

3763: x.fm_method,
3764: upper(x.callback_flag),
3765: x.callback_days,
3766: ar.bucket_name
3767: FROM IEX_AG_DN_XREF x,
3768: ar_aging_buckets ar,
3769: iex_dunning_plans_vl d
3770: WHERE x.aging_bucket_line_ID = l_line_ID
3771: and x.dunning_plan_id = p_dunning_plan_id

Line 3979: * Get Template_ID From iex_ag_dn_xref

3975: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - EndAgingDel');
3976:
3977:
3978: /*===========================================
3979: * Get Template_ID From iex_ag_dn_xref
3980: *===========================================*/
3981:
3982: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - GET Template');
3983:

Line 4418: FROM IEX_AG_DN_XREF x,

4414: x.xdo_template_id,
4415: x.fm_method,
4416: upper(x.callback_flag),
4417: x.callback_days
4418: FROM IEX_AG_DN_XREF x,
4419: ar_aging_buckets ar,
4420: iex_dunning_plans_vl d
4421: WHERE x.aging_bucket_line_ID = l_line_ID
4422: and x.dunning_plan_id = p_dunning_plan_id

Line 4676: * Get Template_ID From iex_ag_dn_xref

4672:
4673: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - lineid='||l_bucket_line_id);
4674:
4675: /*===========================================
4676: * Get Template_ID From iex_ag_dn_xref
4677: *===========================================*/
4678:
4679: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - GET Template');
4680:

Line 5112: FROM IEX_AG_DN_XREF x,

5108: x.fm_method,
5109: upper(x.callback_flag),
5110: x.callback_days,
5111: ar.bucket_name
5112: FROM IEX_AG_DN_XREF x,
5113: ar_aging_buckets ar,
5114: iex_dunning_plans_vl d
5115: WHERE x.aging_bucket_line_ID = l_line_ID
5116: and x.dunning_plan_id = p_dunning_plan_id

Line 5309: * Get Template_ID From iex_ag_dn_xref

5305: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - lineid='||l_bucket_line_id);
5306: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - EndAgingDel');
5307:
5308: /*==========================================
5309: * Get Template_ID From iex_ag_dn_xref
5310: *===========================================*/
5311:
5312: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - GET Template');
5313:

Line 5778: and exists (select 1 from iex_ag_dn_xref x

5774: WHERE d.dunning_plan_id = p_dunning_plan_id
5775: and d.aging_bucket_id = b.aging_bucket_id
5776: and b.aging_bucket_id = l.aging_bucket_id
5777: AND round(IN_DAYS) between l.days_start and l.days_to
5778: and exists (select 1 from iex_ag_dn_xref x
5779: where d.dunning_plan_id = x.dunning_plan_id
5780: and d.aging_bucket_id = x.aging_bucket_id
5781: and x.aging_bucket_line_id = l.aging_bucket_line_id);
5782: --