DBA Data[Home] [Help]

APPS.TASK_MGR dependencies on JTF_NOTES_PUB

Line 86: JTF_NOTES_PUB.CREATE_NOTE

82: --DBMS_OUTPUT.PUT_LINE('TASK_ID = ' ||x);
83:
84: --DBMS_OUTPUT.PUT_LINE('Creating a note...');
85:
86: JTF_NOTES_PUB.CREATE_NOTE
87: (
88: p_parent_note_id => NULL,
89: p_api_version => 1,
90: p_init_msg_list => NULL,

Line 478: -- context_tab JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE;

474: l_note_id NUMBER;
475: l_notes VARCHAR2(4000) := '';
476: l_notes_detail VARCHAR2(32000);
477: l_owner_id NUMBER := 0;
478: -- context_tab JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE;
479:
480: BEGIN
481:
482: l_status_id := 8;

Line 530: JTF_NOTES_PUB.UPDATE_NOTE

526:
527:
528: l_notes := COMMENTS;
529:
530: JTF_NOTES_PUB.UPDATE_NOTE
531: ( p_api_version => 1,
532: p_init_msg_list => FND_API.G_FALSE,
533: p_commit => FND_API.G_FALSE,
534: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 616: context_tab JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE;

612: l_return_status VARCHAR2(30);
613: l_note_id NUMBER;
614: l_notes VARCHAR2(4000) := '';
615: l_notes_detail VARCHAR2(32000);
616: context_tab JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE;
617:
618: BEGIN
619:
620: IF( COMPLETION_STATUS = 'ACCEPTED' ) THEN

Line 691: context_tab JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE;

687: l_return_status VARCHAR2(30);
688: p_note_id NUMBER;
689: l_notes VARCHAR2(4000) := '';
690: l_notes_detail VARCHAR2(32000);
691: context_tab JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE;
692:
693: BEGIN
694:
695: OPEN jtf_note_id_cursor;

Line 718: JTF_NOTES_PUB.Update_note

714: context_tab(1).last_updated_by := FND_GLOBAL.USER_ID;
715: context_tab(1).created_by := FND_GLOBAL.USER_ID;
716:
717:
718: JTF_NOTES_PUB.Update_note
719: ( p_api_version => 1,
720: p_init_msg_list => FND_API.G_FALSE,
721: --p_commit => FND_API.G_FALSE,
722: p_validation_level => FND_API.G_VALID_LEVEL_FULL,