DBA Data[Home] [Help]

APPS.AHL_VWP_VISITS_PVT dependencies on AHL_PRD_PRINT_PVT

Line 1485: l_visit_rec.jc_exist := AHL_PRD_PRINT_PVT.Generated_JobCard_Exists('VST',c_visit_rec.visit_id);

1481: END IF;
1482:
1483: -- SKPATHAK :: 19-MAY-2010 :: Enigma Job Card Changes :: START
1484: IF FND_PROFILE.VALUE('AHL_ENIGMA_3C_URL') IS NOT NULL THEN
1485: l_visit_rec.jc_exist := AHL_PRD_PRINT_PVT.Generated_JobCard_Exists('VST',c_visit_rec.visit_id);
1486: l_visit_rec.view_jc_url := AHL_PRD_PRINT_PVT.Get_JC_File_Location('VST',c_visit_rec.visit_id);
1487: l_visit_rec.jc_gen_status := AHL_PRD_PRINT_PVT.Get_Latest_JCG_Status('VST',c_visit_rec.visit_id);
1488: l_visit_rec.jc_gen_error_text := AHL_PRD_PRINT_PVT.Get_JCG_Error_Msg('VST',c_visit_rec.visit_id);
1489:

Line 1486: l_visit_rec.view_jc_url := AHL_PRD_PRINT_PVT.Get_JC_File_Location('VST',c_visit_rec.visit_id);

1482:
1483: -- SKPATHAK :: 19-MAY-2010 :: Enigma Job Card Changes :: START
1484: IF FND_PROFILE.VALUE('AHL_ENIGMA_3C_URL') IS NOT NULL THEN
1485: l_visit_rec.jc_exist := AHL_PRD_PRINT_PVT.Generated_JobCard_Exists('VST',c_visit_rec.visit_id);
1486: l_visit_rec.view_jc_url := AHL_PRD_PRINT_PVT.Get_JC_File_Location('VST',c_visit_rec.visit_id);
1487: l_visit_rec.jc_gen_status := AHL_PRD_PRINT_PVT.Get_Latest_JCG_Status('VST',c_visit_rec.visit_id);
1488: l_visit_rec.jc_gen_error_text := AHL_PRD_PRINT_PVT.Get_JCG_Error_Msg('VST',c_visit_rec.visit_id);
1489:
1490: IF LENGTH(l_visit_rec.jc_gen_error_text) > 500 THEN

Line 1487: l_visit_rec.jc_gen_status := AHL_PRD_PRINT_PVT.Get_Latest_JCG_Status('VST',c_visit_rec.visit_id);

1483: -- SKPATHAK :: 19-MAY-2010 :: Enigma Job Card Changes :: START
1484: IF FND_PROFILE.VALUE('AHL_ENIGMA_3C_URL') IS NOT NULL THEN
1485: l_visit_rec.jc_exist := AHL_PRD_PRINT_PVT.Generated_JobCard_Exists('VST',c_visit_rec.visit_id);
1486: l_visit_rec.view_jc_url := AHL_PRD_PRINT_PVT.Get_JC_File_Location('VST',c_visit_rec.visit_id);
1487: l_visit_rec.jc_gen_status := AHL_PRD_PRINT_PVT.Get_Latest_JCG_Status('VST',c_visit_rec.visit_id);
1488: l_visit_rec.jc_gen_error_text := AHL_PRD_PRINT_PVT.Get_JCG_Error_Msg('VST',c_visit_rec.visit_id);
1489:
1490: IF LENGTH(l_visit_rec.jc_gen_error_text) > 500 THEN
1491: l_visit_rec.jc_gen_error_text := SUBSTR(l_visit_rec.jc_gen_error_text, 1, 500) || '...';

Line 1488: l_visit_rec.jc_gen_error_text := AHL_PRD_PRINT_PVT.Get_JCG_Error_Msg('VST',c_visit_rec.visit_id);

1484: IF FND_PROFILE.VALUE('AHL_ENIGMA_3C_URL') IS NOT NULL THEN
1485: l_visit_rec.jc_exist := AHL_PRD_PRINT_PVT.Generated_JobCard_Exists('VST',c_visit_rec.visit_id);
1486: l_visit_rec.view_jc_url := AHL_PRD_PRINT_PVT.Get_JC_File_Location('VST',c_visit_rec.visit_id);
1487: l_visit_rec.jc_gen_status := AHL_PRD_PRINT_PVT.Get_Latest_JCG_Status('VST',c_visit_rec.visit_id);
1488: l_visit_rec.jc_gen_error_text := AHL_PRD_PRINT_PVT.Get_JCG_Error_Msg('VST',c_visit_rec.visit_id);
1489:
1490: IF LENGTH(l_visit_rec.jc_gen_error_text) > 500 THEN
1491: l_visit_rec.jc_gen_error_text := SUBSTR(l_visit_rec.jc_gen_error_text, 1, 500) || '...';
1492: END IF;