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.IEM_EMAILPROC_PVT dependencies on JTF_VARCHAR2_TABLE_100

Line 487: l_delete_class_ids_tbl jtf_varchar2_Table_100:=jtf_varchar2_Table_100();

483:
484: IS
485: l_api_name varchar2(30):='deleteAcctEmailProc';
486: l_api_version_number number:=1.0;
487: l_delete_class_ids_tbl jtf_varchar2_Table_100:=jtf_varchar2_Table_100();
488:
489: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
490: l_msg_count NUMBER := 0;
491: l_msg_data VARCHAR2(2000);

Line 621: p_update_rule_ids_tbl IN jtf_varchar2_Table_100,

617: p_all_email IN VARCHAR2:= null,
618: p_rule_type IN VARCHAR2:= null,
619:
620: --below is the data for update
621: p_update_rule_ids_tbl IN jtf_varchar2_Table_100,
622: p_update_rule_keys_tbl IN jtf_varchar2_Table_100,
623: p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
624: p_update_rule_values_tbl IN jtf_varchar2_Table_300,
625: --below is the data for insert

Line 622: p_update_rule_keys_tbl IN jtf_varchar2_Table_100,

618: p_rule_type IN VARCHAR2:= null,
619:
620: --below is the data for update
621: p_update_rule_ids_tbl IN jtf_varchar2_Table_100,
622: p_update_rule_keys_tbl IN jtf_varchar2_Table_100,
623: p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
624: p_update_rule_values_tbl IN jtf_varchar2_Table_300,
625: --below is the data for insert
626: p_new_rule_keys_tbl IN jtf_varchar2_Table_100,

Line 623: p_update_rule_operators_tbl IN jtf_varchar2_Table_100,

619:
620: --below is the data for update
621: p_update_rule_ids_tbl IN jtf_varchar2_Table_100,
622: p_update_rule_keys_tbl IN jtf_varchar2_Table_100,
623: p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
624: p_update_rule_values_tbl IN jtf_varchar2_Table_300,
625: --below is the data for insert
626: p_new_rule_keys_tbl IN jtf_varchar2_Table_100,
627: p_new_rule_operators_tbl IN jtf_varchar2_Table_100,

Line 626: p_new_rule_keys_tbl IN jtf_varchar2_Table_100,

622: p_update_rule_keys_tbl IN jtf_varchar2_Table_100,
623: p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
624: p_update_rule_values_tbl IN jtf_varchar2_Table_300,
625: --below is the data for insert
626: p_new_rule_keys_tbl IN jtf_varchar2_Table_100,
627: p_new_rule_operators_tbl IN jtf_varchar2_Table_100,
628: p_new_rule_values_tbl IN jtf_varchar2_Table_300,
629: --below is the data to be removed
630: p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,

Line 627: p_new_rule_operators_tbl IN jtf_varchar2_Table_100,

623: p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
624: p_update_rule_values_tbl IN jtf_varchar2_Table_300,
625: --below is the data for insert
626: p_new_rule_keys_tbl IN jtf_varchar2_Table_100,
627: p_new_rule_operators_tbl IN jtf_varchar2_Table_100,
628: p_new_rule_values_tbl IN jtf_varchar2_Table_300,
629: --below is the data to be removed
630: p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,
631: --below is the action and action parameter to be updated

Line 630: p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,

626: p_new_rule_keys_tbl IN jtf_varchar2_Table_100,
627: p_new_rule_operators_tbl IN jtf_varchar2_Table_100,
628: p_new_rule_values_tbl IN jtf_varchar2_Table_300,
629: --below is the data to be removed
630: p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,
631: --below is the action and action parameter to be updated
632: p_action IN VARCHAR2 := null,
633: p_parameter1_tbl IN jtf_varchar2_Table_300,
634: p_parameter2_tbl IN jtf_varchar2_Table_300,

Line 635: p_parameter_tag_tbl IN jtf_varchar2_Table_100,

631: --below is the action and action parameter to be updated
632: p_action IN VARCHAR2 := null,
633: p_parameter1_tbl IN jtf_varchar2_Table_300,
634: p_parameter2_tbl IN jtf_varchar2_Table_300,
635: p_parameter_tag_tbl IN jtf_varchar2_Table_100,
636:
637: x_return_status OUT NOCOPY VARCHAR2,
638: x_msg_count OUT NOCOPY NUMBER,
639: x_msg_data OUT NOCOPY VARCHAR2 )is

Line 1004: p_rule_key_typecode_tbl IN jtf_varchar2_Table_100 ,

1000: p_route_boolean_type_code IN VARCHAR2,
1001: p_rule_type IN VARCHAR2,
1002: p_action IN VARCHAR2,
1003: p_all_email IN VARCHAR2,
1004: p_rule_key_typecode_tbl IN jtf_varchar2_Table_100 ,
1005: p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100,
1006: p_rule_value_tbl IN jtf_varchar2_Table_300,
1007: p_parameter1_tbl IN jtf_varchar2_Table_300,
1008: p_parameter2_tbl IN jtf_varchar2_Table_300,

Line 1005: p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100,

1001: p_rule_type IN VARCHAR2,
1002: p_action IN VARCHAR2,
1003: p_all_email IN VARCHAR2,
1004: p_rule_key_typecode_tbl IN jtf_varchar2_Table_100 ,
1005: p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100,
1006: p_rule_value_tbl IN jtf_varchar2_Table_300,
1007: p_parameter1_tbl IN jtf_varchar2_Table_300,
1008: p_parameter2_tbl IN jtf_varchar2_Table_300,
1009: p_parameter_tag_tbl IN jtf_varchar2_Table_100,

Line 1009: p_parameter_tag_tbl IN jtf_varchar2_Table_100,

1005: p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100,
1006: p_rule_value_tbl IN jtf_varchar2_Table_300,
1007: p_parameter1_tbl IN jtf_varchar2_Table_300,
1008: p_parameter2_tbl IN jtf_varchar2_Table_300,
1009: p_parameter_tag_tbl IN jtf_varchar2_Table_100,
1010: x_return_status OUT NOCOPY VARCHAR2,
1011: x_msg_count OUT NOCOPY NUMBER,
1012: x_msg_data OUT NOCOPY VARCHAR2 ) is
1013:

Line 1452: p_emailproc_ids_tbl IN jtf_varchar2_Table_100,

1448: p_api_version_number IN NUMBER,
1449: p_init_msg_list IN VARCHAR2 := null,
1450: p_commit IN VARCHAR2 := null,
1451: p_email_account_id IN NUMBER,
1452: p_emailproc_ids_tbl IN jtf_varchar2_Table_100,
1453: p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,
1454: p_delete_emailproc_ids_tbl IN jtf_varchar2_Table_100,
1455: p_rule_type IN varchar2,
1456: x_return_status OUT NOCOPY VARCHAR2,

Line 1453: p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,

1449: p_init_msg_list IN VARCHAR2 := null,
1450: p_commit IN VARCHAR2 := null,
1451: p_email_account_id IN NUMBER,
1452: p_emailproc_ids_tbl IN jtf_varchar2_Table_100,
1453: p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,
1454: p_delete_emailproc_ids_tbl IN jtf_varchar2_Table_100,
1455: p_rule_type IN varchar2,
1456: x_return_status OUT NOCOPY VARCHAR2,
1457: x_msg_count OUT NOCOPY NUMBER,

Line 1454: p_delete_emailproc_ids_tbl IN jtf_varchar2_Table_100,

1450: p_commit IN VARCHAR2 := null,
1451: p_email_account_id IN NUMBER,
1452: p_emailproc_ids_tbl IN jtf_varchar2_Table_100,
1453: p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,
1454: p_delete_emailproc_ids_tbl IN jtf_varchar2_Table_100,
1455: p_rule_type IN varchar2,
1456: x_return_status OUT NOCOPY VARCHAR2,
1457: x_msg_count OUT NOCOPY NUMBER,
1458: x_msg_data OUT NOCOPY VARCHAR2