13: APPS_SCHEMA_NAME varchar2(4) := 'APPS';
14: -- ***********************************************
15: -- procedure Customize_pub_item
16: -- we assume the default pub item piv created
17: -- per standard as follows:
18: -- For example, pub item name :sample_custom
19: -- base table name : sample_custom
20: -- acc table name : sample_custom_acc
21: -- base table name : having 30 columns
67:
68: B_TAB_NAME := p_base_table_name;
69: log ('base table name = '||b_tab_name);
70:
71: -- Standard Start of API savepoint
72: SAVEPOINT customize_pub_item_PVT;
73: -- Standard call to check for call compatibility.
74: if NOT FND_API.Compatible_API_Call
75: (
69: log ('base table name = '||b_tab_name);
70:
71: -- Standard Start of API savepoint
72: SAVEPOINT customize_pub_item_PVT;
73: -- Standard call to check for call compatibility.
74: if NOT FND_API.Compatible_API_Call
75: (
76: l_api_version_number,
77: p_api_version_number,
569: l_api_name CONSTANT VARCHAR2(30) := 'MARK_DIRTY1' ;
570: l_ret boolean;
571:
572: BEGIN
573: -- Standard Start of API savepoint
574: SAVEPOINT mark_dirty1;
575:
576: -- Standard call to check for call compatibility.
577: if NOT FND_API.Compatible_API_Call
572: BEGIN
573: -- Standard Start of API savepoint
574: SAVEPOINT mark_dirty1;
575:
576: -- Standard call to check for call compatibility.
577: if NOT FND_API.Compatible_API_Call
578: (
579: l_api_version_number,
580: p_api_version_number,
638: l_api_name CONSTANT VARCHAR2(30) := 'MARK_DIRTY2' ;
639: l_ret boolean;
640:
641: BEGIN
642: -- Standard Start of API savepoint
643: SAVEPOINT mark_dirty2;
644:
645: -- Standard call to check for call compatibility.
646: if NOT FND_API.Compatible_API_Call
641: BEGIN
642: -- Standard Start of API savepoint
643: SAVEPOINT mark_dirty2;
644:
645: -- Standard call to check for call compatibility.
646: if NOT FND_API.Compatible_API_Call
647: (
648: l_api_version_number,
649: p_api_version_number,
708: l_api_name CONSTANT VARCHAR2(30) := 'MARK_DIRTY3';
709: l_ret boolean;
710:
711: BEGIN
712: -- Standard Start of API savepoint
713: SAVEPOINT mark_dirty3;
714:
715: -- Standard call to check for call compatibility.
716: if NOT FND_API.Compatible_API_Call
711: BEGIN
712: -- Standard Start of API savepoint
713: SAVEPOINT mark_dirty3;
714:
715: -- Standard call to check for call compatibility.
716: if NOT FND_API.Compatible_API_Call
717: (
718: l_api_version_number,
719: p_api_version_number,
780: l_ret boolean;
781:
782: BEGIN
783:
784: -- Standard Start of API savepoint
785: SAVEPOINT mark_dirty4;
786:
787: -- Standard call to check for call compatibility.
788: if NOT FND_API.Compatible_API_Call
783:
784: -- Standard Start of API savepoint
785: SAVEPOINT mark_dirty4;
786:
787: -- Standard call to check for call compatibility.
788: if NOT FND_API.Compatible_API_Call
789: (
790: l_api_version_number,
791: p_api_version_number,
850: l_ret boolean;
851: l_api_version_number CONSTANT NUMBER := 1.0;
852: l_api_name CONSTANT VARCHAR2(30) := 'MARK_DIRTY5';
853: BEGIN
854: -- Standard Start of API savepoint
855: SAVEPOINT mark_dirty5;
856:
857: -- Standard call to check for call compatibility.
858: if NOT FND_API.Compatible_API_Call
853: BEGIN
854: -- Standard Start of API savepoint
855: SAVEPOINT mark_dirty5;
856:
857: -- Standard call to check for call compatibility.
858: if NOT FND_API.Compatible_API_Call
859: (
860: l_api_version_number,
861: p_api_version_number,