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 6773: l_listheader_rec ams_listheader_pvt.list_header_rec_type;

6769: l_no_of_duplicates NUMBER := 0;
6770:
6771: -- Two records are required for init rec and complete rec
6772: -- Table ams_list_headers_all_tl and ams_list_headers_all
6773: l_listheader_rec ams_listheader_pvt.list_header_rec_type;
6774: l_tmp_listheader_rec ams_listheader_pvt.list_header_rec_type;
6775:
6776: -- Two records are required for init rec and complete rec
6777: -- Table ams_list_select_actions

Line 6774: l_tmp_listheader_rec ams_listheader_pvt.list_header_rec_type;

6770:
6771: -- Two records are required for init rec and complete rec
6772: -- Table ams_list_headers_all_tl and ams_list_headers_all
6773: l_listheader_rec ams_listheader_pvt.list_header_rec_type;
6774: l_tmp_listheader_rec ams_listheader_pvt.list_header_rec_type;
6775:
6776: -- Two records are required for init rec and complete rec
6777: -- Table ams_list_select_actions
6778: l_listaction_rec ams_listaction_pvt.action_rec_type;

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

7208: -----------------------------------------------------------------------------
7209: -- Gets list header record details
7210: -- Intialize the record, set the list header id and retrieve the records
7211: -----------------------------------------------------------------------------
7212: write_to_act_log(p_msg_data => 'Calling ams_listheader_pvt to get the list header details.' ,
7213: p_arc_log_used_by => 'LIST',
7214: p_log_used_by_id => p_list_header_id,
7215: p_level => 'LOW');
7216:

Line 7217: ams_listheader_pvt.init_listheader_rec(l_tmp_listheader_rec);

7213: p_arc_log_used_by => 'LIST',
7214: p_log_used_by_id => p_list_header_id,
7215: p_level => 'LOW');
7216:
7217: ams_listheader_pvt.init_listheader_rec(l_tmp_listheader_rec);
7218: l_tmp_listheader_rec.list_header_id := p_list_header_id;
7219:
7220: l_error_position := '<- complete rec ->';
7221: ams_listheader_pvt.complete_listheader_rec

Line 7221: ams_listheader_pvt.complete_listheader_rec

7217: ams_listheader_pvt.init_listheader_rec(l_tmp_listheader_rec);
7218: l_tmp_listheader_rec.list_header_id := p_list_header_id;
7219:
7220: l_error_position := '<- complete rec ->';
7221: ams_listheader_pvt.complete_listheader_rec
7222: (p_listheader_rec =>l_tmp_listheader_rec,
7223: x_complete_rec =>l_listheader_rec);
7224: -----------------------------------------------------------------------------
7225:

Line 7846: l_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;

7842: x_return_status OUT NOCOPY VARCHAR2,
7843: x_msg_count OUT NOCOPY NUMBER,
7844: x_msg_data OUT NOCOPY VARCHAR2,
7845: x_list_header_id OUT NOCOPY NUMBER ) is
7846: l_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;
7847: l_init_msg_list varchar2(2000) := FND_API.G_FALSE;
7848: l_api_version number := 1.0;
7849: l_api_name constant varchar2(30) := 'Create_List';
7850: l_list_query_rec AMS_List_Query_PVT.list_query_rec_type ;

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

7908: -- Initialize API return status to success
7909: x_return_status := FND_API.G_RET_STS_SUCCESS;
7910: -- Perform the database operation
7911:
7912: -- ams_listheader_pvt.init_listheader_rec(l_list_header_rec);
7913: l_list_header_rec.list_name := p_list_name;
7914: l_list_header_rec.list_type := p_list_type;
7915: l_list_header_rec.owner_user_id := p_owner_user_id;
7916: l_list_header_rec.list_source_type := p_master_type ;

Line 7920: AMS_ListHeader_PVT.Create_Listheader

7916: l_list_header_rec.list_source_type := p_master_type ;
7917: if l_list_header_rec.view_application_id is null then
7918: l_list_header_rec.view_application_id := 530;
7919: end if;
7920: AMS_ListHeader_PVT.Create_Listheader
7921: ( p_api_version => 1.0,
7922: p_init_msg_list => l_init_msg_list,
7923: p_commit => p_commit,
7924: p_validation_level => p_validation_level ,

Line 8067: l_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;

8063: x_msg_count OUT NOCOPY NUMBER,
8064: x_msg_data OUT NOCOPY VARCHAR2,
8065: x_list_header_id OUT NOCOPY NUMBER ,
8066: p_list_name in VARCHAR2 ) is
8067: l_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;
8068: l_init_msg_list varchar2(2000) := FND_API.G_FALSE;
8069: l_api_version number := 1.0;
8070: l_api_name constant varchar2(30) := 'Create_import_List';
8071: l_action_rec AMS_ListAction_PVT.action_rec_type ;

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

8127: -- Initialize API return status to success
8128: x_return_status := FND_API.G_RET_STS_SUCCESS;
8129: -- Perform the database operation
8130:
8131: -- ams_listheader_pvt.init_listheader_rec(l_list_header_rec);
8132: l_list_header_rec.list_name := l_import_list_name ;
8133: l_list_header_rec.list_type := 'STANDARD';
8134: l_list_header_rec.list_source_type := l_source_type;
8135: l_list_header_rec.owner_user_id := p_owner_user_id;

Line 8139: AMS_ListHeader_PVT.Create_Listheader

8135: l_list_header_rec.owner_user_id := p_owner_user_id;
8136: l_list_header_rec.view_application_id := 530;
8137: -- l_list_header_rec.purpose_code := 'GENERAL';
8138:
8139: AMS_ListHeader_PVT.Create_Listheader
8140: ( p_api_version => 1.0,
8141: p_init_msg_list => l_init_msg_list,
8142: p_commit => p_commit,
8143: p_validation_level => p_validation_level ,

Line 8273: l_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;

8269: x_return_status OUT NOCOPY VARCHAR2,
8270: x_msg_count OUT NOCOPY NUMBER,
8271: x_msg_data OUT NOCOPY VARCHAR2
8272: ) is
8273: l_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;
8274: l_init_msg_list varchar2(2000) := FND_API.G_FALSE;
8275: l_api_version number := 1.0;
8276: l_api_name constant varchar2(30) := 'Create_List';
8277: l_list_query_rec_tbl AMS_List_Query_PVT.list_query_rec_type_tbl ;

Line 8452: l_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;

8448: x_return_status OUT NOCOPY VARCHAR2,
8449: x_msg_count OUT NOCOPY NUMBER,
8450: x_msg_data OUT NOCOPY VARCHAR2
8451: ) is
8452: l_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;
8453: l_init_msg_list varchar2(2000) := FND_API.G_FALSE;
8454: l_api_version number := 1.0;
8455: l_api_name constant varchar2(30) := 'Create_List';
8456: l_list_query_rec_tbl AMS_List_Query_PVT.list_query_rec_type_tbl ;

Line 9411: l_listheader_rec ams_listheader_pvt.list_header_rec_type;

9407: l_no_of_duplicates NUMBER := 0;
9408:
9409: -- Two records are required for init rec and complete rec
9410: -- Table ams_list_headers_all_tl and ams_list_headers_all
9411: l_listheader_rec ams_listheader_pvt.list_header_rec_type;
9412: l_tmp_listheader_rec ams_listheader_pvt.list_header_rec_type;
9413:
9414: -- Two records are required for init rec and complete rec
9415: -- Table ams_list_select_actions

Line 9412: l_tmp_listheader_rec ams_listheader_pvt.list_header_rec_type;

9408:
9409: -- Two records are required for init rec and complete rec
9410: -- Table ams_list_headers_all_tl and ams_list_headers_all
9411: l_listheader_rec ams_listheader_pvt.list_header_rec_type;
9412: l_tmp_listheader_rec ams_listheader_pvt.list_header_rec_type;
9413:
9414: -- Two records are required for init rec and complete rec
9415: -- Table ams_list_select_actions
9416: l_listaction_rec ams_listaction_pvt.action_rec_type;

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

9788: -----------------------------------------------------------------------------
9789: -- Gets list header record details
9790: -- Intialize the record, set the list header id and retrieve the records
9791: -----------------------------------------------------------------------------
9792: write_to_act_log(p_msg_data => 'Calling ams_listheader_pvt to get the header details.' ,
9793: p_arc_log_used_by => 'LIST',
9794: p_log_used_by_id => p_list_header_id,
9795: p_level => 'LOW');
9796:

Line 9797: ams_listheader_pvt.init_listheader_rec(l_tmp_listheader_rec);

9793: p_arc_log_used_by => 'LIST',
9794: p_log_used_by_id => p_list_header_id,
9795: p_level => 'LOW');
9796:
9797: ams_listheader_pvt.init_listheader_rec(l_tmp_listheader_rec);
9798: l_tmp_listheader_rec.list_header_id := p_list_header_id;
9799:
9800: l_error_position := '<- complete rec ->';
9801: ams_listheader_pvt.complete_listheader_rec

Line 9801: ams_listheader_pvt.complete_listheader_rec

9797: ams_listheader_pvt.init_listheader_rec(l_tmp_listheader_rec);
9798: l_tmp_listheader_rec.list_header_id := p_list_header_id;
9799:
9800: l_error_position := '<- complete rec ->';
9801: ams_listheader_pvt.complete_listheader_rec
9802: (p_listheader_rec =>l_tmp_listheader_rec,
9803: x_complete_rec =>l_listheader_rec);
9804: -----------------------------------------------------------------------------
9805: