DBA Data[Home] [Help]

APPS.PV_OPPORTUNITY_VHUK dependencies on JTF_VARCHAR2_TABLE_100

Line 212: p_user_name_tbl IN JTF_VARCHAR2_TABLE_100,

208: p_api_version_number IN NUMBER,
209: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
210: p_commit IN VARCHAR2 := FND_API.G_FALSE,
211: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
212: p_user_name_tbl IN JTF_VARCHAR2_TABLE_100,
213: p_user_type_tbl IN JTF_VARCHAR2_TABLE_100,
214: p_username IN VARCHAR2,
215: p_opp_amt IN VARCHAR2,
216: p_opp_name IN VARCHAR2,

Line 213: p_user_type_tbl IN JTF_VARCHAR2_TABLE_100,

209: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
210: p_commit IN VARCHAR2 := FND_API.G_FALSE,
211: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
212: p_user_name_tbl IN JTF_VARCHAR2_TABLE_100,
213: p_user_type_tbl IN JTF_VARCHAR2_TABLE_100,
214: p_username IN VARCHAR2,
215: p_opp_amt IN VARCHAR2,
216: p_opp_name IN VARCHAR2,
217: p_customer_name IN VARCHAR2,

Line 1648: l_user_id_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

1644: l_notify_am_flag CHAR(1) := 'N';
1645: l_notify_cm_flag CHAR(1) := 'N';
1646: l_notify_others_flag CHAR(1) := 'N';
1647:
1648: l_user_id_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1649: l_user_name_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1650: l_resource_id_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1651: l_user_type_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1652:

Line 1649: l_user_name_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

1645: l_notify_cm_flag CHAR(1) := 'N';
1646: l_notify_others_flag CHAR(1) := 'N';
1647:
1648: l_user_id_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1649: l_user_name_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1650: l_resource_id_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1651: l_user_type_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1652:
1653: count_row NUMBER := 1;

Line 1650: l_resource_id_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

1646: l_notify_others_flag CHAR(1) := 'N';
1647:
1648: l_user_id_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1649: l_user_name_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1650: l_resource_id_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1651: l_user_type_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1652:
1653: count_row NUMBER := 1;
1654:

Line 1651: l_user_type_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

1647:
1648: l_user_id_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1649: l_user_name_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1650: l_resource_id_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1651: l_user_type_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1652:
1653: count_row NUMBER := 1;
1654:
1655: l_user_type VARCHAR2(20);