DBA Data[Home] [Help]

APPS.GMA_EDITEXT_ATTACH_MIG dependencies on FND_ATTACHMENT_BLK_ENTITIES

Line 229: from fnd_attachment_blk_entities

225: in(SELECT attachment_function_id
226: from fnd_attachment_blocks
227: WHERE attachment_blk_id
228: in(SELECT attachment_Blk_id
229: from fnd_attachment_blk_entities
230: WHERE data_object_code
231: in(SELECT data_object_code
232: from fnd_document_entities
233: WHERE UPPER(table_name) in(p_table_name)

Line 400: l_pk1_field fnd_attachment_blk_entities.pk1_field%type;

396: p_pk4_value OUT NOCOPY VARCHAR2 ,
397: p_pk5_value OUT NOCOPY VARCHAR2
398: )
399: Is
400: l_pk1_field fnd_attachment_blk_entities.pk1_field%type;
401: l_pk2_field fnd_attachment_blk_entities.pk2_field%type;
402: l_pk3_field fnd_attachment_blk_entities.pk3_field%type;
403: l_pk4_field fnd_attachment_blk_entities.pk4_field%type;
404: l_pk5_field fnd_attachment_blk_entities.pk5_field%type;

Line 401: l_pk2_field fnd_attachment_blk_entities.pk2_field%type;

397: p_pk5_value OUT NOCOPY VARCHAR2
398: )
399: Is
400: l_pk1_field fnd_attachment_blk_entities.pk1_field%type;
401: l_pk2_field fnd_attachment_blk_entities.pk2_field%type;
402: l_pk3_field fnd_attachment_blk_entities.pk3_field%type;
403: l_pk4_field fnd_attachment_blk_entities.pk4_field%type;
404: l_pk5_field fnd_attachment_blk_entities.pk5_field%type;
405:

Line 402: l_pk3_field fnd_attachment_blk_entities.pk3_field%type;

398: )
399: Is
400: l_pk1_field fnd_attachment_blk_entities.pk1_field%type;
401: l_pk2_field fnd_attachment_blk_entities.pk2_field%type;
402: l_pk3_field fnd_attachment_blk_entities.pk3_field%type;
403: l_pk4_field fnd_attachment_blk_entities.pk4_field%type;
404: l_pk5_field fnd_attachment_blk_entities.pk5_field%type;
405:
406: l_api_name CONSTANT VARCHAR2(30) := 'Get_Fnd_Attachment_Blk_PK' ;

Line 403: l_pk4_field fnd_attachment_blk_entities.pk4_field%type;

399: Is
400: l_pk1_field fnd_attachment_blk_entities.pk1_field%type;
401: l_pk2_field fnd_attachment_blk_entities.pk2_field%type;
402: l_pk3_field fnd_attachment_blk_entities.pk3_field%type;
403: l_pk4_field fnd_attachment_blk_entities.pk4_field%type;
404: l_pk5_field fnd_attachment_blk_entities.pk5_field%type;
405:
406: l_api_name CONSTANT VARCHAR2(30) := 'Get_Fnd_Attachment_Blk_PK' ;
407: l_api_version CONSTANT NUMBER := 1.0 ;

Line 404: l_pk5_field fnd_attachment_blk_entities.pk5_field%type;

400: l_pk1_field fnd_attachment_blk_entities.pk1_field%type;
401: l_pk2_field fnd_attachment_blk_entities.pk2_field%type;
402: l_pk3_field fnd_attachment_blk_entities.pk3_field%type;
403: l_pk4_field fnd_attachment_blk_entities.pk4_field%type;
404: l_pk5_field fnd_attachment_blk_entities.pk5_field%type;
405:
406: l_api_name CONSTANT VARCHAR2(30) := 'Get_Fnd_Attachment_Blk_PK' ;
407: l_api_version CONSTANT NUMBER := 1.0 ;
408: l_progress VARCHAR2(3) := '000';

Line 423: from fnd_attachment_blk_entities

419: p_pk2_value,
420: p_pk3_value,
421: p_pk4_value,
422: p_pk5_value
423: from fnd_attachment_blk_entities
424: where data_object_code=p_table_name
425: and attachment_blk_id=
426: (SELECT attachment_blk_id
427: FROM fnd_attachment_blocks