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.EAM_WORKORDERBILLING_PVT dependencies on STANDARD

Line 83: -- Standard Start of API savepoint

79:
80: BEGIN
81:
82: l_stmt := 10;
83: -- Standard Start of API savepoint
84: SAVEPOINT insert_AR_Interface_PVT;
85: -- Standard call to check for call compatibility.
86: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
87: p_api_version ,

Line 85: -- Standard call to check for call compatibility.

81:
82: l_stmt := 10;
83: -- Standard Start of API savepoint
84: SAVEPOINT insert_AR_Interface_PVT;
85: -- Standard call to check for call compatibility.
86: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
87: p_api_version ,
88: l_api_name ,
89: G_PKG_NAME )

Line 240: NULL, nvl(sp.standard_terms,

236:
237: select nvl(su.payment_term_id,
238: decode(spt.billing_cycle_id,
239: -- if cycle is NULL
240: NULL, nvl(sp.standard_terms,
241: decode(apt.billing_cycle_id,
242: -- if cycle is NULL
243: NULL, nvl(ap.standard_terms , -94) ,
244: -- if cycle is NOT NULL

Line 243: NULL, nvl(ap.standard_terms , -94) ,

239: -- if cycle is NULL
240: NULL, nvl(sp.standard_terms,
241: decode(apt.billing_cycle_id,
242: -- if cycle is NULL
243: NULL, nvl(ap.standard_terms , -94) ,
244: -- if cycle is NOT NULL
245: -92)),
246: -- if cycle is NOT NULL
247: decode(ap.cons_bill_level,

Line 249: 'ACCOUNT', nvl(ap.standard_terms, -93),

245: -92)),
246: -- if cycle is NOT NULL
247: decode(ap.cons_bill_level,
248: -- if bill level = Account
249: 'ACCOUNT', nvl(ap.standard_terms, -93),
250: -- if bill level = Site
251: 'SITE', nvl(nvl(sp.standard_terms, ap.standard_terms), -95)
252: -- if bill level is not set
253: , -91)))

Line 251: 'SITE', nvl(nvl(sp.standard_terms, ap.standard_terms), -95)

247: decode(ap.cons_bill_level,
248: -- if bill level = Account
249: 'ACCOUNT', nvl(ap.standard_terms, -93),
250: -- if bill level = Site
251: 'SITE', nvl(nvl(sp.standard_terms, ap.standard_terms), -95)
252: -- if bill level is not set
253: , -91)))
254: into l_term_id
255: from --ra_cust_trx_types tt,

Line 260: ( select /+ leading(su2) / cp.override_terms,cp.standard_terms,cp.cust_account_id,

256: hz_customer_profiles ap,
257: hz_cust_site_uses_all su,
258: ra_terms_b apt,
259: ra_terms_b spt,
260: ( select /*+ leading(su2) */ cp.override_terms,cp.standard_terms,cp.cust_account_id,
261: su2.site_use_id profile_bill_to_site_use_id
262: from hz_customer_profiles cp,
263: hz_cust_site_uses_all su1,
264: hz_cust_site_uses_all su2

Line 277: and ap.standard_terms = apt.term_id (+)

273: and p_ra_line.customer_id = ap.cust_account_id
274: and ap.site_use_id is null
275: and p_ra_line.customer_id = sp.cust_account_id (+)
276: and su.site_use_id = sp.profile_bill_to_site_use_id (+)
277: and ap.standard_terms = apt.term_id (+)
278: and sysdate between nvl(apt.start_date_active, sysdate) and
279: nvl(apt.end_date_active, sysdate)
280: and sp.standard_terms = spt.term_id (+)
281: and sysdate between nvl(spt.start_date_active, sysdate) and

Line 280: and sp.standard_terms = spt.term_id (+)

276: and su.site_use_id = sp.profile_bill_to_site_use_id (+)
277: and ap.standard_terms = apt.term_id (+)
278: and sysdate between nvl(apt.start_date_active, sysdate) and
279: nvl(apt.end_date_active, sysdate)
280: and sp.standard_terms = spt.term_id (+)
281: and sysdate between nvl(spt.start_date_active, sysdate) and
282: nvl(spt.end_date_active, sysdate);
283:
284: exception

Line 480: -- Standard check of p_commit.

476: l_stmt := 70;
477:
478: -- End of API body.
479:
480: -- Standard check of p_commit.
481: IF FND_API.To_Boolean( p_commit ) THEN
482: COMMIT WORK;
483: END IF;
484: -- Standard call to get message count and if count is 1, get message info.

Line 484: -- Standard call to get message count and if count is 1, get message info.

480: -- Standard check of p_commit.
481: IF FND_API.To_Boolean( p_commit ) THEN
482: COMMIT WORK;
483: END IF;
484: -- Standard call to get message count and if count is 1, get message info.
485: FND_MSG_PUB.Count_And_Get
486: ( p_count => x_msg_count ,
487: p_data => x_msg_data
488: );

Line 541: -- Standard Start of API savepoint

537: l_rounded_unit_price NUMBER;
538: l_rounded_conv_rate NUMBER;
539:
540: BEGIN
541: -- Standard Start of API savepoint
542: SAVEPOINT insert_WO_Table_PVT;
543: -- Standard call to check for call compatibility.
544: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
545: p_api_version ,

Line 543: -- Standard call to check for call compatibility.

539:
540: BEGIN
541: -- Standard Start of API savepoint
542: SAVEPOINT insert_WO_Table_PVT;
543: -- Standard call to check for call compatibility.
544: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
545: p_api_version ,
546: l_api_name ,
547: G_PKG_NAME )

Line 687: -- Standard check of p_commit.

683:
684:
685:
686: -- End of API body.
687: -- Standard check of p_commit.
688: IF FND_API.To_Boolean( p_commit ) THEN
689: COMMIT WORK;
690: END IF;
691: -- Standard call to get message count and if count is 1, get message info.

Line 691: -- Standard call to get message count and if count is 1, get message info.

687: -- Standard check of p_commit.
688: IF FND_API.To_Boolean( p_commit ) THEN
689: COMMIT WORK;
690: END IF;
691: -- Standard call to get message count and if count is 1, get message info.
692: FND_MSG_PUB.Count_And_Get
693: ( p_count => x_msg_count ,
694: p_data => x_msg_data
695: );

Line 779: -- Standard Start of API savepoint

775: l_rounded_amount NUMBER;
776:
777:
778: BEGIN
779: -- Standard Start of API savepoint
780: SAVEPOINT insert_PAEvent_Table_PVT;
781: -- Standard call to check for call compatibility.
782: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
783: p_api_version ,

Line 781: -- Standard call to check for call compatibility.

777:
778: BEGIN
779: -- Standard Start of API savepoint
780: SAVEPOINT insert_PAEvent_Table_PVT;
781: -- Standard call to check for call compatibility.
782: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
783: p_api_version ,
784: l_api_name ,
785: G_PKG_NAME )

Line 941: -- Standard check of p_commit.

937: --dbms_output.put_line('finished inserting');
938:
939:
940: -- End of API body.
941: -- Standard check of p_commit.
942: IF FND_API.To_Boolean( p_commit ) THEN
943: COMMIT WORK;
944: END IF;
945: -- Standard call to get message count and if count is 1, get message info.

Line 945: -- Standard call to get message count and if count is 1, get message info.

941: -- Standard check of p_commit.
942: IF FND_API.To_Boolean( p_commit ) THEN
943: COMMIT WORK;
944: END IF;
945: -- Standard call to get message count and if count is 1, get message info.
946: FND_MSG_PUB.Count_And_Get
947: ( p_count => x_msg_count ,
948: p_data => x_msg_data
949: );