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.AMS_LISTGENERATION_PKG dependencies on AMS_LISTHEADER_PVT

Line 1104: (p_list_header_rec ams_listheader_pvt.list_header_rec_type,

1100: -- Error logging at each stage
1101: -- END of Comments
1102: -----------------------------------------------------------------------------
1103: PROCEDURE initialize_list
1104: (p_list_header_rec ams_listheader_pvt.list_header_rec_type,
1105: x_msg_count OUT NOCOPY number,
1106: x_msg_data OUT NOCOPY varchar2,
1107: x_return_status OUT NOCOPY VARCHAR2 ) IS
1108: BEGIN

Line 6830: l_listheader_rec ams_listheader_pvt.list_header_rec_type;

6826: l_no_of_duplicates NUMBER := 0;
6827:
6828: -- Two records are required for init rec and complete rec
6829: -- Table ams_list_headers_all_tl and ams_list_headers_all
6830: l_listheader_rec ams_listheader_pvt.list_header_rec_type;
6831: l_tmp_listheader_rec ams_listheader_pvt.list_header_rec_type;
6832:
6833: -- Two records are required for init rec and complete rec
6834: -- Table ams_list_select_actions

Line 6831: l_tmp_listheader_rec ams_listheader_pvt.list_header_rec_type;

6827:
6828: -- Two records are required for init rec and complete rec
6829: -- Table ams_list_headers_all_tl and ams_list_headers_all
6830: l_listheader_rec ams_listheader_pvt.list_header_rec_type;
6831: l_tmp_listheader_rec ams_listheader_pvt.list_header_rec_type;
6832:
6833: -- Two records are required for init rec and complete rec
6834: -- Table ams_list_select_actions
6835: l_listaction_rec ams_listaction_pvt.action_rec_type;

Line 7297: write_to_act_log(p_msg_data => 'Calling ams_listheader_pvt to get the list header details.' ,

7293: -----------------------------------------------------------------------------
7294: -- Gets list header record details
7295: -- Intialize the record, set the list header id and retrieve the records
7296: -----------------------------------------------------------------------------
7297: write_to_act_log(p_msg_data => 'Calling ams_listheader_pvt to get the list header details.' ,
7298: p_arc_log_used_by => 'LIST',
7299: p_log_used_by_id => p_list_header_id,
7300: p_level => 'LOW');
7301:

Line 7302: ams_listheader_pvt.init_listheader_rec(l_tmp_listheader_rec);

7298: p_arc_log_used_by => 'LIST',
7299: p_log_used_by_id => p_list_header_id,
7300: p_level => 'LOW');
7301:
7302: ams_listheader_pvt.init_listheader_rec(l_tmp_listheader_rec);
7303: l_tmp_listheader_rec.list_header_id := p_list_header_id;
7304:
7305: l_error_position := '<- complete rec ->';
7306: ams_listheader_pvt.complete_listheader_rec

Line 7306: ams_listheader_pvt.complete_listheader_rec

7302: ams_listheader_pvt.init_listheader_rec(l_tmp_listheader_rec);
7303: l_tmp_listheader_rec.list_header_id := p_list_header_id;
7304:
7305: l_error_position := '<- complete rec ->';
7306: ams_listheader_pvt.complete_listheader_rec
7307: (p_listheader_rec =>l_tmp_listheader_rec,
7308: x_complete_rec =>l_listheader_rec);
7309: -----------------------------------------------------------------------------
7310:

Line 7934: l_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;

7930: x_return_status OUT NOCOPY VARCHAR2,
7931: x_msg_count OUT NOCOPY NUMBER,
7932: x_msg_data OUT NOCOPY VARCHAR2,
7933: x_list_header_id OUT NOCOPY NUMBER ) is
7934: l_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;
7935: l_init_msg_list varchar2(2000) := FND_API.G_FALSE;
7936: l_api_version number := 1.0;
7937: l_api_name constant varchar2(30) := 'Create_List';
7938: l_list_query_rec AMS_List_Query_PVT.list_query_rec_type ;

Line 8000: -- ams_listheader_pvt.init_listheader_rec(l_list_header_rec);

7996: -- Initialize API return status to success
7997: x_return_status := FND_API.G_RET_STS_SUCCESS;
7998: -- Perform the database operation
7999:
8000: -- ams_listheader_pvt.init_listheader_rec(l_list_header_rec);
8001: l_list_header_rec.list_name := p_list_name;
8002: l_list_header_rec.list_type := p_list_type;
8003: l_list_header_rec.owner_user_id := p_owner_user_id;
8004: l_list_header_rec.list_source_type := p_master_type ;

Line 8008: AMS_ListHeader_PVT.Create_Listheader

8004: l_list_header_rec.list_source_type := p_master_type ;
8005: if l_list_header_rec.view_application_id is null then
8006: l_list_header_rec.view_application_id := 530;
8007: end if;
8008: AMS_ListHeader_PVT.Create_Listheader
8009: ( p_api_version => 1.0,
8010: p_init_msg_list => l_init_msg_list,
8011: p_commit => p_commit,
8012: p_validation_level => p_validation_level ,

Line 8155: l_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;

8151: x_msg_count OUT NOCOPY NUMBER,
8152: x_msg_data OUT NOCOPY VARCHAR2,
8153: x_list_header_id OUT NOCOPY NUMBER ,
8154: p_list_name in VARCHAR2 ) is
8155: l_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;
8156: l_init_msg_list varchar2(2000) := FND_API.G_FALSE;
8157: l_api_version number := 1.0;
8158: l_api_name constant varchar2(30) := 'Create_import_List';
8159: l_action_rec AMS_ListAction_PVT.action_rec_type ;

