APPS.JTF_FM_REQUEST_GRP dependencies on JTF_FM_REQUEST_CONTENTS

Line 648: Procedure to INSERT JTF_FM_REQUEST_CONTENTS table.

644:
645: END CHECK_AND_INSERT_QUERY;
646:
647: /**
648: Procedure to INSERT JTF_FM_REQUEST_CONTENTS table.
649: */
650:
651: PROCEDURE INSERT_REQ_CONTENTS
652: (

Line 678: FROM JTF_FM_REQUEST_CONTENTS

674: CURSOR CCONT IS
675: SELECT CONTENT_ID, CONTENT_NUMBER,
676: CONTENT_NAME, CONTENT_TYPE, DOCUMENT_TYPE,
677: BODY, USER_NOTES, QUANTITY,MEDIA_TYPE, CONTENT_SOURCE, FND_FILE_ID
678: FROM JTF_FM_REQUEST_CONTENTS
679: where request_id = p_request_id;
680:
681: BEGIN
682: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

Line 696: INSERT INTO JTF_FM_REQUEST_CONTENTS (

692: FETCH CCONT INTO l_content_id,l_content_number,
693: l_content_name,l_content_type,l_document_type,l_body,
694: l_user_notes,l_quantity,l_media_type,l_content_source,l_file_id;
695: EXIT WHEN CCONT%NOTFOUND;
696: INSERT INTO JTF_FM_REQUEST_CONTENTS (
697: REQUEST_ID, CONTENT_ID, CONTENT_NUMBER,
698: CONTENT_NAME, CONTENT_TYPE, DOCUMENT_TYPE,
699: BODY, USER_NOTES, QUANTITY,
700: CREATED_BY, CREATION_DATE,

Line 806: INSERT INTO JTF_FM_REQUEST_CONTENTS (

802:
803: BEGIN
804: JTF_FM_UTL_V.PRINT_MESSAGE('Begin PROCEDURE INSERT_REQUEST_CONTENTS', JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
805:
806: INSERT INTO JTF_FM_REQUEST_CONTENTS (
807: REQUEST_ID,
808: CONTENT_ID,
809: CONTENT_NUMBER,
810: CONTENT_NAME,

Line 867: SELECT CONTENT_NUMBER into l_content_number FROM JTF_FM_REQUEST_CONTENTS

863: IS
864: l_content_number NUMBER;
865:
866: BEGIN
867: SELECT CONTENT_NUMBER into l_content_number FROM JTF_FM_REQUEST_CONTENTS
868: where REQUEST_ID = p_request_id and fnd_file_id = p_file_id;
869:
870: RETURN l_content_number;
871:

Line 3191: -- Do the following to get the correct content_no from JTF_FM_REQUEST_CONTENTS table

3187:
3188: JTF_FM_UTL_V.PRINT_MESSAGE('Procedure to check MES contents',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
3189:
3190: /***
3191: -- Do the following to get the correct content_no from JTF_FM_REQUEST_CONTENTS table
3192:
3193: ***/
3194: select nvl(max(content_number),0) into l_count_total from JTF_FM_REQUEST_CONTENTS where request_id = p_request_id;
3195:

Line 3194: select nvl(max(content_number),0) into l_count_total from JTF_FM_REQUEST_CONTENTS where request_id = p_request_id;

3190: /***
3191: -- Do the following to get the correct content_no from JTF_FM_REQUEST_CONTENTS table
3192:
3193: ***/
3194: select nvl(max(content_number),0) into l_count_total from JTF_FM_REQUEST_CONTENTS where request_id = p_request_id;
3195:
3196:
3197: IF(p_content_type = 'ATTACHMENT') THEN
3198: