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 3973: ams_listaction_pvt.init_action_rec(l_tmp_action_rec);

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

Line 3975: ams_listaction_pvt.complete_action_rec

3971: -- details
3972: -------------------------------------------------------------------------
3973: ams_listaction_pvt.init_action_rec(l_tmp_action_rec);
3974: l_tmp_action_rec.list_select_action_id := l_list_select_action_id;
3975: ams_listaction_pvt.complete_action_rec
3976: (p_action_rec => l_tmp_action_rec,
3977: x_complete_rec => p_action_rec);
3978: -------------------------------------------------------------------------
3979: 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 3994: ams_listaction_pvt.Validate_ListAction

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

Line 6835: l_listaction_rec ams_listaction_pvt.action_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;
6836: l_tmp_listaction_rec ams_listaction_pvt.action_rec_type;
6837: l_no_of_rows_in_list number ;
6838: cursor c_get_rows (c_list_header_id in number ) is
6839: select no_of_rows_in_list

Line 6836: l_tmp_listaction_rec ams_listaction_pvt.action_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;
6836: l_tmp_listaction_rec ams_listaction_pvt.action_rec_type;
6837: l_no_of_rows_in_list number ;
6838: cursor c_get_rows (c_list_header_id in number ) is
6839: select no_of_rows_in_list
6840: from ams_list_headers_all

Line 7940: l_action_rec AMS_ListAction_PVT.action_rec_type ;

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 ;
7939: l_list_query_id number ;
7940: l_action_rec AMS_ListAction_PVT.action_rec_type ;
7941: l_action_id number;
7942: cursor c_mapping_types(p_master_type varchar2) is
7943: SELECT list_source_type_id
7944: FROM ams_list_src_types a

Line 8053: AMS_ListAction_PVT.Create_ListAction

8049: l_action_rec.list_action_type := 'INCLUDE';
8050: l_action_rec.arc_incl_object_from := 'SQL';
8051: l_action_rec.incl_object_id := l_list_query_id;
8052: l_action_rec.rank := 1;
8053: AMS_ListAction_PVT.Create_ListAction
8054: ( p_api_version => 1.0,
8055: p_init_msg_list => l_init_msg_list,
8056: p_commit => p_commit,
8057: p_validation_level => p_validation_level,

Line 8159: l_action_rec AMS_ListAction_PVT.action_rec_type ;

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 ;
8160: l_action_id number;
8161: l_import_list_name varchar2(200);
8162: cursor c_chk_name is
8163: select 'x'

Line 8250: AMS_ListAction_PVT.Create_ListAction

8246: l_action_rec.list_action_type := 'INCLUDE';
8247: l_action_rec.arc_incl_object_from := 'IMPH';
8248: l_action_rec.incl_object_id := p_imp_list_header_id ;
8249: l_action_rec.rank := 1;
8250: AMS_ListAction_PVT.Create_ListAction
8251: ( p_api_version => 1.0,
8252: p_init_msg_list => l_init_msg_list,
8253: p_commit => p_commit,
8254: p_validation_level => p_validation_level,

Line 8367: l_action_rec AMS_ListAction_PVT.action_rec_type ;

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 ;
8366: l_list_query_id number ;
8367: l_action_rec AMS_ListAction_PVT.action_rec_type ;
8368: l_action_id number;
8369:
8370: l_master_type_id number;
8371: l_source_type_code varchar2(30);

Line 8430: AMS_ListAction_PVT.Create_ListAction

8426: l_action_rec.arc_incl_object_from := 'SQL';
8427: l_action_rec.incl_object_id := l_list_query_id;
8428: l_action_rec.rank := 1;
8429: l_action_rec.order_number := 1 ;
8430: AMS_ListAction_PVT.Create_ListAction
8431: ( p_api_version => 1.0,
8432: p_init_msg_list => l_init_msg_list,
8433: p_commit => p_commit,
8434: p_validation_level => p_validation_level,

Line 8546: l_action_rec AMS_ListAction_PVT.action_rec_type ;

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 ;
8545: l_list_query_id number ;
8546: l_action_rec AMS_ListAction_PVT.action_rec_type ;
8547: l_action_id number;
8548:
8549: l_master_type_id number;
8550: l_source_type_code varchar2(30);

Line 8611: AMS_ListAction_PVT.Create_ListAction

8607: l_action_rec.arc_incl_object_from := 'SQL';
8608: l_action_rec.incl_object_id := l_list_query_id;
8609: l_action_rec.rank := 1;
8610: l_action_rec.order_number := 1 ;
8611: AMS_ListAction_PVT.Create_ListAction
8612: ( p_api_version => 1.0,
8613: p_init_msg_list => l_init_msg_list,
8614: p_commit => p_commit,
8615: p_validation_level => p_validation_level,

Line 8713: l_tmp_action_rec ams_listaction_pvt.action_rec_type;

8709: x_msg_count OUT NOCOPY NUMBER,
8710: x_msg_data OUT NOCOPY VARCHAR2) IS
8711:
8712: -- AMS_LIST_SELECT_ACTIONS Record for init record and complete record
8713: l_tmp_action_rec ams_listaction_pvt.action_rec_type;
8714: p_action_rec ams_listaction_pvt.action_rec_type;
8715: l_list_select_action_id number;
8716:
8717: ----------------------------------------------------------------------------

Line 8714: p_action_rec ams_listaction_pvt.action_rec_type;

8710: x_msg_data OUT NOCOPY VARCHAR2) IS
8711:
8712: -- AMS_LIST_SELECT_ACTIONS Record for init record and complete record
8713: l_tmp_action_rec ams_listaction_pvt.action_rec_type;
8714: p_action_rec ams_listaction_pvt.action_rec_type;
8715: l_list_select_action_id number;
8716:
8717: ----------------------------------------------------------------------------
8718: -- Cursor definition to select list_select_action_id.Will be used in loop to

Line 9517: l_listaction_rec ams_listaction_pvt.action_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;
9518: l_tmp_listaction_rec ams_listaction_pvt.action_rec_type;
9519: l_no_of_rows_in_list number ;
9520: cursor c_get_rows (c_list_header_id in number ) is
9521: select no_of_rows_in_list

Line 9518: l_tmp_listaction_rec ams_listaction_pvt.action_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;
9518: l_tmp_listaction_rec ams_listaction_pvt.action_rec_type;
9519: l_no_of_rows_in_list number ;
9520: cursor c_get_rows (c_list_header_id in number ) is
9521: select no_of_rows_in_list
9522: from ams_list_headers_all

Line 11937: l_tmp_action_rec ams_listaction_pvt.action_rec_type;

11933: Retcode OUT NOCOPY VARCHAR2,
11934: p_action_used_by_id in number ) IS
11935:
11936: -- AMS_LIST_SELECT_ACTIONS Record for init record and complete record
11937: l_tmp_action_rec ams_listaction_pvt.action_rec_type;
11938: p_action_rec ams_listaction_pvt.action_rec_type;
11939: l_list_select_action_id number;
11940: l_running_total number := 0;
11941: p_action_used_by varchar2(30) := 'LIST';

Line 11938: p_action_rec ams_listaction_pvt.action_rec_type;

11934: p_action_used_by_id in number ) IS
11935:
11936: -- AMS_LIST_SELECT_ACTIONS Record for init record and complete record
11937: l_tmp_action_rec ams_listaction_pvt.action_rec_type;
11938: p_action_rec ams_listaction_pvt.action_rec_type;
11939: l_list_select_action_id number;
11940: l_running_total number := 0;
11941: p_action_used_by varchar2(30) := 'LIST';
11942: p_log_flag varchar2(1) := 'Y';

Line 12031: ams_listaction_pvt.init_action_rec(l_tmp_action_rec);

12027: -- Gets list select actions record details
12028: -- Intialize the record, set the list_select_action_id and get the
12029: -- details
12030: -------------------------------------------------------------------------
12031: ams_listaction_pvt.init_action_rec(l_tmp_action_rec);
12032: l_tmp_action_rec.list_select_action_id := l_list_select_action_id;
12033: ams_listaction_pvt.complete_action_rec
12034: (p_action_rec =>l_tmp_action_rec,
12035: x_complete_rec =>p_action_rec);

Line 12033: ams_listaction_pvt.complete_action_rec

12029: -- details
12030: -------------------------------------------------------------------------
12031: ams_listaction_pvt.init_action_rec(l_tmp_action_rec);
12032: l_tmp_action_rec.list_select_action_id := l_list_select_action_id;
12033: ams_listaction_pvt.complete_action_rec
12034: (p_action_rec =>l_tmp_action_rec,
12035: x_complete_rec =>p_action_rec);
12036:
12037: ----------------------------------------------------------------------

Line 12051: ams_listaction_pvt.Validate_ListAction

12047: END IF; -- End of if for list_action_type check
12048: END IF; --End of Validation:- First Action Include Check
12049:
12050:
12051: ams_listaction_pvt.Validate_ListAction
12052: ( p_api_version => 1.0,
12053: p_init_msg_list => FND_API.G_FALSE,
12054: p_validation_level => JTF_PLSQL_API.G_VALID_LEVEL_RECORD,
12055: x_return_status => x_return_status,