Line 8219: -- ams_listheader_pvt.init_listheader_rec(l_list_header_rec);

8215: -- Initialize API return status to success
8216: x_return_status := FND_API.G_RET_STS_SUCCESS;
8217: -- Perform the database operation
8218:
8219: -- ams_listheader_pvt.init_listheader_rec(l_list_header_rec);
8220: l_list_header_rec.list_name := l_import_list_name ;
8221: l_list_header_rec.list_type := 'STANDARD';
8222: l_list_header_rec.list_source_type := l_source_type;
8223: l_list_header_rec.owner_user_id := p_owner_user_id;

Line 8227: AMS_ListHeader_PVT.Create_Listheader

8223: l_list_header_rec.owner_user_id := p_owner_user_id;
8224: l_list_header_rec.view_application_id := 530;
8225: -- l_list_header_rec.purpose_code := 'GENERAL';
8226:
8227: AMS_ListHeader_PVT.Create_Listheader
8228: ( p_api_version => 1.0,
8229: p_init_msg_list => l_init_msg_list,
8230: p_commit => p_commit,
8231: p_validation_level => p_validation_level ,

Line 8361: l_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;

8357: x_return_status OUT NOCOPY VARCHAR2,
8358: x_msg_count OUT NOCOPY NUMBER,
8359: x_msg_data OUT NOCOPY VARCHAR2
8360: ) is
8361: l_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;
8362: l_init_msg_list varchar2(2000) := FND_API.G_FALSE;
8363: l_api_version number := 1.0;
8364: l_api_name constant varchar2(30) := 'Create_List';
8365: l_list_query_rec_tbl AMS_List_Query_PVT.list_query_rec_type_tbl ;

Line 8540: l_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;

8536: x_return_status OUT NOCOPY VARCHAR2,
8537: x_msg_count OUT NOCOPY NUMBER,
8538: x_msg_data OUT NOCOPY VARCHAR2
8539: ) is
8540: l_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;
8541: l_init_msg_list varchar2(2000) := FND_API.G_FALSE;
8542: l_api_version number := 1.0;
8543: l_api_name constant varchar2(30) := 'Create_List';
8544: l_list_query_rec_tbl AMS_List_Query_PVT.list_query_rec_type_tbl ;

Line 9512: l_listheader_rec ams_listheader_pvt.list_header_rec_type;

9508: l_no_of_duplicates NUMBER := 0;
9509:
9510: -- Two records are required for init rec and complete rec
9511: -- Table ams_list_headers_all_tl and ams_list_headers_all
9512: l_listheader_rec ams_listheader_pvt.list_header_rec_type;
9513: l_tmp_listheader_rec ams_listheader_pvt.list_header_rec_type;
9514:
9515: -- Two records are required for init rec and complete rec
9516: -- Table ams_list_select_actions

Line 9513: l_tmp_listheader_rec ams_listheader_pvt.list_header_rec_type;

9509:
9510: -- Two records are required for init rec and complete rec
9511: -- Table ams_list_headers_all_tl and ams_list_headers_all
9512: l_listheader_rec ams_listheader_pvt.list_header_rec_type;
9513: l_tmp_listheader_rec ams_listheader_pvt.list_header_rec_type;
9514:
9515: -- Two records are required for init rec and complete rec
9516: -- Table ams_list_select_actions
9517: l_listaction_rec ams_listaction_pvt.action_rec_type;

Line 9893: write_to_act_log(p_msg_data => 'Calling ams_listheader_pvt to get the header details.' ,

9889: -----------------------------------------------------------------------------
9890: -- Gets list header record details
9891: -- Intialize the record, set the list header id and retrieve the records
9892: -----------------------------------------------------------------------------
9893: write_to_act_log(p_msg_data => 'Calling ams_listheader_pvt to get the header details.' ,
9894: p_arc_log_used_by => 'LIST',
9895: p_log_used_by_id => p_list_header_id,
9896: p_level => 'LOW');
9897:

Line 9898: ams_listheader_pvt.init_listheader_rec(l_tmp_listheader_rec);

9894: p_arc_log_used_by => 'LIST',
9895: p_log_used_by_id => p_list_header_id,
9896: p_level => 'LOW');
9897:
9898: ams_listheader_pvt.init_listheader_rec(l_tmp_listheader_rec);
9899: l_tmp_listheader_rec.list_header_id := p_list_header_id;
9900:
9901: l_error_position := '<- complete rec ->';
9902: ams_listheader_pvt.complete_listheader_rec

Line 9902: ams_listheader_pvt.complete_listheader_rec

9898: ams_listheader_pvt.init_listheader_rec(l_tmp_listheader_rec);
9899: l_tmp_listheader_rec.list_header_id := p_list_header_id;
9900:
9901: l_error_position := '<- complete rec ->';
9902: ams_listheader_pvt.complete_listheader_rec
9903: (p_listheader_rec =>l_tmp_listheader_rec,
9904: x_complete_rec =>l_listheader_rec);
9905: -----------------------------------------------------------------------------
9906: