DBA Data[Home] [Help]

APPS.ASO_SUP_CAPTURE_DATA_PKG dependencies on JTF_VARCHAR2_TABLE_100

Line 208: P_mult_ans_flag IN JTF_VARCHAR2_TABLE_100,

204: P_Template_id IN NUMBER := FND_API.G_MISS_NUM,
205: P_comp_sect_map_id IN JTF_NUMBER_TABLE,
206: P_response_value IN JTF_VARCHAR2_TABLE_2000,
207: P_response_id IN JTF_NUMBER_TABLE,
208: P_mult_ans_flag IN JTF_VARCHAR2_TABLE_100,
209: P_owner_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: P_owner_table_id IN NUMBER := FND_API.G_MISS_NUM,
211: X_template_instance_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
212: X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 236: l_multAnsFlags JTF_VARCHAR2_TABLE_100 := P_mult_ans_flag;

232:
233: l_compSectMapIds JTF_NUMBER_TABLE := p_comp_sect_map_id;
234: l_responseIds JTF_NUMBER_TABLE := P_response_id ;
235: l_responseValues JTF_VARCHAR2_TABLE_2000 :=P_response_value;
236: l_multAnsFlags JTF_VARCHAR2_TABLE_100 := P_mult_ans_flag;
237: l_api_version NUMBER := 1.0;
238: l_api_name VARCHAR2(50) := 'create_template_instance';
239:
240: -- hyang: for bug 2710767

Line 470: P_mult_ans_flag IN JTF_VARCHAR2_TABLE_100,

466: P_Template_instance_id IN NUMBER := FND_API.G_MISS_NUM,
467: P_comp_sect_map_id IN JTF_NUMBER_TABLE,
468: P_response_value IN JTF_VARCHAR2_TABLE_2000,
469: P_response_id IN JTF_NUMBER_TABLE,
470: P_mult_ans_flag IN JTF_VARCHAR2_TABLE_100,
471: X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
472: X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,
473: X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2) IS
474:

Line 490: l_multAnsFlags JTF_VARCHAR2_TABLE_100 := P_mult_ans_flag;

486:
487: l_compSectMapIds JTF_NUMBER_TABLE := p_comp_sect_map_id;
488: l_responseIds JTF_NUMBER_TABLE := P_response_id ;
489: l_responseValues JTF_VARCHAR2_TABLE_2000 :=P_response_value;
490: l_multAnsFlags JTF_VARCHAR2_TABLE_100 := P_mult_ans_flag;
491: l_temp NUMBER :=0;
492: l_api_version NUMBER := 1.0;
493: l_api_name VARCHAR2(50) := 'update_instance_value';
494: