DBA Data[Home] [Help]

APPS.ASO_SUP_CAPTURE_DATA_PKG dependencies on JTF_NUMBER_TABLE

Line 205: P_comp_sect_map_id IN JTF_NUMBER_TABLE,

201: P_VERSION_NUMBER IN NUMBER,
202: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
203: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
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,

Line 207: P_response_id IN JTF_NUMBER_TABLE,

203: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
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,

Line 233: l_compSectMapIds JTF_NUMBER_TABLE := p_comp_sect_map_id;

229: lx_msgData VARCHAR2(2000);
230: lx_templateInstanceId NUMBER;
231: l_temp NUMBER :=0;
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;

Line 234: l_responseIds JTF_NUMBER_TABLE := P_response_id ;

230: lx_templateInstanceId NUMBER;
231: l_temp NUMBER :=0;
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';

Line 467: P_comp_sect_map_id IN JTF_NUMBER_TABLE,

463: P_VERSION_NUMBER IN NUMBER,
464: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
465: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
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,

Line 469: P_response_id IN JTF_NUMBER_TABLE,

465: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
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

Line 487: l_compSectMapIds JTF_NUMBER_TABLE := p_comp_sect_map_id;

483: lx_msgCount NUMBER;
484: lx_msgData VARCHAR2(2000);
485: l_templateInstance aso_sup_instance_value.template_instance_id%TYPE :=p_template_instance_id;
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;

Line 488: l_responseIds JTF_NUMBER_TABLE := P_response_id ;

484: lx_msgData VARCHAR2(2000);
485: l_templateInstance aso_sup_instance_value.template_instance_id%TYPE :=p_template_instance_id;
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;