APPS.ASO_FFM_INT dependencies on JTF_FM_REQUEST_GRP

Line 30: l_bind_var_tbl JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

26: IS
27: l_api_name CONSTANT VARCHAR2(30) := 'Submit_FFM_Request';
28: l_api_version_number CONSTANT NUMBER := 1.0;
29:
30: l_bind_var_tbl JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
31: l_bind_val_tbl JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
32: l_bind_var_type_tbl JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
33: l_index NUMBER;
34: l_content_xml VARCHAR2(2000) := '';

Line 31: l_bind_val_tbl JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

27: l_api_name CONSTANT VARCHAR2(30) := 'Submit_FFM_Request';
28: l_api_version_number CONSTANT NUMBER := 1.0;
29:
30: l_bind_var_tbl JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
31: l_bind_val_tbl JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
32: l_bind_var_type_tbl JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
33: l_index NUMBER;
34: l_content_xml VARCHAR2(2000) := '';
35: l_tmp_content_xml VARCHAR2(2000);

Line 32: l_bind_var_type_tbl JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

28: l_api_version_number CONSTANT NUMBER := 1.0;
29:
30: l_bind_var_tbl JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
31: l_bind_val_tbl JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
32: l_bind_var_type_tbl JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
33: l_index NUMBER;
34: l_content_xml VARCHAR2(2000) := '';
35: l_tmp_content_xml VARCHAR2(2000);
36: BEGIN

Line 50: JTF_FM_REQUEST_GRP.Start_Request(

46:
47: -- Initialize API return status to SUCCESS
48: x_return_status := FND_API.G_RET_STS_SUCCESS;
49:
50: JTF_FM_REQUEST_GRP.Start_Request(
51: p_api_version => 1.0,
52: p_init_msg_list => FND_API.G_FALSE,
53: p_commit => FND_API.G_FALSE,
54: X_Return_Status => x_Return_Status,

Line 64: l_bind_var_tbl := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;

60: RAISE FND_API.G_EXC_ERROR;
61: END IF;
62:
63: FOR i IN 1..p_ffm_content_tbl.count LOOP
64: l_bind_var_tbl := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;
65: l_bind_val_tbl := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;
66: l_bind_var_type_tbl := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;
67: l_index := 1;
68: FOR j IN 1..p_bind_tbl.count LOOP

Line 65: l_bind_val_tbl := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;

61: END IF;
62:
63: FOR i IN 1..p_ffm_content_tbl.count LOOP
64: l_bind_var_tbl := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;
65: l_bind_val_tbl := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;
66: l_bind_var_type_tbl := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;
67: l_index := 1;
68: FOR j IN 1..p_bind_tbl.count LOOP
69: IF p_bind_tbl(j).content_index = i THEN

Line 66: l_bind_var_type_tbl := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;

62:
63: FOR i IN 1..p_ffm_content_tbl.count LOOP
64: l_bind_var_tbl := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;
65: l_bind_val_tbl := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;
66: l_bind_var_type_tbl := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;
67: l_index := 1;
68: FOR j IN 1..p_bind_tbl.count LOOP
69: IF p_bind_tbl(j).content_index = i THEN
70: l_bind_var_tbl(l_index) := p_bind_tbl(j).bind_var;

Line 76: JTF_FM_REQUEST_GRP.Get_Content_XML(

72: l_bind_var_type_tbl(l_index) := p_bind_tbl(j).bind_var_type;
73: l_index := l_index+1;
74: END IF;
75: END LOOP;
76: JTF_FM_REQUEST_GRP.Get_Content_XML(
77: p_api_version => 1.0,
78: p_init_msg_list => FND_API.G_FALSE,
79: p_commit => FND_API.G_FALSE,
80: p_validation_level => p_validation_level,

Line 113: JTF_FM_REQUEST_GRP.Submit_Request(

109: RAISE FND_API.G_EXC_ERROR;
110: END IF;
111: l_content_xml := l_content_xml||l_tmp_content_xml;
112: END LOOP;
113: JTF_FM_REQUEST_GRP.Submit_Request(
114: p_api_version => 1.0,
115: p_init_msg_list => FND_API.G_FALSE,
116: p_commit => FND_API.G_FALSE,
117: p_validation_level => p_validation_level,