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 2197: from iex_AG_DN_XREF

2193: LAST_UPDATED_BY,
2194: CREATION_DATE,
2195: CREATED_BY ,
2196: LAST_UPDATE_LOGIN
2197: from iex_AG_DN_XREF
2198: where AG_DN_XREF_id = in_AG_DN_XREF_id
2199: FOR UPDATE NOWAIT;
2200: --
2201: l_api_name CONSTANT VARCHAR2(30) := 'Update_AG_DN';

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

2263: If ( C_Get_AG_DN_XREF_REC%NOTFOUND) Then
2264: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2265: THEN
2266: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
2267: FND_MESSAGE.Set_Token ('INFO', 'IEX_AG_DN_XREF', FALSE);
2268: FND_MSG_PUB.Add;
2269: END IF;
2270: raise FND_API.G_EXC_ERROR;
2271: END IF;

Line 2408: FROM IEX_AG_DN_XREF

2404:
2405: IS
2406: CURSOR C_GET_AG_DN_XREF (IN_AG_DN_XREF_ID NUMBER) IS
2407: SELECT AG_DN_XREF_ID
2408: FROM IEX_AG_DN_XREF
2409: WHERE AG_DN_XREF_ID = IN_AG_DN_XREF_ID;
2410: --
2411: l_AG_DN_XREF_id NUMBER;
2412: l_api_name CONSTANT VARCHAR2(30) := 'Delete_AG_DN';

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

2452:
2453: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2454: THEN
2455: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
2456: FND_MESSAGE.Set_Token ('INFO', 'IEX_AG_DN_XREF', FALSE);
2457: FND_MSG_PUB.Add;
2458: END IF;
2459: raise FND_API.G_EXC_ERROR;
2460: END IF;

Line 2693: from iex_ag_dn_xref

2689: select ag_dn_xref_id,
2690: range_of_dunning_level_from,
2691: range_of_dunning_level_to,
2692: min_days_between_dunning
2693: from iex_ag_dn_xref
2694: where AG_DN_XREF_ID = p_ag_dn_xref_id
2695: order by AG_DN_XREF_ID;
2696:
2697: l_dunning_plan_lines c_dunning_plan_lines%rowtype;

Line 2716: from iex_ag_dn_xref xref,

2712:
2713: cursor c_dunn_plan_line_dtls (p_ag_dn_xref_id number) is
2714: select nvl(dunn.include_current ,'N'),
2715: nvl(dunn.include_unused_payments_flag,'N')
2716: from iex_ag_dn_xref xref,
2717: iex_dunning_plans_b dunn
2718: where AG_DN_XREF_ID = p_ag_dn_xref_id
2719: and xref.dunning_plan_id = dunn.dunning_plan_id;
2720:

Line 4024: FROM IEX_AG_DN_XREF x,

4020: x.xdo_template_id,
4021: x.fm_method,
4022: upper(x.callback_flag),
4023: x.callback_days
4024: FROM IEX_AG_DN_XREF x,
4025: ar_aging_buckets ar,
4026: iex_dunning_plans_vl d
4027: WHERE x.aging_bucket_line_ID = l_line_ID
4028: and x.dunning_plan_id = p_dunning_plan_id

Line 4474: * Get Template_ID From iex_ag_dn_xref

4470: END IF;
4471: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - lineid='||l_bucket_line_id);
4472:
4473: /*===========================================
4474: * Get Template_ID From iex_ag_dn_xref
4475: *===========================================*/
4476: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - RUNNING LEVEL = '||p_running_level);
4477: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - bucket_line_id = '||l_bucket_line_id);
4478: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - score = '||l_score);

Line 5290: FROM IEX_AG_DN_XREF x,

5286: x.xdo_template_id,
5287: x.fm_method,
5288: upper(x.callback_flag),
5289: x.callback_days
5290: FROM IEX_AG_DN_XREF x,
5291: ar_aging_buckets ar,
5292: iex_dunning_plans_vl d
5293: WHERE x.aging_bucket_line_ID = l_line_ID
5294: and x.dunning_plan_id = p_dunning_plan_id

Line 5329: from iex_ag_dn_xref

5325: range_of_dunning_level_from,
5326: range_of_dunning_level_to,
5327: min_days_between_dunning,
5328: invoice_copies
5329: from iex_ag_dn_xref
5330: where dunning_plan_id = p_dunn_plan_id
5331: order by AG_DN_XREF_ID ;
5332:
5333: Type refCur is Ref Cursor;

Line 5447: from iex_ag_dn_xref

