APPS.AMS_ADI_CTD_PVT dependencies on JTF_NUMBER_TABLE

Line 42: p_used_by_id_list JTF_NUMBER_TABLE,

38: p_adhoc_param_val2 varchar2 default null,
39: p_adhoc_param_val3 varchar2 default null,
40: p_adhoc_param_val4 varchar2 default null,
41: p_adhoc_param_val5 varchar2 default null,
42: p_used_by_id_list JTF_NUMBER_TABLE,
43: p_schedule_id number,
44: p_activity_id number,
45: p_schedule_src_code varchar2,
46: x_ctd_id_list OUT nocopy jtf_number_table,

Line 46: x_ctd_id_list OUT nocopy jtf_number_table,

42: p_used_by_id_list JTF_NUMBER_TABLE,
43: p_schedule_id number,
44: p_activity_id number,
45: p_schedule_src_code varchar2,
46: x_ctd_id_list OUT nocopy jtf_number_table,
47: x_msg_count number,
48: x_msg_data varchar2,
49: x_return_status out nocopy varchar2,
50: p_activity_product_id NUMBER

Line 58: l_act_param_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

54: l_ctd_rec AMS_CTD_PVT.ctd_rec_type;
55: l_ctd_param_val AMS_Ctd_Prm_Val_PVT.ctd_prm_val_rec_type;
56: l_adhoc_param AMS_Adhoc_Param_PVT.adhoc_param_rec_type;
57: l_act_param_code_list JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
58: l_act_param_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
59:
60: l_forward_url varchar2(2000);
61: l_track_url varchar2(2000);
62: l_return_status varchar2(30);

Line 66: l_ctd_id_list jtf_number_table := JTF_NUMBER_TABLE(1);

62: l_return_status varchar2(30);
63: l_msg_count number;
64: l_msg_data varchar2(4000);
65: l_ctd_id number;
66: l_ctd_id_list jtf_number_table := JTF_NUMBER_TABLE(1);
67: l_tracking_url varchar2(2000);
68: l_forwarding_url varchar2(2000);
69: l_used_by_id number;
70: l_act_param_val_id number;

Line 77: x_ctd_id_list := JTF_NUMBER_TABLE();

73: l_used_by_type varchar2(30);
74:
75: BEGIN
76: x_return_status := FND_API.G_RET_STS_SUCCESS;
77: x_ctd_id_list := JTF_NUMBER_TABLE();
78:
79:
80: AMS_CTD_UTIL_PKG.GET_FORWARDING_URL(
81: p_action_id => p_action_id,