36: l_trace_enable_flag VARCHAR2(1) :='N';
37:
38: BEGIN
39:
40: -- Standard Start of API savepoint
41: -- SAVEPOINT get_pricing_attribs;
42:
43: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
44:
43: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
44:
45: csi_utility_grp.check_ib_active;
46:
47: -- Standard call to check for call compatibility.
48: IF NOT FND_API.Compatible_API_Call (l_api_version,
49: p_api_version,
50: l_api_name ,
51: g_pkg_name)
149: END IF;
150:
151: -- End of API body
152:
153: -- Standard check of p_commit.
154: /*
155: IF FND_API.To_Boolean( p_commit ) THEN
156: COMMIT WORK;
157: END IF;
164: END IF;
165: -- End disable trace
166: ****/
167:
168: -- Standard call to get message count and if count is get message info.
169: FND_MSG_PUB.Count_And_Get
170: (p_count => x_msg_count ,
171: p_data => x_msg_data
172: );
243: l_trace_enable_flag VARCHAR2(1) :='N';
244:
245: BEGIN
246:
247: -- Standard Start of API savepoint
248: SAVEPOINT create_pricing_attribs;
249:
250: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
251:
251:
252: csi_utility_grp.check_ib_active;
253:
254:
255: -- Standard call to check for call compatibility.
256: IF NOT FND_API.Compatible_API_Call (l_api_version,
257: p_api_version,
258: l_api_name ,
259: g_pkg_name)
340:
341: -- End of API body
342:
343:
344: -- Standard check of p_commit.
345: IF FND_API.To_Boolean( p_commit ) THEN
346: COMMIT WORK;
347: END IF;
348:
353: END IF;
354: -- End disable trace
355: ****/
356:
357: -- Standard call to get message count and if count is get message info.
358: FND_MSG_PUB.Count_And_Get
359: (p_count => x_msg_count ,
360: p_data => x_msg_data
361: );
430: l_trace_enable_flag VARCHAR2(1) :='N';
431:
432: BEGIN
433:
434: -- Standard Start of API savepoint
435: SAVEPOINT update_pricing_attribs;
436:
437: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
438:
438:
439: csi_utility_grp.check_ib_active;
440:
441:
442: -- Standard call to check for call compatibility.
443: IF NOT FND_API.Compatible_API_Call (l_api_version,
444: p_api_version,
445: l_api_name ,
446: g_pkg_name)
526:
527: -- End of API body
528:
529:
530: -- Standard check of p_commit.
531: IF FND_API.To_Boolean( p_commit ) THEN
532: COMMIT WORK;
533: END IF;
534:
539: END IF;
540: -- End disable trace
541: ****/
542:
543: -- Standard call to get message count and if count is get message info.
544: FND_MSG_PUB.Count_And_Get
545: (p_count => x_msg_count ,
546: p_data => x_msg_data
547: );
615: l_trace_enable_flag VARCHAR2(1) :='N';
616:
617: BEGIN
618:
619: -- Standard Start of API savepoint
620: SAVEPOINT expire_pricing_attribs;
621:
622: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
623:
622: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
623:
624: csi_utility_grp.check_ib_active;
625:
626: -- Standard call to check for call compatibility.
627: IF NOT FND_API.Compatible_API_Call (l_api_version,
628: p_api_version,
629: l_api_name ,
630: g_pkg_name)
711:
712: -- End of API body
713:
714:
715: -- Standard check of p_commit.
716: IF FND_API.To_Boolean( p_commit ) THEN
717: COMMIT WORK;
718: END IF;
719:
724: END IF;
725: -- End disable trace
726: ****/
727:
728: -- Standard call to get message count and if count is get message info.
729: FND_MSG_PUB.Count_And_Get
730: (p_count => x_msg_count ,
731: p_data => x_msg_data
732: );