5443:
5444: cursor c_min_days_between_dunn_99 (p_dunn_plan_id number, p_stage_no number, p_score_val number)
5445: is
5446: select min_days_between_dunning
5447: from iex_ag_dn_xref
5448: where dunning_plan_id = p_dunn_plan_id
5449: and p_stage_no between range_of_dunning_level_from and range_of_dunning_level_to
5450: and p_score_val between score_range_low and score_range_high;
5451:

Line 5877: ' from iex_ag_dn_xref ' ||

5873: ' range_of_dunning_level_from, ' ||
5874: ' range_of_dunning_level_to, ' ||
5875: ' min_days_between_dunning, ' ||
5876: ' invoice_copies ' ||
5877: ' from iex_ag_dn_xref ' ||
5878: ' where dunning_plan_id = :p_dunning_plan_id ' ||
5879: ' AND :p_score between score_range_low and score_range_high ' ||
5880: ' order by range_of_dunning_level_from ' || l_orderby;
5881:

Line 6945: FROM IEX_AG_DN_XREF x,

6941: x.fm_method,
6942: upper(x.callback_flag),
6943: x.callback_days,
6944: ar.bucket_name
6945: FROM IEX_AG_DN_XREF x,
6946: ar_aging_buckets ar,
6947: iex_dunning_plans_vl d
6948: WHERE x.aging_bucket_line_ID = l_line_ID
6949: and x.dunning_plan_id = p_dunning_plan_id

Line 7313: * Get Template_ID From iex_ag_dn_xref

7309: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - lineid='||l_bucket_line_id);
7310: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - EndAgingDel');
7311:
7312: /*===========================================
7313: * Get Template_ID From iex_ag_dn_xref
7314: *===========================================*/
7315:
7316: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - GET Template');
7317:

Line 7991: FROM IEX_AG_DN_XREF x,

7987: x.fm_method,
7988: upper(x.callback_flag),
7989: x.callback_days,
7990: ar.bucket_name
7991: FROM IEX_AG_DN_XREF x,
7992: ar_aging_buckets ar,
7993: iex_dunning_plans_vl d
7994: WHERE x.aging_bucket_line_ID = l_line_ID
7995: and x.dunning_plan_id = p_dunning_plan_id

Line 8151: from iex_ag_dn_xref

8147: range_of_dunning_level_from,
8148: range_of_dunning_level_to,
8149: min_days_between_dunning ,
8150: invoice_copies
8151: from iex_ag_dn_xref
8152: where dunning_plan_id = p_dunning_plan_id
8153: --and range_of_dunning_level_from >= p_stage
8154: --and range_of_dunning_level_to <= p_stage
8155: and p_stage between range_of_dunning_level_from and range_of_dunning_level_to

Line 8277: from iex_ag_dn_xref

8273:
8274: cursor c_min_days_between_dunn_99 (p_dunn_plan_id number, p_stage_no number, p_score_val number)
8275: is
8276: select min_days_between_dunning
8277: from iex_ag_dn_xref
8278: where dunning_plan_id = p_dunn_plan_id
8279: and p_stage_no between range_of_dunning_level_from and range_of_dunning_level_to
8280: and p_score_val between score_range_low and score_range_high;
8281:

Line 9166: FROM IEX_AG_DN_XREF x,

9162: x.xdo_template_id,
9163: x.fm_method,
9164: upper(x.callback_flag),
9165: x.callback_days
9166: FROM IEX_AG_DN_XREF x,
9167: ar_aging_buckets ar,
9168: iex_dunning_plans_vl d
9169: WHERE x.aging_bucket_line_ID = l_line_ID
9170: and x.dunning_plan_id = p_dunning_plan_id

Line 9503: * Get Template_ID From iex_ag_dn_xref

9499:
9500: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - lineid='||l_bucket_line_id);
9501:
9502: /*===========================================
9503: * Get Template_ID From iex_ag_dn_xref
9504: *===========================================*/
9505:
9506: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - GET Template');
9507:

Line 10246: FROM IEX_AG_DN_XREF x,

10242: x.xdo_template_id,
10243: x.fm_method,
10244: upper(x.callback_flag),
10245: x.callback_days
10246: FROM IEX_AG_DN_XREF x,
10247: ar_aging_buckets ar,
10248: iex_dunning_plans_vl d
10249: WHERE x.aging_bucket_line_ID = l_line_ID
10250: and x.dunning_plan_id = p_dunning_plan_id

Line 10346: FROM IEX_AG_DN_XREF x

10342: SELECT
10343: --x.fm_method,
10344: upper(x.callback_flag),
10345: x.callback_days
10346: FROM IEX_AG_DN_XREF x
10347: WHERE x.ag_dn_xref_id = p_ag_dn_xref_id;
10348:
10349: l_dunning_object_id number;
10350: l_del_id number;

