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_LISTACTION_PVT

Line 3800: l_tmp_action_rec ams_listaction_pvt.action_rec_type;

3796: x_msg_count OUT NOCOPY NUMBER,
3797: x_msg_data OUT NOCOPY VARCHAR2) IS
3798:
3799: -- AMS_LIST_SELECT_ACTIONS Record for init record and complete record
3800: l_tmp_action_rec ams_listaction_pvt.action_rec_type;
3801: p_action_rec ams_listaction_pvt.action_rec_type;
3802: l_list_select_action_id number;
3803: l_return_status VARCHAR2(100) := FND_API.G_FALSE;
3804:

Line 3801: p_action_rec ams_listaction_pvt.action_rec_type;

3797: x_msg_data OUT NOCOPY VARCHAR2) IS
3798:
3799: -- AMS_LIST_SELECT_ACTIONS Record for init record and complete record
3800: l_tmp_action_rec ams_listaction_pvt.action_rec_type;
3801: p_action_rec ams_listaction_pvt.action_rec_type;
3802: l_list_select_action_id number;
3803: l_return_status VARCHAR2(100) := FND_API.G_FALSE;
3804:
3805: ----------------------------------------------------------------------------

Line 3972: ams_listaction_pvt.init_action_rec(l_tmp_action_rec);

3968: -- Gets list select actions record details
3969: -- Intialize the record, set the list_select_action_id and get the
3970: -- details
3971: -------------------------------------------------------------------------
3972: ams_listaction_pvt.init_action_rec(l_tmp_action_rec);
3973: l_tmp_action_rec.list_select_action_id := l_list_select_action_id;
3974: ams_listaction_pvt.complete_action_rec
3975: (p_action_rec => l_tmp_action_rec,
3976: x_complete_rec => p_action_rec);

Line 3974: ams_listaction_pvt.complete_action_rec

3970: -- details
3971: -------------------------------------------------------------------------
3972: ams_listaction_pvt.init_action_rec(l_tmp_action_rec);
3973: l_tmp_action_rec.list_select_action_id := l_list_select_action_id;
3974: ams_listaction_pvt.complete_action_rec
3975: (p_action_rec => l_tmp_action_rec,
3976: x_complete_rec => p_action_rec);
3977: -------------------------------------------------------------------------
3978: write_to_act_log('Included object is of type '||p_action_rec.arc_incl_object_from||' , action type is '||p_action_rec.list_action_type||' , included object_id is '||to_char(p_action_rec.incl_object_id),'LIST',g_list_header_id,'LOW');

Line 3993: ams_listaction_pvt.Validate_ListAction

3989: END IF; -- End of if for list_action_type check
3990: END IF; --End of Validation:- First Action Include Check
3991:
3992: write_to_act_log('Calling validate_listaction procedure to validate the list selection attributes','LIST',g_list_header_id, 'LOW');
3993: ams_listaction_pvt.Validate_ListAction
3994: ( p_api_version => 1.0,
3995: p_init_msg_list => FND_API.G_FALSE,
3996: p_validation_level => JTF_PLSQL_API.G_VALID_LEVEL_RECORD,
3997: x_return_status => x_return_status,

Line 6778: l_listaction_rec ams_listaction_pvt.action_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;
6779: l_tmp_listaction_rec ams_listaction_pvt.action_rec_type;
6780: l_no_of_rows_in_list number ;
6781: cursor c_get_rows (c_list_header_id in number ) is
6782: select no_of_rows_in_list

Line 6779: l_tmp_listaction_rec ams_listaction_pvt.action_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;
6779: l_tmp_listaction_rec ams_listaction_pvt.action_rec_type;
6780: l_no_of_rows_in_list number ;
6781: cursor c_get_rows (c_list_header_id in number ) is
6782: select no_of_rows_in_list
6783: from ams_list_headers_all

Line 7852: l_action_rec AMS_ListAction_PVT.action_rec_type ;

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 ;
7851: l_list_query_id number ;
7852: l_action_rec AMS_ListAction_PVT.action_rec_type ;
7853: l_action_id number;
7854: cursor c_mapping_types(p_master_type varchar2) is
7855: SELECT list_source_type_id
7856: FROM ams_list_src_types a

Line 7965: AMS_ListAction_PVT.Create_ListAction

7961: l_action_rec.list_action_type := 'INCLUDE';
7962: l_action_rec.arc_incl_object_from := 'SQL';
7963: l_action_rec.incl_object_id := l_list_query_id;
7964: l_action_rec.rank := 1;
7965: AMS_ListAction_PVT.Create_ListAction
7966: ( p_api_version => 1.0,
7967: p_init_msg_list => l_init_msg_list,
7968: p_commit => p_commit,
7969: p_validation_level => p_validation_level,

Line 8071: l_action_rec AMS_ListAction_PVT.action_rec_type ;

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 ;
8072: l_action_id number;
8073: l_import_list_name varchar2(200);
8074: cursor c_chk_name is
8075: select 'x'

Line 8162: AMS_ListAction_PVT.Create_ListAction

8158: l_action_rec.list_action_type := 'INCLUDE';
8159: l_action_rec.arc_incl_object_from := 'IMPH';
8160: l_action_rec.incl_object_id := p_imp_list_header_id ;
8161: l_action_rec.rank := 1;
8162: AMS_ListAction_PVT.Create_ListAction
8163: ( p_api_version => 1.0,
8164: p_init_msg_list => l_init_msg_list,
8165: p_commit => p_commit,
8166: p_validation_level => p_validation_level,

Line 8279: l_action_rec AMS_ListAction_PVT.action_rec_type ;

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 ;
8278: l_list_query_id number ;
8279: l_action_rec AMS_ListAction_PVT.action_rec_type ;
8280: l_action_id number;
8281:
8282: l_master_type_id number;
8283: l_source_type_code varchar2(30);

Line 8342: AMS_ListAction_PVT.Create_ListAction

8338: l_action_rec.arc_incl_object_from := 'SQL';
8339: l_action_rec.incl_object_id := l_list_query_id;
8340: l_action_rec.rank := 1;
8341: l_action_rec.order_number := 1 ;
8342: AMS_ListAction_PVT.Create_ListAction
8343: ( p_api_version => 1.0,
8344: p_init_msg_list => l_init_msg_list,
8345: p_commit => p_commit,
8346: p_validation_level => p_validation_level,

Line 8458: l_action_rec AMS_ListAction_PVT.action_rec_type ;

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 ;
8457: l_list_query_id number ;
8458: l_action_rec AMS_ListAction_PVT.action_rec_type ;
8459: l_action_id number;
8460:
8461: l_master_type_id number;
8462: l_source_type_code varchar2(30);

Line 8523: AMS_ListAction_PVT.Create_ListAction

8519: l_action_rec.arc_incl_object_from := 'SQL';
8520: l_action_rec.incl_object_id := l_list_query_id;
8521: l_action_rec.rank := 1;
8522: l_action_rec.order_number := 1 ;
8523: AMS_ListAction_PVT.Create_ListAction
8524: ( p_api_version => 1.0,
8525: p_init_msg_list => l_init_msg_list,
8526: p_commit => p_commit,
8527: p_validation_level => p_validation_level,

Line 8625: l_tmp_action_rec ams_listaction_pvt.action_rec_type;

8621: x_msg_count OUT NOCOPY NUMBER,
8622: x_msg_data OUT NOCOPY VARCHAR2) IS
8623:
8624: -- AMS_LIST_SELECT_ACTIONS Record for init record and complete record
8625: l_tmp_action_rec ams_listaction_pvt.action_rec_type;
8626: p_action_rec ams_listaction_pvt.action_rec_type;
8627: l_list_select_action_id number;
8628:
8629: ----------------------------------------------------------------------------

Line 8626: p_action_rec ams_listaction_pvt.action_rec_type;

8622: x_msg_data OUT NOCOPY VARCHAR2) IS
8623:
8624: -- AMS_LIST_SELECT_ACTIONS Record for init record and complete record
8625: l_tmp_action_rec ams_listaction_pvt.action_rec_type;
8626: p_action_rec ams_listaction_pvt.action_rec_type;
8627: l_list_select_action_id number;
8628:
8629: ----------------------------------------------------------------------------
8630: -- Cursor definition to select list_select_action_id.Will be used in loop to

Line 9416: l_listaction_rec ams_listaction_pvt.action_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;
9417: l_tmp_listaction_rec ams_listaction_pvt.action_rec_type;
9418: l_no_of_rows_in_list number ;
9419: cursor c_get_rows (c_list_header_id in number ) is
9420: select no_of_rows_in_list

Line 9417: l_tmp_listaction_rec ams_listaction_pvt.action_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;
9417: l_tmp_listaction_rec ams_listaction_pvt.action_rec_type;
9418: l_no_of_rows_in_list number ;
9419: cursor c_get_rows (c_list_header_id in number ) is
9420: select no_of_rows_in_list
9421: from ams_list_headers_all

Line 11836: l_tmp_action_rec ams_listaction_pvt.action_rec_type;

11832: Retcode OUT NOCOPY VARCHAR2,
11833: p_action_used_by_id in number ) IS
11834:
11835: -- AMS_LIST_SELECT_ACTIONS Record for init record and complete record
11836: l_tmp_action_rec ams_listaction_pvt.action_rec_type;
11837: p_action_rec ams_listaction_pvt.action_rec_type;
11838: l_list_select_action_id number;
11839: l_running_total number := 0;
11840: p_action_used_by varchar2(30) := 'LIST';

Line 11837: p_action_rec ams_listaction_pvt.action_rec_type;

11833: p_action_used_by_id in number ) IS
11834:
11835: -- AMS_LIST_SELECT_ACTIONS Record for init record and complete record
11836: l_tmp_action_rec ams_listaction_pvt.action_rec_type;
11837: p_action_rec ams_listaction_pvt.action_rec_type;
11838: l_list_select_action_id number;
11839: l_running_total number := 0;
11840: p_action_used_by varchar2(30) := 'LIST';
11841: p_log_flag varchar2(1) := 'Y';

Line 11930: ams_listaction_pvt.init_action_rec(l_tmp_action_rec);

11926: -- Gets list select actions record details
11927: -- Intialize the record, set the list_select_action_id and get the
11928: -- details
11929: -------------------------------------------------------------------------
11930: ams_listaction_pvt.init_action_rec(l_tmp_action_rec);
11931: l_tmp_action_rec.list_select_action_id := l_list_select_action_id;
11932: ams_listaction_pvt.complete_action_rec
11933: (p_action_rec =>l_tmp_action_rec,
11934: x_complete_rec =>p_action_rec);

Line 11932: ams_listaction_pvt.complete_action_rec

11928: -- details
11929: -------------------------------------------------------------------------
11930: ams_listaction_pvt.init_action_rec(l_tmp_action_rec);
11931: l_tmp_action_rec.list_select_action_id := l_list_select_action_id;
11932: ams_listaction_pvt.complete_action_rec
11933: (p_action_rec =>l_tmp_action_rec,
11934: x_complete_rec =>p_action_rec);
11935:
11936: ----------------------------------------------------------------------

Line 11950: ams_listaction_pvt.Validate_ListAction

11946: END IF; -- End of if for list_action_type check
11947: END IF; --End of Validation:- First Action Include Check
11948:
11949:
11950: ams_listaction_pvt.Validate_ListAction
11951: ( p_api_version => 1.0,
11952: p_init_msg_list => FND_API.G_FALSE,
11953: p_validation_level => JTF_PLSQL_API.G_VALID_LEVEL_RECORD,
11954: x_return_status => x_return_status,