Line 10640: * Get Template_ID From iex_ag_dn_xref

10636:
10637: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - lineid='||l_bucket_line_id);
10638: */
10639: /*===========================================
10640: * Get Template_ID From iex_ag_dn_xref
10641: *===========================================*/
10642: /*
10643: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - GET Template');
10644:

Line 11198: FROM IEX_AG_DN_XREF x,

11194: x.fm_method,
11195: upper(x.callback_flag),
11196: x.callback_days,
11197: ar.bucket_name
11198: FROM IEX_AG_DN_XREF x,
11199: ar_aging_buckets ar,
11200: iex_dunning_plans_vl d
11201: WHERE x.aging_bucket_line_ID = l_line_ID
11202: and x.dunning_plan_id = p_dunning_plan_id

Line 11432: * Get Template_ID From iex_ag_dn_xref

11428: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - lineid='||l_bucket_line_id);
11429: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - EndAgingDel');
11430:
11431: /*==========================================
11432: * Get Template_ID From iex_ag_dn_xref
11433: *===========================================*/
11434:
11435: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - GET Template');
11436:

Line 11990: FROM IEX_AG_DN_XREF x,

11986: x.fm_method,
11987: upper(x.callback_flag),
11988: x.callback_days,
11989: ar.bucket_name
11990: FROM IEX_AG_DN_XREF x,
11991: ar_aging_buckets ar,
11992: iex_dunning_plans_vl d
11993: WHERE x.aging_bucket_line_ID = l_line_ID
11994: and x.dunning_plan_id = p_dunning_plan_id

Line 12089: FROM IEX_AG_DN_XREF x

12085: CURSOR C_CALLBACK_DETAILS (p_ag_dn_xref_id number) IS
12086: SELECT x.fm_method,
12087: upper(x.callback_flag),
12088: x.callback_days
12089: FROM IEX_AG_DN_XREF x
12090: WHERE x.ag_dn_xref_id = p_ag_dn_xref_id;
12091:
12092: l_dunning_object_id number;
12093: l_del_id number;

Line 12251: * Get Template_ID From iex_ag_dn_xref

12247: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - lineid='||l_bucket_line_id);
12248: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - EndAgingDel');
12249: */
12250: /*==========================================
12251: * Get Template_ID From iex_ag_dn_xref
12252: *===========================================*/
12253: /*
12254: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - GET Template');
12255:

Line 12830: and exists (select 1 from iex_ag_dn_xref x

12826: and d.aging_bucket_id = b.aging_bucket_id
12827: and b.aging_bucket_id = l.aging_bucket_id
12828: --AND round(IN_DAYS) between l.days_start and l.days_to
12829: AND IN_DAYS between l.days_start and l.days_to
12830: and exists (select 1 from iex_ag_dn_xref x
12831: where d.dunning_plan_id = x.dunning_plan_id
12832: and d.aging_bucket_id = x.aging_bucket_id
12833: and x.aging_bucket_line_id = l.aging_bucket_line_id);
12834: -- end bug 9393778 gnramasa 19th Feb 10, add trunc function

Line 18177: iex_ag_dn_xref xref

18173: dunn.object_id,
18174: dunn.object_type
18175: from iex_dunning_transactions idt,
18176: iex_dunnings dunn,
18177: iex_ag_dn_xref xref
18178: where idt.dunning_id = dunn.dunning_id
18179: and dunn.request_id = p_conc_req_id
18180: and dunn.ag_dn_xref_id = xref.ag_dn_xref_id
18181: and xref.invoice_copies = 'Y'

Line 18200: ' iex_ag_dn_xref xref, ' ||

18196: ' dunn.object_type, ' ||
18197: ' dunn.dunning_method ' ||
18198: ' from iex_dunning_transactions idt, ' ||
18199: ' iex_dunnings dunn, ' ||
18200: ' iex_ag_dn_xref xref, ' ||
18201: ' ra_customer_trx trx ' ||
18202: ' where idt.dunning_id = dunn.dunning_id ' ||
18203: ' and dunn.request_id = :p_conc_req_id ' ||
18204: ' and dunn.ag_dn_xref_id = xref.ag_dn_xref_id ' ||

Line 18423: from iex_ag_dn_xref xref,

18419:
18420: cursor c_dunn_plan_line_dtls (p_ag_dn_xref_id number) is
18421: select nvl(dunn.include_current ,'N'),
18422: nvl(dunn.include_unused_payments_flag,'N')
18423: from iex_ag_dn_xref xref,
18424: iex_dunning_plans_b dunn
18425: where AG_DN_XREF_ID = p_ag_dn_xref_id
18426: and xref.dunning_plan_id = dunn.dunning_plan_id;
18427: